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
From the course: Copilot in Excel: Supercharge Your Productivity
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,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Write and explain Excel formulas2m 32s
-
(Locked)
Results will vary29s
-
(Locked)
Highlight data automatically with conditional formatting2m 36s
-
(Locked)
Summary reports with charts and pivot tables2m 23s
-
(Locked)
Quick data insights and advanced analysis2m 39s
-
(Locked)
Clean data with the COPILOT function3m
-
(Locked)
Agent Mode: The future of copilot in Excel2m 16s
-