Copilot works inside the file — which is exactly why your data structure decides whether it is useful.
The key difference between Copilot and a general AI assistant is location. Copilot runs inside Excel with access to the workbook, so it can act on your data rather than describe what you should do.
What Copilot can do in a workbook
- Answer questions about the data in a table in plain language
- Add a formula column described in words, with the formula written into the sheet
- Create PivotTables and charts from a described question
- Highlight or sort to surface patterns and outliers
- Summarise what a table shows, as a starting point for report commentary
Preparation decides the result
Copilot works best on a properly formed table, and this is the single biggest reason people find it disappointing.
- Convert your range into an Excel Table with Ctrl+T
- Give every column a clear, unique header — 'Invoice Amount', not 'Col3'
- Remove merged cells, blank spacer rows and mid-table subtotals
- Ensure dates are real dates and numbers are real numbers
- Keep one topic per sheet rather than three tables side by side
Copilot vs ChatGPT for Excel work
| Copilot for Excel | ChatGPT | |
|---|---|---|
| Sees your workbook | Yes | No, unless you upload or describe it |
| Can edit the sheet | Yes | No |
| Best at | Acting on structured data in place | Explaining, drafting, planning |
| Requirement | Eligible Microsoft 365 licence | Public or company AI account |
Writing a good Copilot prompt
Add a column called "Margin %" that divides Profit by Revenue, formatted as a percentage with one decimal.
Show total Revenue by Region and Quarter as a PivotTable, sorted highest first.As with any AI output, check the formula it inserts. Copilot writes into your file, so an unchecked assumption becomes part of the workbook.
Frequently asked questions
- Do I need a specific licence for Copilot in Excel?
- Yes. Copilot in the Microsoft 365 desktop apps requires an eligible Microsoft 365 plan with the Copilot capability enabled by your organisation. Availability of individual features changes over time, so confirm against current Microsoft documentation.
- Why does Copilot say it can't work with my data?
- Most often the range is not a proper Excel Table, or it contains merged cells, blank rows or unclear headers. Fixing the structure resolves the majority of these cases.
- Is Copilot better than ChatGPT for Excel?
- They do different jobs. Copilot acts inside the workbook; ChatGPT is stronger for explanation, planning and drafting. Many people use both.
Learn this properly, with a trainer
Advanced Excel with Raj Singh — classroom in Vasai or live online. Batch timings are confirmed when you enquire.
See course options & fees