Automate Excel using Python + ChatGPT-4o 🤯
👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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.
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation
Пікірлер: 19
*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 👍
@CodingIsFun
Ай бұрын
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 😎
@CodingIsFun
Ай бұрын
🤣 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!!!!!
It’s not ChatGPT 4 point Oh, just 4 Oh
@CodingIsFun
Ай бұрын
My bad - thanks for clarifying! Cheers, Sven ✌️
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
@CodingIsFun
Ай бұрын
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 ✌️
Title is a bit misleading. This is automating Python/Pandas. If you had shown using VBA code then it would have been more accurate.
@CodingIsFun
Ай бұрын
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 ✌️
@kcell2042
Ай бұрын
@@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.
@CodingIsFun
Ай бұрын
*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
@CodingIsFun
Ай бұрын
It's true, AI is advancing rapidly! 🤯
@sheet-chat
Ай бұрын
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
@CodingIsFun
Ай бұрын
But I didn't even use the OpenAI API in this video 🤷♂️ Anyways, thanks for watching. Cheers, Sven ✌️