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

Write review

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Scrimba

Free courses from frontend to fullstack and AI

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

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