Skip to content
Write a review
UdemyBestseller on UdemyOffice ProductivityPaid courseAll LevelsCertificate

Google Sheets - The Comprehensive Masterclass (Udemy.com)

Master Google Sheets from essentials to advanced: QUERY function, pivot tables, charts, and automation

4.7
13,297 reviews

Created by: Leila Gharani

Last updated March 2026

Our take

Based on the ratings of 13,297 students, a sample of their written reviews and the syllabus, as the course stood in March 2026. No course pays to be reviewed.

Leila Gharani's course runs 14.3 hours over 134 lectures and 20 sections. The first half covers the essentials: data entry, sorting and cleaning, lookups, charts and pivot tables. The second half goes advanced, with a full section on the QUERY function, plus Apps Script and macros. Every lesson comes with start and solution workbooks. The audience is wide on purpose, from people who have never opened a spreadsheet to Excel users switching over and analysts who want to go deeper.

Teaching gets most of the praise. One reviewer likes that Gharani speaks at a normal pace, clearly, and shows empathy for the student, and another calls it the best course for a beginner. Of 13,297 ratings, 9,490 are five stars and 3,280 are four, with under 100 at one or two stars. The recurring complaint is age. The course dates from 2020, and although it was last updated in March 2026, reviewers say menus have moved and some lessons no longer match. The image and QR code lesson relies on an old Google chart method that has stopped working.

That makes it a solid, practical pick for learning Sheets properly, as long as you don't mind pausing now and then to hunt for a renamed button. With 60,571 students and a Bestseller badge, it is clearly the course many people land on. It is not short, but the lessons are small enough to skip around. Anyone who only needs one trick, like QUERY, can jump straight to that section.

Best forBeginners or Excel users who need Sheets for work and want QUERY, dashboards and Apps Script covered in one place.
Skip it ifYou want a quick crash course, or need every menu and the QR code lesson to match today's Sheets exactly.

Pros

  • Reviewers praise Gharani's clear, normal-paced delivery and say it works well for beginners
  • A full QUERY section of 10 lectures and about an hour, plus lookups, pivot tables and charts
  • Start and solution workbooks plus challenges, so learners practice instead of just watching
  • Starts from zero but reaches Apps Script, macros and live data imports like IMPORTRANGE

Cons

  • Reviewers say some menus and features have moved or been renamed since recording
  • The image and QR code lesson uses a dead Google method, so a reviewer needed another formula
  • At 14.3 hours it is a real time commitment if you only need a few functions
What i like most about Leila is how she speaks at a "normal" pace in a clear and understandable manner. She also shows empathy towards the student.
Victor Morales, a student

Truly starts from zero, while the QUERY and Apps Script sections suit people who already use Sheets often.

icon
What you will 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

Course content

20 sections · 134 lectures · 14 hours of video 5 quizzes, 22 articles

  1. 1Welcome to Your Google Sheets Course 2 free previews3 lectures · 9 min
  2. 2***** GOOGLE SHEETS ESSENTIALS ***** 1 free preview1 lecture · 3 min
  3. 3Getting Started Right with Google Sheets 1 free preview7 lectures · 1 quiz · 42 min
  4. 4Data Entry & Basic Formulas6 lectures · 39 min
  5. 5Best Practice & Useful Features9 lectures · 1 quiz · 1.2 hours
  6. 6Sorting, Filtering and Cleaning Data 1 free preview8 lectures · 47 min
  7. 7Essential Sheets Functions to Analyze & Summarize12 lectures · 1.6 hours
  8. 8Lookup & Filter Functions9 lectures · 52 min
  9. 9Text, Date & Time Functions7 lectures · 1 quiz · 46 min
  10. 10Helpful Google Sheet Functions7 lectures · 45 min

Who it is for

The instructor says it suits

  • Complete beginners who have never used Google Sheets or any spreadsheet tool before
  • Excel users moving to Google Sheets who want to transfer their skills and learn what's different
  • Analysts and reporting professionals who use Google Sheets regularly but want to go deeper into QUERY, pivot tables, and automation
  • Job seekers and students who need solid Google Sheets skills to meet employer requirements or prepare for data roles

What you need before you start

  • A free Google account is all you need to get started. You can create one during the course if you don't have one yet.
  • No prior spreadsheet experience required. The course starts from the basics and builds to advanced.
  • Excel users are welcome. Most concepts and functions covered apply directly to Microsoft Excel as well.

