How to Prompt Microsoft Copilot for Work (2026)

The fastest way to get better answers from Microsoft 365 Copilot is to write better prompts — and there's an official formula for it. Microsoft calls it GCSE: Goal, Context, Source, Expectations. A prompt that names all four gives Copilot a clear job, the reason behind it, the exact data to draw from, and the shape of the answer you want. This guide teaches the pattern, then hands you 10 real prompts you can paste into Word, Excel, PowerPoint, Outlook, Teams and Copilot Chat today.

If you'd rather grab finished prompts first and learn the theory later, jump to the 35 best Copilot prompts or keep the one-page Copilot prompt cheat sheet open beside you. This page is the "why" behind those — read it once and you'll write your own.

The GCSE prompt formula

GCSE is four parts. You don't always need all four, but the more you include, the less Copilot has to guess.

• Goal — what you want Copilot to produce. The verb: draft, summarize, rewrite, compare, list, build.
• Context — why you need it and who it's for. The audience, the situation, the constraints.
• Source — which files, emails, meetings or data Copilot should use. This is what makes work-Copilot different from a generic chatbot.
• Expectations — the tone, length and format of the output. Bullet points, a table, three paragraphs, a formal tone.

Here's a weak prompt — a bare goal with nothing else:

Write an email about the project.

Copilot has to invent the project, the reader, the point and the tone. The result is generic. Now the same request as a full GCSE prompt:

Draft a status update email to the marketing team about the Q3 website relaunch. Context: we slipped the launch by one week and I need to reassure them the new date is firm. Base it on the timeline in /Website Relaunch Plan and the risks in /Launch Risk Log. Keep it under 150 words, confident and calm in tone, with the new launch date bolded and a short bulleted list of what changes for them.

Why it works: Goal (draft a status update email), Context (the slip, the reassurance), Source (two named files), Expectations (under 150 words, tone, bolded date, bullets) are all present, so Copilot delivers something you can send with minor edits.

Point Copilot at the right source

Of the four parts, Source is the one that most separates a good answer from a wasted query — and it's the part people skip most. In Copilot Chat and Word, type / then start typing a file name and pick it from the list; Copilot then reads that document as grounding. To bring a person's work into the picture, type @ and their name — useful for "summarize my last three threads with @Priya Nair."

In Excel, there's no / picker; instead you point Copilot at a specific Excel Table, range or set of columns, so it analyzes structured tabular data rather than scattered cells. Get your data into a real table first (Insert → Table) — more on that in our Copilot prompts for Excel guide.

This is the whole point of a Microsoft 365 Copilot license: it grounds answers in your work data — mail, files, meetings and chats you already have access to. Without a source, Copilot writes from general knowledge and your prompt burns effort on a plausible-but-generic reply. Name the file, and the same prompt returns something specific to your work.

10 copy-paste example prompts

Each prompt below is a working GCSE example across a different app. Swap the [bracketed] parts for your own specifics and paste it into the Copilot pane for that app.

1. Draft a document from your own files (Word)

Draft a one-page project brief for [Project Name] aimed at senior stakeholders who haven't been involved yet. Use the notes in /[Kickoff Notes] and the scope in /[Statement of Work]. Structure it with these headings: Background, Objectives, Scope, Timeline, Risks. Keep it concise and neutral in tone, no more than 400 words.

Why it works: the / references give Word two real sources, and the heading list is a precise Expectation.

2. Rewrite text for a specific audience (Word)

Rewrite the selected section so a non-technical customer can follow it. Remove jargon, keep every factual claim, and use short sentences. Target a friendly but professional tone and cut the length by about a third.

Best for: turning internal wording into something client-ready without losing meaning.

3. Explain and build a formula (Excel)

Add a formula column to this Excel Table called "Margin %" that divides (Revenue minus Cost) by Revenue and shows it as a percentage. Explain the formula in one sentence and flag any rows where Margin % is below 20%.

Why it works: it names the table as the Source and asks for both the column and a plain-English explanation. See more in Copilot prompts for Excel.

4. Find insights in a table (Excel)

Analyze this sales table and give me the three biggest trends and any outliers. Break results out by [Region] and by [Month], summarize what's driving the top-performing segment, and present it as a short bulleted list I can paste into a slide.

Best for: a quick read on structured data before you build a PivotTable or chart.

5. Build a deck from an existing document (PowerPoint)

