Microsoft 365 Copilot · sub-product

Copilot in Excel

Useful for explaining other people's models; do not trust new ones without checking.

Consilix rank 6/10

What it is

AI inside Excel. Explains formulas, builds analysis from natural language, generates charts, and (Agent Mode, GA April 2026) makes multi-step changes directly to formulas, tables, and pivots. The closest mainstream tool to a junior analyst, when it works.

Key features

Natural language to formula and pivot
Explain this formula and explain this workbook
Chart generation from prompt
Agent Mode for multi-step modelling tasks
Python in Excel integration for heavier analysis

Best use cases

Asking what the SUMIFS in cell H42 is actually doing
Generating a pivot summary from a raw export
Building a quick variance chart from sales data
Cleaning a messy supplier list with conditional rules

Weaknesses

Still wrong on complex models and large worksheets, do not trust output without checking. Struggles with real-world messy data where columns are inconsistent. Agent Mode is impressive in demos and patchy in production.

Pricing

Included in Microsoft 365 Copilot (paid).

Microsoft 365 Copilot