Make sense of spreadsheets
Intermediate 5 · 1 minute 47 seconds · Free to learn · Words printed on screen · Watch above, then try the exercise below.
What you'll learn
- Describing what you want in plain English instead of formula language
- The tidy-up pass — formats, duplicates, hidden double-bookings
- "Show your working" — the phrase that keeps totals honest
- Charts and what-if models in seconds
Key points
The whole lesson runs on one honest example: a year of village hall bookings — dates, halls, and fees — kept in a spreadsheet that has got untidy.
The tidy-up explains what it changed as it goes, and an untidy sheet usually hides something — here, a double-booked Saturday.
A total you cannot trace is a rumour: ask "show me which rows you added" and the numbers stay honest.
Check one row by hand before you trust the whole sheet — AI arithmetic is strong, but it can only count what the data actually says.
Always work on a copy, never the original, so a bad tidy-up costs you nothing. Camp rule: You bring the questions; it does the counting.
Try it
- Copy one small spreadsheet you own.
- Ask for a tidy-up and read what it changed.
- Ask three plain questions — with "show your working."
The words in this video
Prefer to read, or want to follow along while you watch? Here is everything the narrator says in this lesson, word for word.
Welcome back. I am Maggie. Today, the spreadsheet — that grid of numbers other people seem to read like a newspaper. Our example is honest and small. The village hall bookings — a year of dates, halls, and fees, kept in a spreadsheet that has got untidy. You do not need to learn the grid's secret language. You describe what you want in plain English, and the AI translates.
First, the tidy-up. I paste the bookings in and ask — clean this up. Same date format everywhere, hall names spelled one way, no duplicates. It explains what it changed as it goes. That explanation matters — untidy data usually hides one double-booked Saturday. Now questions, in sentences. Which hall earned most this year. Which month is quietest. It answers from the numbers, and shows its working.
Showing its working is the phrase to remember. A total you cannot trace is a rumour. Ask — show me which rows you added. Formulas without tears. I say — add a column that takes ten percent off for charities. It writes the formula and tells me what it does, in words. Pictures from numbers. Make a simple bar picture of fees by month. One glance tells the committee what three meetings could not.
And the what-next question. If we raised the small hall by two pounds an hour, what would the year look like. It models it in seconds. The caution, as always. Check one row by hand before you trust the whole sheet. AI arithmetic is strong, but it can only count what the untidy data actually says. Keep the original file untouched. Always work on a copy, so a bad tidy-up costs you nothing.
Try it. Take one small spreadsheet you own, paste it in, and ask three plain-English questions — with show your working on the end. Camp rule — you bring the questions, it does the counting. Next time, pictures with a plan. See you there.