Excel Automation Made Easy with Python and ChatGPT (don’t miss out…)
Language:
In this video, I’m sharing my experience with ChatGPT, an AI tool that helps you automate tasks in Python and Excel. I’ve been playing around with it over the past few weeks, and I have to say, it’s pretty impressive.
In the video, I’ll be demonstrating a couple of practical examples of how you can use ChatGPT to make your life easier. Specifically, I’ll be showing you how to use ChatGPT to replace certain phrases in multiple Excel files, save each worksheet in a workbook as a new workbook, and filter data in an Excel file by unique values.
For some examples, I’ll also be comparing the solution that ChatGPT gives me to the one I came up with in a previous tutorial. This way, you can see the differences and how ChatGPT’s solution stacks up.
📝 Resources:
- The code and files can be found here: https://github.com/Sven-Bo/excel-automation-with-chatgpt
- 1. Example – Find & Replace Values: https://youtu.be/Uyw9fjDKYQY
- 2. Example – Store values in a new wb: https://youtu.be/J-3UBaP2DfM
- 3. Example – Filter Excel data: https://youtu.be/RGR048I5ZDE
- 4. Example – Split ws into wb: https://youtu.be/DyfLlbbPNsc