Data & AnalyticsBusiness Analytics in Excel
KPIs, pivot-style summaries, rankings, Pareto, trends, statistics, forecasts and cohorts: 8 labs on realistic business data.
IntermediateCertificate$9.99
Data & Analytics
Data analysis you can audit, cell by cell
Good analysis is less about clever tools and more about clean inputs, transparent formulas and honest conclusions. These courses train exactly that. You work on realistic datasets in a spreadsheet in your browser, build every summary and test yourself, and get immediate feedback on each cell, so you always know why a number is what it is.
The catalogue covers the everyday analyst toolkit (KPIs, cleaning, pivot-style summaries, forecasting) and goes deep where business questions need it: regression, ANOVA, chi-square tests, Bayesian A/B tests, sample size and power, survey weighting, cohort and churn analysis, market baskets, RFM segmentation and process mining. Several courses include chart tasks that the checker grades alongside the formulas.
Courses in Data & Analytics
Data & Analytics
Data & AnalyticsBusiness Statistics & Regression in Excel
Standard error, confidence intervals, hypothesis tests, two-group comparisons, correlation and regression: 8 labs on realistic business data.
IntermediateCertificate$9.99
Data & AnalyticsData Cleaning & Preparation in Excel
Trim, split, convert, map, de-duplicate, fill, flag and validate: 8 labs that turn messy exports into analysis-ready tables.
IntermediateCertificate$9.99
Data & AnalyticsForecasting & Time-Series Analysis in Excel
Growth rates, smoothing, seasonal indices, trend × season forecasts, accuracy metrics and driver-based scenarios: 8 labs on one consistent retail dataset.
IntermediateCertificate$9.99
Data & AnalyticsSurvey & Customer Feedback Analysis in Excel
Response rates, Likert scales, NPS, cross-tabs, weighting, margins of error, significance tests and open-text coding: 8 labs on one customer survey.
IntermediateCertificate$9.99
Data & AnalyticsA/B Testing & Experimentation
Plan, size, run and analyse A/B tests in Excel: metrics and MDE, sample size and duration, z-tests, confidence intervals, revenue t-tests, Bonferroni, SRM checks and the peeking trap, in 8 graded labs.
IntermediateCertificate$9.99
Data & AnalyticsData Storytelling with Charts
Turn messy default charts into clear stories: pick the message and the form, declutter, highlight, rank Top 5 + Other, slope charts, waterfall vs stacked, honest axes and headline titles, in 8 graded labs.
IntermediateCertificate$9.99
Data & AnalyticsData Analyst Portfolio Projects in Excel
Four end-to-end projects for one company (e-commerce sales, HR attrition, marketing campaigns, customer support): clean, analyse, chart and state the insight, with every cell checked.
IntermediateCertificate$9.99
Data & AnalyticsRegression Analysis for Business in Excel
From scatter plot to multiple regression: least squares by hand, R² and standard error, t-tests and p-values, prediction intervals, LINEST with several drivers, dummy variables, residual analysis and log models, in 8 hands-on labs on one retailer's data.
IntermediateCertificate$9.99
Data & AnalyticsLocation Analytics in Excel: Distances, Catchments & Territories
Haversine distances from latitude/longitude, distance matrices, nearest store with INDEX/MATCH, catchment rings, drive-time proxies, territory balancing, the Huff gravity model and weighted site selection with a scatter map: 8 labs on one bakery chain's network.
IntermediateCertificate$9.99
Data & AnalyticsCustomer Segmentation: RFM Scoring, Personas & k-Means by Hand
RFM from a raw order log, quintile scores with PERCENTILE and PERCENTRANK, named segments, segment value charts, z-scores, a k-means iteration by hand, the elbow method and campaign economics: 8 graded labs on one fictional homeware shop.
IntermediateCertificate$9.99
Data & AnalyticsBayesian Statistics in Excel: Priors, Posteriors & Bayesian A/B Tests
Bayes' theorem, step-by-step updating, grid posteriors, Beta-Binomial, prior sensitivity, P(B > A) and expected loss: 8 hands-on labs with an online plant shop.
IntermediateCertificate$9.99
Data & AnalyticsNonparametric Statistics: Rank Tests, Spearman & Bootstrap
Ranks and ties, Mann-Whitney U, Wilcoxon signed-rank, Kruskal-Wallis, Spearman, the sign test and a bootstrap interval: 8 hands-on labs with a food-delivery start-up.
IntermediateCertificate$9.99
Data & AnalyticsCross-Tabs & Chi-Square: Analysing Categorical Data in Excel
Build cross-tabs from raw rows with COUNTIFS, read row and column percentages, compute expected counts, chi-square and Cramér's V by hand, and handle 2 × 2 tables, small samples and paired answers, in a live spreadsheet that checks every cell.
IntermediateCertificate$9.99
Data & AnalyticsNetwork & Graph Analysis in Excel: Degree, Paths & Centrality
Edge lists and adjacency matrices with COUNTIFS, degree, strength and density, a Dijkstra step table, common neighbours with matrix multiplication, closeness, PageRank iterations and edge betweenness: 8 graded labs on a fictional studio network.
IntermediateCertificate$9.99
Data & AnalyticsCustomer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves
Tenure and censoring from raw dates, monthly hazard rates, survival curves and the median lifetime, Kaplan-Meier from a customer list with a step chart, Basic vs Plus curves with a simple log-rank test, LTV from the survival curve, churn drivers with lift and the ROI of a save offer: 8 graded labs on one fictional subscription box.
IntermediateCertificate$9.99
Data & AnalyticsMarket Basket Analysis: Support, Confidence, Lift & Cross-Selling
Item and pair support from 0/1 basket rows, a co-occurrence matrix with SUMPRODUCT and INDEX/MATCH, confidence, lift, leverage and conviction, filtering and ranking rules, the Apriori pruning idea on 3-item sets and a cross-selling plan with expected margin uplift: 8 graded labs on one fictional grocery store.
IntermediateCertificate$9.99
Data & AnalyticsCausal Inference for Business: Difference-in-Differences, Matching & Natural Experiments
Tell cause from correlation in Excel: confounding and Simpson's paradox, randomised tests, difference-in-differences with LINEST, parallel-trend checks, nearest-neighbour matching, propensity-score weighting, regression discontinuity and instrumental variables, in 8 graded labs on one retailer's data.
AdvancedCertificate$9.99
Data & AnalyticsANOVA & Experimental Design in Excel: One-Way, Two-Way & Post-Hoc Tests
Design and analyse experiments in Excel: group means, sums of squares with DEVSQ, the one-way ANOVA table with F.DIST.RT, effect sizes, assumption checks with Levene, Tukey HSD and Bonferroni, randomised blocks and a 2×3 factorial with an interaction plot, in 8 graded labs.
IntermediateCertificate$9.99
Data & AnalyticsPolling & Survey Sampling: Margin of Error, Weighting & Poll Averages
Margins of error with NORM.S.INV, sample sizes for a target margin, the finite population correction, proportional vs equal stratified allocation, post-stratification weights by age and area, Kish's design effect, a weighted poll average with a trend chart and the margin of a lead: 8 graded labs on one fictional city referendum.
IntermediateCertificate$9.99
Data & AnalyticsE-commerce Cohort Analysis: Repeat Purchase, Revenue per Cohort & Payback
First purchase with MINIFS and cohort labels, cohort sizes between two dates, calendar month numbers, a triangle of distinct active customers, a retention heat map, cumulative revenue per customer with a cohort chart, CAC payback by cohort and channel cohorts compared: 8 graded labs on one fictional online shop.
IntermediateCertificate$9.99
Data & AnalyticsData Privacy in Practice: Pseudonymisation, k-Anonymity & Re-identification Risk
Prepare a (fictional, synthetic) health-survey extract for safe sharing: identifier types, pseudonyms and salted IDs, generalisation, k-anonymity with COUNTIFS, suppression and information loss, l-diversity, re-identification risk and a retention schedule, every cell checked live. Educational, not legal advice.
IntermediateCertificate$9.99
Data & AnalyticsQueue Simulation with Spreadsheets: Arrivals, Service Times & Waiting Lines
Simulate a (fictional) coffee kiosk from given random numbers: exponential arrivals, service times, a single-server queue table, utilisation and queue length, a second barista, a check against the M/M/1 formulas with confidence intervals, and a staffing cost trade-off, every cell checked live.
IntermediateCertificate$9.99
Data & AnalyticsData Modeling Basics: Fact Tables, Dimensions, Keys & Star Schemas
Build a small star schema for a fictional retailer by hand: declare the grain, map surrogate keys, join facts to dimensions, build a date dimension, keep history with SCD type 2, avoid bridge-table double counting and run the QA checks a data team runs before every report.
IntermediateCertificate$9.99
Data & AnalyticsCompetitor Price Monitoring: Price Index, Changes & Promotion Detection
Turn scraped competitor prices into decisions: match products across shops, calculate price index and price position, detect price changes and promotions, estimate elasticity from your own price tests, build a repricing rule with a margin floor and a monitoring dashboard.
IntermediateCertificate$9.99
Data & AnalyticsForecast Accuracy & Forecast Value Added: MAPE, WAPE, Bias & FVA
Measure demand forecasts like a planning team: errors, MAPE vs WAPE vs sMAPE, bias and tracking signal, MAE/RMSE by SKU and family, the naive benchmark, an FVA stairstep from statistical to consensus forecast, ABC/XYZ targets and an accuracy dashboard, in 8 hands-on labs on one consumer goods company.
IntermediateCertificate$9.99
Data & AnalyticsIoT Sensor Data Analysis: Resampling, Thresholds, Drift & Uptime
Find gaps in timestamps, resample to hourly averages, measure threshold excursions, compute uptime and completeness, track calibration drift with SLOPE, smooth noise, build hysteresis alarms and a compliance report with MKT: 8 graded labs on a fictional cold-storage warehouse.
IntermediateCertificate$9.99
Data & AnalyticsEnergy Bill & Load Profile Analytics: kWh, Peak Demand & Tariffs
Analyse a small business's 15-minute smart-meter data: kW vs kWh, hourly load profiles with AVERAGEIFS, peak demand and load factor, a time-of-use bill, demand charges and peak shaving, night baseload, weather normalisation with degree days and a three-tariff comparison dashboard: 8 graded labs with illustrative tariffs.
IntermediateCertificate$9.99
Data & AnalyticsEducation Analytics: Attendance, Grades, Pass Rates & Cohort Progress
Analyse a whole college, not just one class: attendance rates and persistent-absence flags, grade distributions and success rates by course, weighted GPA, cohort retention and completion, value added from prior attainment, gaps between student groups, an early-warning risk score and a leadership dashboard: 8 hands-on labs with synthetic data, graded instantly.
IntermediateCertificate$9.99
Data & AnalyticsFraud Detection Rules: Velocity Checks, Rule Scoring & Alert Tuning
Build card-not-present fraud rules the way risk teams do: amount-vs-average, new-device and country features, rolling velocity windows with COUNTIFS, weighted risk scores, precision and dollar recall per threshold, analyst capacity, net benefit, a rule performance table and a champion/challenger test, in 8 graded labs. Synthetic data, defensive training only.
IntermediateCertificate$9.99
Data & AnalyticsIndex Numbers: Laspeyres, Paasche, Fisher & Building a Price Index
Build price indices in Excel from an illustrative café basket: simple indices and rebasing, Carli/Dutot/Jevons, Laspeyres, Paasche and Fisher with SUMPRODUCT, quantity and value indices, chain-linking, deflating to real terms and contributions to inflation. 8 graded labs, no affiliation with any statistics office.
IntermediateCertificate$9.99
Data & AnalyticsSample Size & Power Analysis: How Many Observations Do You Need?
Plan studies, surveys and experiments in Excel: margin of error and sample size for means and proportions, the finite population correction, Cohen's d and the MDE, two-group sample sizes with NORM.S.INV, power curves, power and MDE for a fixed n, and Bonferroni, unequal allocation, dropout and non-response, in 8 graded labs.
IntermediateCertificate$9.99
Data & AnalyticsPrincipal Component Analysis in Excel: Standardise, Covariance, Eigenvectors & Scores
PCA from scratch with formulas: z-scores, covariance and correlation matrices with MMULT, the first eigenvector by power iteration, eigenvalues and explained variance, deflation for PC2, a scree plot, scores and loadings, and reconstruction error: 8 graded labs on a city dataset.
AdvancedCertificate$9.99
Data & AnalyticsData Quality Metrics: Completeness, Validity, Uniqueness, Timeliness & DQ Scorecards
Measure data quality like a data steward: completeness with COUNTBLANK, validity rules, duplicate keys, orphan records across tables, entry lag and freshness against SLAs, accuracy against a verified sample, a weighted DQ scorecard with icon sets and a trend dashboard with the cost of poor data: 8 graded labs on CRM and order data.
IntermediateCertificate$9.99
Data & AnalyticsSurvey Weighting: Post-Stratification, Raking (IPF) & Design Effects
Compare sample and population margins, build post-stratification cell weights, rake a 3 × 3 table to two margins by iterative proportional fitting, trim and rescale extreme weights, compute weighted estimates with SUMPRODUCT, measure Kish's design effect, widen the margin of error and chart the before/after gaps: 8 graded labs on one fictional transit survey. Synthetic data for practice.
IntermediateCertificate$9.99
Data & AnalyticsMeta-Analysis in Excel: Effect Sizes, Fixed vs Random Effects & Forest Plots
Combine the results of several studies step by step in Excel: mean difference, Cohen's d and log odds ratios with their variances, inverse-variance weights, the fixed-effect estimate with CI and z-test, Q, I² and τ² (DerSimonian–Laird), the random-effects model and prediction interval, a forest plot, funnel plot and Egger's test, and leave-one-out sensitivity, in 8 graded labs.
AdvancedCertificate$9.99
Data & AnalyticsProcess Mining with Spreadsheets: Event Logs, Case Durations, Variants & Bottlenecks
Analyse an order-to-cash event log like a process-mining tool, with formulas: cases per month, throughput times with MINIFS/MAXIFS, activity frequency and rework loops, waiting times, TEXTJOIN variants, a directly-follows matrix heat map, a bottleneck chart and a happy-path conformance and SLA check: 8 hands-on labs, graded instantly.
IntermediateCertificate$9.99
Data & Analytics
Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories
Find out what customers want most: ranking scores, best–worst counts, the product line-up that reaches the most people and Kano categories, with every cell checked as you go.
IntermediateCertificate$9.99
Guides with worked examples
How to Calculate NPS in Excel: Formula and Example
How to calculate NPS in Excel with COUNTIF and COUNTIFS: promoters minus detractors, a score from −100 to +100 and its margin of error. Excel example.
How to Calculate MAPE in Excel (with MAE, Bias and WAPE)
How to calculate MAPE in Excel step by step, plus MAE, bias, the tracking signal and WAPE for zero or small actuals. Worked example with every formula.
LINEST in Excel: Multiple Regression with a Worked Example
How to run a multiple regression in Excel with LINEST: coefficients in reverse order, standard errors, t stats, p-values, R² and a forecast. Excel example.
A/B Test Sample Size Calculator: Formula & Excel Example
Calculate A/B test sample size in Excel: baseline rate, minimum detectable effect, 95% significance and 80% power, visitors per variant and test length.
Haversine Formula in Excel: Distance from Latitude/Longitude
The haversine formula in Excel: great-circle distance between two latitude/longitude points in miles or km, step by step, with a ready-to-copy formula.
Mann-Whitney U Test in Excel: Step by Step with p-Value
How to run a Mann-Whitney U test in Excel: ranks with RANK.AVG, rank sums, U, the normal approximation and the p-value. Worked example with formulas.
Frequently asked questions
Do I need Python or SQL for these courses?
No. Everything happens in a spreadsheet, which keeps each step visible. The concepts you learn, such as cleaning, aggregating, testing and forecasting, carry over unchanged if you later move to Python or SQL.
How much statistics do I need to know?
None to begin with. The statistics courses start from averages and spread and introduce each test through a practical question. Comfort with basic formulas such as SUM, AVERAGE and IF is enough.
How much does a course cost?
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
More categories
Ready to learn by doing?
Start with the recommended course and build your first result in the lab today.