40+ Best Microsoft Copilot Prompts for Work (November 2026)

Enterprise-Ready AI Prompts for Microsoft 365 (Word, Excel, PowerPoint, Teams), Azure & GitHub

44 Best AI Prompts for Microsoft Copilot in 2026

Boost your daily workplace output with 44 tested prompts for Microsoft Copilot in 2026. Whether you are drafting source-cited proposals in Word, building formula-driven forecasts in Excel, generating brand-aligned decks in PowerPoint, triaging Teams & Outlook threads via Microsoft Graph, or refactoring code in GitHub Copilot, these templates give you verifiable, enterprise-ready deliverables.

QUICK ANSWER: HOW TO PROMPT MICROSOFT 365 & GITHUB COPILOT IN 2026

What Formula Works Best for Microsoft Copilot Prompts?

Microsoft recommends structuring every Copilot prompt around 4 core pillars: 1. Goal & Deliverable (what you want created), 2. Context & Audience (why you need it and who will read it), 3. Explicit Data Sources (type / in M365 Copilot to reference exact Word/Excel/PowerPoint files, Teams meetings, or people, or type @workspace in GitHub Copilot), and 4. Expectations & Guardrails (tone, table layout, citation requirements, and marking missing facts as [NEEDS INPUT]).

Updated for Nov 2026 M365 & GitHub Copilot 44 Enterprise-Ready Templates Microsoft Graph `/` Grounding Ready Free 1-Click Copy

Explore This Guide

Jump directly to any section of this article.

2026 MICROSOFT COPILOT ECOSYSTEM ARCHITECTURE

Microsoft Copilot App, Grounding Trigger & Output Matrix (2026)

Match each workplace task below to the right Copilot surface, `/` or `@` context trigger, and verification guardrail.

Copilot Surface Best Prompts on This Page Context Trigger to Type Ideal Output Format Key Enterprise Guardrail
Word, PowerPoint & Outlook #1, #4, #6, #8, #12 Type / to attach `.docx`, `.pptx`, or emails Sectioned draft with source tags Mark missing figures as [NEEDS INPUT]
Excel, Power BI & Dynamics #2–#3, #11, #13–#14, #16–#24 Format data as Excel Table (Ctrl+T) Live formulas (XLOOKUP) + Python in Excel Never overwrite raw actuals with hardcoded values
M365 Business Chat & Cowork #5, #7, #9–#10, #15, #36–#44 Toggle Work vs. Web tab + / files Cross-app action tables & Notebooks Separate internal Graph facts from public web claims
GitHub, VS Code & Azure Copilot #25–#35 @workspace, #file, @azure Diff patches, Bicep IaC, KQL & unit tests Keep secrets in Key Vault; require PR test pass

44 AI Prompts for Writing, Excel Analysis, GitHub Coding & Research

Filter by category or browse all 44 tested Microsoft Copilot templates below

1. Word Document Builder with Source Citations

WORD & WRITING

Draft a complete, executive-ready Word document from reference files with inline source tracking.

Create a comprehensive Word document for [project / proposal topic] grounded in /[File 1] and /[File 2]: 1. Structure the document with: Executive Summary (under 150 words), Business Objectives, Key Findings & Data Table, Risk & Mitigation Matrix, and Immediate Next Steps. 2. Cite the exact source filename and section inline after every major factual claim or metric. 3. Never invent numbers—insert `[NEEDS INPUT: owner/metric]` wherever data is missing from the referenced files.
Pro Microsoft Copilot Tip: In the Word Copilot draft box, type `/` to select up to 3 SharePoint or OneDrive reference files from the autocomplete menu so Copilot grounds every paragraph in your actual specs.

2. Copilot in Excel Formula & Trend Analyst

EXCEL & ANALYSIS

Analyze an Excel table, generate live formula columns, and surface top/bottom performers.

Analyze the active Excel Table in this workbook: 1. Identify the Top 3 and Bottom 3 performers across [metric column] grouped by [category/region column], and flag any statistical outlier rows exceeding 2 standard deviations from the mean. 2. Propose and insert dynamic Excel formula columns (using `XLOOKUP`, `SUMIFS`, `LET`, or percentage variance formulas—never paste static hardcoded numbers) and explain how each formula works. 3. Recommend the single best PivotChart type to visualize this trend and insert it on a new worksheet.
Pro Microsoft Copilot Tip: Copilot in Excel requires your data range to be formatted as an official Excel Table first (`Ctrl + T`) and saved to OneDrive or SharePoint with AutoSave turned on.

3. Excel Budget vs. Actuals Variance & Forecast Builder

EXCEL & FINANCE

Reconcile budget vs. actuals, rank top variances, and build a cell-traceable rolling forecast.

Review the Actuals vs. Budget table in this workbook: 1. Calculate both absolute (`$`) and relative (`%`) variance by line item and month, and rank the 5 largest Favorable and 5 largest Unfavorable variances in a summary table. 2. Explain the primary operational drivers behind the top variances using strictly the notes/categories present in the sheet. 3. Build a [3 or 6]-period rolling forecast where growth and cost assumptions live in a dedicated `Assumptions` cell block so every forecast cell is 100% formula-traceable.
Pro Microsoft Copilot Tip: Click Advanced Analysis (Python in Excel) inside Copilot when you want time-series forecasting (`ARIMA` / `Prophet`) run directly on your spreadsheet cells.

4. PowerPoint Executive Deck Builder from Word Doc

POWERPOINT

Convert a Word brief into a 10-slide presentation using your corporate Slide Master and speaker notes.

Create a 10-slide executive presentation from /[Word Document Name] using our active corporate PowerPoint template: 1. Narrative Arc: Slide 1 Title, Slide 2 Executive Summary, Slides 3–4 Problem & Data Evidence, Slides 5–7 Recommended Solution & Architecture, Slide 8 Financial/Resource Impact, Slide 9 Risk Mitigation, Slide 10 Decision & Timeline. 2. Rule of One: Keep slide body copy under 35 words per slide (max 4 bullets) and put the full spoken narrative inside the Speaker Notes pane. 3. Flag any slide claim that needs a chart or citation verified before the meeting.
Pro Microsoft Copilot Tip: Open your company's branded `.potx` or `.pptx` template file *first* before running this prompt so Copilot automatically applies your corporate fonts, colors, and Slide Master layouts.

