Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Data Cleaning and Analysis Skills in Excel
Data cleaning and analysis using TEXT functions in Excel
Pre-Assessment Quiz by Rakesh Sud
Lecture 1: What will we learn in this module? (4:39)
Lecture 2: Download the excel template for this module (0:34)
Lecture 3: Illustration 1: Introduction (1:44)
Lecture 4: Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions (15:04)
Lecture 5: Illustration 2: Understanding the TRIM and FIND function (8:35)
Lecture 6: Illustration 2: Understanding the LEFT and MID function (12:28)
Lecture 7: Illustration 3: Introduction (1:44)
Lecture 8: Illustration 3: Understanding the SEARCH function (6:26)
Lecture 9: Illustration 3: Understanding the IFERROR function (3:33)
Lecture 10: Illustration 3: Understanding the IF function (3:32)
Lecture 11: Recap: what did we learn in this module? (0:52)
Lecture 12: Practice Assignment #1: DIFFICULTY LEVEL - MEDIUM
Lecture 13: Solution to Practice Assignment #1
Lecture 14: Please provide us your valuable feedback on the course thus far
Lecture 12: Practice Assignment #1: DIFFICULTY LEVEL - MEDIUM
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock