Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Cleaning in Google Sheets
Introduction
Lesson 1: Introduction to the Course (1:01)
Lesson 2: Join the Facebook group
Lesson 3: Introduction to Data Cleaning and Best Practices (5:12)
Data Cleaning
Lesson 4: Data Types (8:01)
Lesson 5: Handy Shortcuts for Data Tables (3:58)
Lesson 6: Shortcut key reference
Lesson 7: Find and Replace (7:19)
Lesson 8: Trim, Clean and Dealing with Spaces (1:58)
Lesson 9: Lower, Upper and Proper functions to deal with Case (2:35)
Lesson 10: Searching within data strings (5:08)
Lesson 11: Extracting data with Left, Right and Mid functions (11:26)
Lesson 12: Changing data with Substitute and Replace formulas (8:53)
Lesson 13: Splitting Data with Text to Columns (3:23)
Lesson 14: Bringing Data Together (4:42)
Lesson 15: Sorting and Filtering Data (8:59)
Advanced Data Cleaning Techniques
Lesson 16: Dealing with Null Values (9:09)
Lesson 17: Duplicates (7:07)
Lesson 18: Duplicates Formula Method (15:40)
Lesson 19: Using the IF function and logic to clean data (14:27)
Lesson 20: Using VLOOKUP to clean data (7:55)
Lesson 21: Spelling Tools and Transposing Data (5:32)
Data Cleaning Case Studies
Lesson 22: Case Study 1 Part I (18:09)
Lesson 23: Case Study 1 Part II (6:19)
Lesson 24: Case Study 2 Part I (13:38)
Lesson 25: Case Study 2 Part II (14:16)
Lesson 26: Case Study 2 Part III (6:23)
Lesson 13: Splitting Data with Text to Columns
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock