50 Best Microsoft Copilot Prompts in 2026: Templates for Office 365

Write a 2,000-word report on [TOPIC] for [AUDIENCE].

Structure:
- Executive summary (200 words max)
- Background and context
- Key findings with data
- Analysis and implications
- Recommendations with next steps

Tone: professional but accessible. Use headers 
and bullet points for scannability.

Rewrite this document for [NEW AUDIENCE].

Keep the same data and conclusions. Change the:
- Vocabulary level and technical depth
- Length (shorter/longer based on audience needs)
- Emphasis (what matters most to this reader)

Preserve all factual claims.

Draft a company policy on [POLICY TOPIC].

Include:
- Purpose and scope
- Definitions of key terms
- Policy statements (numbered)
- Roles and responsibilities
- Compliance and enforcement
- Effective date: [DATE]

Match the tone of our existing HR policies in 
/[SharePoint folder].

Convert these meeting notes into a structured 
action item document:

[PASTE NOTES OR REFERENCE MEETING]

Format each action item with:
- Owner
- Due date
- Priority (high/medium/low)
- Dependencies

Add a summary paragraph at the top.

Summarize this contract in plain language.

/[contract file]

Extract:
- Key obligations for each party
- Important dates and deadlines
- Financial terms and payment schedule
- Termination conditions
- Unusual or non-standard clauses

Flag anything that needs legal review.

Create a client proposal for [SERVICE/PRODUCT] 
for [CLIENT NAME].

Sections:
- Problem statement (their specific challenge)
- Proposed solution and approach
- Timeline with milestones
- Pricing and payment terms
- Team qualifications
- Case studies or references

Reference our past proposals in /[folder] for style.

Write an SOP for [PROCESS NAME].

Include:
- Purpose and scope
- Required tools/systems/access
- Step-by-step procedure (numbered)
- Decision points with criteria
- Troubleshooting common issues
- Version history table

Keep language clear enough for a new employee.

Create a one-page executive brief on [TOPIC].

Structure:
- Headline finding (one sentence)
- 3-4 key insights with supporting data
- Recommended action
- Risk if no action is taken

Maximum 500 words. No jargon.

Compare these two documents and highlight:
/[document 1]
/[document 2]

- Material differences in terms or language
- New additions or removals
- Changed numbers or dates
- Inconsistencies between the two

Present as a table: section, document A, document B.

Synthesize the key findings from these documents:
/[file 1]
/[file 2]
/[file 3]

Create a unified summary that:
- Identifies common themes across all sources
- Notes contradictions or gaps
- Provides an integrated recommendation

Clean up this spreadsheet:
- Remove duplicate rows
- Standardize date formats to YYYY-MM-DD
- Fill empty cells in [COLUMN] with "N/A"
- Fix inconsistent capitalization in [COLUMN]
- Create a summary of changes made

Create a sales analysis dashboard from this data.

Include:
- Monthly revenue trend (line chart)
- Top 10 customers by revenue (bar chart)
- Sales by region (pie chart)
- Month-over-month growth percentage
- Average deal size calculation

Highlight any months with negative growth in red.

Build a 12-month financial projection model.

Inputs needed:
- Monthly revenue: [AMOUNT] growing at [RATE]%
- COGS: [PERCENTAGE]% of revenue
- Fixed costs: [LIST WITH AMOUNTS]
- Variable costs: [LIST WITH PERCENTAGES]

Outputs:
- Monthly P&L statement
- Cash flow projection
- Break-even analysis
- Key ratios (gross margin, burn rate)

Create a pivot table from this data showing:
- Rows: [FIELD 1]
- Columns: [FIELD 2]
- Values: Sum of [FIELD 3], Average of [FIELD 4]

Add a slicer for [FILTER FIELD].
Sort by total descending.

Analyze these survey results:

Calculate:
- Response rate
- Average score for each question
- Distribution of responses (1-5 scale)
- Statistical significance between groups
- Top 3 and bottom 3 areas

Create charts for the top-level findings.

Build an inventory management sheet with:
- Current stock levels
- Reorder point calculations (based on lead time 
  and daily usage)
- Automatic alerts when stock falls below threshold
- Cost tracking (unit cost × quantity)
- Monthly usage trend per item

Use conditional formatting for low-stock warnings.

Create a scheduling template for [NUMBER] employees 
across [SHIFTS].

