Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Cleaning and Pivot Tables in Google Sheets
Introduction
Lesson 1: Introduction to the Course (2:20)
Lesson 2: About the Instructor (3:25)
Lesson 3: How this Course is structured (1:50)
Join the Facebook group
Data Cleaning
Lesson 4: Introduction to Data Cleaning and Best Practices (5:12)
Lesson 5: Data Types (8:01)
Lesson 6: Handy Shortcuts for Data Tables (3:58)
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)
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)
Pivot Tables
Lesson 22: Introduction to Pivot Tables (5:41)
Lesson 23: Pivot Table Fundamentals (11:09)
Lesson 24: Pivot Table Fundamentals II (7:29)
Lesson 25: Preparing Data for Pivot Tables (10:09)
Lesson 26: Advanced Pivot Table Features (Filters, Dates and Calculated Fields) (10:12)
Lesson 27: Show As Percentage (5:38)
Lesson 28: Pivot Table Options (5:32)
Lesson 29: Other uses for Pivot Tables (8:58)
Lesson 30: Getting data out of Pivot Tables the right way (7:57)
Data Cleaning & Pivot Tables Course Case Studies
Lesson 31: Case Study 1 Part I (18:09)
Lesson 32: Case Study 1 Part II (6:19)
Lesson 33: Case Study 2 Part I (13:38)
Lesson 34: Case Study 2 Part II (14:16)
Lesson 35: Case Study 2 Part III (6:23)
Join the Facebook group
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock