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
Computational Investing, Part IGeorgia 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