AI for Spreadsheets and Data Analysis
Write formulas, clean messy data and get real answers from your spreadsheets without being a data analyst.
What you'll be able to do
- Generate and explain formulas (XLOOKUP, QUERY, pivots)
- Clean and reshape messy exports
- Ask questions of a dataset and verify the answers
- Make charts that tell the story
The curriculum
3 modules · 7 lessons · 68 minutes
Module 1Formulas2 lessons
- Describe it, get the formulaFree preview9 min
- Explaining someone else's spreadsheet8 min
Module 2Cleaning2 lessons
- Fixing dates, names and duplicates12 min
- Splitting and merging columns9 min
Module 3Analysis3 lessons
- Uploading data to an AI chat10 min
- Checking AI's maths9 min
- Charts and summaries11 min
Who it's for
Anyone who opens spreadsheets more than they'd like.
Requirements
- •Excel or Google Sheets
Start now with free tutorials
Free guides on the same topic, available to read today.
AI at Work.
Turn any meeting transcript into decisions and actions
A reusable prompt that produces a table of decisions, owners and deadlines instead of useless minutes.
AI at Work.
Get the right spreadsheet formula every time
How to describe your sheet so AI writes formulas that work first time, and how to check them.
You might also like
Get your evenings back.
ChatGPT for Everyday Work
A practical, free starter course: emails, summaries, research and planning, with AI saving you an hour a day.
Prompts that land.
Prompt Engineering Masterclass
Go from vague questions to reliable, structured prompts that work across ChatGPT, Claude and Gemini.
Zero to shipped.
Claude Code from Zero to Shipping
Use an AI agent in your terminal to plan, write, test and ship real features, without losing control of your codebase.