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 with OpenPyXL in Python
Mammoth Club All levels 10 sections 51 lectures

Automate Excel with OpenPyXL in Python

If you can describe the task, Python can do it in Excel. Master programmatic Excel control.

Created by Team Mammoth
·
51 lectures
01
Skill level
All levels
02
Sections
10
03
Lectures
51
04
Instructor
Team Mammoth
What's inside

This course includes.

✓
10
Sections
✓
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
+ Introduction to the Course 3 lectures Preview
01.00 Course Overview Locked
01.01 Run Openpyxl On The Web Locked
01 Source Files Locked
+ 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
+ Worksheet Tables 3 lectures
03.01 Build A Table Locked
03.02 Style A Table Locked
03 Source Files Locked
+ 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
+ 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
+ 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
+ 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
+ Update a Spreadsheet 3 lectures
07.01 Set Up Update Information Locked
07.02 Update The Spreadsheet Locked
07 Source Files Locked
+ More Chart Types 4 lectures
08.01 Build A Stock Chart Locked
08.02 Build A Doughnut Chart Locked
08.03 Build A Bubble Chart Locked
08 Source Files Locked
+ 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.

Break the limits of basic macros. Learn to use the OpenPyXL library to read, write, and modify Excel files programmatically with Python perfect for tasks too complex for standard tools.

• Generate hundreds of custom reports in seconds.

• Format cells, styling, and charts via code.

• Merge data from multiple workbooks automatically.

✔️ Lifetime access

✔️ Source files included

✔️ Human-made HD video and crystal-clear audio

Instructors

Taught by people who ship.

Team Mammoth

Team Mammoth

Instructor

Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.

Ready to start building?

If you can describe the task, Python can do it in Excel. Master programmatic Excel control.

Buy lifetime access →