Python Excel
This course shows you how to use OpenPyXL to automate functions in Excel using Python, automate Excel tasks and build a wide range of Excel projects.
Segment - 01 - Course Overview
Segment - 02 - Run OpenPyXL on the Web
Source File
Segment - 03 - Make a Workbook
Segment - 04 - Save a Workbook
Segment - 05 - Work with Rows and Columns
Segment - 06 - Merge and Unmerge Cells
Segment - 07 - Fold a Range
Segment - 08 - Make a New Sheet
Segment - 09 - Copy Data to a Sheet
Segment - 10 - Remove a Sheet
Source File
Segment - 11 - Build a Table
Segment - 12 -Style a Table
Segment - 13 - Import Dataset
Segment - 14 - Style a Cell
Segment - 15 - Make a Named Style
Segment - 16 - Copy a Style
Source Files
Segment - 17 - Make a Chart
Segment - 18 - Build Line Charts
Segment - 19 - Build a Pie Chart
Segment - 21 - Build an Area Chart
Segment - 20 - Build a Scatter Chart
Source File
Segment - 22 - Project Setup
Segment - 23 - Expand Columns to Fit Content
Segment - 24 - Add Dates
Segment - 25 - Add Days of the Week
Source File
Segment - 26 - Read Spreadsheet Data
Segment - 27 - Store Spreadsheet Data
Segment - 28 - Write to a Text File
Source File