Limited time · 90% off Premium Membership - claim $199 deal →
For Teams For Libraries Sign in
EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Automate Excel Files with Python OpenPyXL
Mammoth Club All levels 10 sections 51 lectures

Automate Excel Files with Python OpenPyXL

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

Created by John Bura
01
Skill level
All levels
02
Sections
10
03
Lectures
51
04
Instructor
John Bura
What's inside

This course includes.

✓
10
Sections
✓
51
Lectures
✓
51
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

10 sections · 51 lectures
+ 01 Introduction to the Course 3 lectures
01.00 Course Overview Locked
01.01 Run Openpyxl on the Web Locked
01 Source Files Locked
+ 02 Use OpenPyXL and Sheets 12 lectures
02.01 Make A Workbook Locked
02.02 Save A Workbook Locked
02.03 Read A Workbook Locked
02.04 Work With Rows And Columns Locked
02.05 Use A Formula Locked
02.06 Use Dates Locked
02.07 Merge And Unmerge Cells Locked
02.08 Fold A Range Locked
02.09 Make A New Sheet Locked
02.10 Copy Data To A Sheet Locked
02.11 Remove A Sheet Locked
02 Source Files Locked
+ 03.01 Worksheet Tables 3 lectures
03.01 Build A Table Locked
03.02 Style A Table Locked
Source Files Locked
+ 03.02 Format Cells 5 lectures
03.01 Import Dataset Locked
03.02 Style A Cell Locked
03.03 Make A Named Style Locked
03.04 Copy A Style Locked
03b Source Files Locked
+ 04 Build 2D Charts 6 lectures
04.01 Make A Chart Locked
04.02 Build Line Charts Locked
04.03 Build A Pie Chart Locked
04.04 Build A Scatter Chart Locked
04.05 Build An Area Chart Locked
04 Source Files Locked
+ 05 Project: Employee Timelog 5 lectures
05.01 Project Setup Locked
05.02 Expand Columns To Fit Content Locked
05.03 Add Dates Locked
05.04 Add Days Of The Week Locked
05 Source Files Locked
+ 06 Write to a Text File 4 lectures
06.01 Read Spreadsheet Data Locked
06.02 Store Spreadsheet Data Locked
06.03 Write To A Text File Locked
06 Source Files Locked
+ 07 Update a Spreadsheet 3 lectures
07.01 Set Up Update Information Locked
07.02 Update The Spreadsheet Locked
07 Source Files Locked
+ 08 More Chart Types 4 lectures
08.03 Build A Bubble Chart Locked
08 Source Files Locked
08.01 Build A Stock Chart Locked
08.02 Build A Doughnut Chart Locked
+ 09 Web Scraping 6 lectures
09.01 Import Web Driver Locked
09.02 Scrape A Web Page Locked
09.03 Parse Page Data Locked
09.04 Put Data Into Excel Sheet Locked
09.05 Clean Data Locked
09 Source Files Locked
Description

About this course.

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.

Instructors

Taught by people who ship.

John Bura

John Bura

Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.

Ready to start building?

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

Buy lifetime access →