Learning Path

Data Analysis with Python in Excel

Believe it or not, Microsoft Excel and Python have many things in common. For example, working with data tables is fundamental in both technologies when your goal is to produce new insights and positively impact the business.

This learning path will leverage your Excel knowledge to jumpstart your Python skills using pandas, one of the most popular Python packages for working with data. The pandas library provides Python with rich data table functionality. Not surprisingly, skills with pandas are fundamental for analyzing data with Python.

Enhance your data analysis skills, boost your career, and unlock new opportunities. You'll learn how to construct tables, for example, and perform advanced analytics in Excel with embedded Python.

By the end of this learning path, you’ll learn:

What are Python objects, and how they relate to Microsoft Excel.

How pandas DataFrame and Series objects are fundamental to data analysis using Python.

How Python provides a repeatable process for crafting the best data tables for your analyses.

Get Access

5 Courses • 38 Lessons

9 Lessons

Data Analysis with Python in Excel: The Basics (Day 1)

This course is Part 1 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

8 Lessons

Data Analysis with Python in Excel: Working with Columns (Day 2)

This course is Part 2 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

6 Lessons

Data Analysis with Python in Excel: Filtering DataFrames (Day 3)

This course is Part 3 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

7 Lessons

Data Analysis with Python in Excel: Data Cleaning and Wrangling (Day 4)

This course is Part 4 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

8 Lessons

Data Analysis with Python in Excel: Combining and Pivoting Tables (Day 5)

This course is Part 5 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

What's Next?

Complete all courses in this path to earn your course completion certificates.

This is for you because...

You’re an Excel-based data analyst.
You work with tables of data in Excel to produce insights.
You want to move beyond the limitations of Excel to have more impact.

Prerequisites

Knowledge of Excel tables, PivotTables, formulas, and VLOOKUP.
Required: You must have access to Python in Excel features
Required: Install Excel on Windows. If you’re using a Mac, follow these steps to get access to Python in Excel.

Recommended preparation

Get Started with Anaconda: Learn about Python, packages, and more in these short tutorials.
Python for Excel Analysts: The Basics - Series of blog posts by Dave Langer.

INSTRUCTOR

Dave Langer

Dave is the Founder of Dave on Data, where he delivers training designed for ANY professional to develop data analysis skills.