Google Sheets Tutorials That Actually Make Sense
Learn VLOOKUP, QUERY, pivot tables, and more with step-by-step guides designed for real spreadsheet problems.
Popular Tutorials
Start with these foundational guides to build your Google Sheets expertise.
VLOOKUP in Google Sheets
Master the most popular lookup function. Learn how to search for values across your spreadsheet with practical examples.
IF Statements & Logic
Build powerful conditional formulas. Learn IF, IFS, AND, OR, and nested logic to automate your spreadsheet decisions.
QUERY Function Deep Dive
Use SQL-like queries in Google Sheets. Filter, sort, and aggregate data with the most powerful function available.
Conditional Formatting
Make your data visual. Automatically highlight cells, create heat maps, and build dynamic formatting rules.
Data Validation
Control what data enters your spreadsheet. Create dropdowns, set rules, and prevent data entry errors.
INDEX MATCH
The flexible alternative to VLOOKUP. Learn why pros prefer INDEX MATCH and how to use it effectively.
Reading about formulas is not the same as writing them
Basic Training is a free course that lives inside a Google Sheet. 7 short lessons, 19 exercises, about 40 minutes. You type every formula yourself and the Sheet grades each one the moment you press Enter.
- ✅ Instant feedback, not a quiz at the end
- ✅ A hint on every exercise, if you want it
- ✅ Your own copy, yours to keep
Get your free copy
We email you a link that makes your own copy of the course Sheet.
✅ You're in.
Taking you to your copy of Basic Training now. If nothing happens in a few seconds, the link is in your inbox too.
Instant access, no confirmation step. No spam, ever.
Prefer to read first? See what is inside Basic Training.
Browse by Topic
Find exactly what you need organized by category.
Lookup Functions
Logic & Conditions
Data Visualization
Data Management
Text Functions
Dates & Time
Why Learn With Us
Step-by-Step Guides
Every tutorial walks you through with screenshots and clear explanations. No confusing jargon.
Real Examples
Practice with actual spreadsheet scenarios, not abstract theory. Copy formulas directly into your work.
Free Tutorials
Every tutorial on this site is free to read. No paywalls, no sign-up required.