Streamline Excel Operations with Python's OpenPyXL Automation
Created by Team Mammoth
01
Skill level
All levels
02
Sections
10
03
Lectures
51
04
Instructor
Team Mammoth
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.
+ Introduction to the Course 3 lectures
01 Source Files
Locked
01.01 Run Openpyxl On The Web
Locked
01.00 Course Overview
Locked
+ Use OpenPyXL and Sheets 12 lectures
02.02 Save A Workbook
Locked
02.03 Read A Workbook
Locked
02.01 Make A Workbook
Locked
02.06 Use Dates
Locked
02.04 Work With Rows And Columns
Locked
02.05 Use A Formula
Locked
02.09 Make A New Sheet
Locked
02.08 Fold A Range
Locked
02.07 Merge And Unmerge Cells
Locked
02 Source Files
Locked
02.10 Copy Data To A Sheet
Locked
02.11 Remove A Sheet
Locked
+ Worksheet Tables 3 lectures
03.01 Source Files
Locked
03.02 Style A Table
Locked
03.01 Build A Table
Locked
+ Format Cells 5 lectures
03.01 Import Dataset
Locked
03.02 Style A Cell
Locked
03.03 Make A Named Style
Locked
03b Source Files
Locked
03.04 Copy A Style
Locked
+ Build 2D Charts 6 lectures
04.03 Build A Pie Chart
Locked
04.01 Make A Chart
Locked
04.02 Build Line Charts
Locked
04 Source Files
Locked
04.05 Build An Area Chart
Locked
04.04 Build A Scatter Chart
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 Source Files
Locked
05.04 Add Days Of The Week
Locked
+ Write to a Text File 4 lectures
06.01 Read Spreadsheet Data
Locked
06.03 Write To A Text File
Locked
06.02 Store Spreadsheet Data
Locked
06 Source Files
Locked
+ Update a Spreadsheet 3 lectures
07 Source Files
Locked
07.01 Set Up Update Information
Locked
07.02 Update The Spreadsheet
Locked
+ More Chart Types 4 lectures
08.03 Build A Bubble Chart
Locked
08.01 Build A Stock Chart
Locked
08.02 Build A Doughnut Chart
Locked
08 Source Files
Locked
+ Web Scraping 6 lectures
09.02 Scrape A Web Page
Locked
09.01 Import Web Driver
Locked
09.03 Parse Page Data
Locked
09 Source Files
Locked
09.04 Put Data Into Excel Sheet
Locked
09.05 Clean Data
Locked
Instructors
Taught by people who ship.
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?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.