Refer the book (in Chinese) 《让Python遇上Office - 从编程入门到自动化办公实践》"When Python Meets Office - From Entry Programming to Office Automation Practice", teach in English language, let you familiar the related Python library dealing with Excel (openpyxl), Word (python-docx), PowerPoint (python-pptx) and PDF (pypdf2 or pypdf3), demo and guide you not only the usage of those libraries, but also practice the actual exercise in those variable office components.
After the course, you'll be confidently choose the right "tool" in proper scenario, and improve your office automation productivity.
The book has 10 chapters in total, divided into 3 parts: The first part (Chapter 1~5) includes the basic knowledge of getting started with Python from scratch (data types, functions, classes and objects, catching exceptions, file operations, management modules, etc.); Chapter 1 The second part (Chapter 6~9) focuses on operating office documents and introduces how to use Python code to process Word, Excel, PPT, and PDF documents to realize document office automation; the third part (Chapter 10) is the advanced part. It involves desktop automation, sending emails, network requests, scheduled tasks, GUI, packaging programs, etc., which can help readers further improve work efficiency.
The course is focusing on show you how to learn by doing! I do hope you can learn new skills as well as feel fun during the journey! Good luck!