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.01 Run Openpyxl on the Web
Complete and Continue