Home › AI at work

AI at work

Get Excel to do whatever you need

You know SUM. Maybe VLOOKUP on a good day. That's enough now. Describe what you want in plain English and AI gives you the formula, the steps, or the finished result.

1

AI writes it, you run it

Describe your columns and what you want. The AI gives you the exact formula or the exact clicks.

Your data never leaves Excel, so it works even where uploading work files isn't allowed.

2

AI does the work

Upload the spreadsheet and ask questions. Get answers, charts, cleaned files and a written summary back.

The fastest route, when your company's AI policy allows it.

Start here

Five guides, each built around an everyday office job. All free, all with prompts you can copy.

GuideRouteDifficultyTimeCost
Get AI to write any Excel formulaLookups, totals with conditions, fixing #N/A, understanding inherited formulas
 FormulaStarter20 minFree Read guide →
Clean up a messy spreadsheetRemove duplicates, fix mixed dates, strip spaces and symbols
 BothStarter30 minFree Read guide →
Pivot tables made easyTurn hundreds of rows into the answer your boss wants
 BothStarter30 minFree Read guide →
Build an Excel dashboardHeadline numbers, charts, traffic lights and a filter on one page
 FormulaEasy1 hourFree Read guide →
Hand your spreadsheet to AIAsk questions, get charts, files and the summary email
 AI does itStarter20 minFree Read guide →
Combine 20 spreadsheets into one
 AI does itComing soon
Turn a PDF table into Excel
 AI does itComing soon
Automate a weekly report
 ScriptComing soon
Mail merge from a spreadsheet
 FormulaComing soon
Google Sheets versions of every guide
 FormulaComing soon
ADVERTISEMENT · 728 × 90

Free practice files

300 made-up orders from an office-supplies company, so you can learn without touching real work data. Every guide uses them.

office-supplies-sales-clean.csvReady to use. For the formula, pivot table, dashboard and analysis guides. office-supplies-sales-messy.csvThe same orders after six people "helped": duplicates, mixed dates, stray spaces and more.

Before you use AI with work data

  • Check your company's AI policy. Many workplaces provide an approved tool, like Microsoft Copilot or a business plan of ChatGPT, Claude or Gemini. Use that rather than a personal account.
  • Never upload confidential or personal data (customer details, salaries, health information) to a personal AI account. Remove those columns, or use route 1 instead.
  • Check before you send. Compare at least one total with your own. AI is very good with data, but your name is on the report.