Spreadsheets have changed. This is how you catch up.
Google Sheets isn’t the same tool it used to be.
In just the past two years, AI has landed in our spreadsheets, tables have transformed how we structure data, and brand-new functions have unlocked possibilities that didn’t exist before.
But here’s the problem: most folks are still following old tutorials, blogs, and courses that teach the old way of working in Sheets.
That’s why I created Modern Google Sheets — a practical, hands-on course designed to bring you fully up to speed on the current best practices. You’ll learn not just the formulas and features, but the modern mindset for working in spreadsheets in the AI era.
Whether you’re analyzing data, building reports, or automating workflows, this course shows you the smartest ways to use Google Sheets today.
This course will teach you:
- How to work smarter not harder, by using Gemini AI inside of Sheets
- How to use Tables in Google Sheets and the many benefits they bring
- Use Gemini to help you overcome the pivot table hurdle
- How to integrate Google Sheets with Google Forms and Google Slides
- To effectively communicate ideas and insights using the Google Sheets chart tool
- And much, much more!
Who this course is for:
- Regular Google Sheets users who know the basics but want to progress
- Individuals looking to understand how Gemini AI fits into their Google Sheets workflows
- People who want to be more effective with spreadsheets
Course Syllabus
- 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)
- 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)