1.5 Copilot Capabilities Across Microsoft 365 Apps
Key Takeaways
- The AB-730 blueprint asks you to explain how Copilot features differ per app, so learn each app by the artifact it produces: Word drafts prose, PowerPoint builds decks, Excel analyses tables, Outlook triages mail, Teams handles meetings.
- Copilot in Excel requires the data to be a real Excel table or a range formatted as a table, stored in OneDrive or SharePoint with AutoSave on.
- Copilot Chat is the only surface that reasons across every app at once; in-app Copilot is scoped to the file or mailbox you currently have open.
- PowerPoint can generate a full deck from an existing Word document, which is the fastest route from an approved narrative to a presentation.
- The same underlying model powers every app, so quality differences you see come from the grounding data each surface can reach, not from a weaker model.
1.5 Copilot Capabilities Across Microsoft 365 Apps
Quick Answer: The blueprint bullet "understand the differences in features and capabilities of the Copilot experience in various Microsoft 365 apps" is tested as a routing question: given a business task, which app's Copilot should the user open? The rule is to follow the artifact. Word for prose documents, PowerPoint for decks, Excel for tabular analysis, Outlook for mail and scheduling, Teams for meetings, and Copilot Chat whenever the task spans more than one of those.
Candidates often assume the differences between apps come from different models. They do not. The same foundation model and the same Microsoft Graph grounding layer sit behind every surface. What changes is the working set each surface can see and the output type it can produce. Copilot in Word can restructure the document you have open but cannot read your inbox. Copilot in Outlook can summarise a 40-message thread but cannot build a chart. Understanding this scoping rule answers most app-comparison items on the exam.
1. Deep Dive: Copilot Capabilities Across Microsoft 365 Apps
┌─────────────────────────────────────────────────────────────────────────────┐
│ M365 APP CAPABILITY MATRIX │
│ │
│ [ Word ] ──────► Drafts from prompts / files, transforms tables, rewrites │
│ [ PowerPoint ] ► Creates decks from Word docs, adds slides, restructures │
│ [ Excel ] ─────► Formula generation, conditional formatting, Python models │
│ [ Outlook ] ───► Email thread summaries, tone coaching, ghostwriting drafts │
│ [ Teams ] ─────► Real-time meeting catch-up, action item tracking, recaps │
└─────────────────────────────────────────────────────────────────────────────┘
1. Copilot in Microsoft Word
- Drafting New Content: Users can generate initial drafts from simple prompts or ground the draft on up to 3 existing files stored in OneDrive or SharePoint (e.g., "Draft a 3-page project proposal based on /ProjectScope.docx and /Q3Budget.xlsx").
- Transforming Existing Text: Converts unstructured bullet points into formatted tables, summarizes lengthy sections, or rewrites content to adjust tone (e.g., Professional, Casual, Formal, Concise).
- Chat with Document: Ask questions directly against a 100-page document without reading the entire text ("What are the key indemnification liabilities in Section 8?").
2. Copilot in Microsoft PowerPoint
- Presentation Generation: Create a complete multi-slide presentation from scratch or transform an existing Word outline into a structured slide deck with suggested speaker notes.
- Slide Restructuring: Add new slides, reorganize sections, or consolidate wordy slides into clean visual layouts with bulleted takeaways.
- Brand Template Preservation: Generates slide designs while respecting the organization's custom enterprise templates, font themes, and color palettes.
3. Copilot in Microsoft Excel
Copilot in Excel operates on Excel Tables (data formatted with Ctrl+T or Home > Format as Table):
- Data Exploration and Insights: Ask plain-English questions about datasets ("What are the top three sales regions by margin in 2026?").
- Formula Authoring: Generates complex formulas, such as nested
XLOOKUP,INDEX/MATCH,SUMIFS, and dynamic array functions with explanations. - Visualizations & Formatting: Automatically creates pivot tables, bar charts, trend lines, and applies color-coded conditional formatting.
- Python in Excel: Executes Python code in secure, isolated cloud containers to perform advanced data wrangling, clustering analysis, machine learning forecasts, and seaborn/matplotlib visualizations directly within the spreadsheet.
4. Copilot in Microsoft Outlook
- Thread Summarization: Generates bulleted summaries of long, multi-party email chains, highlighting key decisions and unanswered questions.
- Drafting and Refinement: Drafts replies based on context from previous messages, with options to adjust length (Short, Medium, Long) and tone.
- Coaching by Copilot: Analyzes drafted emails before sending, offering feedback on tone, clarity, potential reader sentiment, and missing context.
5. Copilot in Microsoft Teams
- Live Meeting Intelligence: During an active meeting with transcription enabled, participants can query Copilot in real time ("What points of disagreement were raised regarding the timeline?" or "What tasks were assigned to David?") without interrupting the speaker.
- Post-Meeting Recaps: Generates organized meeting notes, structured action item lists with owner assignments, and direct timestamped links to the recording.
- Channel and 1:1 Chat Catch-up: Summarizes missed discussions over the last 1, 7, or 30 days, identifying decisions made while the user was away.
2. Choosing a Surface: The Routing Rule
When an exam item describes a business task, decide the answer in two steps.
- Name the artifact the user needs at the end. A memo, a deck, a chart, a reply, a recap.
- Ask whether the inputs live in one file or many. One file means in-app Copilot; many sources means Copilot Chat.
| Business task | Correct surface | Why the others are wrong |
|---|---|---|
| Shorten a 30-page policy already open on screen | Copilot in Word | The content is already in the active document; Chat adds an unnecessary referencing step |
| Turn an approved strategy memo into a 10-slide deck | Copilot in PowerPoint | Only PowerPoint emits slides; Word can summarise the memo but not build the deck |
| Find the three regions missing quarterly forecasts | Copilot in Excel | Requires formula and column reasoning over a table |
| Catch up on a vendor thread received while on leave | Copilot in Outlook | The grounding data is the mail thread itself |
| Summarise a meeting you missed | Copilot in Teams | Grounded on the meeting transcript and recap |
| Build a client status update from last week's meeting, the budget workbook and the SOW | Copilot Chat | Three artifacts across three apps; no single in-app surface can reach all of them |
Prerequisites Candidates Miss
- Excel: the range must be a genuine Excel table (or a range formatted as a table), the workbook must be saved to OneDrive or SharePoint, and AutoSave must be on. A local
.xlsxon the desktop will not work. - Teams: meeting features depend on the meeting being transcribed or recorded; without a transcript, meeting Copilot is limited to the live session.
- Outlook: Copilot works against the new Outlook and Outlook on the web; coaching and summarising act on the thread, not on the whole mailbox.
On the Exam: If a scenario names two or more different content types — "the contract, the pricing sheet and last Thursday's call" — the answer is almost always Copilot Chat, not an in-app Copilot.
Which capability of Copilot in Microsoft Outlook reviews a drafted email before sending and provides feedback on tone, clarity, and potential reader sentiment?
A financial analyst wants Copilot in Excel to identify outliers in a saved sales workbook, but the Copilot button produces no analysis. What is the most likely cause?
A project manager needs a client update that pulls from last week's Teams meeting, the project budget workbook, and the signed statement of work. Which Copilot surface should they use?