Using Python with Excel

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.

This course was created by Madecraft. We are pleased to host this content in our library.

Topics include:

• 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

About the Author

Anthony Sagely is a Python instructor who is passionate about data science and automation.

Anthony teaches Python, Excel, and data science to companies who seek to solve problems and find efficiencies in their workflow.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Intermediate
• Video Duration: 1h 22m
• Instructor: Anthony Sagely