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

Challenge: Copilot for data analysis

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

Challenge: Copilot for data analysis

“

(upbeat music) - [Narrator] This chapter focused on maximizing the use of Copilot for analyzing your data with visualizations, conditional formatting, and more. For this challenge I've provided you with a new data set, your objective is to analyze it with Copilot's assistance. The exercise file for this challenge is named 03_04_ch03_challenge. Begin by examining the average review column. Determine how closely each category approaches a five star rating by applying a data bar conditional format. Next, you'll analyze the potential correlation between average review and return percentage. Instruct Copilot to create a visualization for this comparison and then assess the outcome. Moving on to revenue analysis, I'd like you to chart revenue over time to identify any patterns or seasonal trends. Ask Copilot to generate this visual. Finally, let's delve into sales performance by category. See if you can find the leading product category by revenue. Work through these tasks and feel free to explore any other questions that pique your interest. I'll meet you over in the next video.

Contents