Skip to content
← Back to the guide

Copilot in Excel: formula columns, tables, and charts

7slides. Screenshot a slide, download it as a PNG, or use your browser's Print → Save as PDF for a LinkedIn-ready multi-page carousel — each slide becomes one page.

M
solvingmicrosoft365.com
1 / 7

Copilot in Excel: formula columns, tables, and charts

The formula, table, chart, and PivotTable prompts that reliably work in Copilot in Excel, why tables still matter, and the COPILOT() function.

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 1Download PNG
M
solvingmicrosoft365.com
2 / 7
01

Tables: no longer required, still the whole game

Early Copilot in Excel refused to work on anything that wasn't a formatted Excel table. That restriction has relaxed — Copilot will now work on a plain range with a clear header row — but the honest advice hasn't change…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 2Download PNG
M
solvingmicrosoft365.com
3 / 7
02

Formula column patterns that work

Copilot's strongest single feature is adding a formula column. You describe the calculation; it inserts a new column with a formula (using structured references if you're in a table) and a plain-English explanation. Pat…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 3Download PNG
M
solvingmicrosoft365.com
4 / 7
03

Highlight, sort, filter

"Highlight rows where Status is Overdue," "bold the top 10 by Margin," "sort by Region then by Date descending" — these are conditional-formatting and sort actions, and Copilot applies them directly. Reliable, and a goo…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 4Download PNG
M
solvingmicrosoft365.com
5 / 7
04

Charts and PivotTables

Ask for "a chart of Revenue by Month" and Copilot inserts a native Excel chart — a real chart object you can restyle, not an image. Ask for "sales by region and product" and you'll get a PivotTable, usually on a new she…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 5Download PNG
M
solvingmicrosoft365.com
6 / 7
05

The COPILOT() function

Newer builds include a =COPILOT() worksheet function that takes a prompt and optional ranges and returns AI-generated text or values directly into cells — classify sentiment, summarise a comment, extract a product name…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 6Download PNG
M
solvingmicrosoft365.com
7 / 7
06

Practical prompting rules

Copilot in Excel isn't a replacement for knowing Excel. It's a replacement for remembering syntax, which turns out to be most of what stops people. Give it a clean table and clear column names and it's the best producti…

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/copilot-in-excel-formulas-tables-and-charts

Slide 7Download PNG

Auto-generated from Copilot in Excel: formula columns, tables, and charts. This page is not indexed and isn't part of the guide itself.