Our Copilot overview covers what it is and whether it is worth the licence. This note goes one level down: app by app, what it actually does, what that looks like on a normal working day, and where you still need to keep your eyes open.
Throughout, remember the rule that applies everywhere: Copilot can only use information it can reach and, within your organisation, only information you already have permission to open. Connectors can extend that reach into other business systems, while web search gives it access to public information. Anything held in an unconnected private system stays invisible to it.
Outlook: the biggest everyday win
For most people, Outlook is where Copilot pays for itself.
- Summarise a thread. Open a 30-message chain you have been copied into and ask for a summary. You get who wants what, what has been agreed, and what is still open, in seconds.
- Draft a reply. Tell it the gist ("decline politely, suggest next month") and it drafts in context, because it has read the thread. Adjust the tone and length before you insert it. You can also save standing instructions about how you like your mail written, so "in my tone" stops being something you ask for every single time.
- Coaching. Ask it to review a draft you wrote yourself: tone, clarity, what a reader might take badly.
- Prioritise the inbox. Copilot can assess messages as they arrive and mark their priority using factors you define, such as the sender, the subject, or a project you are tracking.
- Turn a thread into a meeting. It can draft the invitation, the title and an agenda from the conversation, and include the people who were on it.
Watch for: drafts that are polite but empty. Copilot will happily write three flowing paragraphs that say nothing. Give it the substance; let it handle the wrapping.
Word: from first draft to finished structure
- Draft from a brief. A proposal, letter, policy or job ad from a few sentences of instruction, and it can reference an existing document: "draft a proposal for X, based on the structure of this one".
- Rewrite what is there. Select any passage and have it tightened, made more formal, or turned into bullet points.
- Edit the whole document. Ask it to reorganise a proposal, shorten the sections that repeat each other, add a conclusion and make the formatting consistent. Edit with Copilot, which Microsoft first launched as Agent Mode, carries out several connected changes in the document itself and formats the result with Word's own styles, instead of handing you text to paste in.
- Summarise a long document. Open a 40-page report and ask what matters. Good for getting oriented before a meeting, though a very long document often summarises better a section at a time. A summary is there to orient you, not to save you reading the part you will be held to.
Watch for: confident filler. A first draft from Copilot is scaffolding, not a finished document. It will invent plausible-sounding specifics, dates, figures, commitments, that nobody agreed. Everything factual needs your check before it leaves the building.
Teams: the meeting memory
This is the feature people mention most in training, months later.
- Recaps. With transcription on, Copilot produces a summary of the meeting with decisions and actions, and who took them.
- Catch-up mid-meeting. Join twenty minutes late and ask what you missed, quietly, without interrupting.
- Ask about a conversation. Open a chat or channel and ask "What did Priya say about the delivery date?" Copilot answers from that conversation and links back to the messages it used, looking at the last 30 days unless you tell it otherwise. It is reading that one conversation, not all of them. For a question spanning several chats and files, use Microsoft 365 Copilot Chat instead.
Watch for: attribution slips. Recaps occasionally credit the wrong person with a view or an action, and a summary of a rambling meeting is a summary of a ramble. Skim before you forward one as a formal record. Teams notifies participants when transcription starts, but your business should still be clear about when meetings may be transcribed, who can see the transcript, and how long it is kept.
Excel: no longer the junior partner
- Explain. Point at a formula you inherited and ask what it does. Genuinely helpful.
- Analyse. Ask questions of a table in plain English: totals, trends, outliers, and get a chart back.
- Build formulas. Describe the calculation you want and it writes the formula.
- Hand over the whole job. Edit with Copilot will build and rework a spreadsheet itself: formulas, PivotTables, cleaning up messy data, and analysis in Python.
Watch for: data that is not in a clean table. Copilot in Excel wants tidy, labelled columns; on the average real-world spreadsheet, with merged cells and notes in the margins, it struggles. Edit with Copilot has closed most of the gap on the other three apps, but it can still reach a confidently wrong answer from a messy sheet, so check its arithmetic the way you would a new hire's.
The pattern across all four apps is the same: Copilot is strong at reading, summarising, drafting and restructuring, but unreliable when it has to fill gaps. Let it do the first pass; keep the judgement.
The skill is knowing which job to hand it
None of the features above are hard to use. The gap between teams that get value and teams that do not is knowing, by reflex, which jobs to hand over and which to keep, and being fast at checking what comes back. That reflex is what hands-on training starts to build, using your team's real emails and documents rather than demo data. Practice afterwards is what turns it into the normal way of working.
Written with Claude, then steered, cut and checked by me. I answer for it.
Explore Benchmark Lab’s free indices for personal AI use, organisational adoption and governance. All are in Research beta and can be used independently of training.