Skip to main content

• Overview
• Workflows
• Prompt Builder
• Governance
• Custom Tools

• Overview
• Workflows
• Prompt Builder
• Governance
• Custom Tools

Dark mode Microsoft 365 Copilot Excel · Word · PowerPoint

You have Copilot. Now build a system around it.

Most teams use M365 Copilot for one-off tasks and forget about it between them. This guide shows you how to build repeatable workflows in Excel, Word, and PowerPoint — plus the governance guardrails to deploy it safely.

Explore workflows → Governance checklist Copilot is live in XL Excel Formulas, data analysis, Agent Mode for multi-step workbook tasks Formulas Analysis Agent Mode Active W Word Drafting, rewriting, sensitivity label inheritance, Agent Mode (GA) Draft Rewrite Agent Mode Active PPT PowerPoint Create from file, bulk reformatting, speaker notes, Designer integration Create Speaker Notes Designer Active The Problem

Copilot as a habit vs. Copilot as a system

When Copilot is something you remember to try, you get inconsistent results and no compounding value. When it's embedded in a defined workflow, it multiplies your output every time.

Habit mode

What most teams do

• Write a prompt from scratch each time
• Use Copilot for whichever task comes to mind first
• No shared prompts across the team
• No governance — Copilot can see everything
• Results vary wildly, trust erodes

System mode

What you could do instead

• Saved, reusable prompts for each recurring task
• Defined entry points per app and workflow type
• Team prompt library stored in SharePoint
• Sensitivity labels and DLP policies in place first
• Predictable outputs the whole team relies on

Repeatable Workflows

Pick your app. Build the loop.

Each app has a different interaction model. Understanding where Copilot fits inside each one is the first step to replacing one-time asks with repeatable systems.

Excel Word PowerPoint Formula & Analysis

Explain & write complex formulas

Tell Copilot what you want to calculate. It writes the formula, explains each part, and flags edge cases — without you leaving the grid.

Data Shaping

Clean and reshape messy data

Paste in raw exports. Ask Copilot to remove blanks, normalise columns, split fields, or convert formats — described in plain English.

Insight Generation

Surface trends and anomalies

Highlight a range and ask Copilot to identify what's notable. Get a plain-language summary plus a suggested chart type to illustrate it.

Agent Mode

Multi-step workbook tasks

Agent Mode in Excel can plan and execute multi-step tasks — building models, reshaping tables, generating charts — while you watch and verify each step.

Excel — Formula & Analysis

Explain & write complex formulas

Close × 1 Open Copilot in Excel

Click the Copilot button in the Home ribbon. Make sure you have data in a named table — Copilot performs best when it can reference structured ranges.

2 Describe what you need

Don't write the formula — describe the output. Use this prompt template:

Write a formula that calculates [WHAT] for each row in column [COLUMN], using the values in [SOURCE COLUMNS]. Flag any rows where [EDGE CASE CONDITION]. Explain each part of the formula. 3 Review, then insert

Copilot shows the formula and its explanation before inserting. Read it. If the logic is wrong, tell it what to fix before committing. Click "Insert column" only when you're satisfied.

4 Save this prompt to your library

Copy the working prompt into your team's shared prompt library in SharePoint. Tag it with the workflow name and the table structure it works for.

Excel Copilot in Grid Formula Writing Excel — Data Shaping

Clean and reshape messy data

Close × 1 Load the raw data

Paste your export into a new sheet. Convert it to a Table (Ctrl+T) so Copilot has a clear reference for column names and structure.

2 Describe the transformation In the [TABLE NAME] table: remove rows where [COLUMN] is blank, split the [COLUMN] column into separate First Name and Last Name columns, and convert all dates in [DATE COLUMN] to YYYY-MM-DD format. Add a new column called "Status" with the value "Active" for all rows. 3 Verify before saving

Use Ctrl+Z to undo any changes that aren't right. Copilot works incrementally — you can correct one step without losing the others.

Excel Data Cleaning Table Operations Excel — Insight Generation

Surface trends and anomalies

Close × 1 Select your data range

Highlight the table or range you want analysed. The more structured the data, the more useful Copilot's analysis will be.

2 Ask for a narrative summary Analyse this data and tell me: what are the top 3 trends, are there any outliers or anomalies I should flag, and what chart type would best illustrate the key pattern? Keep it to 3 sentences max. 3 Generate the chart

Ask Copilot to insert a recommended chart. Then use the chart title and axis labels it suggests as the basis for your deck's slide copy.

Excel Analysis Charting Excel — Agent Mode

Multi-step workbook tasks

Close × 1 Enable Agent Mode

Agent Mode is available in Excel on Windows and Web for Microsoft 365 Copilot subscribers. Open Copilot and look for the Agent Mode toggle at the top of the panel.

