2015
Mach 42 Productions / Udemy
0:32
English
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.
If you want to know how to use common Excel string functions then take this course.
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 explains the Excel string function and gives examples. Excel is one of the most popular tools used today in businesses. Knowing how to use functions in it is necessary.
I look forward to seeing you on the other side.
Section 1: Introduction to this course
1 Introduction to Excel course
2 Udemy course completion certificate for LinkedIn - Text
3 Leaving a review - Text
Section 2: Text functions commonly used in Excel part 1
4 Getting the length of a string
5 Strings of length quiz 2 question(s)
6 Finding text within a string
7 Finding text quiz 2 question(s)
Section 3: Text functions commonly used in Excel part 2
8 Extracting text from a string
9 Extracting text quiz 2 question(s)
10 Getting rid of excess spaces
11 Trimming text quiz 2 question(s)
12 Joining text from different Excel cells
13 Joining text quiz 2 question(s)
Section 4: Wrap up section
14 Wrap-up lecture
Download File Size:89.86 MB