Get fluent in Excel formulas.
Look up any Excel function, see it worked through, then drill it until you stop needing to look it up.
Browse the guides
- Functions Guides for every Excel function, each with syntax, a worked example and the mistakes people make.
- How-to Step-by-step answers to everyday jobs: drop-down lists, freezing panes, locking cells.
- Features The big tools explained from the start: pivot tables, conditional formatting, charts.
- Errors What #N/A, #VALUE!, #REF! and the rest mean, and how to fix each one.
- Shortcuts The keyboard shortcuts worth learning, grouped by what you are trying to do.
- Learn Guided tracks from first formula to job-test ready, with practice exercises.
Practice Excel in a spreadsheet that checks your work
Type the formula, press Enter and find out on the spot whether you got it right. No videos to sit through and no answer key to hunt for.
It works like Excel
Cells, a formula bar and the same keyboard shortcuts, so what you practice carries straight over.
One skill per drill
Each drill takes a couple of minutes and asks you to type one formula or do one task.
Every answer is graded
The sheet checks the result in your cell, so a formula that only looks right doesn't pass.
Most-used functions
See every function- XLOOKUP The modern lookup: find a value in one range and return the matching entry from another, in any direction. It replaces most VLOOKUP and INDEX/MATCH uses.
- VLOOKUP The classic lookup: find an item in the first column and fetch something from the same row. Common in interviews, though XLOOKUP is the modern choice.
- IF The basic decision function: show one thing if a condition holds, another if not. It underpins most conditional logic in spreadsheets.
- SUMIFS Adds values subject to several conditions at once, e.g. sales for a product in one quarter.
- COUNTIFS Counts rows where all the listed conditions hold at once, such as orders from one region in a given month. The standard way to do AND-style counting.
- INDEX Returns the item at a given row and column of a range. Paired with MATCH it makes a flexible lookup that works in any direction.
- MATCH Finds where an item sits in a list and returns its position number. Usually combined with INDEX.
- FILTER Returns only the rows that satisfy one or more conditions, spilling the results. It replaces many manual filter and lookup-all tricks.
Learn Excel in order
How the tracks work- Excel for beginners Cells, ranges, your first formulas and the handful of functions everything else builds on. Start this track
- Intermediate Excel Lookups, conditional sums and counts, text and date formulas, tables and sorting. Start this track
- Advanced Excel Dynamic arrays, nested logic, pivot tables and the formulas hiring tests like to ask for. Start this track
Popular how-tos
All how-tosExcel test coming up?
Hiring tests ask for the same dozen skills again and again. See what they cover, then drill each one until it's quick.