Business Analytics in Excel
KPIs, pivot-style summaries, rankings, Pareto, trends, statistics, forecasts and cohorts: 8 labs on realistic business data.
The first lesson is free — no account needed.
About this course
A hands-on Excel data analysis course for everyday business questions. You calculate KPIs such as growth, margin and average order value, build pivot-style summaries with SUMIFS and COUNTIFS, rank with RANK, LARGE and INDEX/MATCH, run Pareto (ABC) and budget-versus-actual analysis, describe data with medians and percentiles, fit a linear trend and track customer cohorts, in eight graded spreadsheet labs.
Lessons
- KPI Basics: Growth, Margin & Average Order ValueFree
- Pivot-Style Summary Tables with SUMIFS & COUNTIFS Pro
- Top-N & Ranking: RANK, LARGE, INDEX/MATCH Pro
- Contribution & Pareto (ABC) Analysis Pro
- Variance & Trend: MoM, YoY, Moving Average, Budget vs Actual Pro
- Descriptive Statistics: Median, Spread, Percentiles, Outliers Pro
- Simple Forecasting with a Linear Trend Pro
- Customer Cohorts & Retention Pro