Excel: Implementing Balanced Scorecards with KPIs
Excel: Implementing Balanced Scorecards with KPIs
Duration: 1h 4m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 140 MB
Genre: eLearning | Language: English
Duration: 1h 4m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 140 MB
Genre: eLearning | Language: English
Discover how to use Excel to create a balanced scorecard to measure business performance based on data available throughout your organization. This course shows intermediate Excel users how to capture metrics related to the financial, process, customer, and learning and growth aspects of their business and display them in an easy-to-understand visualization built entirely in Excel. Instructor Curt Frye provides an overview of balanced scorecards, including the four perspectives and related key performance indicators (KPIs). He then shows how to ingest data from various sources and levels of the organization into dashboards that summarize overall performance, using popular Excel features such as PivotTables and conditional formatting.
More Info