Prompt Vault

Prompts that teach you the mechanic

Not "100 magic prompts" listicle garbage. Every entry here exploits a specific behavior of M365 Copilot — and the why line tells you what that behavior is, so you can build your own variants.

Copilot Chat The Monday catch-up
Summarize everything that happened while I was out since last Thursday: emails that need a reply from me specifically, decisions made in my Teams chats, and documents shared with me. Group by urgency, not by source. For each item, tell me the one action you'd recommend.
Why it works: Forces Copilot to fuse mail + Teams + files into one ranked view instead of three separate summaries. "From me specifically" filters CC noise.
Copilot Chat Pre-meeting ambush prep
I'm meeting with /[person] in 30 minutes. Pull together: our last 3 email threads, any open commitments either of us made (search Teams and email), and the latest version of any file we've both edited. End with 3 questions they're likely to ask me.
Why it works: The /person reference grounds on the people graph. Asking for "commitments either of us made" surfaces promises buried in threads — the thing you actually forget.
Copilot Chat The receipts finder
Find where we decided [decision topic]. Search my emails, Teams messages, and meeting transcripts from the last 90 days. Quote the exact message or transcript line, who said it, and the date. If you find conflicting decisions, show me both.
Why it works: Copilot cites sources when you demand quotes. "Show conflicting decisions" exploits its retrieval breadth — humans stop at the first hit.
Copilot Chat Weekly status report on autopilot
Draft my weekly status update for my manager. Source it from: meetings I attended this week, emails I sent, and files I edited. Format: 3 wins, 2 risks, 1 ask. Write it in first person, confident but factual, max 150 words. Don't invent anything — if a section is thin, say so.
Why it works: "Don't invent anything" is load-bearing: without it Copilot pads thin weeks with fluff. The fixed format makes output instantly usable.
Word Draft from your own sources
Draft a 2-page project proposal for [project]. Use /[requirements doc] for scope and /[budget spreadsheet] for the numbers. Match the tone and structure of /[a past proposal that won]. Flag any place where the source documents disagree with each other.
Why it works: Referencing up to 3 files with / is Word Copilot's killer feature — and the disagreement flag turns it into a consistency checker, which no template mentions.
Word The brutal editor
Rewrite this section at half the length without losing any commitments, numbers, or named people. Then list what you removed in bullet form so I can veto any cut.
Why it works: "List what you removed" is the safety net that makes aggressive cutting safe — you review the cuts, not the whole rewrite.
Word Tone transplant
Rewrite this document for a board audience: remove implementation detail, lead with financial impact, keep every number, convert any jargon to plain English, and keep it under one page. Preserve all headings as navigation anchors.
Why it works: Stacked constraints work better than "make it executive-friendly." Each clause is a testable instruction Copilot can actually follow.
Excel The column explainer
Add a column that flags any row where [metric] is more than 2 standard deviations from the mean of its [category] group. Explain the formula you used in plain English before applying it.
Why it works: Excel Copilot is far more reliable when it proposes formulas than when it summarizes data. "Explain before applying" lets you catch wrong logic before it touches cells.
Excel Make my data Copilot-readable
Convert this range to a formatted table, give every column a descriptive header, and tell me which columns have mixed data types or blanks that will cause problems for analysis.
Why it works: 80% of "Excel Copilot is dumb" complaints are actually unformatted-data problems. This prompt makes Copilot fix its own biggest blocker.
Excel Insight interrogation
Using advanced analysis, find the 3 strongest drivers of [outcome column] in this table. Show your Python, state your confidence in each finding, and tell me what additional column would most improve the analysis.
Why it works: "Advanced analysis" routes to the Python/code-interpreter path — dramatically better than the default. Asking what data is missing turns it into an analyst, not a chart generator.
PowerPoint Deck from a real document
Create a presentation from /[Word doc]. Max 8 slides, one idea per slide, speaker notes containing the supporting detail you cut from the slide. Use our template's layouts only — no AI-generated images.
Why it works: Doc-to-deck is PowerPoint Copilot's strongest path. Pushing detail into speaker notes instead of slide body is the difference between a deck and a teleprompter.
PowerPoint The slide surgeon
This slide has too much text. Split it into 2 slides with a clear narrative break, convert the bullets into a comparison layout if the content supports it, and rewrite each bullet to max 8 words.
Why it works: Specific surgical instructions beat "make this better." The 8-word cap forces real editing instead of cosmetic shuffling.
Outlook Thread triage
Summarize this thread. Then list: 1) what's being asked of me specifically, 2) deadlines mentioned anywhere in the thread, 3) the position of each participant in one line each. Draft a reply that addresses only #1.
Why it works: Long-thread summarization is Outlook Copilot's best skill. Splitting asks/deadlines/positions catches things a generic summary buries.
Outlook The diplomatic no
Draft a reply declining this request. Tone: warm but unambiguous. Offer one concrete alternative (suggest [alternative]). Don't apologize more than once, and don't leave a door open you don't intend to walk through.
Why it works: Email Copilot defaults to over-apologetic mush. Tone constraints with negative instructions ("don't leave a door open") fix its biggest writing weakness.
Teams Mid-meeting save
What has been decided so far in this meeting, and what questions were raised but not answered? List who owns each open item based on what was said.
Why it works: Works live during the meeting — the single best Copilot moment in all of M365. Asking for unanswered questions is how you rescue a drifting meeting.
Teams The meeting you skipped
For the [meeting name] I missed: what was decided, what was assigned to me or my team, what was said about [topic I care about], and was there any disagreement? Quote the transcript for anything assigned to me.
Why it works: Recap + targeted topic search + disagreement detection — this is why people say Copilot gave them their meeting hours back. Demand quotes for your action items.
Teams Channel archaeology
Search this channel for everything posted about [project] in the last month. Build a timeline of status changes, and flag the messages where the stated deadline or scope changed.
Why it works: Channels are where scope-creep hides. Copilot reading 4 weeks of posts in 10 seconds is cheaper than the meeting you'd otherwise schedule.
Agents Instruction-writing meta-prompt
You are helping me write instructions for a declarative Copilot agent. Its job: [job]. Its knowledge: [SharePoint site / files]. Draft instructions that include: persona, step-by-step response procedure, 3 concrete examples of good answers, what to do when the answer isn't in the knowledge source, and topics it must refuse. Keep under 8,000 characters.
Why it works: The 8,000-char instruction field is the whole game in declarative agents. Most agents fail because instructions describe a vibe instead of a procedure.
Agents Agent red-team pass
Here are my agent's instructions: [paste]. Act as a hostile tester. Give me 10 user messages likely to make this agent fail, hallucinate, or leak content it shouldn't — then rewrite the instructions to survive all 10.
Why it works: Nobody tests agents before shipping them to the org. This is a 5-minute red-team that catches the failure modes your pilot users will find in week one.
Word Reference-checked rewrite
Rewrite the executive summary so every claim is supported by something in the body of the document. List any claim you couldn't support — those are either cuts or things I need to add evidence for.
Why it works: Turns Copilot into an internal fact-checker. The unsupported-claims list is often more valuable than the rewrite itself.
Excel The handoff-proof workbook
Document this workbook for a colleague taking it over: what each sheet does, which cells contain manual inputs vs formulas, the data flow between sheets, and anything fragile that breaks if rows are added.
Why it works: Workbook archaeology is misery work humans avoid. Copilot does a credible first pass in seconds — and the 'fragile' list catches future breakage.
Copilot Chat The org-knowledge interview
I'm new to [team/project]. Based on files, Teams channels, and meetings I have access to: who are the key people and what does each own? What decisions were made before I arrived that I should know? What's currently blocked and why?
Why it works: Onboarding via semantic index. New hires using this get to useful-in-week-one instead of useful-in-month-two — the single highest-ROI Copilot use case.
Outlook Inbox-zero by exception
Go through today's unread email. Tell me only the ones that: need a decision from me, contain a deadline, or come from my management chain. Everything else, give me a single combined one-paragraph digest.
Why it works: Inverts the summary model: detail only by exception. This is the prompt that makes daily Copilot use stick for executives.
PowerPoint Narrative skeleton first
Before creating slides: propose 3 different narrative structures for presenting [topic] to [audience], each as a 6-line story arc. I'll pick one, then you build the deck from it.
Why it works: Deck quality is decided by structure, not slides. Making Copilot propose arcs first prevents the wall-of-bullets deck it builds by default.
Agents Knowledge-source audit
List every document in /[SharePoint site] that is older than 18 months, contradicts a newer document, or has 'draft' in the name or title. This is the cleanup list before I point an agent at this site.
Why it works: Agents grounded on dirty SharePoint give confidently wrong answers. The #1 cause of failed agent pilots is skipping this audit.
Teams Action-item enforcement
Compare the action items from last week's [meeting] recap against what was actually posted or completed in this channel since. List each item as: done, in progress with evidence, or silent. Draft a gentle nudge for the silent ones.
Why it works: Closes the loop nobody closes. Cross-referencing recap commitments against channel activity is something only Copilot has the patience to do weekly.
Copilot Chat The devil's advocate
Here's a decision we're about to make: [decision]. Search our files and threads for evidence that contradicts it — past attempts, failed pilots, dissenting opinions in Teams, data that points the other way. Steelman the case against.
Why it works: Organizational memory is Copilot's superpower and nobody uses it for dissent. This prompt has killed more than one bad project in week zero.
Excel Scenario stress-test
Using advanced analysis on this table: model what happens to [output metric] if [input] drops 10%, 25%, and 40%. Present as a small table with the assumption stated above it, and tell me which assumption in my data the result is most sensitive to.
Why it works: Sensitivity analysis in plain English. The "most sensitive assumption" answer is what your CFO actually wants to know.
Cowork Morning takeover
Catch me up on everything since yesterday 5pm, then organize my inbox: file newsletters and automated notifications away, flag anything needing a decision from me, and draft replies for the two most urgent threads — but show me each draft for approval before anything is sent or moved.
Why it works: Chains a read-only catch-up into real inbox actions in one task. The explicit approval clause is the training wheels — Cowork's approval gates mean you can delegate boldly and still veto every send.
Cowork Event planner, end to end
Plan our [team offsite / customer workshop] on [date] for [n] people: find a slot that works for the attendee list, draft the invite, create an agenda document and a logistics checklist in the output folder, and schedule a prep meeting with [co-organizer] two weeks before. Pause and ask me before sending any invites or booking anything.
Why it works: A genuine multi-step agentic task — scheduling, documents, invites — with one human checkpoint placed exactly where actions become irreversible. Watch the Progress panel and click Show parameters at each approval: that's where you learn what it's really about to do.
Cowork Build me a skill
Create a skill for my weekly status report. Interview me about: where the source material lives, the exact format my manager expects, my hard rules (never invent items, max 150 words, always show me the draft before sending), and what a thin week should look like. Then write the SKILL.md with a description that triggers whenever I ask for my 'Friday update'.
Why it works: Cowork can author its own skills from natural language. Making it interview you first extracts the procedure from your head — and dictating the trigger phrase up front is what makes the skill actually load next Friday.
Researcher Competitive brief, pre-scoped
Research [competitor] as a threat to our [product line]. Sections: their offering and pricing, recent moves (last 12 months), where they win against us per our internal win/loss notes, where we win, and a one-paragraph recommended response. Sources: web for their public moves, our files and meeting transcripts for the win/loss view. Cite every claim. When you ask clarifying questions, I'll give you our current hypothesis to test against.
Why it works: Pre-scoping sections and sources turns a vague topic into a deliverable spec. The last line is the real trick: Researcher quality is decided at the clarifying-questions step, so plan to answer with substance, not 'whatever you think'.
Researcher What do WE already know?
Before we commission outside research on [topic]: build a report of everything our org already knows about it. Search files, meeting transcripts, emails, and Teams across everything I can access. Sections: prior work and pilots, who the internal experts are, conclusions reached and by whom, open questions, and contradictions between sources. Quote and link every source.
Why it works: Researcher across work content is organizational memory at scale — most companies re-buy knowledge they already own. The contradictions section is the gold: it surfaces where two teams quietly disagree.
Researcher Decision memo with a steelman
Prepare a decision memo on [decision]. Structure: context, the case for, the strongest possible case against (steelman it — find real internal evidence: failed past attempts, dissenting voices in meetings or threads, data pointing the other way), risks of each path, and a recommendation with stated confidence. Web sources for market facts, work content for our history. Every claim cited.
Why it works: Forcing a steelman section makes Researcher hunt for disconfirming evidence instead of assembling a justification. A memo that survives its own counter-case is one you can actually take to leadership.
Analyst The anomaly hunt
Analyze this file for anomalies: outliers, impossible values, duplicates, sudden trend breaks, and any column where the distribution changed partway through. Show me the Python for every check, tell me which rows you excluded and why, and rank the anomalies by how much they'd change a topline summary of this data.
Why it works: Analyst's chain-of-thought Python is the trust model — demand to see it, especially the row-exclusion choices where wrong conclusions are born. Ranking by topline impact separates curiosities from landmines.
Analyst Driver analysis with honesty built in
Using this dataset, identify the strongest drivers of [outcome] and compare cohorts by [dimension, e.g. signup quarter]. For each finding: show the Python, state your confidence as high/medium/low with the reason, flag any data-quality issue that could invalidate it, and tell me the one additional column that would most improve the analysis.
Why it works: The stated-confidence requirement stops Analyst presenting weak correlations and solid findings in the same confident prose. The missing-column question turns it from a chart generator into an analyst telling you what to measure next.