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

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