Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Modern Google Sheets
Introduction
1. Course Introduction (3:21)
2. Course Structure / Templates (2:39)
3. How to get Gemini AI in Google Sheets
Tables
4. Introduction to Tables (6:42)
5. Working with Data in Tables (8:12)
6. Structured Table References (16:35)
7. Smart Chips in Tables (10:50)
8. Data Cleanup with Tables: Part 1 (13:02)
9. Data Cleanup with Tables: Part 2 (17:37)
10. Data Cleanup with Tables: Part 3 (5:57)
11. Data Cleanup with Tables: Part 4 (15:14)
12. Data Cleanup with Tables: Part 5 (13:46)
Modern Formulas
13. Creating Formulas with Gemini (12:53)
14. AI Function (13:48)
15. Data Wrangling Functions (11:17)
16. XLOOKUP Function (15:00)
17. IMPORTRANGE to Link Google Sheet Files (13:05)
18. LET Function (11:29)
19. LAMBDA Functions (18:14)
20. Named Functions (10:55)
21. Advanced Function Example (11:17)
A Small Ask From Me
Will you leave a testimonial?
Working with Data
22. Data Basics & Structure (16:37)
23. Data Analysis with Gemini (17:24)
24. Pivot Table Fundamentals (14:20)
25. Pivot Table Advanced Features (12:26)
26. QUERY Function (18:25)
Visual Sheets
27. Conditional Formatting (16:35)
28. Creating an Info Sheet (12:04)
29. Data Visualization 101 (9:37)
30. Mastering the Google Sheets Chart tool (15:39)
31. Combo Chart Example (11:58)
32. Advanced Chart Tutorial (16:17)
AI Case Study
33. Collecting Data with a Google Form (9:05)
34. AI Analysis of Google Form Data (10:52)
35. Forms → Sheets → Slides Workflow (5:47)
36. Conditional Notifications (14:17)
37. Automation with Apps Script (13:43)
9. Data Cleanup with Tables: Part 2
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock