课程: Excel with Copilot: AI-Driven Data Analysis

Solution: Enhancing a table with Copilot

课程: Excel with Copilot: AI-Driven Data Analysis

Solution: Enhancing a table with Copilot

“

(electronic music) - [Instructor] Welcome back. This challenge was centered on using Copilot to facilitate initial steps of data manipulation. Let's proceed with the exercise file named, 02_05_ch02_challenge. The first step is to generate a sales column. I'll instruct Copilot via the prompt guide to add a Total Sales column that multiplies price by quantity. Copilot generates a formula, price times quantity, let's insert that into our table. Next, I no longer need to view the quantity and price columns, so I will hide them from my worksheet. Now in this case, it looks like Copilot is having trouble doing this. Manually, you could try another prompt. Let's see what I have here, "Hide the quantity column." I will try to do this one at a time and see if that helps. I did use the word columns instead of column. We'll see if that affects its results here. Okay, the quantity column is now hidden. So in a case like this, when you're having issues with Copilot fulfilling your request, try to break it down into individual steps. So I'm going to go ahead and do that again. "Hide the price column," singular, and it looks like breaking that down into individual steps was enough for Copilot to understand. Okay, let's continue on. My next goal is to count the number of products in each category. I'll direct Copilot to generate a visualization, showing the category distribution. This results in a bar chart that clearly shows there are more electronics, products and home goods, and if you'd like to insert this into your workbook, you can do so with "Add to a new sheet." I'll continue on here and sort the data. Let's sort by total sales in descending order. Very good, our data is now much easier to understand and we've done some initial exploration. Did you achieve similar results to mine or did you find any other interesting insights? In any case, nice work using Copilot for data profiling and exploration. Through this exercise, you're now ready to progress to the next phase of analysis, all thanks to the assistance of Copilot.

内容