From the course: Enhancing Excel with Generative AI Tools
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Challenge: Troubleshooting and integration
From the course: Enhancing Excel with Generative AI Tools
Challenge: Troubleshooting and integration
(bright electronic music) - [Instructor] In this Challenge, you'll put your skills to the test by first troubleshooting Excel formulas in your workbook, and then conducting preliminary analysis to answer questions directly within the workbook. Let's open the exercise file named chapter-3-challenge. You'll see a table labeled Sales. In the last column, Total Sales, a colleague has tried to calculate Total Sales based on Units Sold, Unit Price and the Discount Rate, however, your manager suspects these calculations are off. Your first task is to troubleshoot the formula and confirm it's working accurately. Next, let's leverage generative AI to help create a formula that calculates total sales for March, 2024 in cell H3. If you already have a formula in mind, consider submitting it for suggestions on possible improvements or alternatives, or you can even ask AI to guide you in crafting an entirely new formula from scratch. This is a great opportunity to uncover new techniques and expand…
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.