Using Python with Excel
Offered By: LinkedIn Learning
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
- 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
- Using openpyxl with Workbooks
- Selecting cells, rows, and columns
- Adding workbook formatting
- Creating names, ranges, and tables
- Managing multiple sheets
- Working with large worksheets
- Conditional formatting
- Creating Excel plots in Python
- Exporting Python plots to Excel
- Next steps
Taught by
Anthony Sagely and Madecraft
Related Courses
Artificial Intelligence for RoboticsStanford University via Udacity Intro to Computer Science
University of Virginia via Udacity Design of Computer Programs
Stanford University via Udacity Web Development
Udacity Programming Languages
University of Virginia via Udacity