How to Use Copilot in Excel

What Do You Need Before Starting?

• A Microsoft 365 Copilot (business) or Copilot Pro (personal) license — see our Copilot pricing guide for CAD numbers.
• The workbook saved to OneDrive or SharePoint with AutoSave on — this is the #1 reason Copilot appears disabled in Excel.
• Data in a real Excel table: click inside your range, press Ctrl+T, confirm headers.

How Do You Add Copilot to Excel?

There is no separate install — the Copilot button appears in Excel's Home ribbon automatically once three conditions are met:

1. Your Microsoft 365 admin has assigned a Copilot license to your account (Microsoft 365 admin center → Billing → Licenses), or you subscribe to Copilot Pro on a personal plan.
2. Excel is updated to the current channel build — File → Account → Update Options → Update Now on older installs.
3. The workbook is saved to OneDrive or SharePoint with AutoSave on — the button appears greyed out on local-only files.

How Do You Generate Formulas With Copilot?

1. Click a cell in your table and open the Copilot pane from the ribbon.
2. Describe the column you want: "add a column calculating days between order date and delivery date" or "profit margin as a percentage."
3. Copilot shows the formula with an explanation — read it, then Insert column.
4. Spot-check a few rows. For conditional flags, ask directly: "highlight rows where margin is under 20%."

How Do You Analyze Data and Build Charts?

1. In the Copilot pane, start with "show data insights" for an automatic first pass — trends, outliers, correlations with suggested visuals.
2. Then ask specifics: "sales trend by quarter for each region," "top 5 customers by revenue this year vs last."
3. Click Add to sheet to insert the supporting PivotTable or chart, and verify the numbers against a known total before sharing.
4. For heavier analysis, ask Copilot to use Python in Excel — forecasting, correlation matrices, or cleaning steps run in-sheet without you writing code.

Where Does Copilot in Excel Fall Short?

It analyzes one workbook at a time, inherits your sheet's data-quality problems, and re-prompting the same analysis every Monday is still manual work. If the real goal is recurring reporting — sales, ops, and accounting numbers assembled automatically each week — that's an automated reporting workflow, not a per-seat license.

Copilot in Excel vs ChatGPT: Which Should You Use for Spreadsheets?

Copilot wins when the work happens inside the workbook: it sees your actual cells, writes formulas in place, and builds PivotTables you can keep. ChatGPT (or Claude) wins when the work is about the spreadsheet: designing a model before you build it, explaining a formula someone else wrote, cleaning messy exported data you paste in, or writing a macro. Cost matters too: Copilot for Microsoft 365 is a per-seat add-on on top of a Microsoft 365 subscription, while a single ChatGPT Plus seat is cheaper for occasional spreadsheet help — full CAD numbers in our Copilot pricing guide and ChatGPT pricing guide.

The practical rule for most Canadian teams: analysts living in Excel all day get Copilot seats; everyone else gets a general assistant and borrows an analyst when a workbook needs surgery. Unsure how that maps to your team? Our tool-selection guide walks the whole decision.