Copilot in Excel is an AI assistant built into Excel that can draft formulas from plain English, analyse a table of data for trends and outliers, create charts and PivotTables, and clean up data. It can’t handle messy, unstructured data, it needs a Microsoft 365 Copilot licence, and its output always needs checking. Used well, it’s a genuine time-saver.
There’s a lot of hype about AI in Excel, and a fair bit of confusion about what Copilot actually does day to day. This guide gives you the honest version: what Copilot in Excel is genuinely good at, where it falls short, what you need to run it, and how to get useful results.
What is Copilot in Excel?
Copilot in Excel is Microsoft’s AI assistant built directly into the Excel app. You open it from a button on the ribbon and ask, in plain English, for help with your spreadsheet, and it responds inside the workbook: suggesting a formula, summarising your data, building a chart, and so on.
It’s part of Microsoft 365 Copilot (the paid, work-grounded version), not a separate program. Because it sits inside Excel and can read the data in your open workbook, it works with your actual numbers rather than generic examples.
What can Copilot do in Excel?
This is where Copilot earns its keep. On a well-structured table of data, it can:
- Write formulas from plain English. Describe the calculation you want (“add a column that flags orders over $1,000”) and Copilot suggests the formula and can insert it as a new column.
- Analyse your data. Ask for trends, outliers, totals or a summary, and it returns insights, often with a chart or a breakdown to back them up.
- Create charts and PivotTables. Ask for “a chart of sales by month” or “a PivotTable of revenue by region” and Copilot builds it.
- Clean and reformat data. It can help highlight duplicates, standardise inconsistent entries, sort and filter.
- Explain what’s happening. Point it at a complicated formula or dataset and ask it to explain in plain English, which is a great way to learn.
In short, it’s fastest at the things that normally take clicking, remembering syntax, or eyeballing a big table.
What can’t Copilot do in Excel (yet)?
Being clear about the limits is what separates people who get value from Copilot from those who give up on it:
- It needs structured data. Copilot’s analysis works on data formatted as a table or a tidy, table-like range, single header row, no blank rows, no merged cells. Point it at a messy sheet and it struggles or refuses.
- It can be wrong. Copilot can suggest a formula that looks right but isn’t, or misread what you asked. Every output needs a human check, especially anything feeding a decision or a report.
- It’s not a replacement for understanding Excel. The better you know formulas and PivotTables, the better you can direct Copilot and catch its mistakes. It’s a multiplier for skill, not a substitute for it.
- It has limits on scale and complexity. Very large datasets, highly complex models, and niche tasks can be beyond it or unreliable.
- Features change. Microsoft adds and occasionally retires Copilot features, so exactly what’s available shifts over time.
None of this means Copilot isn’t useful. It means you get the most from it when you treat it as a fast, fallible assistant, not an oracle.
What do you need to use Copilot in Excel?
Three things:
- An eligible Microsoft 365 plan with Copilot. The full Copilot-in-Excel experience requires a Microsoft 365 Copilot licence (or another eligible Copilot-enabled plan). It isn’t part of a standard Office subscription by default.
- Your data in a table. Format your data as an Excel Table (Ctrl+T) for the best results; Copilot’s analysis is built around structured ranges.
- A cloud-saved file with AutoSave on. Copilot works best with workbooks saved to OneDrive or SharePoint.
If Copilot isn’t appearing for you, it’s almost always one of these, usually the licence.
Where is Copilot in Excel, and how do you turn it on?
Once your account has an eligible Copilot licence, Copilot appears as a Copilot button on the Home tab of the ribbon in Excel (desktop and web). Click it to open the Copilot pane on the right, then type your request.
If you don’t see the button, check that you’re signed in with the licensed account, that your Office apps are up to date, and that your file is saved to the cloud. There’s no separate download.
How do you write good prompts for Copilot in Excel?
The quality of your result depends heavily on your prompt. A strong Excel prompt names the data, the task, and the output you want. Compare:
- Weak: “analyse this.”
- Strong: “Using the Sales table, show total revenue by region and highlight the two regions with the biggest drop versus last quarter.”
Reference your table by name, be specific about the calculation or view you want, and ask for the format (“as a PivotTable,” “as a new column”). If the first answer isn’t right, refine with a follow-up rather than starting over.
What is the COPILOT function in Excel?
Newer to Excel is the =COPILOT() function, which lets you call AI from inside a cell like any other formula, for example to summarise or categorise the contents of other cells, with results that recalculate as your data changes. It’s available to Microsoft 365 Copilot users and is rolling out over time. It’s powerful for text-heavy tasks (summarising, classifying, extracting), but the same rule applies: check the output before you rely on it.
Is Copilot in Excel worth it?
For people who work in Excel daily, especially with data analysis, reporting or formula-heavy work, Copilot can pay for itself by saving time on formulas, summaries and charts. For occasional Excel users, the licence cost may be harder to justify on Excel alone (though a Copilot licence also covers Word, Outlook, Teams and PowerPoint).
The deciding factor, as with all of Copilot, is skill: teams that learn to prompt it well and know enough Excel to check its work get real value; those who expect it to “just do it” are usually disappointed.
How do you get the most out of Copilot in Excel?
Start with well-structured tables, learn a handful of reliable prompt patterns, and always sanity-check the output against what you know. It also helps to keep building your core Excel skills, because Copilot rewards people who can direct and verify it.
For the bigger picture of Copilot across all your Office apps, see our Microsoft 365 Copilot guide. To use Copilot confidently in real work, our hands-on Microsoft 365 Copilot Essentials course covers Copilot across Excel, Word, Outlook, Teams and PowerPoint with a Microsoft Certified Trainer. And because Copilot multiplies your Excel skills rather than replacing them, pairing it with our Advanced Excel course (and guides like Excel Pivot Tables and the Complete Guide to Microsoft Excel) gets you far more from it.
Frequently asked questions
Copilot in Excel can draft formulas from plain-English requests, analyse a table of data for trends, outliers and summaries, create charts and PivotTables, clean and reformat data, and explain formulas. It works best on data formatted as a table.
Yes. The full Copilot-in-Excel experience requires an eligible Microsoft 365 plan with Copilot, typically a Microsoft 365 Copilot licence added to your subscription. It isn’t included in a standard Office plan by default.
Usually one of three reasons: your account doesn’t have an eligible Copilot licence, your Office apps aren’t up to date, or your file isn’t saved to the cloud. Check the licence first, then make sure you’re signed in and your workbook is on OneDrive or SharePoint.
Yes, as long as the data is structured as a table or tidy range. Copilot can summarise it, spot trends and outliers, and build charts or PivotTables. It cannot reliably analyse messy, unstructured sheets with blank rows or merged cells.
Mostly, but not always. Copilot can suggest a formula that looks correct but isn’t, or misinterpret a request. Always check its output before relying on it, particularly for anything that feeds a report or decision.
There’s nothing to install. Once your account has an eligible Copilot licence, sign in, update your Office apps, and save your workbook to OneDrive or SharePoint; the Copilot button then appears on the Home tab of the ribbon.
