The Microsoft Copilot Prompt Library — 50+ Working Prompts by Surface (2026)

Most teams that buy Microsoft Copilot don't get the value they paid for. The product works. The users don't know what to ask it.

This is the library that fixes that. 50+ prompts organized by where you use them, with examples and notes on what works vs. what doesn't.

Copy any of these. Tweak the variables. Use them tomorrow.

How to use this library

Each prompt below has three parts:

• Use case — what job you're trying to do
• The prompt — exact text you can paste into Copilot
• What you'll get — the realistic output shape

The prompts use {{PLACEHOLDERS}} for the parts you fill in. Replace those with your real data.

Outlook prompts (8)

1. Email thread summary

Use case: Caught up on a 14-message thread without reading every reply.

Prompt: `` Summarize this email thread. Include the original question, key decisions made, current open items, and who owns each open item. Keep it under 150 words. `

What you'll get: A scannable summary with action items mapped to owners. Saves 10-15 min per long thread.

2. Draft a reply

Prompt: ` Draft a reply to this email. The point I want to make is {{YOUR_POINT}}. Tone: {{warm/direct/professional/apologetic}}. Length: under 100 words. End with a clear next step. `

What you'll get: A draft you can edit in 30 seconds. Saves 5-15 min per email.

3. Decline politely

Prompt: ` Draft a polite decline to this request. The reason is {{HONEST_REASON}}. Offer {{ALTERNATIVE_or_REFERRAL}} if applicable. Keep it under 60 words. Don't over-apologize. `

What you'll get: A no that doesn't leave damage. The "don't over-apologize" instruction is essential — Copilot defaults to apologetic.

4. Schedule a meeting from email context

Prompt: ` Draft a reply proposing 3 meeting times next week based on my calendar availability. The meeting should be 30 minutes. Include a Teams link automatically. `

What you'll get: Three time options pulled from your actual calendar. Cuts the back-and-forth.

5. Catch-up brief on a person

Prompt: ` I have a meeting with {{NAME}} tomorrow. Pull from our email history and any related documents in SharePoint. Brief me on: what we last discussed, any open items, and any context I should remember. `

What you'll get: Pre-meeting context you'd otherwise dig for. Materially better meetings.

6. Inbox triage

Prompt: ` Look at my unread emails from today. Categorize them as: urgent (needs reply today), important (needs reply this week), informational (no action needed), or noise (can archive). Surface only the urgent ones. `

What you'll get: A filtered list. Cuts triage time substantially.

7. Follow-up nudge

Prompt: ` Draft a polite follow-up to {{NAME}}. The original email was {{N}} days ago about {{TOPIC}}. Keep it brief, friendly, no guilt. End with a low-stakes way to revive the thread. `

What you'll get: A nudge that doesn't read as pushy.

8. Async update

Prompt: ` Draft an async update to {{STAKEHOLDER}} about {{PROJECT}}. Include: current status, what changed since last update, what's blocking, what I need from them. Tone: confident, direct. Under 200 words. `

What you'll get: A clean update that makes you look on top of things.

Word prompts (8)

1. First draft from notes

Prompt: ` Turn these notes into a {{TYPE: memo, brief, proposal, blog post, etc.}}. Audience: {{AUDIENCE}}. Length: {{N}} words. Tone: {{TONE}}.

Notes: {{PASTE_NOTES}} `

What you'll get: A first draft you can edit. Saves 60-80% of writing time on routine docs.

2. Convert voice memo to document

Prompt: ` This is a voice memo transcript. Turn it into a clean {{document type}} preserving my voice and key phrasings. Fix grammar and add structure but don't dilute the personality. Length: {{N}} words. `

What you'll get: Your own voice, cleaned up and structured. Critical for personal-brand content.

3. Tighten a draft

Prompt: ` Tighten this draft. Goal: cut 30% of the words without losing substance. Remove filler. Strengthen verbs. Don't add anything new. `

What you'll get: A leaner draft. Especially useful for executive summaries and emails.

4. Add structure to a wall of text

Prompt: ` Add structure to this document. Insert clear section headers, break long paragraphs, and add a 3-bullet executive summary at the top. Don't change the meaning. `

What you'll get: A scannable document. Your readers will thank you.

5. Translate technical to plain language

