Somebody just forwarded you a 47-tab workbook. The senior who built it left the company two roles ago. The deadline is tomorrow morning. And you still cannot remember the syntax for INDEX-MATCH.
That is the moment Microsoft Copilot in Excel was actually built for. Not the demo where someone asks for “a quarterly summary” and a beautiful chart appears. The real moment, where you are staring at a sheet of numbers somebody else built and you need to make sense of it before a meeting in twenty minutes.
Here is the thing most coverage misses: Copilot in Excel changed a lot in the last six months. Agent Mode went generally available in April 2026. Plan Mode rolled out in May. The =COPILOT() function now lives inside cells like any native formula. And Python runs inside Edit with Copilot for the analyses that used to need a data scientist.
Let us break down what corporate workers can actually do with it today, without learning a single Excel formula.
What Changed in 2026 (So You Are Not Reading 2023 Advice)
Copilot in Excel today looks very different from the version that shipped at launch. Four things matter if you have not opened it in a while.
Agent Mode went generally available across Word, Excel, and PowerPoint on April 22, 2026. It lets Copilot take multi-step, app-native actions directly in your workbook, from formulas to tables to visuals, while you stay in control.
Plan Mode rolled out in May 2026. Before Copilot edits your workbook, it lays out a step-by-step approach, shows which data it plans to use, and waits for you to approve or adjust the plan. Nothing changes until you sign off.
The =COPILOT() function brings AI into the calculation engine itself. You type a prompt inside a cell, reference your data, and Copilot returns results that recalculate automatically when the underlying data changes. Think of it as XLOOKUP for natural language.
Python in Edit with Copilot went live in April 2026 across Windows, Mac, and web. You can ask Copilot to run advanced statistical analysis or build predictive charts without leaving your workbook. It writes and runs the Python behind the scenes.
Underneath all this, Microsoft now offers model choice. OpenAI’s GPT-5.5 and Anthropic’s Claude Opus 4.7 are both available inside Excel for users on Microsoft 365 Premium or the Enterprise Copilot license.
What It Costs in 2026
Pricing is messier than it should be. Here is the short version a corporate buyer needs.
- Microsoft 365 Copilot Business is $18 per user per month on annual commitment through June 30, 2026, then it moves to $21. It works for organisations up to 300 users and requires any qualifying Microsoft 365 Business plan.
- Microsoft 365 Copilot Enterprise is $30 per user per month on annual commitment and requires E3, E5, Business Standard, or Business Premium underneath. This tier unlocks Researcher and Analyst reasoning agents and model choice.
- Microsoft 365 Premium for individuals is $199.99 per year, replacing the old Copilot Pro plan. It is the only way for a solo professional to get the full Copilot experience inside Office apps.
- Copilot Chat is free for anyone with a qualifying Microsoft 365 subscription, but it does not include the in-Excel editing experience this article walks through.
If your company already pays for Microsoft 365, the Copilot add-on is what you actually need to use the eight things below. Free Copilot Chat will not cut it.
The Four Ways Copilot Shows Up in Excel
You will see Copilot in four places once you have a license. Each one does a different job.
- The sidebar. Open Excel, click the Copilot button on the Home ribbon. A panel opens on the right. You ask questions in plain English. Copilot reads your active table and answers.
- The =COPILOT() function. Type
=COPILOT("your prompt", A2:A100)inside any cell. Results spill into adjacent cells and recalculate when your data changes. - Formula AI in the formula bar. Type
=in any cell and Copilot suggests the right formula based on your column headers and nearby data. If nothing fits, click “Ask Copilot for a formula” and describe what you want in words. - Agent Mode. Inside the sidebar, switch from Chat to Allow editing. Now Copilot can take multi-step actions on your workbook, not just describe them.
For most of what follows, the sidebar in Agent Mode is the answer.
Eight Real Things You Can Do Without Knowing a Single Formula
1. Clean a Messy CSV Export in Two Minutes
Your CRM exports customer data with mixed case, extra spaces, inconsistent country names, and date columns that arrived as text. The traditional fix is Power Query plus an hour you do not have.
Open the file. Click into the table. Open the Copilot sidebar in Agent Mode. Try:
“Clean this dataset. Trim whitespace, standardise the Country column so ‘USA’, ‘United States’ and ‘U.S.’ all become ‘United States’, and convert the Order Date column from text to actual dates in YYYY-MM-DD format.”
Copilot reads the table, plans the cleanup, shows you what it will change, and waits for approval. You hit Apply. Done. The cleaned dataset replaces the messy one and the changes are highlighted for one turn so you can revert if anything looks off.
2. Build a Pivot Table Without Touching the Menu
The PivotTable dialog has intimidated office workers since 1995. You do not need it anymore.
“Create a pivot table that shows total revenue by product category by quarter. Put quarters across the top, categories down the side, and add a grand total row.”
Copilot generates the pivot table on a new sheet with the right rows, columns, values, and grand totals. You can then ask it to add a filter, swap dimensions, or convert the pivot into a chart, all in plain English.
3. Write Any Formula in Plain English
This is the one that changes daily life for non-Excel people.
Click any empty cell. Type =. Click “Ask Copilot for a formula”. Then describe what you want:
“Calculate the total profit for orders shipped to Germany in Q3 2025, but only count orders where the discount was less than 10 percent.”
Copilot returns a working formula (something like =SUMIFS with multiple conditions), shows a preview of the result, and explains in one line what the formula does. You click Keep and it stays in the cell.
The same workflow handles year-over-year growth, running totals, percentile rankings, and lookups across two tables. You never have to remember a function name again.
4. Highlight What Matters With Conditional Formatting
You have a sales sheet. You want underperformers in red, top performers in green, and rows where the close date is in the past but the status is still “Open” in yellow.
“Apply conditional formatting to this sheet. Highlight rows in red where Revenue is below $10,000, green where Revenue is above $50,000, and yellow where Close Date is before today but Status is still ‘Open’.”
Copilot applies all three rules at once. You did not open a single dialog box.
5. Generate a Chart From a Sentence
You need a slide for tomorrow morning. The data is in Excel. Skip the Insert Chart dance.
“Create a bar chart that compares revenue by region for the last four quarters. Use our brand colours and put the chart on a new sheet called ‘Charts’.”
Copilot picks the right chart type, builds it natively in Excel (not as an image), and places it where you asked. If the chart looks wrong, you describe the fix in plain English and Copilot adjusts it.
6. Summarise 500 Lines of Customer Feedback With One Formula
This is where the =COPILOT() function earns its keep. You have a column of free-text customer reviews from cells D2 through D501. You need a quick summary for the product meeting.
In an empty cell, type:
=COPILOT(“Summarise the main themes in these reviews in five bullet points”, D2:D501)
The summary spills into the cells below the formula. If a new review lands in D502, the summary recalculates automatically. No Power Query, no external tool, no copy-paste into ChatGPT.
7. Categorise 2,000 Support Tickets in Under a Minute
Same function, different prompt. You have 2,000 free-text support tickets in column B and you need each one tagged as Billing, Technical, Account, or Other so the ops manager can route them.
=COPILOT(“Classify each ticket into one of these categories: Billing, Technical, Account, Other”, B2:B2001)
Copilot returns a category for each row, spilled into the adjacent column. The function works up to 100 calls per 10 minutes and 300 per hour, and passing a whole range counts as a single call, so 2,000 tickets in one shot is fine.
Sentiment scoring, language detection, intent classification, and PII tagging all work the same way. This is the use case enterprise teams underestimate the most.
8. Build a Monthly Performance Report End to End
Most monthly reporting work is the same loop: pull data, clean it, summarise, pivot, chart, write a commentary, paste into a doc. Agent Mode collapses that loop.
“Take the raw sales data on Sheet1. Clean it, drop any rows missing Region or Revenue, then build a one-page monthly summary on a new sheet called ‘Report’. Include total revenue, MoM growth, the three best and worst-performing regions, and a chart showing weekly revenue trend. Write a three-sentence commentary at the top explaining what changed versus last month.”
Plan Mode shows you the seven or eight steps Copilot intends to take before it starts. You approve the plan. Copilot executes. You review the highlighted changes. What used to take ninety minutes fits inside ten.
Two Power Moves Worth Knowing
Plan Mode for High-Stakes Edits
When you are about to ask Copilot to rebuild a real model, click Plan in the menu above the prompt box. Copilot lays out the full step-by-step approach in advance: which sheets it will touch, which formulas it will write, which cells it will overwrite.
You can edit the plan before anything runs. This single feature is the difference between trusting Copilot with your live forecast and trusting it only with throwaway analysis.
Work IQ Context
If you are on the Enterprise tier, Copilot in Excel can pull context from your emails, meetings, chats, and other files when it edits your workbook. Ask it to build a sales forecast and it can quietly factor in the deal updates from your last sales call without you pasting anything in.
This is the feature that most quietly changes how teams work, because the model edits are no longer made in a vacuum.
How To Turn It On This Week
Step 1: Check What License You Have
In Excel, go to File > Account. Look for “Microsoft 365 Copilot” in the subscription list. If you see it, skip to Step 3. If not, continue.
Step 2: Buy or Request The License
If you are on a personal Microsoft 365 plan, upgrade to Microsoft 365 Premium at $199.99 per year. If you are on a business plan, ask your IT admin to add Microsoft 365 Copilot Business or Enterprise to your account. SMB teams should move before June 30, 2026 to lock in the $18 promotional rate.
Step 3: Open The Sidebar
Open any Excel file. Click anywhere inside your data table. Click the Copilot button on the Home ribbon, or press Alt+Q on Windows. The Copilot sidebar opens on the right.
Step 4: Switch To Allow Editing
Above the prompt box, you will see a Chat / Edit switcher. Toggle to Allow editing if you want Copilot to make changes, not just answer questions.
Step 5: Try The Pivot Prompt First
The single best first prompt is: “Build a pivot table summarising this data and pick the most useful breakdown.” Watch what it does. You will learn more in two minutes than from any tutorial.
Step 6: Bookmark The COPILOT Function
The =COPILOT() function is hidden in the formula bar, not the ribbon. Type it in any cell with a prompt and a range. Once you have used it for sentiment analysis or classification, you will reach for it weekly.
Honest Limitations Worth Knowing
A few things to be clear about before you trust Copilot with anything that ships externally.
- Numerical calculations. The =COPILOT() function is for semantic and exploratory tasks. For anything that needs to be deterministically accurate, use native Excel formulas like SUM, AVERAGE, IF, and XLOOKUP. Copilot can write them, but the result should be a formula, not a model output.
- Audit and compliance. AI-generated edits in financial models can hide their reasoning. For audited workbooks, regulated filings, or board-grade financial output, treat Copilot as a draft assistant and validate every change manually.
- Live web and internal documents. The =COPILOT() function does not browse the web or read other files. It only sees the cells you reference. If you need it to use a policy document or a CRM export, paste the data into the workbook first.
- Free tier limits. Free Copilot Chat is helpful for general questions but cannot edit your spreadsheets. The eight use cases above require a paid Copilot license.
- The good news on data. Microsoft has confirmed prompts and data supplied to the =COPILOT() function are not used to train AI models. Enterprise data protection applies on commercial plans.
Why This Matters For Corporate Workers Right Now
The skill gap that used to define spreadsheet-heavy jobs is collapsing. The senior analyst who could write a forty-nested IF statement from memory is no longer the only person who can do that work. The junior who can describe an outcome clearly in a sentence now sits a lot closer to the analyst’s output.
That is not a threat to either of them. It is a new floor. Operations managers in Frankfurt, finance analysts in Singapore, consulting associates in New York, and small business owners in Bangalore all gained the same capability the same week. The competitive question is no longer “do you know Excel”. It is “do you know how to describe what you need with enough clarity for Copilot to deliver it on the first try”.
The best way to learn that skill is to open the file on your desktop that has scared you for six months, switch to Allow editing, and ask Copilot to explain what the workbook does. Then watch what comes back.
That is the headline.
If this saved you from a Sunday-night reporting marathon, share it with the colleague who keeps saying their Excel sheet is too complicated to explain.
Sources and further reading
- Microsoft 365 Insider Blog, A more discoverable Copilot experience in Word, Excel, and PowerPoint (May 13, 2026).
- Microsoft 365 Blog, Copilot’s agentic capabilities in Word, Excel, and PowerPoint are generally available (April 22, 2026).
- Microsoft Community Hub, What’s New in Microsoft 365 Copilot, April 2026 (covers Plan Mode rollout).
- Microsoft Support, COPILOT function.
- Microsoft Community Hub, What’s New in Excel, April 2026 (Python in Edit with Copilot).
- Microsoft Community Hub, What’s New in Excel, March 2026 (Claude Opus 4.6 model availability).
- Microsoft, Microsoft 365 Copilot plans and pricing.
- Copilot Experts, Microsoft Copilot pricing for small business (April 2026).
- Microsoft Community Hub, Write formulas with natural language using Copilot in Excel.
- Neowin, All new features Microsoft added to Excel in April 2026.
- Computerworld, 11 cool things Copilot can do in Excel.
- Microsoft, Easy data analysis with Copilot in Excel.
- Excel University, COPILOT function in Excel.
- Microsoft 365, Work IQ context in Microsoft 365 Copilot.
- Forvis Mazars, Excel Copilot function: AI-powered formulas for smarter data analysis.
Just Being Resourceful! 
Leave a comment