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.
𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
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
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:25 – 1. Example: Find & replace values
01:50 – 2. Example: Store values in a new wb
03:30 – 3. Example: Filter Excel data
04:53 – 4. Example: Split ws into wb
06:19 – 5. Example: Automate PowerPoint
07:45 – Conclusion
08:37 – Outro
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
Website: https://pythonandvba.com
GitHub: https://github.com/Sven-Bo
⭐ Discord: https://pythonandvba.com/discord
▶️ Subscribe: https://youtube.com/c/CodingIsFun?sub_confirmation=1
𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
Get it here: https://pythonandvba.com/mytoolbelt
𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: https://pythonandvba.com/resources
𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲
If you want to support this channel, you can buy me a coffee here:
https://pythonandvba.com/coffee-donation
Source