คอร์สปฏิบัติ Automation สำนักงานด้วย Python สไตล์การ์ตูน|เรียนเขียนโปรแกรมสนุกจากศูนย์ เพิ่มประสิทธิภาพครบทุกสถานการณ์ จัดการรายงานทีละชุด ปลดมือ

Course Introduction

Most people's inefficient overtime at work is never about lacking ability - it's about doing repetitive mechanical work day after day: organizing Excel reports, editing Word docs, making PPTs, merging/splitting files, repeating web operations, sending and tallying emails. This flood of trivial repetitive work eats all your time, is inefficient and error-prone, and costs you promotion and raises. Traditional programming learning is dry and obscure, its code cryptic, which scares off zero-basis office workers who want efficiency tools but don't know where to start.

This comic-style Python office-automation course breaks the dry traditional model, teaching through fun, easy comics, dropping complex theory and focusing on practical workplace application, tailor-made for zero-basis office workers. No rote memorization of code, no professional programming background needed - ordinary people can quickly master Python core skills, letting the computer take over all repetitive work for efficient office work and goodbye to useless overtime.

The biggest feature is fun comic teaching + pure hands-on landing: easy to understand, dense with value, every knowledge point maps to a real workplace scenario you can apply immediately. It thoroughly solves pain points of too much overtime, low efficiency, repetitive work, error-prone reports and a sluggish pace, replacing mechanical labor with technology and greatly lifting office efficiency.

Course Content

01.1 Why you need office automation

02.2 Intro to programming - install Anaconda - use a virtual environment

03.3 Operators - data types - input and output

04.4 [mini project] build a chatbot

05.5 Boolean type - comparison operators - control flow

06.6 Loops and iteration

07.7 [mini project] get city weather

08.8 Using functions

09.9 Lists and tuples

10.10 Dictionaries and sets

11.11 [mini project] build a word-frequency counter

12.12 [Excel automation] read/write and modify Excel data

13.13 [Excel automation] modify Excel data/style and read large Excel files

14.14 [Excel automation project] Python auto-operates Excel to make a calendar

15.15 [Excel automation] Pandas simple Excel operations

16.16 [Excel automation] modify + filter + sort Excel data

17.17 [Excel automation] visualize Excel data

18.18 [Excel automation] multi-table joins + split data + aggregate

19.19 [Word automation] create Word docs + add data

20.20 [mini project] auto-generate a data-analysis report

21.21 [Word automation] modify content + understand text format + styles

22.22 [mini project] auto-generate a thousand-labor contracts

23.23 [PPT automation] create PPT + insert and read data

24.24 [mini project] finish a 250-page movie PPT in 5 seconds

25.25 [PDF automation] read PDF content + read PDF tables + split/merge PDFs

26.26 [mini project] turn website content into PDF

27.27 [file automation] path differences + absolute/relative paths + os module

28.28 [file automation] shutil module + archive operations

29.29 [mini project] brute-force an encrypted archive

30.30 [web automation] what is a browser + website structure + client-server interaction

31.31 [web automation] developer tools + browser plugins

32.32 [web automation] requests + BeautifulSoup + XPath

33.33 [mini project] scrape Douban's top 250 movies

34.34 [web automation] website captchas + Cookies

35.35 [web automation] dynamic pages + Selenium intro and environment setup

36.36 [web automation] Selenium basics + implicit/explicit waits + window switching

37.37 [mini project] auto-operate a company website backend

38.38 [email automation] SMTP protocol + set up mailbox + send mail

39.39 [email automation] IMAP protocol + auto-receive mail + monitor key emails and SMS alerts

40.40 [after-class] how to schedule Python programs on Windows

41.41 [desktop automation] control mouse + control keyboard

42.42 [mini project] auto-delete WeChat chat messages

Suitable For

✅ Office workers bogged down daily by reports, docs and file sorting, with frequent overtime

✅ Zero-basis beginners who want coding efficiency but fear it's dry, hard and unusable

✅ Admin, HR, finance, operations and clerical staff who handle office files heavily

✅ Office workers needing batch data, reports andmaterial organization

✅ Advanced learners wanting core workplace skills, personal competitiveness, and fast promotion/raises

What You'll Learn

1. Master Python core coding easily from zero, escaping 'hard, unreadable, unusable' programming

2. Achieve full Excel automation: batch data, reports and charts, goodbye to manual tallying

3. Master full Word/PPT/PDF processing to generate reports, contracts and decks in one click

4. Handle batch files, archive decryption and path management, organizing huge office materials

5. Master web scraping and backend auto-operation to free hands and save manual time

6. Achieve smart email monitoring and auto send/receive, integrating office workflows

7. Master scheduled tasks and desktop automation to lift office efficiency on all fronts

8. Unlock core workplace efficiency skills, escape useless overtime, boost competitiveness and promotion

*Note: this article is only an introduction and makes no income promise. Results vary by person and depend on your own effort and hands-on practice. Use what you learn reasonably, and strictly follow platform rules and relevant laws.*