Prompt: ` Rewrite this technical document for a non-technical audience. The audience is {{AUDIENCE — e.g., board members, customers, non-engineering stakeholders}}. Remove jargon. Use analogies where appropriate. Don't simplify so much that it's wrong. `

What you'll get: A version your stakeholders can actually act on.

6. Generate a brief from a long doc

Prompt: ` Read this long document. Generate a 1-page brief for an executive who won't read the full thing. Include: the question this answers, the recommended action, the top 3 risks, and the financial implication. `

What you'll get: Executive-ready brief. Saves your boss 30 minutes.

7. Rewrite for tone consistency

Prompt: ` Match the tone of this draft to these voice samples: {{PASTE_2-3_SAMPLES}}. The current draft is too {{formal/casual/stiff/etc.}}. Adjust without changing the substance. `

What you'll get: A consistent voice across documents. Useful for teams with brand voice guidelines.

8. Compare two versions

Prompt: ` Compare these two versions of a document. Identify substantive changes (not just word edits). Surface anything where the meaning or position has actually shifted. `

What you'll get: A real diff, not a syntactic one. Critical for contract review and policy work.

Excel prompts (10)

1. Variance analysis

Prompt: ` Compare actual to budget across these columns. Flag any line item where actual exceeds budget by more than 15%. List the top 5 variances by dollar amount with a one-sentence likely cause based on the line item name. `

2. Cohort retention

Prompt: ` Treat customer_id as the cohort identifier. Group customers by their first transaction month. For each cohort, calculate retention at month 1, 3, 6, and 12. Build a heatmap. `

3. Outlier detection

Prompt: ` Find rows where the value in {{column X}} is more than 2.5 standard deviations from the mean. Group by {{category column}} and report which categories have the most outliers. `

4. Trend chart with annotations

Prompt: ` Build a line chart of monthly {{metric}} from this data. Add a 3-month rolling average overlay. Annotate the months where {{metric}} dropped more than 10% from the prior month. `

5. Customer segmentation

Prompt: ` Segment these customers into 4 tiers based on total spend in the last 12 months: VIP (top 10%), Strong (10-30%), Casual (30-70%), At-risk (bottom 30%). Add a tier column and color-code rows. `

6. Formula generation

Prompt: ` Write a formula that takes a date in column B, an amount in column C, and returns {{specific computation}}. Our fiscal year starts in April. Put the result in column D. `

7. Scenario matrix

Prompt: ` In this revenue model, assume customer count grows by X% and average revenue per customer grows by Y%. Show me the resulting ARR for X = 5, 10, 15% and Y = 0, 5, 10%. Build a 3x3 matrix. `

8. Data cleanup

Prompt: ` In this column, normalize everything: trim whitespace, lowercase, standardize date formats to YYYY-MM-DD. Show me unique values after cleanup so I can verify. `

9. Pivot from messy data

Prompt: ` Build a pivot table from this data: rows = {{dimension}}, columns = {{time period}}, values = sum of {{metric}}. Add row totals. Sort rows by total descending. `

10. Year-over-year comparison

Prompt: ` Build a year-over-year comparison. For each row, calculate the YoY % change. Highlight increases over 20% in green and decreases over 20% in red. Add a summary row at the bottom. `

PowerPoint prompts (5)

1. Generate slide outline from notes

Prompt: ` Turn these notes into a slide outline for a {{N}}-minute presentation. Each slide should have a clear single message. Aim for {{N}} slides total. Tone: {{TONE}}.

Notes: {{PASTE}} `

Note: Copilot's PowerPoint visual generation is weak. Use this for the outline. Rebuild visuals yourself or use a different tool.

2. Convert document to deck

Prompt: ` Read this Word document. Generate a {{N}}-slide deck that covers the key points. Each slide: clear title, 3-5 supporting bullets max. Skip anything that's filler in the doc. `

3. Speaker notes from slides

Prompt: ` Generate speaker notes for each slide in this deck. The notes should explain what to say (not just what's on the slide). Conversational tone. Aim for 30-45 seconds of speaking per slide. `

4. Executive summary slide

Prompt: ` Create an executive summary slide for this deck. Three bullets: situation, recommendation, ask. Each bullet under 12 words. `

5. Q&A prep

Prompt: ` Read this deck. Generate the 8 hardest questions an executive might ask after seeing this. For each, draft a one-paragraph answer. Be specific. `

Teams prompts (5)

1. Meeting recap

