From the course: Microsoft 365 Copilot Quick Tips
Join today to access over 25,600 courses taught by industry experts.
Analyze Excel worksheet data with Copilot
From the course: Microsoft 365 Copilot Quick Tips
Analyze Excel worksheet data with Copilot
Instead of working with all the various ribbon commands to analyze data in your worksheet, why not ask Copilot to help you with this? Here we are. We're working in the H Plus Sport Product Worksheet, and there's two things I want to point out to you before we get started. Notice that there are several different product categories over here in column B that's labeled Product Category. We have Fitness, Mineral Water, Supplements, and then within column C, which is labeled Item, there are several different products that are part of those product categories. Now, to get to Copilot, we're gonna go to the Home ribbon. On the right side of the ribbon, we'll select Copilot. That launches the Copilot chat pane. Something new here to point out. Notice just above the area where you enter your prompt to Copilot, it says Allow Editing. This is the default setting, and if I select this arrow, we have a menu to choose Allow Editing, which means that Copilot can make edits to this worksheet on your…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.