From the course: Excel with Copilot: AI-Driven Data Analysis

Challenge: Enhancing a table with Copilot

From the course: Excel with Copilot: AI-Driven Data Analysis

Challenge: Enhancing a table with Copilot

“

(upbeat music) - [Instructor] Great job on taking additional steps in this exciting journey with Copilot. It's time for another knowledge check. The exercise file for this one is 02_04_ch02_challenge, which contains the same product sales data set as the challenge from chapter one. Let's build on the work you accomplished with that data and with Copilot. First, I would like you to add a total sales column that calculates the product of price and quantity. Although this field was part of the last chapter's dataset, it's probably best as a calculated field anyway. After you've added the calculated column, proceed to hide the price and quantity columns in the worksheet. Next, use Copilot to count the number of products in each category. Here's a tip, requesting the distribution for the relevant column is an effective approach. The final task is to arrange the dataset by total sales in descending order. Good luck, and remember, you're always welcome to experiment with your own queries and methods as you explore the data further. I'll catch up with you in the next video.

Contents