5. Dual-Grounded Research Brief (M365 Work Graph + Live Web)

RESEARCH

Synthesize internal SharePoint/Teams files alongside live web market data while keeping sources separated.

Research [topic / strategic question] using both my Microsoft 365 work context and live web sources (ensure Web grounding is toggled ON): 1. Internal vs. External Split: Clearly separate findings pulled from our internal SharePoint/OneDrive/Teams files from external public web reports. 2. Source Confidence Table: List the 8 most important findings with columns: `Finding | Source Type (Internal File vs. Web URL) | Confidence Level (Confirmed / Single Source / Uncertain)`. 3. Conclude with 3 recommended actions tailored to our current internal roadmap.
Pro Microsoft Copilot Tip: In Microsoft 365 Copilot Business Chat (`Work` tab), toggle the globe icon (**Web content**) ON so Copilot combines your internal tenant knowledge with live Bing search results.

6. Outlook Inbox Priority Triage & Draft Responder

OUTLOOK & EMAIL

Triage unread Outlook emails by urgency, surface blockers requiring your sign-off, and draft replies.

Review my unread Outlook emails and @mentions from [today / the last 48 hours]: 1. Priority Triage Table: Categorize threads into: (A) Urgent — Reply Required Today, (B) Action Needed This Week, (C) Delegated / Waiting on Others, and (D) FYI Newsletter/Notification. 2. Decision Blockers: Highlight any email where a teammate or client is blocked waiting on my explicit approval. 3. Draft concise, action-oriented reply drafts (under 4 sentences each) for the top 3 Urgent emails. Do NOT send any email automatically.
Pro Microsoft Copilot Tip: Run this every morning at 9:00 AM inside the Outlook Copilot side pane to clear high-priority blockers before opening individual threads.

7. Cross-App M365 Project Brief Synthesizer (Outlook + Teams + Word)

M365 WORKFLOW

Consolidate scattered emails, Teams channel chats, meeting transcripts, and docs into one source-linked brief.

Using all available emails, Teams chats, meeting transcripts, and SharePoint files related to [Project Name] from the last [14 days]: Compile a single-page Project Status & Alignment Brief: 1. Current Status, Locked-In Decisions (with date and who approved), and Active Blockers. 2. Action & Ownership Table: `Deliverable | Owner | Stated Deadline | Source (Email/Meeting/Doc)`. 3. Conflict & Gap Alert: Flag any date or scope discrepancy where an email says one thing and a Teams chat or document says another.
Pro Microsoft Copilot Tip: Step 3 ("Conflict & Gap Alert") uses Microsoft Graph across apps to catch when a deadline gets moved in a Teams chat without updating the main project spec.

8. Teams Meeting Recap, Unassigned Task & Planner Extractor

TEAMS & MEETINGS

Convert a Teams meeting recording or transcript into verified decisions, owned tasks, and a follow-up post.

Analyze the transcript from this Teams meeting: /[Meeting Name]: 1. Decisions vs. Discussion: Separate decisions that were explicitly agreed upon from ideas that were merely brainstormed. 2. Planner-Ready Action Table: `Task | Assigned Owner | Due Date | Timestamp`. Mark any task where no owner or deadline was spoken aloud as `[UNASSIGNED — CONFIRM IN CHANNEL]`. 3. Unresolved Questions: List open questions that were tabled or ran out of time. 4. Draft a 4-bullet recap message ready to paste into the Teams meeting chat.
Pro Microsoft Copilot Tip: Run this prompt 2 minutes before a live Teams call ends so you can read the `[UNASSIGNED]` rows out loud and lock in owners before everyone hangs up.

9. Copilot Studio & Cowork Multi-Step Agent Delegator

COPILOT AGENTS

Define a staged execution plan with human-in-the-loop approval checkpoints for autonomous Copilot agents.

Delegate this multi-step workflow to Copilot: [describe target outcome and deadline] using these approved sources: /[File/Folder/Channel]. Follow these strict execution guardrails: 1. Plan First: Output a numbered execution plan listing every file, email draft, or tracker row you intend to read or create, and wait for my approval. 2. Approval Gates: Never send external emails, overwrite existing SharePoint files, or schedule calendar invites without pausing for my explicit confirmation. 3. Audit Summary: Conclude with a log of completed steps, skipped items, and items requiring human review.
Pro Microsoft Copilot Tip: Use this structure when configuring autonomous declarative agents in **Microsoft Copilot Studio** or M365 Agent Builder.

10. Copilot Pages & Notebook Knowledge Synthesizer

RESEARCH

Compile project files, emails, and notes into a persistent Copilot Page / Notebook with strict source grounding.

Create a structured project synthesis for [Project / Topic] grounded strictly in /[File 1], /[File 2], and /[Meeting/Email]: 1. One-Page Executive Overview & Architecture Summary. 2. Verified Fact Ledger: Every core metric, requirement, and date paired with its exact source file name. 3. Contradictions & Missing Info: Explicitly state `"NOT IN PROVIDED SOURCES"` for any standard project requirement that is missing, and list 5 onboarding FAQs for new team members.
Pro Microsoft Copilot Tip: Click **Edit in Pages** beneath Copilot's response to turn this output into a live collaborative Loop/Copilot Page that updates with your team in real time.

11. Executive Decision Matrix & Pre-Mortem Analyst

STRATEGY & ANALYSIS

Evaluate competing strategic options across TCO, execution risk, dependencies, and failure pre-mortems.

Evaluate these strategic options: [Option A vs. Option B vs. Option C] using our internal context in /[Reference File]: 1. Weighted Decision Matrix Table: Score each option (1–10) across Total Cost, Expected ROI, Time-to-Value, Technical Complexity, and Reversibility. 2. Key Assumption & Flip Test: Identify the single riskiest assumption behind the winning option and state what data point would flip the recommendation. 3. Pre-Mortem: Assume the chosen option failed 6 months from today and list the top 3 root causes and how to prevent them now.
Pro Microsoft Copilot Tip: Export the generated decision matrix directly to Word or PowerPoint to anchor leadership alignment meetings.

