EMFADCourses
Basket
Instant access by email once payment is confirmed14-day refundSecure checkoutSupport by email, phone and WhatsApp

Programming and Software Development

Python for Automation

Use Python to automate repetitive office and data work, from files and spreadsheets to reports, emails, web data and scheduled pipelines that run on their own.

Level
Intermediate
Format
Written, self-paced
Length
About 6 hours
Lessons
15
Modules
4
Certificate
Yes, verifiable
Last updated
October 2026

About this course

Use Python to automate repetitive office and data tasks: renaming files, cleaning spreadsheets, generating reports, sending emails and pulling data from websites and APIs.

Self-paced written course: text lessons, practical exercises, module quizzes and a final project, delivered online. No video and no live tutor.

What you will learn

  • Identify tasks worth automating and estimate their payback
  • Organise automation projects with virtual environments, pathlib and command-line arguments
  • Read, clean, combine and write Excel and CSV data with openpyxl and pandas
  • Generate Word and PDF reports with charts automatically
  • Collect data from web APIs and websites responsibly, and send emails with attachments
  • Run reliable scheduled scripts with logging, error handling and failure alerts

Curriculum

Module 1Automation Foundations4 lessons
  1. 1Spotting Tasks Worth Automating4 min read Free preview
  2. 2Setting Up Projects and Virtual Environments3 min read
  3. 3Working with Files and Folders Using pathlib3 min read
  4. 4Command-Line Arguments for Reusable Scripts3 min read
  5. QuizModule quiz, 4 questions
Module 2Automating Spreadsheets and Documents4 lessons
  1. 5Reading and Writing Excel Files with openpyxl3 min read
  2. 6Cleaning and Combining CSV Data with pandas3 min read
  3. 7Generating Word and PDF Reports4 min read
  4. 8Creating Charts Automatically3 min read
  5. QuizModule quiz, 4 questions
Module 3Automating the Web and Communication4 lessons
  1. 9Calling Web APIs with requests3 min read
  2. 10Responsible Web Scraping with Beautiful Soup3 min read
  3. 11Sending Emails and Attachments from Python3 min read
  4. 12Working with Dates, Times and Schedules3 min read
  5. QuizModule quiz, 4 questions
Module 4Reliable Automation3 lessons
  1. 13Logging and Error Handling for Scripts4 min read
  2. 14Scheduling Scripts with Task Scheduler and cron4 min read
  3. 15Course Project: Automated Weekly Report Pipeline3 min read
  4. QuizModule quiz, 4 questions

Final project

Automated Weekly Report Pipeline. A practical brief with ordered steps, what to produce and how to check your own work. You confirm it in your learner area.

Who it is for

  • Office professionals who spend hours on repetitive computer tasks
  • Analysts who prepare the same reports every week or month
  • Developers who want practical automation patterns for business work

Not for you if you are completely new to the subject. Start with a beginner course in programming and software development first.

Requirements

  • Python 3 installed on Windows, macOS or Linux
  • Working knowledge of Python variables, loops and functions
  • Permission to install packages with pip and an email account you may use for testing

What is included

  • 15 written lessons
  • 15 practical exercises
  • 4 module quizzes
  • A final project
  • Certificate of completion with a verification code
  • Lifetime access to what you buy

Questions about this course

What do I need before I start?

Python 3 installed on Windows, macOS or Linux. Working knowledge of Python variables, loops and functions. Permission to install packages with pip and an email account you may use for testing.

What device do I need?

A phone, tablet or computer with a modern web browser and an internet connection. Lessons are written, so they work on slow connections.

How long do I have access?

Lifetime access to the full course or to any module you buy. All Access and Teams give 12 months of access to every course.

Can I get a refund?

Yes: a full refund within 14 days of purchase if you have completed less than 30% of the course (or of the module, for a single module). Read the refund policy.

Should I buy a module or the full course?

A module (USD 10) unlocks that module's lessons and quiz. The full course (USD 59) unlocks everything and leads to the certificate. If you buy modules first, each one you own is credited at USD 10 when you buy the full course.

Which currency will I pay in?

US dollars (USD). Prices include all taxes where applicable. Your bank may apply its own conversion fee. Card payment is being set up with our bank. After you place your order we email you payment instructions within one working day; your access starts as soon as payment is confirmed.

Programming and Software Development learning path

All 13 open courses in this subject for USD 359. Bought separately they cost USD 607, so you save USD 248.

See the path

More in Programming and Software Development.

All programming and software development courses

USD 59Full course