Prompt (inside meeting Copilot panel): ` Summarize this meeting. Decisions: list with owners. Action items: list with owners and deadlines. Open questions. Skip greetings and small talk. `

2. Catch up on a chat thread

Prompt: ` Summarize this Teams chat from the last 48 hours. What was discussed? What was decided? What do I need to respond to? `

3. Async update to a channel

Prompt: ` Draft a Teams channel post updating the team on {{TOPIC}}. Tone: matter-of-fact, not corporate. Length: under 150 words. Include a clear call-to-action if needed. `

4. Pre-meeting brief from prior meetings

Prompt: ` I have a Teams meeting with {{NAME}} tomorrow. Pull from our last 3 meetings together. What did we discuss? What's open? What did I commit to? `

5. Cross-meeting theme extraction

Prompt: ` Look at all my meetings from the last 2 weeks tagged with {{TAG or PROJECT}}. Surface the themes that came up repeatedly across meetings. `

SharePoint prompts (5)

1. Find a specific document

Prompt (in Copilot Chat): ` Find the most recent version of {{document type — policy, contract, brief}} about {{topic}} in our SharePoint. Confirm it's the latest version by checking the modified date. `

2. Cross-document synthesis

Prompt: ` Search our SharePoint for all documents about {{topic}}. Synthesize what they say into one summary. Flag any contradictions between documents. `

3. Policy answer with citation

Prompt: ` What's our policy on {{specific question}}? Cite the specific document and section. If we have multiple documents on the topic, identify which is canonical. `

4. Stakeholder identification

Prompt: ` Who in our company owns {{topic/process/system}}? Use SharePoint and Teams data to identify. List primary owner and key contributors. `

5. Historical context

Prompt: ` We're about to make a decision about {{topic}}. Have we made similar decisions before? Search SharePoint for prior decisions on similar topics and summarize what we learned. `

Copilot Studio (basic agent creation)

1. System prompt for an FAQ agent

` You are an assistant for {{TEAM/COMPANY}}. You answer questions about {{TOPIC AREA}} using only the connected knowledge sources. If you can't find the answer, say so honestly and offer to connect the user to a human. Tone: helpful, direct, not over-apologetic. Don't make up answers. Always cite the source document. `

2. System prompt for an intake agent

` You are an intake assistant for {{PROCESS}}. Your job is to capture structured information from users and create a record in {{DESTINATION — SharePoint list, Power Automate flow, etc.}}. Required fields: {{LIST}}. Ask only for what's required. If a user has additional context, capture it in a notes field but don't probe for more. `

3. System prompt for a status agent

` You are a status assistant for {{PROJECT/SYSTEM}}. Users ask you for current state. Pull data from {{SOURCES}}. Reply with: current status, recent changes, blockers, and next milestone. Always include data freshness ("last updated X ago"). ``

What Copilot doesn't do well (saves you the experiment)

• Generate good-looking PowerPoint slides (output is dated)
• Browse the web meaningfully (Edge integration is shallow)
• Work with very large Excel datasets (>100k rows)
• Write code (use Cursor or Claude Code instead)
• Long-form creative writing (Claude or ChatGPT are better)
• Image generation (use DALL-E, Midjourney, or Flux)
• Real-time data from internal systems (Copilot Studio with connectors works but takes setup)

The five rules for getting more from Copilot

• Be specific about output format. "Write a summary" is bad. "Write a 150-word summary with 3 bullets" is good.

• Provide voice samples for tone-sensitive tasks. Paste 2-3 examples of your preferred voice. Tell Copilot to match.

• Use negative instructions. "Don't use these phrases: {{LIST}}." Copilot defaults to corporate-helpful language. Negatives push it past defaults.

• Cite sources for anything factual. Add "cite the source document" to any retrieval prompt. Forces Copilot to ground answers.

• Start over instead of correcting. If a Copilot response is far off, don't iterate. Edit your original prompt and re-run. Iterating compounds drift.

What to do tomorrow

Pick the three prompts above that map to your most common workflows. Save them somewhere accessible (Notion, OneNote, even a Word doc).

Use each one twice this week. After two real uses, you'll know whether it fits.

By the end of a quarter, you'll have a personal prompt library of 15-20 that you use daily. That's where the real Copilot ROI lives — not in the marketing demos, but in the small habits that compound.

Start with three. Build from there.