Every prompt below is a real, natural-language Microsoft 365 Copilot prompt you can paste and run. Each block notes which app to use it in — Copilot Chat, Excel, PowerPoint, Word, Outlook or Teams — and where a prompt reads your own files, emails or meetings you'll need a Microsoft 365 Copilot license so Copilot is grounded in your work data.
The best prompts follow Microsoft's GCSE framework: Goal (what you want), Context (why and who it's for), Source (which files or data), and Expectations (tone, length, format). Swap the [bracketed] placeholders for your specifics, and in Copilot Chat or Word type / to reference a file and @ to reference a person. For the reasoning behind the wording, read how to prompt Copilot for work, and keep the Copilot prompt cheat sheet open while you go.
Getting started & work basics
Start here. These five run in Copilot Chat (the work-grounded chat, not a specific document) and cover the daily jobs almost everyone has: catching up, summarizing, prepping and deciding. They lean on the GCSE structure so you can copy the shape into anything else.
1. Catch up on everything I missed today
Catch me up on everything from the last [24 hours]. Summarize the most important emails, Teams messages and meetings I was part of, grouped by [project or person]. Flag anything that needs a reply or a decision from me, list it as a short to-do with owners and dates, and keep the whole thing under [200 words].Why it works: it gives Copilot a clear time window, a grouping, and an explicit output shape, so the "what did I miss" answer stays scannable instead of a wall of text.
2. Summarize a set of files into a brief
Using /[file one] and /[file two], write a one-page brief for [audience, e.g. my manager] on [topic]. Pull out the key findings, the decisions still open, and the risks. Use short headings and bullet points, keep it neutral and factual, and end with three recommended next steps.Best for: merging several documents into a single readable summary — the / references tell Copilot exactly which sources to use.
3. Prep me for a meeting from an invite and files
I have a meeting about [topic] with @[person] on [date]. Using the calendar invite and any related files and recent emails, prepare me: summarize the background, list the likely agenda items, note where we last left things, and suggest [3] smart questions I should ask. Keep it to a tight bulleted list.Why it works: naming the person with @ and the topic lets Copilot pull the right thread of history rather than guessing.
4. Turn scattered notes into a clear action plan
Here are my rough notes from [project]: [paste notes]. Turn them into a structured action plan. Group the items into [themes], assign a suggested owner where I've named one, add a priority (high / medium / low), and format it as a table with columns for Task, Owner, Priority and Due. Point out anything that looks missing.Best for: converting messy brainstorm text into something you can act on and share.
5. Find what a person and I last agreed on
Look across my emails, chats and meetings with @[person] about [topic]. What did we most recently agree or decide, what is still open, and what am I waiting on from them? Give me a short timeline of the key exchanges with dates, then a two-line summary of where things stand today.Why it works: Copilot Chat can reason across email, chat and meetings at once, so a single scoped question saves a long manual search.
Excel
In Excel, format your data as a proper Excel Table (Insert → Table) first — Copilot works on structured rows and columns, not scattered cells — then click into the table before prompting. For a deeper set, see Copilot prompts for Excel.
6. Write and explain an Excel formula
Write a formula that returns [what you want, e.g. the total revenue for rows where Region is "West" and Status is "Closed"] using the columns [Region], [Status] and [Revenue] in this table. Show me the formula, explain in one plain sentence what each part does, and tell me which cell to put it in.Why it works: naming the columns and the exact result you want lets Copilot build a correct formula and explain it, so you learn the pattern.
7. Add a calculated formula column to a table
Add a new formula column to this table called [Margin %] that calculates [(Revenue - Cost) / Revenue] as a percentage for every row. Format it as a percentage with [one] decimal place, and make sure it fills down for the whole column.Best for: adding a computed column across every row without dragging a formula by hand.
8. Build a PivotTable to summarize the data
Create a PivotTable from this table that shows [total Revenue] by [Region] down the rows and by [Quarter] across the columns. Sort the regions from highest to lowest total, and add a grand total row and column.Why it works: a PivotTable request works best when you specify the value, the row field and the column field explicitly, exactly as you would set them by hand.
9. Surface insights, trends and outliers
Analyze this table and give me the four or five most useful insights. Highlight any trends over [time], the biggest [drivers of Revenue], and any outliers or values that look wrong. Explain each insight in one sentence in plain language, and suggest one chart that would show the most important pattern.Best for: a fast read on what the numbers are actually doing before you dig in.
10. Highlight and flag rows by a rule
In this table, highlight every row where [Days Overdue] is greater than [30] in red, and every row where [Status] is "At Risk" in amber. Then give me a short count of how many rows fall into each group so I know the size of the problem.Why it works: Copilot can apply conditional highlighting and report the counts in one pass, turning a review into a quick triage.
11. Run a step-by-step analysis with the Analyst agent
Using the Analyst agent, analyze this sales table. Work step by step: clean the data, calculate month-over-month growth by [product], identify which [products] are accelerating or declining, and build a simple forecast for the next [quarter]. Show your reasoning and the Python you ran, and summarize the takeaways for a non-technical reader.Best for: data-science-grade work — the Analyst agent reasons step by step and can write and run Python on your data. Advanced queries are metered, so save it for real analysis.
PowerPoint
Copilot in PowerPoint can build a deck from a prompt or an existing file, restructure slides, apply your org template through Designer, and write speaker notes. More in Copilot prompts for PowerPoint.
12. Create a presentation from a prompt
Create a [10]-slide presentation on [topic] for [audience]. Include a title slide, an agenda, [3-4] main sections with one key point per slide, a slide with [supporting data or examples], and a closing slide with clear next steps. Keep the text concise and bullet-led, and apply our organization template.Why it works: giving Copilot a slide count, an audience and a required structure produces a usable draft instead of a generic outline.
13. Build a deck from an existing Word document
Create a presentation from /[Word document name]. Turn each major heading into a section, summarize the content under each into [3] short bullets per slide, and pull any tables or key figures onto their own slides. Keep it to about [12] slides and use our brand template.Best for: converting a finished report or brief into a deck without rebuilding it slide by slide.
14. Restructure and tighten an existing deck
Review this presentation and restructure it so the story flows: [problem, then solution, then results, then ask]. Merge any slides that overlap, cut slides that don't support the main message, shorten wordy bullets, and tell me which slides you changed and why. Keep it under [15] slides.Why it works: giving Copilot the narrative order you want lets it reorganize toward a goal rather than just tidying formatting.
15. Generate speaker notes for every slide
Write speaker notes for every slide in this deck. For each slide, give me [2-3] sentences I can say out loud that expand on the bullets without just reading them, in a [confident, conversational] tone. Add a natural transition line at the end of each note that leads into the next slide.Best for: turning a finished deck into something you can actually present from.
16. Add a slide from referenced data
Add a new slide after slide [4] titled "[Results]" that summarizes the key numbers from /[Excel file] as [3-4] bullet points, with the single most important figure called out large. Match the style of the rest of the deck and suggest a simple chart for the data.Why it works: pointing at a source file with / and specifying the slide position keeps the addition precise.
Word
In Word, Copilot drafts from a prompt or from referenced files, rewrites and reshapes text, summarizes, and builds tables. Reference source files with /. See Copilot prompts for Word for the full set.
17. Draft a document from referenced files
Draft a [project proposal] for [audience] using /[brief] and /[background notes]. Include sections for Overview, Goals, Approach, Timeline and Budget. Write in a [clear, professional] tone, keep it to about [800] words, and leave a [BRACKETED] placeholder anywhere you need information I haven't provided.Why it works: the / references anchor the draft in real content, and asking for bracketed placeholders stops Copilot from inventing details.
18. Rewrite a passage in a different tone
Rewrite the selected paragraph to be [more concise and more formal] for [a senior executive audience]. Keep every fact and figure exactly as written, cut filler and repetition, and aim for about [half] the current length. Show me the rewrite so I can compare.Best for: fixing tone and length on a passage you've already written — select the text first, then prompt.
19. Summarize a long document
Summarize this document for [audience] who has [5] minutes. Give me a three-sentence overview at the top, then the key points as bullets grouped by section, then a short list of any decisions or actions it asks for. Keep it under [250] words and flag anything that looks unresolved.Why it works: defining the reader and a time budget forces a genuinely short, prioritized summary.
20. Insert and fill a table in a document
Insert a table into this document that compares [option A], [option B] and [option C] across the criteria [cost, effort, risk and timeline]. Fill each cell with a short, factual assessment based on the content above, and add a final row with your recommended option and a one-line reason.Best for: building a clean comparison or summary table inline instead of formatting one by hand.
21. Expand a bullet outline into full prose
Turn this bullet outline into full prose for a [report section] aimed at [audience]: [paste outline]. Write [2-3] tight paragraphs per bullet, keep the tone [professional and plain], preserve the order, and don't add any claims that aren't in the outline. Use a heading for each main bullet.Why it works: telling Copilot not to add claims keeps the expansion faithful to your outline.
Outlook & email
Copilot in Outlook summarizes long threads, drafts and rewrites replies at a chosen tone and length, coaches you on clarity, and helps triage the inbox. The full pack is at Copilot prompts for Outlook & email.
22. Summarize a long email thread
Summarize this email thread. Tell me what it's about, the key points each person raised, what's already been decided, and what's still open. End with a clear list of any actions and who owns them, and highlight anything that specifically needs a response from me.Why it works: asking for decisions, open items and owners turns a 30-message thread into a decision you can act on in seconds.
23. Draft a reply from a referenced email
Draft a reply to this email that [agrees to the request but pushes the deadline to [date]]. Keep it [warm but brief], acknowledge their main point, give a one-line reason for the change, and end with a clear next step. Match the level of formality of the original message.Best for: a fast, on-tone first draft you can tweak — Copilot uses the referenced email as context.
24. Adjust the tone and length of a draft
Take my draft reply and make it [more direct and about half the length], but keep it polite and keep every commitment I made. Remove hedging and repeated apologies, and make the ask in the last line unmistakable. Show me the revised version.Why it works: Copilot rewrites at a chosen tone and length, so naming both plus what to preserve gets a usable result in one shot.
25. Triage and prioritize the inbox
Go through my inbox from the last [3 days] and triage it. Group emails into "Needs a reply from me", "For my awareness", and "Can wait", ordered by urgency. For each in the first group, give a one-line summary and a suggested next action. Ignore newsletters and automated notifications.Best for: clearing a backed-up inbox by importance instead of top to bottom.
26. Get coaching on a sensitive email
Use Coaching by Copilot on my draft. This is going to [a client] about [a delay], so check the tone, clarity and how it might land emotionally. Point out anything that sounds defensive or unclear, and suggest specific rewrites. Don't send it — just give me feedback and options.Why it works: Coaching by Copilot reviews tone and clarity before you hit send, which is exactly what a delicate message needs.
Teams & meetings
Copilot generates a meeting recap from the transcript, so transcription or recording must be on. You can ask for a Speaker Summary, an Executive Summary, or a custom recap. More at Copilot prompts for Teams & meetings.
27. Recap a meeting I attended
Give me an executive summary of this meeting: the main topics, the key decisions, the action items with owners and due dates, and any open questions we didn't resolve. Keep it under [200 words] and put the decisions and actions in clearly labeled lists at the end.Why it works: asking for an Executive Summary with decisions and actions gives you a shareable recap, not a play-by-play transcript.
28. List action items with owners
List every action item from this meeting as a table with columns for Task, Owner and Due date. Only include things someone actually committed to, use the name of the person who owns each one, and mark any item where no owner or date was agreed so I can chase it down.Best for: pulling clean, assignable follow-ups out of a call so nothing is dropped.
29. Catch up on a meeting I missed
I missed this meeting. Tell me what I missed in [under 150 words]: what was discussed, what was decided, anything that affects [my project or my team], and whether my name or my area came up and in what context. Then list anything I now need to do.Why it works: Copilot answers "what did I miss" directly from the transcript and can flag where your work specifically came up.
30. Pull the decisions out of a meeting
List only the decisions made in this meeting — not the discussion. For each one, give the decision in a single sentence, who made or owns it, and any condition or deadline attached. If something was debated but left unresolved, put it under a separate "Still open" heading.Best for: a clean decision log you can paste into notes or a project tracker.
31. Draft a follow-up email from the recap
Draft a follow-up email to the attendees of this meeting. Open with a one-line thank you, then summarize the key decisions, then list the action items with owners and due dates as bullets, and close by asking people to flag anything I got wrong. Keep the tone [friendly and brief].Why it works: Copilot turns the recap it just generated straight into a ready-to-send follow-up, closing the loop after the call.
Copilot Chat & agents
These use Copilot's specialized agents and canvases: Researcher for deep cited research, Analyst for step-by-step data work, and Copilot Pages for co-editing. They're the heaviest prompts here, and advanced Researcher and Analyst queries are metered — roughly 25 combined per month on a Copilot license.
32. Run a deep research report with the Researcher agent
Using the Researcher agent, build me a briefing on [topic or question]. Pull from my relevant emails, files and past meetings as well as the web, compare what we already know internally with what's happening externally, and give me a structured report with sections, key findings, gaps, and cited sources for every claim.Why it works: the Researcher agent runs multi-step research across your work data and the web and returns citations, so it's built for questions a single chat answer can't cover.
33. Reason over data with the Analyst agent
Using the Analyst agent and /[data file], answer this question: [e.g. which customer segments are driving the drop in renewals?]. Work step by step, write and run whatever Python you need, show your reasoning and any charts, and finish with a plain-language conclusion and two recommended actions.Best for: real data questions where you want reasoning and running code, not just a summary — point the Analyst at a specific file with /.
34. Turn a Copilot answer into a shareable Page
Take this answer and turn it into a Copilot Page I can share with [my team]. Organize it with clear headings, tighten the wording, add a short intro and a "next steps" section at the end, and leave placeholders for anyone to add their own notes. Keep it clean enough to send as-is.Why it works: Copilot Pages is a shared canvas where you and Copilot co-edit, so moving a good chat answer onto a Page makes it collaborative and durable.
35. Run a cross-app workflow in one prompt
From /[Excel data] and the recap of [last week's meeting], do the following in order: pull out the top three findings, draft a [5]-slide summary deck outline, and write a short email to @[manager] highlighting the one result they most need to know. Show each output under its own heading so I can review before I use it.Best for: stitching data, a deck outline and an email together in one pass — a taste of the multi-step, agentic work Copilot's Agent Mode and Cowork handle end to end. When you're ready for more, browse the whole Copilot Prompts library.
Frequently Asked Questions
Do I need a Microsoft 365 Copilot license to run these prompts?
For prompts that read your own files, emails and meetings you need a Microsoft 365 Copilot license, which grounds Copilot in your work data. Copilot Chat has a free web-grounded tier that handles general drafting and research, but it cannot see your documents unless you have the paid license.
What is the GCSE prompt framework?
GCSE is Microsoft's official structure: Goal (what you want), Context (why and who it's for), Source (which files or data to use), and Expectations (tone, length and format). The more of the four you include, the better and more specific the output. There's a full walkthrough in how to prompt Copilot for work.
How do I point Copilot at a specific file or person?
In Copilot Chat and Word, type a forward slash / then start the filename to reference a document, and type @ then a name to reference a person. In Excel, click into the table or select the range or columns you want Copilot to work on before you prompt.
What is the difference between the Researcher and Analyst agents?
Researcher runs deep, multi-step research across your emails, files, meetings and chats plus the web, returning a cited report. Analyst does data-science-grade analysis, reasoning step by step and writing and running Python on your data. A Copilot license includes roughly 25 combined advanced queries per month.
Why does Copilot need my data as an Excel Table?
Copilot works on structured tabular data, not scattered cells. Selecting your range and choosing Insert → Table gives every column a header and a clear boundary, so Copilot can build formulas, PivotTables, charts and insights reliably instead of guessing at the shape of your data.
Can Copilot build a PowerPoint deck from a Word document?
Yes. In PowerPoint, open Copilot and ask it to create a presentation from a referenced Word file using the / reference. Copilot turns the headings into slides, applies your organization template through Designer, and can add speaker notes on request.
Do meeting prompts work if no one recorded the call?
No. Teams recap, action items and catch-up prompts all rely on the transcript, so transcription or recording must be turned on during the meeting. Without a transcript there is nothing for Copilot to summarize afterward.
Should I write one long prompt or several short ones?
Start with one complete GCSE prompt, then refine in follow-ups. Copilot keeps the context of the conversation, so you can say "make it shorter", "change the tone to formal", or "add a risks section" without repeating everything. Iterating usually beats one giant prompt — the Copilot prompt cheat sheet lists the modifiers worth reusing.