Hiring and Interview Skills to Recruit Top Talent as Manager
John Masud Parvez
5.0 (267)·5h 55m · 48 lectures
$3.00$12–$199up to −98%
Loading course
Microsoft Excel Statistics & Data Analysis – Zero to Analyst
Statistics in Excel from scratch. Master t-tests, ANOVA, chi-square and regression — no math background required
5.09 reviews153 learners
- All Levels
- 9h 9m video
- 89 lectures
- English
- Captions
- Updated 2026
Taught by Andreas Andreas Exadaktylos • Excel, Python & Microsoft Office
- 9h 9m of on-demand video
- 89 lectures across 11 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- Closed captions (English)
Curriculum
11 sections89 lectures9h 9m total
- Course Overview & Setting Expectations2:21
- Download the Exercise Files1:30
- Who This Course Is For — and What You'll Be Able to Do2:02
- Excel Statistics on PC or Mac?2:46
- Introduction: From Raw Data to Clear Decisions0:29
- What are Statistics?2:16
- Samples vs. Populations4:15
- Excel Essentials — Part 1 (Formulas, References, Absolute References)5:50
- Excel Essentials — Part 2 (Tables, Navigation, Flash Fill)5:25
- Connecting the dots of Statistics6:02
- Exercise 1 — Sales Calculator (VAT)4:28
- Introduction: Descriptive Statistics in Excel2:45
- Understanding the Types of Variables5:42
- The main types of Descriptive Statistics1:18
- Categorical Frequency Distribution7:45
- Numerical Frequency Table5:51
- Histograms4:08
- The 3 Measures of Center3:32
- Examples of MEAN, MEDIAN and MODE8:06
- Range and Variability3:13
- Standard Deviation4:23
- Z-Score4:30
- Normal Curve and Normal Distribution2:10
- Skewness and Kurtosis5:33
- Using the Empirical Rule and Z-Scores6:09
- Interquartile Range & Boxplot Chart13:33
- Descriptive Tool: Data Analysis6:03
- Descriptive Tool — Section 3 Hands-On Exercise4:53
- Exercise 2 — HR Bonus Review5:08
- Exercise 3 — Wait Time Outlier Hunt (IQR)5:07
- Introduction to Probabilities2:39
- Simulating probability in Excel4:25
- Permutations and Combinations7:21
- Percentiles3:53
- Multiple Events: What That Really Means10:43
- Multiplication Rule5:25
- Bayes Theorem4:03
- Types of Probability Distributions2:30
- Introduction to Discrete Distributions4:12
- The Binomial Distribution Part:111:58
- The Binomial Distribution Part:212:21
- Exercise 4 — QC Defect Rate (Binomial)4:36
- The Poisson Distribution10:13
- Choosing Between Binomial and Poisson3:48
- Exercise 5 — Call Centre Staffing (Poisson)4:35
- Discrete Mean2:38
- The Normal Distribution5:48
- Normal Distribution and Excel4:12
- Z-score Tables7:14
- Plotting a Normal Curve in Excel7:30
- Samples5:05
- The Standard Normal Distribution3:47
- Central Limit Theorem11:02
- Standard Error for Proportions7:01
- t-statistic vs. z-statistic9:03
- Introduction to Confidence Intervals4:38
- Confidence Intervals for Proportions4:33
- Creating Confidence Intervals for Proportions in Excel8:07
- Assignment4:44
- Confidence Intervals for Means5:30
- Creating Confidence Intervals for Means in Excel12:07
About this course
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 usin…
Before you start
- 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
Who it’s for
- Excel users in marketing, operations, sales, HR, or finance who want to make data-driven decisions
- Anyone preparing for an analyst, data analyst, or business analyst role and needs the statistics foundation
- Students who took a statistics class once, forgot most of it, and want the practical version
- Complete beginners who have never touched statistics — the course assumes zero background
- Excel users who keep hearing words like "p-value," "confidence interval," or "regression" and want to actually understand them
- Business professionals tired of relying on others to interpret data for them
Related
More in Business
Master Business Intelligence BI -- دبلوم ذكاء الاعمال
Qusay Tawfiq AL-Btoush
5.0 (210)·14h 15m · 29 lecturesNot available yetThe complete guide Real Estate Investing from Scratch
Nexa Learning
5.0 (145)·1h 22m · 28 lectures$3.00$12–$199up to −98%
$3.00$12–$199