Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Controller KPI Dashboard - [Excel + Course] One KPI Dashboard To Run A Business
Controller KPI Dashboard
Download Template
Overview (1:43)
How to Read Dashboard (2:43)
How to Populate Dashboard (3:00)
Dashboard Design
Build Overview (1:24)
Choice of KPIs (3:49)
Flow of Data (2:54)
Font, color, tiles (1:17)
Dashboard Excel Functions
Index/Match (9:45)
Conditional Formatting (2:49)
Drop-down Menu (1:19)
Hyperlinks (4:06)
How To Add New KPIs
Add New KPIs (7:09)
Troubleshooting
#N/A Error (3:19)
#DIV/0 Error (2:02)
Conditional Formatting Errors (2:41)
Bonus - Balance Sheet Ratio Cheat Sheet
Download Balance Sheet Ratio Cheat Sheet
Flow of Data
Complete and Continue