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:
The website with links to all ChatGPT prompts:
โญ ๐ง๐๐ ๐๐ฆ๐ง๐๐ ๐ฃ๐ฆ:
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
โผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธโผ๏ธ
๐๐ข๐ก๐ก๐๐๐ง ๐ช๐๐ง๐ ๐ ๐:
๐ Website:
๐ GitHub:
โญ Discord:
โถ๏ธ Subscribe:
๐ ๐๐ฅ๐๐ ๐๐
๐ฐ๐ฒ๐น ๐๐ฑ๐ฑ-๐ถ๐ป ๐๐ผ ๐ฏ๐ผ๐ผ๐๐ ๐๐ผ๐๐ฟ ๐ฝ๐ฟ๐ผ๐ฑ๐๐ฐ๐๐ถ๐๐ถ๐๐
Get it here:
๐ ๐ฅ๐ฒ๐๐ผ๐๐ฟ๐ฐ๐ฒ๐ ๐ณ๐ผ๐ฟ ๐น๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด ๐ฉ๐๐ & ๐ฃ๐๐๐ต๐ผ๐ป
Check out my recommendations:
โ ๐๐๐ ๐บ๐ฒ ๐ฎ ๐ฐ๐ผ๐ณ๐ณ๐ฒ๐ฒโ
If you want to support this channel, you can buy me a coffee here:
