From the course: Copilot in Excel: Supercharge Your Productivity

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Agent Mode: The future of copilot in Excel

Agent Mode: The future of copilot in Excel

- The future of Copilot in Excel is called Agent Mode. It's absolutely incredible and you just have to see it in action. So here I have some sales data, and I want to create a dashboard with several charts. I'm going to click the Copilot button to open the Copilot chat experience. And here I'm going to go to Tools and choose Agent Mode. And Agent Mode uses Copilot and AI to perform multi-step tasks and edits to the workbook. So I'm gonna paste my prompt in here, which is to create a dashboard from the sales data table with these following charts. Go ahead and hit Enter, and Copilot will get to work. And I'm speeding up the video here as Agent Mode is working. So Copilot has finished its work. It took about two minutes and 14 seconds for it to create the dashboard. As it says here, created four charts. Those charts have been added over here to this dashboard sheet. So here's all four of the charts on the dashboard sheet,…

Contents