Excel: Implementing Balanced Scorecards with KPIs
Offered By: LinkedIn Learning
Course Description
Overview
Discover how to use Excel to create a balanced scorecard to measure business performance based on financial, process, customer, and learning and growth metrics.
Syllabus
Introduction
- Measure business performance with a balanced scorecard
- What you should know
- The balanced scorecard methodology
- The four perspectives of a balanced scorecard
- Defining key performance indicators (KPIs)
- Introducing the course's scenario
- Determine objectives with each perspective
- Identify barriers to successful implementation
- Generate and maintain momentum
- Measure program effectiveness
- Create a PivotTable from an external data source
- Import a large data set into Excel
- Add data icon conditional formats
- Create a conditional formatting rule based on a formula
- Change PivotTable views using GETPIVOTDATA formulas
- Next steps
Taught by
Curt Frye
Related Courses
Using Covid-19 Data to Make Supply Chain Logistics Decisions in SpreadsheetsCoursera Project Network via Coursera Microsoft Excel - Excel from Beginner to Advanced
Udemy Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Microsoft Excel Mastery: From Beginner to Pro
Udemy