Domain 3 of 4 · Chapter 1 of 2

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

NeedCopilot in WordCopilot in ExcelCopilot in PowerPoint
Create contentA first draft from a prompt, outline, notes, or referenced fileData, formulas, dashboards, and templates generated from your promptA new presentation from a prompt, using your template or Brand Kit
Ground in a specific sourceType / and choose the fileChange data sources: Web, Work, and federated connectorsReference a file, or type /, when adding a slide or a topic
Understand the contentChat only: summary, key takeaways, open questions, action itemsChat only: analysis and insights without workbook changesSummarize slides, answer questions, suggest likely audience questions
VisualsTurn selected text into a table or an imageCharts and PivotTables with editable links to source dataStock images, brand images, or AI-generated images
How changes reach the fileShared document: preview in chat, added only after you approveEdit mode (the default) changes the workbook directly; Plan shows a plan firstGenerates or edits content directly in the presentation

Decision tree

Which visual fits the content?Need grouped totalsfrom workbook data?YesPivotTable(Excel)NoChart to stay inthe workbook?YesExcel chart(linked to data)NoEdit with colleagueson a Copilot Page?YesCopilot Page(rich artifact)NoDoes an existingimage fit?YesStock image(PowerPoint)NoCreate an image(new composition)

Cheat sheet

  • Copilot connectors make external business knowledge available inside Copilot
  • Synced connectors index content while federated connectors retrieve it live
  • Federated connector access uses the user's source-system identity
  • Self-serve sync connectors index an individual's permitted external content
  • Turn Work IQ on to ground Copilot Chat in permitted organizational content
  • Work IQ connects work relationships and content to reveal actionable insights
  • Source controls narrow the information Copilot may use for a business answer
  • Cross-work retrieval needs the relevant people, period, and business outcome
  • A Word draft can start from business requirements without an existing source document
  • An existing document or template can supply structure for new Word content
  • Copilot can refine, extend, or restructure document content in place
  • Word's Chat only mode explains or summarizes content without editing the document
  • Excel separates analysis-only chat, planning, and direct workbook editing
  • Excel grounding depends on the requested context and source approvals
  • Excel can analyze themes and sentiment in text as well as numeric data
  • Copilot can generate calculations, retrieve matching values, and explain formulas
  • Highlighting, sorting, and filtering bring existing records into focus
  • Copilot can bring selected data from another workbook into the current workbook
  • Excel charts visualize source data and remain editable
  • PivotTables summarize measures by requested business dimensions
  • Excel editing requires Automatic calculation and a supported file state
  • Excel skills retain a repeatable workbook process for reuse
  • PowerPoint can start from a business prompt or a structured Word source
  • Presentation templates and Brand Kits guide design separately from source content
  • Copilot can extend an existing deck with a slide or a topic section
  • Copilot in PowerPoint can analyze a deck and anticipate audience questions
  • Copilot can change formatting across an existing presentation
  • Image generation uses a descriptive prompt and explicit visual controls
  • Generated images can be refined before being copied or downloaded
  • PowerPoint distinguishes finding an existing image from generating a new one
  • Copilot can turn business source data into rich visuals for a shared page
  • Citations provide evidence to inspect rather than automatic approval of a business answer
  • Business-ready content must match the intended audience and decision needs
  • Human review must account for whether Copilot changes content before approval

Unlock with Premium — includes all practice exams and the complete study guide.

Also tested in

References

  1. https://support.microsoft.com/en-us/microsoft-365-copilot/what-information-does-copilot-use-to-answer-my-prompt
  2. https://learn.microsoft.com/en-us/microsoft-365/copilot/connectors/overview
  3. https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-730
  4. https://support.microsoft.com/en-us/microsoft-365-copilot/turn-raw-data-into-dynamic-visuals-with-microsoft-365-copilot-pages
  5. https://learn.microsoft.com/en-us/microsoft-365/copilot/connectors/federated-connectors-overview
  6. https://support.microsoft.com/en-us/microsoft-365-copilot/refer-to-specific-files-and-more-in-microsoft-365-copilot
  7. https://learn.microsoft.com/en-us/microsoft-copilot-studio/knowledge-graph-vs-power-platform-connectors
  8. https://support.microsoft.com/en-us/microsoft-365-copilot/control-review-sources-copilot-chat
  9. https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-data-sources
  10. https://support.microsoft.com/en-gb/word/copilot/draft-and-add-content-with-copilot-in-word
  11. https://support.microsoft.com/en-gb/word/copilot/start-from-exist
  12. https://support.microsoft.com/en-us/word/welcome-to-copilot-in-word
  13. https://support.microsoft.com/en-us/microsoft-365-copilot/how-reference-and-document-lengths-affect-copilot-responses
  14. https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel
  15. https://support.microsoft.com/en-us/excel/copilot/frequently-asked-questions-about-copilot-in-excel
  16. https://support.microsoft.com/en-us/excel/copilot/data-insights-with-copilot-in-excel
  17. https://support.microsoft.com/en-us/excel/copilot/import-data-from-another-excel-file-with-copilot-in-excel
  18. https://support.microsoft.com/en-us/excel/copilot/visualize-your-data-with-copilot-in-excel
  19. https://support.microsoft.com/en-us/powerpoint/copilot/create-a-new-presentation-with-copilot-in-powerpoint
  20. https://support.microsoft.com/en-us/powerpoint/edit-with-copilot-in-powerpoint
  21. https://support.microsoft.com/en-us/powerpoint/copilot/add-a-slide-from-a-file-with-copilot-in-powerpoint
  22. https://support.microsoft.com/en-us/office/add-topics-to-your-existing-powerpoint-presentation-with-copilot
  23. https://support.microsoft.com/en-us/microsoft-365-copilot/how-copilot-chat-works-in-microsoft-365-apps
  24. https://support.microsoft.com/en-us/powerpoint/copilot/add-an-image-to-your-presentation-with-copilot-in-powerpoint
  25. https://support.microsoft.com/en-us/microsoft-365-copilot/create-ai-generated-images-with-the-microsoft-365-copilot-app
  26. https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-tips
  27. https://support.microsoft.com/en-us/microsoft-365-copilot/evaluate-copilot-output-for-clarity-accuracy-tone-and-coverage