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

Computational Investing, Part I
Georgia Institute of Technology via Coursera Введение в машинное обучение
Higher School of Economics via Coursera Математика и Python для анализа данных
Moscow Institute of Physics and Technology via Coursera Introduction to Python for Data Science
Microsoft via edX Python for Data Science
University of California, San Diego via edX