2 Describe the full task Build a monthly budget model from the data in Sheet1. Create summary tables by category, add variance columns comparing to the prior month, generate a waterfall chart showing the top 5 cost drivers, and format the final sheet for printing. 3 Stay in control

Agent Mode shows you each step before executing it. Approve, modify, or stop at any point. Your data is never changed without your confirmation.

Excel Agent Mode Complex Models Document Creation

Draft from a brief or source file

Give Copilot a brief, a reference doc, or both. It generates a full structured first draft — sections, headings, and opening paragraphs — in your format.

Editing & Tone

Rewrite for audience or length

Select a passage and tell Copilot who's reading it. It adjusts register, cuts jargon, or expands thin sections — without losing the core argument.

Templates

Build reusable document templates

Define a standard structure for recurring document types — briefs, SOPs, status reports — and embed Copilot instructions directly in the template notes.

Agent Mode

Iterative long-document editing

Agent Mode in Word is generally available. It can make direct edits across a full document, apply formatting consistently, and restructure sections based on your instructions.

Word — Document Creation

Draft from a brief or source file

Close × 1 Start with Draft with Copilot

In a new document, click "Draft with Copilot" in the canvas. This gives Copilot access to the full document context from the start.

2 Reference a source file

Use the "/" reference syntax to point Copilot at an existing file. It pulls structure and content from the source while writing in the new document.

Draft a [DOCUMENT TYPE] based on /[SOURCE FILE]. Use the following sections: [SECTION 1], [SECTION 2], [SECTION 3]. Audience: [AUDIENCE]. Tone: [TONE]. Length: approximately [TARGET LENGTH]. 3 Sensitivity label inheritance

When Copilot drafts from a labelled source file, the new document inherits the source's sensitivity label. Verify the label shown at the top of the document before sharing.

Word Draft with Copilot Label Inheritance Word — Editing

Rewrite for audience or length

Close × 1 Select the passage

Highlight the paragraph or section. Click the Copilot icon that appears in the margin, or open the Copilot panel and reference the selection.

2 Give a specific rewrite instruction Rewrite this section for [AUDIENCE TYPE, e.g. "a non-technical executive audience"]. Keep the core argument. Cut jargon. Target [WORD COUNT]. End with a clear call to action. 3 Accept, discard, or iterate

Copilot shows the rewritten version alongside the original. Use "Regenerate" to get a different take before accepting. Track changes stays on so reviewers can see what changed.

Word Rewrite Tone Adjustment Word — Templates

Build reusable document templates

Close × 1 Define your document structure

Create a Word template (.dotx) with your standard sections. In each section's notes or placeholder text, embed the Copilot prompt that should generate that section's content.

2 Embed prompts as instructional text [COPILOT: Draft a 2-paragraph executive summary of the project described above. Audience: C-suite. Tone: direct and confident. Do not use bullet points.] 3 Store in SharePoint, not locally

Save templates to a shared SharePoint library with the correct sensitivity label. This ensures every team member uses the same version and Copilot can reference them via the "/" syntax.

Word Templates SharePoint Word — Agent Mode

Iterative long-document editing

Close × 1 Agent Mode is generally available

For Microsoft 365 Copilot subscribers, Agent Mode in Word requires no special activation. Open the Copilot panel and it will offer agentic capabilities automatically for complex tasks.

2 Describe the full editing task Review this entire document. Standardise all heading levels, replace informal language with formal equivalents, ensure the conclusion references points made in sections 2 and 4, and add a summary table after the introduction listing all recommendations. 3 Review each change

Agent Mode shows you a step-by-step plan before making changes. Approve the plan, then review each edit in track-changes mode before accepting.

Word Agent Mode Long Docs Deck Creation

Create a presentation from a document

Point Copilot at a Word document or brief. It builds a structured deck with one idea per slide, a suggested visual layout, and speaker note starters.

Slide Editing

Redesign and reformat slides in bulk

Tell Copilot to standardise your slide layouts, apply a consistent tone to all bullets, or restructure a section — across the whole deck at once.

Explain This

Decode complex slides on the fly

Select any text box, table, or acronym and ask Copilot to explain it. Useful for inherited decks or onboarding new team members to existing materials.

Speaker Notes

Generate and improve speaker notes

Ask Copilot to write speaker notes for every slide, calibrated to the audience and the time you have per slide. Edit the result before you present.

PowerPoint — Deck Creation

Create a presentation from a document

Close × 1 Start in a new presentation

Open PowerPoint and click "Create presentation from file" in the Copilot panel. Reference a Word document, PDF, or outline stored in SharePoint or OneDrive.

