Practical Guide7 min readPublished on 2026-03-19

Claude AI in Excel and PowerPoint: a complete guide for businesses

Claude is now available as a native add-in for Excel and PowerPoint with Opus 4.6: pivot tables, charts, formulas, automated slides, financial Skills and MCP connectors. A practical guide for businesses.

Claude arrives inside Excel and PowerPoint: what changes

Since March 2026, Claude has been available as a native add-in for Microsoft Excel and Microsoft PowerPoint. This is not a sidebar chatbot that suggests text: Claude operates directly inside the file — reading data, modifying cells, creating charts, generating slides and maintaining shared context between both applications within the same conversation.

The underlying model is Opus 4.6, Anthropic's most powerful, with a context window of one million tokens. In practical terms, Claude can have a spreadsheet with thousands of rows and an 80-slide presentation open simultaneously, reasoning across both without losing track.

For professionals in finance, consulting or corporate management, this integration eliminates the most frustrating part of the daily workflow: copy-pasting between tools. Analyze the data in Excel, ask Claude to generate the slides in PowerPoint, and get a presentation that is fully consistent with the numbers you just crunched — all in a single workflow.

What Claude can do in Excel: beyond formulas

Claude's capabilities in Excel go well beyond formula generation. The most immediately useful starting point is pivot table manipulation: Claude can sort, filter, change the layout and restructure a pivot without you having to navigate through menus and sub-menus. Simply describe what you want to see — "show me revenue by geography filtered to clients above 500k" — and Claude executes.

Conditional formatting is another area where Claude saves significant time. Conditional formatting rules, data bars, color scales: operations that normally require several manual steps become a single natural-language request. Claude generates native Excel charts directly from the data, choosing the most appropriate visualization type or following your instructions.

Formula analysis is particularly valuable for anyone who inherits complex spreadsheets built by others. Claude can map cell dependencies, identify circular references, flag logical errors and explain what each formula does in plain language. A CFO who receives a budget model from a controller can ask Claude to perform a complete audit of the spreadsheet's structure in seconds.

MCP connectors: real-time financial data inside Excel

One of the most significant features for the financial world is MCP connectors — connectors based on Anthropic's Model Context Protocol that allow Claude to access external data sources directly without leaving Excel.

The connectors available at launch cover the major financial data providers: S&P Global, LSEG (London Stock Exchange Group), Daloopa, Pitchbook, Moody's and FactSet. In practice, an analyst can ask Claude to populate a spreadsheet with the last five years of financial statements for a listed company, sector multiples from FactSet or credit ratings from Moody's — and Claude imports them directly into the right cells.

This radically changes the research and analysis workflow. Today an analyst opens the Bloomberg terminal, exports data to CSV, imports it into Excel, cleans it and formats it. With MCP connectors, the entire process reduces to a single sentence: "Import income statement data for Enel for the last 5 years from FactSet and calculate the margins." The time saved on each individual analysis accumulates rapidly when you are managing dozens of portfolio companies.

Claude in PowerPoint: presentations that respect your brand

The PowerPoint integration solves a problem that anyone who has worked in consulting or finance knows well: generating presentations that are consistent with the corporate template. Claude does not create generic slides — it reads the slide master of the file, identifies layouts, fonts and color palettes, and generates content that respects your company's visual guidelines.

Claude can build complete presentations from scratch based on a natural-language briefing. You can describe the structure — "create a 12-slide presentation for the board meeting with an executive summary, financial analysis, strategic project update and next steps" — and Claude generates each slide with structured content, well-calibrated bullet points and a coherent narrative from beginning to end.

Even more useful is the ability to edit existing slides. Have a presentation that needs updating with the latest quarterly data? Upload the Excel file with the results and ask Claude to update the relevant slides. Claude identifies which slides contain financial data, updates them with the new numbers and rewrites the commentary accordingly. This is possible thanks to the shared context between Excel and PowerPoint: Claude sees both files in the same conversation and maintains consistency between data and presentation.

Want to discuss with an expert?

30 minutes to discuss your specific case.

Book a call

Skills: reusable workflows for the team

