Using Python with Excel (2019)

Python is the world's fastest growing programming language. It's a powerful tool that is helping to streamline development and data science. In this course from Madecraft, you can learn how to combine the power of the Python language with the data analysis and reporting tools in Microsoft Excel. Discover how to leverage the pandas and openpyxl libraries to inspect, filter, clean, and convert data and how to build solid reports that help businesses take action. Discover how to work with large amounts of data that would be unmanageable in Excel alone. By the end of this course, viewers will learn how this combination of tools can lead businesses to better insights than ever before.

Learning objectives
Loading and saving data with pandas
Filtering and sorting data with pandas
Formatting workbooks with openpyxl
Creating graphs and charts with openpyxl
Converting data
Advanced graphing