Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Controller KPI Dashboard - [Excel + Course] One KPI Dashboard To Run A Business
Module One – Understanding the Controller KPI Dashboard
Course Information, Learning Objectives & Glossary
About The Instructor (0:42)
Controller KPI Dashboard Template – Download
Module 1 Learning Objectives
M1 Lecture 1: Controller KPI Dashboard Overview (1:43)
M1 Lecture 2: How to Read and Interpret the Dashboard (2:43)
M1 Lecture 3: How to Populate the Dashboard (3:00)
Module 1 Review Quiz
Module Two – Designing the KPI Dashboard
Module 2 Learning Objectives
M2 Lecture 1: Dashboard Design Overview (1:24)
M2 Lecture 2: Selecting Key Performance Indicators (KPIs) (3:49)
M2 Lecture 3: Understanding the Flow of Data (2:54)
M2 Lecture 4: Dashboard Layout and Visual Design (1:17)
Module 2 Review Quiz
Module Three – Excel Functions for KPI Dashboards
Module 3 Learning Objectives
M3 Lecture 1: Using INDEX/MATCH in the Dashboard (9:45)
M3 Lecture 2: Applying Conditional Formatting (2:49)
M3 Lecture 3: Creating Drop-Down Lists (1:19)
M3 Lecture 4: Creating and Using Hyperlinks (4:06)
Module 3 Review Quiz
Review Quiz Answers Explained
Module Four – Maintaining and Troubleshooting the KPI Dashboard
Module 4 Learning Objectives
M4 Lecture 1: Adding New KPIs to the Dashboard (7:09)
M4 Lecture 2: Troubleshooting #N/A Errors (3:19)
M4 Lecture 3: Troubleshooting #DIV/0! Errors (2:02)
M4 Lecture 4: Troubleshooting Conditional Formatting (2:41)
Module 4 Review Quiz
Review Quiz Answers Explained
Final Assessment
Please provide course evaluation!
Final CPE Assessment
Continue Your Learning
⭐ Explore the CFO Bundle – Exclusive 45% Student Discount
M4 Lecture 4: Troubleshooting Conditional Formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock