From the course: Microsoft 365 Copilot Shorts: 20 Skills in 20 Minutes

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Leveraging Copilot Agent Mode in Excel

Leveraging Copilot Agent Mode in Excel

From the course: Microsoft 365 Copilot Shorts: 20 Skills in 20 Minutes

Start my 1-month free trial Buy for my team

Leveraging Copilot Agent Mode in Excel

“

how to use agent mode in Excel. So start in Excel and go to the upper right and open copilot. Now go to the tools menu and choose agent mode. This puts Excel into a mode where now I can just have natural language discussions and it'll build rich dashboards and data for me. So I'm gonna put in my prompt, can you research the latest GPU data, forecast out a few years, build some charts and structure the spreadsheet accordingly and I'll hit go. Now agent mode is doing its work. It's going step by step. If I expand this, I can even see all the steps that it's going through as it's going to build out my spreadsheet. Okay, Agent Mode is finished. So I've got a nice GP market data and forecast with a bunch of data laid out really nicely and how to update this forecast. I have research notes, so NVIDIA, AMD, Intel, all the notes and sources that it went and it researched and then the charts and analysis. So some different charts you can see right here, including the pie chart, market by…

Contents