Spreadsheets, explained by a real person
Spreadsheets that finally make sense.
G’day, I’m Steve. I pick a spreadsheet skill, show you it in a short video, write it up properly, and build a template so you can use it straight away. Aussie examples, no jargon.
|
Item |
Category |
Price (inc GST) |
|---|---|---|
|
Flat white |
Coffee |
$5.00 |
|
Smashed avo |
Breakfast |
$19.50 |
|
Lamington |
Cakes |
$6.50 |
|
Sausage roll |
Savoury |
$7.00 |
What are you trying to do?
Popular: VLOOKUP · SUMIFS · FILTER · IF · Working out GST · Financial year dates
Learn
What’s New This Month
-
Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
The Functions Library
Every function, answered in the first few lines.
Plain-English explanations, real examples from a Bluegum Cafe workbook, which version it works in, and the errors you’ll actually hit.
Lookup & Reference
XLOOKUP · INDEX · MATCH
Text
TEXTJOIN · LEFT · TRIM
Date & Time
EOMONTH · NETWORKDAYS · TODAY
Logical
IF · IFS · IFERROR
Math & Trig
SUMIFS · ROUND · SUMPRODUCT
Statistical
COUNTIFS · AVERAGEIFS · MAX
Dynamic Array
FILTER · UNIQUE · SORT
Financial
PMT · NPV · FV
Information
ISBLANK · ISNUMBER · CELL
Made for Aussie Spreadsheets
Examples that look like your actual work.
Most tutorials assume US dates, sales tax and a January year. Here, everything’s built for how we do it.
=C2/11
10% GST
Pull the GST out of an inclusive price, or add it on, the right way.
1 Jul – 30 Jun
Financial year
Group, total and report by FY and quarter, not calendar year.
25/12/2026
DD/MM dates
Dates the way we write them, plus the fix when Excel flips them.
$ AUD
Real small-business tasks
Rosters, supplier invoices, payroll and sales, from a cafe you’ll get to know.
Who’s the Guru?
I’m Steve. I’ve spent years making spreadsheets do the boring bits.
I work with reporting data in spreadsheets day in, day out, and I’ve done postgraduate study in data science, so I know both the theory and the messy reality of a real-world workbook. What I love most is taking a pile of raw numbers and turning it into a report people actually understand and trust. I started That Spreadsheet Guru to share the practical skills that make that possible, minus the jargon.
One spreadsheet tip a week.
Straight to your inbox from Steve. A useful function, the weekly topic or a template link that will make your spreadsheet life a little easier. Unsubscribe any time.