New To Data Analysis?

Build real-world data analysis & AI skills fast.

No complex math required.

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 Data Analysis Skills for AI

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

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

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

    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.

  • 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’re new to Python, you can be ready to use these skills in a single weekend.

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

    No questions asked

  • The Introduction to Machine Learning online course is available in partnership with TDWI and focuses on crafting ML predictive models.

    Use code LANGER to save 20% off your purchase.

  • 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

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