Library
- What AI in a spreadsheet actually does
What the AI button in Excel and Google Sheets does with your data, what it can change, and what you still need to check yourself.
- AI features in Excel and Google Sheets: what the makers say
Which AI features Microsoft and Google document for Excel and Google Sheets, which plans they need, and what has been retired. Checked 11 November 2026.
- Asking AI to write a formula
How to describe what you want so spreadsheet AI gives a usable formula, with the makers' own example prompts and what to do with the result.
- Checking a formula the AI wrote before you rely on it
Practical ways to test a spreadsheet formula written by AI when you don't yet understand it, using Excel's Evaluate Formula and a few hand checks.
- Cleaning messy data with AI: names, dates and duplicates
Can AI tidy mixed dates, names and spellings in a spreadsheet? What the makers say it does, and how to check that no rows were lost or changed.
- Summarising a table or sheet with AI
What happens when you ask spreadsheet AI for totals, trends or a summary, and why the numbers can be wrong. Includes how the makers say to verify them.
- What data leaves your spreadsheet when you use AI
Where your sheet goes when you ask Excel's Copilot or Gemini in Sheets a question, what the makers say about training, and what to keep out.
- When a plain formula or pivot table is better than AI
Which spreadsheet jobs need exact, repeatable answers, and why a formula or PivotTable suits them better than an AI prompt.