Google Sheets - The Comprehensive Masterclass

Google Sheets is where modern spreadsheet work happens. This course takes you from basics to advanced in one complete path.

Whether you're new to Google Sheets or coming from Excel, this masterclass covers everything you need to work confidently with data: essential functions, data analysis, lookup formulas, the QUERY function, pivot tables, charts, automation with macros, and Google-specific features you won't find in any other spreadsheet tool.

By the end you'll be the person on your team who knows how to solve data problems quickly and build reports people actually use.

What you'll be able to do after this course:

• Navigate, format, and manage large Google Sheets files efficiently

• Clean and transform data using sort, filter, split, trim, and find and replace

• Use essential functions: SUM, SUMIFS, COUNTIFS, IF, IFS, and AVERAGEIFS

• Look up data with VLOOKUP, INDEX MATCH, FILTER, and SORTN

• Write QUERY function formulas to create any analysis you need, including aggregations, pivot columns, and dynamic filters

• Pull live data into your spreadsheets with GOOGLEFINANCE, IMPORTHTML, IMPORTXML, and IMPORTRANGE

• Build interactive dashboards with pivot tables, charts, slicers, and sparklines

• Set up dependent dropdown lists, advanced conditional formatting, and data validation with formulas

• Automate repetitive tasks with macros and Google Apps Script

• Apply array formulas, SEQUENCE, INDIRECT, and INDEX MATCH for advanced data challenges

Why this course covers ground others don't:

Most Google Sheets courses skip the QUERY function or treat it as a footnote. This course dedicates a full section to it, covering syntax, aggregations, dynamic cell references, date handling, and combining data across files with IMPORTRANGE. Once you know QUERY, you can replace dozens of complex formula combinations with a single line.

The course also covers Google-specific features that have no Excel equivalent: live stock and currency data with GOOGLEFINANCE, web scraping with IMPORTHTML and IMPORTXML, language detection and translation, and QR code generation. These are practical tools that can change how you work.

What's inside:

• 20 sections from essentials to advanced

• Challenges and find-the-mistake exercises in every section

• Practice workbooks with start files and solution files for every lesson

• Pre-assessment quiz to identify your weak spots before you begin

• Quizzes throughout to test your understanding as you go

• Full section on Google Apps Script and macros for automation

Who this works for:

Complete beginners and Excel users moving to Google Sheets are both well served by the Essentials sections. If you already know the basics, skip straight to Advanced Data Analysis, the QUERY function, or Apps Script.

Note: Most concepts taught in this course also apply directly to Microsoft Excel.

Taught by Leila Gharani, Microsoft MVP and trusted by 515,000+ students on Udemy.

Enroll now and start with the pre-assessment quiz to see exactly where to begin.