From the course: Excel and ChatGPT: Data Analysis Power Tips

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Produce step-by-step Excel tutorials

Produce step-by-step Excel tutorials

From the course: Excel and ChatGPT: Data Analysis Power Tips

Start my 1-month free trial Buy for my team

Produce step-by-step Excel tutorials

“

- [Instructor] Alright, so for this next demo, what I want to do is see if we can use ChatGPT to generate clear step-by-step instructions or guidelines for conducting some sort of analysis in Excel. I'm going to walk through two examples here, starting relatively simple with a basic PivotTable, and then we're going to try something a bit more advanced by creating a relational data model using Power Pivot. And what I want to see is if ChatGPT can guide us through this process as if we were a beginner user without much familiarity with these tools. So for the first demo, what we've got here is a basic sample of product orders. Got order IDs in column A, product names in B, quantity, price, revenue, and a categorical field called Order Size, which is based on the quantity purchased. Now, suppose we wanted to calculate the average revenue for each order size specifically. This is something that's very easy to do with a…

Contents