Copilot in Excel: What It Does and What You Still Need

Copilot in Excel is an AI assistant that turns plain-English requests into formulas, charts, PivotTables and short summaries of your data. It can save time, but it can also be wrong, and whether you have it at all depends on your plan, version and region. This guide explains what it does, where it falls short, and the Excel skills you still need to use it well and to pass a job test without it.

What is Copilot in Excel?#

Copilot is Microsoft's AI assistant built into Microsoft 365 apps. In Excel, you open it from the Copilot button on the Home tab, type a request in a side pane, and it replies with a suggestion you can accept, change or ignore.

You might type requests like these:

• "Add a column that shows profit as revenue minus cost."
• "Which region had the highest sales in March?"
• "Highlight orders over 1,000."
• "Make a PivotTable of revenue by product."
• "Explain this formula."

Copilot reads your sheet, decides what to do and shows the result. Usually you still click to insert it, so you stay in control of what changes.

Who can use Copilot in Excel?#

Access depends on your Microsoft 365 plan, the Excel version you use and where you live. Microsoft has offered Copilot through different routes for home and business accounts, and it changes the details often. That is why this guide doesn't list plans or prices.

To find out what you have:

1. Open Excel and look for the Copilot button on the Home tab.
2. If it is missing or greyed out, check which account you're signed in with.
3. Read Microsoft's current Copilot help page for your plan.

Microsoft's requirements have also included things like saving the file to OneDrive or SharePoint with AutoSave on. These can change too, so treat the help page as the final word. Your Excel version matters as well: see Excel 365 vs Excel 2021 vs 2019 for how the versions differ, and Excel desktop vs Excel for the web if you work in a browser.

What can Copilot do in Excel?#

Copilot handles four main kinds of work. Each one saves typing, but each one still needs a human check.

Microsoft keeps adding features. For example, it has been testing a COPILOT function that runs a prompt from inside a cell. If you read about a feature online, check that your own version has it before you plan around it.

Some of this overlaps with older built-in tools. Flash Fill can split or join text from one typed example, and Quick Analysis adds totals, charts and data bars in two clicks. Neither needs Copilot.

How to get better answers from Copilot#

Copilot gives better results when your data is easy to read. A few habits help a lot:

• Format the data as a table. Select it and press Ctrl+T (Mac: ⌘T). Tables give every column a clear name and a clear edge.
• Use one header row with clear names. "Revenue" is better than "Col F" or a merged two-row header.
• Keep one record per row. No blank rows, no subtotal rows in the middle, no notes typed into the data.
• Be specific. "Total revenue for West in Q1" works better than "how are we doing?".
• Ask for the formula, not just the answer. A formula can be checked. A number on its own can't.

Why you still need to check Copilot's work#

Copilot can give a confident answer that is wrong. It might read the wrong column, miss rows, treat text that looks like numbers as text, or summarise a trend that isn't really there.

The fix is simple: check the key numbers with your own formula. Say you ask for the average West order and Copilot replies 620. On the exercise data, you would check it like this:

=AVERAGEIF(A2:A8,"West",C2:C8)

The West rows are 600, 450 and 720, so the true average is 590, not 620. A check like this takes ten seconds and catches the mistake before it reaches a report.

Good checks to keep in mind:

• Totals: SUM or SUMIFS should match any total Copilot gives.
• Counts: COUNTIF or COUNTIFS should match any count.
• PivotTables: the grand total should match a SUM of the source column.
• New formula columns: test two or three rows by hand.

What Excel skills do you still need?#

You still need the core skills, because you can't judge an answer you couldn't produce yourself. These are the ones that matter most next to Copilot:

1. Clean data structure: tables, headers, one record per row.
2. Core formulas: SUM, AVERAGE, IF, SUMIFS, COUNTIFS and a lookup such as XLOOKUP.
3. PivotTables: so you can read, fix and rebuild what Copilot creates. The PivotTables 1 lesson covers the basics.
4. References: relative and absolute references, so you can tell when a suggested formula will break as it's filled down.
5. Checking habits: spot-checking totals and reading formulas line by line.

The Excel skills checklist lists what employers commonly expect at each level. Not sure where you stand? The Excel level test gives you a quick starting point.

Copilot and Excel job tests#

Timed Excel tests in hiring usually check what you can do yourself, and many run in a test environment without AI help. Interviewers may also ask you to explain how a formula works. Copilot can help you learn, but it can't sit the test for you.

A good way to use it while you study: try a task yourself first, then ask Copilot how it would do it and compare. If the answers differ, work out which one is right. That builds the judgement that both tests and real jobs need. When you're ready, try a timed basic Excel test without any help.

Practise it#

Start with the exercise on this page: check Copilot's 620 with AVERAGEIF. Then take the basics skill check to fix and calculate a real order sheet with no hints, and practise PivotTables in a live spreadsheet so you can check any summary Copilot builds. Each lesson checks your answer instantly.