Top-N & Ranking: RANK, LARGE, INDEX/MATCH
This lesson is part of the course
In this lesson
You rank 12 outdoor products by revenue, find the leaders and measure how concentrated sales are.
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