Using Python with Excel

Offered By: LinkedIn Learning

Tags

Python Courses Data Analysis Courses Data Visualization Courses pandas Courses Jupyter Notebooks Courses Data Manipulation Courses openpyxl Courses

Course Description

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

Related Courses

Intro to Statistics
Stanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent