Explore This Guide
Jump directly to any section of this article.
AI Prompts for Writing, Analysis, Coding & Research
Select a category or browse all Microsoft Copilot prompts below
1. Word Agent Document Builder (With Citations)
WRITINGCreate a complete professional Word document from a project brief, with sources you can check.
Create a professional Word document for [project/topic] using this information: [paste details or reference files]. Structure it with an executive summary, objectives, key information, recommendations, risks, and next steps. Keep the writing concise and ready for review. Cite the source behind every important claim, mark anything not found in the sources as [needs input], and do not invent figures.
Create a professional Word document for [project/topic] using this information: [paste details or reference files]. Structure it with an executive summary, objectives, key information, recommendations, risks, and next steps. Keep the writing concise and ready for review. Cite the source behind every important claim, mark anything not found in the sources as [needs input], and do not invent figures.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
2. Excel Agent Data Analyst
ANALYSISAnalyze spreadsheet data, build the formulas, and turn it into clear business insights.
Analyze this Excel workbook: [reference workbook]. Identify important trends, anomalies, top and bottom performers, and relationships in the data. Use real formulas, not pasted values, for any calculation you add, and explain each one in a notes column. Recommend the most useful charts, create a concise executive summary, and clearly separate facts from assumptions. Do not invent missing data.
Analyze this Excel workbook: [reference workbook]. Identify important trends, anomalies, top and bottom performers, and relationships in the data. Use real formulas, not pasted values, for any calculation you add, and explain each one in a notes column. Recommend the most useful charts, create a concise executive summary, and clearly separate facts from assumptions. Do not invent missing data.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
3. Excel Variance & Forecast Review
ANALYSISCompare actuals to budget, explain the gaps, and build a simple traceable forecast.
Review this workbook with actuals and budget: [reference workbook]. Calculate variance by line item and period, rank the five largest favorable and unfavorable variances, and explain the likely drivers using only data in the workbook. Then build a simple forecast for the next [number] periods with the assumptions listed in a separate cell range, so every number can be traced. Flag anything that needs a human decision.
Review this workbook with actuals and budget: [reference workbook]. Calculate variance by line item and period, rank the five largest favorable and unfavorable variances, and explain the likely drivers using only data in the workbook. Then build a simple forecast for the next [number] periods with the assumptions listed in a separate cell range, so every number can be traced. Flag anything that needs a human decision.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
4. PowerPoint Deck in Our Brand Style
WRITINGTurn business information into a presentation that follows your template and layouts.
Create a 10-slide PowerPoint presentation from this information: [paste or reference content], using our company template and brand layouts. Build a clear story from problem to insight to recommendation. Include concise slide titles, key evidence, suggested visuals, and speaker notes. Keep each slide focused on one main message, and list any claim on a slide that needs a source before presenting.
Create a 10-slide PowerPoint presentation from this information: [paste or reference content], using our company template and brand layouts. Build a clear story from problem to insight to recommendation. Include concise slide titles, key evidence, suggested visuals, and speaker notes. Keep each slide focused on one main message, and list any claim on a slide that needs a source before presenting.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
5. Microsoft Copilot Researcher
RESEARCHResearch a complex business topic and produce a structured, cited report.
Research this topic: [topic]. Use relevant web sources and, where available, my Microsoft 365 work context. Compare important viewpoints, identify key evidence, explain uncertainties, and produce a structured report with citations, key findings, and recommended next steps. Label each finding as confirmed by multiple sources, single source, or uncertain, and separate what comes from the web from what comes from our internal files.
Research this topic: [topic]. Use relevant web sources and, where available, my Microsoft 365 work context. Compare important viewpoints, identify key evidence, explain uncertainties, and produce a structured report with citations, key findings, and recommended next steps. Label each finding as confirmed by multiple sources, single source, or uncertain, and separate what comes from the web from what comes from our internal files.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
6. Outlook Inbox Triage & Reply Drafts
WRITINGSort your inbox by urgency and draft replies that keep your voice.
Review my unread Outlook emails from [time period]. Sort them into: needs a reply today, needs a reply this week, FYI only, and can be ignored. For the first group, draft a short reply in my usual tone with a clear next step, and list the emails that need a decision from me. Do not send anything, and tell me which emails you were unsure about.
Review my unread Outlook emails from [time period]. Sort them into: needs a reply today, needs a reply this week, FYI only, and can be ignored. For the first group, draft a short reply in my usual tone with a clear next step, and list the emails that need a decision from me. Do not send anything, and tell me which emails you were unsure about.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
7. Cross-App Project Brief Generator
PRODUCTIVITYCombine information from Microsoft 365 sources into one project brief.
Using the available project emails, meeting notes, files, and chat context, create a concise project brief for [project]. Include objectives, current status, decisions, open questions, risks, owners, deadlines, and next actions. List the sources you used for each section, flag information that is missing, conflicting, or uncertain, and do not fill gaps with guesses.
Using the available project emails, meeting notes, files, and chat context, create a concise project brief for [project]. Include objectives, current status, decisions, open questions, risks, owners, deadlines, and next actions. List the sources you used for each section, flag information that is missing, conflicting, or uncertain, and do not fill gaps with guesses.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
8. Teams Meeting Action Agent
WRITINGTurn a meeting discussion into decisions, owners, and follow-up actions.
Analyze this Teams meeting transcript: [reference transcript]. Extract the key decisions, unresolved issues, action items, owners, and deadlines. Separate confirmed decisions from suggestions, and mark any owner or deadline that was not clearly stated as "unclear". Finish with a concise follow-up message that can be sent to attendees and a list of tasks I can assign in Planner.
Analyze this Teams meeting transcript: [reference transcript]. Extract the key decisions, unresolved issues, action items, owners, and deadlines. Separate confirmed decisions from suggestions, and mark any owner or deadline that was not clearly stated as "unclear". Finish with a concise follow-up message that can be sent to attendees and a list of tasks I can assign in Planner.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
9. Copilot Cowork Task Delegation
PRODUCTIVITYHand a multi-step piece of work to Copilot Cowork with clear limits, checkpoints, and a final review.
Delegate this work to Cowork: [describe the outcome and deadline]. Use these sources: [files, emails, meetings, sites]. First show me your plan with the steps and the files you will create or change. Ask for my approval before sending any message, deleting or overwriting a file, or booking anything. Work in stages, report progress at each stage, and finish with a summary of what was done, what you could not complete, and what needs my review.
Delegate this work to Cowork: [describe the outcome and deadline]. Use these sources: [files, emails, meetings, sites]. First show me your plan with the steps and the files you will create or change. Ask for my approval before sending any message, deleting or overwriting a file, or booking anything. Work in stages, report progress at each stage, and finish with a summary of what was done, what you could not complete, and what needs my review.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
10. Copilot Notebook from Project Files
RESEARCHBuild a working notebook from your files, emails, and notes, then ask questions grounded in them.
Create a notebook for [project/topic] using these references: [files, emails, meeting notes, pages]. Produce a one-page overview, a list of key facts with the source of each, open questions, conflicting information between sources, and a short FAQ a new team member would ask. Answer only from the notebook sources, and say "not in the sources" when the answer is missing.
Create a notebook for [project/topic] using these references: [files, emails, meeting notes, pages]. Produce a one-page overview, a list of key facts with the source of each, open questions, conflicting information between sources, and a short FAQ a new team member would ask. Answer only from the notebook sources, and say "not in the sources" when the answer is missing.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
11. Copilot Business Decision Analyst
ANALYSISCompare business options using evidence, constraints, risks, and trade-offs.
Evaluate these options: [option A, option B, option C]. Use the available business information and data to compare cost, benefits, risks, dependencies, expected impact, and implementation difficulty. Create a decision matrix and recommend the strongest option with a clear rationale. Include the biggest assumption behind the recommendation, what evidence would change it, and a pre-mortem listing the three most likely reasons it could fail.
Evaluate these options: [option A, option B, option C]. Use the available business information and data to compare cost, benefits, risks, dependencies, expected impact, and implementation difficulty. Create a decision matrix and recommend the strongest option with a clear rationale. Include the biggest assumption behind the recommendation, what evidence would change it, and a pre-mortem listing the three most likely reasons it could fail.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
12. RFP Response Assistant (Source-Referenced)
WRITINGDraft RFP answers from your internal content, with a source for every claim.
Answer the following RFP questions using our internal proposal content: [paste RFP questions]. Reference relevant case studies and capabilities from [knowledge source]. Keep answers compliant, concise, and persuasive. After each answer, list the document it came from, and flag any claim, figure, or certification that is not clearly supported by our files so a person can confirm it before submission.
Answer the following RFP questions using our internal proposal content: [paste RFP questions]. Reference relevant case studies and capabilities from [knowledge source]. Keep answers compliant, concise, and persuasive. After each answer, list the document it came from, and flag any claim, figure, or certification that is not clearly supported by our files so a person can confirm it before submission.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
13. Competitive Battlecard from CRM & Web Data
ANALYSISBuild a competitive battlecard using internal sales notes and public information.
Create a competitive battlecard for [our product] against [competitor]. Use our CRM data and recent call notes: [paste/reference] plus their public website. Highlight our unique differentiators, their weaknesses, the objections customers raise and the best response to each, and the questions our reps should ask to qualify the deal. Mark which points come from our CRM and which come from public sources.
Create a competitive battlecard for [our product] against [competitor]. Use our CRM data and recent call notes: [paste/reference] plus their public website. Highlight our unique differentiators, their weaknesses, the objections customers raise and the best response to each, and the questions our reps should ask to qualify the deal. Mark which points come from our CRM and which come from public sources.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
14. Power BI Dashboard Explanation
ANALYSISNarrate a Power BI dashboard for a non-technical audience.
Explain this Power BI report page: [describe or reference]. Walk through each visual: what it shows, why it matters, and how it connects to the business KPIs. Use plain language, point out any number that looks unusual and what could explain it, and conclude with one actionable recommendation and the question I should ask the data owner.
Explain this Power BI report page: [describe or reference]. Walk through each visual: what it shows, why it matters, and how it connects to the business KPIs. Use plain language, point out any number that looks unusual and what could explain it, and conclude with one actionable recommendation and the question I should ask the data owner.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
15. Recurring Autopilot Weekly Report with Approval Gates
PRODUCTIVITYForward-looking prompt to set up a persistent agent that prepares a recurring report and waits for your approval.
Set up a recurring task for me: every [day and time], prepare a [weekly status report / pipeline summary / team update] for [audience]. Gather the data from [sources]. Draft the report in [Word/PowerPoint/Outlook], flag anything unusual compared with last time, and send me the draft for approval before it goes to anyone. If a source is missing or a number looks wrong, stop and tell me instead of continuing. Keep a short log of what you did each week.
Set up a recurring task for me: every [day and time], prepare a [weekly status report / pipeline summary / team update] for [audience]. Gather the data from [sources]. Draft the report in [Word/PowerPoint/Outlook], flag anything unusual compared with last time, and send me the draft for approval before it goes to anyone. If a source is missing or a number looks wrong, stop and tell me instead of continuing. Keep a short log of what you did each week.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
16. Project Risk Assessment from Planner/Project
ANALYSISIdentify risks using project schedule and task data.
Analyze this project plan: [reference Microsoft Project or Planner]. Identify tasks with no buffer, over-allocated resources, and dependencies that could cause a cascade delay. Create a risk register with severity and mitigation.
Analyze this project plan: [reference Microsoft Project or Planner]. Identify tasks with no buffer, over-allocated resources, and dependencies that could cause a cascade delay. Create a risk register with severity and mitigation.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
17. Sentiment Analysis from Customer Feedback Forms
ANALYSISProcess Microsoft Forms responses for sentiment and emerging themes.
Analyze these Forms survey responses: [paste or reference]. Categorize sentiment (positive/neutral/negative) and extract the top 5 recurring topics. Provide a summary for the product team and highlight any urgent complaint.
Analyze these Forms survey responses: [paste or reference]. Categorize sentiment (positive/neutral/negative) and extract the top 5 recurring topics. Provide a summary for the product team and highlight any urgent complaint.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
18. Sales Forecast with What-If Scenarios
ANALYSISUse historical sales data to model best/worst/likely scenarios.
Using our sales data from the last 12 months: [reference Excel or CRM], create a 6-month forecast. Include best, worst, and most likely scenarios. Explain the assumptions behind each, and recommend pipeline actions to meet the target.
Using our sales data from the last 12 months: [reference Excel or CRM], create a 6-month forecast. Include best, worst, and most likely scenarios. Explain the assumptions behind each, and recommend pipeline actions to meet the target.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
19. Policy Compliance Gap Analysis
ANALYSISReview internal documents against a new regulation.
Compare our current data handling policy: [paste/reference doc] with this new regulation: [paste regulation text]. Identify gaps, suggest wording updates, and flag sections that require legal review. Create a compliance checklist.
Compare our current data handling policy: [paste/reference doc] with this new regulation: [paste regulation text]. Identify gaps, suggest wording updates, and flag sections that require legal review. Create a compliance checklist.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
20. Budget Variance Explainer
ANALYSISExplain why actuals differ from budget in plain language.
Given this budget vs. actuals report: [paste/reference Excel]. Explain the top 3 positive and negative variances. For each, identify the likely root cause based on the data, and suggest corrective actions. Use language suitable for a CFO.
Given this budget vs. actuals report: [paste/reference Excel]. Explain the top 3 positive and negative variances. For each, identify the likely root cause based on the data, and suggest corrective actions. Use language suitable for a CFO.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
21. Email Attachment Content Aggregator
ANALYSISAggregate key points from multiple email attachments.
Review the attachments from the last 5 emails in this thread: [reference]. Extract the key numbers, deadlines, and requested actions. Compile them into a single one-page summary for the project manager.
Review the attachments from the last 5 emails in this thread: [reference]. Extract the key numbers, deadlines, and requested actions. Compile them into a single one-page summary for the project manager.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
22. IT Helpdesk Ticket Trend Analyzer
ANALYSISAnalyze ServiceNow or Dynamics ticket data for recurring issues.
Analyze these IT helpdesk tickets from the last quarter: [paste/reference data]. Identify the top 3 recurring incident categories, average resolution time, and any spike periods. Recommend process improvements to reduce ticket volume.
Analyze these IT helpdesk tickets from the last quarter: [paste/reference data]. Identify the top 3 recurring incident categories, average resolution time, and any spike periods. Recommend process improvements to reduce ticket volume.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
23. Stakeholder Impact Assessment
ANALYSISPredict how a change affects different departments using org data.
Our upcoming change is: [describe change]. Based on our organizational structure [reference Teams/Outlook groups], assess the impact on each major department. Highlight who needs training, who gains efficiency, and who may resist.
Our upcoming change is: [describe change]. Based on our organizational structure [reference Teams/Outlook groups], assess the impact on each major department. Highlight who needs training, who gains efficiency, and who may resist.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
24. Contract Clause Risk Highlighter
ANALYSISReview a contract for risky clauses and suggest fallbacks.
Analyze this contract: [paste/reference doc]. Identify clauses that present liability, unclear indemnification, or termination risks. For each, flag the risk level and propose a safer alternative wording.
Analyze this contract: [paste/reference doc]. Identify clauses that present liability, unclear indemnification, or termination risks. For each, flag the risk level and propose a safer alternative wording.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
25. GitHub Copilot Code Refactoring
CODINGRefactor a messy function with clear explanations.
Refactor this JavaScript/TypeScript function: [paste code]. Split it into smaller, reusable functions, use modern syntax, and add error handling. Explain each change as if for a code review.
Refactor this JavaScript/TypeScript function: [paste code]. Split it into smaller, reusable functions, use modern syntax, and add error handling. Explain each change as if for a code review.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
26. Azure Infrastructure as Code (Bicep/Terraform)
CODINGGenerate Azure IaC templates with best practices.
Write a Bicep script to provision an Azure Function App with a storage account, App Service Plan, and Application Insights. Include comments explaining each resource and output the function URL. Ensure it follows the Azure Well-Architected Framework.
Write a Bicep script to provision an Azure Function App with a storage account, App Service Plan, and Application Insights. Include comments explaining each resource and output the function URL. Ensure it follows the Azure Well-Architected Framework.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
27. PowerShell Script for Microsoft 365 Admin
CODINGAutomate a common admin task with error handling.
Write a PowerShell script to list all Microsoft 365 users who haven't logged in for 30 days and export them to a CSV. Use the Microsoft Graph module, add verbose logging, and handle authentication errors gracefully.
Write a PowerShell script to list all Microsoft 365 users who haven't logged in for 30 days and export them to a CSV. Use the Microsoft Graph module, add verbose logging, and handle authentication errors gracefully.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
28. SQL Query Optimization for Azure SQL
CODINGOptimize a slow query with Azure SQL specifics.
Optimize this slow T-SQL query: [paste query]. Analyze the execution plan, suggest missing indexes, rewrite subqueries, and apply query hints if necessary. Ensure it works efficiently on Azure SQL Database.
Optimize this slow T-SQL query: [paste query]. Analyze the execution plan, suggest missing indexes, rewrite subqueries, and apply query hints if necessary. Ensure it works efficiently on Azure SQL Database.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
29. API Endpoint with Azure Functions & Node.js
CODINGCreate a serverless API with input validation and security.
Create an Azure Function (Node.js, TypeScript) that serves as a REST API for [resource]. Include validation, try-catch, HTTP status codes, and integrate with Azure Key Vault for secrets. Provide a Swagger snippet.
Create an Azure Function (Node.js, TypeScript) that serves as a REST API for [resource]. Include validation, try-catch, HTTP status codes, and integrate with Azure Key Vault for secrets. Provide a Swagger snippet.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
30. .NET MAUI App UI Generator
CODINGBuild a cross-platform UI with data binding.
Create a .NET MAUI page for [purpose, e.g., customer list]. It should have a search bar, a CollectionView with pull-to-refresh, and a detail page navigation. Use MVVM pattern and provide the ViewModel in C#.
Create a .NET MAUI page for [purpose, e.g., customer list]. It should have a search bar, a CollectionView with pull-to-refresh, and a detail page navigation. Use MVVM pattern and provide the ViewModel in C#.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
31. Python Script for Excel Data Processing
CODINGAutomate Excel report generation with Python and openpyxl.
Write a Python script that reads 'Sales.xlsx', aggregates sales by region and month, creates a pivot table, and saves a new formatted Excel file with charts. Use pandas and openpyxl. Add error handling for missing files.
Write a Python script that reads 'Sales.xlsx', aggregates sales by region and month, creates a pivot table, and saves a new formatted Excel file with charts. Use pandas and openpyxl. Add error handling for missing files.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
32. React Component with Fluent UI
CODINGBuild a React component using Microsoft's design system.
Create a React functional component for a 'User Profile Card' using Fluent UI React v9. It should display an avatar, name, title, email, and a 'Connect' button. Use TypeScript and ensure it's accessible.
Create a React functional component for a 'User Profile Card' using Fluent UI React v9. It should display an avatar, name, title, email, and a 'Connect' button. Use TypeScript and ensure it's accessible.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
33. GitHub Actions Workflow Generator
CODINGGenerate a CI/CD pipeline for Azure deployment.
Create a GitHub Actions workflow that builds a .NET application, runs tests, and deploys to Azure App Service on push to 'main'. Include environment secrets, artifact uploading, and a rollback step.
Create a GitHub Actions workflow that builds a .NET application, runs tests, and deploys to Azure App Service on push to 'main'. Include environment secrets, artifact uploading, and a rollback step.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
34. Legacy VBA to Office Script Conversion
CODINGModernize Excel macros to TypeScript Office Scripts.
Convert this VBA macro to an Office Script (TypeScript): [paste VBA code]. Use modern Excel JavaScript APIs, maintain the same logic, and add comments. Test for compatibility with Excel on the web.
Convert this VBA macro to an Office Script (TypeScript): [paste VBA code]. Use modern Excel JavaScript APIs, maintain the same logic, and add comments. Test for compatibility with Excel on the web.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
35. Security Copilot Incident Response Script
CODINGGenerate a KQL query for Microsoft Sentinel.
Write a KQL query for Microsoft Sentinel to detect potential privilege escalation. Look for new role assignments in Azure AD within a short time window. Include comments and describe the expected output.
Write a KQL query for Microsoft Sentinel to detect potential privilege escalation. Look for new role assignments in Azure AD within a short time window. Include comments and describe the expected output.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
36. Market Research Brief from Internal Data & Web
RESEARCHCombine internal sales data with external market trends.
Research the market for [industry/product]. Use our internal sales data from [reference] and public industry reports to identify growth segments, competitor moves, and emerging risks. Format as a 2-page executive brief.
Research the market for [industry/product]. Use our internal sales data from [reference] and public industry reports to identify growth segments, competitor moves, and emerging risks. Format as a 2-page executive brief.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
37. Literature Scan for Scientific Paper
RESEARCHFind and summarize recent papers on a topic using Copilot's web grounding.
Summarize the last 3 years of research on [topic] from top journals. Find at least 5 papers, provide a 3-sentence summary for each, and identify the current research gap. Cite the papers in APA format.
Summarize the last 3 years of research on [topic] from top journals. Find at least 5 papers, provide a 3-sentence summary for each, and identify the current research gap. Cite the papers in APA format.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
38. SharePoint Knowledge Base Article Draft
RESEARCHTurn a subject matter expert interview into a KB article.
Based on this interview transcript: [paste], create a knowledge base article for our SharePoint intranet. Use a how-to format, include step-by-step instructions, and tag it with relevant metadata.
Based on this interview transcript: [paste], create a knowledge base article for our SharePoint intranet. Use a how-to format, include step-by-step instructions, and tag it with relevant metadata.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
39. Patent Landscape with Microsoft IP Data
RESEARCHExplore the patent landscape using Microsoft's public IP and external sources.
Analyze the patent landscape for [technology area] by reviewing Microsoft's patents in this space and competitors'. Identify white space for innovation, key patent holders, and potential infringement risks. Use publicly available data.
Analyze the patent landscape for [technology area] by reviewing Microsoft's patents in this space and competitors'. Identify white space for innovation, key patent holders, and potential infringement risks. Use publicly available data.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
40. Due Diligence Checklist from Multiple Sources
RESEARCHCreate a comprehensive checklist for M&A or vendor assessment.
Build a due diligence checklist for [target company / vendor]. Combine information from their website, recent news, and any internal notes: [paste/reference]. Organize by financial, legal, technical, and cultural areas.
Build a due diligence checklist for [target company / vendor]. Combine information from their website, recent news, and any internal notes: [paste/reference]. Organize by financial, legal, technical, and cultural areas.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
41. Training Module Outline for Compliance
RESEARCHDesign a training outline that meets regulatory requirements.
Create a 1-hour training module outline on [compliance topic, e.g., GDPR]. Include learning objectives, interactive elements, assessment questions, and a facilitator guide. Reference the specific regulation sections.
Create a 1-hour training module outline on [compliance topic, e.g., GDPR]. Include learning objectives, interactive elements, assessment questions, and a facilitator guide. Reference the specific regulation sections.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
42. Industry Benchmarking with Public Filings
RESEARCHCompare our metrics against competitors using their 10-K reports.
Analyze the latest 10-K filings of [our company] and [competitor A, B]. Compare revenue growth, gross margin, R&D spend, and employee headcount. Present the data in a table and summarize our competitive position.
Analyze the latest 10-K filings of [our company] and [competitor A, B]. Compare revenue growth, gross margin, R&D spend, and employee headcount. Present the data in a table and summarize our competitive position.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
43. Internal Wiki Migration Content Re-structurer
RESEARCHMigrate content from an old wiki to a new SharePoint structure.
Given this dump of our old wiki content: [paste], reorganize it into a modern SharePoint site structure. Suggest site pages, document libraries, and metadata tags. Keep the original information but improve findability.
Given this dump of our old wiki content: [paste], reorganize it into a modern SharePoint site structure. Suggest site pages, document libraries, and metadata tags. Keep the original information but improve findability.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
44. Customer Journey Map from Support Logs & Surveys
RESEARCHVisualize the end-to-end customer experience with data.
Create a customer journey map using our support ticket data: [reference] and NPS survey responses: [reference]. Identify pain points, moments of delight, and opportunities to improve onboarding.
Create a customer journey map using our support ticket data: [reference] and NPS survey responses: [reference]. Identify pain points, moments of delight, and opportunities to improve onboarding.
Recommended Tech Stack
Microsoft Copilot for Microsoft 365 (where licensed), Microsoft Graph-grounded work context (where available), Excel, Word, PowerPoint, and Teams. Use only apps and data sources enabled for your account.
Quick Implementation Guide
- Specify the source files, relevant Teams channels or meetings, date range, and approved enterprise repository; ask Copilot to cite or name the sources it actually used.
- Review the generated draft, calculations, or presentation outline for source accuracy, brand alignment, missing context, and unsupported assumptions.
- Refine and export the result in the appropriate Office app. Review changes and obtain approval before sending messages, sharing files, or taking consequential actions.
Real-World Use Case Example
Example: Prepare a weekly executive status report by summarizing permitted Teams discussions and Outlook threads, reconciling the figures against an Excel tracker, and drafting a PowerPoint update for a person to review before distribution. This example requires appropriate product features, permissions, and data availability.
Microsoft Copilot: Enterprise Prompting Guide
Use these practical guidelines alongside the prompt library. Copilot features and access to Microsoft 365 work data vary by product, subscription, permissions, and administrator settings; review outputs before acting on them.
Optimizing Your Microsoft Copilot Workflow with Enterprise-Grade Prompts
Strong Copilot prompts define the goal, audience, source material, constraints, and desired output. Name the specific files, dates, tables, or Teams conversations you want considered; ask for citations or source references; and tell Copilot to mark missing evidence instead of guessing. Start with a small, reviewable deliverable before asking for a final document or cross-app workflow.
Step-by-Step Guide: Harnessing Copilot for Microsoft 365 and Enterprise Productivity
1. Choose the right Copilot experience and confirm that your account, license, app, and permissions support the requested feature. 2. Reference the source files or work context explicitly, and specify the audience, time range, output format, and success criteria. 3. Review the draft against the source material, correct errors, and approve any consequential edits or messages yourself. Feature availability can vary by subscription, tenant configuration, and rollout.
The Science Behind Graph Grounding, Context Retrieval, and Office Integration Prompts
Microsoft Graph can help eligible Microsoft 365 experiences ground responses in work content the signed-in user is allowed to access. Better prompts narrow the search space by naming relevant files, people, meetings, channels, and date ranges. Grounding is not a guarantee that every relevant item was retrieved: ask Copilot to list the sources used, distinguish internal material from web sources, and identify conflicting or absent evidence.
Best Practices for Maintaining Data Security, Compliance, and Contextual Relevance in Copilot
Use only approved work accounts and repositories, follow your organization’s classification and retention rules, and avoid pasting secrets or sensitive personal data into unapproved tools. Existing access controls matter, but they do not replace careful sharing, permissions reviews, or human approval. Treat generated content as a draft, verify regulatory and legal interpretations with qualified reviewers, and never assume a prompt alone enforces security or compliance.
Unlocking Advanced Cross-Application Automation, Data Analysis, and Corporate Reporting with Expert Prompts
For multi-app work, define the reporting period, authoritative source for each metric, calculation rules, audience, and final deliverable. Ask for a traceable table of findings before requesting a Word summary or PowerPoint deck. A useful workflow is to consolidate evidence from permitted Teams, Outlook, and Excel sources, reconcile mismatched figures, draft the executive narrative, then verify the figures and approve distribution. Access and automation capabilities depend on the Copilot product and tenant setup.
AI Prompt Templates for Microsoft Copilot in the Enterprise
These prompt templates cover Word, Excel, PowerPoint, Outlook, Teams, research, reporting, and development workflows. Available integrations depend on the Copilot product, license, permissions, and organization configuration. Use the templates as starting points, verify important claims, and follow your organization’s security and approval policies.
How Can These AI Prompts Improve My Copilot Results?
These AI prompts improve Copilot results by giving the model clear context from your Microsoft 365 environment, specific instructions, and a structured output format. Instead of generic chat, you are telling Copilot to reference a Word document, an Excel table, a Teams transcript, or a GitHub repo. This results in answers that are directly relevant to your business, actionable, and ready to share. By filling in the bracketed placeholders, you turn Copilot into a precise enterprise assistant.
Frequently Asked Questions
What was updated on this page for Oct 2026?
This page was reviewed on Oct 18, 2026 with revised prompt guidance, enterprise workflow notes, and clearer implementation steps.
What are the best AI prompts for Microsoft Copilot in 2026?
The best AI prompts for Microsoft Copilot in 2026 combine clear instructions with references to Microsoft 365 data, GitHub repositories, and enterprise workflows. They cover writing, analysis, coding, and research tasks that integrate seamlessly with Word, Excel, PowerPoint, Teams, and more.
Do these Copilot prompts work with the free version of Copilot?
Most general prompts work with Copilot's free tier. However, prompts that reference specific Microsoft 365 documents, email threads, or enterprise data require a Copilot for Microsoft 365 license.
Are these prompts beginner-friendly?
Yes. Just copy any prompt and replace bracketed placeholders with your content. The prompts are designed to be usable with Copilot's chat interface across Office apps and Windows.
Can these prompts use my organization's data?
Several prompts are designed to reference files, emails, or meetings within Microsoft 365, assuming you have the appropriate permissions and a Copilot for Microsoft 365 subscription. They respect data access controls.
Should I fact-check information from Copilot prompts?
Yes. Always verify critical facts, figures, or business recommendations against trusted internal sources or up-to-date external data. Copilot can make mistakes, especially when working with unverified internet content.
