Beginner

4 Chapters · 64 Lessons

Essential Knowledge for Automating Tasks and Leaving Work Early

Laying the foundation for office programs, web scraping, and email automation

My Courses

Chapter 1

How to Automate Excel Tasks with Python

‌

Lessons

‌

How to Automate Repetitive Office Tasks

Introduction to Python Libraries for Office Automation

Python Library for Data Processing, Pandas

Manipulating Data with DataFrames

Calculate Summary Statistics with Pandas

Analyze Monthly Sales by Product Using Pandas

Fill-in-the-blank quiz

Automate Excel Tasks with Python

Exploring Key Methods of openpyxl

Efficiently Enter Data into an Excel File

How to Modify Cell Values Using Python Code

Formatting Fonts, Background Colors, and Borders

Adjusting Cell Width and Height

Formatting Columns

Visualizing Data with Charts

How to Use pandas and openpyxl Together

Multiple-choice quiz

Pandas and openpyxl Wrap-up

Chapter 2

How to automate repetitive PowerPoint and Word tasks using Python code

‌

Lessons

‌

How to Automate Repetitive PowerPoint Tasks

Adding Text Box and Text to Slides

Changing Font, Size, and Color of Text Formatting

Inserting and Adjusting Images on a Slide

Creating and Managing Tables in Slides

Inserting Excel Data into a Slide as a Table

Creating Charts and Visualizing Data with Python

Fill-in-the-blank quiz

Create Word Documents with Python Code

Adding and Formatting Paragraphs

How to Create Tables with Python Code

Inserting and Styling Images in Your Document

Adjusting Document Page Layout

Read Excel with openpyxl & Write to Word

Multiple-choice quiz

Challenge Yourself! Creating a Simple Table with python-docx

Chapter 3

Smart Data Collection through Web Crawling

‌

Lessons

‌

Repeated Data Collection with Web Crawling

Considerations When Conducting Web Crawling

Essential HTML Knowledge for Web Crawling

Essential CSS Knowledge for Web Crawling

Essential HTTP Knowledge for Web Crawling

Collecting Web Page Data with the requests Package

Parsing HTML with BeautifulSoup

Key Methods and Usage of BeautifulSoup

Regular Expressions for Web Crawling

Extracting Desired Information from Wikipedia

Fill-in-the-blank quiz

JavaScript and Dynamic Web Crawling

Basic Selenium Methods and Usage

Frequently Used Selenium Methods

Practical Examples of Using Selenium

Crawling US Stock Index with Selenium

Multiple-choice quiz

Coding Quiz - Web Scraping with Selenium

Chapter 4

Automating Email Sending

‌

Lessons

‌

The Technical Principles of Email Communication

Why Do We Need Email Automation?

Email Message Format and MIME

How to Send an Email Using Python Code

Fill-in-the-blank quiz

Sending Emails with Attachments

Sending Data from Excel via Email

How to Send Periodic Emails

Sending Weather Information via Email After Web Crawling

Multiple-choice quiz

Summary of Email Automation