Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Automate Excel Files with Python OpenPyXL
Intro to Mammoth Interactive
01 How to Learn Online Effectively (13:39)
00 About Mammoth Interactive (1:05)
01 Introduction to the Course
01.00 Course Overview (2:20)
01.01 Run Openpyxl on the Web (1:45)
Source Files
02 Use OpenPyXL and Sheets
02.01 Make a Workbook (11:01)
02.02 Save a Workbook (3:51)
02.03 Read a Workbook (8:02)
02.04 Work with Rows and Columns (8:07)
02.05 Use a Formula (8:41)
02.06 Use Dates (7:18)
02.07 Merge and Unmerge Cells (7:11)
02.08 Fold a Range (6:17)
02.09 Make a New Sheet (3:17)
02.10 Copy Data to a Sheet (4:35)
02.11 Remove a Sheet (3:45)
Source Files
03.01 Worksheet Tables
03.01 Build a Table (15:50)
03.02 Style a Table (8:55)
Source Files
03.02 Format Cells
03.01 Import Dataset (4:19)
03.02 Style a Cell (6:47)
03.03 Make a Named Style (6:57)
03.04 Copy a Style (4:59)
Source Files
04 Build 2D Charts
04.01 Make a Chart (11:04)
04.02 Build Line Charts (15:30)
04.03 Build a Pie Chart (14:09)
04.04 Build a Scatter Chart (11:22)
04.05 Build an Area Chart (8:21)
Source Files
05 Project - Employee Timelog
05.01 Project Setup (4:29)
05.02 Expand Columns to Fit Content (6:35)
05.03 Add Dates (7:34)
05.04 Add Days of the Week (7:11)
Source Files
07 Update a Spreadsheet
07.01 Set Up Update Information (3:44)
07.02 Update the Spreadsheet (5:41)
Source Files
08 More Chart Types
08.01 Build a Stock Chart (9:13)
08.02 Build a Doughnut Chart (9:22)
08.03 Build a Bubble Chart (8:53)
Source Files
09 Web Scraping
09.01 Import Web Driver (8:06)
09.02 Scrape a Web Page (6:06)
09.03 Parse Page Data (9:17)
09.04 Put Data into Excel Sheet (6:22)
09.05 Clean Data (4:38)
Source Files
01 How to Learn Online Effectively
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience