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

Unlock the full course today

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

The Canvas interface

The Canvas interface

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

Start my 1-month free trial Buy for my team

The Canvas interface

“

- [Presenter] All right, for this next demo, let's take a quick look at the new canvas feature, which is great for collaborative writing or editing code. And, in this case, we'll pick up where we left off in our last demo where we analyzed multiple CSV files for our fictitious electronics retailer. And, remember, we wrapped up that analysis by visualizing average delivery times by year. So now suppose I want to drill into the code behind this portion of the analysis. There are a couple of ways that I could do this with canvas. I could either use this Edit in canvas button using this icon here, or I could drill into the Tools, select Canvas, and enter a prompt like, "Please summarize the code you used "for the delivery time analysis." And when I submit that prompt, you'll see that ChatGPT is going to start producing code, and then it's automatically going to trigger this canvas interface here. And it's writing out, line by line, the exact code that it used to produce that portion of…

Contents