2 Define the deck's parameters Create a [NUMBER]-slide presentation based on /[SOURCE FILE]. Audience: [AUDIENCE]. Purpose: [PURPOSE, e.g. "board update", "client pitch", "team training"]. One key idea per slide. Include speaker notes of [LENGTH] per slide. 3 Check the inherited label

When creating from a labelled source, the presentation inherits that label. Check it before sharing — if the label is more restrictive than needed, you can adjust it, but not to a lower sensitivity than the source.

PowerPoint Create from File Label Inheritance PowerPoint — Slide Editing

Redesign and reformat slides in bulk

Close × 1 Open the Copilot panel

With your deck open, use the Copilot panel to issue instructions that apply to the whole deck. You don't need to select individual slides for bulk operations.

2 Issue a bulk editing instruction Across all slides: standardise all bullet points to no more than 8 words each, remove any slide with fewer than 2 content items, and ensure every slide has a clear action-oriented headline. Apply consistent capitalisation to all titles. 3 Use Designer for visual consistency

After Copilot edits content, use PowerPoint Designer to suggest layout improvements. These two tools work in sequence — content first, then visual treatment.

PowerPoint Bulk Editing Designer PowerPoint — Explain This

Decode complex slides on the fly

Close × 1 Select any element

The "Explain this" feature works on text boxes, tables, acronyms, or entire slides. Select the element, then open the Copilot panel. It provides contextual explanation without modifying the slide.

2 Ask follow-up questions Explain the acronym [ACRONYM] in the context of this slide. Then suggest a clearer alternative phrasing for the main point that a non-specialist audience would understand in under 10 seconds. PowerPoint Explain This Onboarding PowerPoint — Speaker Notes

Generate and improve speaker notes

Close × 1 Generate notes for all slides Write speaker notes for every slide in this deck. Audience: [AUDIENCE]. I have [TIME AVAILABLE] total. Each note should: summarise the slide's point in 1 sentence, provide 2–3 talking points, and flag any question the audience is likely to ask. 2 Edit, don't accept wholesale

Copilot's speaker notes are a starting point. Read each one aloud before the presentation. Remove any phrasing that doesn't sound like you — the goal is to sound prepared, not scripted.

PowerPoint Speaker Notes Presentation Prep Prompt Builder

Write it once. Use it every time.

Each app has a different prompt anatomy. Pick your app first — the fields below reconfigure to match what Copilot actually needs for that tool. Copy the output straight into Copilot, then save it to your team prompt library.

Excel Formulas · Analysis · Data shaping Word Drafting · Editing · Templates PowerPoint Decks · Speaker notes · Reformatting Select an app above to start building your prompt. Your prompt Your prompt will appear here as you fill in the fields. Built: 0 Copy to clipboard Generate prompt → Governance

Copilot sees what your permissions allow.

Copilot doesn't grant access to data users shouldn't have — but it will surface anything they already have permission to see. If your SharePoint is overshared, Copilot exposes that oversharing. Governance isn't a blocker to adoption; it's what makes adoption safe.

01

Sensitivity Labels

Labels in Microsoft Purview classify files and enforce protections like encryption and access restrictions. When Copilot drafts from a labelled file, the new document inherits the source label automatically.

Microsoft Purview 02

DLP for Copilot

Data Loss Prevention policies can prevent Copilot from processing files with specific sensitivity labels, or from responding to prompts containing sensitive information types like personal data or financial records.

DLP Policy 03

Oversharing Audit

Run a SharePoint Data Access Governance report before enabling Copilot broadly. Sites shared with "Everyone" or via "Anyone links" are Copilot's biggest risk surface. Fix permissions before you expand access.

SharePoint Admin 04

Restricted Content Discovery

Restricted Content Discoverability (RCD) prevents high-risk sites from appearing in Copilot responses and search results — without changing who has access to the sites themselves.

SharePoint SAM 05

Audit Logs

Every Copilot interaction is logged in Microsoft Purview audit. IT admins can see which files were referenced in responses, which labels were present, and which users triggered which interactions.

Purview Audit 06

Pilot First

Microsoft's own internal deployment started with a small supervised pilot before rolling out organisation-wide. Evaluate data access patterns and productivity impact in a controlled group first.

Adoption Strategy Pre-deployment governance checklist ✓ Run SharePoint Data Access Governance report — identify overshared sites and "Anyone" links ✓ Enable Microsoft Purview sensitivity labels for SharePoint and OneDrive files ✓ Define a sensitivity label taxonomy and publish labels to all users (minimum: General, Confidential, Highly Confidential) ✓ Configure DLP policies to block Copilot from processing files labelled Highly Confidential or above ✓ Apply Restricted Content Discoverability to any SharePoint sites flagged as high-risk ✓ Enable Purview audit logging and confirm Copilot interactions are captured in the AI activities log ✓ Communicate the labelling policy to all staff and establish a policy for unlabelled content ✓ Run a supervised pilot group before enabling Copilot for the full organisation 0 of 8 items complete Custom Tooling

