# Google Sheets practice: lessons and exercises graded in a live sheet

> A hands-on Google Sheets formulas course: 17 lessons and 53 graded exercises. The first 7 lessons are free.

Source: https://spreadsheetpractice.com/google-sheets · Updated October 29, 2026

## Sheets essentials (free)

Formulas, conditional totals, lookups, and FILTER and SORT the Google Sheets way.

- [Lesson 1: Formulas in Google Sheets](https://spreadsheetpractice.com/google-sheets/learn/formulas-in-google-sheets): Sheets formulas work like Excel's, plus one habit worth learning early: ranges with no last row. (8 min)
- [Lesson 2: COUNTIF, SUMIF and the IFS versions](https://spreadsheetpractice.com/google-sheets/learn/countif-sumif): Count or add only the rows that match, with conditions anyone can change from a cell. (10 min)
- [Lesson 3: VLOOKUP and XLOOKUP in Google Sheets](https://spreadsheetpractice.com/google-sheets/learn/vlookup-xlookup): Pull a name, a price or a rate from another table by its code. (10 min)
- [Lesson 4: FILTER and SORT, the Sheets way](https://spreadsheetpractice.com/google-sheets/learn/filter-and-sort): Pull the matching rows into a live list, then put them in order, with one formula each. (12 min)

## Data tools (free)

Conditional formatting, pivot tables and charts, the way Google Sheets does them.

- [Lesson 5: Conditional formatting with custom formulas](https://spreadsheetpractice.com/google-sheets/learn/conditional-formatting): Color cells, and whole rows, by any rule you can write as a formula. (10 min)
- [Lesson 6: Pivot tables](https://spreadsheetpractice.com/google-sheets/learn/pivot-tables): Total, count and rank a whole table in a few clicks, with no formulas to write. (12 min)
- [Lesson 7: Charts that fit the data](https://spreadsheetpractice.com/google-sheets/learn/charts): Pick the chart that answers the question, and give it exactly the right range. (10 min)

## Sheets power tools (Pro)

UNIQUE, ARRAYFORMULA, SPLIT, regular expressions and QUERY, then a capstone.

- [Lesson 8: UNIQUE, COUNTUNIQUE and duplicates](https://spreadsheetpractice.com/google-sheets/learn/unique-and-duplicates): List each value once, count how many different values there are, and flag the repeats before they cause trouble. (9 min)
- [Lesson 9: ARRAYFORMULA: one formula for the whole column](https://spreadsheetpractice.com/google-sheets/learn/arrayformula): Write the formula once at the top, and every row below gets its answer, including rows added later. (10 min)
- [Lesson 10: SPLIT, JOIN and text cleanup](https://spreadsheetpractice.com/google-sheets/learn/split-join-text): Tidy messy imported text, break one column into several, and join values back into one cell. (11 min)
- [Lesson 11: REGEXMATCH, REGEXEXTRACT and REGEXREPLACE](https://spreadsheetpractice.com/google-sheets/learn/regexmatch-regexextract-regexreplace): Find, pull out and rewrite text by pattern instead of by position. (12 min)
- [Lesson 12: QUERY basics: select, where, order by](https://spreadsheetpractice.com/google-sheets/learn/query-function-basics): Ask a range a question in plain, SQL-like words and get a live table of answers back. (12 min)
- [Lesson 13: QUERY: group by, totals and labels](https://spreadsheetpractice.com/google-sheets/learn/query-group-by): Turn a long list into a summary table, one row per store or rep, with a single formula. (12 min)
- [Lesson 14: QUERY: pivot, limit and text matching](https://spreadsheetpractice.com/google-sheets/learn/query-pivot-limit-contains): Match part of a name, keep only the top few rows, and spread a category across the columns. (11 min)
- [Lesson 15: MAP, BYROW and LAMBDA in Sheets](https://spreadsheetpractice.com/google-sheets/learn/map-lambda-byrow-sheets): Run your own formula over every row, with one cell and no filling down. (11 min)
- [Lesson 16: SORTN, SEQUENCE and TRANSPOSE](https://spreadsheetpractice.com/google-sheets/learn/sortn-sequence-transpose): Take the top rows, number a list, and flip a table on its side. (9 min)
- [Lesson 17: Capstone: a sales summary in Sheets](https://spreadsheetpractice.com/google-sheets/learn/capstone-sales-summary): Build a working sales summary on one order log: a self-filling revenue column, a region table, a top-reps ranking and a drill-down. (20 min)

## Guides and tools

- [The QUERY function](https://spreadsheetpractice.com/google-sheets/query)
- [IMPORTRANGE](https://spreadsheetpractice.com/google-sheets/importrange)
- [GOOGLEFINANCE](https://spreadsheetpractice.com/google-sheets/googlefinance)
- [Google Sheets vs Excel](https://spreadsheetpractice.com/google-sheets/vs-excel)
- [Highlight duplicates](https://spreadsheetpractice.com/google-sheets/highlight-duplicates)
- [Interview questions](https://spreadsheetpractice.com/google-sheets/interview-questions)
- [Free skills test](https://spreadsheetpractice.com/google-sheets/skills-test)
- [ARRAYFORMULA in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/arrayformula)
- [FILTER in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/filter)
- [SORT in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/sort)
- [SPLIT in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/split)
- [JOIN in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/join)
- [COUNTUNIQUE in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/countunique)
- [REGEXMATCH in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/regexmatch)
- [REGEXEXTRACT in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/regexextract)
- [REGEXREPLACE in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/regexreplace)
- [TO_TEXT in Google Sheets](https://spreadsheetpractice.com/google-sheets/functions/to-text)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
