The Word, Excel, and PowerPoint agents in the Microsoft 365 Copilot app are designed to help you create and refine files directly from a chat experience, even if you don’t have a full Microsoft 365 Copilot license.

Here’s what happens behind the scenes:

• You start in chat: You open the Microsoft 365 Copilot app, go to All agents, and select the Word, Excel, or PowerPoint agent (or just type the agent name in the prompt box and select it).
• You provide a prompt: You describe what you need, such as “Create a project tracking workbook…” or “Draft a 2-page customer brief…” or “Build a 6-slide executive update…”.
• Grounding on your content: Each agent uses a mix of web sources and files you upload or select (for example, Project Nano Launch Workback.xlsx or Q3 product strategy.doc) to ground its output.
• Quick validation questions: Copilot asks a few clarifying questions with preselected options (you can also type your own answers). This step helps shape the structure, tone, and level of detail.
• Automatic file creation and saving: Copilot generates the file, saves it to your OneDrive, and shows it side-by-side with the chat window.
• Iterative refinement in chat: You can then refine the file conversationally (e.g., “Add a risk section,” “Simplify the language,” “Add a dashboard sheet”) or open it directly in Word, Excel, or PowerPoint for manual edits.

In short, you describe the outcome you want, Copilot creates a first draft using your content and web data, and you use chat to reimagine and polish the final document, workbook, or presentation.

The Excel agent is best when you need structured data, models, or dashboards, while Word and PowerPoint are better for narrative documents and presentations.

Use the Excel agent when you want to:

• Build and iterate on spreadsheets from scratch or from your existing files.
• Create structured workbooks with linked sheets, assumptions, and formulas.
• Turn raw data and guidance into models and visual dashboards.

Examples of what the Excel agent can do:

• Financial models: Create a discounted cash flow (DCF) model for a mid-size software company, including Balance Sheet, Cash Flows, and Income Statement. You can specify assumptions like:
  • Free cash flows starting at $10 million in year 1
  • 12% annual growth for 5 years
  • 9% discount rate and 2% terminal growth rate
  Copilot can also add sensitivity analysis tables and selectors for best, base, and worst-case scenarios.
• Scenario modeling from your files: Use historical revenue, cost, pipeline, renewal, and pricing guidance data from an uploaded file to build a multi-year model with:
  • Full P&L, cash flow, and balance sheet
  • Driver-based forecasting and base/upside/downside scenarios
  • Sensitivity analysis on price, win rate, churn, and more
  • Error checks, a dashboard of charts, and a one-page executive summary
• Project tracking systems: Build a full tracking workbook with tasks, owners, milestones, budgets, and risk ratings, grounded in your workback plans, sprint notes, and budget files. Copilot can add:
  • Gantt-style timelines
  • Conditional formatting for at-risk or overdue tasks
  • Dashboards with burndown charts, budget tracking, and risk heatmaps
  • A status-ready summary that you can export for leadership updates
• Market forecasts: For example, build a US market forecast for smart fitness apparel from 2026–2030 using the latest activewear market data. Copilot can:
  • Set up adjustable assumptions
  • Chart revenue by segment
  • Add region-specific breakdowns and visuals

Use Word when you need narrative content (reports, briefs, whitepapers) and PowerPoint when you need a visual story (decks, executive updates, planning presentations). Use Excel when your main goal is to structure numbers, scenarios, and metrics in a way that you can analyze and update over time.

The Word and PowerPoint agents help you turn ideas and existing files into polished documents and decks through a chat-based workflow.

With the Word agent, you can:

• Generate event summaries and scripts: For example, create a report on announcements and themes from Microsoft Ignite 2025 and draft a 5–7 minute podcast script tailored to a tech-savvy audience.
• Evaluate methods and tradeoffs: Compare approaches like collaborative filtering vs. deep learning models for an AI recommendation system. Copilot can structure a decision-support whitepaper that covers business value, technical feasibility, risks, and long-term ROI to guide leadership discussions.
• Build strategic reports: Summarize emerging trends in agentic AI and new job opportunities over the last 12–18 months and the next 12–24 months, prioritizing enterprise and regulated environments. It can also evaluate these trends against your own roadmap (for example, using Product roadmap.docx) and highlight opportunities and risks.
• Analyze social media trends: Create a report on influencer and social media advertising trends and suggest improvements to an upcoming campaign based on a deck like Q4 Campaign.pptx.

With the PowerPoint agent, you can:

• Create analytical industry decks: For instance, analyze the last 5 years of the semiconductor industry, focusing on TSMC, Intel, Samsung, and NVIDIA. Copilot can show key strategic pivots, R&D intensity, market share shifts, and 5-year forward risks in a consulting-style presentation with charts and an executive summary.
• Support HR and benefits communication: Build slides to encourage employees to fund their retirement accounts, using details from Company Retirement Match.doc. Copilot can combine numbers, visuals, and narrative analogies to clarify the value of the company match and increase participation.
• Plan business initiatives: Draft an 8-slide overview for a pop-up kitchen in Philadelphia that must serve 200 guests, use locally sourced ingredients, stay within a $10,000 food-cost budget, and comply with county health permits.
• Develop buyer personas: Generate a deck with 3 detailed SMB buyer personas for an HR employee benefits software platform, based on a file like SMB Market Research.pdf. Copilot can outline demographics, pain points, buying triggers, and preferred communication channels.
• Explore cultural topics: Create slides on themes such as the evolution of coffee culture, combining narrative, visuals, and data.

In both Word and PowerPoint, the pattern is similar: you select the agent, describe what you need, answer a few validation questions, and Copilot generates a first draft grounded in your files and web content. You then refine it in chat to reshape the structure, tone, and visuals until it fits your audience and goals.