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

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…

Contents