A One-Page KPI Dashboard with a Chart
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Sharing-Ready Tables: Tidy Data, Totals and ChecksFree
- SUMIFS and COUNTIFS Reports (and QUERY in Sheets)Free
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE) Pro
- Text and Dates: Clean Names, Build IDs and Due Dates Pro
- Data Validation Logic: Checking Form Responses with Formulas Pro
- Conditional Formatting for a Shared Inventory Sheet Pro
- A One-Page KPI Dashboard with a Chart Pro
- Team Task Tracker: Status Counts and Overdue Items Pro