Select and apply prebuilt Microsoft 365 Copilot agents
Unlock the complete study guide + 25 practice exams totaling 1,452 questions.
Bundled into the existing Microsoft Certified: AI Business Professional premium course — no separate purchase.
14-day refund guarantee on one-time purchases and your first subscription charge.
Included in this chapter:
- Prebuilt agents and when to reach for one
- Knowledge versus actions: what an agent can change
- Researcher: in-depth research with cited reports
- Analyst: insights from the data you supply
- Word, Excel, and PowerPoint Agents: new Office files
- Workflows: automations described in plain language
- Coaching agents: improve how you ask, write, and think
- Planner Agent: executing plan tasks and reporting
- Find and add agents in the Agent Store
- Agent options in the left navigation
- Prebuilt or custom: deciding when to build
- Where you can apply an agent in Microsoft 365
- Use an agent on a SharePoint site
- Bring a SharePoint agent into a Teams conversation
- Return to earlier agent conversations
- Exam patterns: choosing and applying prebuilt agents
Prebuilt agents by the output they produce
| Agent | Output it produces | What you give it | Pick something else when |
|---|---|---|---|
| Researcher | A structured report with headings, visuals, and source citations | A specific question and the source scope: work, web, or both | You need only a quick answer (Copilot Chat) |
| Analyst | Statistics, trends, outliers, and charts from your data | Attached data files, such as Excel workbooks or CSV files | The task is gathering evidence from many sources (Researcher) |
| Word, Excel, or PowerPoint Agent | A new document, workbook, or presentation saved to OneDrive | A description of the file's content and structure | You need cell-, slide-, or page-level edits (open the file in its app) |
| Workflows | A scheduled or event-triggered automation across Microsoft 365 | A plain-language description that names the services involved | The automation needs non-Microsoft or custom connectors (Power Automate) |
| Coaching agents | Better prompts, writing, ideas, or learning plans | Your prompt, draft, or goal with context | You need the task itself done or its facts checked |
| Planner Agent | Task output in a Loop component, or a plan status report | Tasks assigned in a Planner plan, or a reporting period and sections | The work is not organized in a Planner plan |
Decision tree
Cheat sheet
Unlock with Premium — includes all practice exams and the complete study guide.
References
- https://support.microsoft.com/en-us/microsoft-365-copilot/get-started-with-researcher-in-microsoft-365-copilot
- https://support.microsoft.com/en-us/microsoft-365-copilot/get-started-with-analyst-in-microsoft-365-copilot
- https://support.microsoft.com/en-us/office/365-copilot-app/get-started-with-word-excel-and-powerpoint-agents-in-microsoft-365-copilot
- https://learn.microsoft.com/en-us/agents/design-guidelines/intro-to-agents
- https://learn.microsoft.com/en-us/microsoft-365/copilot/responsible-ai/copilot-cowork-application-card
- https://learn.microsoft.com/en-us/microsoft-365/copilot/copilot-agent-store
- https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-730
- https://learn.microsoft.com/en-us/microsoft-365/copilot/extensibility/agents-overview
- https://support.microsoft.com/en-us/sharepoint/copilot-in-sharepoint/interact-with-agents-in-sharepoint
- https://support.microsoft.com/en-us/microsoft-365-copilot/get-started-with-workflows-in-microsoft-365-copilot
- https://support.microsoft.com/en-us/sharepoint/copilot-in-sharepoint/share-an-agent-from-sharepoint-in-teams
- https://learn.microsoft.com/en-us/microsoft-365/copilot/microsoft-365-copilot-overview
- https://learn.microsoft.com/en-us/microsoft-365/copilot/cowork/use-cowork
- https://learn.microsoft.com/en-us/microsoft-365/copilot/manage-public-web-access
- https://support.microsoft.com/en-us/office/use-model-choice-in-the-researcher-agent
- https://support.microsoft.com/en-us/microsoft-365-copilot/use-model-council-with-researcher-in-microsoft-365-copilot
- https://support.microsoft.com/en-us/microsoft-365-copilot/agents-built-by-microsoft
- https://learn.microsoft.com/en-us/microsoft-365/copilot/faq-wordexcelppt-agents
- https://learn.microsoft.com/en-us/microsoft-365/copilot/connect-to-ai-subprocessor
- https://learn.microsoft.com/en-us/microsoft-365/copilot/agent-essentials/m365-agents-admin-guide
- https://learn.microsoft.com/en-us/microsoft-365/copilot/extensibility/agent-template-prompt-coach
- https://learn.microsoft.com/en-us/microsoft-365/copilot/extensibility/agent-template-writing-coach
- https://learn.microsoft.com/en-us/microsoft-365/copilot/extensibility/agent-template-idea-coach
- https://support.microsoft.com/en-us/planner/copilot/frequently-asked-questions-about-planner-agent
- https://support.microsoft.com/en-us/planner/copilot/execute-tasks-with-planner-agent
- https://support.microsoft.com/en-us/planner/copilot/generate-automatic-status-reports-with-planner-agent
- https://learn.microsoft.com/en-us/copilot/microsoft-365/microsoft-365-copilot-requirements
- https://support.microsoft.com/en-us/microsoft-365-copilot/get-started-with-agents-in-the-microsoft-365-copilot-app
- https://support.microsoft.com/en-us/microsoft-365-copilot/get-more-agents-in-the-microsoft-365-copilot-app
- https://support.microsoft.com/en-us/microsoft-365-copilot/what-information-does-copilot-use-to-answer-my-prompt
- https://learn.microsoft.com/en-us/microsoft-365/admin/manage/manage-copilot-agents-integrated-apps
- https://support.microsoft.com/en-us/sharepoint/copilot-in-sharepoint/use-an-agent-created-in-sharepoint-in-microsoft-365-copilot-chat
- https://learn.microsoft.com/en-us/microsoft-365/copilot/extensibility/agent-builder
- https://learn.microsoft.com/en-us/microsoft-365/copilot/connectors/overview
- https://support.microsoft.com/en-us/microsoft-365-copilot/how-microsoft-365-copilot-chat-history-works
- https://learn.microsoft.com/en-us/microsoft-365/copilot/release-notes
- https://support.microsoft.com/en-us/microsoft-365-copilot/share-conversations-responses-in-microsoft-copilot