Learn Excel by doing,
not watching
Hands-on exercises in a real spreadsheet — not a video. Type the formula, see it calculate, know instantly if you got it right.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Tax |
| 2 | Widget | 50 | =B2*0.2 |
13
function tracks
24
lessons
67
hands-on exercises
Every track, start to finish
3 lessons are free to try. The rest unlock with Pro — see pricing.
Excel Basics
The SUM Function
Learn to add up numbers with the SUM function, the most-used formula in Excel.
3 exercises
AVERAGE, MAX & MIN
Summarize a list of numbers at a glance — the three functions you'll use constantly in any report.
2 exercises
Absolute References ($)
Lock a cell reference with $ so it doesn't shift — essential for formulas you'll copy across rows or columns.
2 exercises
Logic
The IF Function
Make decisions in your spreadsheet: test a condition and return one value if it's true, another if it's false.
3 exercises
AND & OR
Combine multiple conditions into one TRUE/FALSE test — AND requires every condition to pass, OR only needs one.
2 exercises
IFS & SWITCH
Test several conditions at once without nesting nested IFs — IFS checks a list of conditions, SWITCH matches a value against a list of options.
2 exercises
Text Functions
Working with Text
Combine, split, and clean up text with LEFT, RIGHT, and CONCATENATE — handy for names, codes, and messy imported data.
3 exercises
Text Manipulation
Fix inconsistent capitalization, swap out unwanted characters, and join lists together — UPPER, PROPER, SUBSTITUTE, and TEXTJOIN.
4 exercises
Searching Inside Text
Pull characters out of the middle of a string, or find where one piece of text sits inside another — MID, FIND, and SEARCH.
3 exercises
Lookup Functions
VLOOKUP Essentials
Look up values in a table using VLOOKUP — one of the most requested Excel skills in job interviews.
1 exercise
XLOOKUP
Excel's modern replacement for VLOOKUP — simpler to write and more flexible.
2 exercises
HLOOKUP
Like VLOOKUP, but for tables laid out sideways — HLOOKUP searches across a row and returns a value from a row below it.
1 exercise
INDEX & MATCH
MATCH finds a value's position; INDEX returns a value at a position. Combined, they're a more flexible alternative to VLOOKUP.
3 exercises
Conditional Totals
Dates
Statistics
LARGE, SMALL & Rounding
Find the 2nd-highest or 2nd-lowest value in a list, and round numbers up or down to a chosen increment — LARGE, SMALL, FLOOR, and CEILING.
4 exercises
AVERAGEIF & MEDIAN
Average only the rows that match a condition, find the true middle value of a list, and sum with a wildcard pattern.
3 exercises
Formulas & Errors
Arrays
Combined Skills
Shortcuts
Conditional Formatting
Pivot Tables
A real formula engine
Every grid runs an actual spreadsheet calculation engine. Type =VLOOKUP(...) and it computes for real — no multiple-choice guessing.
Streaks, badges, levels
Keep a daily streak going, earn badges for finishing tracks, and level up as you rack up points.
A public leaderboard
See where you rank against everyone else learning. Your profile shows your badges, streak, and progress.