Course Overview
Picture this. You open Excel, a dataset is staring back at you — sales numbers, survey results, website traffic, exam scores — and you know there's something important in it. But you're not sure how to prove it. That's why I created this Excel Statistics course.
Welcome to the Microsoft Excel Statistics & Data Analysis Course — From Zero to Analyst. This is a practical, hands-on, Excel-first course designed to take you from "I have a spreadsheet I don't understand" to "I can explain a decision with confidence using data." Everything we cover, we cover in Excel Statistics workflows — no Python, no R, no expensive software.
What makes this course different
Most statistics courses on Udemy use disconnected worked examples — one dataset for the hypothesis testing section, another for ANOVA, another for regression. Students learn each technique in isolation and never see how they fit together.
This course is different. The entire curriculum runs on a continuous storyline. You're the new junior analyst at BrightRoast Coffee — a fictional 200-store chain — and every section adds a new skill to your toolkit. Maria, the Head of Analytics, gives you the questions. You do the analysis in Excel. Across the course you'll complete 10 hands-on exercises that mirror exactly what an entry-level analyst does in a real first week on the job. Each exercise ends with a self-check that turns green when you've nailed it.
The curriculum at a glance
Foundations — Statistics in plain English. Samples vs. populations. Descriptive vs. inferential. Excel essentials including absolute references, Tables, and Flash Fill.
Descriptive Statistics — Mean, median, mode. Range, standard deviation, IQR. Z-scores and the Empirical Rule. Histograms, boxplots, and outlier detection. The Data Analysis ToolPak's descriptive output, explained line by line.
Probability & Distributions — Counting outcomes with PERMUT and COMBIN. The binomial distribution for yes/no situations (BINOM.DIST). The Poisson distribution for events arriving at a rate (POISSON.DIST). The normal distribution and z-tables.
The Central Limit Theorem — Standard error of the mean. Standard error of a proportion. Why n ≥ 30 makes the CLT work. The t-distribution vs. the z-distribution.
Confidence Intervals — For proportions. For means. How sample size changes the interval. The difference between 90%, 95%, and 99% confidence.
Hypothesis Testing — The 5-step framework. One-tailed vs. two-tailed tests. Type 1 and Type 2 errors. P-values explained honestly. One-sample tests for means and proportions.
Two-Sample Tests — Independent vs. paired samples. Two-proportion z-tests. Welch's t-test. Paired t-tests for before/after studies. F-tests for comparing variances.
ANOVA & Chi-Square — Comparing 3+ groups with one-way ANOVA. Post-hoc tests. Effect size with eta-squared. The chi-square test for categorical data (goodness-of-fit and independence). Cramer's V as effect size.
Regression Analysis — Correlation vs. regression. Simple linear regression: SLOPE, INTERCEPT, RSQ, FORECAST.LINEAR. Multiple regression with the Data Analysis ToolPak. R-squared and adjusted R-squared. Regression diagnostics (the LINE assumptions: Linearity, Independence, Normality, Equal variance). Making predictions with prediction intervals.
Section checkpoints
At the end of every section, a one-slide checkpoint shows exactly what you can now do. Six items, six green checkmarks. Your progress is visible — section by section, skill by skill.
What you get
• 80+ short, focused video lectures
• The exact Excel workbooks used in every lecture, downloadable for follow-along
• 10 hands-on exercises with paired challenge/solution worksheets
• Practice quizzes after each section
• Direct Q&A support — post a question and I'll personally walk you through the step that's confusing
• Lifetime access and free updates
If you're ready to turn spreadsheets into insight and master Excel Statistics for real-world data analysis, click the Enroll button and let's get started.
FAQ
FAQ area empty
Course curriculum
Chương 1 Course Setup & What You'll Be Able to Do 4 bài · 9 phút
Chương 2 Statistical Foundations & Excel Essentials 8 bài · 29 phút
- From Raw Data to Clear Decisions: How This Course Works Học thử 0:29
- What Statistics Is: Describing Data and Inferring from It Học thử 2:16
- Samples vs. Populations Học thử 4:15
-
Excel Essentials: Formulas, Relative & Absolute References 5:50
-
Excel Essentials: Tables, Navigation & Flash Fill 5:25
-
How the Statistical Methods in This Course Fit Together 6:02
-
Exercise 1: Build a Sales Calculator with VAT 4:28
-
Welcome and Introduction to Statistics
Chương 3 Descriptive Statistics in Excel 22 bài · 1 giờ 40 phút
-
Descriptive Statistics: What You'll Build in This Section 2:45
-
Variable Types: Categorical, Ordinal & Continuous 5:42
-
The Main Families of Descriptive Statistics 1:18
-
Build a Categorical Frequency Distribution in Excel 7:45
-
Build a Numerical Frequency Table with Bins 5:51
-
Create a Histogram to See Your Data's Shape 4:08
-
Mean, Median & Mode: The Three Measures of Centre 3:32
-
Choosing Between MEAN, MEDIAN and MODE on Real Data 8:06
-
Range & Variability: Measuring Spread 3:13
-
Standard Deviation with STDEV.S and STDEV.P 4:23
-
Calculate a Z-Score to Standardise Any Value 4:30
-
Normal Curve and Normal Distribution 2:10
-
Skewness & Kurtosis: Measuring Asymmetry and Tails 5:33
-
Apply the Empirical Rule (68-95-99.7) with Z-Scores 6:09
-
Interquartile Range & Box Plots: Finding Outliers 13:33
-
Descriptive Statistics with the Data Analysis ToolPak 6:03
-
Hands-On: A Full Descriptive Summary of a Dataset 4:53
-
Exercise 2: HR Bonus Review with Descriptive Statistics 5:08
-
Exercise 3: Find Wait-Time Outliers Using IQR 5:07
-
Descriptive Statistics
-
The Average Says We're Fine (Outliers & Median)
-
Who Really Earned the Bonus? (Z-Scores)
Chương 4 Probability Distributions 23 bài · 2 giờ
-
Probability Basics: Events, Outcomes & Notation 2:39
-
Simulate Probability in Excel with RAND and RANDBETWEEN 4:25
-
Permutations & Combinations with PERMUT and COMBIN 7:21
-
Calculate Percentiles and Quartiles in Excel 3:53
-
Multiple Events: Independent, Dependent & Mutually Exclusive 10:43
-
The Multiplication Rule for Joint Probability 5:25
-
Bayes' Theorem: Updating Probability with New Evidence 4:03
-
Discrete vs Continuous Probability Distributions 2:30
-
Discrete Distributions: When Outcomes Are Countable 4:12
-
The Binomial Distribution: Trials, Successes & BINOM.DIST 11:58
-
Binomial Probability: Exact vs Cumulative with BINOM.DIST 12:21
-
Exercise 4: Quality-Control Defect Rate with the Binomial 4:36
-
The Poisson Distribution: Events Over Time with POISSON.DIST 10:13
-
Choosing Between Binomial and Poisson 3:48
-
Exercise 5: Call-Centre Staffing with the Poisson Distribution 4:35
-
Expected Value: The Mean of a Discrete Distribution 2:38
-
The Normal Distribution: Properties and Real-World Fit 5:48
-
Normal Probabilities with NORM.DIST and NORM.INV 4:12
-
Reading Z-Score Tables (and Why Excel Replaces Them) 7:14
-
Plotting a Normal Curve in Excel 7:30
-
Probability and Distributions
-
Is the Supplier Lying About Defects? (Binomial)
-
How Many Agents Do We Need? (Poisson Staffing)
Chương 5 The Central Limit Theorem 6 bài · 36 phút
-
Sampling Distributions: What Happens Across Many Samples 5:05
-
The Standard Normal (Z) Distribution 3:47
-
The Central Limit Theorem: Why Sample Means Go Normal 11:02
-
Calculate Standard Error for a Proportion 7:01
-
T-Statistic vs Z-Statistic: Choosing the Right One 9:03
-
The Central Limit Theorem
Chương 6 Confidence Intervals 10 bài · 40 phút
-
Confidence Intervals: What 95% Actually Means 4:38
-
Confidence Intervals for Proportions 4:33
-
Build a Confidence Interval for a Proportion in Excel 8:07
-
Assignment: Build a Confidence Interval from Survey Data 4:44
-
Confidence Intervals for Means 5:30
-
Build a Confidence Interval for a Mean with CONFIDENCE.T 12:07
-
Confidence Intervals
-
Should We Launch? (Confidence Interval for a Proportion)
-
Marketing Claim Check
-
Statistics Practice Exam 1: Describing Data, Probability & Confidence Intervals (Sections 2-6)
Chương 7 Hypothesis Testing 9 bài · 41 phút
-
Hypothesis Testing: Null, Alternative & p-Values 3:20
-
The Five Steps of a Hypothesis Test 7:00
-
One-Tailed vs Two-Tailed Hypothesis Tests 5:26
-
Run a Hypothesis Test for a Mean in Excel (T.TEST) 11:51
-
Run a Hypothesis Test for a Proportion in Excel 7:56
-
Type I & Type II Errors: False Positives and False Negatives 5:13
-
Hypothesis Testing
-
We Proved the New Checkout Works! (Hypothesis Testing)
-
A/B Test on Conversion Rate
Chương 8 Comparing Two Populations 13 bài · 1 giờ 15 phút
-
Comparing Two Groups: Choosing the Right Test 4:30
-
Compare Two Proportions with a Z-Test 9:31
-
Compare Two Means with an Independent-Samples t-Test 8:40
-
F-Test: Comparing the Variance of Two Samples 9:40
-
Paired t-Test: Before-and-After Comparisons 12:34
-
The Chi-Square Test: Analysing Categorical Data 4:24
-
Chi-Square Goodness-of-Fit Test in Excel 9:59
-
Chi-Square Test of Independence in Excel 8:08
-
Reading and Reporting Chi-Square Results 7:48
-
Two Populations
-
Which Test Do I Use? (Choosing the Right Test)
-
Sales Training Programme
-
Region and Cup Size: Chi-Square Test
Chương 9 ANOVA - Analysis of Variance 4 bài · 21 phút
-
ANOVA: Comparing Three or More Group Means 13:33
-
Run One-Way ANOVA in Excel and Read the F-Statistic 7:17
-
ANOVA
-
Let's Just Cut Programme C (Interpreting ANOVA)
Chương 10 Regression Analysis 14 bài · 1 giờ 15 phút
-
Regression: Predicting One Variable from Another 3:51
-
Correlation: Measuring Strength with CORREL and PEARSON 8:13
-
Simple Linear Regression: Slope, Intercept & Residuals 6:07
-
Run a Simple Linear Regression in Excel 8:46
-
R-Squared: How Well Does the Model Fit? 7:40
-
Testing Regression Coefficients for Significance 13:15
-
Multiple Linear Regression with Several Predictors 9:02
-
Regression Assumptions and Diagnostics 8:36
-
Make Predictions with FORECAST.LINEAR and TREND 5:29
-
Regression Recap: Choosing and Reporting Your Model 4:09
-
Regression Analysis
-
If We Spend $150k on Ads... (Regression Predictions)
-
Website Redesign: Choose and Run the Test
-
Statistics Practice Exam 2: Hypothesis Testing, Comparing Groups, ANOVA & Regression (Sections 7-10)
Chương 11 Capstone Project 3 bài · 4 phút
-
Capstone: Analyse a Real Dataset End to End 4:24
-
Cumulative Final Quiz
-
Two Minutes with the CEO (Capstone Briefing)
Requirment
-
Excel 2016 or later — including Excel for Microsoft 365, Excel Online, and Mac versions
-
Basic Excel comfort: opening files, entering formulas, navigating worksheets (nothing advanced)
-
No prior statistics knowledge required — we cover everything from scratch
-
About 30-40 minutes a day for two to three weeks (or work at your own pace)
-
A willingness to actually open Excel and follow along — this is a hands-on course
Outcomes
-
Master Excel Statistics from absolute zero — no math degree, no prior stats, no Python required
-
Describe any dataset with confidence: mean, median, standard deviation, z-scores, IQR, boxplots
-
Use the binomial and Poisson distributions for real business questions (defect rates, calls per hour)
-
Apply the Central Limit Theorem — the single most useful idea in statistics
-
Build 95% confidence intervals for means and proportions, and explain what they actually mean
-
Run the full toolkit of hypothesis tests: t-tests, z-tests, paired t-tests, F-tests, ANOVA, chi-square
-
Build simple and multiple regression models in Excel, with diagnostics and predictions
-
Use the Data Analysis ToolPak like a working analyst — every test, every output, every interpretation
-
Complete 10 hands-on exercises modeled on real first-week analyst tasks at a fictional coffee chain
-
Translate every statistical finding into business language an executive can act on
0 Student
1 Course
0 review