Microsoft Copilot Prompts

For Microsoft 365 Copilot in Word, Excel, Outlook and Teams

Master M365 workflows. Expert prompts for Teams, Excel, Power BI, Outlook, and Graph grounding. Enterprise-grade automation at your fingertips.

Category: Productivity & Enterprise AI

Microsoft Copilot prompt packs by task

Copy-paste prompt sets for one job each, grouped by the tool you use.

Business reviews and forecastsCopilot prompts for businessMicrosoft 365 Copilot prompts for weekly operating reviews, pipeline forecasts, proposals and Excel variance notes, each tied to a file you can open.
Inbox, briefs and trackersCopilot prompts for administrative assistantsTriage an Outlook thread, prepare meeting briefs, update Excel trackers and plan travel, with a final send check that stays with you.
Meeting minutesCopilot prompts for detailed meeting minutesTurn a Teams transcript into minutes with decisions, an action register and speaker checks, then write shorter versions once the record is approved.

How to use these Microsoft Copilot prompts

These prompts are written for Microsoft 365 Copilot, the version you reach with a work or school account inside Word, Excel, Outlook, Teams and PowerPoint. It can read the mail, files, chats and meetings you already have permission to open, which is what makes it different from a general chatbot. It cannot see anything you are not allowed to see, and it does not know about a file unless you point it there or it turns up in a search of your work content.

If you use the free Copilot app with a personal Microsoft account, most of these prompts still work as writing and planning prompts, but anything that says "from this thread" or "in this workbook" needs you to paste the material in yourself. GitHub Copilot is a different product for writing code and is not covered here.

Each prompt has placeholders in square brackets. Replace every one, delete the lines that do not apply, and add the one thing the template cannot know: which file, meeting or thread Copilot should use. The table below shows where each group of prompts runs and what to open first.

Where each prompt runs

Prompt group	Where to run it	Open first	Good to know
Teams & Communication	Copilot in Teams, or Copilot Chat in Teams	The meeting recap, chat or channel you want to work from	Meeting prompts need transcription or recording to have been on. Without it, Copilot only sees what was typed in chat.
Excel & Data Analysis	Copilot in Excel	The workbook, saved to OneDrive or SharePoint	Works best on data formatted as a table with clear column headers. Check every formula it adds before you rely on it.
Power BI & Dashboarding	Copilot in Power BI	The report or semantic model you have permission to edit	Availability depends on how your organisation has set up Power BI. If you cannot see Copilot there, use these as planning prompts in Copilot Chat.
Outlook & Email Productivity	Copilot in Outlook	The email thread, or a new draft	Copilot drafts. You send. Read the draft against the thread, especially names, dates and commitments.
Graph & Advanced Integration	Copilot Chat (work mode)	Nothing yet: these are planning prompts	They produce a design or checklist for IT, Power Automate or Copilot Studio. Copilot does not change settings or build flows from them.

Teams & Communication

Enhance collaboration and communication across your organization with AI-powered Teams prompts.

Meeting Summary Generator

Analyze the following Teams meeting transcript and provide a concise executive summary including: key decisions made, action items with owners, risks identified, and next steps. Format the output as a structured document with clear sections.

Meeting Transcript:
[PASTE TRANSCRIPT HERE]

Provide a professional summary suitable for distribution to stakeholders who missed the meeting.

Team Announcement Composer

Create a professional, engaging announcement for our Microsoft Teams channel about the following update:

Update Details: [PROVIDE DETAILS]

Tone: [PROFESSIONAL/CASUAL/URGENT]

Include:
- A compelling headline
- Context about why this matters
- Key details and timeline
- Call to action
- Links to relevant resources

Format for Teams channel posting with appropriate emojis and formatting.

Conflict Resolution Protocol

I need to address a team conflict situation. Generate a structured communication plan for resolving this using Copilot for Teams:

Situation: [DESCRIBE CONFLICT]
Parties Involved: [LIST TEAM MEMBERS]
Objective: [DESIRED OUTCOME]

Provide:
- Initial one-on-one conversation frameworks
- Group discussion agenda
- Documentation template
- Follow-up check-in schedule

Ensure the approach maintains psychological safety and team cohesion.

Excel & Data Analysis

Transform raw data into actionable insights with AI-powered Excel analysis and reporting.

Sales Performance Analysis

I have sales data in Excel with columns for: Date, Sales Rep, Product, Revenue, Region, and Deal Stage.

