Automate Everyday Tasks with Python: Files, Excel, Email & Web Scraping
Welcome, champion! π₯
You've mastered 0 of 85 lessons. Start your first lesson free β no signup needed.
About this course
Renaming a folder of files, merging branch spreadsheets, sending the same email with a different attachment and copying figures from a web page are tasks a short script can do in seconds. This online Python automation course on Abekus teaches how to write small, safe scripts for files and folders, CSV, JSON and Excel data, reports, email, web APIs, web scraping and scheduling, in short reading-card lessons each followed by an MCQ quiz.
Who this Python automation course is for
It is written for office workers, analysts, students and junior developers who spend hours on repetitive file, spreadsheet, email and web tasks. You should already know basic Python: variables, loops and functions. The course does not teach the language from zero. It starts with one script that renames every file in a folder and shows how to run it from the terminal. By the end you can write scripts that organise files, read and write Excel workbooks, produce reports, send and read email, call web APIs, scrape pages responsibly and run on a schedule.
Examples follow one setup: Python 3.12 or later, using the standard library first, including pathlib, shutil, csv, json, re, datetime, zoneinfo, smtplib, email, imaplib, argparse, logging and urllib.robotparser. Only three third-party packages are taught: openpyxl for Excel, requests for HTTP and beautifulsoup4 for HTML parsing, installed with pip into a virtual environment. Email examples use SMTP with an app password or OAuth, kept in environment variables. The course leaves out GUI automation with pyautogui, browser automation with Selenium or Playwright beyond naming them for JavaScript-rendered pages, pandas as a teaching stack, the Google Sheets API, Microsoft Graph, Outlook COM, logging in to scrape and CAPTCHA handling.
How the lessons work
Each lesson is a short set of reading cards on one module, function or practice, usually with a code example of a few lines and the output it prints, followed by a quiz of multiple-choice questions that often ask what a script will do. Lessons go from basics up: a first automation, then files and folders, text and data formats, Excel with openpyxl, reports and spreadsheet workflows, email, web requests and APIs, web scraping, scheduling and reliability, and finally comparisons and worked cases. You move at your own pace.
MCQ practice vs video courses for Python automation
Video courses on Udemy, Coursera or freeCodeCamp are a good choice if you want to watch someone type a script from start to finish. This course is built for a different job: a short explanation followed straight away by questions about real code, such as what data_only=True returns for a workbook Excel has never calculated, why a CSV file opened without newline='' can show blank rows, which port goes with STARTTLS, what happens to a request that has no timeout, or what find() returns when nothing matches. Automation scripts fail on details like these, and predicting them question by question saves debugging time later. Many learners use both: a video for a first walkthrough, and questions to make the details stick.
Common Python automation mistakes
The course corrects these directly:
- Expecting openpyxl to recalculate formulas when it saves. It never calculates; Excel does that when the file is opened.
- Trying to open an old .xls file with openpyxl. It reads and writes the .xlsx family only.
- Assuming requests has a default timeout. A request does not time out unless you pass timeout.
- Putting a Gmail account password in an SMTP script. Use an app password, which needs 2-Step Verification, or OAuth.
- Using STARTTLS on port 465. Port 465 is TLS from the start; port 587 uses STARTTLS.
- Treating robots.txt as legally binding everywhere. It is a crawler convention; a site's terms of service and the law apply separately.
- Deleting or moving files without a dry run. Print what the script would do first.
Best way to learn Python automation
Pick one task you repeat every week and write the smallest script that does it. Break the task into steps, run it as a dry run that only prints, then add logging and handle errors for each item so one bad file does not stop the rest. The last part of the course is built around the choices you meet on the way: openpyxl versus pandas for Excel, scraping versus an official API, smtplib versus an email service API, when a script needs a schedule and when a spreadsheet formula is enough, applied to a monthly sales report from branch files, invoice files renamed and filed, a daily price tracker with email alerts and attendance sheet consolidation.