Move from prompts to infrastructure

Once your team is running repeatable workflows, the next level is building shared infrastructure — prompt libraries, custom agents, and standardised templates — so Copilot works consistently across the team, not just for individuals who remember how to prompt it.

Team Prompt Library in SharePoint Shared, versioned, searchable — not in someone's chat history +

Create a SharePoint document library called "Copilot Prompts". Store prompts as .txt or .docx files with a consistent naming convention: [APP]-[TASK TYPE]-[USE CASE]. For example: Excel-Analysis-WeeklyRevenueReview.txt.

Tag each file with a custom metadata column: "App", "Task Type", "Last Validated" (date), and "Owner". Use SharePoint search to let the team find prompts by tag. Review and update prompts quarterly — stale prompts give worse results as Copilot evolves.

Library structure example: /Copilot-Prompts/ Excel/ Analysis/ ← Excel-Analysis-*.txt DataShaping/ ← Excel-DataShaping-*.txt Word/ Drafting/ Editing/ PowerPoint/ DeckCreation/ SpeakerNotes/ SharePoint Prompt Library Team System Copilot Pages for Persistent Outputs Save Copilot chat outputs into collaborative, living documents +

Copilot in M365 Chat lets you export any response to a Copilot Page — a collaborative Loop-based document stored in your M365 tenant. Use Pages to save useful outputs instead of copying from chat to email.

Set up Pages for recurring outputs: weekly team summaries, project status snapshots, competitive analysis notes. Each page can be updated by Copilot in subsequent sessions, building a persistent, versioned record of AI-assisted work.

After getting a useful Copilot response: 1. Click "Edit in Pages" on the response 2. Add context notes manually 3. Share via SharePoint link with appropriate label 4. Refer to the Page in future prompts using the "/" syntax Copilot Pages Loop Persistent Outputs Custom Copilot Agents via Copilot Studio Build task-specific agents grounded in your company data +

Copilot Studio lets you build declarative agents — Copilot instances tuned to a specific role, grounded in specific SharePoint libraries, with predefined instructions and behaviours. No code required for basic agents.

Example use cases: a "Finance Report Agent" grounded in your finance SharePoint library that always returns data in your standard reporting format; a "New Hire Onboarding Agent" that answers policy questions using only your HR documentation. Agents can be shared with the whole organisation through the M365 app catalogue.

To create a basic declarative agent: 1. Go to Copilot Studio (copilotstudio.microsoft.com) 2. New Agent → "From conversation" 3. Define: name, behaviour instructions, knowledge sources (SharePoint sites) 4. Test in preview 5. Publish to your M365 tenant 6. Assign appropriate sensitivity label access scopes Copilot Studio Custom Agents No-Code Word & PowerPoint Templates with Embedded Prompts Make Copilot instructions part of the template, not the person's memory +

The best prompt library is one that travels with the document. In Word templates (.dotx) and PowerPoint templates (.potx), embed Copilot instructions as placeholder text or document notes. When anyone opens the template, the right prompt is already there.

For PowerPoint, use the slide notes panel to embed generation instructions. For Word, use placeholder text inside content controls. Store all templates in a shared, labelled SharePoint library so Copilot can reference them via the "/" syntax from any app.

Example Word template placeholder: [COPILOT INSTRUCTION — DELETE BEFORE SENDING] Draft this section using Copilot: "Summarise the project status in 3 sentences. Include: what's complete, what's at risk, and the next milestone. Audience: project sponsor. Tone: concise and factual." Word Templates PowerPoint Templates SharePoint Measuring Impact — Building a Copilot ROI Log Justify the investment and improve what you measure +

Create a shared Excel workbook — the Copilot ROI Log — where team members record time saved per workflow each week. Use a simple table: Date, Task, Tool, Estimated minutes saved, Notes.

Review the log monthly. Identify the highest-value workflows and standardise them first. Use the data to make the case for broader rollout, additional licences, or custom agent investment. The log itself can be analysed by Copilot — ask it to summarise the top time-saving patterns each month.

Monthly Copilot ROI summary prompt (in Excel): "Analyse the data in this table. What are the top 3 workflows by total time saved? Which team members are using Copilot most and for what? Identify any workflows where time saved is unexpectedly low. Summarise in 5 bullet points." Excel ROI Tracking Adoption

Stop prompting. Start building.

Copilot is most valuable when it's invisible — when it's just how your team produces reports, reformats data, and prepares decks. That starts with one repeatable workflow. Pick one, save the prompt, share it with two colleagues, and iterate from there.

Go to Workflows → Governance Checklist Microsoft 365 Copilot — Built for teams already using M365 Built with Copilot in Word, Excel & PowerPoint