From the course: Enhancing Excel with Generative AI Tools

Unlock this course with a free trial

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

Solution: Troubleshooting and integration

Solution: Troubleshooting and integration

From the course: Enhancing Excel with Generative AI Tools

Start my 1-month free trial Buy for my team

Solution: Troubleshooting and integration

“

(upbeat music) - [Instructor] All right, fantastic work. Let's explore how we can leverage ChatGPT to enhance our formula accuracy. To kick things off, I'm going to ask ChatGPT. I need help calculating the total sales after discount, but my current formula seems off. It looks like this. We have the formula here. You can get this entire prompt in the download file in your exercise folder. I'll run the prompt here and ChatGPT will return a new formula for us to try. We'll go ahead and copy that and head back to the workbook. I'm back in Excel. Let's copyright over this current sales formula with our new one. And these numbers definitely look more accurate here. Next, let's shift to a more theoretical question about formulas. So here we want to find total sales for March, 2024. I'm going to see if ChatGPT can write this formula for us from scratch. I'll head back to ChatGPT and let's paste in our prompt here. How would I sum the total sales for March, 2024 based on the Date column? My…

Contents