Spreadsheets, explained by a real person
Spreadsheets that finally make sense.
Hi, 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. Real-world examples, no jargon.
|
Item |
Category |
Price (inc. tax) |
|---|---|---|
|
Flat white |
Coffee |
$5.00 |
|
Avocado toast |
Breakfast |
$19.50 |
|
Brownie |
Bakery |
$6.50 |
|
Croissant |
Savoury |
$7.00 |
What are you trying to do?
Popular: VLOOKUP · SUMIFS · FILTER · IF · Working out sales tax & VAT · Fiscal year dates
Learn
What’s New This Month
-
How to Sum by Category and Month in Excel (SUMIFS)
Turn a long list of bills into a monthly spending summary with one SUMIFS formula. Step-by-step, with sales-tax and fiscal-year variations.
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 Real-World Spreadsheets
Examples that look like your actual work.
Most tutorials assume one country’s dates, tax and calendar. Here, every example works wherever you are, with local variations when they matter.
=C2/(1+B2)
Sales tax & VAT
Pull the tax out of a tax-inclusive price, or add it on, the right way.
Any year-end
Fiscal year
Group, total and report by fiscal year and quarter, whichever month yours starts.
12/25 vs 25/12
Date formats
Handle DD/MM and MM/DD dates, plus the fix when Excel flips them.
$ € £
Real small-business tasks
Rosters, supplier invoices, payroll and sales, from a cafe you’ll get to know.
Who’s That Spreadsheet Guy?
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 Guy 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.