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.
Quick data insights and advanced analysis
From the course: Copilot in Excel: Supercharge Your Productivity
Quick data insights and advanced analysis
- Sometimes you'll receive an Excel file that you aren't familiar with and spend a bunch of time just trying to figure it out. So in this lesson, we'll use Copilot to quickly get insights on our data and do advanced analysis. So here I have some data that was exported from an online system, and I'm not familiar with this data, so I wanna use Copilot to help me learn more about this dataset. Over here in the chat box, I'm gonna type, "Show data insights." And this is a simple prompt you can use anytime you wanna learn about your data. So Copilot has read through the data and it's telling us that these are sales transactions with details, and it gives more information here. And then down below it has this nice table that gives us some key insights about our data, including the number of orders, total revenue, average order value, and then top selling product and more. It also has information down here as well, again, with…
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
-