Skip to main content
Level 2
google workspace

Advanced Google Sheets

Power up with QUERY, ARRAYFORMULA, pivot tables, Apps Script basics, and advanced data workflows.

Advanced Google Sheets course thumbnail

8 lessons

Video-based curriculum

48 min

Total duration

Level 2

Curriculum placement

Syllabus

  1. 1VLOOKUP and IMPORTRANGE
  2. 2QUERY function deep dive
  3. 3ARRAYFORMULA for bulk operations
  4. 4Pivot tables in Sheets
  5. 5Data validation and protected ranges
  6. 6Connecting Sheets to external data
  7. 7Introduction to Apps Script
  8. 8Building dashboards in Sheets

Ready to start learning?

Sign up for free to access this course and track your progress.

Get Started Free