Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Text and Data Cleaning: Learn Excel 365
Text and Data Cleaning
Course Introduction (1:30)
DOWNLOAD ME: Course Files
Using the LOWER, UPPER, and PROPER Functions (2:49)
Using the MID, LEN, LEFT, and RIGHT Functions (9:01)
Using the VALUE Function to Convert Text to a Number (1:22)
Using the TRIM function to Remove Extra Spaces (0:48)
Using the SUBSTITUTE Function to Replace Text (1:42)
Using the Spell Checker and Translate Features (1:53)
Using the Advanced Autofill Series Options (5:03)
Course Conclusion (1:16)
Course Quiz and Certificate of Completion
Course Quiz
Using the MID, LEN, LEFT, and RIGHT Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock