Start Free Trial
Free Google Sheets Expert Help

Tools to Help You Learn Google Sheets

Free Google Sheets Training and Tools

Try the FREE Google Sheets tools designed to save you time and make your work easier. Use the helper and finder tools below to learn Google Sheets functions and boost your productivity.

Subscribe Below to Access This Google Sheets Class Workbook

Click on the tabs to test out the workbook.

Subscribe and get the FREE Google Sheets Class Training Workbook

This is a full Google Sheets class for FREE, go through the workbook and learn everything Google Sheets can do

Google Sheets Help: The Formula Lookup Tool

Memorizing Google Sheets formulas and functions can be really difficult.

Search through the top 50 Google Sheets functions and see:
• What the formula does
• The complete formula
• Examples of how to use them

Google Sheets Formula Helper

Select a formula to see its explanation and example.

Google Sheets Pro Challenges

Can you write a formula to sum only the odd numbers in this list?
Example list in column A: 2, 5, 8, 11, 14

✅ Answer: =SUM(FILTER(A1:A5, MOD(A1:A5,2)=1))
Google Sheets uses FILTER instead of SUMPRODUCT for this.

How can you highlight the top 3 sales values using Conditional Formatting?
Example list in column B: 4500, 7200, 6100, 8800, 5300

✅ Answer: Use in Conditional Formatting:
=B1>=LARGE($B$1:$B$5,3)
Works the same in Google Sheets.

How can you remove duplicate values while keeping original order?
Example list in column D: Apple, Orange, Apple, Banana, Orange

✅ Answer: =UNIQUE(D1:D5)
Returns only unique values, keeping their first appearance. Works the same in Google Sheets.

Google Sheets Formula Finder

Select a typical request from boss to see how to answer it in Google Sheets.

How to Answer Questions From Boss

Ever been asked for a quick calculation or report in Google Sheets and weren't sure which formula to use?

The Google Sheets Formula Finder shows you the most common boss requests — from combining names, calculating percentages, finding top performers, or pulling data automatically.

For each request, you'll get:
• A plain-English explanation
• The exact Google Sheets formula
• A simple example you can copy instantly

Stop wasting time guessing — this tool gives you the right formula in seconds.

More Google Sheets Pro Challenges

How can you count only cells containing numbers greater than 100?
Example list in column C: 50, 120, 200, 75, 150

✅ Answer: =COUNTIF(C1:C5,">100")
Counts only numbers greater than 100 in the range.

How can you extract the last name from a full name automatically?
Example list in column D: Jane Smith, John Doe, Alice Johnson

✅ Answer: =RIGHT(D1,LEN(D1)-FIND(" ",D1))
Finds the space and returns all characters after it.

How can you calculate the average of only positive numbers?
Example list in column E: -5, 10, 15, -2, 20

✅ Answer: =AVERAGEIF(E1:E5,">0")
Averages only the positive numbers in the range.

Google Sheets Error Lookup Tool

Troubleshooting Google Sheets errors can be tricky.

Select an error from the list to see what it means and how to fix it.

Google Sheets Error Finder

Select an error to see details.
⌨️ Google Sheets Shortcut Study Chart

Use this chart to memorize Google Sheets shortcuts. Click any shortcut to copy it, or copy all at once.
Press Ctrl + / (Windows) or ⌘ + / (Mac) in Google Sheets to view the full list for your setup.

Navigation
Jump to edge of dataCtrl + Arrow
Go to A1Ctrl + Home
Go to last cell with dataCtrl + End
Next sheetCtrl + Page Down
Previous sheetCtrl + Page Up
Open shortcuts helpCtrl + /
Selection
Select columnCtrl + Space
Select rowShift + Space
Select allCtrl + A
Extend selectionShift + Arrow
Select regionCtrl + Shift + Arrow
Select current regionCtrl + Shift + *
Formatting
BoldCtrl + B
ItalicCtrl + I
UnderlineCtrl + U
StrikethroughAlt + Shift + 5
Formulas
Start a formula=
AutoSumAlt + =
Insert dateCtrl + ;
Insert timeCtrl + Shift + ;
Show function helpCtrl + Shift + A
Absolute referenceF4
Editing & Paste
CopyCtrl + C
PasteCtrl + V
CutCtrl + X
UndoCtrl + Z
RedoCtrl + Y
FindCtrl + F
ReplaceCtrl + H
Paste values onlyCtrl + Shift + V

Note: Shortcuts can vary by OS and browser. Press Ctrl + / (Windows) or ⌘ + / (Mac) in Sheets to see the live shortcut list.

Google Sheets Training Material to Level Up Your Team

💪
Google Sheets Cheat Sheet →
💯
12 Must-Know Google Sheets Formulas →
📊
Top 10 Tips for Google Sheets Dashboards →

Google Sheets FAQ

What is Google Sheets? ▶
Google Sheets is a free, web-based spreadsheet program that allows you to create, edit, and share spreadsheets online. It offers many of the same features as Excel, with real-time collaboration.
Who is the free Google Sheets class for? ▶
This free class is perfect for beginners, business owners, and anyone looking to organize and analyze data more effectively using Google Sheets.
What topics does the class cover? ▶
The class covers formulas, functions, formatting, data organization, charts, conditional formatting, and practical tips for efficient spreadsheet management.
Do I need prior experience with spreadsheets? ▶
No prior experience is needed. The free class starts with the basics and guides you step-by-step to more advanced techniques.
Can I use Google Sheets offline? ▶
Yes. Google Sheets can be used offline if you enable offline mode in your Google Drive settings, allowing you to edit and save spreadsheets without an internet connection.
How do I access the free Google Sheets class? ▶
You can access the free class directly on the page. No payment or signup is required.
Keep Learning Spreadsheets

Want to learn Excel & how to create amazing tools?

Enroll

Self-paced learning