Pivot-Style Summary Tables with SUMIFS & COUNTIFS
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- 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