Balanced Scorecards and Operational Dashboards with Microsoft Excel

Introduction

Part I Strategic Performance with Balanced Scorecards
1 Accelerating Strategic Performance
2 Developing Your Strategic Foundation
3 Preparing to Build Your Balanced Scorecard
4 Step-by-Step to Building Your Strategy Map
5 Step-by-Step from Strategy to Action
6 Step-by-Step to Selecting Metrics and Setting Targets
7 Step-by-Step to Developing Your Implementation Plan
8 Step-by-Step to Rollout and Strategic Reviews

Part II Operational Performance with Dashboards
9 Developing Executive and Operational Dashboards
10 Mapping Your Operational Processes
11 Identifying Critical Metrics and Key Performance Indicators

Part III Building Maps, Scorecards, and Dashboards
12 Creating Dashboards for Decision-Making
13 Drawing Process and Strategy Maps
14 Using Microsoft Excel for Balanced Scorecards and Dashboards
15 Text-Based Dashboards
16 Custom Labels and Formatting
17 Working with Data That Changes Size
18 Retrieving Data from Lists and Tables of Data
19 Creating Miniature Charts and Tables
20 Controlling Charts with Menus, Combo Boxes, and Buttons
21 Working with PivotTables
22 Working with PowerPivot
23 Smoothing Data and Forecasting Trends
24 Identifying Targets and Displaying Alerts
25 Building Powerful Decision-Making Charts
26 Drilling to Detail
27 Using Excel Add-ins for Extra Capabilities
28 Finishing Touches
29 Data Integration Methods
30 Publishing Balanced Scorecards and Dashboards

Index