Module 3 of StartCloud's Copilot Essentials learning pathway, in six short units with a knowledge check: a practical app-by-app tour of Microsoft 365 Copilot in Word, Outlook, Teams, Excel and PowerPoint, covering where each saves real time and where it falls flat.
Copilot in the apps you use every day
Word and Outlook: the writing workhorses
If your working day involves writing anything longer than a text message, these two apps are where a Copilot licence earns its keep first. Not because the writing is brilliant (it is fine, and we will get to that), but because the boring halves of writing, the starting and the catching up, largely disappear.
Word
Drafting, rewriting, and summarising long documents
Ask Copilot to draft a document from a prompt, and it will happily reference other files, meetings, and emails you point it at, up to ten of them at once. Highlight any paragraph and it will offer rewrites for clarity or tone. And its best trick barely gets mentioned: paste in a long document, or open one, and ask for a summary. It can chew through documents up to roughly 80,000 words, which covers every contract, tender, and policy document a small business is ever likely to meet.
- First drafts of proposals, letters, and policies from a decent prompt
- Summarising a 40-page contract or tender before a meeting
- Rewriting a clunky paragraph three different ways in seconds
- Asking questions about a document instead of reading all of it
- Anything that needs your voice. Drafts read like a competent stranger wrote them
- Precise formatting and layout. It writes words, it does not design documents
- Facts and figures. It will confidently draft around numbers you never gave it, so check every one
Outlook
Summarising threads, drafting replies, and coaching
Three features carry Outlook. Summarise condenses a 25-message reply-all saga into a few sentences with the key points and who said what. Draft with Copilot writes a reply from a one-line instruction, with controls for tone and length. And Coaching is the quiet achiever: it reads a reply you wrote yourself and suggests improvements to tone, clarity, and how the message will land. That last one is useful the day you are typing angry.
- Catching up on a long thread after two days of leave
- Knocking out routine replies: scheduling, confirmations, follow-ups
- Coaching a touchy email before you hit send
- Rewriting a highlighted sentence that is not quite right
- Emails to people who know you. The polish is detectably not yours
- Anything sensitive or high-stakes. Draft it yourself, then let Coaching review it
- The classic Outlook for Windows app gets fewer features than new Outlook and the web version
Treat every Word and Outlook draft like work from a bright new intern: fast, well organised, slightly too formal, and never sent to a client without a once-over. Used that way, it is excellent. Sent as-is, it is how you end up signing off an email to your plumber with "Warmest regards".
Teams: the meeting memory you always wanted
Ask people with a Copilot licence what they would keep if they could only keep one thing, and the meeting features in Teams win by a street. Copilot can recap what was discussed, who committed to what, and pull out action items. Join twenty minutes late and you can quietly ask "catch me up" instead of interrupting. After the meeting, the recap gives you notes and tasks without anyone having been the designated scribe.
It also works in chat. Copilot can summarise up to 30 days of a chat thread, which is a small mercy when you return from leave to a channel with 400 unread messages. One limit: in chat it only reads the one conversation you are in, not your other chats, emails, or files.
Copilot in meetings runs entirely off the transcript, so transcription has to be on. Your admin can allow a saved transcript (Copilot keeps answering questions after the meeting ends) or a temporary one that exists only during the meeting and is deleted afterwards, which some organisations prefer for privacy. Either way, if nobody turns transcription on, Copilot sits in the corner knowing nothing. It also will not work at all in end-to-end encrypted meetings.
- Meeting recaps with notes and action items, no scribe required
- Catching up mid-meeting when you join late
- Asking questions during a meeting: what did we decide about pricing?
- Summarising a month of chat after annual leave
- Meetings where nobody turned transcription on. It cannot recap silence
- Action items from vague discussions. If nobody clearly owned the task in the room, Copilot will not fix that
- Half the meeting on a bad mic or talking over each other. The transcript, and everything built on it, suffers
Etiquette matters here too. Recording and transcription are visible to everyone in the meeting, and that is exactly as it should be. If external guests are on the call, say up front that the meeting is transcribed.
Excel: powerful, picky, and improving
Excel is where expectations most need managing. When the conditions are right, Copilot is terrific: ask it to highlight trends, suggest a formula, add conditional formatting, or answer plain-English questions about your data, and it shows you a preview of any change before applying it. When the conditions are wrong, it shrugs, and the conditions are wrong more often than the marketing suggests.
The big one: Copilot works best with data formatted as a proper table. One header row, one type of data per column, no merged cells, no subtotal rows wedged in the middle. It has improved (it can now reason over plain ranges that have a single clean header row), but the further your spreadsheet drifts from a tidy table, the less useful it gets.
One header row, consistent columns. Copilot can sort it, chart it, and answer questions about it.
Merged cells, notes in the data, mystery tabs. Copilot cannot untangle this, and neither can Kevin.
- Everyday questions about tidy data: which client spent the most this quarter?
- Formula suggestions when you know what you want but not the syntax
- Spotting trends and correlations you would have missed
- Conditional formatting without wrestling the rules dialog
- Messy real-world spreadsheets: merged cells, multiple header rows, notes in the margins
- Reasoning across several sheets or workbooks at once
- Complex financial models. It helps at the edges, it does not build them
In short: Copilot in Excel rewards businesses that already keep tidy data, and punishes the rest. If your spreadsheets are chaos, the fix is not a licence, it is an afternoon of cleanup. Then the licence gets good.
PowerPoint: fast first drafts, real limits
PowerPoint is the flashiest demo and the one that needs the most careful framing. Point Copilot at a Word document (a proposal, a report, even a PDF) and ask for a presentation, and thirty seconds later you have a structured deck: sections, speaker notes, images, the lot. As a way to skip the blank-slide stage, it is brilliant. It can also summarise an existing deck, answer questions about it, and do light tidying like adding sections and an agenda slide.
What the demo does not mention: a first draft is exactly what you get. The layouts are serviceable rather than beautiful, the stock imagery is generic, and unless your organisation has set up proper branded templates, the deck will not look like your business. For a Monday planning session, none of that matters. For the pitch that wins you a contract, expect to spend real time on the polish, because your audience can tell.
- Turning an existing Word document into a first-draft deck in under a minute
- Skipping blank-slide paralysis for internal presentations
- Summarising a 60-slide deck someone sent you at 4:55pm
- Adding structure: sections, agenda slides, basic reordering
- Client-ready polish. Layouts and imagery are serviceable, not stunning
- Your branding, unless proper corporate templates are set up first
- Data-heavy slides and precise chart work. Build those yourself
- Starting from nothing. A thin prompt gets a thin, generic deck
Write the substance in Word first, where Copilot's drafting is strongest, then hand that document to Copilot in PowerPoint for the deck. You get better slides from a good document than from a good prompt, every single time.
The cheat sheet: what to try first in each app
Five apps is a lot to absorb, so here is the whole module on one card. If you are rolling Copilot out to a team, this is the order of operations we suggest: start each person on the task in the green column of the app they live in, and leave the right-hand column well alone until the habit has formed.
One app, one task, two weeks
The people who get real value from Copilot do not try everything at once. They pick the one task above that matches their week, use it every day for a fortnight, and let the habit spread from there.
- Pick the app you spend the most hours in
- Use its green-column task daily until it is a reflex
- Always review before you send, save, or present
- Then, and only then, add the next app
- Microsoft Learn: Microsoft 365 Copilot overview
- Microsoft Learn: Manage Microsoft 365 Copilot in Teams meetings and events
- Microsoft Learn: Intelligent recap for Teams calls, meetings, and events
- Microsoft Learn: Microsoft 365 Copilot release notes
- Microsoft Learn: Archived Microsoft 365 Copilot release notes
Capabilities were current at the time of writing (July 2026). Copilot features roll out gradually and vary slightly between Windows, Mac, web, and mobile, so your buttons may differ a little.
Knowledge check
5 quick questions. Get 4 right and the module is yours.
1. What does Copilot in a Teams meeting need before it can do anything?
2. What kind of data does Copilot in Excel handle best?
3. What does Coaching by Copilot in Outlook actually do?
4. The smartest way to treat a Copilot draft in Word is as...
5. You need a client-ready pitch deck. What is the best use of Copilot in PowerPoint?