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

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…

Contents