Lesson 3 of 7
Copilot in Excel
6 min read
What if the AI wasn't in a different app at all, but sitting right beside your grid — and could change the sheet itself, not just talk about it?
The assistant that lives in the app
Copilot is Microsoft's AI built right into Excel. It sits in a side panel next to your grid, and it can see the sheet you're looking at. So you don't paste anything — you just type a request, and Copilot reaches into the actual cells and makes the change: adds a column, highlights the outliers, builds a summary.
Copilot doesn't hand you text to paste — it edits the live grid in place, then tells you what it did.
Data prep and analysis, in place
Two jobs it's especially good at. Prep: tidy a table, add a calculated column, flag duplicates — the grunt work before analysis. Analysis: ask "what's the trend?" or "which region is the outlier?" and it answers from your numbers and can drop a chart in for you. You describe the outcome; it does the clicking.
Copilot works from what's in the sheet, so a messy table gives messy answers. Clean the data first — or ask Copilot to — before you trust its analysis.
The shape of it
- —Copilot is an AI panel built inside Excel, beside your grid.
- —It edits the real cells in place — prep and analysis — not a chat copy.
- —Its answers are only as clean as the table underneath, so tidy first.
How is Copilot in Excel different from pasting your data into a separate chatbot?
Continue in the app
Take the whole AI for Spreadsheets course — tracked
Get your personalized path, progress and streaks in the app — this lesson and every next one, in order.