New To Data Analysis?

Build real-world data analysis & AI skills fast.

No complex math required.

Get started now

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

Learn Fundamental Data Analysis Skills for AI

Learn With Help From Your AI Tutor

Let me introduce you to Virtual Dave, your AI tutor. Virtual Dave is a customized, curated AI designed to help you learn visual data analysis quickly. 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 teach only the techniques I use in my real-world work.

No math beyond middle school is needed. No calculus and no statistics.

  • Welcome

    The 4 Levels of Analytics

    The “Why”

    Data Analysis with Copilot in Excel

    Course Dataset

  • Introducing Plotnine

    A Plotnine Example

    Missing Data & Plotnine

  • Numeric Summaries

    Ratios

    Measures of Central Tendency

    Probability

    Measures of Dispersion

  • Business Questions

    Frequency Distributions

    Histograms

    Interpreting Histograms

    Histogram Bins

    Histograms with Plotnine

    Insights with Histograms

    Faceted Histograms

    Histograms with Copilot in Excel

    Medians & Quartiles

    Box Plots

    Insights with Box Plots

    Faceted Box Plots

    Box Plots Over Time

    Box Plots with Copilot in Excel

  • Business Questions

    Scatter Plots

    What is Correlation?

    Always Visualize Your Data

    Scatter Plots with Plotnine

    Handling Duplicate Values

    Adding Trendlines

    Interpreting Scatter Plots

    Insights with Scatter Plots

    Faceted Scatter Plots

    Scatter Plots with Copilot in Excel

  • Continue Your Learning

Ready to build your skills?

Greetings! I’m Your Instructor, Dave Langer.

Author | Microsoft Excel MVP | LinkedIn Top Voice

I’m not your typical analytics instructor. I believe ANY professional can (and should) build DIY analytics skills. To succeed in this mission, I have to do one thing and do it well.

I have to make learning analytics fun.

Yes, you read that correctly.

I won’t lie. Many find applying visual analysis intimidating. It shouldn’t be. It’s a skill like any other. You get better with practice.

Making learning analytics 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

  • Yes! All the code used in this course is 100% compatible with Python in Excel.

    My Python in Excel Accelerator online course will teach you what you need to know.

    Also, you will get Copilot in Excel AI prompts for generating Python code.

  • This online course assumes certain skills with Python and Jupyter Notebooks.

    Alternatively, you can use Python in Excel for the course.

    My Python in Excel Accelerator online course will teach you what you need to know.

  • No! While math is covered in the course out of necessity, it is all intuitive, and nothing is beyond the middle school level.

  • Assuming that you know enough Python, you can be ready to use these skills in a single weekend.

  • 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.

  • 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, check out my Machine Learning Bootcamp for Teams.

Being Your DIY Data Science Journey

Visual Analysis with Python

  • 3+ hours of video lessons

  • All data and Python code

  • Copilot in Excel AI prompts

  • Access to Virtual Dave AI Tutor

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

Get started now for only $75

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