Lessons

14 lessons so far, with more on the way. Lesson 1 is free to try. Lessons 2 to 4 need a free account, and the rest come with the semester pass.

1. 1LESSON 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
2. 2LESSON 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
3. 3LESSON 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
4. 4LESSON 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
5. +55 LESSONS · PASSFoundationsReferences, percentages, margins and rounding: the habits every model relies on.PASS
6. +44 LESSONS · PASSCounting and summing with conditionsCount and total only the rows that matter.PASS
7. +11 LESSON · PASSLogicFormulas that make decisions.PASS