Using Copilot in Excel, create:
1. A pivot table analyzing revenue by rep and region
2. A trend analysis showing Q1-Q3 performance
3. Identify top 5 performing reps and their key products
4. Flag underperforming regions with percentage variance from target
5. Generate recommendations for performance improvement

Provide formulas I can use and explain the insights clearly.

Budget Variance Report

Generate an automated budget variance analysis for our department expenses. I have:

- Budget by Category (columns: Category, Budgeted Amount, Actual Spent, Variance %)
- Monthly breakdown data

Create:
1. Variance analysis with conditional formatting (red for over-budget)
2. Month-over-month spending trends
3. Department comparison analysis
4. Forecast for remaining budget
5. Executive summary with recommendations

Structure this for presentation to finance leadership.

Customer Cohort Analysis

Analyze our customer data to understand behavior patterns:

Data includes: Customer ID, Signup Date, Purchase Amount, Purchase Frequency, Last Purchase Date, Churn Status

Using Copilot:
1. Segment customers into cohorts by signup month
2. Calculate retention rates by cohort
3. Analyze spending patterns and lifetime value
4. Identify high-risk churn cohorts
5. Generate actionable retention recommendations

Format results for presentation to marketing and product teams.

Power BI & Dashboarding

Build intelligent dashboards with AI assistance to drive data-driven decision making.

KPI Dashboard Design

I need to build a Power BI dashboard for tracking our key business metrics. Our KPIs are:

- Monthly Recurring Revenue (MRR)
- Customer Acquisition Cost (CAC)
- Churn Rate
- Net Revenue Retention
- Support Ticket Resolution Time

Using Copilot in Power BI, help me:
1. Design the dashboard layout
2. Create visualizations for each KPI
3. Add drill-down capabilities by region/team
4. Set up alerts for metrics below threshold
5. Create a narrative summary using AI insights

Target audience: Executive leadership.

Predictive Analytics Setup

Set up predictive analytics in Power BI using our historical data:

Data: Monthly revenue, seasonality patterns, marketing spend, customer acquisition, product launches

Implement:
1. Revenue forecasting model for next 12 months
2. Confidence intervals and error margins
3. Driver analysis showing what impacts revenue most
4. Scenario planning (best case/worst case/realistic)
5. Automated anomaly detection

Explain model assumptions and limitations for stakeholders.

Customer Health Scorecard

Create a Power BI customer health dashboard that tracks account health metrics:

Metrics: Usage frequency, feature adoption rate, support ticket volume, NPS score, renewal risk

Design:
1. Heat map showing all accounts with health status
2. Drill-down by customer segment and size
3. Early warning system for at-risk accounts
4. Recommended actions by Copilot AI
5. Comparative benchmarking against similar accounts

Integrate with our CRM system for real-time updates.

Outlook & Email Productivity

Master email productivity and communication with AI-powered Outlook prompts.

Executive Briefing Email

Draft a professional executive briefing email on behalf of our department:

Subject Matter: [TOPIC]
Key Points to Convey: [LIST 3-5 POINTS]
Target Recipient: [TITLE/ROLE]
Actionable Items: [WHAT YOU NEED FROM THEM]
Timeline: [URGENCY]

Requirements:
- Concise (2-3 paragraphs max)
- Professional but approachable tone
- Clear call to action
- Formatted for easy scanning
- Include relevant data points

Generate 3 versions and choose the best fit.

Complex Email Summarizer

I received a lengthy email thread with multiple participants and context switches. Using Copilot:

1. Extract the main topic and sub-topics
2. Identify who said what and their positions
3. List agreed-upon decisions
4. Highlight unresolved items
5. Create an action items list with owners
6. Generate a brief response acknowledging key points

[PASTE EMAIL THREAD]

Format the summary for quick scanning and provide a template response.

Client Relationship Email

Craft a strategic client relationship email with multiple objectives:

