From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution: Intelligence and interpretation of data

Solution: Intelligence and interpretation of data

From the course: Copilot in Excel: AI-Powered Financial Planning & Analysis

Start my 1-month free trial Buy for my team

Solution: Intelligence and interpretation of data

“

(upbeat music) - [Instructor] In this challenge, you were tasked with analyzing and interpreting online sales data for Red30 Tech. Because you were pressed for time, you decided to make use of the AI-powered tools within Excel, specifically Copilot and Analyze Data. Now, I'm curious to know where did you find Copilot to be the best tool and where did you find Analyze Data to be the best tool? Now allow me to show you my suggestions as to how you might solve these challenges. First, you are tasked with determining the total sales by month for business customers. What I'm going to do is go to my home ribbon, go all the way over here to Copilot, and let's start prompting. First, I'm going to ask Copilot, "What are total sales by month for business customers?" Well, that was easy. When I prompted what are total sales by month for business customers, Copilot responded by saying order total by year and month of order date for customer type business result in this pivot table. If I want, I…

Contents