Take the Leap From Excel to Python: A Hands-On Guide

Use Python data analysis to re-create Excel features like pivot tables, VLOOKUP, charts, and more!

Created by: Cory Stahle
Data Professional | Statistician

What Will I Learn?

• You will know how to use "notebooks" to create well-documented and re-usable data analysis.
• You will know how to re-create major Excel features like cell formulas and pivot tables in Python.
• You will know how to use Python and pandas to perform VLOOKUP style operations
• You will know how to use matplotlib to re-create Excel charts.
• You will know how Python packages and functions are used
• You will know how to build Excel pivot tables in Python

Requirements

• Familiarity with basic data analysis in Microsoft Excel.
• No prior experience with programming is required — this course is geared for beginners.

Target audience

• Spreadsheet users who want to grow their careers or improve their analysis by using Python.