Free Google Sheets Expert Help

Tools to Help You Learn Google Sheets

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.

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

Need a printable reference instead? Grab the Google Sheets formula cheat sheet.

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. Want the full list? Check out our 12 must-know Google Sheets formulas.

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 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.