Black Friday 2024: 25+ Ways to Save on Online Learning

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

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
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

Go to class

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.