12. Source-Verified RFP & Security Questionnaire Responder

RFP & PROPOSALS

Draft compliant RFP responses grounded strictly in your SharePoint proposal library and SOC2/ISO docs.

Answer the following RFP / security questionnaire items using strictly our approved internal documents in /[Proposal Doc] and /[Security/Case Study Doc]: [Paste RFP questions] 1. For each question, write a concise, persuasive, and compliant response matching the buyer's exact terminology. 2. Source Attribution: Immediately below each answer, cite ``. 3. Hallucination Guardrail: Never invent certifications, SLAs, or customer metrics—if an answer is not explicitly supported in our files, mark it `[SME VERIFICATION REQUIRED]`.
Pro Microsoft Copilot Tip: Pointing Copilot to a dedicated SharePoint folder of past winning RFPs cuts proposal drafting time by 70% while preventing fabricated compliance claims.

13. Dynamics 365 CRM + Web Competitive Battlecard Builder

SALES & CRM

Combine internal CRM win/loss call notes with live competitor web positioning into a 1-page sales battlecard.

Build a 1-page Sales Competitive Battlecard for [Our Product] vs. [Competitor Name] combining our internal notes in /[CRM Export / Call Notes] and live Web search: 1. Head-to-Head Positioning Table: Pricing Model, Core Technical Wedge, Where We Win, and Where We Lose. 2. Top 4 Prospect Objections: Quote the exact objections prospects raise on calls and write a 2-sentence trap-setting rebuttal for each. 3. Landmine Discovery Questions: 3 sharp questions our Account Executives should ask early in discovery to expose [Competitor Name]'s architectural weaknesses. 4. Clearly label which insights come from internal CRM notes vs. public web sources.
Pro Microsoft Copilot Tip: Works seamlessly in **Microsoft Copilot for Sales** connected to Dynamics 365 or Salesforce.

14. Power BI Executive Narrative & Anomaly Explainer

POWER BI

Translate a complex Power BI dashboard page into plain-English KPI takeaways and root-cause questions.

Summarize this Power BI report page for [target executive audience, e.g., VP of Operations / CFO]: 1. Headline KPI Narrative: Walk through the primary visuals, stating exact period-over-period changes and whether each metric is on track against target. 2. Anomaly & Slice Spotlight: Pinpoint the most significant regional, product, or cohort outlier driving variance on this page. 3. Actionable Next Step: Provide 2 concrete operational recommendations supported by the visuals and 1 diagnostic question to ask the data owner.
Pro Microsoft Copilot Tip: Drop this prompt into the **Narrative with Copilot** visual inside Power BI Desktop or Power BI Service so the summary auto-refreshes whenever users click a slicer!

15. Scheduled Weekly Status Report & Anomaly Gate

AUTOMATION

Automate a recurring Friday executive status update across Teams, Outlook, and Excel with an approval hold.

Prepare this week's Executive Status Report for [Project / Department] covering [Date Range] using /[Excel Tracker], recent Teams channel updates in /[Channel], and my sent emails: 1. Format into 4 tight sections: Headline Wins & Metrics (vs. last week), Shipped Deliverables, Red/Yellow Risks & Blockers, and Next Week's Top 3 Priorities. 2. Delta Check: Flag any KPI or deadline that slipped compared to last week's report. 3. Hold for Review: Output the draft here for my inspection first—never post or email stakeholders until I confirm.
Pro Microsoft Copilot Tip: Save this prompt in **Copilot Prompt Gallery (My Prompts)** and schedule it via Power Automate + Copilot Studio for a zero-friction Friday ritual.

16. Microsoft Planner & Project Critical-Path Risk Scanner

PROJECT & PLANNER

Audit a project schedule export for zero-slack tasks, overallocated owners, and cascading delay risks.

Analyze this project schedule from Microsoft Planner / Project: /[Schedule File or Table]: 1. Critical Bottleneck Scan: Identify all tasks with zero buffer/float, tasks with overdue predecessors, and team members assigned to more than 3 concurrent deadlines in the same week. 2. Cascade Simulation: Show which downstream milestones slip if the top 2 bottleneck tasks are delayed by 5 business days. 3. Output a prioritized Risk Register Table (`Task ID | Owner | Bottleneck Type | Cascade Impact | Concrete Rebalancing Fix`).
Pro Microsoft Copilot Tip: Export your Planner board to Excel (`Export plan to Excel`) and run this prompt to spot resource overallocation across sprints immediately.

17. Microsoft Forms Survey Sentiment & Verbatim Theme Coder

FORMS & EXCEL

Code open-ended Microsoft Forms responses into sentiment buckets, frequency counts, and urgent escalations.

Analyze the open-ended survey responses in this Microsoft Forms Excel export: 1. Sentiment & Theme Table: Group all verbatim comments into the Top 5 recurring themes (`Theme | Response Count & % | Sentiment Breakdown (Pos/Neu/Neg) | Representative Verbatim Quote`). 2. Urgent Escalation Filter: Flag any individual response mentioning safety, billing errors, legal/compliance issues, or immediate churn intent by Row ID. 3. Recommend the #1 product or process fix that addresses the largest cluster of negative feedback.
Pro Microsoft Copilot Tip: Click *Open in Excel* inside Microsoft Forms so Copilot can add a live Sentiment category column next to every respondent row.

18. 6-Month Rolling Sales Pipeline & What-If Scenario Modeler

EXCEL & DYNAMICS

Model Best, Base, and Bear sales revenue forecasts weighted by stage conversion probabilities.

