Copilot in Excel — Free Mind Map
Visual guide to Copilot in Excel — analyse data, generate formulas, build charts, format tables, and run Python with natural language. Free mind map.
What can Copilot do in Excel — and when is Python in Excel actually useful?
Last reviewed
Frequently Asked Questions
Does Copilot in Excel work on any spreadsheet?
Best results come from data formatted as a table (Ctrl+T) or a clean range with headers. Unstructured grids work for many features now — the new 'Ask Copilot about any part of your sheet' covers free-form areas too.
What is 'Edit with Copilot' in Excel?
Edit with Copilot (formerly Agent Mode, GA March 2026) lets you describe multi-step changes in chat — build templates, add formulas, restructure data — and Copilot performs the workbook edits for you.
Do I need a Python skill to use Python in Excel?
No. Copilot in Excel with Python lets you describe what you want in plain English — 'forecast next quarter' or 'cluster these customers' — and Copilot writes and runs the Python code. Available on Windows and Mac.
Can Copilot in Excel see my entire workbook?
Copilot reads the active sheet and any data you select or reference. It respects sensitivity labels and data protection policies in your tenant — labelled data stays inside your boundary.