Microsoft Copilot Use Cases: The Boring Ones Win

1Kill the endless email thread

Summary by Copilot sits at the top of a thread in Outlook, with numbered citations back to each email.

2Get the meeting recap (even for the ones you skipped)

Copilot in Teams (licence needed) answers your questions privately during the meeting, and after it if there's a transcript.

3Stop writing first drafts from zero

In Word, type / to point Copilot at a file, email or meeting, and it drafts from that instead of from thin air.

4Excel analysis without the Excel person

Formula columns, PivotTables and charts, just by asking. Edit mode is the default, so Copilot changes the workbook in front of you.

5Ask one question across all your work

With the licence, Copilot Chat searches your email, chats, meetings and files, with your own permissions. Free Copilot Chat sticks to the web, files you upload and, in Outlook, your inbox and calendar.

1Sales: walk into every call already prepared

Customer research and sales prep come first on Microsoft's own list for sellers. Copilot pulls the email history, the meeting recaps and any proposal draft you point it at before your call, so you don't have to.

Prompt: Prepare me for my call with [customer] tomorrow. Summarize our emails and meetings from the last 3 months, list open questions and anything we promised, and suggest 3 questions to ask. Put it in a table.

2Marketing: stop writing from a blank page

Content creation is first on Microsoft's marketing list. Writing from zero gives you generic AI copy (we've all read it). Repurposing what you already have works better: a webinar into a blog draft, a launch deck into 5 emails. With the licence, PowerPoint also builds on your company template.

Prompt: Use /[launch brief] and /[product FAQ]. Write 3 versions of a LinkedIn post announcing [product] for [audience]: practical, bold, and built around a customer problem. Under 120 words each.

3HR: the company-wide email nobody wants to write

Policy updates, onboarding and recruiting are on Microsoft's HR list. Copilot is great at the drafting: policy updates, onboarding plans, the company-wide email nobody wants to write. One line for European HR teams: Microsoft's own transparency note says to avoid uses that could have a consequential impact on life opportunities or legal status, and the EU AI Act treats recruitment and worker-evaluation systems as high-risk (obligations apply from 2 December 2027). Copilot drafts. People decide.

Prompt: Compare /[old hybrid work policy] with /[new hybrid work policy]. List every change in a table: old rule, new rule, who's affected. Then draft a short, friendly email to all staff that explains the 3 biggest changes.

4Finance: explain the variance before the CFO asks

Contract review and amendment comparisons are on Microsoft's finance list. In Excel, just ask: a profit-margin column, a PivotTable by month, an explanation of the formula someone left behind years ago. The Analyst agent runs Python on your data and shows you the code.

Prompt (Excel): Add a column with the variance between budget and actual for each cost centre, in % and [currency]. Highlight anything over 10%. Then write 3 sentences for the CFO on the biggest variances.

5Legal: the first-pass redline (a lawyer still signs)

