Automate Excel Files with Python OpenPyXL

Bring the power of Python to your Excel spreadsheets. Automate your Excel tasks with Openpyxl.

Learn Excel automation from scratch.

Hands On Lectures Including:

Learn how to run Openpyxl on the web, which means no software installation required.

Learn simple sheet manipulate tasks with Openpyxl, including making your first workbook automatically.

Work with tables to automate your worksheets.

Learn how to format cells with Python.

Build 2D charts with Python and data.

Build an employee timelog project to put in your portfolio.

Learn how to scrape the web and save it to an Excel file.

And much more!

A SCHOOL YOU CAN TRUST

  • Lifetime access that never expires
  • Project-based curriculum to superboost your portfolio
  • Graduation certificate for every course
  • Absolute beginner-friendly
  • New courses every month
  • Efficient lectures with step by step explanations
  • Relevant industry topics 8 years of award-winning course delivery
  • 700,000 students in 186 countries
  • Learn with free tools and affordable courses

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.


Course Curriculum


  Intro to Mammoth Interactive
Available in days
days after you enroll
  01 Introduction to the Course
Available in days
days after you enroll
  02 Use OpenPyXL and Sheets
Available in days
days after you enroll
  03.01 Worksheet Tables
Available in days
days after you enroll
  03.02 Format Cells
Available in days
days after you enroll
  04 Build 2D Charts
Available in days
days after you enroll
  05 Project - Employee Timelog
Available in days
days after you enroll
  07 Update a Spreadsheet
Available in days
days after you enroll
  08 More Chart Types
Available in days
days after you enroll
  09 Web Scraping
Available in days
days after you enroll

Your Instructor


Alexandra Kropf
Alexandra Kropf

Alexandra Kropf is Mammoth Interactive's CLO and a software developer with extensive experience in full-stack web development, app development and game development. She has helped produce courses for Mammoth Interactive since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.

Over 12 years, Mammoth Interactive has built a global student community with 4 million courses sold. Mammoth Interactive has released over 350 courses and 3,500 hours of video content.

Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you.


Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!