Google Sheets
Google Sheets practice, graded in a live sheet
Learn the formulas by writing them: FILTER, QUERY, ARRAYFORMULA, XLOOKUP, SPLIT and the REGEX functions, in a sheet that follows Google Sheets rules and checks your answer the moment you press Check.
Try one: FILTER with two conditions
Sheets modeF2, use FILTER to list every Open order worth more than 1000. Return all four columns of A2:D9, and give each condition its own argument.The course
Each lesson starts with a short walkthrough on sample data, then gives you a fresh sheet to solve. Your answers are re-checked on changed data, so a formula has to really work.
Sheets essentials
FreeFormulas, conditional totals, lookups, and FILTER and SORT the Google Sheets way.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 1 | Formulas in Google Sheets | SUM, AVERAGE, COUNTA, IF, B2:B | 8 | 3 | |
| 2 | COUNTIF, SUMIF and the IFS versions | COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF | 10 | 3 | |
| 3 | VLOOKUP and XLOOKUP in Google Sheets | VLOOKUP, XLOOKUP, IFNA, INDEX, MATCH | 10 | 3 | |
| 4 | FILTER and SORT, the Sheets way | FILTER, SORT, IFNA | 12 | 3 |
Sheets power tools
ProUNIQUE, ARRAYFORMULA, SPLIT, regular expressions and QUERY, then a capstone.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 5 | UNIQUE, COUNTUNIQUE and duplicates | UNIQUE, SORT, COUNTUNIQUE, COUNTIF | 9 | 3 | |
| 6 | ARRAYFORMULA: one formula for the whole column | ARRAYFORMULA, IF, { ; } | 10 | 3 | |
| 7 | SPLIT, JOIN and text cleanup | SPLIT, JOIN, TEXTJOIN, TRIM, PROPER, LEFT, RIGHT, LEN | 11 | 3 | |
| 8 | REGEXMATCH, REGEXEXTRACT and REGEXREPLACE | REGEXMATCH, REGEXEXTRACT, REGEXREPLACE, TO_TEXT, FILTER | 12 | 3 | |
| 9 | QUERY basics: select, where, order by | QUERY, select, where, order by, limit | 12 | 3 | |
| 10 | QUERY: group by, totals and labels | QUERY, group by, sum, count, label, Col1 | 12 | 3 | |
| 11 | Capstone: a sales summary in Sheets | ARRAYFORMULA, SORT, UNIQUE, SUMIFS, QUERY, FILTER | 20 | 4 |
Where Google Sheets formulas differ from Excel
Most formulas are the same in both. These are the ones that trip people up when they switch, and each links to practice.
| Task | Google Sheets | Excel |
|---|---|---|
| Filtering rows | FILTER(range, condition1, condition2, …). No match gives #N/A. | FILTER(array, include, [if_empty]). No match gives #CALC!. |
| Sorting | SORT(range, column, TRUE or FALSE, …) | SORT(array, [sort_index], [1 or -1], [by_col]) |
| Array math | Wrap the formula in ARRAYFORMULA (or press Ctrl+Shift+Enter). | Microsoft 365 spills array results on its own. |
| Summarizing with SQL | QUERY(data, "select … where … group by …") | No QUERY. FILTER, GROUPBY or a PivotTable do parts of it. |
| Regular expressions | REGEXMATCH, REGEXEXTRACT, REGEXREPLACE | Microsoft 365 has REGEXTEST, REGEXEXTRACT and REGEXREPLACE, with different arguments. |
| Splitting text | SPLIT(text, delimiter) | TEXTSPLIT in Microsoft 365, or Text to Columns. |
| Ranges that grow | A2:A runs to the bottom of the sheet. | Use A:A, a table, or a fixed range like A2:A1000. |
| Joining ranges | {A2:A10, C2:C10} puts ranges side by side; a semicolon stacks them. | Braces hold constants only; use HSTACK and VSTACK. |
| Counting unique values | COUNTUNIQUE(range) | COUNTA(UNIQUE(range)) |
Guides and practice
The QUERY function
Select, where, group by, order by and label, every example calculated live, plus three graded exercises.
Highlight duplicates
The conditional formatting formula, only-the-repeats, two columns, and removing duplicate rows.
Interview questions
18 questions with model answers. The formula ones come with a graded task.
Free skills test
Six timed tasks, your level, and what to practice next. No signup.
Sheets functions
ARRAYFORMULA, FILTER, SORT, SPLIT, JOIN, COUNTUNIQUE and more, each with live examples.
Functions shared with Excel
XLOOKUP, SUMIFS, IFERROR, UNIQUE and over a hundred more work the same way in both.
Questions
Is this the real Google Sheets?
No. It's our own spreadsheet that runs in your browser. For the formulas taught here it follows Google Sheets rules: FILTER and SORT take Sheets arguments, QUERY, ARRAYFORMULA, SPLIT and the REGEX functions work, and empty results stay blank. That's what lets us grade your answer instantly.
Do I need a Google account?
No. Everything runs on this site. Your progress is saved in your browser, or to your account here if you sign in.
What's free?
The first 4 lessons, the skills test, the function pages, the QUERY guide and the interview questions. Pro unlocks the power tools track and the Excel course.
Do you cover pivot tables, charts and conditional formatting?
Not in the live grid yet. The interview questions explain how they work in Sheets, and the duplicates guide covers the conditional formatting formulas you can practice here.
I already know Excel. Where should I start?
Read the differences table above, then go to FILTER and SORT, ARRAYFORMULA and QUERY. Those are where Sheets works differently.
Google Sheets is a trademark of Google LLC. Spreadsheet Practice is independent and not affiliated with or endorsed by Google.