Google Sheets practice that does not let you fake it
Most Google Sheets tutorials show you a formula, let you copy it into a sample file and call that practice. A week later you still cannot write a FILTER with two conditions from scratch. Sheetsdrill was built around one rule: the only way through an exercise is a working formula.
Every drill runs your formula twice. First against the data on screen, then against a version of the same sheet with different values. A formula that types in the answer, or that only works by luck on the visible rows, fails the second run and you are told why. That is exactly what breaks in shared spreadsheets, where someone else changes the data after you leave.
Practice Google Sheets online, with no Google account needed
Each exercise runs on a small spreadsheet in your browser that follows Google Sheets rules for the functions it uses, including arrays that flow from FILTER, SORT or SPLIT into the next function, and the Sheets error values such as #N/A and #VALUE!. You write the formula exactly as you would in Sheets, press Enter, and get an answer with an explanation.
That makes it useful where opening a real spreadsheet is awkward: between meetings, on a train, or in the ten minutes before a skills test. Progress is saved in your browser, and a free account keeps it across devices.
Google Sheets exercises built in five levels
The 50 exercises are organized into levels of ten, and each level only introduces one or two new ideas on top of what you already know.
- Basics: total ad spend, average order value, one rate for every row, over budget with IF, share of total sales, month-over-month growth.
- Conditional counting and summing: open high-priority tickets, sales for one rep and month, orders between two dates, customer tiers with IFS, region names with SWITCH.
- Lookups: find the price, look left with XLOOKUP, a friendly Not found, zero instead of #N/A, shipping rate by weight band, the latest status in a log.
- Arrays and FILTER: sum a filtered list, two conditions in FILTER, distinct customers, top three deals with SORTN, revenue with ARRAYFORMULA, totals and counts with QUERY.
- Text and dates: first name with SPLIT, join the confirmed names, valid order IDs with REGEXMATCH, pull out the invoice number, full years of service, working days with holidays.
Within a level the drills get harder one notch at a time. By the end of Arrays and FILTER you have written a FILTER with two conditions, a SORTN for the top three and a QUERY with group by, not because you read about them, but because the exercise would not pass until you did.
Open the exercise list
QUERY function practice and FILTER function practice
Two functions separate people who use Google Sheets from people who are good at it, and they are where most learners stall, so each gets a run of exercises that build on each other.
- FILTER practice: one condition, two conditions at once, FILTER feeding SUM, FILTER with UNIQUE for distinct customers, FILTER with SORT for the best seller.
- QUERY practice: select with sum and count, where with comparisons and dates, group by for a total per region, order by with limit for the top region.
- Arrays: SORTN for top N with ties, ARRAYFORMULA for a whole column of revenue, and SPLIT output flowing into the next function.
Learn Google Sheets formulas for work, not trivia
The data in every drill looks like something you would meet at work: ad spend by channel, a ticket log with priorities, deals with reps and months, an inventory with weight bands, a contact list with email domains. The questions are the ones a manager sends in a chat message: how much did we spend, which tickets are still open, who are our distinct customers this month.
You will not be asked to compute anything you would never need. The goal is that the next time someone shares a sheet and a question, you already know which function to reach for.
Learn Google Sheets by getting it wrong first
A hint is one click away, but the worked solution opens only after your second attempt. That is on purpose. Writing a formula, seeing #N/A, reading the hint and fixing it yourself is the part that sticks. Copying a solution before you have tried does not.
Every exercise also explains why the reference formula is built the way it is: why the range is locked with dollar signs, why IFNA wraps the lookup, why QUERY wants the column letter in the where clause. Read it after you pass, and the pattern is yours.
Google Sheets test practice for interviews and skills checks
Operations, marketing, sales ops and analyst roles increasingly test spreadsheet skills before hiring, and many of those teams live in Google Sheets rather than Excel. The questions are rarely exotic: a SUMIFS, a lookup with a missing value handled, a date difference, a filtered list.
Sheetsdrill's drills are the same shape as those questions, and timed mode puts a clock on the screen with hints and solutions locked until time is up, so you get used to writing under pressure.
Try a timed drill
Why hands-on beats watching
You can watch a ten-minute video on QUERY and feel like you understand it. Then you open a sheet, type =QUERY( and stop. The gap between recognizing and producing is the whole problem, and the only thing that closes it is reps.
A Sheetsdrill session is five to fifteen minutes of writing formulas, each one slightly different from the last. Ten sessions in, the function names, the argument order and the array habits are automatic.
Google Sheets exercises for beginners and for daily users
If you know what a cell reference is, you can start. The Basics level begins with SUM and does not assume anything else. If you already use Sheets every day, skip to Lookups, Arrays and FILTER or Text and dates and look for the gaps: most experienced users have one or two functions they have always copied from a forum, and the drills find them quickly.
Every exercise is independent, so you can jump to the one you need for today's problem and come back to the rest later.
Sheetsdrill