Copilot Excel Skills for Teams: 8 to Train, and the 4 You Can Self-Teach
Bottom line: a team needs 8 Copilot Excel skills, and only 4 of them need a workshop. Self-teach choosing a mode, writing a prompt, formulas, and charts and PivotTables. Microsoft publishes guidance for all 4, with example prompts for formulas and PivotTables, and any practice file will do.
The other 4 depend on your own files, your review standards and your team agreeing on a habit. (Yes, I sell workshops. That's exactly why I'm telling you half of this list doesn't need one.)
The Copilot Excel skills matrix: what to train first
The skills come from what Microsoft documents Copilot in Excel doing today. I'd train them in this order: trust first, power second.
(Microsoft also uses "skills" for the saved routines inside Copilot, which is skill 8 here. Everywhere else on this page, a skill is something your people can do.)
| Skill | What your people can do | Route |
|---|---|---|
| 1. Choose a mode | Copilot has 3 modes. Edit (the default) changes the workbook, plan shows a plan first, and chat only answers. Start new users in chat, which makes no changes. | Self-study |
| 2. Write a prompt that names the columns | State the goal, then add context, expectations and a source. Name the columns or ranges. Start broad, then refine with follow-ups. | Self-study |
| 3. Check and undo | Read the plan before Copilot edits, spot-check results, ask Copilot what it changed, and know how to undo it. | Workshop |
| 4. Question data you didn't build | Ask for insights as charts, PivotTables, trends or outliers. For text such as survey comments, hover over the superscript number to see the source data. | Workshop |
| 5. Formulas and lookups | Add a formula column, ask for an XLOOKUP-style lookup, or have Copilot explain a formula. | Self-study |
| 6. Charts and PivotTables | Describe the chart or PivotTable in plain words. Both stay linked to the source data. | Self-study |
| 7. Clean messy data | Use the Clean Data button (Excel for the web and Windows) for inconsistent text, number formats and extra spaces. For other clean-up, ask Copilot in edit mode and review what it changes. | Workshop |
| 8. Make it repeatable | Save rules for a workbook, or record a skill from a task you demonstrate. Availability differs by platform, so test first. | Workshop |
Sources: Microsoft's Copilot in Excel support pages (checked November 2026).
Copilot Excel training: why 4 skills don't need a workshop
My rule: self-teach a skill when Microsoft publishes the steps and any file will do for practice. Bring in a trainer when it depends on your own files, your review standards or your team agreeing on a habit. That's my rule of thumb, not Microsoft's.
For skills 5 and 6, start with Microsoft's own example prompts on a copy of a real file:
Add a column that calculates the profit margin for each product.
Explain the formula in cell D3.
Create a PivotTable with the sum of sales, with month in rows and category in columns.
The other 4 are where a room helps:
3Check and undo
Microsoft's FAQ says Copilot can make mistakes, and to avoid it for decisions in sensitive areas such as finance, legal or medical topics. Someone has to define what "checked" means for your team (otherwise it means "I glanced at it"). The trail has gaps too: Show Changes doesn't list formatting changes, chart and object edits, PivotTable operations, or hiding and filtering.
4Question data you didn't build
Microsoft says naming the columns you want analysed gives more accurate results, so people must read the sheet before they ask. A fluent wrong answer about a sheet you didn't build is the expensive kind.
7Clean messy data
Clean Data works best on tabular data of up to 100 columns and 50,000 rows, ideally in an Excel table, and Microsoft says it initially performs best in English. If your sheets are in German or French, test on your own data before you promise anything.
8Make it repeatable
Rules and custom skills only help if the team agrees what goes in them. Microsoft's own pages disagree on the skill recorder. The October 2026 Excel post lists it as Insiders-only on Windows and Mac, and generally available on the web, while the support page says it is still rolling out.
Before any Copilot Excel training: can your people open it?
A skills session for people who can't see the button is an expensive way to find a licence problem. Check 3 things first.
1Access
Copilot in Excel needs a Personal or Family plan with AI credits, a Microsoft 365 Premium plan, a commercial Microsoft Copilot licence (Microsoft 365 Copilot until its rename), or a Copilot Chat-eligible business or enterprise subscription. The in-app label shows what you get. Copilot Chat (Basic) means no Copilot in Excel.
2Files
Calculation Options must be set to Automatic, and the file can't be checked out in SharePoint or saved as Strict Open XML (save it as .xlsx). AutoSave doesn't have to be on.
3The button
Since spring 2026 it sits in the lower-right corner of the workbook, and F6 finds it. Still missing? Use the fix list: Copilot not showing in Excel.
Microsoft's free Copilot Excel training, and where it stops
Items 1 to 5 are free. Search the names to find the pages.
12 Microsoft Learn paths
"Transform ideas into action with Copilot" (beginner, 4 modules on Copilot Chat) and "Draft, Analyze, and Present with Microsoft Copilot" (MS-4018, intermediate, 7 modules, Excel included).
22 Excel modules, both dated 2025
"Work Smarter in Excel with Copilot Chat" (7 units) and "Summarize Sales Data Using Copilot in Excel". They pre-date the edit, plan and chat modes and the corner button, so the screens may differ.
3Copilot Academy
Learning paths inside Viva Learning (aka.ms/copilot-academy), on by default for all Microsoft 365 users, though knowledge administrators can restrict it to licensed users. It runs in 8 languages: English, French, German, Italian, Japanese, Portuguese (Brazil), Spanish and Chinese.
4Prompts inside the app
The standalone Prompt Lab app closed on 15 July 2025. Prompts now sit in the Prompt Lab in Copilot Chat, and as prompt pills below the input box in the Copilot pane.
5Success Kit and Trainer Kit
For admins and trainers: admin controls, licensing, training materials, onboarding email templates, and a downloadable PowerPoint deck for Copilot Chat.
6Instructor-led QuickStart sessions
Listed in Microsoft's enablement guide, which gives no price or eligibility terms, so I can't tell you what they cost.
None of it gives you someone watching your people use Copilot on their own files and telling them what they got wrong. That's my inference, not a Microsoft statement.
Free place to start today: the Learn modules, my guide to Copilot in Excel and the Copilot prompts for Excel.
Self-study or workshop? 4 if-then checks
1If your team only needs skills 1, 2, 5 and 6, then self-study is enough
Point them to the Microsoft material and a copy of a real file.
2If the output goes to managers, auditors or customers, then train skill 3 together
"Checked" has to mean the same thing to everyone who signs off a number.
3If your files are messy, shared or multilingual, then practise skills 4 and 7 on the real files
Microsoft warns that Copilot was trained on sources predominantly in English and may not perform as well in other languages.
4If 20 to 25 people need it at once, then a hands-on workshop fits
That's the format I run: hands-on, live online, 1.5 to 4 hours. See my Microsoft Copilot workshop. (I have no commercial interest in Microsoft. My commercial interest is in workshops, as I said.)
Questions about Copilot Excel skills and training
What skills do you need to use Copilot in Excel?
8 skills cover it: choosing a mode, writing a prompt that names the columns, checking and undoing, questioning data you didn't build, formulas and lookups, charts and PivotTables, cleaning messy data, and making tasks repeatable.
Is there free Microsoft training for Copilot in Excel?
Yes. Microsoft offers Learn paths and 2 Excel modules (both dated 2025), Copilot Academy inside Viva Learning, prompts built into the Copilot pane, and a Success Kit and Trainer Kit for admins and trainers. The enablement guide gives no price for its instructor-led sessions.
Do you need a workshop to learn Copilot in Excel?
Not for modes, prompts, formulas, and charts and PivotTables. A hands-on workshop helps with checking and undoing, data you didn't build, messy data and repeatable tasks, because those depend on your files and your standards.
How long does Copilot Excel training take?
It depends on how many of the 8 skills you cover. My hands-on workshops run from 1.5 to 4 hours for groups of 20 to 25 people.
What should you check before training a team on Copilot in Excel?
Access, files and the button: each person's in-app licence label, Calculation Options on Automatic, practice files saved as .xlsx, and the button in the lower-right corner (F6 finds it).
Self-teach 4. Bring in help for the other 4.
I run live online, hands-on Copilot workshops for groups of 20 to 25 people, from 1.5 to 4 hours. Teams that live in Excel have their own session.