Using the 12-month historical sales and open pipeline table in this workbook: 1. Stage-Weighted Forecast: Calculate a 6-month revenue forecast weighting open deals by historical stage win-rate and average sales cycle length. 2. Three-Scenario Table: Model **Bull** (+20% win rate), **Base** (historical average), and **Bear** (-25% win rate & +15 days cycle slip) against our quarterly quota target of `[Target $]`. 3. Pipeline Gap Action Plan: Calculate the exact pipeline coverage ratio required this month to hit Base quota and flag stalled deals over 45 days old.
Pro Microsoft Copilot Tip: Flagging "stalled deals over 45 days old" stops zombie pipeline opportunities from inflating your quarterly forecast.

19. Regulatory & Security Policy Compliance Gap Auditor

COMPLIANCE & WORD

Cross-check your internal IT or data policy Word doc against a new regulatory standard line by line.

Compare our internal policy in /[Internal Policy Doc] against the regulatory requirements in /[Regulation / Standard Doc]: 1. Clause-by-Clause Gap Matrix: `Regulation Requirement | Current Internal Policy Section | Compliance Status (Compliant / Partial / Missing) | Exact Gap Description`. 2. Redline Wording Updates: Draft the exact replacement paragraphs needed to bring Partial or Missing sections into compliance. 3. Flag any high-risk ambiguity that requires formal sign-off from Legal or our DPO/CISO.
Pro Microsoft Copilot Tip: Use this in Word or Microsoft Purview Compliance Manager when updating internal SOPs for ISO 27001, SOC 2, DPDP Act, or GDPR audits.

20. CFO-Ready P&L Budget Variance Commentary Writer

FINANCE & EXCEL

Turn a raw P&L variance spreadsheet into concise, board-ready financial commentary for the CFO.

Based on the P&L Budget vs. Actuals data in /[Excel Workbook]: 1. Top Variance Breakdown: Identify the 3 largest positive and 3 largest negative variances across Revenue, COGS, and OpEx (stating both `$` and `%` impact on EBITDA). 2. Price vs. Volume Decomposition: Separate variances driven by unit volume shifts from those driven by pricing/rate or one-time timing differences. 3. Draft a 250-word CFO Executive Commentary narrative with concrete cost-containment or reallocation actions for next month.
Pro Microsoft Copilot Tip: Separating "one-time timing differences" from "structural run-rate overruns" gives finance leaders the exact context they need for board decks.

21. Multi-Attachment Email Thread Data Consolidator

OUTLOOK & M365

Extract and reconcile numbers, quotes, and deadlines buried across multiple email attachments.

Review the email thread regarding [Topic / Vendor Quote] and its attached files (`/[Attachment 1]`, `/[Attachment 2]`): 1. Consolidated Comparison Table: Extract all pricing figures, delivery dates, scope exclusions, and payment terms across every attachment into one normalized table. 2. Version Drift Check: Highlight any number or term that changed between earlier and later attachments in the thread. 3. Summarize the open action items for the project manager in 3 bullet points.
Pro Microsoft Copilot Tip: Run this in M365 Business Chat when vendors send 4 revised PDF/Excel quotes across a long email chain.

22. IT Helpdesk & ServiceNow Ticket Root-Cause Deflector

IT OPS & BI

Analyze quarterly IT support ticket exports to find MTTR bottlenecks and self-service automation wins.

Analyze this IT Helpdesk / ServiceNow ticket dataset in /[Excel or CSV]: 1. Incident Pareto Table (80/20 Rule): Rank the top 5 incident categories by ticket volume, Mean Time to Resolution (MTTR), and SLA breach rate. 2. Spike & Correlation Check: Identify specific dates, software rollouts, or departments correlated with ticket volume spikes. 3. Deflection Playbook: Recommend 3 specific self-service KB articles or Power Automate / Intune remediation scripts that would deflect at least 30% of Tier-1 tickets.
Pro Microsoft Copilot Tip: Pair the top recurring Tier-1 ticket category from step 3 with Prompt #38 to immediately generate the SharePoint self-service KB article.

23. ADKAR Change-Management & Department Impact Mapper

CHANGE MANAGEMENT

Map how an upcoming software rollout or org policy impacts each department with tailored comms plans.

We are rolling out this organizational/system change: [describe change and timeline] using context from /[Project Charter Doc]: 1. Department Impact Matrix: For each impacted team (Sales, Engineering, Ops, Finance, Support), rate Disruption Level (Low/Med/High), Daily Workflow Change, and Primary Resistance Risk. 2. ADKAR Rollout Plan: Outline specific enablement steps (Awareness, Desire, Knowledge, Ability, Reinforcement) and training assets needed per role. 3. Draft a concise FAQ addressing the top 5 employee concerns.
Pro Microsoft Copilot Tip: Grounding this prompt in your internal project charter ensures role names and system workflows match your company's actual terminology.

24. Vendor Contract Redline & Liability Clause Auditor

LEGAL & WORD

Scan a third-party vendor agreement in Word for uncapped liability, auto-renewal traps, and IP risks.

Review this contract in Word (from our perspective as the [Customer / Service Provider]): 1. Risk Clause Table: Scan for Limitation of Liability, Indemnification, IP Ownership, Data Privacy/Breach Notice, Auto-Renewal, and Termination for Convenience. Rate each as `[High Risk]`, `[Medium Risk]`, or `[Standard]`. 2. Missing Protections: Flag any standard protective clause that is completely absent from the agreement. 3. Redline Fallback Text: For every `[High Risk]` clause, quote the exact current text and write a balanced fallback clause ready to paste as a Word Track Changes redline.
Pro Microsoft Copilot Tip: You can also reference your company's `/[Standard Contract Playbook.docx]` so Copilot checks every vendor clause against your pre-approved legal fallback positions.

25. GitHub Copilot Modular Code Refactoring (`@workspace`)

GITHUB COPILOT

Refactor high-complexity TypeScript/JavaScript or Python functions into modular, testable units in VS Code.

@workspace Refactor the selected function/module in `#file` to reduce cyclomatic complexity and improve type safety: 1. Extract single-responsibility helper functions while keeping the public export signature 100% backward-compatible across the workspace. 2. Replace nested callbacks/conditionals with early guard clauses, strict TypeScript types (zero `any`), and explicit error handling. 3. Explain each structural change in a concise PR review table and generate unit tests covering all branches.
Pro Microsoft Copilot Tip: In VS Code GitHub Copilot Chat, prefixing with `@workspace` and `#file` lets Copilot inspect all callers across your repo before modifying function signatures.

