Excel Automation Made Easy with Python and ChatGPT (don’t miss out…)
62.7 هزار بار بازدید -
2 سال پیش
-
👉 Explore All My Excel
👉 Explore All My Excel Solutions: https://pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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-auto...
1. Example – Find & Replace Values: Find & Replace Values in Multiple Exc...
2. Example – Store values in a new wb: Save Excel Values From Each Worksheet...
3. Example – Filter Excel data: Create and Distribute Excel Files usi...
4. Example – Split ws into wb: Python: Split Each Excel Sheet Into S...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-tem...
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: LinkedIn: sven-bosau
📸 Instagram: Instagram: codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 Discord: https://pythonandvba.com/discord
📬 Contact: https://pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ https://pythonandvba.com/coffee-donation
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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-auto...
1. Example – Find & Replace Values: Find & Replace Values in Multiple Exc...
2. Example – Store values in a new wb: Save Excel Values From Each Worksheet...
3. Example – Filter Excel data: Create and Distribute Excel Files usi...
4. Example – Split ws into wb: Python: Split Each Excel Sheet Into S...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-tem...
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: LinkedIn: sven-bosau
📸 Instagram: Instagram: codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 Discord: https://pythonandvba.com/discord
📬 Contact: https://pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ https://pythonandvba.com/coffee-donation
2 سال پیش
در تاریخ 1401/10/18 منتشر شده
است.
62,765
بـار بازدید شده