How to Use Microsoft Copilot in Excel, Word, and PowerPoint
You already have the license. Your admin already flipped the switch. Now open Word, stare at the Copilot icon in the ribbon, and realize you have no idea what to type. That's the gap this guide fills: real prompts, per app, that produce actual output you can use today.
Prerequisites
Before opening any app, confirm these are in place. Missing any one of them is why most "Copilot not showing up" tickets exist.
-
RequiredMicrosoft 365 subscription (Business or Enterprise)M365 Business Basic, Standard, Premium, E3, E5, F1, F3, or Apps for Business/Enterprise. Check your plan
-
RequiredMicrosoft 365 Copilot license$30/user/month (Enterprise) or $18-21/user/month (Business, up to 300 users; promotional pricing through June 30, 2026). Assigned by your admin in the M365 Admin Center. Without it, you get Copilot Chat (with limited in-app capabilities), not the full Work IQ experience. Compare plans
-
RequiredMicrosoft Entra work or school accountSign in with your org account (user@yourorg.com), not a personal Microsoft account. Copilot accesses your Microsoft Graph data through this identity.
-
RequiredConnected experiences enabledConnected experiences are the cloud-powered features in Microsoft 365 that analyze your content to provide AI suggestions, design recommendations, and other smart capabilities. If your IT admin has disabled "connected experiences that analyze your content" in Microsoft 365 privacy controls, Copilot features are completely hidden in Word, Excel, PowerPoint, and Outlook. Ask your admin to verify in the M365 Apps admin center.
-
Excel RequiredFiles saved to OneDrive or SharePointFor Excel specifically, Copilot does not work on local files. Auto-Save must be on. This catches more people than any other prerequisite.
-
RequiredCurrent Microsoft 365 apps (Current Channel)Copilot features require the latest version of desktop apps on the Current Channel (Microsoft's fastest update track, which delivers new features monthly). If your organization uses the Semi-Annual Enterprise Channel (updates every six months), Copilot features may not be available yet. Run File > Account > Update Options > Update Now in any Office app.
Quick check: Open Word, look for the Copilot icon in the Home tab ribbon. If it's there, you're set. If it's missing, work through the list above with your IT admin.
What You Get Without the Paid License
Microsoft 365 Copilot Chat is included free with any eligible M365 subscription. It now appears directly inside Word, Excel, PowerPoint, and OneNote across desktop, web, and Mac -- not just as a standalone web chat. Free-tier users get open-document grounding (Copilot can reference the file you currently have open plus public web data) and standard access to Agent Mode, which lets Copilot orchestrate multi-step edits to your document while showing its reasoning. What free-tier Copilot Chat cannot do is pull context from your emails, Teams chats, or SharePoint files. The paid license unlocks Work IQ: Copilot grounded in your entire Microsoft Graph, with priority access to Agent Mode and full cross-app data integration.
Step 1: Confirm Your License and Access
Open m365copilot.com and sign in with your work account. If you see both Work and Web toggle options in Copilot Chat, your full license is active. If you only see web-grounded chat, your admin hasn't assigned the Copilot license to your account yet.
In any Microsoft 365 desktop app, click the Copilot button in the ribbon. If it opens a side panel, you're ready. If the button is grayed out or missing entirely, check:
- Account: File > Account. Confirm you're signed in with your Entra work account, not a personal account.
- Updates: File > Account > Update Options. Run any pending updates.
- License: Ask your admin to verify your Copilot license assignment at admin.microsoft.com.
Verification: The Copilot icon appears in the Home tab ribbon of Word, Excel, and PowerPoint. Clicking it opens a side panel with a prompt field.
Common failure: Copilot icon is visible but grayed out in Excel. Your file is saved locally. Move it to OneDrive or SharePoint and enable Auto-Save. This is the single most common blocker for Excel users.
Step 2: Use Copilot in Excel
Microsoft Copilot for Excel is where most people either get hooked or get frustrated. The difference is prompt specificity. Copilot acts as an in-app data analyst: it reads your workbook through Microsoft Graph -- Microsoft's unified API layer that connects your files, emails, calendar, chats, and organizational data across all M365 apps -- suggests formulas, generates charts, and highlights patterns. But it needs structured data to work with -- formatted as a table (Ctrl+T), not raw ranges scattered across tabs.
Generate Formulas from Plain English
Instead of looking up XLOOKUP syntax, describe what you need:
Copilot creates the formula, inserts it, and applies it down the column. Review the formula it generates before accepting -- it sometimes misidentifies the correct column reference in wide datasets.
Analyze Data and Surface Trends
Copilot scans your data, highlights the results in the side panel, and offers to create a chart. The analysis runs against whatever table your cursor is in, so position yourself in the right table before prompting.
Create Charts and PivotTables
Copilot generates the PivotTable on a new sheet. You can refine it with follow-up prompts like "Add a filter for deals over $10,000" or "Sort by total revenue descending."
Excel Limitations to Know
Copilot in Excel requires your data to be in a formatted Excel table (not a plain range). It struggles with complex multi-sheet models that have circular references. It does not support Power Query M-code generation (Power Query is Excel's ETL tool for importing, transforming, and cleaning data from external sources -- if your workflow relies on it, Copilot cannot help there yet). Performance degrades noticeably on tables exceeding roughly 10,000 rows: formula generation becomes less reliable, analysis turns superficial, and timeouts increase. And it does not work on files saved locally -- cloud storage with Auto-Save is mandatory. For heavy financial modeling with multi-tab dependencies, know that Copilot's reasoning depth has real limits; verify any cross-sheet formula logic manually.
Verification: Ask Copilot "Summarize this dataset." If it returns column names, row counts, and basic statistics, Excel integration is working correctly.
Step 3: Use Copilot in Word
Using Microsoft Copilot in Word means two interaction modes: the side panel (chat with your document) and inline drafting (generate or rewrite text directly in the document body). The side panel is for questions and summaries. Inline drafting is for content creation.
Draft a Document from a Prompt
Click the Copilot icon that appears at the top of a blank document (or type / to trigger inline drafting):
Copilot generates a structured draft with headings, placeholder content, and formatting. It pulls context from your Microsoft Graph data -- if you've emailed about this project or have related SharePoint docs, it may reference that information. One caveat: when Copilot in Word drafts content grounded in organizational documents, it occasionally fabricates document names or attributes content to the wrong source file. Always verify any specific file references Copilot claims to be citing.
Summarize a Long Document
Open a lengthy report or contract and click Copilot in the side panel:
Rewrite for a Different Audience
Select a paragraph, click the Copilot icon that appears, and choose Rewrite:
Reference Other Files
This is where the paid license earns its cost. You can ground Copilot's output in specific files:
Typing / in the Copilot prompt field opens a file picker that surfaces your Most Recently Used (MRU) files -- it's not a literal file path. The picker shows only files you have opened recently; if the file you need is not in the list, open it once in the relevant app and return to the picker. You can also paste a SharePoint or OneDrive link directly into the prompt. If you don't specify a source, Copilot pulls from everything your account can access across Microsoft 365 -- which sometimes returns irrelevant context.
Verification: Ask Copilot to "Summarize this document." If it returns an accurate summary referencing actual content from your document, Word integration is working.
Common failure: Copilot generates a summary that seems unrelated to your document. This happens when the document is very short (under 200 words) or newly created and not yet saved. Save the document to OneDrive and try again.
Step 4: Use Copilot in PowerPoint
The Microsoft Copilot PowerPoint generator turns prompts into slide decks. It's not going to produce keynote-quality results on the first pass, but it gets you 70% of the way in under a minute -- and that's the point.
Create a Presentation from a Prompt
Open PowerPoint, click the Copilot button in the ribbon:
Copilot generates the slide structure, applies a template from your organization's design library (if configured), and populates placeholder content. Each slide gets a layout appropriate to its content type.
Create a Presentation from a Word Document
This is the highest-value workflow for Microsoft Copilot in PowerPoint:
Type / in the prompt to open the file picker and select your source document. Copilot reads the Word document, extracts the structure, and converts it into slides with appropriate layouts. Section headings become slide titles. Bullet points stay as bullets. Data tables become simplified visuals.
Refine and Restructure
After generation, use follow-up prompts to iterate:
Generate Speaker Notes
Verification: Ask Copilot "Summarize this presentation." If it returns an accurate summary of your slide content, PowerPoint integration is active.
Common failure: Copilot creates slides with generic stock images that don't match your content. Use follow-up prompts to replace them: "Replace the image on slide 5 with an illustration of a cloud migration architecture." Copilot can generate AI images (powered by DALL-E) or pull from your organization's approved image library.
Step 5: Use Copilot in Outlook and Teams
Outlook: Triage and Draft
Microsoft Copilot for Outlook works in both the side panel and inline within email composition.
Summarize a long thread:
Open a long email chain and click the Summary by Copilot banner at the top of the thread (it appears automatically for threads with 4+ messages):
Draft a reply:
Click Draft with Copilot in the reply window:
Coaching:
After drafting an email, click Coaching by Copilot to get feedback on tone, clarity, and sentiment before sending.
Teams: Meeting Recaps and Chat Summaries
Microsoft Teams Copilot requires an active meeting transcript (enabled by your admin or meeting organizer).
During a meeting (side panel):
After a meeting:
Open the meeting chat and click the Copilot button:
Chat summaries:
In any Teams chat thread, Copilot can summarize up to 30 days of conversation. Open the Copilot panel in the chat:
Copilot includes clickable citations back to the original messages, so you can verify any summary point.
Verification: In a Teams meeting with transcription enabled, ask Copilot "What topics have been discussed?" during the meeting. If it returns accurate points from the transcript, Teams integration is working.
Step 6: Master Copilot Prompts Across All Apps
Generic prompts get generic results. The gap between a useless response and a useful one is almost always prompt quality. Microsoft's own guidance and the prompt engineering community have converged on a four-part framework.
The Goal-Context-Expectations-Source Framework
| Element | What It Does | Example |
|---|---|---|
| Goal | What you need | "Summarize this contract" |
| Context | Why you need it / how you'll use it | "I'm preparing for a negotiation meeting tomorrow" |
| Expectations | Format, length, audience | "5 bullet points, plain language, suitable for a non-legal audience" |
| Source | Where to look | "Use only the attached PDF, not other files" |
You don't need all four every time. But the more you include, the more targeted the response.
Weak Prompt vs. Strong Prompt
Weak: "Summarize this spreadsheet."
Strong: "Identify the 3 product categories with declining revenue over the last 2 quarters. For each, show the percentage decline and the region most affected. Format as a table."
Weak: "Write an email."
Strong: "Draft a follow-up email to the client thanking them for yesterday's meeting. Reference the three action items we agreed on (migration timeline, security audit, and budget approval). Ask for confirmation by Friday. Professional but warm tone, under 200 words."
Advanced Techniques
Point to specific files. In Word or Copilot Chat, type / to open the file picker and select files by name: "Using /Budget-2026.xlsx and /Strategy-Deck.pptx, draft a one-page executive summary." The / triggers the MRU (Most Recently Used) file picker, not a literal path. If the file isn't in your recently used list, open it first and the picker updates.
Use the RISEN framework for complex requests: define a Role ("Act as a financial analyst"), give Instructions ("Review Q1 actuals vs. forecast"), specify Steps ("First compare revenue, then margins, then headcount costs"), set an End goal ("Produce a variance report"), and Narrow the scope ("Only look at the North America business unit").
Iterate, don't start over. Copilot maintains conversation context in the side panel. If the first response is 80% right, tell it what to fix: "Good, but remove the section on marketing spend and add more detail on engineering headcount." Starting a new prompt from scratch loses the context.
Give positive instructions. Say "Include only data from Q1 2026" rather than "Don't include data from other quarters." LLMs respond better to what you want than what you don't. Keep prompts focused -- Copilot has a token limit per interaction, so a concise, structured prompt outperforms a rambling paragraph every time.
For more prompting strategies and reusable templates, see the TJS Prompt Engineering Library and Microsoft's Copilot Lab.
Validation
Run this end-to-end test to confirm Copilot is working across your M365 apps:
- Excel: Open a workbook with tabular data on OneDrive. Ask Copilot "Summarize this dataset." Confirm it returns column names, row counts, and at least one insight.
- Word: Open a document with 500+ words. Ask Copilot "What are the 3 key points in this document?" Confirm the summary matches the actual content.
- PowerPoint: Open a deck with 5+ slides. Ask Copilot "Summarize this presentation." Confirm it identifies the main topic and key slides.
- Outlook: Open an email thread with 3+ replies. Look for the "Summary by Copilot" banner. Click it and confirm the summary is accurate.
- Teams: Join or review a meeting with transcription enabled. Ask Copilot "What were the main discussion points?" Confirm it references actual transcript content.
If any app fails, revisit the Prerequisites checklist above. The most common culprits: license not assigned (check Admin Center), connected experiences disabled (check privacy controls), or files saved locally instead of to OneDrive/SharePoint.
Measuring effectiveness: Ask your team to log Copilot interactions for two weeks -- note the task, time spent with and without Copilot, and whether the output was accepted, edited, or rejected. This gives you the data to calculate actual time savings rather than relying on vendor projections. For a full ROI framework, see the Microsoft Copilot for Enterprise breakdown.
Troubleshooting
Cause: Your account doesn't have a Copilot license assigned, or your Microsoft 365 apps are not on Current Channel.
Fix: Ask your admin to verify the license at admin.microsoft.com, then run File > Account > Update Options > Update Now. If your organization uses the Semi-Annual Enterprise Channel (updates every six months instead of monthly), Copilot features may not be available yet.
Cause: Copilot can't find relevant source material to ground the response. This happens when you don't specify a file, when the file is local (not on OneDrive/SharePoint), or when you have Copilot Chat (free) instead of the full license.
Fix: Explicitly reference files in your prompt. Verify your license tier at m365copilot.com -- if you don't see a "Work" toggle, you have the free tier only.
Cause: Your data is not formatted as an Excel table, or the file is saved locally.
Fix: Select your data range, press Ctrl+T to convert it to a table, and save the file to OneDrive or SharePoint with Auto-Save enabled. Copilot also struggles with workbooks that have more than one table on the same sheet -- keep one table per sheet.
Cause: Copilot strictly honors your existing Microsoft Graph permissions via RBAC (Role-Based Access Control -- the system that determines which files and sites each user can see). If you don't have at least "view" permission on a file or site, Copilot can't retrieve it either.
Fix: Request access through your IT admin or the site owner. This is by design -- Copilot never bypasses access controls. For more on AI data governance in enterprise environments, see the AI Governance Hub.
Cause: Large workbooks (100K+ rows), complex multi-sheet references, or high organizational load during peak hours.
Fix: Reduce the data scope. In Excel, filter to the relevant subset before prompting. In Word, work with sections rather than entire 50-page documents. If timeouts persist, check Microsoft 365 Service Health for any Copilot service incidents.
Cause: Meeting transcription was not enabled. Copilot in Teams requires a live transcript to function during and after meetings.
Fix: The meeting organizer needs to enable transcription before or during the meeting: More actions > Record and transcribe > Start transcription. Your admin may also need to enable transcription at the tenant level in Teams admin center.
What's Next
Agent Mode: The Next Level
Agent Mode rolled out across Word, Excel, and PowerPoint in Q1 2026 and changes how Copilot operates. Instead of responding to one prompt at a time, Agent Mode lets Copilot orchestrate multi-step tasks autonomously -- editing, formatting, and building content across your document while showing its reasoning at each step. You steer; it executes. In Excel, Agent Mode can build a complete budget tracker with categorized expenses, conditional formatting, and data bars from a single prompt. In Word and PowerPoint, it drafts, refines, and formats entire documents iteratively. Paid M365 Copilot users get priority access with work grounding (Microsoft Graph data). Free Copilot Chat users get standard access with web grounding on the web versions of these apps. For more on how agentic AI is reshaping productivity tools, see the TJS Agentic AI Hub.
Copilot Notebooks
Build a Copilot Notebook. Microsoft Copilot Notebooks let you centralize project-related content -- plans, specs, meeting notes, research -- into a single workspace where Copilot is grounded specifically in that curated material. It even generates podcast-style audio summaries and suggests new content to add. It's the closest thing to having a dedicated AI teammate that actually knows your project context.
For the full picture on what Copilot is and how the orchestrator architecture works under the hood, see our What Is Microsoft Copilot breakdown. To understand whether the license cost makes sense for your team, check the Microsoft Copilot pricing and plans comparison. For reusable prompt templates you can drop directly into any M365 app, browse the Free AI Templates and Tools library. And for guides and breakdowns on every major AI tool, explore the AI Tools Hub.