OfficeDrillsGoogle Sheets
Practice real Google Sheets workflows — writing IF, AND, and COUNTIF formulas, sharing with the right permissions, choosing between a Filter and a private Filter view, setting up data validation, and choosing between restricting or warning on a protected range — in a hands-on training simulation.
Educational practice environment — not affiliated with, endorsed by, or sponsored by Google.
Options
Lesson 1 is free in every option. You'll enter your email first — no password. $20 unlocks the rest of Beginner or Advanced · Crash Course is $10.
Start here
Beginner
Every step spelled out, including what each screen and field actually means. For anyone who's never opened Google Sheets before.
Start Beginner — free lesson 1 →
Advanced
The full real-world workflow with less hand-holding. Best if you've used it before or pick up new software fast.
Start Advanced — free lesson 1 →
Crash Course
Four of the Advanced lessons — the highest-value tasks in the same real workflow. Built for brushing up before an interview.
Start Crash Course — $10, free lesson 1 →
What you'll practice
Getting Set Up
- Create a Named Range
- Set Up Conditional Formatting
- Freeze Rows or Columns
- Find and Replace a Value Across the Sheet
- Set Up Email Notifications for Sheet Edits
Formulas
- Flag Overdue Items with IF
- Combine Two Conditions with AND
- Count Overdue Items with COUNTIF
Sharing
- Share with the Right Permission
- Decide the Right Sharing Setting
Views & Validation
- Choose a Filter or a Private Filter View
- Set Up Data Validation
Protection
- Protect a Range
- Decide Between Restricting and Warning
Drills & Projects
Drill
Out of Sync →
Six real spreadsheet tasks, on an actual sheet — a stale IMPORTRANGE, a real-time edit collision, a stale sharing link, and more.
🔒 Included with Google Sheets
Drill
Half a Setting →
Six real Google Sheets tasks, on an actual shared sheet — a viewer who can still copy the data, a warning that isn't a barrier, an alert set up for one person, an AND that should have been OR, and more.
🔒 Included with Google Sheets
Drill
Looks Right, Reads Wrong →
Six Google Sheets jobs where the sheet looks right and computes wrong: a total that ignores a filter, amounts stored as text, a highlight rule on the wrong rows, a stale pivot table, a lookup that guesses, and a count that cannot read checkboxes.
🔒 Included with Google Sheets