Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 15 Minute(s)
Language
English
Taught by
Cory Stahle
Rating
2 views
Course Overview
Use Python data analysis to re-create Excel features like pivot tables, VLOOKUP, charts, and more!
****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
Course Content
- 10 section(s)
- 50 lecture(s)
- Section 1 Welcome to the course!
- Section 2 Quick Start Concepts
- Section 3 PART 2 -----------------From Excel to Python-----------------
- Section 4 Clean Data without the Excel Ribbon
- Section 5 Use Python to Run "Cell Formulas''
- Section 6 Transform Your Data with Pivot Tables and More!
- Section 7 Working with Multiple Dataframes: Replacing VLOOKUP
- Section 8 Building Charts and Visualizations
- Section 9 PART 3 -----------------Projects-----------------
- Section 10 Bringing It All Together: Project Demo
What You’ll 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
Reviews
-
JJoseph Mensah
It was a very good match for me. Presenter had a very calming and informal approach that made the course very engaging.
-
JJose Moya
Quite a clear, and well-prepared course. I enjoy and learnt a lot following it.
-
JJan Tharmak
I like the fact that the instructor first states what the function is in Excel and then goes into Python functions. For each Python function, instructor provides a very detailed explanation that is easy to understand! BEST EXCEL to PYTHON course I bought !!
-
GGary Hamrick
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.