26. Azure Well-Architected Bicep & Terraform IaC Generator

AZURE & IAC

Generate production-hardened Azure Bicep or Terraform templates with Managed Identity and Key Vault RBAC.

@azure Write a modular, production-ready Azure [Bicep / Terraform] template to provision: [e.g., an Azure Function App / Container App, Storage Account, Key Vault, and Application Insights]. Requirements: 1. Security (Zero Shared Keys): Use System-Assigned Managed Identity and RBAC role assignments (`Storage Blob Data Owner`, `Key Vault Secrets User`) instead of hardcoded connection strings. 2. Network & Reliability: Enforce HTTPS-only, TLS 1.2+, minimum SKU parameters for Dev vs. Prod, and diagnostic log routing to Log Analytics. 3. Include parameter validation decorators and deployment CLI commands (`az deployment group create`).
Pro Microsoft Copilot Tip: Enforcing "System-Assigned Managed Identity instead of connection strings" ensures your Bicep templates pass Azure Policy and Defender for Cloud security scans on first deploy.

27. Microsoft Graph PowerShell SDK Admin Automator

POWERSHELL & M365

Write modern `Microsoft.Graph` PowerShell 7 scripts for Entra ID and M365 license/user auditing.

Write a PowerShell 7 script using the modern `Microsoft.Graph` SDK (do NOT use deprecated `AzureAD` or `MSOnline` modules) to: [e.g., find all Entra ID / M365 licensed users with no interactive or non-interactive sign-in activity in the last 30 days and export a license-reclamation report to CSV]. Include: 1. Least-Privilege Scopes: Exact `Connect-MgGraph -Scopes` required (e.g., `User.Read.All`, `AuditLog.Read.All`). 2. Server-Side Filtering & Pagination: Use `-Filter` and `-All` with `-Property` selection so it runs fast on tenants with 10,000+ users. 3. Support `-WhatIf` / `SupportsShouldProcess` and structured `try/catch` error logging.
Pro Microsoft Copilot Tip: Explicitly banning the retired `AzureAD` and `MSOnline` modules ensures Copilot outputs modern `Get-MgUser` cmdlets that work in 2026 M365 tenants.

28. Azure SQL & T-SQL Execution Plan & Index Optimizer

AZURE SQL

Refactor high-DTU/vCore T-SQL queries by eliminating key lookups, implicit conversions, and non-sargable predicates.

Optimize this slow T-SQL query running on Azure SQL Database / SQL Server: [Paste T-SQL query and table schema/indexes] 1. Execution Bottleneck Audit: Check for non-SARGable `WHERE` clauses, implicit type conversions, scalar UDFs, Key Lookups, and TempDB spills. 2. Refactored T-SQL: Rewrite the query using sargable predicates, window functions, or indexed CTEs/temp tables. 3. Missing Index DDL: Provide the exact `CREATE NONCLUSTERED INDEX ... INCLUDE (...)` statement tailored to this query's filter and join columns.
Pro Microsoft Copilot Tip: Adding `INCLUDE (...)` covering columns to your nonclustered index eliminates expensive Key Lookups on high-frequency Azure SQL endpoints.

29. Azure Functions v4 (TypeScript / Node.js) Serverless API Builder

AZURE FUNCTIONS

Build an Azure Functions v4 HTTP trigger in TypeScript with Zod validation and Key Vault secret loading.

Create a production-ready Azure Functions v4 (Node.js 22, TypeScript programming model v4 `@azure/functions`) HTTP endpoint for [resource/action]: 1. Use the modern `app.http(...)` registration syntax (not legacy `function.json` folders). 2. Implement request payload validation, structured correlation-ID logging (`context.log`), and secret retrieval via `@azure/identity` (`DefaultAzureCredential`) + `@azure/keyvault-secrets`. 3. Return standardized HTTP status codes (`200`, `400`, `401`, `500`) and include an OpenAPI / Swagger schema definition.
Pro Microsoft Copilot Tip: Specifying "`@azure/functions` v4 programming model" prevents code generators from outputting legacy v3 `function.json` boilerplate.

30. .NET 9 MAUI & C# MVVM Cross-Platform Screen Architect

.NET & C#

Generate a responsive .NET MAUI XAML view and C# `CommunityToolkit.Mvvm` ViewModel.

Build a cross-platform .NET MAUI screen for [purpose, e.g., offline-capable service ticket list & detail navigation]: 1. XAML View: Include a debounced `SearchBar`, a virtualized `CollectionView` with `RefreshView` (pull-to-refresh), empty/skeleton state templates, and compiled bindings (`x:DataType`) for fast rendering. 2. C# ViewModel: Use `CommunityToolkit.Mvvm` source generators (`[ObservableProperty]`, `[RelayCommand]`), async cancellation tokens, and Shell URI navigation (`Shell.Current.GoToAsync`). 3. Ensure clean dependency injection registration in `MauiProgram.cs`.
Pro Microsoft Copilot Tip: Enforcing compiled bindings (`x:DataType`) and `CommunityToolkit.Mvvm` source generators cuts boilerplate C# property code by 70% in Visual Studio.

31. Automated Python (`pandas` + `openpyxl`) Excel Report Generator

PYTHON & EXCEL

Automate multi-tab Excel reporting with formatted PivotTables, conditional formatting, and embedded charts.

Write a complete Python script using `pandas` and `openpyxl` (or `xlsxwriter`) that reads `[Input_File.xlsx]`, cleans messy dates/nulls, and generates an executive multi-sheet workbook `[Output_Report.xlsx]`: 1. Sheet 1 (`Executive Summary`): Aggregated KPIs by [Region and Month] with currency/percentage number formatting, auto-fitted column widths, frozen header panes, and conditional color scales. 2. Sheet 2 (`Charts`): Embed a native Excel bar/line chart linked dynamically to the summary table cells. 3. Add defensive `try/except` checks for missing columns or locked files.
Pro Microsoft Copilot Tip: Auto-fitting column widths and applying native number formats (`$#,##0.00`) in `openpyxl` makes Python-generated workbooks ready to email to executives with zero manual formatting.

