BN.com Gift Guide

Balanced Scorecards and Operational Dashboards with Microsoft Excel

Overview

Learn to maintain and update scorecards and dashboards with Excel

Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that ...

See more details below
Paperback
$32.38
BN.com price
(Save 35%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (20) from $24.91   
  • New (15) from $26.58   
  • Used (5) from $24.91   

Overview

Learn to maintain and update scorecards and dashboards with Excel

Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations.

  • Covers Excel 2010 back to Excel 2003
  • Shows how to develop consensus on strategy and operational plans with the executive teams
  • Details steps in creating tactical action plans
  • Gives step-by-step guidance in creating the most powerful management dashboards
  • Puts over ten years of experience in one book

Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.

Read More Show Less

Product Details

  • ISBN-13: 9781118519653
  • Publisher: Wiley
  • Publication date: 1/14/2013
  • Edition number: 2
  • Pages: 480
  • Sales rank: 482,374
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.20 (d)

Meet the Author

Ron Person is a senior consultant of business optimization at Sitecore. For the 27 years prior to that, Ron's independent consulting firm helped organizations clarify their strategy and build measurable high performance. His clients included Medtronic Vascular, the U.S. Navy, Naval Undersea Warfare Center, the U.S. Army Corps of Engineers, and the Motion Picture Artists Association.

Read More Show Less

Table of Contents

Introduction xxvii

Part I Strategic Performance with Balanced Scorecards 1

Chapter 1 Accelerating Strategic Performance 3

Chapter 2 Developing Your Strategic Foundation 17

Chapter 3 Preparing to Build Your Balanced Scorecard 31

Chapter 4 Step-by-Step to Building Your Strategy Map 47

Chapter 5 Step-by-Step from Strategy to Action 61

Chapter 6 Step-by-Step to Selecting Metrics and Setting Targets 71

Chapter 7 Step-by-Step to Developing Your Implementation Plan 85

Chapter 8 Step-by-Step to Rollout and Strategic Reviews 91

Part II Operational Performance with Dashboards 101

Chapter 9 Developing Executive and Operational Dashboards 103

Chapter 10 Mapping Your Operational Processes 109

Chapter 11 Identifying Critical Metrics and Key Performance Indicators 121

Part III Building Maps, Scorecards, and Dashboards 133

Chapter 12 Creating Dashboards for Decision-Making 135

Chapter 13 Drawing Process and Strategy Maps 147

Chapter 14 Using Microsoft Excel for Balanced Scorecards and Dashboards 157

Chapter 15 Text-Based Dashboards 167

Chapter 16 Custom Labels and Formatting 183

Chapter 17 Working with Data That Changes Size 207

Chapter 18 Retrieving Data from Lists and Tables of Data 229

Chapter 19 Creating Miniature Charts and Tables 243

Chapter 20 Controlling Charts with Menus, Combo Boxes, and Buttons 267

Chapter 21 Working with PivotTables 283

Chapter 22 Working with PowerPivot 297

Chapter 23 Smoothing Data and Forecasting Trends 317

Chapter 24 Identifying Targets and Displaying Alerts 331

Chapter 25 Building Powerful Decision-Making Charts 347

Chapter 26 Drilling to Detail 371

Chapter 27 Using Excel Add-ins for Extra Capabilities 385

Chapter 28 Finishing Touches 395

Chapter 29 Data Integration Methods 405

Chapter 30 Publishing Balanced Scorecards and Dashboards 425

Index 441

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)