--- id: copilot-everyday-apps-deeper lang: en track: copilot title: "Copilot in your everyday apps, deeper" seoTitle: "Copilot in Excel, Outlook and Teams, deeper" description: "Go deeper with Copilot in everyday apps: Python-powered analysis in Excel, email coaching and thread summaries in Outlook, and meeting recaps in Teams." part: advanced partTitle: "Advanced and specialised" partOrder: 5 order: 3 level: Advanced durationMinutes: 11 outcome: "Run a Python-powered analysis in Excel, use Outlook's email coaching before you send, and get a usable recap of any Teams meeting." summary: "Copilot behaves differently in each app: Excel's advanced analysis runs visible Python, Outlook coaches your tone and summarizes threads, and Teams supports meetings live and after." draft: false updated: "2026-10-14" furtherReading: - title: "Copilot in Excel with Python" url: "https://support.microsoft.com/office/copilot-in-excel-with-python-364e4ae9-9343-4d56-952a-5f62b0f70db6" note: "How advanced analysis runs Python in Excel, with requirements and limits." - title: "Get email coaching with Copilot in Outlook" url: "https://support.microsoft.com/office/email-coaching-with-copilot-in-outlook-91a3cd56-1586-4a31-85c7-2eb8cdb02405" note: "How to use Coaching by Copilot in Outlook and which accounts support it." - title: "Use Copilot in Microsoft Teams meetings" url: "https://support.microsoft.com/en-us/office/use-copilot-in-microsoft-teams-meetings-0bf9dd3c-96f7-44e2-8bb8-790bedf066b1" note: "What Copilot can do during and after a Teams meeting, and what it needs." keywords: - Copilot in Excel - Excel advanced analysis Python - Copilot in Outlook - Outlook email coaching - Copilot in Teams meetings - Teams meeting recap quiz: intro: "Five quick questions. Ace them all and the next lesson unlocks." passScore: 5 questions: - q: "What makes Excel's advanced analysis different from a plain Copilot chat answer about your data?" options: - "It works faster but hides how it got the answer" - "It only works on pivot tables" - "It shows the actual Python code in the sheet, so the method can be checked" - "It needs you to write the Python yourself" answer: 2 explain: "Advanced analysis shows its actual Python code in the sheet, making the method checkable rather than a black-box claim." - q: "Who currently has access to Outlook's Copilot features, including email coaching?" options: - "Any account added to Outlook, including Gmail, Yahoo, and iCloud" - "Work or school accounts and personal Microsoft accounts on outlook.com, hotmail.com, live.com, or msn.com" - "Only Outlook on Windows, never mobile or Mac" answer: 1 explain: "Gmail, Yahoo, and iCloud addresses can still use Outlook, but Copilot features do not appear on those accounts. That is an account-level limitation, not a bug." - q: "What does Copilot do near the scheduled end of a Teams meeting?" options: - "It ends the meeting automatically" - "It starts transcribing the meeting" - "It sends the full transcript to every participant" - "It prompts the group to wrap up, summarizing key points and listing next steps and owners" answer: 3 explain: "It nudges the group toward closing the meeting with a summary and a list of next steps and owners, which can shorten meetings that would otherwise run long." - q: "What happens to Copilot's conversation history in a recurring meeting series when transcription is turned on or off?" options: - "Copilot's existing conversation history for that series is removed" - "Nothing changes; the history carries over" - "The history is moved to the Recap tab" answer: 0 explain: "Toggling transcription in a recurring series removes Copilot's existing conversation history for that series, so switching it mid-series can quietly erase context." - q: "What is the common thread connecting advanced analysis, email coaching, and meeting recap?" options: - "All three need a Copilot Studio flow set up first" - "All three ground on content you already have access to, the grounding mechanic from lesson 4.1 applied per app" - "All three need a Teams Premium add-on" - "All three work on any email account" answer: 1 explain: "All three ground on content you already have access to (your data, your mail, your meeting), the same grounding mechanic from lesson 4.1 applied per app." pass: badge: "Perfect score" title: "You know where Copilot goes deep." body: "Full marks. You can analyse data in Excel, coach an email in Outlook, and recap a Teams meeting. Next up, the final lesson: Copilot playbooks, chaining features into repeatable work." retry: "Check the marked answers and give it another go. You've got this." --- > **Level:** Advanced ยท **Reading time:** ~11 min > > **What you'll be able to do:** run a Python-powered analysis in Excel, use Outlook's email coaching before you send, and get a usable recap of any Teams meeting.
Three apps, three different depthsThree rows. Excel: advanced analysis runs visible, checkable Python. Outlook: email coaching reviews tone before you send. Teams: live recap during and after a meeting.Three apps, three different depths1ExcelAdvanced analysis: visible, checkable Python on your data.Analysis2OutlookEmail coaching: reviews tone before you hit send.Coaching3TeamsMeeting recap: live during, cited summary after.RecapSame Graph grounding underneath, a genuinely different depth per app.
## 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](/learn/copilot/working-smart/researcher-and-analyst)) 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](/learn/copilot/getting-started/first-steps-in-copilot) 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](/learn/copilot/working-smart/context-and-grounding), 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](/learn/copilot/getting-started/giving-copilot-context) 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](/learn/copilot/getting-started/which-copilot-do-you-have)'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. ## Key terms [Advanced analysis](/glossary#advanced-analysis), [Email coaching](/glossary#email-coaching), [Intelligent Recap](/glossary#intelligent-recap), [Meeting transcript](/glossary#meeting-transcript), [Copilot](/glossary#copilot)