From the course: Excel Copilot: Working with Formulas and Functions
Join today to access over 25,500 courses taught by industry experts.
Challenge: Creating a pricing calculation with Copilot
From the course: Excel Copilot: Working with Formulas and Functions
Challenge: Creating a pricing calculation with Copilot
(upbeat music) - [Instructor] All right, it's time for you to prep a data set for some hands-on work with Copilot's formula and function assistance. For this task, you'll use the pricing calc challenge sales data set in your exercise files. First things first, I'd strongly recommend converting this data into a table and giving the columns clear, AI-friendly names to keep things smooth. Next up, you'll create a total sales column. Calculate this by multiplying the units sold by the unit price, then factoring in the discount to get the final amount. Next, you'll tackle something a little trickier with text. The category column is stuck in all uppercase, which is a bit of an eyesore. See if Copilot can help you transform it into proper case to make it look cleaner and more readable. Finally, push Copilot to write a formula that calculates the average number of units sold, but only for transactions where the discount is greater than 20%. This should be a fun challenge to test its skills…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
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.