From the course: Microsoft Copilot for Excel

Unlock this course with a free trial

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

Analyzing data

Analyzing data

From the course: Microsoft Copilot for Excel

Start my 1-month free trial Buy for my team

Analyzing data

“

- [Instructor] Time to move on to the last of co-pilot's basic features and likely the one that most people are excited about, just analyzing data. So the idea here is that you can ask Copilot to analyze your data and answer any questions by using natural language. So you can directly ask it something like, how many active employees do we have by recruitment source? And Copilot will take a look at your data, analyze it, and then answer your question by showing you the supporting data. So here you can see that it returns what looks like a pivot table with the number of active employees by recruitment source sorted from top to bottom. So we can clearly see that Indeed and LinkedIn are the ones where we get most of our employees from. And if we add that to a new sheet, well then you'll see that in this case, it's not actually a pivot table behind the scenes, but a crazy dynamic array formula instead. Now it gets the job done, but it is quite surprising that this is the route that Copilot…

Contents