Draft and analyze business content with Microsoft 365 Copilot
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:
- Grounding: where a business answer gets its facts
- Copilot connectors: synced versus federated
- Use connector content in Copilot
- Work IQ: ground Copilot in your work context
- Derive insights across your work with Work IQ
- Choose the sources for one answer
- Copilot in Word: create and change document content
- Copilot in Word: understand a document with Chat only
- Copilot in Excel: choose a mode before you prompt
- Copilot in Excel: what the analysis can draw on
- Copilot in Excel: analyze and visualize data
- Copilot in Excel: reuse a process with a custom skill
- Copilot in PowerPoint: create a new presentation
- Copilot in PowerPoint: work with an existing deck
- Choose and create visuals for business content
- Edit boundaries: preview, plan, or direct change
- Validate content before you share it
- Practice scenarios: recognize the right choice
Copilot in Word, Excel, and PowerPoint: what each produces and how changes reach the file
| Need | Copilot in Word | Copilot in Excel | Copilot in PowerPoint |
|---|---|---|---|
| Create content | A first draft from a prompt, outline, notes, or referenced file | Data, formulas, dashboards, and templates generated from your prompt | A new presentation from a prompt, using your template or Brand Kit |
| Ground in a specific source | Type / and choose the file | Change data sources: Web, Work, and federated connectors | Reference a file, or type /, when adding a slide or a topic |
| Understand the content | Chat only: summary, key takeaways, open questions, action items | Chat only: analysis and insights without workbook changes | Summarize slides, answer questions, suggest likely audience questions |
| Visuals | Turn selected text into a table or an image | Charts and PivotTables with editable links to source data | Stock images, brand images, or AI-generated images |
| How changes reach the file | Shared document: preview in chat, added only after you approve | Edit mode (the default) changes the workbook directly; Plan shows a plan first | Generates or edits content directly in the presentation |
Decision tree
Cheat sheet
Unlock with Premium — includes all practice exams and the complete study guide.
Also tested in
References
- 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/copilot/connectors/overview
- https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-730
- https://support.microsoft.com/en-us/microsoft-365-copilot/turn-raw-data-into-dynamic-visuals-with-microsoft-365-copilot-pages
- https://learn.microsoft.com/en-us/microsoft-365/copilot/connectors/federated-connectors-overview
- https://support.microsoft.com/en-us/microsoft-365-copilot/refer-to-specific-files-and-more-in-microsoft-365-copilot
- https://learn.microsoft.com/en-us/microsoft-copilot-studio/knowledge-graph-vs-power-platform-connectors
- https://support.microsoft.com/en-us/microsoft-365-copilot/control-review-sources-copilot-chat
- https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-data-sources
- https://support.microsoft.com/en-gb/word/copilot/draft-and-add-content-with-copilot-in-word
- https://support.microsoft.com/en-gb/word/copilot/start-from-exist
- https://support.microsoft.com/en-us/word/welcome-to-copilot-in-word
- https://support.microsoft.com/en-us/microsoft-365-copilot/how-reference-and-document-lengths-affect-copilot-responses
- https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel
- https://support.microsoft.com/en-us/excel/copilot/frequently-asked-questions-about-copilot-in-excel
- https://support.microsoft.com/en-us/excel/copilot/data-insights-with-copilot-in-excel
- https://support.microsoft.com/en-us/excel/copilot/import-data-from-another-excel-file-with-copilot-in-excel
- https://support.microsoft.com/en-us/excel/copilot/visualize-your-data-with-copilot-in-excel
- https://support.microsoft.com/en-us/powerpoint/copilot/create-a-new-presentation-with-copilot-in-powerpoint
- https://support.microsoft.com/en-us/powerpoint/edit-with-copilot-in-powerpoint
- https://support.microsoft.com/en-us/powerpoint/copilot/add-a-slide-from-a-file-with-copilot-in-powerpoint
- https://support.microsoft.com/en-us/office/add-topics-to-your-existing-powerpoint-presentation-with-copilot
- https://support.microsoft.com/en-us/microsoft-365-copilot/how-copilot-chat-works-in-microsoft-365-apps
- https://support.microsoft.com/en-us/powerpoint/copilot/add-an-image-to-your-presentation-with-copilot-in-powerpoint
- https://support.microsoft.com/en-us/microsoft-365-copilot/create-ai-generated-images-with-the-microsoft-365-copilot-app
- https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-tips
- https://support.microsoft.com/en-us/microsoft-365-copilot/evaluate-copilot-output-for-clarity-accuracy-tone-and-coverage