4.29 out of 5
4.29
232 reviews on Udemy

Python Programming for Excel Users – NumPy, Pandas and More!

Learn to Automate Excel with the Power of Python Programming
Instructor:
Derrick Sherrill
6,635 students enrolled
English [Auto]
Python Programming
NumPy
Pandas
Matplotlib

Wanting to learning Python for Excel Use cases? I’ll show you the basics here. We’ll cover the fundamentals of python, numpy, pandas, and matplotlib, to get you to a functional level of using python with your excel workbooks.

We’ll start with a python bootcamp that will get  complete beginner to a python user who can execute scripts and create functions.

Once we complete the bootcamp, we’ll go through tools of the trade lessons where you’ll learn all the things that can help make you a better python developer.

After completing that, we’ll introduce NumPy, and go through practice exercises to get you functional with our first python library, NumPy.

We’ll iterate over some more tools of the trade sections for software that will make you a stronger developer.

Then we’ll get into the fun part and look at how we can begin using pandas to do our data manipulation tasks.

Throughout the course, the main emphasis is to provide you project use cases that I hope will resemble your own use cases. I want to be coding on your own data ASAP and the goal of the projects is to provide you the tools to do so.

Introduction

1
Welcome to the Course!

Welcome to the Course! Brief chat before we get started.

Download Python

1
Getting Ready to Use Python

Short intro to Download Section

2
Download Python - Mac OS

Download instructions for Mac OS

3
Download Python - Windows OS

Special Guest Jen Introduces how to install python for Windows

Tools of the Trade - 1

1
What is a Text Editor?

We'll go over what the purpose of a text editor is, why it's helpful, and a few suggestions of ones to try out

2
Optional: Atom Setup
3
What are Documentations?

Brief look at documentations

Python Boot Camp - Level 1

1
Introduction to Boot Camp I

Welcome to Python Boot Camp level I

2
Quick Note about Python Script Execution
3
Python Variables vs. Excel "Variables"

Introduction to using Python Variables, Data types, and how we can check types and use print statements

4
Math Operators

Introduction to operators and operands

5
Operators Quiz

Brief Review of Operators

6
Data Types & Composite Data Types

Deeper dive into python data types and more composite data types

7
Python Control Flow

Let's look at control flow logic

8
Functions

Ready to unlock the power of python? Let's look at how to create functions

Project 1 -

1
Project Description - Make a Search Function

Introduction to our first project - Playing around with dtypes and search logic

2
Project Solution - Make a Search Function

Python Boot Camp - Level 2

1
Methods & Attributes

Introduction to accessing attributes and methods

2
Core Python vs. Included Libraries

Briefly talk about other standard libraries that come included with python

3
What is a Package Manager?

How to use the Python Package Manager - Pip!

4
What are Jupyter Notebooks?

Brief Rundown of how we can use jupyter notebooks

Python Boot Camp - Level 3 (NumPy)

1
NumPy - Install

Introduction to why we may want to use NumPy and install

2
NumPy Arrays

Introduction to NumPy Arrays

3
(Optional) - Array Practice

Let's Work with NumPy Arrays

4
Indexing & Reshaping

Introduction to Indexing and Reshaping NumPy Arrays

5
(Optional) Reshaping & Indexing Practice

Practice Reshaping and Indexing Arrays

6
Array Math
7
(Optional) Array Math Practice

NumPy Array Math Practice

Python Boot Camp - Level 4 (Pandas)

1
What is Pandas?

Introduction to Pandas, read excel methods, and what to expect

2
Pandas DataFrame

Introduction to Pandas DataFrames and how we can manually construct them

3
What is Kaggle?

Introduction to kaggle.com and downloading the csv file for the upcoming lecture

4
Input/Output Tools

We'll look at different methods of input and outputting our data using pandas

5
Data Selection Tools

In this one we'll fire up a jupyter notebook and work on data selection methods

6
Important Methods

We'll look at groupby, describe and boolean indexing

Project 2 - Custom Excel Reports (Code Along)

1
Code Along Intro

Introduction to our Code Along Project

2
Project - Joining Worksheets

Joining Together Data Using the Concat method - Brief discussion about the concat axis keyword

3
Project - Performing Calculations

How to create new dataframe columns and do simple calculations

4
Project - Data Selection (Boolean Indexing)

Boolean Indexing Example working through our project

5
Project - Viewing Results

How to get quick insights into our data

6
Project - Creating Function

Tools of the Trade - 3

1
What is Stack Overflow?

Stack Overflow <3

2
What is GitHub?

Brief Introduction to GitHub

Python Boot Camp - Level 5 (Matplotlib)

1
What is Matplotlib?

Download of Matplotlib

2
Creating Simple Graphs

In this one we'll create our first graph with matplotlib and look at how we can add more things to our graphs

3
More Graphs!

We'll talk about bar, histo2d, barh graphs in this one

4
Pandas Integrated graphing techniques

How we can plot dataframe information

Capstone Project - Automate Excel Reporting

1
Capstone Introduction
2
Task 1: Select Data

How can we select data only when specific criteria are met?

3
Task 2: Calculations

We'll do Pandas Series Calculations in this one

4
Task 3: Create Visuals
5
Task 4: Automate it!

Programmatically Automate Excel Reports Using Python

Wrapping Up & Thank You!

1
Thank You!

Thanks so much!

Python Reference (Optional Content)

1
Syntax & Commenting

Deeper look at Python Syntax and Commenting

2
Variables and Data Types

Deeper look into variables and data types

3
Composite Data Types

Deeper look into composite data types

4
Numbers

Deeper look into working with Python Numbers

5
Lists

Revisiting Lists

6
Strings

Revisiting Strings

7
Tuples

Intro to Tuple Values

8
Sets & Frozen Sets

Introduction to Sets and Frozensets

9
Dictionaries

Retouching on Dictionaries

10
If Statements

Looking at If Statements Again

11
While Loops

Looking at While Loops again

12
For Loops

Revisit to For Loops

13
Functions

Visiting Functions again

14
Class Objects

Class Objects in Python Introduction

Bonus Content: NumPy

1
NumPy Default Arrays

More NumPy Topics! Default Arrays in this one

2
NumPy Default Arrays Practice

Practice Using NumPy Default Arrays

3
NumPy Advanced Indexing

NumPy Advanced Indexing Lesson

4
NumPy Advanced Indexing Project

We'll work with NumPy Advanced Indexing a little more in this project video.

5
NumPy Broadcasting

Introduction to NumPy Broadcasting

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
232 Ratings

Detailed Rating

Stars 5
99
Stars 4
75
Stars 3
48
Stars 2
6
Stars 1
4
1320f7adffdb3990be101dc320129e0b

Includes

4 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion