Microsoft Copilot for Excel: Honest Review and Best Use Cases

Quick answer (updated 1 November 2026): Copilot in Excel is the Copilot button in the lower-right corner of the workbook. If you don't see it, the usual cause is a licence that doesn't include Copilot in the Office apps. Jump to setup, why it's missing or current plans and prices. This review was first written in May 2026; the setup, plan, price and feature facts were re-checked against Microsoft's pages on 1 November 2026.

Microsoft Copilot for Excel is now useful enough that finance teams cannot dismiss it as a demo, but it is still narrower than many buyers assume. Deckary, the agentic AI Excel add-in built for consultants and finance teams, is still the better fit for multi-step workbook work because it follows a read workbook -> plan steps -> write formulas or sheets -> verify output -> ask before destructive edits loop.

For this review, we checked the top 5 Google results for "microsoft copilot for excel" on May 9, 2026, read 9 current Microsoft pricing, support, FAQ, and release-note pages, and mapped Copilot against 11 recurring spreadsheet jobs: formula writing, lookups, cleanup, summaries, charting, PivotTables, workbook edits, multi-sheet reporting, financial modeling, audit checks, and presentation handoff. The top-ranking pages are mostly Microsoft help content and beginner guides. They explain what Copilot can do, but they leave gaps on licensing, workflow limits, and finance-team fit.

If you already pay for Microsoft 365 and mainly need quick formulas, charts, summaries, and light workbook edits, Microsoft Copilot for Excel is worth trying. If your team needs deeper workbook execution or tighter overwrite control, a dedicated tool like Deckary is the better buy.

The infographic below was made in May 2026 and is out of date in two places: Copilot Business now lists at $21 per user per month (the $18 is a first-year promotion), and Microsoft no longer describes Copilot's edits as saved automatically or limited to data in the open workbook. The current plans table was checked on 1 November 2026.

What Is Microsoft Copilot for Excel?#

Microsoft Copilot for Excel is Microsoft's AI assistant inside Excel for formulas, charts, PivotTables, summaries, imports, and workbook edits driven by natural-language prompts.

Microsoft's current Get started with Copilot in Excel page says Copilot in Excel can import data, highlight and filter data, generate and explain formulas, and return insights as charts, PivotTables, summaries, trends, or outliers. That is the clearest description of the core product today.

The more important update is that Microsoft now treats editing as part of the main experience. On the current Edit with Copilot in Excel page, Microsoft says Copilot creates a step-by-step plan, works directly in the workbook, reviews the result, and evaluates whether the output matches your intent. That is much closer to an agent workflow than the older "chat beside a spreadsheet" model.

That said, Copilot is still bounded. When this review was first written in May 2026, Microsoft said editing with Copilot only worked with the currently open workbook and could not access other files, emails, or enterprise data. By 1 November 2026, Microsoft's Get started page lists importing data from other workbooks saved to OneDrive, SharePoint or your computer, and fetching information from the web with citations. The edits still land in the one workbook you have open. For quick Excel tasks, that is fine. For broader workbook research and document-grounded work, it is still a real limit.

One more cleanup point matters because the SERP still includes older walkthroughs. Microsoft's support article for advanced analysis said App Skills were removed from Excel by late-February 2026; by 1 November 2026 Microsoft had retired that article too. So if you land on a guide telling you to open App Skills for Python analysis, that guide is already stale.

Microsoft Copilot for Excel Pricing and Access#

Microsoft Copilot for Excel pricing is simple at the headline level and messy in practice.

Microsoft's current pricing page lists the Microsoft 365 Copilot Business add-on at $21.00 per user per month paid yearly, or $25.20 per user per month with a monthly commitment. The $18.00 figure older guides quote is now a promotion: Microsoft shows it for the first year only, for existing customers with an eligible Business plan who commit annually between 1 July and 31 December 2026. Today the add-on is bought on top of a qualifying Microsoft 365 plan; Microsoft says new purchases won't need that base plan from 1 December 2026 (details in the plans section). Last verified 1 November 2026; the full plan list is in the plans section below.

The access rules matter just as much as the sticker price:

Microsoft's current support pages also make two practical points that many third-party guides bury:

1. If you do not see the Copilot button, Microsoft says it may not be included with your subscription or available because of your organization's settings.
2. Copilot in Excel is listed on Microsoft's support page for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, web, and iPad, so Mac support is real even if rollout timing can vary by feature.

For teams comparing Copilot with dedicated Excel tools, this is where the math gets clearer. Deckary's pricing page lists Premium at $180 per year and says that plan includes both the AI Excel Agent and PowerPoint AI. If your workflow ends in board decks or client slides, that bundle matters more than it would for a general Microsoft 365 deployment. For the product view behind that positioning, see Deckary's AI Excel Agent page.

Where Is Copilot in Excel? Setup on Windows, Mac and the Web#

Copilot in Excel is the Copilot button in the lower-right corner of the workbook. Microsoft calls it the Copilot Dynamic Action Button and says it has consolidated how you open Copilot into this single entry point; you can dock it next to the ribbon if you prefer. There is no add-in to install: if your account is licensed and Excel is current, the button appears on its own.

Each step below links the Microsoft page it comes from, checked on 1 November 2026. We did not sign in to a Copilot tenant for this update, so the steps follow Microsoft's documentation rather than our own screens.

Which Excel versions have Copilot#

Microsoft's Get started page lists these modes by platform:

Copilot opens in edit mode by default, which changes the workbook directly. Plan mode proposes the steps for you to approve first, and chat mode answers without touching the sheet. Perpetual versions such as Excel 2021 or 2024 are not in Microsoft's "applies to" list; Copilot in Excel is documented for Excel for Microsoft 365 only.

How to turn on Copilot in Excel#

1. Check your licence. Sign in to Microsoft 365 with your work account and look at the label under your name: Copilot Chat (Basic), M365 Copilot (Basic) or M365 Copilot (Premium). Only the last two open Copilot inside Excel (What Copilot license do I have). Personal accounts need Microsoft 365 Personal or Family with an AI credits plan, or Microsoft 365 Premium (Copilot in Excel FAQ).
2. Refresh the licence. On Windows go to File > Account > Update License; on Mac choose Excel > About Excel > More Info > Refresh License. Close and reopen all Office apps (missing-button page).
3. Update Excel. Business users on the Semi-Annual Enterprise Channel don't get Copilot features; Microsoft says to move to Current Channel or Monthly Enterprise Channel, and that Excel for the web works in the meantime (missing-button page).
4. Turn on connected experiences. Under the account privacy settings, both "Experiences that analyze your content" and "All connected experiences" must be on. In a managed tenant your IT admin controls these (missing-button page).
5. On the web, allow third-party cookies. Microsoft's requirements page says Copilot in Excel for the web needs them, and the missing-button page says blocked cookies stop Copilot validating your licence.

For prompts and first tasks once the button is there, our guide on how to use Copilot in Excel walks through formulas, PivotTables and edit mode step by step.

Why Copilot is missing in Excel#

When the button isn't there, Microsoft's troubleshooting and requirements pages point to these causes:

• You are looking in the old place. Some older guides point to the Home tab. Microsoft's missing-button page says the button moved: look in the lower-right corner of the grid.
• Your label is Copilot Chat (Basic). You can use Copilot Chat in Outlook and the Copilot app, but not inside Excel. Only an admin can change that by assigning a licence (What Copilot license do I have).
• Your company's update channel is Semi-Annual Enterprise. The licence is there, the feature isn't.
• The licence is assigned to the device, not to you. Microsoft's requirements page says Copilot isn't available with device-based licensing for Microsoft 365 Apps for enterprise.
• Privacy or network settings block it. Connected experiences off, third-party cookies blocked on the web, or a proxy blocking *.cloud.microsoft.
• The file state is unsupported. Microsoft's Excel FAQ lists "Unsupported file state" errors for SharePoint files that require check-out (Excel for the web still works) and for formats such as Strict Open XML. Its Microsoft 365 Premium page says Copilot in Excel requires AutoSave, so the file must be saved to OneDrive.
• You share a Family plan. Microsoft says only the subscription owner can use Copilot in the desktop apps (What Copilot license do I have).

Continue reading: Tornado Charts in PowerPoint · PowerPoint Alignment Shortcuts · Appendix Slide PowerPoint

Microsoft 365 Copilot Plans for Excel Users: Basic vs Premium#

The shortest answer to "Copilot Basic vs Premium": Basic and Premium are labels on your work account, not products you buy. M365 Copilot (Premium) means your admin has assigned a paid Microsoft Copilot add-on licence, with priority access to the full Copilot experience in Word, Excel, PowerPoint and OneNote. M365 Copilot (Basic) means no add-on licence but standard access to Copilot in those apps. Copilot Chat (Basic) means no add-on licence and no Copilot inside Excel at all. Microsoft explains the labels on What Copilot license do I have (page updated April 2026).

To see your label without admin rights, sign in to Microsoft 365 with your work account and scroll to the bottom of the home page; the label sits under your name.

If you need to ask, a short note works: "My Microsoft 365 label reads [label] and Copilot doesn't appear in Excel. Could you check my Copilot licence assignment, whether my device is on Current or Monthly Enterprise Channel, and whether connected experiences and *.cloud.microsoft are allowed for my account?"

The practical difference in Excel, per Microsoft's comparison of Copilot Chat with and without a licence: without the add-on you get standard access that may be limited at peak times, limited work-data grounding (uploaded files) and no advanced agents such as Analyst or Researcher. With it you get priority access, grounding in your meetings, email, chats and files, and the advanced agents. Microsoft's FAQ adds that choosing between Anthropic's Claude and OpenAI's GPT models in Excel needs a commercial Copilot subscription or Microsoft 365 Premium.

Current plans and prices#

Prices are US list prices from Microsoft's own pages. Last verified 1 November 2026.

Three details change the bill:

• The $18 is a promotion. Microsoft's footnote limits it to existing customers with an eligible Business plan, on an annual commitment bought between 1 July and 31 December 2026, for the first year only. The list price is $21.00.
• Some AI features are billed on usage. The business pricing page warns that usage-based features can add charges beyond the licence fee.
• The base-plan requirement ends for new purchases on 1 December 2026. Until then the add-ons need a qualifying Microsoft 365 plan; Microsoft's requirements page still listed one on 1 November 2026. Microsoft's Partner Center announcements for October 2026 say that from 1 December new Microsoft 365 Copilot and Copilot Business offers can be bought without a base subscription, priced the same as today's, and existing subscriptions renew unchanged. Microsoft adds that Copilot experiences "continue to depend on the Microsoft 365 apps and services a customer is licensed for", so you still need a plan that includes Excel.

Microsoft's requirements page says Microsoft 365 Copilot is now named Microsoft Copilot (and Copilot Chat likewise); the pricing pages still use the old names.

Agent Mode and the COPILOT function: where they went#

Two Excel features that many 2025 guides lead with have changed:

• Agent Mode is now the default. Microsoft's Microsoft 365 Premium page says editing with Copilot "was previously known as Agent Mode but is now integrated into the experience", and the Excel FAQ describes edit mode as the default. Microsoft's Copilot Chat in apps page still refers to selecting Agent Mode from the Tools menu for licensed users, so you may see both names.
• The COPILOT function is retired. Microsoft's COPILOT function page says the function is no longer available in Excel from 14 September 2026. It was a preview limited to the Frontier and Microsoft 365 Insider programs. Results already calculated stay in the workbook as cached values, but a cell that recalculates returns #NAME?. Microsoft points users to the Copilot pane for the same jobs, such as classifying text in a column.

If you have workbooks built on =COPILOT(...), paste the cached results as values before anyone recalculates them.

When Microsoft Copilot for Excel Works Best#

Microsoft Copilot for Excel works best when the task starts with a clean table and ends in one or two clear actions.

Based on Microsoft's own documentation, the strongest use cases are:

These are the kinds of prompts Copilot handles well:

• "Create a formula column that calculates gross margin by row."
• "Build a PivotTable showing revenue by region and quarter."
• "Highlight rows where forecast variance is above 10%."
• "Summarize the main trends in this expense table."
• "Create a donut chart for spending by category."

Microsoft's own FAQ for editing with Copilot says this mode is best for tasks that go beyond simple formulas, single PivotTables, or basic charts when you need several steps or an iterative process. That is meaningful, because Microsoft is not pretending every Excel task is a one-shot prompt anymore.

There is also a good middle ground here for managers and analysts. If you are reviewing a budget, scanning survey responses, or turning a clean export into a chart and a quick summary for leadership, Copilot can save real time. It is easier to recommend in management reporting than in model review.

Where Microsoft Copilot for Excel Falls Short#

Microsoft Copilot for Excel falls short when the workbook is messy, high-risk, or spread across several dependencies.

The first issue is scope. Copilot edits the workbook you have open. Microsoft now lets it import data from other workbooks and fetch web information, but each source has to be pulled in and checked inside that one workbook. So if your real task is "reconcile these three versions, check the assumptions sheet, and rebuild the board output," Copilot starts to feel narrow.

The second issue is risk control. Microsoft's FAQ said in May 2026 that editing with Copilot makes direct changes to the workbook, that those changes are saved automatically, and that you should use a copy of a critical or sensitive workbook to protect the original. The current FAQ (checked 1 November 2026) says that once you save Copilot's changes, anyone with access to the file sees them, including people co-authoring, and that you revert by undoing or restoring a prior version. It also says editing only works when Calculation Options are set to Automatic. That is workable, but it also tells you where trust still breaks.

The third issue is precision. In the same FAQ, Microsoft says Copilot can make mistakes, misinterpret information, or produce inaccurate outcomes, and specifically says not to use it for decisions in sensitive areas such as finance, legal, or medical topics without review. For finance teams, that is the sentence that matters most in the whole product pitch.

The fourth issue is feature drift in older tutorials. Microsoft removed App Skills from Excel by late-February 2026, and it says advanced Python-style analysis from that older workflow does not currently have a direct analog inside Copilot itself. If you want deeper analysis now, Microsoft points users toward Analyst rather than keeping that capability inside the old Excel workflow.

This is why spreadsheet benchmark research still matters. The EMNLP 2023 paper InstructExcel: A Benchmark for Natural Language Instruction in Excel includes over 10,000 samples across 170-plus Excel operations and 2,000 public spreadsheets, and the authors describe it as a hard benchmark even for GPT-4. Spreadsheet work is not just language. It is structure, context, and verification.

Microsoft Copilot for Excel vs Deckary#

Microsoft Copilot for Excel and Deckary overlap on the headline promise, but they are built for different depths of work.

For teams already standardized on Microsoft 365, Copilot is a sensible default. It is built into the ecosystem, it can handle a lot of routine table work, and the business case is easier if you are already paying for Microsoft licenses.

For finance and consulting workflows, we recommend Deckary instead. The reason is not that Copilot is weak. The reason is that high-stakes spreadsheet work needs a stronger execution loop and better write control than Copilot currently offers. If your task is "help me with this table," Copilot is enough. If your task is "work through this workbook with me," Deckary is the better fit.

If you want the wider market view before deciding, read Excel AI, AI for Excel, and Best AI for Excel next.

Should You Use Microsoft Copilot for Excel?#

Microsoft Copilot for Excel is worth using if your team already lives in Microsoft 365 and your common jobs are formula help, quick charting, PivotTables, summaries, and light workbook cleanup.

It is not the best choice when your spreadsheet work involves messy inherited files, multi-sheet reconciliation, formal financial modeling review, or controlled output-sheet creation. Those are workbook-agent problems, not just Excel-chat problems.

The practical buying advice is straightforward:

That is the honest read on the product as of May 9, 2026. Microsoft Copilot for Excel is now good enough to matter. It is just not the full answer for every Excel workflow. The setup, plan, price and feature facts on this page were re-checked against Microsoft's pricing, support and Learn pages on 1 November 2026.

FAQ#

What is Microsoft Copilot for Excel?#

Microsoft Copilot for Excel is Microsoft's AI assistant inside Excel for formulas, charts, PivotTables, summaries, and workbook edits using natural-language prompts.

How much does Microsoft Copilot for Excel cost?#

On 1 November 2026 Microsoft listed the Microsoft 365 Copilot Business add-on at $21.00 per user per month paid yearly (with a first-year promotional $18.00 for eligible existing business customers who commit annually between 1 July and 31 December 2026) or $25.20 paid monthly, on top of a qualifying Microsoft 365 plan. Bundles with Copilot start at $23.50 per user per month, and the enterprise Microsoft 365 Copilot add-on is $30.00. For individuals, Microsoft 365 Premium is $19.99 a month.

Does Microsoft Copilot for Excel work on Mac?#

Yes. Microsoft's current support page lists Copilot in Excel for Microsoft 365 for Mac, though some features and rollout timing can still vary by environment.

Can Microsoft Copilot for Excel edit a workbook directly?#

Yes. Copilot in Excel opens in edit mode by default and changes the open workbook directly. Microsoft says saved Copilot changes are visible to anyone with access to the file, including co-authors, and that you can undo them or restore a prior version, so review them carefully.

Is Microsoft Copilot for Excel good for financial modeling?#

It can help with budgets, formulas, and quick model edits, but Microsoft also says not to rely on it for sensitive finance decisions without review.

What is the best alternative to Microsoft Copilot for Excel?#

For consultants, FP&A teams, and analysts who need multi-step workbook execution and stronger overwrite controls, Deckary is the best alternative to Microsoft Copilot for Excel.

Where is Copilot in Excel?#

Copilot opens from the Copilot button in the lower-right corner of the workbook, which Microsoft calls the Copilot Dynamic Action Button. You can move it next to the ribbon. Some older guides point to the Home tab; Microsoft's current pages point to the lower-right button.

How do I add Copilot to Excel?#

There is nothing to install: the button appears in Excel for Microsoft 365 once your account is eligible, meaning a work account whose Copilot label reads M365 Copilot (Basic) or M365 Copilot (Premium), or a personal Microsoft 365 Premium, or Personal or Family with an AI credits plan. If it is still missing, refresh your licence under File > Account and work through the setup steps on this page.

Is Copilot in Excel free?#

Copilot Chat comes at no extra cost with eligible work Microsoft 365 plans, but it only opens inside Excel if your account label reads M365 Copilot (Basic) or (Premium); Copilot Chat (Basic) has no Copilot in Excel. Priority access needs the paid add-on.

What is the difference between Copilot Basic and Premium?#

They are Microsoft's labels for work accounts, not products you buy. M365 Copilot (Premium) means a paid add-on licence with priority access in Word, Excel, PowerPoint and OneNote; M365 Copilot (Basic) means standard access without the add-on; Copilot Chat (Basic) means no Copilot in those apps.

Sources#

• Microsoft Support: Get started with Copilot in Excel
• Microsoft Support: Edit with Copilot in Excel (redirects to Get started with Copilot in Excel on 1 November 2026)
• Microsoft Support: Frequently asked questions about editing with Copilot in Excel
• Microsoft Support: Get advanced data analysis using Copilot in Excel App Skills (article retired by 1 November 2026)
• Microsoft 365 Copilot pricing (checked 1 November 2026)
• Microsoft 365 Copilot release notes
• Microsoft Support: Frequently asked questions about Copilot in Excel (checked 1 November 2026)
• Microsoft Support: How to find and enable missing Copilot button in Microsoft 365 apps (checked 1 November 2026)
• Microsoft Support: What Copilot license do I have (checked 1 November 2026)
• Microsoft Support: How Copilot Chat works with and without a Microsoft Copilot license (checked 1 November 2026)
• Microsoft Support: How Copilot Chat works in Microsoft 365 apps (checked 1 November 2026)
• Microsoft Support: COPILOT function (checked 1 November 2026)
• Microsoft Learn: Microsoft Copilot requirements (checked 1 November 2026)
• Microsoft Learn: Partner Center announcements, October 2026 (checked 1 November 2026)
• Microsoft 365 Copilot enterprise pricing (checked 1 November 2026)
• Microsoft 365 plans for individuals (checked 1 November 2026)
• Microsoft 365 Premium (checked 1 November 2026)
• Deckary pricing
• OpenAI: Introducing ChatGPT for Excel
• OpenAI Help: ChatGPT for Excel and Google Sheets (checked 1 November 2026)
• InstructExcel: A Benchmark for Natural Language Instruction in Excel