The Complete Python Automation Course

1. Environment Setup

   3 lessons

   1. Installing Python
   2. Installing Jupyter Notebook
   3. Installing PyCharm

2. Python Basics

   18 lessons

   1. Creating a Jupyter Notebook
   2. Indentation in Python
   3. Variables
   4. Lists
   5. Loops
   6. Flow Control
   7. Python Operators
   8. Functions
   9. Reading from Files
   10. Writing to Files
   11. Handling User Input
   12. Type Conversion
   13. Strings
   14. Floats
   15. Tuples
   16. Compiling and Running Python Scripts
   17. Project: Todo List
   18. Python Basics Quiz

3. Excel Documents Automation

   6 lessons

   1. Reading Excel Files via “openpyxl”
   2. Reading Excel Files via "pandas”
   3. Writing & Updating Excel Data
   4. Formatting Excel (styles, colors, fonts)
   5. Automating Reports (summaries, totals)
   6. Excel Automation Quiz

4. PDF Documents Automation

   3 lessons

   1. Reading Data from PDFs
   2. Merging Multiple PDFs
   3. Generating PDF Reports from Data

5. Web Automation

   5 lessons

   1. Browser Control with Selenium
   2. Finding Elements
   3. Interacting with Elements
   4. Scraping Data from Pages
   5. Downloading Files

6. File & Folder Automation

   3 lessons

   1. Creating, Moving & Deleting Files
   2. Monitoring Folders
   3. Zipping & Unzipping Files

7. Email Automation

   3 lessons

   1. Sending Emails with SMTP
   2. Reading Emails with IMAP
   3. Scheduled Email Reports

8. GUI Automation

   2 lessons

   1. Desktop Automation with PyAutoGUI
   2. Window & Application Control

9. Capstone Project: Personal Finance Reported

   5 lessons

   1. Project Folder Structure
   2. Reading & Summarizing the Data
   3. Generating the PDF Report
   4. Emailing the Report to Yourself
   5. Testing the Project