Microsoft 365 Copilot in Excel

Microsoft 365 Copilot in Excel brings natural-language assistance to spreadsheets — generating formulas, explaining formulas, suggesting analyses, building charts, formatting data. It's particularly useful for the large population of Excel users who know what they want but don't know how to express it in formula syntax.

What Copilot in Excel can do

Explain formulas

Click a cell with a complex formula, ask Copilot "what does this formula do?" — get a plain-English explanation. Useful for inheriting workbooks from departed colleagues or making sense of spreadsheets you didn't build.

Generate formulas

Describe what you want:

• "Calculate the average sales for each region, but only for orders over $1,000."
• "Look up the customer name in the Customers sheet using the Customer ID."
• "Flag rows where the discount is more than 20% of the total."

Copilot proposes the formula. You verify and apply.

Build charts

"Create a column chart of monthly revenue for 2025." Copilot inserts the chart with appropriate axes and labels.

Suggest analyses

For a structured data range or table, Copilot can suggest:

• Useful pivot tables.
• Relevant filters.
• Conditional formatting that highlights interesting patterns.
• Statistical observations ("revenue in the West region is 23% above the trailing 6-month average").

Format data

"Highlight any row where the value in column D is below the average for that column." Copilot generates the conditional formatting.

Sort and filter

"Show only customers in the South region with orders over $5,000, sorted by date." Copilot applies the filter and sort.

Critical constraint: structured data

Copilot in Excel works dramatically better on structured data — formatted as a table (Ctrl+T), with column headers, in a single rectangular range. Free-form spreadsheets with merged cells, multiple regions per sheet, and inconsistent formatting confuse Copilot.

Before using Copilot heavily: clean the workbook. Convert ranges to tables. Use one column per type of data. Remove merged cells where possible.

What Copilot in Excel does poorly

• Very large workbooks (millions of rows) — context limits and performance.
• Cross-sheet logic beyond simple lookups — multi-sheet model navigation is still limited.
• Pivot table manipulation of complex existing pivots — better to generate from scratch.
• VBA / macros — Copilot can suggest formulas but isn't a macro-writing tool.
• Data quality — Copilot can't tell you the data is wrong; it processes what's there.

Patterns that work well

Iterate on formulas

"That formula gives the right total but doesn't exclude null values" → Copilot refines the formula. Iteration is part of the workflow.

Explore an unfamiliar spreadsheet

When inheriting a workbook from someone else, use Copilot to explain key formulas and the overall structure before making changes.

Generate the first version of a chart or analysis

Even if the result needs refining, the first version is faster than starting from scratch.

Combine with natural-language data summarisation

"Summarise the key trends in this data" produces a plain-English overview that's useful for executive emails or report introductions.

What's coming

Microsoft continues to invest in Copilot in Excel:

• Python in Excel integration — Copilot can write Python code for analysis.
• Larger workbook handling — context limits expanding.
• Cross-workbook reasoning — analysis spanning multiple files.

For now, Copilot in Excel is most powerful on focused single-workbook scenarios with well-structured data. As of 2026, that covers a meaningful fraction of real Excel work; the rest remains a hand-built craft.