YoVDO

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

Artificial Intelligence for Robotics
Stanford 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