How to Use Copilot in Word, Excel, PowerPoint, Outlook and Teams
GuidesMonday, 03 August 2026 at 14:50
To use Copilot well in Microsoft 365, begin inside the app that owns the final output. Give it a specific goal, point to the authoritative source, describe the changes it may make, and review the result in the native file before sharing or sending anything.
That app-native workflow is the main advantage. Copilot can edit a Word document, work with Excel cells, build PowerPoint slides, use an Outlook thread or reason over a Teams meeting without turning every task into a detached chatbot conversation.
Your exact features depend on the account, license, app and administrator settings. This guide explains those differences and then provides practical workflows for the five core apps. Use our complete Microsoft Copilot guide to map the entire product family, or the complete Microsoft 365 Copilot guide for Work IQ and workplace rollout decisions. If you have never used the standalone assistant, begin with how to use Microsoft Copilot.
First check which Copilot you have
Do this before following a tutorial. Two people can open the same version of Word and see different Copilot capabilities.
Personal Microsoft account
Microsoft Copilot itself is available free for general chat. Copilot inside the desktop versions of Word, Excel, PowerPoint, Outlook and OneNote is available to the subscription owner of eligible Microsoft 365 Personal, Family and Premium plans.
Important consumer rules include:
- AI benefits in a Family plan are for the subscription owner, not every person with whom the plan is shared;
- usage limits or AI credits apply;
- Microsoft 365 Premium has higher limits and access to advanced agents;
- app, device, language and region availability can differ;
- consumer data terms are not the same as organizational enterprise data protection.
Work or school account
Eligible Entra users receive Microsoft 365 Copilot Chat without an extra Copilot add-on. In 2026, that included product can also provide Basic experiences in Word, Excel, PowerPoint and Outlook, depending on the tenant and configuration.
The paid Microsoft 365 Copilot add-on provides the Premium experience: broader work grounding through Work IQ, advanced in-app tools, priority access, Teams meeting intelligence and agents such as Researcher and Analyst. The account type also changes the data boundary; see Microsoft Copilot privacy and security before using confidential material.
Open Copilot and look for the label under your account:
- Copilot Chat (Basic): protected workplace chat, without full add-on rights;
- M365 Copilot (Basic): Basic in-app capabilities;
- M365 Copilot (Premium): paid Microsoft 365 Copilot capabilities.
Microsoft documents the current differences in its Copilot Chat license comparison.
| Account or entitlement | What to expect in the apps |
| Free personal Copilot | General chat; no assumption of desktop Office integration |
| Microsoft 365 Personal or Family owner | Copilot in desktop apps with consumer usage limits |
| Microsoft 365 Premium owner | Higher consumer limits and selected advanced agents/features |
| Eligible work account without add-on | Protected Copilot Chat; Outlook and Basic app experiences vary by tenant |
| Work account with paid add-on | Premium in-app features, full Work IQ grounding and advanced agents |
If a button is missing, check the signed-in identity, account label, app version, update status, connected-experience privacy settings and administrator policy before assuming the license is wrong.
A prompt pattern that works in every Microsoft 365 app
Use five elements:
- Outcome: What useful result should exist?
- Source: Which document, range, thread, meeting or file is authoritative?
- Action: Should Copilot draft, analyze, rewrite, plan or edit?
- Constraints: What must it preserve, avoid or leave unchanged?
- Review form: How should it expose assumptions, sources or changes?
For example:
Prepare a one-page project update for the steering committee. Use this document and the linked risk register as the only sources. Keep all confirmed dates, separate decisions from open questions, and do not invent an owner for any unassigned task. Draft the update in this Word file and end with a checklist of facts I should verify.
The phrase “make this better” gives Copilot no definition of better. The structured request tells it what it may use and how the user will judge the result.
How to use Copilot in Word
Copilot in Word is useful for creating, understanding and revising documents. It can draft text, summarize a document, answer questions about it, rewrite selected passages and—where the user has the appropriate capability—make broader edits within the file.
Microsoft’s Copilot in Word overview covers supported Word platforms and current entry points.
Prepare the document
Before prompting:
- save the document in a supported Word format;
- put authoritative source files in OneDrive or SharePoint when you need to reference them;
- apply headings to make the structure explicit;
- separate instructions from source text;
- resolve obvious tracked changes or know which ones must remain;
- confirm that you are signed in with the Copilot-enabled account.
Cloud storage makes source references, sharing, version history and organizational grounding more reliable. Some consumer or platform-specific features may require Word for the web or have different file-reference behavior.
Workflow 1: draft from approved source material
- Open a new or existing Word document.
- Open Copilot from the ribbon, canvas or side pane.
- State the audience, purpose and desired length.
- Use the file-reference control or type / and select the source when that option is available.
- Ask Copilot to draft.
- Inspect the source-dependent claims before keeping the text.
- Revise selected sections instead of regenerating the whole document.
Prompt:
Draft a 900-word customer implementation plan for a non-technical operations director. Use /Approved Statement of Work and /Implementation Checklist as the only factual sources. Organize it as objectives, scope, timeline, responsibilities, risks and next decision. Mark any conflict between the two files instead of resolving it yourself.
This is stronger than pasting both documents into a generic chat because the result remains inside the governed Word workflow and can retain the document’s structure.
Workflow 2: summarize a long document
Ask for a decision-specific summary:
Summarize this document for a legal and procurement review. List commercial commitments, deadlines, termination rights and unresolved placeholders. Give the heading or section for every item. Do not offer legal advice.
Microsoft notes that automatic Word summaries depend on the plan, file location and document length. A short file may need a manual summary request, while very long source sets may need section-by-section work.
Do not evaluate summary quality by how fluent it sounds. Check whether Copilot:
- omitted an exception;
- collapsed a conditional statement into a certainty;
- confused a proposal with an approved decision;
- attributed a number to the wrong section;
- ignored a table, footnote or image.
Workflow 3: controlled rewriting
Select the passage before asking Copilot to rewrite it.
Prompt:
Rewrite only the selected paragraphs for a general business audience. Preserve every number, product name and contractual term. Shorten sentences, remove repeated claims and keep the current heading structure. Show the revised text; do not edit the rest of the document.
Selection limits the blast radius. A whole-document request can silently alter facts that were already correct.
Workflow 4: critique before editing
Use a separate diagnostic step:
Review this proposal without rewriting it. Identify unsupported claims, missing decisions, repeated sections and places where the reader will not know who acts next. Put the findings in a table with section, problem, consequence and recommended fix.
Approve the changes only after reviewing the diagnosis. Critique-then-edit is safer than asking for a polished rewrite in one step.
Word review checklist
- Compare names, dates and numbers with the source.
- Check quotations against the original.
- Inspect headings, lists, tables, footnotes and tracked changes.
- Confirm that comments or sensitive drafting notes were not pulled into the output unexpectedly.
- Run the normal spelling, accessibility and document-review tools.
- Have the accountable owner approve external or high-impact text.
Copilot is an editor and drafting assistant, not an authority on the underlying facts.
How to use Copilot in Excel
Copilot in Excel can analyze data, generate formulas, create charts and PivotTables, apply formatting and make direct workbook changes. Current experiences can offer chat, plan and edit modes.
- Use chat when you want an explanation without changing the workbook.
- Use plan when the task is complex and you want to inspect the proposed steps.
- Use edit when the requested changes are clear and reversible.
Microsoft’s current Copilot in Excel FAQ describes the supported modes and license labels.
Prepare the workbook
Copilot performs better when the workbook has:
- one clear header row per dataset;
- descriptive column names;
- consistent dates, numbers and categories;
- no decorative blank rows inside data;
- limited merged cells;
- explicit units and currencies;
- source data separated from presentation;
- formulas instead of unexplained typed totals;
- a current saved version or backup.
For broad compatibility, save the workbook to OneDrive or SharePoint and use a supported format such as XLSX, XLSM or XLSB. Microsoft’s consumer plan material can still state an AutoSave and OneDrive requirement, while current Excel support documentation says newer Copilot experiences can run with AutoSave enabled or disabled. Treat the in-product behavior for your account as decisive.
If Copilot will edit directly, turn off AutoSave for experimentation or work on a copy. Version history and Undo are controls, not inconveniences.
Workflow 1: understand before changing
Start in chat mode:
Inspect this workbook without making changes. Identify the tables, key formulas, dependencies between sheets, date range, units and any obvious data-quality problems. Tell me which assumptions you would need before analyzing customer profitability.
This helps expose whether Copilot has understood the structure. Correct a mistaken interpretation before asking for calculations.
Workflow 2: generate and explain a formula
Prompt:
In a new column named Renewal risk, propose a formula that labels an account High when the renewal date is within 60 days and either product usage is below 40% or there is an unresolved critical ticket. Explain the formula first and wait before inserting it.
Then ask:
Apply the approved formula to the table. Do not replace existing values outside the new column. Show me which rows are High and why.
Review the formula’s ranges, absolute references, blank handling, error handling and date logic. Test it on known boundary cases: exactly 60 days, missing usage and closed critical tickets.
Workflow 3: analyze trends without inventing causation
Prompt:
Analyze monthly net revenue by region from January 2025 through June 2026. Separate direct observations from possible explanations. Flag missing months and changes in reporting coverage. Create a line chart and a table of the three largest month-over-month movements. Do not call a relationship causal.
Copilot can identify patterns, but the workbook may not contain the information needed to explain them.
Workflow 4: create a PivotTable and chart
Prompt:
Create a PivotTable on a new sheet showing closed revenue by quarter, region and sales channel. Add a clustered column chart. Keep the source sheet unchanged, use the workbook’s currency format and place a note above the PivotTable stating the active filters.
Inspect filters and aggregation. A plausible chart built from the wrong field is still wrong.
Workflow 5: use plan mode for multi-step cleanup
Prompt:
Plan how to standardize the Customer type and Country fields, identify duplicate Account IDs, and create a validation sheet. Do not delete or overwrite rows. Include a rollback step and wait for approval.
Data cleaning often requires business judgment. “Intl,” “International” and “Global” may look like duplicates but represent different categories.
Excel review checklist
- Recalculate key totals independently.
- Inspect every new or changed formula.
- Check filters, hidden rows and excluded ranges.
- Confirm number, date, percentage and currency formats.
- Test blank, zero, duplicate and error cases.
- Verify chart axes and aggregation.
- Preserve raw data and version history.
- Treat forecasts as scenarios based on assumptions, not facts.
For regulated reporting, finance, payroll or material decisions, use validated models and qualified review.
How to use Copilot in PowerPoint
Copilot in PowerPoint can draft a presentation, create slides from a source, reorganize content, summarize an existing deck, rewrite bullets, create images and help anticipate audience questions.
The best workflow starts from an approved narrative and a real template. One sentence such as “make a sales deck” rarely produces a useful presentation because Copilot must invent the audience, argument and proof.
Prepare the presentation
- Start with the organization’s current PowerPoint template.
- Put the intended audience and decision in the prompt.
- Prepare a concise source document with clear headings.
- Store source files in OneDrive or SharePoint when required.
- Remove expired claims and duplicated charts.
- Decide whether Copilot may create images or must use approved assets.
Microsoft recommends using a properly built PowerPoint template so Copilot can use its theme and layouts. A branded background image is not the same as a functioning template with Slide Master and layout definitions.
Workflow 1: create a deck from a source file
- Open a blank copy of the approved template.
- Open Copilot.
- Choose the create-from-file route where available.
- Select the approved Word document, PDF or other supported source.
- Tell Copilot the audience, decision and desired structure.
- Generate the draft.
- compare each slide against the source.
Prompt:
Create an eight-slide decision deck from /Expansion Business Case. The audience is the executive committee, and the requested decision is whether to fund a three-month pilot. Use this template. Include problem, evidence, options, financial range, major risks, pilot design, success criteria and decision. Do not invent testimonials or replace missing numbers.
Microsoft’s presentation-from-file workflow notes that Copilot can create a draft with images and speaker notes. Those additions still require review.
Workflow 2: add one grounded slide
Prompt:
Add one slide after “Customer evidence” using /June Research Summary. Show the three strongest findings and the sample size. Use the existing slide layouts and add a source note in the speaker notes. Do not change any other slide.
Adding one slide is easier to verify than regenerating the deck.
Workflow 3: restructure an existing deck
Ask for a plan before edits:
Review this deck for a 15-minute board discussion. Recommend a new slide order that brings the decision and evidence forward. Identify slides to move to the appendix. Do not edit yet.
Then approve the order and ask Copilot to apply it. Confirm that cross-references and narrative transitions still work.
Workflow 4: prepare for questions
Prompt:
Act as a skeptical CFO reviewing this deck. List the ten questions most likely to block approval. For each, identify which slide contains an answer and which question is not answered by the current evidence.
This uses Copilot as a rehearsal partner without asking it to invent reassuring answers.
PowerPoint review checklist
- Verify every factual claim and chart.
- Remove generic or unsupported images.
- Check brand, layout, contrast and accessibility.
- Confirm speaker notes do not contain invented facts.
- Make sure each slide advances the same decision narrative.
- Inspect source attributions and permissions.
- Rehearse timing and questions with a human colleague.
Copilot can produce a visually complete deck before the argument is complete. Do not confuse design finish with decision quality.
How to use Copilot in Outlook
Copilot in Outlook can summarize email threads, draft replies, coach tone, help prepare for meetings and—depending on license and platform—assist with calendar actions and rules.
Eligible organizational users can use Copilot Chat in Outlook without the paid add-on, but their context is narrower. With the paid Microsoft 365 Copilot license, Outlook can reason across the inbox, calendar, meetings, chats, files and other enterprise context.
Workflow 1: summarize a thread
Open the conversation and select the summary control.
Follow with:
List the confirmed decisions, unresolved questions, deadlines and owners in this thread. Cite the message for each item. If two participants disagree, show both positions.
Check whether collapsed messages, attachments, encrypted email or content outside the thread were excluded. Microsoft says Copilot features are not supported for some signed, encrypted, rights-managed or sensitivity-labeled messages.
Workflow 2: draft a reply without creating commitments
Prompt:
Draft a concise reply acknowledging the delay, confirming the two dates already agreed in this thread and asking for a decision on the open scope item. Do not promise a discount, accept liability or introduce a new deadline.
Read the draft as if you were the recipient. Check the addressees, attachments, dates, tone and implied commitments before sending.
Workflow 3: use coaching
Write your own message first, then ask Copilot to assess clarity, tone and sentiment.
Prompt:
Review this draft for clarity and unintended hostility. Do not make it warmer at the expense of the firm deadline. Explain each suggested change before applying it.
Tone coaching can smooth necessary disagreement into vagueness. The author remains responsible for the message.
Workflow 4: prepare for a meeting
Open the calendar item and use the meeting-preparation experience where available.
Prompt:
Prepare me for this meeting. Summarize the stated objective, the latest related email, the current project document and unresolved actions from the previous meeting. Separate confirmed facts from your inference and identify any source you could not access.
Paid Work IQ grounding makes this cross-source workflow more useful. An unlicensed user may need to reference or upload specific items.
Workflow 5: schedule carefully
Copilot Chat in Outlook can support calendar actions, but scheduling is consequential. Confirm:
- the correct people;
- time zones;
- duration;
- recurrence;
- room or online link;
- description and attachments;
- whether sending should wait for approval.
“Find a time” is not enough when attendees have different roles or when external guests need consent.
Outlook review checklist
- Verify recipients before sending.
- Confirm dates, times and time zones.
- Check quoted commitments against the thread.
- Open referenced attachments.
- Review sensitivity labels and external-recipient warnings.
- Never let a generated draft create a legal, commercial or personnel commitment by accident.
How to use Copilot in Teams
Copilot in Teams can summarize discussions, answer questions about meetings, identify actions and decisions, and help users catch up. Teams also hosts Copilot Chat and agents such as Facilitator.
The meeting experience is primarily a paid Microsoft 365 Copilot capability. It also depends on meeting policy, organizer settings, transcription or recording choices and whether the meeting is hosted by the user’s organization. Microsoft’s current Teams meeting guide documents those conditions.
Before the meeting
The organizer should decide:
- whether Copilot is allowed;
- whether it operates only during the meeting;
- whether transcription or recording will run;
- how participants are informed;
- what retention and eDiscovery rules apply;
- whether external or sensitive discussion is appropriate.
Copilot can run during supported meetings without creating a transcript, but post-meeting availability differs. Microsoft explains that a transcript is needed for normal after-meeting prompting and history; an “only during the meeting” configuration can use live audio and contextual signals without a transcript, subject to organizational policy.
Workflow 1: catch up during a meeting
Prompt:
Catch me up from the start. List the decisions made, evidence discussed, disagreements that remain and actions assigned. Include the speaker for each action. Do not infer agreement when the discussion was unresolved.
The summary is private to the user unless it is copied or shared. Confirm important points with the participants.
Workflow 2: test whether a decision actually exists
Prompt:
Has the group made a final decision on the launch date? Quote or closely identify the statements supporting your answer. If there is no explicit decision, say so and describe the remaining positions.
Meeting summaries often turn momentum into apparent consensus. A decision test is more useful than a generic recap.
Workflow 3: create a reviewable action list
Prompt:
Create a table with action, owner, due date, dependency and the moment in the meeting where it was assigned. Mark missing owners or dates as unassigned; do not guess.
Read the list aloud or share it before the meeting closes. People should be able to correct an assignment while context is fresh.
Workflow 4: post-meeting recap
Open the meeting chat or Recap and ask:
Create a follow-up summary for attendees. Include purpose, decisions, unresolved questions and approved actions. Exclude informal comments and personal discussion. Draft only; do not post.
If transcription or recording was not available, the after-meeting source may be incomplete or unavailable.
Workflow 5: use Facilitator
Facilitator can help maintain an agenda, generate notes and create supported documents or collaborative components. Give it a bounded role:
Track the agenda and decisions. When an action is stated, ask for an owner and date if either is missing. Do not create or assign work without confirmation.
Facilitator should support meeting discipline, not become an invisible chairperson.
Teams review checklist
- Verify decisions with participants.
- Confirm action owners and dates.
- Distinguish transcript text from interpretation.
- Check whether late joiners or external participants changed context.
- Follow organizational consent, recording and retention policy.
- Do not place sensitive side discussions in a generated recap.
A complete cross-app workflow
Copilot becomes more useful when each app owns the step it is designed for.
Suppose a team needs to turn customer research into an approved quarterly plan:
- Teams: extract confirmed decisions and open actions from the review meeting.
- Word: draft the plan from the approved research and meeting output.
- Excel: calculate scenario ranges and create the controlled source chart.
- PowerPoint: build the decision deck from the approved plan and workbook.
- Outlook: prepare the review email, with links to the source files.
At every handoff:
- preserve the source link;
- identify the accountable owner;
- state what Copilot changed;
- verify before the next app uses the output.
Do not ask one giant prompt to perform all five stages invisibly. The checkpoints are what make the workflow reviewable.
Common problems and fixes
The Copilot button is missing
Check the signed-in account, license label, supported app version, update channel, internet connection, connected-experience setting and administrator policy.
Copilot cannot find a file
Confirm the file is in an accessible OneDrive or SharePoint location, that the user has permission, and that the file format and size are supported. Use the file picker instead of relying on a vague title.
The output ignores source material
Name the source explicitly, narrow the task and require section references. Split a very long document or workbook into a targeted request.
Excel changes the wrong range
Use plan mode, name the table and columns, work on a copy and require Copilot to state its intended range before editing.
PowerPoint looks generic
Start with a genuine organization template, provide a structured source, define the audience and decision, and revise slide by slide.
Outlook invents context
Limit the prompt to the open thread or selected sources. Tell Copilot to mark missing information instead of inferring it.
Teams creates false certainty
Ask which statement supports each decision and mark unresolved items explicitly. Confirm the recap with humans.
Frequently asked questions
Do I need Microsoft 365 Copilot to use Copilot in Word and Excel?
Not always. Microsoft 365 Personal, Family and Premium owners have consumer in-app rights, and some eligible organizational users receive Basic app capabilities without the paid add-on. Premium workplace features require the Microsoft 365 Copilot license.
Why does my colleague have more Copilot features?
You may have different account types, license labels, app versions, release channels, regions or administrator settings. Compare the Basic or Premium label shown in Copilot.
Does Copilot automatically see all my work files?
Full paid Work IQ grounding can retrieve work content the signed-in user is permitted to access. Basic or consumer experiences may require an explicit file reference. Copilot does not override permissions.
Does Copilot in Excel require OneDrive and AutoSave?
Requirements depend on the plan and current experience. Consumer documentation can require a file saved to OneDrive with AutoSave, while current Excel support says newer Copilot in Excel can run with AutoSave on or off. Saving a version in OneDrive or SharePoint remains the safest general setup.
Can Copilot create a full PowerPoint from a Word document?
Yes, on supported plans and platforms. It can create a draft with slides, images and notes, but the user must verify claims, layout, sources and speaker notes.
Can Copilot send an Outlook email for me?
Some experiences support actions, but review recipients, content, attachments and commitments before any message is sent. Use a draft-first instruction for consequential email.
Does Copilot in Teams work without transcription?
It can work during a supported meeting in an “only during the meeting” mode without normal transcription. Post-meeting availability and history differ, and organizational retention can still apply to prompts and responses.
Can Copilot make mistakes in formulas and meeting summaries?
Yes. It can produce an incorrect formula, omit a condition, misunderstand a speaker or overstate agreement. Review against the workbook, transcript and source evidence.
Which app should I start in?
Start in the app that owns the final object: Word for a document, Excel for a calculation, PowerPoint for a deck, Outlook for an email or calendar item, and Teams for a meeting or chat.
Can Copilot edit a Microsoft 365 file directly?
Some plans and app experiences can make changes in the open file; others mainly suggest content or create a draft for review. Preserve version history, define the permitted range or section and inspect every consequential edit in the native app.
Bottom line
Copilot is most useful in Microsoft 365 when it helps with the real object of work rather than producing text that must be copied between systems.
Use Word for controlled documents, Excel for reviewable calculations, PowerPoint for source-grounded presentations, Outlook for contextual communication and Teams for meeting evidence. In every app, define the source and permitted action, expose assumptions, preserve version history and keep a human responsible for the result.
The interface will keep changing. The durable method will not: choose the correct entitlement, ground the task in authoritative material, ask for a bounded change and verify it where the work lives.
byDavid Porter
Loading