Automate Excel using Python + ChatGPT-4o 🤯

Подписаться 95 тыс.

Просмотров 18 тыс.

50% 1

👉 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: ru-vid.com?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

Опубликовано:

13 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@CodingIsFun Месяц назад

*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

@chandrimad5776 27 дней назад

Informative. Thanks for sharing 👍

@CodingIsFun 26 дней назад

My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️

@armantech5926 Месяц назад

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 😬

@keithsmith4806 Месяц назад

hopefully they get everyone access as not everyone has it. rollout!!!!!

@user-zi3gg2wq9x 11 дней назад

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 11 дней назад

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 ✌️

@shuntera Месяц назад

It’s not ChatGPT 4 point Oh, just 4 Oh

@CodingIsFun Месяц назад

My bad - thanks for clarifying! Cheers, Sven ✌️

@intotheshred Месяц назад

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! 🙏