# Excel course: 45 lessons with graded practice

> A hands-on Excel formulas course: 45 lessons and 127 graded exercises. The first 11 lessons are free.

Source: https://spreadsheetpractice.com/learn · Updated October 29, 2026

## Foundations (free)

Formulas, the core functions, and the $ that trips everyone up.

- [Lesson 1: Your first formula](https://spreadsheetpractice.com/learn/first-formula): Every formula starts with an equals sign and points at cells, not numbers. (6 min)
- [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count): Five functions answer most questions about a list of numbers. (7 min)
- [Lesson 3: Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references): The dollar sign decides what moves when you fill a formula. (9 min)
- [Lesson 4: Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth): Percentages are just decimals with a format applied. (7 min)

## Logic & conditions (free)

IF, AND/OR, IFS, and counting or adding only the rows that match.

- [Lesson 5: The IF function](https://spreadsheetpractice.com/learn/if-function): IF asks a yes-or-no question and returns one of two answers. (7 min)
- [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs): Combine conditions, and pick between more than two outcomes. (9 min)
- [Lesson 7: COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif): Count or add only the rows that match a condition. (8 min)
- [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs): Filter by several conditions at once, driven by input cells. (10 min)

## Data tools (free)

Conditional formatting, PivotTables and charts: the tools most Excel tests check.

- [Lesson 9: Conditional formatting with formulas](https://spreadsheetpractice.com/learn/conditional-formatting-formulas): A formula rule colors exactly the cells you mean, and keeps up when the data changes. (10 min)
- [Lesson 10: PivotTables](https://spreadsheetpractice.com/learn/pivottables): Summarize hundreds of rows by any field in a few clicks, with no formulas to write. (12 min)
- [Lesson 11: Charts: pick the right one](https://spreadsheetpractice.com/learn/charts): The question you're answering picks the chart. Then select the right cells. (9 min)

## Lookups (Pro)

VLOOKUP, XLOOKUP, INDEX/MATCH and tiered lookups.

- [Lesson 12: VLOOKUP](https://spreadsheetpractice.com/learn/vlookup): Find a row by its key and pull back a value from the same row. (9 min)
- [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup): The modern lookup: any direction, exact by default, with a fallback. (9 min)
- [Lesson 14: INDEX & MATCH](https://spreadsheetpractice.com/learn/index-match): Look up by row and column at the same time. (10 min)
- [Lesson 15: Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror): Commission tiers, tax brackets and shipping bands are approximate lookups. (9 min)
- [Lesson 16: Lookups with several criteria](https://spreadsheetpractice.com/learn/multi-criteria-lookups): When one column is not enough to identify a row, match two or more at once. (10 min)
- [Lesson 17: Last match, nearest value & wildcards](https://spreadsheetpractice.com/learn/xlookup-search-modes): XLOOKUP can search from the bottom, round up to the next size, and match part of a name. (10 min)

## Text cleanup (Pro)

Split, join and clean messy imported text.

- [Lesson 18: LEFT, RIGHT, MID & LEN](https://spreadsheetpractice.com/learn/left-right-mid-len): Cut text apart by position. (8 min)
- [Lesson 19: Joining text](https://spreadsheetpractice.com/learn/joining-text): Glue names, labels and lists together. (7 min)
- [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data): Fix spacing, capitals and stray characters in imported data. (8 min)
- [Lesson 21: TEXTBEFORE, TEXTAFTER & FIND](https://spreadsheetpractice.com/learn/textbefore-textafter-find): Split text at a delimiter without counting characters. (8 min)
- [Lesson 22: Splitting and counting list cells](https://spreadsheetpractice.com/learn/textsplit-count-clean-lists): Break "rush, gift, fragile" into separate cells, and count how many items a cell holds. (9 min)

## Dates (Pro)

How Excel stores dates, and the math that follows.

- [Lesson 23: DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text): A date is a number wearing a costume. (8 min)
- [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays): Add months, find month-ends and count business days. (9 min)
- [Lesson 25: Tenure, quarters & weekdays](https://spreadsheetpractice.com/learn/tenure-quarters-weekdays): Complete years between two dates, which quarter a date falls in, and whether it lands on a weekend. (10 min)

## Dynamic arrays (Pro)

UNIQUE, SORT, FILTER and LET: one formula, many results.

- [Lesson 26: UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort): One formula, many results that spill into the cells below. (9 min)
- [Lesson 27: FILTER](https://spreadsheetpractice.com/learn/filter-function): Return only the rows that pass a test, and keep them live. (10 min)
- [Lesson 28: LET](https://spreadsheetpractice.com/learn/let-function): Name the pieces of a long formula. (8 min)
- [Lesson 29: SORTBY, TAKE & SEQUENCE](https://spreadsheetpractice.com/learn/sortby-take-sequence): Build a top-N leaderboard that re-ranks itself. (9 min)
- [Lesson 30: VSTACK & HSTACK](https://spreadsheetpractice.com/learn/vstack-hstack): Combine tables and calculated columns without copy and paste. (9 min)
- [Lesson 31: LAMBDA with BYROW, MAP & SCAN](https://spreadsheetpractice.com/learn/lambda-byrow-map-scan): Write your own function once and apply it to every row, pair or running step. (12 min)
- [Lesson 32: Self-building summary tables](https://spreadsheetpractice.com/learn/summary-tables-unique-sumifs): A summary that lists its own groups, adds them up and ranks them. (11 min)

## Analysis (Pro)

Rounding, ranking and SUMPRODUCT.

- [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown): Formatting hides decimals; rounding removes them. (7 min)
- [Lesson 34: RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small): Who's on top, and by how much. (9 min)
- [Lesson 35: SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct): Multiply row by row and add it up, in one cell. (9 min)
- [Lesson 36: Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total): Anchor one end of a range and let the other end grow as you fill down. (9 min)
- [Lesson 37: Median, quartiles & outliers](https://spreadsheetpractice.com/learn/median-quartiles-outliers): Describe a column of numbers honestly, and flag the values that do not belong. (11 min)
- [Lesson 38: MAXIFS & MINIFS by group](https://spreadsheetpractice.com/learn/maxifs-minifs-by-group): The biggest and smallest value for each group, without sorting or filtering. (8 min)

## Finance (Pro)

Loan payments, time value of money, NPV and IRR.

- [Lesson 39: Loan payments with PMT](https://spreadsheetpractice.com/learn/pmt-loan-payments): What a loan costs per month, and in total. (9 min)
- [Lesson 40: Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value): What money grows to, and what future money is worth today. (8 min)
- [Lesson 41: NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr): Is this project worth doing? (10 min)

## Errors & checks (Pro)

Handle errors on purpose, catch duplicates, and prove two lists agree.

- [Lesson 42: Handling errors on purpose](https://spreadsheetpractice.com/learn/errors-iferror-ifna): Decide which errors to catch, and say what you want shown instead. (10 min)
- [Lesson 43: Duplicates & reconciliation](https://spreadsheetpractice.com/learn/duplicates-reconciliation-checks): Catch repeated rows, and find what is in one list but not the other. (11 min)

## Capstones (Pro)

Multi-step challenges like the ones in analyst interviews.

- [Lesson 44: Capstone: sales report](https://spreadsheetpractice.com/learn/capstone-sales-report): Build a report the way you would at work: a calculated column, an input-driven summary and a self-updating table. (15 min)
- [Lesson 45: Capstone: analyst interview test](https://spreadsheetpractice.com/learn/capstone-analyst-interview): The three tasks that show up in almost every analyst Excel test. (12 min)

## Also free

- [Excel skills test](https://spreadsheetpractice.com/excel-skills-test)
- [Excel functions list](https://spreadsheetpractice.com/functions)
- [Free Excel tests by job](https://spreadsheetpractice.com/free-excel-tests)
- [Formula Lab](https://spreadsheetpractice.com/lab)

---

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