I’m not a wizard with Word and Excel. Are you? Do we know what to do with all those many menus at the top? Now, thanks to AI, maybe we don’t need to.

Microsoft has added AI to those software programs of yesteryear with Agent Mode for both Word and Excel. Powered by Microsoft 365 Copilot, Agent Mode can help anyone — even those with little experience — create high-quality, professional-grade documents and spreadsheets. Microsoft will add Agent Mode to PowerPoint at a future date.

Microsoft has also added Office Agent to Copilot chat to help create PowerPoint presentations and Word documents. Functionality for Excel will be added later.

Vibe coding

It’s a new take on the vibe coding wave, whereby developers can create software with natural language prompts instead of writing lines of code by hand, said Sumit Chauhan, corporate vice president of Microsoft’s Office product group.

«Get started with a simple prompt and then work iteratively with Copilot — steering it as it orchestrates multi-step tasks to deliver high-quality Office documents, spreadsheets, and presentations,» Chauhan said in a statement. «It’s the new pattern of work for human-agent collaboration.»

How Agent Mode works

Say you want to create a household budget in Excel. Tell Agent Mode to create budget categories such as rent or mortgage, groceries, utilities, gas and entertainment. You can have Agent Mode create formulas to let you know if you’re over and under budget, among other tasks. Agent Mode in Excel could also help you create a financial analysis for a business.

In Word, Agent Mode can help you create or refine a limitless number of documents, such as revising and cleaning up your resume, composing a holiday letter, or writing a progress report or executive summary for a business.

Microsoft says Agent Mode for Word «handles the heavy lifting: drafting content, suggesting refinements, and asking clarifying questions. » The consumer works with Agent Mode to keep refining and honing the document to the finished product.

Office Agent in Copilot chat 

You can start creating a PowerPoint from Copilot chat, using a prompt such as «Create a 10-slide PowerPoint deck of the most popular tech products in the US.» The Office Agent will then work with you to clarify intent, such as visual theme and target audience, refine the presentation, and determine how much research is needed.

How to begin

Agent Mode in Copilot for Excel and Word is now available in the Frontier program for Microsoft 365 Copilot licensed customers and Microsoft 365 Personal or Family subscribers. 

Agent Mode is available in Excel on the web and will be coming soon to the desktop. To try it, install the Excel Labs add-in and choose Agent Mode. Agent Mode works in Word on the web, with desktop coming soon. Get started here.

Office Agent is available in the Frontier program for Microsoft 365 Personal or Family subscribers in the US. Office Agent works in Microsoft 365 Copilot on the web in English. Get started here.