Ready for the Future of Excel?

AI will power the future of Microsoft Excel.

And the AI’s magic depends on Python.

Get started now

Real-World AI in 2026. 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

Learn Fundamental Skills for Copilot in Excel

Learn With Help From Your AI Tutor

Let me introduce you to Virtual Dave, your AI tutor. Virtual Dave is a customized and curated AI designed to help you learn Python in Excel fast. More importantly, Virtual Dave is available 24x7 to help you apply what you learn at work to make more impact and stand out from the crowd:

Virtual Dave is an AI service I’m integrating into all my self-paced online courses.

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

Ready to build your skills?

Greetings! I’m Your Instructor, Dave Langer.

Author | Microsoft MVP | LinkedIn Top Voice

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 data science 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:

    Visual Data Analysis

    Cluster Analysis

  • Send me an email within 30 days of your purchase, and I will issue you a refund.

    No questions asked

  • The goal of Virtual Dave is to provide an interactive experience as close to speaking with me in person as possible. Of course, this is not perfect given the current state of AI technology.

    So, I continually monitor and curate Virtual Dave conversations to ensure the best possible experience for you.

    Virtual Dave is an external AI service that I’ve integrated with this online course. As long as I offer the Virtual Dave service, course students will have access for no additional charge.

  • No problem! I wrote Python in Excel Step-by-Step to teach professionals like you the Python foundation needed for the future of Excel.

    It covers essentially the same topics as the online course, so choose what works best for you.

  • 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

  • Access to the Virtual Dave AI tutor

  • Refund within 30 days of purchase if you’re not happy

Get started now for only $97

The price of this course increases to $147 on March 2nd!