Copilot Agent Mode is a content creation agent inside Microsoft 365 Copilot that builds and edits Word documents, Excel workbooks and PowerPoint decks from a plain description of what you want. As of Nov 2026 Microsoft says it runs on Anthropic models and needs a Microsoft 365 Copilot licence, so if you can't see it, the fix is usually a licence or an admin setting, not you.
Microsoft's own definition is one line: an agent in the Copilot experiences within Word, Excel and PowerPoint that creates and edits content in place. You say what the file should contain, it asks a question or two, and you get a draft file back. Here's how it works, who gets it and what to check before anything it makes leaves your desk.
Agent Mode or Word, Excel and PowerPoint Agents?
Microsoft's help pages don't stick to one name, so don't let that confuse you. One page calls it Agent Mode, or Office Agent, and places it in the Copilot experiences inside Word, Excel and PowerPoint. Another calls them the Word Agent, Excel Agent and PowerPoint Agent, and places them in the Microsoft Copilot app on desktop and web, under the Agents or Tools menu. Both describe the same kind of job: describe a file, get a file. One more label to know: PowerPoint's Agent Mode is marked Frontier on Microsoft's page, so treat it as the least settled of the three.
Microsoft pitches it on three points: you don't need design skills, results come out visually polished, and you can apply your own style preferences so the output matches your tone and brand. That's the vendor's claim, not a promise, and it's why the checking section below matters.
Who can use it
Microsoft's note is short: "Word, Excel, and PowerPoint Agents are only available to Microsoft 365 users with a Microsoft 365 Copilot license." No licence, no agents. If you're not sure what your business has, my guide to the Microsoft 365 Copilot licence explains what it covers. Check Microsoft's own page for the current price.
The agents page also describes how far Copilot can reach into your information. With a Copilot licence it automatically pulls in information from your files, emails, meetings and more, while respecting your company's access policies. Without one, Copilot pulls from the web and specific files you reference. On a personal account it uses your own files, notes and data stored in OneDrive.
The Anthropic setting your admin controls
This is the detail that trips people up. Microsoft's Agent Mode page says plainly: "Office Agent runs on Anthropic models." It uses what Microsoft calls a custom multi-agent approach to handle several complex tasks in one go.
That has a practical side effect, spelled out on the agents page: if you don't see the Word, Excel or PowerPoint agents, your admin may need to enable access to Anthropic AI models. So when someone on your team says they've got Copilot but there's no Excel Agent, don't assume it's broken or that they're on the wrong plan. Ask whoever runs your Microsoft 365 admin settings whether access to Anthropic's models has been switched on. Microsoft's article called Connect to Anthropic's AI models covers the steps.
Your first file in five steps
These are Microsoft's own steps, from the Microsoft Copilot app on the web or in Teams, as of Nov 2026:
- Open Copilot and pick an agent. Go to the Tools menu in Copilot Chat, or the Agents menu, and choose Word, Excel or PowerPoint.
- Describe the file. Use your own words or choose one of the sample prompts the agent suggests.
- Answer its questions. If it asks about tone, length or other details, answer them. This is where a vague request turns into a usable one.
- Review the preview. The agent generates your file and shows a preview first.
- Save and edit. The finished file is saved to your OneDrive. Open it in Word, Excel or PowerPoint to check it and polish it.
That last step matters more than it looks. Because the file lands in OneDrive, it's an ordinary document from then on. You can share it, keep versions of it or rip half of it out, the same as anything you've written yourself.
Example requests for each app
Microsoft's pages give sample requests for each app. Here's one per app, shortened, so you can see the level of detail the agents expect:
| App | What you ask for | Microsoft's example |
|---|---|---|
| Word | A structured document with named sections and a tone | A 2-page customer brief that summarises an initiative, outlines the value for an audience and ends with a checklist for the first 30 days |
| Excel | A workbook with sheets, formulas and charts | An annual financial close report for a bike shop, with product lines, variance to budget and year-over-year growth, using dummy data and standard financial formatting |
| PowerPoint | A deck with a set slide count and structure | A 7-slide executive brief with key insights, risks and mitigations, next steps, and short presenter notes on each slide |
Every one of those names the length, the sections and the style. That's the pattern Microsoft is teaching: be creative and specific, because the agents can handle complex instructions. If you'd like one to paste straight in, this is Microsoft's budget tracker example, word for word:
Copy this prompt
Create an Excel workbook for tracking my monthly revenue and expenses, with charts and year-to-date analysis.
The bike shop example has a habit worth borrowing: it asks for dummy data for now. Let the agent build the structure with made-up figures, check the formulas make sense, then type your own numbers in yourself. If you'd rather work inside a file you've already got, that's the in-app Copilot pane instead, which I cover in using Copilot in Excel.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
Changing the draft with feedback
You don't have to get the first request perfect. Microsoft says you can refine a draft with high-level feedback, giving "make it shorter" and "add a slide" as examples, or edit directly in the Microsoft 365 apps. I'd do the big structural changes by feedback (cut a section, add a slide, change the tone) and the small fixes by hand. Asking an agent to change one figure in one cell is slower than typing it.
The other trick in Microsoft's examples is pointing it at your own data. One sample asks it to use data from a file called Q3_sales.xlsx to create a summary report with charts. Working from a file like that beats pasting figures into the chat, and it's easier to check the result against the source.
What Microsoft says happens to your data
Microsoft's privacy line on the agents page is worth reading before you put client material in. It says your data is securely processed, reasoning models don't retain content beyond your request, customer data is never used to train the models, and Copilot respects sensitivity labels along with your organisation's enterprise access policies.
That's reassuring, but it's no reason to skip checking. Microsoft's own note says to always review generated files for accuracy before sharing. A polished-looking report with wrong figures is more dangerous than a rough draft, because it looks finished.
Where I'd start with it
I'd start with a budget tracker or a short customer brief. Both are structured, both are easy to check, and both show you quickly how the agent handles your kind of work. I'd skip sending anything it produced to a client or your board until you've read every figure and every claim yourself. And if the agents don't show up, I'd ask your admin about the Anthropic setting before assuming it's broken or buying anything new.
Microsoft changes Copilot features often, so treat this as accurate as of Nov 2026 and check Microsoft's own support pages for the latest.
If you want your team creating decks, reports and trackers with AI without losing control of accuracy, that's the kind of AI enablement I help with. I run AI training and workshops for teams, and help businesses with AI enablement and workflow automation, so the busywork runs itself and people get time back. Most of that work is with SaaS marketing teams and small businesses. Here's how we can work together.
Frequently asked questions
What is Copilot Agent Mode?
It's a content creation agent in Microsoft 365 Copilot that creates and edits Word, Excel and PowerPoint content from a plain description. As of Nov 2026 Microsoft says it runs on Anthropic models.
Do I need a Copilot licence for Agent Mode?
Yes. Microsoft says the Word, Excel and PowerPoint Agents are only available to Microsoft 365 users with a Microsoft 365 Copilot licence.
Why can't I see the Word, Excel or PowerPoint Agent?
Microsoft says your admin may need to enable access to Anthropic AI models. Check that first, then check your licence.
Where does the finished file go?
The completed file is saved to your OneDrive, and you open it in Word, Excel or PowerPoint to review and edit it.
Is my data used to train the models?
Microsoft says customer data is never used to train the models, and reasoning models don't retain content beyond your request.
