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.

Automate tasks with VBA macros

Automate tasks with VBA macros

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

Start my 1-month free trial Buy for my team

Automate tasks with VBA macros

“

- [Instructor] Next up, I've got a really fun demo for you. We're going to talk about how you can use ChatGPT to Automate Tasks in Excel By Generating VBA Scripts and Macros. So for this demo, what I've got here is a list of some of the top earning movies of all time. It's stored in a macro-enabled Excel workbook, but you can see that it's a little bit messy, right. My row heights are all over the place. My column widths aren't fit properly, and basically my goal is to clean and polish this up. Maybe add some alternating row highlights with the goal of exporting this as a static PDF that I can share. Now, that's certainly possible to do manually or just take a few steps, but if this is something that I'm going to do again and again, it makes it a great candidate for VBA automation. So let's pop into ChatGPT. Let's describe exactly what we're looking for and see if it can produce AVBA script that we can use. Alright, so…

Contents