Ready for the Future of Excel?
AI will power the future of Microsoft Excel.
And the AI’s magic depends on Python.
Real-World AI in 2025. Will You Be Ready?
“Python in Excel is intended to empower everyone (and we mean everyone now that we also have Copilot in Excel with Python) to do data analysis in an easy, secure, and compliant way.”
-Keyur Patel, Principal Program Manager at Microsoft
AI is Being Sold Like it’s Magic
Microsoft will be like every other AI vendor out there - promising that Copilot will magically transform your organization:
Everyone in the organization with Copilot in Excel can perform amazing data analyses.
Better yet, with Copilot in Excel, everyone can harness the power of Python to perform advanced analytics.
Best of all, with Copilot in Excel, nobody needs to understand analytics, and they don’t need to know Python!
What Microsoft Won’t Tell Your Executives
Copilot makes mistakes.
Sometimes, it makes stuff up out of thin air!
The technical term for this is "hallucinations."
Sam Altman, the CEO of the most famous AI company (OpenAI), stated that hallucinations are more a feature of AI than a bug.
Think about this for a second. What Sam Altman is saying is that hallucinations are inherent in every AI. There’s nothing you can do about it.
Every AI will sometimes make stuff up at random.
Learn Fundamental Skills for Copilot in Excel
What’s Inside
I’ve successfully taught 100s of Excel users how to use Python.
The Python in Excel Accelerator is the online version of my live course.
-
Welcome!
Why Learn Python in Excel?
You Are a Coder!
Getting Python in Excel
Running Python in Excel
The Course Workbook
-
Excel is a World of Objects
Pandas DataFrames
Pandas Series
Python Data Types [Hands-On]
Loading DataFrames [Hands-On]
DataFrame Summaries [Hands-On]
The Workbook So Far
-
Accessing Columns [Hands-On]
Numeric Columns [Hands-On]
String Columns [Hands-On]
Datetime Columns [Hands-On]
Indexes [Hands-On]
The Workbook So Far
-
Filtering in Excel
Logical AND [Hands-On]
Logical OR [Hands-On]
Combining Logic [Hands-On]
Filtering Using query() [Hands-On]
The Workbook So Far
-
Functions in Excel
Your First Function [Hands-On]
Mutating DataFrames [Hands-On]
Using Lambdas [Hands-On]
Data Wrangling [Hands-On]
The Workbook So Far
-
Joining Tables in Excel
Left Joins [Hands-On]
Inner Joins [Hands-On]
Pivoting Tables in Excel
Pivoting DataFrames [Hands-On]
The Final Workbook
-
Power Query Connections
Python in Excel Premium
Continue Your Learning
Greetings! I’m Your Instructor, Dave Langer.
LinkedIn Top Voice | Microsoft MVP
I’m not your typical data science instructor. I believe ANY professional can (and should) build DIY data science skills. To succeed in this mission, I have to do one thing and do it well.
I have to make learning data science fun.
Yes, you read that correctly.
I won’t lie. Many find the idea of applying cluster analysis intimidating. It shouldn’t be. It’s a skill like any other. You get better with practice.
Making learning data science fun makes getting started less intimidating.
You’ve got this if you want it.
The Escape Hatch
What if the course isn’t right for you?
My goal is to help you build valuable DIY data science skills for the age of AI. If this online course isn’t right for you, send me an email within 30 days of purchase, and I will issue a refund—no questions asked!
Frequently Asked Questions
-
Assuming that you’re new to Python, you can be ready to use these skills in a single weekend.
-
After learning Python in Excel, the next step is to use Python to analyze your data.
Check out these courses, which also include Copilot in Excel AI prompts:
-
Send me an email within 30 days of your purchase, and I will issue you a refund.
No questions asked
-
If you need team training, please contact me to discuss your needs.
Being Your DIY Data Science Journey
Python in Excel Accelerator
5+ hours of video lessons
80+% hands-on learning.
All Python code in downloadable workbooks
Refund within 30 days of purchase if you’re not happy