Overview
-
Take your Excel skills further by using Python. Discover how to inspect, filter, clean, convert, and visualize data with Excel and Python libraries like pandas and openpyxl.
Syllabus
-
Introduction
- Managing Excel with Python
- Prerequisites
- Introducing the Python pandas library
- Loading and saving data with pandas
- Viewing and inspecting data with pandas
- Filter and sort with pandas
- Cleaning data with pandas
- Introducing the Python openpyxl library
- Using openpyxl with workbooks
- Selecting cells, rows, and columns
- Formatting workbooks
- Graphs and charts
- Tables and images
- openpyxl with pandas
- Managing multiple sheets
- Converting data
- Parsing large spreadsheets
- Advanced graphing with Excel and Python
- Next steps
