Claude Took Over Excel & PowerPoint: What Changed

The headline feature is shared context between Excel and PowerPoint. Previously, AI assistants in Office apps worked in isolation. Claude now maintains a single conversation thread across both apps.

This means you can analyze data in Excel, then switch to PowerPoint and say "create a slide deck summarizing what we just found" — and Claude already knows the data, the insights, and the context. No copy-pasting. No re-explaining.

Claude in Excel now supports full spreadsheet functionality:

• Write and debug formulas — describe what you need in plain English
• Create and edit pivot tables — no more dragging fields around manually
• Build charts — native Excel charts from natural language descriptions
• Apply conditional formatting — highlight patterns automatically
• Clean messy data — standardize formats, remove duplicates, fill gaps
• Analyze trends — get insights from your data in seconds

Claude reads your slide masters, layouts, fonts, and color schemes — so it generates slides that match your brand automatically:

• Generate entire slide decks from a brief description
• Maintain brand consistency using your existing templates
• Pull data from Excel directly into charts and tables on slides
• Edit existing presentations — restructure, rewrite, redesign
• Add speaker notes that match the slide content

The update introduces one-click Skills — saved workflows that teams can share across their organization. Anthropic ships prebuilt starter Skills targeting financial services:

• DCF templates — discounted cash flow models built instantly
• LBO models — leveraged buyout analysis on demand
• Investment banking deck reviews — automated quality checks

Teams can also build and share their own custom Skills. Imagine onboarding a new analyst who immediately has access to every workflow your senior team has perfected.

1. Reconcile a messy sales export

You export 2,400 rows from Stripe, half the customer names are duplicated with inconsistent capitalization, and the dates are in three different formats. Ask Claude:

"Clean column B by trimming whitespace and converting to proper case, then normalize all dates in column F to YYYY-MM-DD."

Claude writes the formula chain itself. Behind the scenes it produces something like:

=PROPER(TRIM(B2))
=TEXT(DATEVALUE(F2),"yyyy-mm-dd")

2. Build a churn cohort without a data analyst

Drop a subscription list into Excel, then ask Claude to "build a monthly cohort retention table from columns A (signup_date) and D (cancel_date)." It will generate a pivot table, add a calculated field for months active, and shade the heatmap.

=COUNTIFS(A:A,">="&EOMONTH(M$1,-1)+1,A:A,"<="&EOMONTH(M$1,0),D:D,">="&EOMONTH($L2,-1)+1)

A junior analyst would burn an afternoon writing that. Claude ships it in one prompt.

3. Flag anomalies in a P&L

Paste 18 months of monthly P&L data and ask Claude to "highlight any line item where MoM change exceeds 25% in red." It applies conditional formatting based on the formula:

=ABS((C2-B2)/B2)>0.25

Then it writes a one-paragraph summary of what changed and why it is suspicious. This is the moment most finance leads we have shown realize their week just got 6 hours shorter.

Step 1. Open the PowerPoint template your team uses. Claude reads the slide master — colors, fonts, logo placement.

Step 2. In the sidebar, paste:

"Build a 10-slide deck pitching our Q2 product launch. Audience: enterprise buyers. Use the Excel sheet I opened earlier for the revenue projections. Include a competitive landscape slide and a closing CTA."

Step 3. Claude pulls the live numbers from the Excel tab in the same Claude thread, builds the charts natively in PowerPoint, writes speaker notes, and matches your typography.

Step 4. Refine with one-liners: "make slide 4 more visual," "shorten the bullets to 5 words," "add a slide on pricing tiers between 7 and 8."

Three moves separate teams who get value from this in week one from teams who let the license sit unused:

• Pick one painful workflow first. Weekly board pack, monthly investor update, quarterly forecast. Build a Skill for it before rolling out the add-in broadly.
• Share Skills, not prompts. A library of three vetted Skills beats a Slack channel full of "what prompt did you use again?"
• Set a data boundary up front. Decide which spreadsheets are okay for Claude to see and which stay off-limits. Document it before someone else does it for you.

Pair it with Claude Skills — the feature that makes reusable workflows portable across your whole org — and you have a competitive moat your competitors will not see for months.

Does Claude in Excel work offline?

No. The add-in calls the Claude API in the cloud. You need an internet connection. Your data is encrypted in transit and not used to train Anthropic's models on paid plans.

Can I use Claude in Office on the free plan?

No. The Excel and PowerPoint add-ins require a paid Claude plan — Pro ($20/mo), Team, or Enterprise. The free tier does not include the Office integrations.

What about Word and Outlook?

Anthropic confirmed Word is on the near-term roadmap. Outlook integration has not been announced. For now, copy-paste from Claude Desktop into Outlook is the workaround.

Is this better than just using Claude Code or the Claude Desktop app?

Different use cases. The Office add-ins win when your work lives inside spreadsheets and decks. For coding or research, see our Claude Code vs Cursor vs GitHub Copilot breakdown.

• It will not execute VBA macros. Claude can read and explain them, even rewrite them as Office Scripts, but it does not run legacy VBA in place. If your finance team lives in macro-heavy workbooks, plan a migration.
• External data connections are read-only at launch. Power Query connections, ODBC links, and live SharePoint lists work as inputs, but Claude will not refresh or modify the connections themselves. Expect that in a future release.
• Files above ~50 MB choke the add-in. Anthropic has not published an official ceiling, but in our tests anything past 50 MB or 200,000 rows triggered timeouts. Sample the data first, then ask Claude to scale the analysis.
• It will not version-control your spreadsheet. If you need an audit trail of every change, pair it with SharePoint version history or commit the .xlsx to Git. Claude is a copilot, not a source-of-truth system.