icon
Course Description

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.
Read More All Levels All Levels product length iconTime: 14.3h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Leila Gharani

Leila Gharani, a Microsoft MVP (most valuable professional), has one mission: to make data work for you. With her clear and practical teaching style, she helps professionals master Excel, Google Sheets, and other tools to create impactful reports, automate tasks, and solve real-world problems - quickly and confidently.

Leila knows the challenges of juggling complex data and tight deadlines because she’s been there. With over 15 years of experience in Finance and IT, she’s streamlined systems, tackled tough data problems, and delivered results for global companies.

Her courses are designed with your success in mind. You’ll find step-by-step lessons, relatable examples, and hands-on exercises that make learning simple and fun. Every concept is tied to real-world applications so you can start seeing results immediately.

Through her YouTube channel and courses, Leila has empowered thousands of learners worldwide to improve their skills, impress at work, and achieve their career goals.

If you’re ready to take control of your data, save time, and stand out as a professional, Leila’s courses are here to help you succeed.

Read More

icon
More courses by Leila Gharani

$199.99

$22.99

$19.99

$19.99

$13.99

$15.99

All courses by Leila Gharani

icon
More Office Productivity courses

$19.99

$10.99

$39.99

$64.99

$19.99

$19.99

All Office Productivity courses

icon
Reviews

4.7

13,297 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Rebecca Herron on 8/25/2026

I had trouble removing captions from your video and it was blocking content. It took several google inquiries to finally figure out the buttons to remove it.

By Jason Loffredo on 8/20/2026

It's a great course. Challenging at times, but I'm mostly following along ok. The biggest fault is that the course is now 6 years old, and there's a lot that's changed in Google Sheets since the course was made. Things are in different places or called slightly different things etc. So, every once in a while I have to pause and work out where that feature or function went. Other than that, it's been great. This course should probably get an update soon, though.

By Victor Morales on 7/30/2026

So far, yes. What i like most about Leila is how she speaks at a "normal" pace in a clear and understandable manner. She also shows empathy towards the student.

By Nhatminh on 7/8/2026

I have recently joined a company used google sheet instead of Excel so I decided to seriously dive into this tool, this course helped me much to achieve that threshold!

By Luap Bbor on 5/30/2026

The instructor is great at guiding you through each lesson. This course does seem to be a little dated now because some of the options are not where the instructor say they are (Macros for example), but if you have a look around in the menus, you should be able to find it.

By Blandine Pougom on 3/15/2026

I appreciated the fact that this course was more detailed and very well explained. I learned a lots from this course. It was a wonderful course.

By CHENG-CHEN YANG CHEN on 1/29/2026

Lots of exercises to check if you have understood and everything very well explained. The only course that i have bought, learnt and finished till the end

By Władysław Nowicki on 1/27/2026

The Google Sheets – The Comprehensive Masterclass can definitely be described as “essential knowledge in a nutshell” for anyone who wants to start working with Google Sheets or significantly improve how they use it in everyday work. The course covers the fundamentals in a very practical way and, at the same time, shows how to apply them to real-life scenarios. Thanks to this course, I was able to noticeably streamline several work processes that are based on Google Sheets. Many things that previously took more time or were done manually are now faster, clearer, and better structured. The knowledge is presented in an easy-to-understand way, and the practical exercises and challenges make it much easier to actually learn by doing, not just by watching. One small note: by 2025, the interface and access to some functions in Google Sheets have slightly changed compared to what is shown in the course. However, this doesn’t reduce the overall value of the content. Overall, a very solid and useful course that I can confidently recommend.

By Barbara Camean on 1/15/2026

Very good teacher, she prepared the course very well. I am pleased with the course. I would like more courses from her. I saw she has Excel courses, but right now I am only using Google Sheets, so another technical course from her would be amazing.

By Yash Krishna Shetty on 12/13/2025

The course is very useful for an individual who wants to learn and explore new ways of showcasing his skills in his role in a company.

Showing all 10 reviews on CourseDuck

Read all 13,297 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

Google Sheets - The Comprehensive Masterclass
Visit course on Udemy Write a review
  • Video Duration: icon 14.3h
  • Price: $109.99
  • Provider: icon Udemy
  • Updated: icon March 2026
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
  • Lectures:134 in 20 sections
  • Practice:5 quizzes
  • Students:60,600
  • Subtitles:9 languages
  • Udemy badge:Bestseller
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com