Create a 10-slide presentation from /[Quarterly Report] for a leadership review. Lead with a summary slide, then one slide per key result, and finish with next steps. Apply our org template, keep each slide to three bullets max, and add speaker notes for every slide.

Why it works: PowerPoint can build a deck straight from a referenced Word doc, and the slide count, template and notes are clear Expectations.

6. Restructure and summarize a deck (PowerPoint)

Summarize this presentation in five bullet points for someone who missed the meeting, then suggest how to reorder the slides so the recommendation comes before the supporting data.

Best for: tightening a deck someone else drafted.

7. Triage a long email thread (Outlook)

Summarize this email thread. List the open questions, any decisions already made, and what's being asked of me specifically, with who's waiting on what. Keep it to a short bulleted list.

Why it works: one clear Goal on a well-defined Source (the current thread) with a tight format.

8. Draft a reply with a set tone (Outlook)

Draft a reply to this email declining the request but keeping the relationship warm. Reference the budget constraints in /[FY26 Budget] without quoting figures, offer to revisit next quarter, and keep it under 120 words in a polite, professional tone.

Best for: a hard message you want to get right the first time. Try Coaching by Copilot to check the tone before you send.

9. Recap a meeting you missed (Teams)

Give me an Executive Summary recap of this meeting: the key takeaways, all decisions made, and every action item with its owner and due date. Then tell me specifically what, if anything, was assigned to me.

Why it works: Copilot builds the recap from the meeting transcript, so it needs recording or transcription to have been on.

10. Ask across all your work data (Copilot Chat)

Catch me up on the [Project Falcon] account before my 3pm call. Pull from my recent emails and Teams chats with @[Account Lead], the latest /[Falcon Status Deck], and any meeting notes from the past two weeks. Give me the current status, open risks, and the top three things the client cares about, as a short briefing.

Why it works: Copilot Chat grounds across mail, chats, files and meetings at once — the @ and / references keep it focused on the right people and documents.

When to hand off to Researcher, Analyst or Agent Mode

Some jobs are bigger than one prompt. Copilot has three heavier tools for those — but two of them draw on a limited budget, so use them deliberately. A Copilot license includes up to roughly 25 combined Researcher and Analyst advanced queries per month, so save those two for questions a normal prompt genuinely can't answer.

Researcher is for deep, multi-step research that reaches across your work data and the web, with citations:

Research how our top three competitors have positioned [Product Category] over the last year. Pull from my emails and files where relevant, add current public information, and give me a cited summary of their messaging, pricing signals and any gaps we could target.

Best for: a briefing that would take you an afternoon of digging across sources.

Analyst is for data-science-grade work — it reasons step by step and can write and run Python on your data:

Using the attached sales data, forecast next quarter's revenue by region, show your method, and flag which regions carry the most uncertainty. Explain the reasoning in plain language and include a chart.

Best for: forecasting, correlation and modeling that goes past a PivotTable.

Agent Mode in Word, Excel and PowerPoint turns a single instruction into a multi-step workflow it executes and shows its work for — no separate query budget:

Agent Mode: build a complete first draft of the [Client Proposal] in Word from /[Discovery Notes] and /[Pricing Sheet]. Create the section structure, write each section, insert a pricing table, and leave clearly marked placeholders wherever information is missing.

Best for: building a whole document, model or deck from a brief rather than editing one part at a time.

5 mistakes that waste Copilot queries

• A vague goal. "Help me with this report" gives Copilot nothing to aim at. Lead with a verb and a concrete outcome — draft, summarize, compare, rewrite.
• No source. Skipping the / file or @ person is the most common miss. Without it, Copilot answers from general knowledge instead of your work, and the reply feels generic.
• Expecting a perfect one-shot. Copilot is a conversation. Get a rough draft, then refine it — "make it shorter," "more formal," "add a risks section" — instead of cramming everything into one prompt.
• Wrong app for the job. Asking Word to crunch numbers or Excel to write prose fights the tool. Build decks in PowerPoint, analyze tables in Excel, draft in Word, and ask cross-data questions in Copilot Chat.
• Asking for data Copilot can't see. Copilot can only ground in files and mail you have access to and that actually exist in your tenant. If you never uploaded or shared it, Copilot can't read it — attach or reference the source first.

Fix those five and most "Copilot isn't helpful" complaints disappear. For ready-made starters that already follow GCSE, browse the best Copilot prompts or the cheat sheet.