What you'll learn:
- Write QUERY function formulas to filter, aggregate, sort, and combine data across multiple sheets and files
- Build interactive dashboards in Google Sheets using pivot tables, charts, slicers, and sparklines
- Use Google-specific functions including GOOGLEFINANCE, IMPORTHTML, IMPORTXML, and IMPORTRANGE to connect live data
- Apply advanced conditional formatting with formulas and set up dependent dropdown lists
- Look up and retrieve data using VLOOKUP, INDEX MATCH, and the FILTER function
- Clean and transform messy data using sort, filter views, split, trim, and find and replace
- Automate repetitive tasks in Google Sheets using macros and Google Apps Script
- Use array formulas, SEQUENCE, and INDIRECT for advanced data analysis challenges
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.