32. Fluent UI React v9 (`@fluentui/react-components`) Component Builder

REACT & FLUENT UI

Build accessible Microsoft Teams tabs, SharePoint SPFx web parts, or enterprise React UIs with Fluent v9 tokens.

Create a reusable, accessible React TypeScript component for [UI component, e.g., an Interactive Employee / Customer Profile Card or Data Grid] using Microsoft **Fluent UI React v9** (`@fluentui/react-components`): 1. Use Fluent v9 Griffel styling (`makeStyles`, `tokens`) so the component automatically adapts to Microsoft Teams Light, Dark, and High-Contrast themes. 2. Include `Avatar`, `Badge`, `Button`, and `Tooltip` primitives with full WCAG 2.2 AA keyboard navigation and `aria-*` attributes. 3. Export strict TypeScript prop interfaces and a Storybook/usage example.
Pro Microsoft Copilot Tip: Explicitly requesting `@fluentui/react-components` (v9 with `makeStyles` and `tokens`) stops AI models from mixing in deprecated Fluent v8 (`@fluentui/react`) imports.

33. GitHub Actions OIDC Passwordless Azure Deployment Workflow

GITHUB ACTIONS

Generate a secure CI/CD workflow using Federated OIDC credentials (zero long-lived Azure client secrets).

Write a production `.github/workflows/azure-deploy.yml` GitHub Actions workflow to build, test, and deploy a [.NET / Node.js / Next.js / Python] app to [Azure App Service / Azure Container Apps / Static Web Apps]: 1. Security: Use **OpenID Connect (OIDC)** federated authentication (`azure/login@v2` with `id-token: write`) instead of static publish profiles or expiring client secrets. 2. Pipeline Stages: Separate `build-and-test` (with dependency caching and test coverage artifact upload) from `deploy-production` (gated by GitHub Environment protection rules). 3. Include an automated post-deploy HTTP health-check smoke test.
Pro Microsoft Copilot Tip: Using OIDC federated identity with `azure/login@v2` eliminates production outages caused by expired Azure Service Principal secrets in GitHub Actions.

34. Legacy Excel VBA Macro to TypeScript Office Scripts Converter

OFFICE SCRIPTS

Migrate desktop-only `.xlsm` VBA macros into cloud-ready TypeScript Office Scripts compatible with Power Automate.

Convert this legacy Excel VBA macro into a modern TypeScript **Office Script** (`function main(workbook: ExcelScript.Workbook)`): [Paste VBA Sub/Function code] 1. Replace slow cell-by-cell VBA `.Select` / `.Activate` loops with batch 2D array reads and writes (`range.getValues()` and `range.setValues()`) so the script runs safely inside Excel on the Web. 2. Add optional input parameters and a typed JSON return object so this Office Script can be triggered automatically from a **Power Automate** cloud flow. 3. Flag any desktop-only VBA API (like local `FileSystemObject` or Windows registry calls) that must be moved to Power Automate connectors.
Pro Microsoft Copilot Tip: Adding typed parameters and return values to `main()` lets you chain this Excel script directly inside an automated SharePoint/Power Automate flow.

35. Microsoft Sentinel & Defender KQL Threat-Hunting Query Builder

SECURITY COPILOT & KQL

Write optimized Kusto Query Language (KQL) hunting rules for Microsoft Sentinel and Defender XDR.

Write an optimized **KQL (Kusto Query Language)** detection and hunting query for Microsoft Sentinel / Microsoft Defender XDR to detect: [e.g., privileged Entra ID role assignments (`Global Administrator`) outside change windows, or anomalous impossible-travel sign-ins followed by inbox forwarding rules]. 1. Query Performance: Filter by `TimeGenerated` first, use case-insensitive operators (`=~`, `has_any`) instead of `contains`, and join `AuditLogs` / `SigninLogs` / `DeviceEvents` efficiently. 2. Entity Mapping: Project `TimeGenerated`, `InitiatingUserPrincipalName`, `IPAddress`, `TargetResource`, and `RiskDetail` for Sentinel Incident Entity Mapping. 3. Explain how a SOC analyst should triage true positives vs. benign admin activity.
Pro Microsoft Copilot Tip: Filtering on `TimeGenerated` on line 1 and using token-indexed operators (`has` instead of `contains`) prevents KQL timeouts across multi-terabyte Log Analytics workspaces.

36. Hybrid Market Intelligence Brief (Internal CRM + Live Web Trends)

RESEARCH

Cross-reference your internal regional sales numbers against external 2026 macro industry reports.

Compile a 2-page Market Intelligence Brief for [Product / Service Line] combining our internal performance data in /[Sales Tracker.xlsx] with live 2026 Web market research: 1. Internal vs. Market Growth Benchmark: Compare our YoY growth rate by segment against external industry averages—are we gaining or losing market share? 2. Competitor & Pricing Shifts: Summarize recent competitor launches, pricing changes, or regulatory shifts from public web sources. 3. Recommend 3 high-margin growth segments to prioritize next quarter, citing both the internal spreadsheet metric and external web source for each.
Pro Microsoft Copilot Tip: Blending internal actuals with external benchmarks reveals whether a sales dip is an internal execution issue or an industry-wide macro slowdown.

37. Peer-Reviewed Literature Synthesis with APA 7th Citations

RESEARCH

Synthesize recent academic studies and technical whitepapers into a structured methodology and gap table.

Using Web grounding (and any attached PDFs in /[Folder/File]), synthesize the last 3 years of peer-reviewed research on "[Research Topic]": 1. Study Comparison Matrix: Identify at least 5 primary studies with columns: `Authors & Year | Journal / Venue | Sample & Methodology | Key Quantitative Finding | Stated Limitation`. 2. Consensus vs. Contradiction: Explain where empirical findings converge and where studies conflict. 3. Research Gap & APA Bibliography: Define the clearest unanswered research question and format all verified references in strict APA 7th style (never invent DOIs).
Pro Microsoft Copilot Tip: Always click the numbered footnote badges in Copilot's response to verify the live publisher link before adding a citation to your manuscript.

38. SME Teams Transcript to SharePoint Knowledge Base Article

SHAREPOINT & KB

Turn a recorded screen-share or SME troubleshooting call into a standardized SharePoint how-to article.

Transform this Subject Matter Expert (SME) interview or troubleshooting call transcript in /[Teams Transcript] into a standardized SharePoint Knowledge Base (KB) article: 1. Article Header: Search-Friendly Title, Target Audience, Prerequisites, and Estimated Completion Time. 2. Step-by-Step Procedure: Convert spoken explanations into numbered, imperative action steps (`1. Open X and click Y...`), inserting `[SCREENSHOT PLACEHOLDER: describe screen]` wherever a visual aid is needed. 3. Troubleshooting & FAQ Table: Extract common error messages mentioned on the call (`Symptom / Error | Root Cause | Fix`) plus suggested SharePoint metadata tags.
Pro Microsoft Copilot Tip: Recording a 10-minute Teams screen-share with a senior engineer and running this prompt is the fastest way to document tribal knowledge into SharePoint.

39. R&D Patent Landscape & White-Space Opportunity Mapper

PATENTS & R&D

Map competing technical claims, key assignees, and uncrowded innovation white space in a technology domain.

Analyze the public patent and R&D landscape for "[Technology Area / Mechanism]" alongside our internal R&D notes in /[File]: 1. Technical Approach Matrix: Group existing patents and public architectures into 3–4 core mechanisms (`Mechanism | Major Assignees | Core Advantage | Technical Bottleneck`). 2. White-Space Identification: Pinpoint 3 under-explored technical intersections where customer pain is high but patent density is lower. 3. Provide exact Boolean search strings (`CPC class + keywords`) for our IP counsel to run in Google Patents / Espacenet.
Pro Microsoft Copilot Tip: Export the Technical Approach Matrix to Excel to track prior-art references alongside your engineering team's invention disclosures.

40. Vendor & M&A Due Diligence Red-Flag Checklist

DUE DILIGENCE

Synthesize public filings, news, and internal deal notes into a 4-pillar Due Diligence tracker.

Build a comprehensive Due Diligence Assessment for [Target Company / Enterprise Vendor] combining internal notes in /[Deal File] and live Web search: 1. 4-Pillar Audit Table: Organize findings and open verification items across **Financial Health**, **Technical & Security Architecture**, **Legal/Regulatory & IP**, and **Customer Reputation / Churn Signals**. 2. Red-Flag Spotlight: Highlight any recent litigation, executive turnover, security incidents, or negative glassdoor/customer trends found via search. 3. List the top 10 document requests (VDR items) we must require from them before signing.
Pro Microsoft Copilot Tip: Move the generated 10-item VDR checklist into Microsoft Lists or Excel to track document handoffs during procurement or M&A review.

41. Viva Learning & Compliance Training Module Architect

L&D & COMPLIANCE

Turn a dense regulatory policy into an interactive 45-minute employee training curriculum and quiz.

Design a 45-minute interactive employee training module based on our policy in /[Compliance Policy Doc]: 1. Curriculum Table: Break the session into 4 time-boxed modules (`Module | Learning Objective | Real-World Workplace Scenario | Interactive Poll/Activity`). 2. Role-Specific Do/Don't Cheat Sheet: Translate abstract legal rules into concrete daily behaviors for engineers, sales reps, and support staff. 3. Assessment Quiz: Write 8 scenario-based multiple-choice questions (with realistic distractors and answer key explanations) to verify comprehension.
Pro Microsoft Copilot Tip: Scenario-based questions ("A vendor emails you a spreadsheet containing customer phone numbers—what do you do?") test real behavioral compliance far better than definition recall.

42. 10-K & Annual Report Competitive Financial Benchmarker

FINANCE & 10-K

Benchmark revenue growth, gross margin, R&D intensity, and risk factors across competing 10-K filings.

Compare the latest annual reports / 10-K filings for [Company A], [Company B], and [Company C] (using attached PDFs `/[File]` or Web search): 1. Financial Ratio Comparison Table: Align Revenue YoY Growth, Gross Margin %, Operating Margin %, R&D as % of Revenue, SG&A as % of Revenue, and Revenue per Employee. 2. Strategic Capital Allocation: Where is each company increasing investment vs. cutting costs? 3. New Risk Factor Diff: Highlight any new or escalated warnings in Item 1A (Risk Factors) that reflect 2026 supply-chain, AI, or regulatory pressures.
Pro Microsoft Copilot Tip: Open the generated Financial Ratio Comparison Table directly in Excel to chart multi-year margin trends across competitors.

43. Legacy Intranet & Wiki to SharePoint Information Architect

SHAREPOINT

Audit an outdated wiki export or folder tree to design a modern SharePoint hub taxonomy and metadata schema.

Analyze this export/inventory of our legacy wiki or shared drive: /[Inventory File or Text Dump]: 1. Content Audit: Group existing pages into 3 buckets: **Keep & Migrate As-Is**, **Consolidate/Merge** (duplicate pages), and **Archive/Delete** (outdated content). 2. SharePoint Hub & Page Taxonomy: Propose a clean navigation hierarchy (Hub Site -> Communication Sites -> Document Libraries) optimized for search findability. 3. Managed Metadata Schema: Define 5 standardized SharePoint column tags (`Department`, `Content Type`, `Review Cycle`, `Owner`, `Status`) so files never become orphaned again.
Pro Microsoft Copilot Tip: Cleaning up duplicate and stale wiki pages *before* enabling M365 Copilot across your tenant dramatically improves Copilot's answer accuracy for the whole company!

44. End-to-End Customer Journey & Churn-Friction Mapper

CX & DYNAMICS

Combine support ticket logs and NPS survey data to map friction points across the 5 stages of your customer journey.

