Automate Boring Office Tasks with ChatGPT and Python 

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Tired of spending hours on tedious office tasks? In this video, I'll show you how to use ChatGPT and Python to automate some of those boring tasks. We'll be looking at automating Outlook, creating PowerPoint presentations, generating charts from Excel data, and manipulating PDFs.
First up, we'll go over how to use ChatGPT and Python to automate tasks in Outlook like sending emails to a list of recipients pulled from an Excel file. Then we'll move on to using ChatGPT and Python to create slides and add text and images to them for PowerPoint presentations.
Next, we'll look at how to use ChatGPT and Python to create interactive charts based on data from an Excel file. And lastly, we'll cover how to use ChatGPT and Python to automate PDF tasks like merging multiple documents.
As a bonus, we'll also take a look at how to use ChatGPT to write emails for you so you don't have to.
Overall, this video will give you a good idea of how you can use ChatGPT and Python to automate some of those repetitive tasks that take up so much of your time.
🌍 𝗟𝗜𝗡𝗞𝗦:
▶ The code and files can be found here: github.com/Sven-Bo/automate-o...
▶ The website with links to all ChatGPT prompts: automate-office-chatgpt.strea...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 - Intro
00:33 - 1. Example: Distribute Excel files with Outlook
03:21 - 2. Example: Automate PowerPoint
06:13 - 3. Example: Create an interactive chart from Excel data
07:07 - 4. Example: Merge PDFs
08:44 - 5. Example: Write Emails
09:14 - 6. Example: Create a Streamlit website
09:45 - Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】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