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 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.