Google Sheets Masterclass 2026

Name: Google Sheets Masterclass 2026
Rating: 5.0 (51 reviews)

Master formulas, pivot tables, dashboards, data validation, smart features, and automation in Google Sheets

Highest Rated

Created byInspireEd Solutions

Last updated 1/2026

English

What you'll learn

Master the Google Sheets interface, rows, columns, cells, formatting, and locale settings
Perform calculations and formulas, including IF conditions, nested formulas, and references
Use VLOOKUP exact and approximate match with data from multiple sheets
Apply data validation, dropdown lists, remove duplicates, and conditional formatting
Create Pivot Tables, reports, charts, and interactive dashboards
Use filters, slicers, and smart cleanup for efficient data analysis
Work with Smart Chips, images, checkboxes, and collaboration tools
Automate tasks using Google Sheets macros
Share, protect, and collaborate securely on Google Sheets files

Course content

1 section • 41 lectures • 4h 4m total length

Getting Started and Accessing Google Sheets2:42
Understanding Google Sheets Interface5:35
Important Info1:29
Working on Rows and Columns in Google Sheets4:25
How to Fix Date and Currency Format Using Local1:29
Working With Data in Cells7:47
Resizing Cells Columns and Rows With Formatting7:25
Grouping and Ungrouping2:51
Freezing and Unfreezing Rows and Columns3:41
Merging and Unmerging Cells in Sheets2:30
Protecting Ranges in Google Sheets From Editing3:26
Protecting Entire Sheet Except Certain Cells Permissions in Google Sheets3:24
Adding New Sheet Tabs to Existing Google Sheet3:43
Using Formula Basics - Working with Addition Multiplication and Subtraction (Fre7:54
Generating Random Data In Sheets Using Special4:21
How To Remove Formulas in Google Sheets and Keep Values1:41
Multiplicative and Divisional Calculations in Sheets4:15
Concept of Nested Formulas6:06
Basics of Absolute and Relative Refrences in Google Sheets8:17
Performing Quick Calculations in Sheets2:51
learn to perform quick calculations in google sheets using quick functions to see sums, averages, minima, maxima, and counts by selecting ranges for instant results.
Introduction to IF Conditions5:32
Writing Basic Formulas5:44
Introduction to Conditional Sum Count and Average6:16
Using All Rounding Functions in Sheets8:09
Introduction to Vlookup7:56
Powerful Use of Data Validation for Drop Down List Using Advance Techniques8:13
Remove Duplicates From Data4:07
How To Use VLOOKUP Approximate Match with Data from Another Sheet6:08
All Formatting Techniques in Google Sheets12:24
Conditional Formatting5:55
Adding Images Links Checkboxes and More in Google Sheets9:02
Change Excel Spreadsheet into Google Sheets Format1:53
Share Google Sheets with Anyone Using a Link1:53
Pivot Table Basics in Google Sheets6:42
Creating Multiple Type of Reports With Pivot Table9:44
Learn to create and customize pivot table reports in Google Sheets, including month-wise and quarter-wise sales, year-based grouping, and region-wise contributions.
Creating Charts in Google Sheets14:15
Create Interactive Dashboards in Google Sheets13:34
Create interactive dashboards in Google Sheets to visualize and summarize sales data. Analyze by region and item with charts, scorecards, line charts, and slicers.
Using Slicer to Filter Data2:57
Filtering and Sorting Data in Google Sheets4:52
Overview of Whats Covered So Far17:58
Sharing and Collaborating in Google Sheets5:25
Learn how to share Google Sheets with collaborators, set editors, viewers, or commenters, and manage access via link sharing and on sheet comments.

Requirements

No prior Google Sheets experience required
Basic computer and internet usage skills
A free Google account to access Google Sheets
Willingness to practice with real examples and exercises

Description

This Google Sheets Basic to Advanced Training Course is a complete, hands-on program designed to help you master Google Sheets for data analysis, reporting, automation, and collaboration—from absolute beginner to advanced user.

You’ll start by learning the Google Sheets interface, working with rows, columns, cells, formats, and locale settings for dates and currency. The course builds a strong foundation by covering data entry, resizing, grouping, freezing panes, merging cells, and protecting ranges and sheets with permissions.

As you progress, you’ll dive deep into formulas and calculations, including addition, multiplication, division, nested formulas, absolute and relative references, rounding functions, and logical IF conditions. You’ll also learn conditional SUM, COUNT, and AVERAGE, making your calculations smarter and more dynamic.

This course gives special focus to VLOOKUP, including exact and approximate match scenarios, pulling data from other sheets, and real-world use cases. You’ll also master data validation, advanced dropdown lists, removing duplicates, and powerful formatting techniques.

On the reporting side, you’ll learn Pivot Table basics, create multiple types of reports, build charts, and design interactive dashboards using slicers and filters. You’ll also explore Smart Cleanup, Smart Chips, and collaboration tools to work efficiently in shared environments.

To take your skills further, the course covers macros in Google Sheets to automate workflows, helping you save time and reduce repetitive tasks. You’ll also learn how to share sheets securely, convert Excel files to Google Sheets, and collaborate in real time.

By the end of this course, you’ll be able to confidently use Google Sheets for data management, analysis, reporting, dashboards, and automation—skills that are highly valuable for office jobs, accounting, business analysis, and freelancing.

Who this course is for:

Beginners who want to learn Google Sheets from scratch
Office professionals working with reports, data, and spreadsheets
Accountants, analysts, and business users using Google Sheets daily
Freelancers and virtual assistants handling client data
Students and job seekers looking to improve data analysis skills
Anyone switching from Microsoft Excel to Google Sheets