Client Name: [NAME]
Objectives: [LIST GOALS - e.g., upsell, strengthen relationship, gather feedback]
Current Status: [CONTEXT]
Proposed Value: [WHAT YOU'RE OFFERING]

Generate:
1. Personalized opening that references shared history
2. Business value proposition tailored to their situation
3. Specific proposal or request
4. Social proof or success stories
5. Clear next steps

Tone should be warm, professional, and value-focused.

Graph & Advanced Integration

Leverage Microsoft Graph API and advanced automation for enterprise-wide intelligence.

Cross-Platform Data Integration

Design a Microsoft Graph integration that connects:

Data Sources: Teams chat, Calendar events, SharePoint documents, OneDrive activity
Objective: Build a unified team productivity view

Using Copilot, create:
1. API calls needed to fetch relevant data
2. Data transformation and aggregation logic
3. Insights to extract (collaboration patterns, content creation, communication volume)
4. Privacy and compliance safeguards
5. Dashboard/report design for insights
6. Automation schedule and refresh strategy

Target: Enable managers to understand team dynamics and bottlenecks.

Compliance & Retention Policy

Set up a comprehensive compliance framework using Microsoft 365 capabilities:

Requirements: Data retention, eDiscovery, audit logging, regulatory standards (GDPR/CCPA)

Implement:
1. Retention policies by content type (email, Teams, SharePoint)
2. Retention labels and auto-apply rules
3. eDiscovery workflow documentation
4. Audit log configuration and monitoring
5. Compliance reports and automated alerts
6. Training content for team members

Ensure documented alignment with legal and privacy teams.

Automated Workflow Engine

Build an automation suite using Power Automate and Microsoft Graph:

Workflows Needed:
1. New employee onboarding (provision accounts, teams, access)
2. Document approval routing (multi-level, parallel, conditional)
3. Escalation management for high-priority items
4. Data sync between systems (CRM, ERP, SharePoint)
5. Scheduled reporting (daily, weekly, monthly)

For each workflow, provide:
- Trigger conditions
- Decision logic and conditions
- Integration points
- Error handling and retry logic
- Monitoring and logging strategy

How to adapt a prompt to your own work

A template gets you started. What makes the answer useful is the context only you have. Before you press enter, check four things.

Name the source. Say which workbook, thread or meeting to use. In Copilot Chat you can usually type a forward slash to pick a file. A prompt that names its source is much less likely to blend in an old version or an unrelated document.
Say who will read it. "For the finance director, who has five minutes" produces a different summary from "for the project team."
Set a rule for gaps. Add "if a figure is not in the file, write NOT IN SOURCE." Without it, Copilot may fill the gap with something plausible.
Ask for a draft. End with "show me the draft, do not send or change anything." You decide what leaves your outbox.

Worked example: the budget variance prompt

The Budget Variance Report template above asks for five outputs at once. In practice that produces a long, generic answer. Here is the same job adapted for a real month-end, run in Excel on the department's budget workbook.

Use the table Budget_FY26 in this workbook (columns: Category, Budgeted, Actual, Month).
For September only:
1. Add a Variance % column: (Actual - Budgeted) / Budgeted.
2. List the three categories most over budget, with the amount and the percentage.
3. Write two sentences for the finance director explaining what changed, using only
   the figures in this table. If a reason is not in the data, say "reason not recorded".
Do not create charts or change any existing cells.

A good result adds one column you can inspect, names three categories with figures that match the table, and keeps the explanation to what the data shows. Click into the new column and check that the formula references the right cells. If Copilot offers a reason such as "higher travel costs" that is not in the workbook, delete it or confirm it with the budget owner before it goes into the report.

Common mistakes

Expecting Copilot to see everything. It only sees what your account can open, and it may not find a file you have not opened recently unless you name it.
Asking for a meeting summary with no transcript. If transcription was off, the recap will be thin or empty.
Trusting formulas without checking. Copilot in Excel can pick the wrong range. Click the cell and read the formula.
Letting it send. Draft replies can sound confident about commitments you never made. Read before you send.
Pasting restricted data into the wrong place. Keep sensitive material in your work account, never in a personal Copilot or another chatbot.

For task-specific sets with more checks built in, see the Copilot prompts for detailed meeting minutes and the step-by-step guide to using Microsoft Copilot in Excel.

Frequently Asked Questions

How do I enable Microsoft Copilot in my Microsoft 365 environment?

An admin assigns Microsoft 365 Copilot licences to users in the Microsoft 365 admin center. Once a licence is assigned, Copilot appears in the supported apps for that user, although some features roll out gradually and depend on region, app version and update channel. Personal and Family plans include Copilot features under different terms, so check which plan you are on before following business setup steps.

What data privacy and security considerations should I know about?

For work accounts, Microsoft states that prompts and responses in Microsoft 365 Copilot stay within the Microsoft 365 service boundary and are not used to train its foundation models. Copilot can only see content the signed-in user already has permission to open, so overshared SharePoint sites and Teams are the main risk. Fix permissions before rollout and check your own compliance requirements with your legal team.

Can I customize Copilot behavior for my organization?

Yes, within limits. Admins control which features and agents are available, Graph connectors can add other data sources to what Copilot can search, and Copilot Studio lets you build agents with their own instructions and knowledge. You cannot retrain the underlying model through everyday use. For most teams, a shared and maintained prompt library is the cheapest form of customisation.

How do I measure the ROI of Microsoft Copilot adoption?

Pick three or four repeat tasks, time them before rollout, and time them again after a month with the same people. Add a quality measure, such as how many Copilot drafts needed major edits, and track active use rather than licences assigned. The admin center has usage reports. Self-reported time savings tend to be optimistic, so measure where you can.

What training should my team receive?

Start with the two or three apps each role uses most, using that role's real files. Cover how to point Copilot at the right source, how to check a draft, and what must never be pasted or shared. Short hands-on sessions with follow-up office hours work better than one long lecture, and a refresher when Microsoft ships a major change keeps habits current.

How do I handle prompts that produce inaccurate or inappropriate outputs?

Check the output against the source before using it, especially numbers, names and dates. If the answer is wrong, tell Copilot which file or section to use and what to do when information is missing, then try again. Report harmful output with the feedback button, keep a note of prompts that fail so the team can fix them, and require a human sign-off for anything that affects money, people or customers.

Can Copilot integrate with third-party applications?

Yes. Graph connectors and Copilot Studio agents can connect Copilot to other systems, and Power Automate has a large library of connectors for workflows that run alongside it. What an individual user can reach depends on what IT has enabled, so check with your admin before planning a workflow around a connection.

What's the difference between Copilot Pro and Microsoft 365 Copilot?

Copilot Pro was a subscription for personal Microsoft accounts. Microsoft 365 Copilot is the business add-on for work accounts: it grounds answers in your organisation's mail, files, chats and meetings, respects your tenant's permissions and is managed by IT. Microsoft has renamed and repackaged consumer plans more than once, so check the current plan page before you buy.

How do I ensure responsible AI use across my organization?

Write a short acceptable use policy that says which data can go into Copilot, which outputs need review and who signs off. Train people on it with real examples, keep a human decision-maker for anything high impact, and review the policy every few months as features change.

What should I include in a Copilot prompt for best results?

A clear goal, the file or thread Copilot should use, the audience, the output format, and what to do if the source does not contain the answer. Detail helps when it is relevant to the task. A long prompt full of generic instructions does not. Ask for a draft you review, never a finished message sent on your behalf.

How do I troubleshoot when Copilot isn't available or isn't working?

Check that your licence includes Copilot and that your app is up to date, then sign out and back in. In Excel, make sure the file is saved to OneDrive or SharePoint. Check the Microsoft 365 service health page for incidents, and send IT the exact error message and app version if it still fails.

What's the best way to scale Copilot adoption across a large organization?

Start with a pilot group that has clear repeat tasks, collect the prompts that worked, and turn them into a shared library before wider rollout. Name a champion in each team, fix data permissions early, and share specific before-and-after examples rather than general claims.

Microsoft Copilot prompt packs by task

How to use these Microsoft Copilot prompts

Where each prompt runs

Teams & Communication

Meeting Summary Generator

Team Announcement Composer

Conflict Resolution Protocol

Excel & Data Analysis

Sales Performance Analysis

Budget Variance Report

Customer Cohort Analysis

Power BI & Dashboarding

KPI Dashboard Design

Predictive Analytics Setup

Customer Health Scorecard

Outlook & Email Productivity

Executive Briefing Email

Complex Email Summarizer

Client Relationship Email

Graph & Advanced Integration

Cross-Platform Data Integration

Compliance & Retention Policy

Automated Workflow Engine

How to adapt a prompt to your own work

Worked example: the budget variance prompt

Common mistakes

Frequently Asked Questions

Explore More Prompts

Copilot for Administrative Assistants

GPT-4o Prompts

Claude Prompts

Gemini Prompts

Midjourney Prompts

Grok Prompts

Microsoft Copilot for API Design

Social Media Prompts

Essay Prompts

Presentation Prompts

What to read next

Copilot Prompts for Business

Copilot Prompts for Administrative Assistants

Copilot Prompts for Meeting Minutes