Google Sheets tutorials for everyday work

Free guides for everyday spreadsheet work

Get more done in Google Sheets.

Clear how-tos, tested formulas and keyboard shortcuts for the work in front of you. No fluff, just the steps.

Popular:FILTER XLOOKUP Dropdowns Shortcuts

Team directory

fx=FILTER(A2:C6, B2:B6="Sales")

ABC1NameTeamRegion2MayaSalesLondon3JordanDesignAustin4AlexSalesToronto5SamFinanceBoston6PriyaSalesMumbai

Sheet13 matching rows

✓

Just the rows you needOne formula, no manual sorting

Start here

Browse by topic

How-Tos

Step-by-step walkthroughs for everyday spreadsheet tasks.

Functions

Syntax, tested examples and common errors for each formula.

Shortcuts

Keyboard shortcuts for Windows, Mac and ChromeOS.

Apps Script

Automate repetitive work with small, readable scripts.

Fresh on GeoSheets

Latest articles

How to Create Dropdown Lists in Google SheetsSeptember 16, 2026
Highlight the Highest and Lowest Values in Google SheetsSeptember 16, 2026
Apply Conditional Formatting Across Sheets in Google SheetsSeptember 16, 2026
Highlight Overdue Dates in Google SheetsSeptember 16, 2026

Function library

Every guide includes the syntax, a tested example and the mistakes to avoid.

See all functions

FILTERReturn only the rows that match XLOOKUPFind a value in any direction VLOOKUPLook up a value in a table QUERYSummarize data with SQL-like syntax COUNTIFCount cells that meet a condition SUMIFAdd up values that match UNIQUERemove duplicate entries IFReturn one value or another

Most popular articles

Apps ScriptApps Script not working? Fix it step by step ShortcutFill color shortcut in Google Sheets ShortcutInsert a row with a keyboard shortcut ShortcutSwitch between tabs with the keyboard ShortcutDelete a row with a keyboard shortcut How-ToRemove gridlines in Google Sheets

Stuck on something specific?

Search every article, function guide and shortcut on GeoSheets.