Claude Inside Excel and PowerPoint: AI in the Documents You Already Make
A plain-English look at the Claude for Excel and Claude for PowerPoint add-ins: what they actually do inside your existing files, a real reporting workflow before and after, and a prompting habit that gets noticeably better results out of both.
Four weeks into this series we've covered Cowork (Claude working on your files in the background), Claude in Chrome (Claude working inside the browser tabs you're already logged into), and how to pick a model without overthinking it. This week is about something more specific: Claude sitting directly inside the two documents most businesses actually run on, Excel and PowerPoint.
The short version
- Claude for Excel and Claude for PowerPoint are add-ins from Anthropic that open as a panel inside your existing workbook or deck.
- Both are generally available on Claude Pro, Max, Team and Enterprise plans, installed from Microsoft AppSource or deployed by an admin.
- In Excel, Claude answers with clickable cell citations, changes assumptions without breaking formulas, traces errors and builds models.
- In PowerPoint, Claude builds inside your own template, edits single slides and turns bullet points into editable charts.
- The two share context, so one conversation can carry numbers from a workbook into a deck.
- Review the output before it reaches a client, and be careful with files from outside your business.
Claude for Excel: working inside the actual workbook
Claude for Excel is an add-in. It isn't a separate app you copy data into, but a panel that opens alongside your actual spreadsheet. It's generally available now on Pro, Max, Team and Enterprise plans, installed from Microsoft AppSource or rolled out organisation-wide by an admin through the Microsoft 365 Admin Center.
Once it's open, you can ask it questions about the workbook in front of you and get answers with cell-level citations you can click to jump straight to the source. "Walk me through how the revenue number in cell C42 is calculated" gets you an actual trail, not a guess. It can adjust assumptions while keeping formula relationships intact ("flex the growth rate from 5% to 10% and show me the impact on terminal value"), track down the root cause of a #REF! or #DIV/0! error, and build a new model or populate an existing template from a plain description. It also handles native Excel mechanics directly (sorting, filtering, pivot tables, conditional formatting) rather than just telling you how to do it yourself.
The benefit: for a business owner who isn't a trained analyst, this turns "someone needs to check why this number is wrong" into something you can ask the spreadsheet itself, with a citation you can verify rather than a confident-sounding answer you have to take on faith.
Claude for PowerPoint: your template, filled in or fixed
Claude for PowerPoint, also generally available on the same plans, works the same way but inside a deck. It reads your existing template (slide master, fonts, colour scheme) and builds within those rules rather than handing you something off-brand. You can generate a full deck structure from a description ("build an internal project update with a timeline and next steps"), make a pinpoint edit to one slide without regenerating the rest ("simplify the text on slide 3, it's too dense"), or turn a block of bullet points into an actual editable chart or diagram rather than a static image.
The benefit: the usual AI-deck problem is output that looks generic and needs a full redesign pass before it's usable. Because this version reads your actual template and produces native, editable PowerPoint elements, what comes out is something you can keep tweaking in PowerPoint itself, not something you have to rebuild.
Claude for Excel and Claude for PowerPoint have the full feature lists and setup steps if you want to see exactly what each can and can't do before installing.
Using Claude for Excel and PowerPoint together for monthly reporting
The part that matters most for reporting: Claude for Excel and Claude for PowerPoint share context, along with Word and Outlook, so one conversation can span an open workbook and an open deck at the same time.
Take the recurring task plenty of businesses already do by hand every month: a finance or operations summary deck built off a spreadsheet. The old way is pulling the latest numbers out of the workbook, rebuilding the chart in the deck, rechecking everything against the spreadsheet after a late correction, and reformatting whatever broke. With both add-ins open, you can instead ask Claude directly: "pull the Q3 regional numbers from this workbook into a bar chart on slide 4, matching the deck's existing template". It carries the numbers across without you retyping or re-exporting anything, and produces a chart you can still click into and adjust afterwards.
The benefit: the monthly reporting slog stops being "redo the deck from scratch every time the numbers move" and starts being "point Claude at the current numbers and check its work". That's a much smaller task, and you end up with the same document you'd have built anyway.
A prompting habit that gets better results from both add-ins
One thing worth deliberately practising here: be specific about exactly what you want changed and in what format, rather than giving a general instruction. "Clean this up" invites Claude to guess what you mean. "Update cell C14 to 8% and show me which other cells change as a result" tells it precisely what to do and what to report back.
There's also a setting worth using once rather than repeating every time. Both add-ins have an Instructions field in the sidebar Settings where you can set standing preferences: "format numbers with thousand separators", "always bold column headers", a currency or locale default, or a house style for decks. It applies to every conversation in that app from then on. Instructions set in Excel only apply in Excel, and the same goes for PowerPoint, so it's worth setting both once rather than restating preferences in every prompt.
The benefit: five minutes spent setting standing formatting preferences saves you correcting the same small thing every single time you use either add-in afterwards.
Limitations and security: what to check before you rely on it
Two things Anthropic is upfront about, and worth repeating here rather than discovering the hard way. First, neither add-in is recommended for final client deliverables or audit-critical calculations without a human actually reviewing the output. Treat what it produces as a strong first pass, not a finished one.
Second, there's a real security consideration. A spreadsheet or deck template from an external source (a vendor file, a downloaded template) can contain hidden instructions, known as prompt injection, designed to manipulate the add-in into extracting or changing data without you realising. Claude will ask you to confirm before running anything risky, so it's worth actually reading those confirmations, especially on files you didn't create yourself.
The benefit: knowing this upfront means you get the speed without the surprise. Review what changed, and be a little more careful with files from outside your own business.
Bringing it together
Cowork handles the background work, Chrome handles the browser, model choice handles the balance of cost and quality, and now Excel and PowerPoint handle the two documents most reporting and client work actually lives in. None of it replaces checking the output. All of it cuts down how much of each document you're building from a blank page.
Next week we're looking at how Claude connects directly to the other software your business runs on: MCP and connectors, explained without the acronym soup. If getting Claude properly set up inside your own Excel and PowerPoint workflow sounds like more time than you have to spend figuring out, that's the kind of thing I help you with, on-site across Sydney, the Central Coast and Newcastle. Book a call and we'll talk it through.
Claude for Excel and PowerPoint: common questions
What is Claude for Excel?
Claude for Excel is an add-in from Anthropic that opens Claude in a panel inside your Excel workbook. It can explain how a number is calculated with clickable cell citations, change assumptions without breaking formula links, trace errors such as #REF! and #DIV/0!, build or fill in models, and handle sorting, filtering, pivot tables and conditional formatting.
What is Claude for PowerPoint?
Claude for PowerPoint is an add-in from Anthropic that works inside your deck. It reads your template's slide master, layouts, fonts and colour scheme, builds full decks or edits a single slide, and turns bullet points into native, editable PowerPoint charts and diagrams rather than static images.
Which Claude plans include Claude for Excel and Claude for PowerPoint?
Both add-ins are generally available on Claude Pro, Max, Team and Enterprise plans. Using them counts towards the usage limits of your existing Claude account.
How do I install Claude for Excel and Claude for PowerPoint?
Install the Claude for Microsoft 365 add-in from Microsoft AppSource, open Excel or PowerPoint, activate the add-in and sign in with your Claude account. Admins can deploy it to a whole organisation through the Microsoft 365 Admin Center.
Which versions of Excel and PowerPoint does it work with?
It works in Excel and PowerPoint on the web, on Windows with a Microsoft 365 subscription, and on Mac (version 16.46 or later). It doesn't run on iPad, Android, or the 2016 and 2019 perpetual-licence versions of Office.
Can Claude move numbers from an Excel workbook into a PowerPoint deck?
Yes. Claude for Excel and Claude for PowerPoint share context with each other, and with Word and Outlook, so one conversation can pull figures from an open workbook into a chart on a slide in your open deck, matching the deck's existing template. Check the numbers before the deck goes out.
Is it safe to use Claude for Excel and PowerPoint with files from outside my business?
Take care. Files from external sources, such as vendor spreadsheets or downloaded templates, can contain hidden instructions (known as prompt injection) designed to make the add-in extract or change data. Claude asks you to confirm risky actions, so read those confirmations, and only use the add-ins with files you trust.
Where does Mat Tower provide on-site AI automation services?
Mat Tower works on-site directly in your office across Sydney, the Central Coast and Newcastle. For clients outside these regions, travel arrangements can be built transparently into the project scope.