Spreadsheet skill is the most transferable thing we teach. It is on more job descriptions than any single technology, and most people only ever learn a tenth of it.
We cover formulas and references, lookups, cleaning messy data, pivot tables, and building a chart that tells the truth.
Jobs this leads towards
Real roles people do after this course and the ones that follow it.
-
Data analyst
Turns a spreadsheet full of numbers into a chart and a sentence a manager can act on.
-
Office administrator
Runs budgets, rotas and records — almost entirely in spreadsheets.
-
Junior finance or operations assistant
Keeps the numbers straight and spots when something is off.
Certifications
What this course prepares you to sit. Exam vouchers are included.
- Microsoft MO-210 (Excel Associate)
Is this for me?
Ninety seconds, no wrong answers, nothing recorded. It tells you how closely this course matches what you enjoy — and where to look if it does not.
What a week looks like
Day to day, so nobody is surprised.
- Two hours a week: half explanation, half doing it on a real dataset.
- Each week ends with a chart, a script or a result you can show somebody.
- You use AI tools every session, and you check what they get wrong.
- A small project of your own choosing for the last three weeks.
Three questions from week one
Get them wrong and you belong here. Get them right and you belong here too. Nothing is recorded.
Books worth having
None of these is required — the course lends what it needs. These are the ones worth owning.
-
Automate the Boring Stuff with Python
Al Sweigart
Free to read online; the course uses several chapters.
Find it ↗
What to bring
Usually nothing. Where something small helps, it is here.
- ▸Nothing to buy: free tools throughout.
- ▸A free account on Kaggle for datasets.
- ▸A notebook for questions you want the data to answer.
Do this at home
Between sessions. Ten to twenty minutes; the people who do this are the ones who finish.
- Habit 1Find a dataset about something you care about and open it in a spreadsheet.
- Habit 2Ask an AI tool a question you know the answer to. Grade it.
- Habit 3Write ten lines of Python a day, even if they are the same ten lines.
What you will be able to do
- Write formulas with absolute and relative references confidently
- Use XLOOKUP and conditional logic to join and classify data
- Clean a messy exported file into something usable
- Summarise thousands of rows with a pivot table
- Build a chart that represents the data honestly
What you will use
- Microsoft Excel
- Google Sheets
- Power Query
What the course covers
The lesson plan for this course is being written. Register and we will tell you the moment it opens.