The other guides build files from a chat. This one is different: Claude now works inside Excel and PowerPoint, editing real cells and slides in the document you already have open. Here's what changed, how to use it, and which tool to reach for when.
The distinction is the whole story.
Everywhere else in this guide, Claude generates a deliverable: you ask for a Word doc, a dashboard, a deck, and Claude builds one from scratch and hands it back. Useful, but it starts from blank.
The Office add-ins do something the file-generation skills can't: they operate inside a workbook or deck you already have. Claude reads real formulas (not flattened text), traces dependencies across 40 tabs, edits cells directly, and shows you every change. It treats a slide deck as a sequence with a story, not a pile of text boxes. The reason AI was bad at Excel for years wasn't intelligence, it was context. Operating inside the application is the fix.
Claude lives in Microsoft Excel and PowerPoint through Anthropic's official add-ins, a sidebar, not a separate chat window.
Ctrl + Option + C · Windows: Ctrl + Alt + CRequires a Claude Pro subscription ($20/month), the same plan that unlocks Cowork. Confirm the live install steps in Anthropic's docs, since menus shift.
Four jobs the Excel agent does well. Click a cell, then ask.
"Explain this formula in plain English." "Trace this cell to its source inputs." "Why is this #REF?" "Find every broken formula in the workbook." Claude follows the logic across the whole file, not just the cell you clicked.
"Convert all dates to YYYY-MM-DD." "Remove duplicates, keep most recent." "Strip Inc/LLC/Ltd from company names." "Split address into street/city/state/zip." It edits in place and highlights every touched cell so you can audit it.
"What changed this year vs last?" "Which customers drive growth?" "Where are we missing budget?" "Categorize these transactions." You get the insight first; ask for the formulas or pivot only if you want them.
Forecasts, SaaS metrics, scenario and sensitivity tables, IRR/exit models, from scratch, inside the sheet. Not flawless, but it kills the blank-sheet phase. Treat the output as a first draft to pressure-test.
Most AI deck tools treat slides as a text problem: generate bullets, export, clean up by hand. The Office agent reasons about why the deck exists and what story the data tells, then builds real slides in your template. The trick is to make it think before it designs. Run these five prompts in order.
PDFs are the end state of work, invoices, receipts, reports, statements, and generating them used to mean templates, converters, or manual formatting. Now you describe the document and Claude builds the layout, tables, totals, and structure, then returns a finished PDF.
"One-page invoice PDF with line items and totals." "Turn this summary into a formatted report PDF." "Receipt with tax and a final total."
"Pull this PDF table into Excel." The round-trip, data out of a PDF, into a model, back into a clean document, is the part that used to need three tools.
This is the part nobody maps. Claude can touch a spreadsheet or a deck four different ways, and reaching for the wrong one wastes time. Use this:
| You want to… | Use | Why this one |
|---|---|---|
| Edit a live workbook/model that already exists | Claude in Excel (add-in) | Only this edits real cells and traces dependencies in your open file. |
| Generate a fresh, formatted workbook from data or a brief | Cowork xlsx skill | Builds a new .xlsx from scratch with formulas and styling; no Office add-in needed. |
| Edit/restyle an existing deck slide-by-slide | Claude in PowerPoint (add-in) | Works inside your template; keeps layouts and master styles intact. |
| Build a new deck from data with a narrative | Cowork pptx skill or the exec-deck skill | Generates a full .pptx from a spreadsheet; the skill bakes in the blueprint→polish method. |
| A shareable, interactive view of a dataset | CSV → HTML dashboard (Workflow 5) | One self-contained HTML file with filters and charts, opens in any browser. |
| A designed, on-brand deck or page | Claude Design (Step 06) | Image-led visual polish and working code, when look-and-feel is the point. |
| A finished invoice/report/receipt to send | PDF agent or the invoice-pdf skill | Layout, totals, and structure handled; returns a shareable PDF. |
If you run the same Office workflow more than twice, stop re-prompting it. Wrap the method in a skill so one sentence triggers it and your preferences stay baked in. Three to build first:
Encodes the five-step blueprint→polish method on top of the pptx skill. "Build an exec deck from this data" → board-ready first draft.
Forecast / SaaS metrics / scenario / sensitivity / IRR on top of xlsx, with every assumption labeled and cited, and a review checklist.
Structured invoices, receipts, and report PDFs on top of the pdf skill, consistent layout and totals every time.