A One-Page KPI Dashboard with a Chart
This lesson is part of the course
In this lesson
You build the half-year dashboard for the team meeting: gross margin per month, the best month, the average order value and a combo chart.
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
- Sharing-Ready Tables: Tidy Data, Totals and Checks Locked
- SUMIFS and COUNTIFS Reports (and QUERY in Sheets) Locked
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE) Locked
- Text and Dates: Clean Names, Build IDs and Due Dates Locked
- Data Validation Logic: Checking Form Responses with Formulas Locked
- Conditional Formatting for a Shared Inventory Sheet Locked
- A One-Page KPI Dashboard with a Chart Locked
- Team Task Tracker: Status Counts and Overdue Items Locked