Google Sheets and Excel help that shows its work

Get any spreadsheet right.

Find a tutorial, fix a broken formula, or check your whole sheet for errors. Every step shown live.

Fix my formula →Browse tutorials

▶#DIV/0 errorErrors · 75s→▶#ERROR formula parse errorErrors · 75s→▶#N/A errorErrors · 75s→

✓Every tutorial includes a reviewed recording and the finished spreadsheet result.

BROWSE BY OUTCOME

Start with what you’re trying to do.

BORDERS · COLOURS · WRAPPING

Format a
spreadsheet

Make sheets readable, consistent, and ready to share.

	A	B	C
1	Region	Q1	Q2
2	North	142	168
3	South	98	121
4	West	173	154

DUPLICATES · WHITESPACE · COLUMNS

Clean messy
data

Fix duplicates, split text, trim spaces, and standardise values.

	A	B
1	Acme	4102
2	Globex	2071
3	Globex	2071
4	Initech	3388

SUMIF · COUNTIFS · VLOOKUP

Build a
formula

Get the exact formula and understand why it works.

	A	B	C
1	North	142	310
2	South	98
3	North	168

#N/A · #REF! · PARSE ERRORS

Fix an error

Understand what broke and repair it without guessing.

	A	B
1	Units	Total
2	24
3	17	408

01 · LEARN IT

Short tutorials that show
the exact move.

Search for the thing you need to do, then follow a short recording inside a real spreadsheet. The written steps, expected result, and common mistakes are all on the same page.

Browse every tutorial →

01▶Data validation · 60s

02 · VERIFIED TUTORIALS

See it happen.
Then do it yourself.

1
Find the exact taskSearch by menu, result, formula, or error.
2
Watch it in a real sheetFollow every click and value without skipping ahead.
3
Check your resultCompare the finished sheet and catch common mistakes.

Verified by real humansThe result, written steps, and recording are checked before publishing.

✓

03 · SOLVE IT

Formula help for the moment
you get stuck.

Fix a broken formula, write one from plain English, understand an unfamiliar formula, or change one you already use. You get one recommended Google Sheets formula first, followed by a clear explanation.