From the course: Microsoft 365 Copilot Quick Tips
Join today to access over 24,900 courses taught by industry experts.
Analyze Excel worksheet data with Copilot - Microsoft Copilot Tutorial
From the course: Microsoft 365 Copilot Quick Tips
Analyze Excel worksheet data with Copilot
- Instead of working with all of the various ribbon commands to analyze data in your worksheet, why not ask Copilot to help you with this? Now here we are, we're working in this H+ Sport product worksheet, and a couple of things I want to point out before we get started. You'll notice that there are several different product categories and many different items within those categories, and there's a little icon that pops-up next to the cell that's selected. This is one way for you to access Copilot, and then you can work with the menu that you have here. You can also go to the Home ribbon and select Copilot to launch the Copilot pane. We're going to use a prompt here now. We could prompt for something like, "How many product categories are there?" And it may look in this worksheet and the other worksheet that's part of this workbook to determine that for me. We're going to ask it to get the average price for a…
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.