Learn Python with Comics · Office Automation Full Practical: Excel/Word/PPT/PDF/Email/Web Scraping All Covered

Course Introduction
This course uses comic illustration + practical-driven approach to guide zero-base students to systematically master all Python office automation skills. From programming environment setup, basic syntax and data structures, to Excel/Word/PPT/PDF read-write modification and style processing, then to file management, web data collection, browser automation, email sending/receiving and desktop mouse keyboard control, covering daily office high-frequency scenarios. Through chatbot, weather query, word frequency statistics, report generation, contract creation, movie PPT, website scraping, backend operation and many other fun practical exercises, let you say goodbye to repetitive labor and truly use code to free your hands.

Suitable Learners

1. Office clerks troubled by Excel/Word/PPT repetitive operations every day.
2. Administrative and financial staff who want to improve work efficiency and reduce manual errors.
3. Workplace newcomers with zero programming foundation who want to quickly get started with automation.
4. Operations and marketing personnel who need batch processing of files, data or emails.
5. Learners who want to use Python to improve competitiveness but fear traditional courses are too boring.

Learning Outcomes

1. Can independently write scripts to automate Excel reports and data.
2. Batch generate Word contracts, PPT presentations and PDF documents.
3. Achieve file organization, compression/decompression and scheduled task automatic execution.
4. Scrape web data, operate website backend, improve information acquisition efficiency.
5. Control mouse and keyboard, automatically complete repetitive desktop software operations.

Course Catalog:
01. 1Why Need Office Automation
02. 2Introduction to Programming-Install Anaconda-Use Virtual Environment
03. 3Operators-Data Types-Input and Output
04. 4[Mini Practice] Build a Chatbot
05. 5Boolean Type-Comparison Operators-Control Flow
06. 6Loops and Iterations
07. 7[Mini Practice] Get City Weather
08. 8Using Functions
09. 9Lists and Tuples
10. 10Dictionaries and Sets
11. 11[Mini Practice] Implement Word Frequency Counter
12. 12[Excel Automation] Read, Write and Modify Excel Data
13. 13[Excel Automation] Modify Excel Data and Styles and Read Large Excel Files
14. 14[Excel Automation Practice] Python Automated Excel Operation Generate Calendar
15. 15[Excel Automation] Pandas Simple Excel Operation
16. 16[Excel Automation] Modify + Filter + Sort Excel Data
17. 17[Excel Automation] Visualize Excel Data
18. 18[Excel Automation] Multi-table Joint Operation + Split Data + Statistical Calculation
19. 19[Word Automation] Create Word Document + Add Data
20. 20[Mini Practice] Auto Generate Data Analysis Report
21. 21[Word Automation] Modify Content + Understand Text Format + Understand Styles
22. 22[Mini Practice] Auto Generate 10,000-word Labor Contract
23. 23[PPT Automation] Create PPT + Insert and Read Data
24. 24[Mini Practice] Complete 250-page Movie PPT in 5 Seconds
25. 25[PDF Automation] Read PDF Content + Read Tables in PDF + Split and Merge PDF
26. 26[Mini Practice] Convert Website Content to PDF
27. 27[File Automation] File Path Differences + Absolute and Relative Paths + os Module Usage
28. 28[File Automation] shutil Module Usage + Compressed File Operation
29. 29[Mini Practice] Brute Force Crack Encrypted Compressed Files
30. 30[Web Automation] What is Browser + Website Content Structure + Client-Server Interaction Process
31. 31[Web Automation] Developer Tools + Browser Plugins
32. 32[Web Automation] requests Usage + BeautifulSoup Usage + XPath Usage
33. 33[Mini Practice] Scrape 250 Movies from Douban
34. 34[Web Automation] Website CAPTCHA + Cookies Usage
35. 35[Web Automation] Dynamic Web Pages + Selenium Introduction and Environment Configuration
36. 36[Web Automation] Selenium Basic Usage + Implicit and Explicit Waits + Window Permission Switch
37. 37[Mini Practice] Auto Operate Company Website Backend
38. 38[Email Automation] SMTP Protocol + Set Email + Send Email
39. 39[Email Automation] IMAP Protocol + Auto Receive Email + Monitor Key Emails and Send SMS Reminders
40. 40[After-class Mini Class] How to Run Scheduled Python Programs on Windows
41. 41[Desktop Automation] Control Mouse + Control Keyboard
42. 42[Mini Practice] Auto Delete WeChat Chat Messages