Excel — Statistics · Course on Udemy

Real statistics in Excel, without the maths degree

Learn what the numbers actually mean, from averages and distributions to confidence intervals, hypothesis tests and regression, all in Excel.

★ 4.8 from 22 ratings on Udemy · 89 lessons · 9 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Is this course for you?

Statistics is how you tell a real change from noise, and Excel already has the tools.

You will get the most from it if you…

work in marketing, operations, sales, HR or finance and want data-driven decisions
are preparing for an analyst or business analyst role
took a statistics class once and forgot most of it
keep hearing “p-value” or “regression” and want to understand them

By the end you will be able to…

describe any data set: mean, median, standard deviation, z-scores, IQR and box plots
use the binomial and Poisson distributions for real business questions
build 95% confidence intervals and explain what they mean
run t-tests, z-tests, F-tests, ANOVA and chi-square tests
build simple and multiple regression models, and explain findings in business language

Want to present your findings visually? See the Excel Charts course.

What you will learn

With 10 hands-on exercises based on a fictional coffee chain’s first-week analyst tasks.

01Descriptive statisticsSummarise any data set

02Probability distributionsBinomial, Poisson and normal

03Confidence intervalsFor means and proportions

04Hypothesis testst, z, F, ANOVA and chi-square

05RegressionSimple and multiple models

What is inside

Four parts, from your first average to a regression model.

1. Foundations and descriptive statistics

Statistical foundations and the Excel essentials, then describing data: averages, spread, z-scores, IQR and box plots.

2. Probability and the Central Limit Theorem

Probability distributions for real questions, such as defect rates and calls per hour, and the Central Limit Theorem, the idea that makes the rest of statistics work.

3. Confidence intervals and hypothesis testing

Confidence intervals for means and proportions, hypothesis testing, comparing two populations, and ANOVA.

4. Regression analysis

Simple and multiple regression in Excel, with diagnostics and predictions, using the Data Analysis ToolPak like a working analyst.

What students say

Reviews from students of this course on Udemy.

“clear & in small bite-sized chunks that are so far, feeling easy to take in & understand as a complete beginner.”Dan B.

“A very good course! The exercises also reinforce the learning.”Rafael Torcende A.

What is included

89 video lessons, 9 hours
10 hands-on exercises with practice files
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need a maths or statistics background?

No. The course starts from zero and explains each idea in plain language before you use it in Excel.

Which version of Excel do I need?

A recent version of Excel with the Data Analysis ToolPak, a free add-in that comes with Excel. You switch it on once, under Add-ins.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free frequency distribution lesson on this site, or the preview lessons on the Udemy course page.

Ready to understand your data?

89 lessons and 10 exercises, from your first average to regression.

Enroll on Udemy →