Microsoft 365 Copilot in Word, Excel, and PowerPoint: A Practical How-To Guide
Step-by-step workflows for using Microsoft 365 Copilot in Word, Excel, and PowerPoint — with the exact prompts that produce usable first drafts, accurate analysis, and compelling presentations.
TL;DR — The quick version
Word, Excel, and PowerPoint are where Microsoft 365 Copilot delivers the fastest, most visible productivity gains for most knowledge workers. But the difference between a useful output and a frustrating one comes down entirely to how you write your prompts. This guide shows you the exact workflows and prompts that work — by application, by use case.
The Most Important Thing to Understand Before You Start
Copilot in Office applications is not a magic button. The quality of what it produces is directly proportional to the quality of the context you give it. A vague prompt produces a generic, often useless output. A specific, well-constructed prompt with reference materials produces a first draft you can genuinely work with.
The universal prompt formula for any Office Copilot task is:
The universal Copilot prompt formula
"[Task] + [Document type] + [Audience] + [Reference: /filename or pasted context] + [Key points to cover] + [Tone/length]." The more of these elements you include, the better the output. "Write a report" produces nothing useful. "Draft a 2-page executive summary for our CFO based on /Q2 Operations Review.docx. Cover revenue performance, cost trends, and the top 3 risks. Tone: concise and data-focused." produces something you can edit into a final document.
Copilot in Word: Drafting, Rewriting, and Summarizing
Word is where Copilot delivers the most consistent time savings for most knowledge workers. The blank page is no longer a problem.
Here are the three highest-value Word workflows, with the exact prompts to use.
| Use Case | Exact Prompt to Use | What to Expect |
|---|---|---|
| Draft from notes or meeting | "Draft a [project proposal / business case / policy] for [audience] based on these notes: [paste notes]. Cover: [list key points]. Keep it under [X] pages. Tone: [professional / concise / persuasive]." | A structured first draft with appropriate headings. Expect to spend 20–40 minutes refining. |
| Rewrite for a different audience | "Rewrite this section for [non-technical executives / a legal audience / frontline staff]. Remove jargon. Keep the same core message. Maximum 150 words." | A reworked version targeting the new audience. Usually 90% usable. |
| Summarize a long document | "Summarize /[document name] in 5 bullet points. Focus on decisions made, actions required, and any open risks. For: [executive / project team]." | A concise summary. Verify specific facts against the source document. |
| Create a structured template | "Create a template for [document type] with the following sections: [list]. Include guidance notes under each heading explaining what to include." | A reusable template your team can populate. Significant time saver for recurring document types. |
Reference documents using the "/" key
In the Copilot prompt box in Word, type "/" to open a file picker and reference a specific document from your OneDrive or SharePoint. Copilot reads the referenced document and uses it as context. This is far more effective than pasting text into the prompt — you can reference entire documents, not just excerpts.
Copilot in Excel: Analyze Data Without Writing Formulas
Copilot in Excel democratizes data analysis. Users who previously needed to know XLOOKUP, SUMIFS, or pivot tables can now ask Copilot to do the analysis in plain English.
Before using Copilot in Excel, format your data as a Table (Home → Format as Table). Copilot works best with structured Table data, not plain ranges.
- 1Open your Excel file and ensure your data is formatted as a Table. Select your data range, then go to Home → Format as Table and choose a style.
- 2Click the Copilot button in the Home ribbon (or press Ctrl+Shift+Space in some builds) to open the Copilot panel.
- 3Ask for analysis in plain language. The key is to be specific about what you want to see, not just "analyze this data."
- 4Copilot will generate the analysis, create pivot tables, or add formulas directly to your spreadsheet. Review the output — Copilot sometimes applies formulas to the wrong range.
- 5Iterate: ask follow-up questions. "Now break that down by region." "Highlight any rows where the margin is below 15%." "Add a column that calculates year-on-year growth."
| What You Want | Exact Prompt to Use |
|---|---|
| Top performers by a metric | "Show me the top 10 [products / customers / reps] by [revenue / margin / units] last quarter. Add a column ranking them 1–10." |
| Trend over time | "Create a line chart showing [revenue / cost / volume] by month for the past 12 months. Add a trend line." |
| Conditional highlighting | "Highlight all rows where [margin] is below [15%] in red. Highlight rows above [30%] in green." |
| Comparison between groups | "Compare [Q1] and [Q2] performance by [product category]. Show the difference as both absolute and percentage." |
| Formula explanation | "Explain what the formula in column G is doing. Is there a simpler way to achieve the same result?" |
Always review Copilot-generated formulas
Copilot in Excel is very useful but occasionally generates formulas with errors — a wrong cell reference, an incorrect aggregate function, or a logic error in a conditional formula. Never accept a Copilot-generated formula without checking it. Click on the cell, read the formula, and verify it does what you expect on a small sample of rows before relying on it for a full dataset.
Copilot in PowerPoint: Turn Documents Into Presentations
The highest-value Copilot in PowerPoint workflow is generating a presentation from an existing Word document. This works remarkably well and eliminates the most painful part of deck-building: deciding the structure.
- 1Write the narrative in Word first. This is the key step most people skip. A presentation is only as good as its story. Use Copilot in Word to draft a structured narrative document with clear headings for each key message.
- 2Open a new PowerPoint file.
- 3Click the Copilot button in the Home ribbon and select "Create a presentation from file."
- 4Select your Word document from OneDrive or SharePoint.
- 5Copilot generates a slide deck — typically one slide per major heading in your Word document. It adds speaker notes derived from the document text.
- 6Review the slide structure. Add, remove, and reorder slides as needed. The content is usually good; the design will need visual polish.
- 7Use Copilot to refine: "Add a title slide with the key headline from the document." "Summarize the key takeaways on the last slide." "Add speaker notes to slide 5 covering the three main objections and how to address them."
The Word-to-PowerPoint workflow in practice
A consultant uses Copilot in Word to draft a 15-page client proposal in 45 minutes (versus a full day previously). She then uses Copilot in PowerPoint to generate a 14-slide executive summary deck from the proposal. Total time for both documents: 90 minutes. Previous time: 2 days. She spends the remaining time on client calls rather than formatting slides.
Building a Prompt Library Your Team Will Actually Use
The organizations extracting the most value from Microsoft 365 Copilot have one thing in common: a shared, maintained prompt library that their teams use daily.
A prompt library is simply a collection of tested, role-specific prompts stored somewhere everyone can access. Here is how to build one.
- 1Run a "prompt discovery" session with each team during your Copilot rollout. Ask: "What are the 10 tasks in Word, Excel, or PowerPoint that take you the most time each week?" For each task, have the team write and test a prompt together.
- 2Capture the prompts that produce the best results. Note: the task, the exact prompt text, what reference files are needed, and what to expect from the output.
- 3Store the library in a Teams channel wiki or a shared OneNote page. Organize by application (Word / Excel / PowerPoint) and by role (Finance / HR / Legal / Sales).
- 4Review and update monthly. Prompts that stop working (usually because Copilot has been updated) should be revised. New prompts discovered by team members should be added.
- 5Make it visible in every relevant Teams channel. Pin the prompt library to the top of each team's primary channel. If it is buried, it will not be used.
Starter prompts for four common roles
Finance: "Analyze /[Budget Review.xlsx] and identify the top 5 cost line items that exceeded budget by more than 10%. For each, add a note explaining the variance." | HR: "Draft an email to [employee name] confirming their leave request approved for [dates]. Tone: warm, professional. Include a reminder to update their Out of Office." | Legal: "Review /[Contract.docx] and flag any clauses that deviate from our standard template. List each deviation with the clause number, what it says, and why it is non-standard." | Project Manager: "Based on /[Meeting Notes.docx], create a project status update email for stakeholders. Cover: progress this week, risks identified, decisions needed, next week's milestones."
Key Terms
Copilot Prompt
The instruction you type into the Copilot panel to tell it what to do. The quality of the prompt directly determines the quality of the output — specific, context-rich prompts produce far better results than vague requests.
Excel Table
A structured Excel data range formatted as a Table (Home → Format as Table). Copilot in Excel works most reliably with Table-formatted data, not plain cell ranges.
File Reference ("/")
The ability to reference a specific OneDrive or SharePoint file in a Copilot prompt by typing "/" — Copilot reads the referenced file and uses its content as context for the task.
Speaker Notes
In PowerPoint, the notes attached to each slide visible to the presenter but not the audience. Copilot generates speaker notes automatically when creating presentations from Word documents.
