Variance & Trend: MoM, YoY, Moving Average, Budget vs Actual
This lesson is part of the course
In this lesson
You analyse 24 months of revenue: month-over-month, year-over-year, a smoothed trend and the budget variance.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- KPI Basics: Growth, Margin & Average Order Value Locked
- Pivot-Style Summary Tables with SUMIFS & COUNTIFS Locked
- Top-N & Ranking: RANK, LARGE, INDEX/MATCH Locked
- Contribution & Pareto (ABC) Analysis Locked
- Variance & Trend: MoM, YoY, Moving Average, Budget vs Actual Locked
- Descriptive Statistics: Median, Spread, Percentiles, Outliers Locked
- Simple Forecasting with a Linear Trend Locked
- Customer Cohorts & Retention Locked