Learn the Excel your first job expects.
Short exercises in your browser, on the kind of spreadsheets you'd get at a bank, a Big 4 firm or in an FP&A team.
A1Kookaburra Retail · FP&A+10 pts
| A | B | |
|---|---|---|
| 1 | Month (FY27) | Opex ($k) |
| 2 | Jul | 4,120 |
| 3 | Aug | 3,980 |
| 4 | Sep | 4,310 |
| 5 | Oct | 4,050 |
| 6 | Nov | 4,460 |
| 7 | Dec | 5,180 |
| 8 | Year to date | 26,100 |
| 9 | Monthly average |
Lessons
Lesson 1 is free to try. Lessons 2 to 4 need a free account, and the rest come with the semester pass.
- LESSON 1 · OPENYour first formulas: SUM, AVERAGE, MAXTotal a retailer's year-to-date operating costs, find the monthly run-rate and the peak month, and watch formulas update themselves.OPEN
- LESSON 2 · FREE ACCOUNTCopying formulas and locking references with $Translate regional revenue from AUD to USD with one FX rate, copy the formula down, and see why $G$1 stays put.FREE
- LESSON 3 · FREE ACCOUNTPercentages and GST: from till takings to revenueStrip GST out of store sales, split out the GST component, and work out each store's share of revenue.FREE
- LESSON 4 · FREE ACCOUNTShortcuts: move, select and sum without the mouseJump to the end of a 20-store revenue table, select a whole column of revenue and total it with AutoSum, all from the keyboard.Needs a keyboardFREE
- LESSON 5 · PASSIF, COUNTIF and SUMIF: screening acquisition targetsFlag which targets pass a leverage test, then count them and total their revenue.PASS
- LESSON 6 · PASSOperators and order of operationsRecalculate a client's sales schedule on an audit team: multiply, subtract inside brackets, fix a BODMAS mistake and compound with ^.PASS
- LESSON 7 · PASSMixed references: one formula for a whole sensitivity tableBuild Kookaburra Retail's FY28 EBITDA table for every growth and margin case from a single formula, using $A5 and B$4.PASS
- LESSON 8 · PASSPercentage change and marginsPrepare Mallee Foods' FY26 results summary: year-on-year % change, gross and EBITDA margins, and the change in margin in percentage points.PASS
- LESSON 9 · PASSRounding properlyPrice Kookaburra Retail's Christmas catalogue: round promo prices to the cent and to 5c, order whole cartons with ROUNDUP and split stock between stores with ROUNDDOWN.PASS
- ALL LESSONS →There are currently 14 lessonsWe're going deep down the rabbit hole.
How it works
Each lesson is a handful of tasks on one spreadsheet, the sort of thing a manager hands a grad. You type the formula into the cell and find out straight away whether it's right. A typed-in number doesn't count, even if it's the right number. Hints are there if you're stuck, but they halve the points for that step.
Semester pass
Six months of every lesson, in Excel and Google Sheets. You pay once and it doesn't renew.
A$49On sale soon