🧠

Spreadsheets & Data Cleanup

Stop fighting formulas. Describe what you want.

AI Foundations · Beginner · 11 min read · 4 quiz questions

By Ronan Liedmeier, fractional head of growth and course author · Reviewed 13 October 2026

What you will learn

  • The mindset: AI as your spreadsheet-literate colleague
  • Paste messy data, get clean tables
  • "What formula do I need?" — plain-English → working formula, explained
  • Upload a CSV/Excel file and ask questions in English
  • Pivot-table thinking without pivot-table skills ("show totals by month by category")

Lesson preview

Spreadsheets stop being intimidating once you treat AI as a colleague who's fluent in formulas, cleanup, and analysis — you describe the outcome in plain English, and it handles the mechanics. The one hard rule is to let it compute on real files instead of doing arithmetic in its head, because that's exactly where confident-sounding wrong totals come from. The biggest shift for beginners is mental, not technical: stop thinking of AI as a formula dictionary you have to phrase questions to correctly, and start thinking of it as a colleague who's genuinely good with spreadsheets and happy to do the fiddly part. That means you don't need to know the name of a function, the right syntax, or even that pivot tables exist as a concept. You describe the outcome — "clean this up," "total this by category," "what formula gets me X" — and the mechanics are the AI's job, not yours. This reframing matters because a lot of people avoid spreadsheet tasks entirely out of formula-anxiety. Once the barrier is "describe what you want" instead of "remember the right function," spreadsheets become approachable in a way they weren't before. Real-world data is rarely clean — mixed date formats, inconsistent categories, stray whitespace, duplicate entries. Instead of manually reformatting row by row, you can paste the mess and ask for a clean, consistently formatted table. Be specific about the format you want ("date as YYYY-MM-DD," "category from this list") so the output is genuinely usable rather than just tidier-looking. It also helps to explicitly ask the AI to flag anything ambiguous, rather than silently guessing at how to categorize an unclear entry. This single skill — paste mess, get structure — removes a huge amount of the tedious manual work that used to make data cleanup dread-inducing.

Continue reading

Frequently asked questions

Who is "Spreadsheets & Data Cleanup" for?
This Beginner module in AI Foundations is for people who are new to AI tools and want practical, everyday results without jargon. It takes about 11 minutes and ends with a 4-question quiz.
Do I need to code?
No. Everything in this module works in tools like ChatGPT, Claude or Gemini through a normal chat window.
What comes before and after this module?
Before "Spreadsheets & Data Cleanup", take "Video With AI" (module 17 of AI Foundations). Afterwards, continue with "Email & Calendar Workflows".

Unlock this lesson and the full academy

  • Monthly€9.99 / month
  • Yearly€69.99 / year
  • Lifetime€129.99 one time
See plansStart with the free lessons

Loading your lesson…

Related modules