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.
-
1
-
Segment - 01 - Course Overview
-
Segment - 02 - Run OpenPyXL on the Web
-
Source File
-
2
-
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
-
3
-
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
-
4
-
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
-
5
-
Segment - 22 - Project Setup
-
Segment - 23 - Expand Columns to Fit Content
-
Segment - 24 - Add Dates
-
Segment - 25 - Add Days of the Week
-
Source File
-
6
-
Segment - 26 - Read Spreadsheet Data
-
Segment - 27 - Store Spreadsheet Data
-
Segment - 28 - Write to a Text File
-
Source File
-
7
-
Segment - 29 - Set up Update Information
-
Segment - 30 - Update the Spreadsheet
-
Source File
-
8
-
Segment - 31 - Build a Stock Chart
-
Segment - 32 - Build a Doughnut Chart
-
Segment - 33 - Build a Bubble Chart
-
Source File
-
9
-
Segment - 34 - Import Web Driver
-
Segment - 35 - Scrape a Web Page
-
Segment - 36 - Parse Page Data
-
Segment - 37 - Put Data into Excel Sheet
-
Segment - 38 - Clean Data
-
Source File