Copilot / Copilot Chat Prompts

Curated collection of prompts organized by category to speed up your work with Copilot and Copilot in M365.

descriptionOffice

  1. Generate an executive summary of this text highlighting key points and recommendations.
  2. Convert the following notes into a 5-slide presentation with titles and 3 bullets per slide.
  3. Create a comparative table in Word with columns: Requirement, Priority, Owner.

assignmentAdministrative

  1. Draft a formal email requesting budget approval for project X (include justification and estimated ROI).
  2. Prepare meeting minutes with agenda, decisions and next steps.
  3. Generate a weekly operations checklist for the administrative team.

bar_chartData Analytics

  1. Provide a Python (pandas) script to clean data: remove duplicates, impute NAs and produce a statistical summary.
  2. Create SQL queries that calculate monthly churn and cohort analysis by signup date.
  3. Suggest Power BI visualizations for KPIs: revenue, conversion rate and average ticket.

support_agentAgents

  1. Design a conversational support agent that performs basic diagnostics and creates a ticket with severity.
  2. Create system instructions for an HR assistant agent to respond to FAQs.
  3. List intents and entities for an internal booking agent (room, date, duration, participants).

groupsTeams

  1. Write a short message to announce a project update in a Teams channel with required action.
  2. Draft a bot script for Teams that schedules reminders and posts meeting notes.
  3. Prepare a quick survey template for Teams with 3 satisfaction questions.

emailOutlook

  1. Draft a friendly follow-up email reminding about a deadline and pending actions.
  2. Create a professional out-of-office automatic reply with alternate contact details.
  3. Suggest inbox rules to prioritize emails from VIP clients.

codeVibe Coding

  1. Provide an efficient snippet to validate and sanitize user input in JavaScript.
  2. Explain how to refactor a monolithic function into testable parts with examples.
  3. Create Jest unit tests for a function that calculates taxes.

descriptionWord

  1. Rewrite this technical document to be executive-friendly while keeping key data and conclusions.
  2. Suggest styles and formatting (headings, subheadings, numbering) for a 10-page user manual.
  3. Draft a formal business letter with greeting, subject description and closing call to action.

slideshowPowerPoint

  1. Create a structure for a 7-slide presentation to present quarterly results with titles and bullets.
  2. Recommend a visual design and color palette (based on the logo) for a corporate deck.
  3. Convert this text into speaker notes per slide with key messages and anecdotes.

table_chartExcel

  1. Provide formulas to calculate metrics: monthly growth rate, weighted average, and a pivot table for sales.
  2. Create a VBA macro script to consolidate monthly sheets into an annual summary.
  3. Generate instructions to clean and prepare a dataset in Excel before importing into Power BI.

securityCybersecurity

  1. Generate a security checklist for deploying a new web application: auth, encryption, logging, WAF, backups.
  2. Draft a user notification after a minor security incident including actions and recommendations.
  3. Create a prompt to audit Azure/Office365 configurations for common misconfigurations and recommendations.