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

LinkedIn Learning

Using Python with Excel

via LinkedIn Learning

Write review
Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
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.6 rating at LinkedIn Learning based on 327 ratings

Start your review of Using Python with Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.