What was assessed

20 lessons including 20 graded spreadsheet labs, and a 23-question final exam (75% required).

• Cell references & percentages: price a spring sale
• Absolute references ($)
• SUM, AVERAGE, MIN & MAX
• IF and nested IF
• SUMIFS & COUNTIFS
• VLOOKUP & XLOOKUP
• ROUND & MROUND
• Dates, payment terms & early-payment discount
• Budget vs actual: variances in $ and %, favourable or unfavourable
• INDEX & MATCH: a two-way lookup of exchange rates
• Running balances: a cash book that shows what is left
• Receivables aging: days past due, buckets & an approximate lookup
• SUMPRODUCT & weighted averages: average cost, interest rate & margin
• Break-even analysis: contribution margin, break-even point & margin of safety
• Check your own work: cross-footing, tie-outs & IFERROR
• Project: a quarterly management report from raw transactions
• Price, volume & mix: why revenue beat the budget
• Allocating shared costs: rent, IT and HR by driver
• Sensitivity: a price × volume profit grid and the price you need
• Final project: a 13-week cash forecast with a buffer and a credit-line need