Statistics and Data Analysis with Excel: Essentials

Data drives decisions in every field — business, health, science, sports, and beyond. This course gives you the statistical tools to make sense of data, spot patterns, and present findings that inform real-world decisions. You'll work through both branches of statistics in a structured, practical sequence. Descriptive statistics help you summarise and describe data — covering measures of centredness like mean, median, and mode, and measures of spread including variance, standard deviation, and boxplots. You'll then move to inferential statistics, where you'll use the normal distribution, the Central Limit Theorem, and hypothesis testing to draw conclusions about whole populations from sample data. Everything is applied in Microsoft Excel, so you're not just learning theory — you're building working spreadsheet models. Each module includes downloadable workbooks, toolbox summary references, and both practice and graded assignments to reinforce your skills step by step. The course closes with a final assignment that brings all four modules together, giving you the opportunity to demonstrate your full range of statistical and analytical skills in a single integrated Excel model. Who this is for: Students, business professionals, and anyone who works with data and wants to understand it more rigorously. No prior statistics or Excel expertise is required.