Skills are arguably the feature with the greatest organizational impact. They are predefined workflows that turn a sequence of repetitive operations into an action executable with a single click. Once created, a Skill can be shared with the entire team, ensuring everyone follows the same process and produces output to the same quality standard.

Anthropic has released a set of starter Skills designed for finance. The DCF template automatically generates a discounted cash flow model from historical data, with adjustable assumptions, WACC calculation and sensitivity table. The LBO template builds a complete leveraged buyout model with debt structure, distribution waterfall and IRR calculation. The investment banking deck review Skill analyzes a presentation and checks numerical consistency, section completeness and adherence to market standards.

The most interesting aspect is that you can create custom Skills for your internal processes. A private equity fund can create a Skill that takes an information memorandum, extracts the key data, enters it into the fund's standard Excel model and generates the first slides for the investment committee presentation. An operation that currently requires an entire day of analyst work becomes a semi-automated process to supervise.

Practical use cases: from the CFO's office to consulting

For the CFO and the controlling team, Claude in Excel transforms the budgeting and forecasting process. Upload the monthly actuals, ask Claude to compare them with the budget and the previous forecast, identify significant variances and generate a commentary report. In PowerPoint, Claude produces the slides for the management committee with updated charts and variance commentary — all starting from the same Excel data.

For financial analysts and M&A teams, MCP connectors change the speed of comparable analysis. Building a comparable analysis on 15 companies with up-to-date multiples, financial statements and operating metrics currently takes hours of manual work. With Claude, the analyst describes the selection criteria and the metrics to compare, and Claude populates the spreadsheet by pulling directly from the data sources.

For strategic consultants, the primary value lies in the speed of deliverable production. A consultant can upload workshop notes, ask Claude to structure them into a presentation with appropriate strategic frameworks, generate the slides and then refine them manually. The time to produce a deck is drastically reduced, freeing up hours for analysis and client relationship work.

Availability, plans and cloud platforms

The Claude add-in for Excel and PowerPoint is available to customers on Anthropic's Max, Team and Enterprise plans. For businesses that prefer to go through their own cloud provider, Claude in Excel and PowerPoint is also accessible via Amazon Bedrock, Google Cloud Vertex AI and Microsoft Foundry — which means you can keep your data within your existing cloud perimeter.

Availability across three cloud platforms is an important detail for European businesses with data residency requirements or existing cloud contracts. A company using AWS can activate Claude via Bedrock without opening a new contractual relationship. The same applies to those on Google Cloud or Azure.

The Team plan at $30 per user per month includes access to the add-in, Claude Code and all collaborative features including shared Skills. For larger organizations, the Enterprise plan offers SSO, audit logs, advanced administrative controls and higher usage limits. The choice between plans depends on team size and governance requirements — for a detailed comparison of available plans, the deciding factor is typically the number of users and IT security requirements.

How to get started: the journey with Maverick AI

Activating the add-in is technically straightforward. Making it actually work — with the right Skills, properly configured MCP connectors and a trained team — requires a structured approach.

Maverick AI supports businesses in adopting Claude in Excel and PowerPoint through a three-phase process. In the first phase, we identify the processes that benefit most from the integration: financial reporting, portfolio analysis, board presentation preparation, due diligence. In the second phase, we configure the environment — Claude plan, MCP connectors with your data sources, custom Skills for your internal templates and models. In the third phase, we train the team with hands-on sessions based on the company's actual workflows, not generic examples.

The result we observe in clients who have already adopted Claude for Excel and PowerPoint work is a 50-70% reduction in time spent producing analyses and presentations. Not because Claude replaces intellectual work, but because it eliminates the hours of mechanical work — formatting, copy-pasting, data updating, slide generation — that currently absorb most of the time of analysts and managers.

Want to bring Claude into Excel and PowerPoint at your organization?

We help you configure the add-in, build custom Skills and integrate MCP connectors with your data sources.

Write to us

Want to learn more?

Contact us to find out how we can help your company with tailored AI solutions.

Claude AI in Excel & PowerPoint: Add-in, Skills, MCP Connector & Use Cases 2026 | Maverick AI