Constraints:
- Maximum [X] hours per employee per week
- Minimum [Y] employees per shift
- No back-to-back closing and opening shifts
- [EMPLOYEE NAMES] unavailable on [DAYS]

Highlight conflicts automatically.

Build a budget tracking sheet that compares:
- Budgeted amounts (from /[budget file])
- Actual spending (from this data)

Show:
- Variance ($ and %) for each line item
- Running total year-to-date
- Projected year-end based on current trends
- Categories that are over budget (highlighted red)

Segment these customers based on:
- Purchase frequency
- Average order value
- Total lifetime value
- Last purchase date

Create RFM (Recency, Frequency, Monetary) scores.
Label segments: Champions, Loyal, At Risk, Lost.
Add a summary chart.

Build a KPI tracking dashboard with:

Metrics: [LIST YOUR KPIS]

For each KPI:
- Current value
- Target value
- Trend (up/down/flat vs last period)
- RAG status (Red/Amber/Green)

Use sparklines for trends. Update monthly.

Create a 15-slide presentation for [CLIENT] on 
[TOPIC].

Use data from /[Excel file] and /[Word report].

Structure:
- Title and agenda (2 slides)
- Situation analysis (3 slides)
- Key findings with charts (4 slides)
- Recommendations (3 slides)
- Timeline and next steps (2 slides)
- Q&A (1 slide)

Match our company template in /[template folder].

Build a QBR deck from these sources:
- Sales data: /[file]
- Customer feedback: /[file]
- Team metrics: /[file]

10-12 slides covering:
- Quarter highlights and lowlights
- Revenue vs target (with chart)
- Customer health scores
- Team performance
- Next quarter priorities

Create a training deck on [TOPIC] for [AUDIENCE].

20 slides with:
- Learning objectives upfront
- One concept per slide
- Visual examples for each concept
- Practice exercises (3-4 slides)
- Quick reference summary at the end

Keep text minimal. Use visuals to explain.

Build a product launch presentation for [PRODUCT].

Cover:
- Market problem and opportunity
- Product overview and key features
- Competitive positioning
- Pricing and packaging
- Go-to-market timeline
- Success metrics

Target audience: [INTERNAL TEAM / CUSTOMERS / PRESS].

Create a board presentation from this month's data.

/[monthly report file]

Structure:
- Financial overview (2 slides, charts only)
- Strategic progress vs plan
- Key risks and mitigations
- Resource and hiring update
- Decisions needed from the board

Maximum 10 slides. No paragraph text on slides.

Build a competitive analysis presentation.

Compare us vs [COMPETITOR 1], [COMPETITOR 2], 
[COMPETITOR 3] on:
- Market positioning
- Feature comparison (table format)
- Pricing comparison
- Strengths and weaknesses
- Our differentiation strategy

Use publicly available data. Note all sources.

Create a project status deck for [PROJECT].

Include:
- Overall RAG status with justification
- Milestones completed and upcoming
- Budget tracking (planned vs actual)
- Risks and issues log
- Resource allocation
- Timeline with critical path

Pull data from /[project tracker].

Build a monthly investor update presentation.

Slides:
- Headline metrics (MRR, growth, churn)
- Key wins this month
- Product milestones
- Financial snapshot
- Cash runway
- Asks (hiring, intros, advice)

Keep it under 8 slides. Data-heavy, narrative-light.

Draft a follow-up email based on the meeting 
with [NAME] on [DATE].

Include:
- Thank them for their time
- Summarize the 3 key decisions made
- List action items with owners
- Propose next meeting date
- Attach relevant documents mentioned

Tone: warm but professional. Under 200 words.

Write a prospecting email to [ROLE] at [COMPANY].

Our product: [ONE-LINE DESCRIPTION]
Their likely pain: [SPECIFIC CHALLENGE]
Our proof point: [RELEVANT CASE STUDY/STAT]

Rules:
- Subject line under 6 words
- Under 100 words body
- One specific ask
- No "I hope this finds you well"

Draft an email addressing [SENSITIVE ISSUE] 
with [RECIPIENT].

Requirements:
- Acknowledge the situation directly
- Avoid blame language
- Propose a specific solution
- Set a clear next step
- Maintain professional relationship

Tone: direct, empathetic, solution-oriented.

Write a project update email to [CLIENT].

Reference: /[project status document]

Cover:
- Progress since last update
- Upcoming milestones this week
- Any blockers or changes to timeline
- Questions or decisions needed from them

Keep it scannable with bullet points.

