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

  • @CodingIsFun
    @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
    @chandrimad5776Ай бұрын

    Informative. Thanks for sharing 👍

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

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

  • @armantech5926
    @armantech5926Ай бұрын

    10:00 - OpenAI releases new model ChatGPT-4o 🤖 10:01 - Sven releases a tutorial based on ChatGPT-4o 😎

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

    🤣 Yeah, when I saw the OpenAI demo yesterday, I had to try it out and make a video about it 😬

  • @keithsmith4806
    @keithsmith4806Ай бұрын

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

  • @shuntera
    @shunteraАй бұрын

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

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

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

  • @user-zi3gg2wq9x
    @user-zi3gg2wq9xАй бұрын

    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

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

  • @intotheshred
    @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

    @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

    @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

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

  • @hamadalshehhi9872
    @hamadalshehhi9872Ай бұрын

    Waw! Im really scared from AI! Thinks are getting crazy advanced levels

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

    It's true, AI is advancing rapidly! 🤯

  • @sheet-chat

    @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

  • @finalfan321
    @finalfan321Ай бұрын

    i couldnt even get my api to work after hours. i hate all this technical bs

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

    But I didn't even use the OpenAI API in this video 🤷‍♂️ Anyways, thanks for watching. Cheers, Sven ✌️