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!

4.35 (83 reviews)

Udemy

platform

English

language

Programming Languages

What you will 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

Why take this course?

****INCLUDES DOZENS OF HANDS-ON CODING NOTEBOOKS****

This course will use hands-on exercises to teach you how to apply your Excel knowledge in Python.

Several years ago, I was in your shoes. I tried learning Python but would go back to do things in Excel because I was more comfortable with it. My goal in this course is to help you become as comfortable in Python as you are in Excel. To become comfortable, you need to have opportunities to participate in hands-on exercises and projects. You will have the chance to do both in this course.

This course is designed for students who want to grow their careers or improve their analysis by using Python.

What will you learn:

How to use Google Colab to begin using Python without installing software
How to use Python packages and functions
How to import and export data from Python
How to perform basic tasks like data cleaning
How Python can save time by creating scripts which can be re-run easily
How notebooks can be used to create well-documented analysis
How to replicate many Excel features

Excel features we will replicate in Python:

Pivot tables
VLOOKUP
Charts
Cell formulas like SUM( ), IF( ) and CONCATENATE( )
Filtering rows
Performing text to columns splits
and more!

Content

This course is divided into three parts.

The first part is the introduction to the course and an overview of the essential concepts you need to know to use Python and pandas.

In part 2, you will have the flexibility to take the lessons in whatever order best suits your needs. If you need to learn how to build a pivot table in Python, you can skip straight to that lesson. Want to build charts in python… you can start there instead.

In part 3 we will work on an analytics project using real-world data together. You will then apply everything you have learned to build your own project.

The course also has a 30-day 100% money-back guarantee. If you aren't happy with your purchase, you can refund the course with no questions asked.

Enroll now to make the leap from Excel to Python!

- Cory

Content

Welcome to the course!

Welcome to the Course!

Using Google Colaboratory

Download Course Notebooks

Quick Start Concepts

Packages

Functions

Variables and Data Types

Importing and Exporting Data

Dataframe Basics

Exploring Dataframes

PART 2 -----------------From Excel to Python-----------------

Welcome to Part 2: From Excel to Python

Clean Data without the Excel Ribbon

Handling Missing Data

Deleting Rows or Columns

Removing Duplicate Values

Changing Data Types

Sorting Your Data

Filtering Rows

Finding and Replacing Text

Text to Columns Splitting

Grouping Data

Use Python to Run "Cell Formulas''

SUM( ), COUNT( ), AVERAGE() and more!

IF() Function

SUMIF( ), COUNTIF( ), and AVERAGEIF( )

AND( ) / OR( )

CONCATENATE( )

LOWER( ), UPPER( ), and PROPER( )

TRIM( )

Transform Your Data with Pivot Tables and More!

Pivot Tables

Crosstabs

Reversing a Pivot (transform wide data to long)

Working with Multiple Dataframes: Replacing VLOOKUP

Appending Dataframes

Merging: VLOOKUP in Python (Part 1)

Merging: VLOOKUP in Python (Part 2)

Building Charts and Visualizations

Column (Bar) Charts

Histograms

Scatterplots

Line and Area Plots

Pie, Donut and Treemap Charts

PART 3 -----------------Projects-----------------

Welcome to Part 3: Projects

Bringing It All Together: Project Demo

Project Overview

Import Data

Explore and Clean the Data

Analyze (Question 1)

Analyze (Question 2)

Analyze (Question 3)

Analyze (Question 4)

Analyze (Question 5)

Communicate Results: Make a PDF or Save to GitHub

Final Project

Your Project Overview

Data sources for your project

Congratulations!

Screenshots

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

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

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

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

Reviews

Courtenay

February 3, 2023

Cory really nails the topic, the process, and everything with this course. I have a few other great courses on Python, but they all start with abstract basics... strangely, nothing has made Python more accessible to me than this course. He was also very helpful and quick with responding to my question. Amazing course experience.

RICARDO

December 26, 2022

It is beautifully detailed but simplified. The best Python in Excel course I've ever had. Looking forward to your next course and maraming salamat po.

Gary

June 29, 2022

Excellent. Instead of spending time with small details, this course get directly to the meat of the course, and makes it simple with multiple real world examples. I really like the course author.

Enakshi

March 24, 2022

i did not see the snippets option in my colaboratory file . There is no explanation whether its a mac specific problem or not .

Manuel

January 31, 2022

Very efficient learning experience, great combination of theory and practice. Exactly what I was looking for! Thanks a lot!

Jyh-Jiuan

January 28, 2022

Most of other lecturers will simply skip a lot of interface using steps, which is basics, however, really essential. Thanks for all the details and guidence which will let the later coding goes more smoothly.

Joseph

January 24, 2022

Best Python course I have ever taken. I have no background in coding, but I have used excel. So, the professors straight forward way of teaching has helped me become as advanced in Python as I am in Excel!

Bryan

December 5, 2021

The most clear, precise and easy to follow course I have encountered. I would buy any of Cory Stahle's courses in a heart beat.

Gerry

October 5, 2021

Clear use of language. Short coding blocks. Using Google Colab is a good idea. Learning a lot of new things. Great.

Robert

September 25, 2021

I finished every lesson in the course and it was fantastic from start to finish. It was the perfect starting point to learn Python for a 30-year Excel user. I have seen some free beginner tutorials online and they tend to start with all kinds computer science jargon - lists, sets, tuples. This course does a minimal amount of that and rather focuses on Excel tasks and functions that Excel users are familiar with and shows how they can be replicated in Python. I learned a tremendous amount in the course and feel very prepared to move forward with the next level of Python learning.

Amit

July 21, 2021

Thanks a Ton, Cory Stahle! This is by far the best Course, I have come across on Udemy for learning Pandas(Python). Highly Recommended for those who wish to learn Pandas for Data Science.

Allison

December 28, 2020

This course is an incredibly detailed and gentle introduction to replacing excel functions with python. The instructor provides you with everything you need to be successful in the course, and anticipates potential questions you might have with a step by step approach. Great course!

Saifullah

December 8, 2020

It was good. But i have a problem and i want to ask the instructor but don't know how. I logged in to my google drive account, proceeded to New and up to the connect more app. I typed inn Colaboratory but it doesn't appear . Please how can i get it?

Derek

December 2, 2020

This was such an effective course. He knows what he is talking about. This is a perfect way to learn python if you are looking to get into data analytics. Very good intro course

David

November 23, 2020

This is a perfect course for getting my feet wet with python. I've wanted to learn python for a long time but it was always very intimidating to me. So far this course has made it feel manageable.

Charts

Price

Rating

Enrollment distribution

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