A Month Picker: INDEX/MATCH & SUMIFS-Driven KPIs
This lesson is part of the course
In this lesson
You build a month picker: one input cell drives the KPI cards (via INDEX/MATCH) and a region chart (via SUMIFS), so the whole dashboard switches to another month when you type a new one.
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
- Plan the Dashboard: Questions, KPIs & Layout Locked
- KPI Cards with Green/Red Rules Locked
- The Trend Chart: This Year vs Last Year Locked
- Category Breakdown: A Sorted Bar Chart with Labels Locked
- Sparklines: A Trend in Every Region Row Locked
- Target vs Actual: Combo Charts & the Secondary Axis Locked
- A Month Picker: INDEX/MATCH & SUMIFS-Driven KPIs Locked
- Final Project: The One-Page Sales Report Locked