Assistant Prompt Library

Best Copilot Prompts: Curated Examples for Microsoft 365 & Productivity

Microsoft Copilot is integrated directly into the Microsoft 365 suite — Word, Outlook, Teams, Excel, and PowerPoint. Its primary value is in-context productivity: working on documents you are already in, summarizing meetings you just had, and drafting emails within threads. These prompts are organized around those in-context, workflow-embedded tasks.

What makes Copilot prompting different

Copilot's defining characteristic is ecosystem integration. Unlike standalone AI assistants, Copilot can access your actual Microsoft 365 content — your email threads, your shared documents, your calendar, your Teams conversations — and use that context in its responses. This means prompts can reference real content without copy-pasting it into a separate interface.

The most effective Copilot prompts are specific about the task, the context (which document, which thread, which meeting), and the output format needed. Copilot works best for structured, well-defined tasks within the Microsoft ecosystem — document drafting and editing, meeting summarization, email composition, spreadsheet formula creation, and slide content generation.

Who these prompts are for

Microsoft 365 users — knowledge workers, managers, executives, analysts, HR professionals, project managers, and anyone who spends significant work time in Word, Outlook, Excel, Teams, or PowerPoint.

Best use cases for Copilot

Drafting and editing Word documents in context
Summarizing and responding to Outlook email threads
Summarizing Teams meeting recordings and extracting action items
Creating Excel formulas and analyzing spreadsheet data
Building PowerPoint slide outlines and speaker notes
Rewriting and improving existing documents without leaving Word

Prompt examples

Word — draft a section

Draft a [section type — e.g. executive summary / methodology / conclusion / introduction] for this document based on the content already in the document. The audience is [describe]. Keep the tone consistent with the rest of the document. Length: [target length]. Focus on [specific goal of this section].

Use this in Word with Copilot. It reads the existing document content so you do not need to describe it.

Word — rewrite for clarity

Rewrite the selected [paragraph / section] to be clearer and more concise. Keep the same meaning and factual content. Improve the sentence structure and remove any redundant phrasing. After rewriting, note the most significant change you made.

Outlook — summarize thread

Summarize this email thread. For each person who has responded: what they asked or stated, any commitments they made, and any unresolved items. Then list the 3 most important action items and who is responsible for each. Format: short bullet points, not prose.

Outlook — draft reply

Draft a reply to this email. My goal: [describe what you want to communicate or accomplish]. Tone: [professional / direct / warm / formal]. Length: [short — under 150 words / medium / thorough]. Key points to include: [list]. One thing to avoid: [specify].

Teams — meeting summary

Summarize this Teams meeting. Provide: the main topic and goal of the meeting, 3–5 key decisions or conclusions reached, action items with the name of the person who owns each and the target date mentioned, and any unresolved questions that need follow-up. Format: concise bullet points.

Excel — formula creation

Create an Excel formula that [describe what you want it to do]. My data structure: [describe columns — e.g. Column A has dates, Column B has amounts, Column C has categories]. The formula goes in cell [cell]. Requirements: [any constraints — e.g. must handle empty cells / should be readable without array formulas / needs to filter by category]. Explain the formula so I can modify it if needed.

Excel — data analysis

Analyze this spreadsheet data and provide: a summary of the key trends, the [highest / lowest / most frequent] values in [column], any outliers or unusual patterns, and 2 observations that would be useful for [business decision or reporting goal]. Format the insights as bullet points, not a full paragraph.

PowerPoint — slide outline

Create a [number]-slide outline for a presentation on [topic] for [audience]. For each slide: slide title and 3–4 bullet points of content. Keep it structured for a [presentation type — e.g. quarterly business review / client pitch / team training]. The key message the audience should leave with: [describe].

PowerPoint — speaker notes

Write speaker notes for this slide. The slide covers: [paste or describe slide content]. The speaker is [describe their role and expertise]. The audience is [describe]. Notes should be natural spoken language — not a script to read word for word. Target: 90–120 seconds of speaking time. Include one anecdote placeholder or example for the main point.

Word — policy or procedure document

Draft a [policy / procedure / guideline / SOP] for [topic]. Audience: [describe — e.g. all employees / new hires / managers / a specific team]. Include: purpose (1–2 sentences), who this applies to, the policy or procedure (numbered steps for procedures), exceptions or edge cases, and how to get help or escalate. Keep it clear enough for someone reading it for the first time.

Common mistakes with Copilot prompts

Not using in-context prompting: Copilot's value is accessing your actual Microsoft 365 content. If you are in Word, prompt Copilot within Word — do not copy the document to another tool. The in-context integration is the primary advantage.
Vague task descriptions: "Help me with this email" gives Copilot nothing to work with. Specify the goal, the recipient, the tone, and the key points to include.
Expecting Copilot to know context it does not have: In Microsoft 365 Copilot, it has access to documents and emails in your tenant. In Copilot.microsoft.com (without 365), it does not. Know which version you are using.
Using Copilot for highly sensitive documents without checking your organization's data policies: Microsoft 365 Copilot processes content within your tenant, but confirm your organization's AI usage policies before processing confidential documents.

How to customize these prompts

For Word and PowerPoint prompts, always specify the audience and the goal of the document — not just the topic. For Outlook and Teams prompts, the in-context integration means Copilot reads the actual thread or transcript, so you do not need to paste it; just describe what you want extracted or done.

Related resources

Build productivity prompts

Use the AI Prompt Generator to create structured prompts for documents, emails, and meetings.

Open AI Prompt Generator