In the present day, we’re bringing vibe working to Microsoft 365 Copilot with Agent Mode in Workplace apps and Workplace Agent in Copilot chat. In the identical method vibe coding has remodeled software program improvement, the most recent reasoning fashions in Copilot unlock agentic productiveness for Workplace artifacts. Get began with a easy immediate after which work iteratively with Copilot—steering it because it orchestrates multi-step duties to ship high-quality Workplace paperwork, spreadsheets, and displays. It’s the brand new sample of labor for human-agent collaboration.
- Agent Mode in Excel and Phrase delivers best-in-class, AI-generated spreadsheets and paperwork proper within the apps hundreds of thousands of individuals depend on day by day at work—beginning in Excel and Phrase, with PowerPoint coming quickly.
- Workplace Agent creates polished PowerPoint displays and ready-to-use Phrase paperwork from chat in Copilot, and coming quickly to Excel.
Agent Mode in Excel
Excel is the world’s most versatile knowledge modeling software—powering all the pieces from family budgets to Fortune 500 revenue and loss statements (P&Ls). But, the complete energy of Excel is on the market solely to knowledgeable customers. Agent Mode modifications that. Agent Mode delivers AI that may “converse Excel” natively. It’s constructed on the richness of Excel artifacts and OpenAI’s newest reasoning fashions—democratizing entry to expert-level capabilities and making superior modeling approachable for many everybody. These breakthroughs permit Agent Mode to not solely generate outputs, but in addition consider outcomes, repair points, and repeat the method till the result is verified. It’s such as you’re handing off work to an Excel knowledgeable—when you steer and information.
SpreadsheetBench exhibits how Agent Mode performs on a wide range of spreadsheet duties:
Give Copilot a immediate like, “Run a full evaluation on this gross sales knowledge set. I wish to perceive some necessary insights to assist me make choices about my enterprise. Make it visible.” Agent Mode will get to work deciding which formulation to make use of, producing new sheets, and creating knowledge visualizations. Copilot shares a full abstract of insights gathered and validation steps taken so you may proceed to iterate with Copilot on the output.
Listed below are some extra Agent Mode in Excel prompts to strive:
- Monetary Evaluation Immediate: Create a monetary month-to-month shut report for a motorcycle store enterprise, together with a breakdown of product strains throughout VTB, VTF, sequential, and year-over-year development. Use customary monetary formatting and finest practices.
- Mortgage Calculator Immediate: Construct a mortgage calculator that computes month-to-month funds based mostly on consumer inputs for mortgage quantity, annual rate of interest, and time period in years. Generate a schedule displaying month, cost, principal, curiosity, and remaining stability. Current the ends in a transparent, formatted desk.
- Private Budgeting Immediate: Create a month-to-month family price range tracker with classes like Hire, Groceries, Utilities, Leisure, Transportation, and Financial savings. Apply conditional formatting and knowledge bars for % Over/Beneath Price range. Add a abstract part displaying deliberate versus precise spending with a donut chart to visualise spending distribution.
Agent Mode in Phrase
Billions of Phrase paperwork are created each month. Agent Mode in Phrase turns doc creation into vibe writing, an interactive, conversational expertise. Simply inform Copilot what you want—like “summarize current buyer suggestions and spotlight key traits,” and Copilot handles the heavy lifting: drafting content material, suggesting refinements, and asking clarifying questions alongside the best way. Copilot makes options to maintain the method flowing, so writing feels extra like a dialogue than a process. You give attention to intent; Copilot brings it to life with Phrase’s native kinds and polished formatting.
This deeper interplay means quicker iteration, higher concepts, and a extra partaking writing expertise.
Listed below are some Agent Mode in Phrase prompts to strive:
- Month-to-month Report Replace Immediate: Assist me replace this month-to-month report for September. Replace the information desk with the most recent numbers from the /Sept Knowledge Pull e mail. Summarize the important thing highlights together with insights in comparison with final month’s /August month-to-month report.doc.
- Mission Replace Immediate: Replace the chief abstract for readability, daring all key findings, and insert a bulleted record of subsequent steps based mostly on the /Mission replace assembly. Be sure so as to add a conclusion.
- Doc Fashion Immediate: Are you able to clear up this doc? Title case for part headers, branding updates per the ‘/Newest model tips’ e mail, and italicize all exterior associate mentions. Be happy to ask in the event you need assistance figuring out companions or tips.
Workplace Agent in Copilot chat
In the present day, work usually begins in chat. Workplace Agent in Copilot, powered by Anthropic fashions, permits you to create PowerPoint displays and Phrase paperwork in a chat-first expertise. PowerPoint is among the most used instruments for creating displays, however over the past two years, AI has usually fallen brief when creating slides. Workplace Agent modifications that. Workplace Agent creates tasteful, well-structured PowerPoint decks and well-researched Phrase paperwork.
Give Workplace Agent in Copilot chat a immediate like, “Create a deck summarizing the highest 5 traits within the athleisure clothes market,” and it’ll:
- Make clear your intent: Begins by understanding your immediate and particular wants—file size, visible theme, key focus areas, audience, and extra.
- Conduct deep analysis: Does web-based analysis to assemble and cause over related data utilizing deep reasoning capabilities—displaying its chain of thought and offering a reside preview of slides.
- Produce high-quality content material: Makes use of code era to execute your request and run high quality checks alongside the best way—producing a ready-to-share presentation. From there, you may collaborate with Workplace Agent to tweak visuals, modify formatting, and revise content material—or seamlessly hand off to PowerPoint for last touches with Copilot.
Listed below are some extra Workplace Agent prompts you should use:
- Enterprise Plan Immediate: Assist my restaurant chain draft a pop-up kitchen plan in Philadelphia. The occasion should serve 200 visitors, use solely regionally sourced substances, keep inside a $10,000 food-cost price range, and adjust to county well being permits. Give me an 8-slide overview to assist me by way of the planning course of.
- Retirement Financial savings Plan Immediate: I have to create a set of slides to share with my workers to encourage them to actively fund their retirement accounts. We’ve agreed to match a share of their contributions, however I’d like to extend the uptake of individuals collaborating on this program. Use a mix of numbers, visuals, and narrative/analogies to assist.
- Social Media Developments Immediate: Create a report evaluating the traits of influencer and social media promoting within the espresso business.
Get began right now
Agent Mode in Copilot for Excel is on the market beginning right now within the Frontier program for Microsoft 365 Copilot licensed clients and Microsoft 365 Private or Household subscribers. Agent Mode works in Excel on the internet and is coming quickly to desktop. To strive it, set up the Excel Labs add-in and select Agent Mode.
Agent Mode in Copilot for Phrase begins rolling out right now within the Frontier program for Microsoft 365 Copilot licensed clients and Microsoft 365 Private or Household subscribers. Agent Mode works in Phrase on the internet, with desktop coming quickly. Get began right here.
Workplace Agent is on the market right now within the Frontier program for Microsoft 365 Private or Household subscribers based mostly in the USA. Workplace Agent works in Microsoft 365 Copilot on the internet in English. Get began right here.
For extra data, learn the Agent Mode in Excel weblog and Workplace Agent weblog.
That is only the start. Keep tuned as we convey vibe working to extra Microsoft 365 Copilot experiences.
