Why each app gets its own depth
Claude behaves largely the same wherever you use it. Copilot doesn't: inside each Microsoft 365 app it is shaped by that app's own data model and by the Microsoft Graph connections available there, so the same assistant can do noticeably different things in Excel, Outlook, and Teams. Knowing where that depth sits is one of the most practically useful things a regular employee can take from this track, which is why this lesson has no direct equivalent in the Claude track.
Three apps, three depths
Each app below gets its own section, followed by a short note on why Word is not one of them.
Excel: advanced analysis with real Python, not just formulas
The deepest Excel feature is advanced analysis, which runs genuine Python against your data without requiring you to know Python or be an Excel formula expert. On the Home tab, select Copilot, then the Advanced analysis card in the task pane, or type a prompt directly such as "Analyze this data using Python." Selecting Start advanced analysis opens a new sheet where Excel writes and runs the actual Python code needed to answer your question, visible in the sheet rather than hidden behind the scenes, so you can see exactly what it did and ask follow-up questions about the method itself, not just the result. Select Stop advanced analysis to return Copilot to its regular mode once you are done.
This matters because it is a genuinely different trust model from a plain-language answer. A chat response asserting "revenue grew 12% in Q3" asks you to take its word for it. Advanced analysis shows you the Python that computed that 12%, which you, or anyone else who opens the sheet later, can actually read and check, the same "show your work" principle that makes Copilot's Analyst agent (lesson 4.4) checkable rather than a black box.
Real constraints apply. Advanced analysis currently runs on Windows only, with support for other platforms planned but not yet available. It supports English, Simplified Chinese, French, German, Italian, Japanese, Brazilian Portuguese, and Spanish, with more languages planned. It requires a specific minimum Excel version (Current Channel from version 2409, or Monthly Enterprise Channel from version 2410), and it needs Python in Excel to already be available on your account, which is not universal across every licence tier. If the Advanced analysis card does not appear, that version or availability gap is the first thing to check, not a sign the feature doesn't exist.
A good first use: take a spreadsheet you already have with a few hundred rows of real data, sales by region, survey responses, expense lines, and ask for something you would normally build a pivot table and a chart to answer, such as "which region had the most volatile month-over-month revenue, and show me why." Advanced analysis will typically compute the volatility measure in visible Python, build a chart from it, and let you ask a natural follow-up like "now break that down by product line" without starting over. Compare this to Copilot's Analyst agent from lesson 4.4, which does a similar job on a larger, multi-file scale: advanced analysis is the version that lives inside the one workbook already open in front of you, while Analyst is the version built for a question that spans several spreadsheets or Graph-indexed sources at once.
Outlook: email coaching before you hit send
Email coaching reviews a draft before it goes out and suggests improvements to tone, clarity, and how the reader is likely to feel reading it, a genuinely different use of Copilot than drafting the email in the first place. To use it: write your message as normal, select the Copilot icon on the toolbar, and choose Coaching by Copilot. Review its suggestions, then either select Apply all suggestions to have Copilot regenerate the message with its changes, or make your own edits based on what it flagged. On iOS and Android you can tap Regenerate for a fresh pass of feedback; on Mac, only the latest Outlook version supports the feature at all.
One access detail worth knowing before you rely on it: email coaching, like most Copilot features in Outlook, only works with work or school accounts and personal Microsoft accounts on outlook.com, hotmail.com, live.com, or msn.com. If a colleague uses Outlook to manage a Gmail, Yahoo, or iCloud address, they can still use Outlook itself, but they will not see Copilot features on that account, which is a real, account-level limitation rather than a bug to troubleshoot.
Outlook's other deep feature worth building into a daily habit is thread summarization: for a long back-and-forth you are catching up on, summarizing the thread before reading every message end to end saves real time, especially on threads you were copied into partway through rather than started on.
Teams: live meeting support, during and after
Copilot's role in a Teams meeting splits cleanly into during and after, and the two halves do different jobs.
During the meeting, Copilot can summarize the discussion so far, including who said what and where people agree or disagree, which is genuinely useful if you join more than five minutes late: open Copilot and ask for a summary rather than whispering "what did I miss" to the person next to you. It also suggests action items in real time and answers direct prompts like "list action items" or "suggest follow-up questions" mid-meeting. Near the scheduled end time, it proactively prompts the group to wrap up, summarizing key points and listing the next steps and assigned owners that came out of the discussion, a small nudge that can actually shorten meetings that would otherwise run long on momentum alone.
After the meeting, you reach Copilot from either the meeting chat or the dedicated Recap tab. It draws on both the transcript and the chat itself, and it cites its sources rather than presenting a summary as if it simply knew. From there it can generate meeting notes, list action items, recap the whole meeting for someone who missed it entirely, or draft a follow-up email to send to participants, each a different, specific request rather than one generic "summarize this" button.
Real limitations shape when this works. The meeting generally needs to be transcribed for full Copilot support, unless the organizer specifically enables Copilot without transcription. Copilot does not work in meetings hosted outside your own organization, so an external client call will not get the same support a purely internal meeting does. In recurring meeting series, Copilot's conversation history is removed whenever transcription is toggled on or off, so a habit of switching transcription mid-series can quietly erase context you expected to still be there. And the fuller Intelligent Recap experience specifically requires either a Teams Premium add-on or a Microsoft 365 Copilot licence, so what you see in a meeting can genuinely differ from what a colleague on a different licence sees in the same meeting.
Word: the one app with no new depth to add here
Word was covered lightly in lesson 2.2 alongside the other apps, and it does not get its own deep dive here, not because it lacks Copilot features, but because its deepest capabilities (drafting from a prompt, rewriting a selection, summarizing a long document) are already close enough to the chat-and-canvas pattern covered thoroughly elsewhere in this track, in Copilot Pages (2.4) and in Copilot in PowerPoint's document-to-deck pipeline (5.2). Excel, Outlook, and Teams earned their own sections here specifically because each behaves in a genuinely different way shaped by its own data model: Excel's advanced analysis writes actual code, Outlook's coaching reasons about tone and a reader's likely reaction, and Teams' recap reconstructs a live conversation after the fact. None of those three has a close analog anywhere else in the track, which is exactly why they were worth this lesson's depth and Word was not.
Putting the three together
These three features share a pattern worth naming: each one does its real work on content Copilot can already ground against through Microsoft Graph (your mail, your files, your meeting transcripts), the same grounding mechanic covered in lesson 4.1, just applied per app rather than described in the abstract. Excel's advanced analysis works on data already in your workbook. Outlook's coaching and summaries work on your own mail thread. Teams' recap works on a meeting you were actually part of. None of these require you to set anything up beyond what default grounding already provides, which is exactly why they are worth building into a daily habit rather than treating as a special, occasional-use feature.
A worked week: using all three without thinking about it
Monday morning, a spreadsheet lands in your inbox with three months of expense data and a request to "find anything unusual." Rather than building a pivot table by hand, open it in Excel, select Copilot, and start advanced analysis with a prompt like "find expense categories with unusual month-over-month swings and explain what's driving them." You get a sheet with visible Python, a flagged category or two, and a chart, something you can forward with the actual working shown rather than just your conclusion.
Tuesday, you need to reply to a client about a delayed delivery, a message where tone matters more than usual. Draft it normally, run Coaching by Copilot before sending, and read its suggestions rather than blindly applying them: coaching is there to catch a tone that reads harsher or more defensive than you intended, not to rewrite your judgment about what to say.
Wednesday, you are double-booked and miss a project meeting entirely. After it ends, open the Recap tab in Teams and ask for a full recap plus a list of action items assigned to you specifically. Because Copilot cites its sources from the transcript and chat, you can click through to the exact moment something was decided if the recap itself raises a question, rather than taking the summary on faith.
None of these three steps required setting anything up in advance beyond what the earlier lessons in this track already covered: Excel already had your data, Outlook already had your draft, Teams already had the meeting's transcript. That is the actual point of this lesson: these features are already available inside tools used every day, and the only real skill is remembering to reach for them before falling back on the slower manual way.
Staying in control
Each of these three features reads real content you did not explicitly hand to Copilot in the moment, your spreadsheet, your draft email, your meeting transcript, which makes the same oversharing caution from lesson 2.5 worth repeating here in its applied form. Advanced analysis only works on data already in the workbook you opened, so nothing leaves that file's existing permission boundary; it is not pulling in other spreadsheets you have access to elsewhere. Email coaching only ever sees the draft open in front of you, not your mailbox history, so there is no risk of it pulling context from an unrelated thread into a sensitive message. Meeting recap is the one with the widest real reach, since it draws on a full transcript and chat history, which is exactly why Microsoft gates its fuller Intelligent Recap behind a licence requirement and lets organizers disable transcription altogether for sensitive meetings. If a meeting covers something genuinely confidential, that is a real decision to make deliberately (turn transcription off, or warn participants it is on) rather than an assumption to leave unexamined.
A second habit worth building alongside the three features themselves: check which licence tier you are on before troubleshooting a missing feature. A colleague on a different Microsoft 365 Copilot plan, or using a personal account instead of a work one, can see a visibly different Teams recap, a missing Advanced analysis card in Excel, or no Copilot icon at all in Outlook, not because something is broken, but because availability genuinely varies by licence tier and by which Microsoft account type sits behind the app. Lesson 2.1's framing still applies at this depth: your IT department controls what tier you are on, not a setting you can simply toggle yourself.
Try it
Pick one lesson from each app and try it against something real this week: run advanced analysis on a spreadsheet you already have a real question about, run email coaching on the next slightly-sensitive email you draft before sending it, and ask Teams for a recap of the next meeting you join more than five minutes late or have to skip entirely.