This is a scannable reference for prompting Microsoft 365 Copilot — the GCSE formula, the triggers that point it at your files and people, the agents worth knowing, and copy-paste modifier tables you can bolt onto any prompt. Keep it open in a tab while you work. Copilot is embedded in Word, Excel, PowerPoint, Outlook, Teams and Copilot Chat; work-data grounding needs a Microsoft 365 Copilot license.
If you want the deeper how-and-why behind these tables, read how to prompt Copilot for work or grab the ready-made best Copilot prompts roundup. For fill-in-the-blank skeletons, see the Copilot prompt templates.
The GCSE formula
Microsoft's official prompt structure is GCSE: Goal (what you want), Context (why, and who it's for), Source (which files or data to use), and Expectations (tone, length, format). A weak prompt states only the goal; a strong one supplies all four. The more complete the prompt, the better and more grounded the output.
Here is the same request written as a full GCSE prompt, labeled part by part:
Goal: Draft a one-page project update.
Context: It's for the leadership steering group who haven't followed the day-to-day; they care about risk and timeline, not detail.
Source: Base it on /Q3-Project-Plan.docx and the notes in /Weekly-Standup-Notes.docx.
Expectations: Professional but plain tone, under 400 words, with a short "Status", "Risks" and "Next steps" section, each as bullets.Why it works: naming the audience (Context) and the exact files (Source) is what turns a generic answer into one grounded in your real work.
Triggers & references
These are the symbols and verbs that steer Copilot. Type / to pull in a file and @ to pull in a person or agent; the plain verbs below tell Copilot what to do with what it already has.
| Trigger | What it does | Example |
|---|---|---|
/ + filename | Attaches and grounds the reply in a specific file (Word, Copilot Chat). | Summarize the key decisions in /Board-Notes.docx |
@ + name | References a person, so Copilot pulls relevant emails, chats and meetings, or invokes an agent. | Draft a reply to @Priya's last email about the launch date |
| Excel Table / range | Points Copilot at structured data in Excel; select the Table, range or columns before prompting. | Add a column to this table that flags rows where Margin is below 20% |
| Summarize | Condenses a thread, document, deck or meeting into key points. | Summarize this email thread and list who owns each action |
| Draft | Creates new content from a prompt or from referenced sources. | Draft a friendly reminder email based on /Invoice-3021.pdf |
| Rewrite | Rephrases existing text; pair with a tone or length modifier. | Rewrite the selected paragraph to be more concise and confident |
| Explain | Breaks down a formula, a decision or a passage in plain language. | Explain what the selected Excel formula does, step by step |
Agents & modes
Beyond a single reply, Copilot offers deeper modes and agents. Researcher and Analyst are the advanced ones — a Copilot license includes roughly 25 combined Researcher/Analyst advanced queries per month, so save them for work that needs the extra depth.
| Feature | Best for | How to invoke |
|---|---|---|
| Copilot Chat | Everyday questions, drafting and summaries grounded in your work data (or web-only on the free tier). | Open Copilot Chat and type your prompt; use / and @ to add sources. |
| Researcher | Deep, multi-step research across emails, files, meetings and the web, with citations. | Pick the Researcher agent in Copilot Chat, then ask your research question. |
| Analyst | Data-science-grade analysis; reasons step by step and can write and run Python on your data. | Pick the Analyst agent, attach your data, and describe the analysis you want. |
| Agent Mode (Word / Excel / PPT) | Turning one instruction into a multi-step workflow the agent executes and shows its work for. | Switch Copilot to Agent Mode in the app, then give a single high-level instruction. |
| Copilot Pages | Co-editing content with Copilot on a shareable canvas, with Suggested Edits. | Send a Chat reply to a Page, then edit together in the canvas. |
| Cowork | Long-running, multi-step agentic work that runs while you do other things. | Start a Cowork session and hand it a larger, multi-part task. |
Tone, format & length modifiers
Every modifier below is the Expectations part of GCSE. Add one or more to the end of any prompt to steer the output without rewriting the whole request.
| Modifier | Add to your prompt |
|---|---|
| Professional tone | ...in a professional, polished tone. |
| Friendly tone | ...in a warm, friendly tone. |
| Direct / concise tone | ...in a direct, no-fluff tone. |
| Bulleted list | ...as a bulleted list. |
| Table | ...in a table with columns for [X], [Y] and [Z]. |
| Email format | ...as a ready-to-send email with a subject line. |
| Short length | ...in under 150 words. |
| Expanded length | ...expanded to about three paragraphs. |
| Audience | ...written for a non-technical audience. |
| Reading level | ...at a plain-English, eighth-grade reading level. |
Quick prompts by app
One strong, copy-paste prompt for each core app. Swap the [bracketed] parts for your own specifics, and reference your real files with /.
| App | Copy-paste prompt |
|---|---|
| Word | Draft a [one-page project brief] based on /[Source-Doc.docx], in a professional tone, with headings for Background, Scope and Timeline. |
| Excel | Analyze this Excel Table and surface the top 3 trends, then add a PivotTable summarizing [Revenue] by [Region] and [Quarter]. |
| PowerPoint | Create a [10-slide] presentation from /[Report.docx], apply our org template, and add speaker notes for each slide. |
| Outlook | Summarize this email thread, list the open questions, then draft a reply that confirms [the meeting time] in a friendly, concise tone. |
| Teams | Generate an Executive Summary recap of this meeting with key decisions and action items, each with an owner. |
Three fuller example prompts that stack the pieces together:
Draft a customer follow-up email based on /Discovery-Call-Notes.docx and @Marcus's summary. Reference the two concerns they raised, propose next steps, and keep it under 200 words in a warm, professional tone with a clear subject line.Best for: Outlook — it names the source file, a person, the tone, the length and the format all at once.
Analyze this Excel Table of monthly sales. Add a formula column for month-over-month growth, then create a PivotTable of total Revenue by Region and a chart of the trend. Call out the single biggest outlier and explain it in one sentence.Best for: Excel — see more like it in 26 Copilot prompts for Excel. Remember the data must be a formatted Excel Table first.
Using Agent Mode, build a 12-slide investor update from /Q3-Results.docx and /Q3-Financials.xlsx. Apply our brand template, put the financial highlights on their own slide as a table, add speaker notes, and finish with a "Risks and asks" slide.Best for: PowerPoint in Agent Mode — one instruction becomes a multi-step deck the agent builds and shows its work for.
Frequently Asked Questions
What is the GCSE prompt formula for Copilot?
GCSE stands for Goal, Context, Source and Expectations. State what you want (Goal), why and who it's for (Context), which files or data to use (Source), and the tone, length and format you need (Expectations). The more of the four you supply, the better the output.
How do I reference a file or a person in a Copilot prompt?
Type a forward slash ( / ) then start typing a file name to attach a document, and type an at sign ( @ ) to reference a person or an agent. In Excel, point Copilot at a specific Excel Table, range or columns instead.
What is Agent Mode in Word, Excel and PowerPoint?
Agent Mode turns one instruction into a multi-step workflow that Copilot executes and shows its work for, rather than producing a single reply. It is available in Word, Excel and PowerPoint in 2026 and suits tasks with several dependent steps.
What is the difference between Researcher and Analyst?
Researcher runs deep, multi-step research across your emails, files, meetings and chats plus the web, returning cited answers. 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.
Which modifiers change tone and format?
Add phrases like in a professional tone, as a bulleted list, in a three-column table, in under 150 words or for a non-technical audience to the end of your prompt. These map to the Expectations part of GCSE and steer the output directly.
Do I need a Copilot license to use these prompts?
For work-data grounding — prompting over your own files, emails and meetings — you need a Microsoft 365 Copilot license. Copilot Chat has a free, web-grounded tier that answers general questions but cannot see your work content.
Why does Copilot need my data to be an Excel Table?
Copilot works on structured tabular data, not scattered cells. Formatting your range as an Excel Table (Insert then Table) gives it clear headers and boundaries, so formula columns, PivotTables, charts and insights come out accurate.