Synthesize our customer support logs in /[Tickets File] and NPS/CSAT survey feedback in /[Survey File] into an evidence-backed Customer Journey Map: 1. 5-Stage Journey Matrix: Across **Discovery**, **Onboarding/Setup**, **Daily Adoption**, **Support/Troubleshooting**, and **Renewal/Expansion**, list: Customer Goal, Top Friction Point (with ticket/survey frequency), Emotional State, and Drop-Off Risk. 2. Time-to-First-Value (TTFV) Bottleneck: Pinpoint the exact onboarding step where new users get stuck most often. 3. Propose 3 high-ROI fixes ranked by impact on 90-day retention.
Pro Microsoft Copilot Tip: Grounding your journey map in real support ticket counts replaces guesswork workshops with hard retention data.

MICROSOFT 365 & GITHUB COPILOT ENTERPRISE GUIDE

Microsoft Copilot: Enterprise Prompting & Graph Grounding Guide

Use these engineering guidelines alongside the 44 prompt templates above to maximize accuracy, security, and cross-application speed across Microsoft 365 Copilot, Copilot Studio, Azure Copilot, and GitHub Copilot.

1. Optimizing Your Microsoft Copilot Workflow with the 4-Part Formula

Microsoft's prompt engineering framework evaluates instructions across four explicit elements: Goal (the exact deliverable), Context (why you need it and who the audience is), Source (which specific files, meetings, or tables to pull from), and Expectations (tone, table columns, and verification rules). Always instruct Copilot to mark missing evidence as [NEEDS INPUT] rather than guessing.

2. Step-by-Step Guide: Using `/` Microsoft Graph Grounding Across Word, PowerPoint, Outlook & Teams

In Microsoft 365 Business Chat, Word, and PowerPoint, typing forward slash (/) opens the Microsoft Graph picker, allowing you to pin exact `.docx`, `.xlsx`, `.pptx`, PDF files, Loop pages, or Teams meetings. Explicitly pinning 1–3 authoritative files narrows the semantic search space and prevents Copilot from pulling numbers from outdated draft files sitting in old SharePoint folders.

3. Best Practices for Copilot in Excel, Python in Excel, and Power BI

Copilot in Excel operates on structured **Excel Tables** (`Ctrl + T`) stored on OneDrive or SharePoint with AutoSave enabled. Always instruct Copilot to generate live Excel formulas (`XLOOKUP`, `SUMIFS`, `LET`) rather than pasting static values, and enable **Advanced Analysis (Python in Excel)** when running multi-variable regressions, cohort retention plots, or time-series forecasts.

4. Maintaining Data Security, Microsoft Purview Compliance, and Human-in-the-Loop Controls

Microsoft 365 Copilot inherits your signed-in Entra ID permissions and Microsoft Purview sensitivity labels. However, before rolling out tenant-wide prompts, audit overshared SharePoint sites (see Prompt #43) so employees don't accidentally surface stale or misconfigured files, and enforce human-in-the-loop approval gates before sending external client communications or RFP submissions.

5. Unlocking GitHub Copilot (`@workspace`), Azure Bicep IaC, and KQL Security Hunting

In VS Code and Visual Studio, use `@workspace`, `#file`, and `#selection` to ground GitHub Copilot in your repository's existing types and architecture. When generating Azure Bicep/Terraform templates or GitHub Actions pipelines, explicitly require **Managed Identity (RBAC)** and **OIDC federated login** so zero long-lived secrets are ever committed to source control.

AI Prompt Templates for Microsoft Copilot in the Enterprise

These 44 prompt templates cover Word, Excel, PowerPoint, Outlook, Teams, SharePoint, Power BI, Dynamics 365, Azure, Sentinel, and GitHub Copilot. Copy any prompt above, type / to attach your Microsoft 365 files, and get verifiable enterprise results in seconds.

Adnan Khan - Founder of I Love AI Prompt

About the Author

Adnan Khan

Founder of I Love AI Prompt • AI Prompt Researcher • Prompt Engineering Specialist

Hi, I'm Adnan Khan, the founder of I Love AI Prompt. I research, test, and publish AI prompts for creators, developers, marketers, designers, students, and businesses. Every prompt on this website is reviewed and refined to improve output quality, consistency, and usability across today's leading AI tools.

This guide was created by auditing real-world Microsoft 365 Copilot, Excel, Power BI, Azure, and GitHub Copilot workflows for measurable workplace productivity.

Frequently Asked Questions

What was updated on this page for November 2026?

This page was updated on November 10, 2026 with a 2026 Microsoft Copilot App & Grounding Matrix, expanded multi-step instructions across all 44 prompt templates, unique workflow tips for `/` Graph file pinning, Excel Tables, and GitHub `@workspace` commands, fixed category filters, and synchronized JSON-LD schema.

What are the best AI prompts for Microsoft Copilot in 2026?

The best AI prompts for Microsoft Copilot in 2026 follow the 4-part Goal + Context + Source (`/` file reference or `@workspace`) + Expectations formula, require inline source citations, and instruct Copilot to mark missing figures as `[NEEDS INPUT]` instead of guessing.

Why is the Copilot button grayed out in my Excel workbook?

Copilot in Excel requires two things to activate: 1) your workbook must be saved on OneDrive or SharePoint with AutoSave turned ON, and 2) your data range must be formatted as an official Excel Table (`Ctrl + T` or Home -> Format as Table).

Do these Copilot prompts work with the free version of Microsoft Copilot?

Yes. Most writing, analysis, research, and coding prompts work in the free web/Windows version of Microsoft Copilot when you paste your text or upload a file directly. Prompts that automatically pull from Outlook, Teams meetings, or SharePoint via `/` Graph grounding require a Microsoft 365 Copilot license.

How do I use the coding prompts (#25–#35) in GitHub Copilot?

Open GitHub Copilot Chat in VS Code or Visual Studio, type `@workspace` or `#file` to attach your active source files, and paste any prompt from #25 to #35 to generate refactored diffs, Bicep templates, PowerShell scripts, or unit tests.

Should I fact-check information generated by Microsoft Copilot?

Yes. Always click the linked source citations in Word, Teams, and Business Chat to verify figures against the original file, audit Excel formula ranges, and run unit tests on generated GitHub Copilot code before deploying to production.