Comparing clauses against your standard terms is Microsoft's own legal scenario. Copilot in Word can edit with Track Changes on, so changes show up as redlines you review. It's not a lawyer (Microsoft's Word FAQ warns the content can be inaccurate), so treat it as a first pass a lawyer signs off on.

Prompt: Compare this contract with /[our standard NDA]. List every clause that deviates in a table: clause, their wording, our standard wording, risk (high, medium, low). Keep the document as it is for now.

6Operations and PM: the status update you don't write from scratch

Microsoft's operations list reads like a project manager's week: a change management plan, a supplier RFP, a business review, a project review. Add the Planner Agent (with the licence since June 2026), which drafts plans, tasks and status updates for you to approve. More in Copilot for project managers.

Prompt: Look at my emails, Teams chats and meetings about [project] from the last 7 days. Write a status update for the steering committee: progress, risks, decisions needed, next steps.

7Executive assistants: the briefing is ready before the boss asks

Schedule with Copilot turns an email thread into an invite with a title, an agenda and the thread attached (licence only). Microsoft also ships an Executive Briefing Agent template for leadership-meeting prep. One limit: scheduling by chat handles up to 2 other people, so the 9-person board meeting is still yours. The full playbook: Copilot for executive assistants.

Prompt: Prepare a one-page briefing for [executive]'s meeting with [company] on [date]. Use our recent emails, Teams chats and shared files, plus public news from the last 30 days. Include talking points, open issues and 3 likely questions.

8Managers: 5 minutes late? Copilot catches you up

Join a Teams meeting 5 or more minutes late and Copilot offers to catch you up. Before a 1:1, ask what you discussed last time and what you promised. For reviews, use Copilot to gather evidence and draft, never to judge people (my guide: Copilot prompts for performance reviews). And Microsoft's own day-prep prompt is worth stealing.

Microsoft's prompt: Triage my meetings tomorrow and suggest where I might get time back.

1Outlook

Summary by Copilot for long threads, Coaching by Copilot for tone and clarity before you hit send, and Prioritize my inbox for new mail (it doesn't re-score old messages). Exchange Online mailboxes only. More in Copilot prompts for Outlook.

Microsoft's prompt (needs the licence for the chats and documents part): Which unread emails are most important? Summarize them, synthesize any related context from my chats and documents, and prioritize the order in which I should respond.

2Teams

Ask Copilot privately during a meeting, get a recap after it (that needs a transcript), and add Facilitator for shared notes. During the meeting, Copilot can work without a saved transcript if your admin allows it (Copilot meeting notes without recording).

Microsoft's prompt: Recap meeting summarizing key takeaways and action items as separate sections, including who's responsible for each.

3Word

Copilot opens in edit mode. Draft from your own files with /, rewrite for a different reader, turn a messy paragraph into a table, and ask what a customer might find unclear before you send it.

Microsoft's prompt: Turn this text into a table with columns for task, owner, due date, and status.

4Excel

Formula columns, lookups, PivotTables and charts, in edit, plan or chat mode. Clean Data on the Data tab (Excel for the web and Windows, for Copilot customers) fixes messy text, number formats and extra spaces. And the =COPILOT() function is gone, retired on 14 September 2026 (what replaces it). More in Copilot prompts for Excel.

Microsoft's prompt: Create a PivotTable with the sum of sales, with month in rows and category in columns.

5PowerPoint

Build a deck from a Word document (or a PDF, with the licence), start from your company template (licence only), add speaker notes, and translate the deck through chat (save a copy first). Step by step: a PowerPoint from a Word document.

Microsoft's prompt: Create an onboarding presentation based on this /[document].

6Copilot Chat

Put a project's files in a Notebook so answers stay inside those sources, and schedule a prompt (licence needed) so it runs without you asking.

Prompt: What did I commit to in emails and meetings last week that I haven't done yet? List each item with who's waiting and the source.

7Agents

Researcher writes cited reports from the web plus your work content. Analyst does data analysis with Python. Agent Builder makes a quick agent for you or a small team. And Cowork does the work itself (emails, meetings, files), with you approving actions before they happen, on top of the licence, billed in Copilot Credits. Guides: Researcher vs Analyst and how to use Copilot Cowork.

Prompt (Researcher): Research [competitor]'s pricing and product changes over the last 6 months. Combine public sources with anything in my emails and files about them. Cite every claim.

140 ideas, zero habits

A feature tour gives everyone 40 ideas and nobody a habit. Pick 2 or 3 per team, tied to weekly work, and go deep. (I see this pattern over and over.)

2Practising on fake demo files

Real documents beat sample files, by a mile. The "that's exactly my problem" moment is what turns a skeptic into a user.

3The salary folder surprise

Copilot only shows what a user can already open. If half the company can open the salary folder, Copilot will find it for them. Fix permissions before the rollout. Read is Copilot safe for confidential information.

4Giving up after the first bad draft

Microsoft itself says to review what Copilot writes. Bad output is normal. The fix is usually a better prompt, so don't give up after 3 tries.