OfficeDrillsSpreadsheet Formulas
Learn how spreadsheet formulas actually work, from scratch — the equals sign, cell references, ranges, SUM, math operators, filling down, absolute references, IF, and COUNTIF — in a slow, hands-on, fully explained practice course.
Free — no cost, no account limits
Start the free lesson →
What you'll practice
- What a Formula Actually Is
- Cell References — Pointing at Another Cell
- Ranges — Defining "B2 Through B6"
- SUM — Adding Up a Range
- Math Operators — Combining Cells
- Filling a Formula Down a Column
- Absolute References — Locking a Cell with $
- IF — Making a Decision
- COUNTIF — Counting What Matches
Drills & Projects
Drill
Technically Runs →
Six real formula tasks, on an actual live formula bar and grid — a wrong auto-suggested range, missing parentheses, a count question answered with a total, and more. No account needed.
Free · No account needed
Drill
Small Slip, Big Miss →
Six real spreadsheet-formula tasks, in any spreadsheet app — a formula that was only text, a reference that shifted on fill-down, a rate typed as 8 instead of 8%, a total that counted itself, and more. No account needed.
Free · No account needed
Drill
Filled Down Wrong →
Six spreadsheets where a fill, a copy or a recalculation quietly changed the answer: a half-locked reference, subtotals counted twice, numbers stored as text, a report built on TODAY and more. No account needed.
Free · No account needed