Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Streamline Excel Operations with Python's OpenPyXL Automation
Introduction to the Course
Source Files
01. Course Overview (2:20)
02. Run Openpyxl On The Web (1:45)
Use OpenPyXL and Sheets
Source Files
01. Make A Workbook (11:01)
02. Save A Workbook (3:51)
03. Read A Workbook (8:02)
04. Work With Rows And Columns (8:07)
05. Use A Formula (8:41)
06. Use Dates (7:18)
07 Merge And Unmerge Cells (7:11)
08. Fold A Range (6:17)
09. Make A New Sheet (3:17)
10. Copy Data To A Sheet (4:35)
11. Remove A Sheet (3:45)
Worksheet Tables
Source Files
01. Build A Table (15:50)
02. Style A Table (8:56)
Format Cells
Source Files
01. Import Dataset (4:20)
02. Style A Cell (6:47)
03. Make A Named Style (6:57)
04. Copy A Style (4:59)
Build 2D Charts
Source Files
01. Make A Chart (11:04)
02. Build Line Charts (15:30)
03. Build A Pie Chart (14:09)
04. Build A Scatter Chart (11:22)
05. Build An Area Chart (8:22)
Project Employee Timelog
Source Files
01. Project Setup (4:30)
02. Expand Columns To Fit Content (6:35)
03. Add Dates (7:34)
04. Add Days Of The Week (7:11)
Write to a Text File
Source Files
01. Read Spreadsheet Data (7:11)
02. Store Spreadsheet Data (3:39)
03. Write To A Text File (5:22)
Update a Spreadsheet
Source Files
01. Set Up Update Information (3:44)
02. Update The Spreadsheet (5:41)
More Chart Types
Source Files
01. Build A Stock Chart (9:14)
02. Build A Doughnut Chart (9:22)
03. Build A Bubble Chart (8:53)
Web Scraping
Source Files
01. Import Web Driver (8:06)
02. Scrape A Web Page (6:07)
03. Parse Page Data (9:17)
04. Put Data Into Excel Sheet (6:22)
05. Clean Data (4:38)
11. Remove A Sheet
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