To try Agent Mode in Excel, you need to get the Excel Labs add-in and choose Agent Mode. In Word, you can just open Copilot ...

Microsoft is adding features that let workers describe what they want in a Word, Excel or PowerPoint file in a Copilot prompt ...

Thanks to Agent Mode in Excel and Docs, all you have to do is describe the task at hand, and you will have a well-formatted and aptly edited document at your disposal.