Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Using Python with Excel

via LinkedIn Learning

Go to class Write review

Overview

Take your Microsoft Excel skills to the next level using Python, one of the world’s most popular object-oriented programming languages.

Syllabus

Introduction

Managing Excel with Python

1. Python and pandas

Jupyter Notebooks basics
Introducing the Python pandas library
Loading and saving data with pandas
Viewing and inspecting data with pandas
Manipulating data with pandas
Working with dates and times in pandas

2. openpyxl

Using openpyxl with Workbooks
Selecting cells, rows, and columns
Adding workbook formatting
Creating names, ranges, and tables

3. Working with Reports

Managing multiple sheets
Working with large worksheets
Conditional formatting
Creating Excel plots in Python
Exporting Python plots to Excel

Conclusion

Next steps

Taught by

Anthony Sagely and Madecraft

Reviews

4.7 rating at LinkedIn Learning based on 226 ratings

Start your review of Using Python with Excel