Every finance team has the ritual. The books close, the Excel pack is updated, and then someone loses a day to the deck: copy the chart, paste it into PowerPoint, resize it, fix the font that changed itself, repeat fourteen times, and rename the file “Board_Deck_June_FINAL_v4.” The analysis was finished on Tuesday. The rest of the week went to moving it between two programs that sit next to each other on the same taskbar.

This column has so far used AI in a chat window — you bring the file to the tool. This week the tool comes to you. Claude now works inside Microsoft Office itself, as add-ins for Excel and PowerPoint installed from the Microsoft Marketplace, available on paid Claude plans (Pro starts at about US$20 a month; Team and Enterprise plans add admin controls). And the feature that matters for month-end is deceptively simple: the two add-ins share one conversation. What Claude just did in your workbook, it remembers when you switch to your deck.

The copy-paste tax

Be honest about where report week actually goes. Not the thinking — the transfer. Excel holds the numbers; PowerPoint holds the story; and between them sits an hour or three of manual freight: paste-special, stretch, re-title, check the legend, notice the June chart still says May. Every hand-off is a chance for the deck to fall out of step with the workbook — and a board member with sharp eyes will always find the slide where the figure is one version old.

That transfer is exactly the kind of mechanical, rule-following work AI should be doing. The judgement stays with you; the freight goes to the tool.

Excel holds the numbers, PowerPoint holds the story — Claude bridges
them in one conversation. (Branded graphic by PGH Consulting, LLC)

Claude inside the spreadsheet

Open the workbook, open the Claude panel, and ask questions where the data lives: “Walk me through what drove the gross margin change this month.” “Build a variance tab comparing actuals to budget and highlight anything more than 10 per cent off.” Because the add-in reads the workbook directly — the formulas, not just the values — it can explain how a number is built, trace what feeds it, and extend the analysis in place. You are no longer exporting a file, uploading it to a chat, and pasting results back. The work happens in the spreadsheet, and the spreadsheet stays the single source of truth.

The rule from every previous week still stands, and stands harder here: Claude works with your figures. It should analyse, summarise, and reformat them — never invent them. If a cell is blank, the answer is to fill the cell, not to let a tool guess.

The handoff: one conversation, two programmes

Here is the part that changes month-end. With the analysis done in Excel, open the deck and ask Claude in PowerPoint: “Update the monthly performance deck from the June workbook — refresh every chart and figure, keep the layout, fonts, and formatting exactly as they are, and flag any slide where the story has changed, not just the number.”

Because the add-ins share context, Claude in PowerPoint already knows what happened in the workbook — which figures moved, which tab holds the variance analysis, what you flagged as unusual. And because it is template-aware, it reads your existing deck — the slide masters, the fonts, the colours — and makes edits that respect the house style instead of bulldozing it. The fourteen charts refresh in minutes. The file still looks like your file. The hour of paste-and-resize simply disappears, and what is left is the part the board actually pays you for: deciding what the changed numbers mean.

The copy-paste tax: analysis done Tuesday, the rest of the week spent
moving it between two programmes. (Branded graphic by PGH Consulting, LLC)

A note on confidentiality

Management accounts and board decks are among the most sensitive files a business holds, so the standing discipline applies with full force. Use a paid business plan whose terms keep your data out of model training, and check what your organisation’s policy allows before connecting anything — on Team and Enterprise plans your administrator decides whether the add-ins are deployed at all. Strip what the job does not need: names can become roles, customers can become “our largest account,” and anything price-sensitive or deal-related stays out. If a workbook is too confidential to email to an outside consultant, it is too confidential to open a Claude panel beside.

What it will not do for you

A refreshed deck is a draft, not a signed-off pack. Check every figure on every slide against the workbook after any automated update — the one month you skip the check is the month a chart keeps its old axis. The narrative slides still need your “why”: Claude can see that distribution costs ran 14 per cent over budget, but it cannot know about the fuel surcharge or the extra Ocho Rios route, and if you let it guess it will guess fluently. Keep versions: refresh into a copy, not over the only master deck. And expect some friction at the edges — heavily customised charts, embedded objects, and elderly templates can still confuse any tool, so the first month is a supervised run, not a hands-off one.

One plain-English request refreshes the whole deck — template-aware,
so it respects your house style. (Branded graphic by PGH Consulting, LLC)

What to try this week

1. Install the Claude add-ins for Excel and PowerPoint from the Microsoft Marketplace (paid Claude plan required — check with your administrator on a work computer).
2. Open last month’s management workbook and ask Claude to walk you through what drove the biggest change — then check its explanation against what you know.
3. Ask it to build a variance tab comparing actuals to budget, highlighting anything more than 10 per cent off.
4. Open a copy of your monthly deck and ask Claude in PowerPoint to refresh the figures from the workbook, keeping the formatting exactly as it is.
5. Ask it to flag every slide where the story changed, not just the number — then verify each flagged slide against the workbook yourself.

Slides updated, story flagged — the file still looks like your file, and the
changed slide gets your attention. A draft to verify, never a signed-off pack. (Branded graphic by PGH Consulting, LLC)

Work on copies until you trust the workflow, strip out confidential names and price-sensitive details the job does not need, and verify every refreshed figure against the workbook before the deck goes to the board.

Peta-Gaye Hardy is the founder of PGH Consulting, LLC, where she helps finance and operations teams adopt AI in practical, low-risk ways. She writes the weekly AI in Finance & Business column and is based between Jamaica and the United States. Learn more at www.pghconsultinggroup.com. Follow on Instagram @pghconsultinggroup.

Disclosures: This article is informational and does not constitute investment, tax, legal, or accounting advice. AI tools can produce errors and figures should always be verified against source data. Some features described require paid subscriptions — the Claude add-ins for Excel and PowerPoint require a paid Claude plan (Pro starts at about US$20/month) alongside Microsoft Office. The author has no commercial relationship with Anthropic, Microsoft, or any product mentioned and was not compensated by them. Readers should consult a qualified professional before acting.