English | MP4 | 1152x720 | 63 kbps | 44 KHz | 1 hours | 92 Mb
Excel 2016 tutorial on Excel text functions
Want to know how and when to use common Excel string functions?
Then take this course. This bite size course will show you how to use Excel string functions that are frequently used to perform operations on strings for everyday tasks such as cleaning data.
You will learn how to extract text from strings, how to search within strings, how to replace characters in strings and much more.
Each lecture presents the concept and gives examples. Excel is one of the most popular tools used today in businesses. Knowing how to use functions in it is necessary.
Thank you for taking the time to read this and I look forward to seeing you on the other side.
What are the requirements?
Need to have Excel 2013 or Excel 2016
This course assumes the student has a working knowledge of Excel
What am I going to get from this course?
Over 7 lectures and 32 mins of content!
Understand how to use common string functions in Excel
Understand how coMbining string functions can be used to clean Excel data
Students will gain the foundations to go and apply these functions to their own Excel work
What is the target audience?
Beginners to intermediate users of Excel
Analysts, particularly those on the data side who regularly clean data and need a refresher
(Buy premium account for maximum speed and resumming ability)