What is Copilot in Excel and what is it good for at work?

Copilot in Excel is a chat pane inside Excel that can change your workbook or analyse it on request. Microsoft's getting-started page lists editing worksheets (adding, renaming or deleting sheets and applying formatting, validation and styles), generating data and formulas across sheets, creating charts, PivotTables and shapes that stay linked to source data, highlighting, sorting and filtering, answering questions with summaries, trends and outliers, searching the web with citations, and saving repeatable tasks as custom skills.

At work that covers the slow parts of spreadsheet jobs: building a summary tab from a raw export, writing a formula you half remember, turning a table into a chart for a meeting, or asking which rows look unusual before you send a report. It does not replace knowing what the numbers mean.

How do I get started with Copilot in Excel?

Open a workbook and select the Copilot icon in the lower-right corner. Microsoft says Copilot in Excel works on Windows, Mac and the web, with fewer modes on iPad, iPhone and Android, and that it may not be included in your Microsoft 365 subscription or may be restricted by your organisation, so ask IT if you cannot see it.

Before you type, choose a mode. Allow editing, the default, changes the workbook directly. Plan proposes steps for your approval first. Chat only gives insights without changing anything. For your first session, use Plan on a copy of a workbook.

A sensible first prompt: 'Add a summary sheet that totals sales by month and region from the Sales sheet, with a chart. Show me the plan first.' You can watch Copilot's steps in the pane and stop it at any point with the Stop button in the chat input field.

What is a good 10-minute Copilot in Excel starter exercise?

Use a fictional regional bakery chain, Oakmere Bakeries. Build a small practice sheet with invented data: about 60 rows with columns for date, shop (four shops), product line (bread, cakes, sandwiches), units and revenue.

Minute 1 to 3: in Plan mode, ask Copilot to add a summary sheet with revenue by shop and product line as a PivotTable, plus a column chart. Read the plan and approve it only if it uses the right columns. Minute 4 to 5: switch to Chat only and ask which shop and product combination looks unusual compared with the others, and why. Minute 6 to 8: pick one figure from the PivotTable and check it yourself with a simple SUMIFS formula on the raw sheet. Minute 9 to 10: ask Copilot to highlight rows where revenue divided by units is outside the normal range, then look at those rows. Some will be your typos, which is a useful lesson in itself.

The habit to build is plan, approve, then verify one number independently. A PivotTable that is wrong looks exactly as tidy as one that is right.

How do I get better results from Copilot in Excel?

Most Copilot in Excel problems come from picking the wrong mode or describing the data loosely. These techniques follow Microsoft's own guidance.

Match the mode to the risk

Use Plan for anything that changes structure, Chat only for questions, and Allow editing only for low-risk formatting or when you have a copy.

Name sheets and columns exactly

Refer to 'the Revenue column on the Sales sheet' rather than 'the numbers', so Copilot reads the range you mean.

Ask for formulas you can read

Ask Copilot to explain each formula it writes in one line, so you can judge whether the logic is right.

Save repeat work as a skill

Microsoft says you can define repeatable tasks as custom skills, which suits a monthly report built the same way each time.

Watch the pane

Copilot shows its reasoning and changes live; stop it as soon as a step heads in the wrong direction.

What should I not put in a workbook with Copilot, and what does Microsoft say about data?

Use Copilot only on workbooks your employer's policy allows, in your work account. Be careful with files that mix sensitive columns, such as salaries or customer personal data, with data you want analysed; split them first if your policy requires it.

Copilot in Excel is covered by Microsoft's data, privacy and security commitments for Microsoft Copilot at work. Microsoft states that prompts, responses and data accessed through Microsoft Graph are not used to train foundation models, that Copilot only surfaces content the user has permission to view, and that interactions in apps such as Excel are stored as Copilot activity history under the organisation's Microsoft 365 commitments, with retention set by admins in Microsoft Purview.

Where does Copilot in Excel fall short?

It edits quickly, which means it can make wrong changes quickly. Microsoft's page stresses that you stay in control of what is modified, but it is still your job to check formulas, totals and chart ranges. Microsoft's wider Copilot documentation also says generative AI responses are not always factual.

Platform support is uneven: Microsoft lists editing on Windows, Mac and the web, with mobile editing still rolling out and only chat mode listed on Android. And Copilot cannot tell you whether your source data is complete; a clean analysis of a partial export is still wrong.

How does Tosheo.ai teach Copilot in Excel inside a role path?

Tosheo.ai teaches Copilot in Excel through spreadsheets from each role: a finance analyst reconciling invented supplier invoices, an operations coordinator building a stock summary, or a marketing manager charting campaign results. Every lesson supplies a fictional workbook, so practice never touches live data.

Lessons take 10 to 15 minutes and end with a task in Excel, marked against a visible rubric that checks mode choice, accuracy and an independent check of at least one figure, with specific feedback. Excel lessons are a natural bridge into the data analytics foundations later in a path. The 7-day free trial needs no credit card.

Sources and scope

Microsoft Support, Getting started with Copilot in Excel, checked 19 October 2026 ↗

Microsoft Learn, Data, privacy and security for Microsoft Copilot, checked 19 October 2026 ↗