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. Copilot Agent Document Builder
WRITINGCreate a complete professional Word document from a simple project brief.
Create a professional Word document for [project/topic] using this information: [paste details]. Structure it with an executive summary, objectives, key information, recommendations, risks, and next steps. Keep the writing concise, professional, and ready for review.
Create a professional Word document for [project/topic] using this information: [paste details]. Structure it with an executive summary, objectives, key information, recommendations, risks, and next steps. Keep the writing concise, professional, and ready for review.
2. Excel Data Analyst with Copilot
ANALYSISAnalyze spreadsheet data 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. Create a concise executive summary and recommend the most useful charts or visualizations. Clearly separate facts from assumptions.
Analyze this Excel workbook: [reference workbook]. Identify important trends, anomalies, top and bottom performers, and relationships in the data. Create a concise executive summary and recommend the most useful charts or visualizations. Clearly separate facts from assumptions.
3. PowerPoint Deck from Business Data
WRITINGTurn business information and data into a presentation-ready deck.
Create a 10-slide PowerPoint presentation from this information: [paste or reference content]. 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.
Create a 10-slide PowerPoint presentation from this information: [paste or reference content]. 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.
4. 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.
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.
5. Outlook Email Coaching & Rewrite
WRITINGImprove an email while preserving the original intent and personal voice.
Review this Outlook email: [paste or reference email]. Improve its clarity, structure, tone, and professionalism without changing the intended meaning. Identify any confusing or unnecessary sentences, then provide the revised version and a short list of recommended changes.
Review this Outlook email: [paste or reference email]. Improve its clarity, structure, tone, and professionalism without changing the intended meaning. Identify any confusing or unnecessary sentences, then provide the revised version and a short list of recommended changes.
6. Excel Python Data Analysis
ANALYSISUse advanced analysis to uncover patterns and insights in Excel data.
Analyze this Excel dataset: [reference workbook]. Use advanced statistical analysis where useful to identify trends, outliers, correlations, and meaningful patterns. Create appropriate visualizations and explain the findings in plain business language. Do not invent missing data.
Analyze this Excel dataset: [reference workbook]. Use advanced statistical analysis where useful to identify trends, outliers, correlations, and meaningful patterns. Create appropriate visualizations and explain the findings in plain business language. Do not invent missing data.
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. Flag information that is missing or uncertain.
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. Flag information that is missing or uncertain.
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. Finish with a concise follow-up message that can be sent to attendees.
Analyze this Teams meeting transcript: [reference transcript]. Extract the key decisions, unresolved issues, action items, owners, and deadlines. Separate confirmed decisions from suggestions. Finish with a concise follow-up message that can be sent to attendees.
9. 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.
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.
10. Copilot End-to-End Work Task
PRODUCTIVITYMove from a workplace request to a finished deliverable across Microsoft 365.
Complete this workplace task: [describe task]. First identify the required information and missing details. Then analyze the available Microsoft 365 context, create or update the appropriate Word, Excel, PowerPoint, or Outlook deliverable, and finish with a short summary of what was completed and what still requires human review.
Complete this workplace task: [describe task]. First identify the required information and missing details. Then analyze the available Microsoft 365 context, create or update the appropriate Word, Excel, PowerPoint, or Outlook deliverable, and finish with a short summary of what was completed and what still requires human review.
11. Social Media Post for LinkedIn (from Microsoft data)
WRITINGGenerate a LinkedIn post using insights from a recent company report.
Create a LinkedIn post promoting our new white paper on [topic]. Reference key findings from this document: [paste/reference doc]. The post should be professional, include a hook, a key stat, and a CTA to download the full paper.
Create a LinkedIn post promoting our new white paper on [topic]. Reference key findings from this document: [paste/reference doc]. The post should be professional, include a hook, a key stat, and a CTA to download the full paper.
12. RFP Response Assistant
WRITINGDraft answers to an RFP using internal knowledge base.
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.
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.
13. Excel Data Insights & Chart Suggestions
ANALYSISAnalyze a spreadsheet and recommend the best visualizations.
Analyze this Excel table: [reference or paste data]. Identify the top 3 trends and anomalies. Suggest which chart types (bar, line, scatter, etc.) would best communicate each insight, and draft a one-paragraph summary for a management presentation.
Analyze this Excel table: [reference or paste data]. Identify the top 3 trends and anomalies. Suggest which chart types (bar, line, scatter, etc.) would best communicate each insight, and draft a one-paragraph summary for a management presentation.
14. Competitive Battlecard from CRM & Web Data
ANALYSISBuild a competitive battlecard using internal sales notes and public info.
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, and handling objections.
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, and handling objections.
15. 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, and conclude with one actionable recommendation.
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, and conclude with one actionable recommendation.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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#.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
AI Prompt Templates for Microsoft Copilot in the Enterprise
These AI prompts are purpose-built for Microsoft Copilot, tapping directly into Word, Excel, PowerPoint, Outlook, Teams, GitHub, and the Microsoft 365 Graph. They transform how you interact with your organization's data, automate complex workflows, and produce professional-grade documents, code, and analysis. Whether you're a business user or a developer, these templates accelerate your work while staying compliant with enterprise security standards.
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 September 2026?
This page was refreshed on September 09, 2026 with updated prompt wording, cleaner formatting, and improved guidance so readers can quickly find the most useful AI prompt templates.
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.