Draft a company-wide announcement about [NEWS].

Structure:
- Headline summary (one sentence)
- What's happening and when
- Why this matters to the team
- What changes for employees
- Where to go with questions

Tone: transparent and positive. Under 250 words.

Write an email to [VENDOR] requesting [BETTER 
TERMS/PRICING].

Include:
- Reference our contract history
- Specific ask with numbers
- Business justification
- What we offer in return (longer term, volume)
- Professional deadline for response

Summarize my unread emails from the last 24 hours.

Group by:
- Requires action (with priority)
- FYI only
- Can be archived

For action items: who sent it, what they need, 
and suggested response.

Draft a meeting request to [PERSON/GROUP].

Purpose: [SPECIFIC GOAL]
Duration: [TIME]
Context: Reference /[relevant document or email]

Include:
- Why this meeting matters now
- Specific questions to address
- Pre-read materials (attached)
- Proposed agenda

Draft a performance review summary email for 
[EMPLOYEE].

Reference: /[review document]

Include:
- Overall performance rating
- Top 3 strengths with examples
- 2 areas for growth
- Goals for next quarter
- Positive closing

Tone: constructive and encouraging.

Write an email to [CLIENT] addressing [ISSUE].

Structure:
- Acknowledge the problem directly
- Explain what happened (briefly, no excuses)
- State what we've done to fix it
- Prevent recurrence steps
- Offer [COMPENSATION/GOODWILL]

Tone: professional accountability.

Summarize the Teams meeting from [DATE/TIME].

Include:
- Key decisions made
- Action items with owners and deadlines
- Unresolved topics
- Follow-up meeting recommendation

Format as a Teams message I can post to the channel.

What happened in [CHANNEL NAME] this week?

Summarize:
- Important announcements
- Decisions that affect the team
- Questions that are still unanswered
- Files or links shared

Skip casual conversation and reactions.

Compare these three documents and identify:
/[Q1 report]
/[Q2 report]
/[Q3 report]

- Trends across all three periods
- Metrics that improved vs declined
- Inconsistencies in reporting
- Projected trajectory for Q4

Prepare me for my meeting with [PERSON] at [TIME].

Pull from:
- Our recent email thread
- Their company's latest news
- Notes from our last meeting
- Relevant documents in /[folder]

Give me: talking points, their likely priorities, 
and questions to ask.

Generate my weekly status report from:
- My sent emails this week
- Completed tasks in Planner/To-Do
- Teams meetings attended
- Documents I edited

Format: accomplishments, in-progress, blockers, 
next week priorities.

Turn this Teams conversation into a knowledge 
base article:

[PASTE OR REFERENCE THREAD]

Structure:
- Problem statement
- Solution steps (numbered)
- Common variations
- Related resources

Write for someone encountering this issue for 
the first time.

Create a 30-day onboarding plan for a new 
[JOB TITLE].

Week 1: Setup and orientation
Week 2: Core training and shadowing
Week 3: Guided practice
Week 4: Independent work with check-ins

Include: responsible person, resources needed, 
completion criteria for each item.

Compile a project brief from our Teams discussions.

Search messages about [PROJECT NAME] in [CHANNEL].

Extract:
- Project goal and scope
- Key requirements mentioned
- Timeline discussed
- Team members involved
- Open questions

Format as a proper project brief document.

Create an expense report from:
- My calendar events for [DATE RANGE]
- Receipts in /[folder]

Calculate:
- Total by category (travel, meals, lodging)
- Per diem vs actual comparison
- Amounts requiring manager approval
- Currency conversions if applicable

Search my emails and Teams for mentions of 
[COMPETITOR NAME] in the last 3 months.

Compile:
- What colleagues are saying about them
- Customer mentions or comparisons
- Features or pricing they've referenced
- Any wins or losses against them

I need to prepare for next week's board meeting.

Steps:
1. Summarize this month's financials from 
   /[Excel file]
2. Pull key decisions from Teams #leadership channel
3. Draft a board memo in Word
4. Create a 10-slide deck in PowerPoint
5. Email the package to board@company.com 
   by Friday 3PM

Start with step 1.

Generate an end-of-quarter summary.

Sources:
- /[Q report Excel]
- Teams meeting summaries from the last 3 months
- My sent emails to clients

Produce:
- Key metrics and performance vs goals
- Client relationship summary
- Wins and lessons learned
- Priorities for next quarter

Format as both a Word report and a slide deck.