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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX