Automate Excel using Python + ChatGPT-4o 🤯
Vložit
- čas přidán 13. 05. 2024
- 👉 DOWNLOAD MY EXCEL ADD-IN: pythonandvba.com/grafly
In this tutorial, I will show you how to use ChatGPT 4.0 to automate Excel tasks and create interactive charts. You'll learn to merge multiple workbooks and visualize data with PyEcharts, making your data processing more efficient. Perfect for anyone looking to enhance their Excel skills and streamline their workflow.
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: pythonandvba.com
📝 GitHub: github.com/Sven-Bo
⭐ Discord: pythonandvba.com/discord
📷 Instagram: / codingisfun_official
▶️ Subscribe: czcams.com/users/CodingIsFun?sub...
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: pythonandvba.com/resources
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
pythonandvba.com/coffee-donation
*Hope you got some inspiration for your own workflow. I just wanted to show you some features that were previously behind the OpenAI paywall.*
That said, if you want to create interactive charts even faster, directly from Excel, then check out my new Excel add-in 😉 ⤵
pythonandvba.com/grafly
Informative. Thanks for sharing 👍
My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️
10:00 - OpenAI releases new model ChatGPT-4o 🤖
10:01 - Sven releases a tutorial based on ChatGPT-4o 😎
🤣 Yeah, when I saw the OpenAI demo yesterday, I had to try it out and make a video about it 😬
hopefully they get everyone access as not everyone has it. rollout!!!!!
i need help in creating pivot table for my output summary of individual providers name and for all summary to in a single sheet can anyone help me please
Thank you for watching! Unfortunately, the question you asked is not related to the video content. If you have any questions or need help, I suggest you join my Discord channel at pythonandvba.com/discord . Just make sure to read the forum rules before posting any questions. Cheers, Sven ✌️
It’s not ChatGPT 4 point Oh, just 4 Oh
My bad - thanks for clarifying! Cheers, Sven ✌️
Title is a bit misleading. This is automating Python/Pandas. If you had shown using VBA code then it would have been more accurate.
Thank you for watching and providing your feedback. To be fair, this is what I mentioned at the end of the video. Essentially, you can continue with the prompting and perform other types of automation, such as sending HTML files via Outlook. Remember that with Python, you also have access to win32com.client, which VBA uses as well. This means you can perform any VBA automation using Python, except for native Excel user forms or workbook/worksheet change events. Cheers, Sven ✌️
@@CodingIsFun
In secured environment of big company, xlwings was the only package that could read and write Excel files in Python and even run VBA.
*EDIT:* I guess I know now what you meant. In the title and thumbnail, I did not include that it is about "Python". I have changed that. Thanks for the hint! 🙏
Waw! Im really scared from AI! Thinks are getting crazy advanced levels
It's true, AI is advancing rapidly! 🤯
I developed an AI assistant before, but after GPT-4o appeared, I felt a lot of pressure for him to really be all only all-powerful
i couldnt even get my api to work after hours. i hate all this technical bs
But I didn't even use the OpenAI API in this video 🤷♂️ Anyways, thanks for watching. Cheers, Sven ✌️