How to automate Excel and PowerPoint busywork with AI.

The direct answer: you automate Excel and PowerPoint busywork with AI by handing over three jobs. Upload the spreadsheet to Claude or ChatGPT, or open Copilot inside Excel, and ask it to clean, reconcile and analyse the data in plain English. Describe the formula you need and get it back working, with an explanation. Then give the model your notes and last quarter's deck and ask for the first draft of the slides, so you never start from blank. Save the instructions that worked and the monthly report becomes a ten-minute job. No code, and every number still gets checked by you.

Add up the hours honestly and it's confronting: for most corporate professionals, decks and spreadsheets consume more of the week than every meeting combined. Formatting cells at 9pm. Rebuilding the same monthly report. Turning someone's rambling notes into fourteen slides by tomorrow.

This is exactly the work AI is best at. Not because it's smarter than you, but because this work never needed your judgment in the first place. It needed your hours. Here's how to hand those hours over, in detail.

Excel: stop doing the data's chores

Modern AI models can read a spreadsheet the way you'd read an email. Upload a file to a frontier model (or open Copilot inside Excel itself) and the busywork becomes a conversation:

• Cleaning: "Merge these three exports, fix the date formats, flag duplicates and anything that looks like a typo." The tedious hour disappears.
• Analysis: "Which clients dropped off quarter-on-quarter, and what do they have in common?" You get the pivot table and the observation.
• Formulas without the folklore: describe what you want in plain English and get the working formula back, with an explanation, so it stops being magic.
• The monthly report: once AI has cleaned it your way twice, you save the instructions and reuse them. Same ten minutes, every month, forever.

The professionals doing this aren't "learning data science." They're delegating to a very fast junior who never gets bored. Your job stays the same: decide what matters, and check the work.

PowerPoint: from blank slide to credible draft

The blank deck is where evenings go to die. The AI workflow inverts it, so you never start from blank again:

• Start from the material, not the slide. Give the model your notes, the spreadsheet, last quarter's deck: "Draft a 10-slide update for the exec committee: headline takeaways, one chart per slide, risks at the end."
• Fix the storyline before the formatting. The draft's structure is the value: the narrative arc, the slide titles that actually say something. Reorder and sharpen while it's still cheap to change.
• Then, and only then, make it pretty. Brand template, layout polish, the human touches. You've spent your time on the 20% the room will remember.

The deck that took a weekend now takes an hour. It's better, too, because you spent that hour thinking instead of aligning text boxes.

A real example

A client, a regional finance manager with a 200-row client portfolio in Excel, used to spend the first two days of every month producing a performance summary deck. We built the workflow together in one session: AI cleans and reconciles the export, surfaces the five movers worth talking about, drafts the summary slides in the firm's structure, and produces the commentary in his tone (which the model learned from his past reports). Two days became roughly ninety minutes, most of it him reviewing, which is the part that was always his real job.

The three rules that keep it safe

• Check the numbers. AI is superb at structure and shockingly confident when wrong. Every figure that leaves your desk still gets your eyes. Fluency includes knowing where the machine can't be trusted.
• Mind the data. Client-identifiable or confidential material belongs in paid business tiers with training off, or gets anonymised first. Set this up once, properly, and it stops being a worry.
• Automate the recurring, not the rare. The payoff lives in the report you build every month, the deck format you reuse every quarter. Automate those first; leave the one-offs alone.

Where to start this week

Pick the single recurring document you resent most. Not five things. One. Spend one focused hour moving it through AI: feed the source material, describe the output you need, iterate until it's 80% there, finish it yourself. Next month, that hour becomes fifteen minutes. That's the whole method, repeated across your week until the admin is automated and the hours are yours again.

The point was never the slides. It's what you do with the reclaimed time: the strategic work that gets noticed, or simply dinner at home.