The Truth / scorecard

Excel Copilot: brilliant analyst, terrible mind-reader

"Genuinely powerful on clean tables, nearly useless on the workbooks your company actually has."

6/10
Best for: Analysts working in clean, table-formatted data who want statistical firepower without writing Python Skip if: Your workbooks are 'formatted for humans' — merged headers, multiple tables per sheet, color-as-data updated June 2026

What's genuinely good

  • Advanced analysis (Python-backed) does real statistics — regressions, outlier detection, scenario modeling — in plain English
  • Formula generation and explanation is excellent, including for formulas someone else wrote in 2019
  • Conditional formatting, sorting, and column-adding from natural language works reliably
  • Workbook documentation — 'explain what this sheet does' — is a legitimately underrated superpower for handoffs

What sucks

  • Requires data formatted as a proper table for most operations — which describes almost no workbook in the wild
  • Struggles with merged cells, multi-row headers, and the 'human-formatted' layouts that dominate real businesses
  • Cross-sheet reasoning is weak: it sees the sheet you're on far better than your workbook as a whole
  • Can't touch most of what makes Excel Excel: pivot table manipulation is limited, charts beyond basics get ignored, VBA is invisible to it
  • Fails silently into generic advice when it can't read your layout — it rarely says 'I can't parse this'

The honest assessment

Excel Copilot has the widest gap in all of M365 between demo performance and Monday-morning performance — and the reason is structural, not a bug that’s getting patched away.

The demo shows a pristine table: one header row, typed columns, no merges. On that input, Copilot is genuinely impressive — ask for drivers of churn and it’ll run a real analysis, show its Python, and hand you defensible numbers. The “advanced analysis” mode is the closest thing to a free data analyst that exists in mainstream software.

Your company’s workbooks look nothing like that. They have three tables per sheet, a title in merged cells across A1:F1, subtotal rows mixed into data, and a color-coding scheme that means something to Brenda. Copilot reads those layouts the way you’d read a shredded newspaper — and instead of saying so, it slides into generic advice that sounds like analysis. That silent degradation is what burns trust: people can forgive “I can’t read this,” but they remember the time it confidently summarized the wrong region’s numbers.

The workarounds that change the score

If you internalize three habits, Excel Copilot jumps from a 6 to a personal 8:

  1. Make Copilot fix its own blocker first. Before anything else: “Convert this range to a formatted table, give every column a descriptive header, and flag mixed-type columns.” This one prompt converts your data into the only format Copilot reads well — using Copilot to do it.
  2. Say “advanced analysis” when you mean analysis. The phrase routes you to the Python-backed path, which is dramatically stronger than the default for anything statistical. If you didn’t see code, you got the weak path.
  3. Treat it as a formula consultant, not a summarizer. “Add a column that flags X” and “explain this formula” are its most reliable skills. “What are the insights in this workbook?” is its least. Aim your questions at the strong skills.

What Microsoft won’t tell you

  • The table-formatting requirement is the single most common cause of “Copilot is useless” verdicts in Excel — and it appears nowhere in the marketing. Teach it in your rollout or watch licenses go unused.
  • Results depend on workbook hygiene built years before Copilot existed. Orgs with disciplined data habits get magic; orgs without get a shrug. Copilot didn’t create the difference — it exposes it.
  • The audit trail matters: advanced analysis shows its Python. Most users scroll past it. Don’t — that code block is how you verify the analysis did what you asked, and it’s the receipts your CFO will want.

Bottom line

Score it for what it is: a real analyst locked behind a formatting tollbooth. People who pay the toll (tables, headers, advanced analysis) get the best Copilot in the suite. People who don’t will tell you it’s broken. Both are reporting honestly.

← All scorecards