Trade in Yours
For a 2.78 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Balanced Scorecards and Operational Dashboards with Microsoft Excel [Paperback]

Ron Person
4.8 out of 5 stars  See all reviews (10 customer reviews)

Available from these sellers.

Trade In this Item for up to 2.78
Trade in Balanced Scorecards and Operational Dashboards with Microsoft Excel for an Amazon Gift Card of up to 2.78, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
Balanced Scorecards & Operational Dashboards with Microsoft Excel Balanced Scorecards & Operational Dashboards with Microsoft Excel 5.0 out of 5 stars (1)
In stock.

Book Description

19 Dec 2008
Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.

Product details

  • Paperback: 480 pages
  • Publisher: John Wiley & Sons; 1 edition (19 Dec 2008)
  • Language: English
  • ISBN-10: 0470386819
  • ISBN-13: 978-0470386811
  • Product Dimensions: 18.9 x 2.6 x 23.6 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Bestsellers Rank: 273,818 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description


"This title is a guide to how an organization can create competitive advantage by successfully executing strategy and accelerating performance."  ( Accountancy Ireland , October 2010)

From the Back Cover

Create Balanced Scorecards and operational dashboards that drive success Balanced Scorecards help organizations clarify their strategy, translate strategy into action, and successfully execute their strategy. Operational dashboards are critical for monitoring and managing high performance. This book is a guide for those who define and build these business performance tools: executive sponsors, operational managers, facilitators, and Excel developers. Based on years of experience, these step–by–step methods will help you develop Balanced Scorecards and operational dashboards that drive strategic execution and operational performance. Write a strategic Destination Statement that clarifies your vision Build a Strategy Map illustrating strategic objectives and the causal links that drive success Map operational processes to identify leverage points with the greatest impact Identify the "critical few" metrics that drive and measure success Gain buy–in with Tactical Action Plans and Implementation Plans Build impressive, dynamic Excel scorecards and dashboards using only spreadsheet functions Build powerful charts and analyses that aid business decision making Develop portable Balanced Scorecards that are secure and easy to maintain Companion Web site Download free Excel sample files at You can also find additional resources on Balanced Scorecards and operational dashboards at

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

3 star
2 star
1 star
4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
16 of 16 people found the following review helpful
5.0 out of 5 stars Take reporting to another level 27 Aug 2010
As an advanced Excel user, I have been looking for a book on Excel that actually taught me something. I have developed Balanced Scorecards in the past and with my current professional focus being board level reporting for a portfolio of operational projects, the subject matter of this book was of interest for a number of reasons.

The book provides guidance towards developing your own Balanced Scorecards, helping you to work out what you need to report, before moving into the domain of handling data and creating charts and tables. I am excited by the discovery of the concept of operational dashboards, this has enabled me to develop some of the ideas that I had developed alone and not quite known how. I have instantly changed the way I use Excel to handle data, using methods and functions that are far more robust, and critically - easily scalable. The Micro-Chart function, a recommended Add-In, is excellent, well worth the cost and will transform the presentation of reports.

Overall, this book is highly recommended if you want to take your reporting to a higher level, critically if you want to produce `apparently' simple reports (ie. That look simple but present a lot of clear and useful information) to aid decision making.
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
The title of the book immediately caught my eye as I am currently in the process of creating my first BSC for my organisation. This is an excellent reference book that, especially for debutant BSCers (albeit with years of experience with using Excel nonetheless) such as myself, provides the why, what and hows of the BSC in addition to the who (can make it happen) and when.

For me the most valuable part of the book is that before launching into how to design the BSC in using Excel, the author first of all sets the context as to why creating the BSC is important and the resources you need (genuine stakeholder/senior management commitment/mission statements/vision statements/organisational plans etc) as the bare minimum on which to start the process. From there, it's up to the reader to then make of it what they will.

The book has provided me with the not only the practical knowledge of how to use particular techniques, but also the theoretical underpinning in order to make whatever is included within our company's BSC meaningful and purposeful.

Now when I talk to stakeholders about our BSC, the conversations have more meaning about what objectives we are trying to acheive and who owns which part of the process, as well as the confidence to question the most senior stakeholders what exactly is it they want in order to make sure that the efforts made to get the data (which may involve new processes and take time to produce) worthwhile.

Further, the book is littered with words of wisdom and references to the creators of the BSC (Kaplan & Norton) and other management luminaries such as Peter Drucker.

All in all a very useful and interesting read and comes as highly recommended. MW.
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
5.0 out of 5 stars This book delivers exactly what the title says 25 Sep 2009
The Balanced Scorecards & Operational Dashboards delivers exactly what the title says. This is a great book, and it's amazing how well the author managed to embrace the theory down to the formula in Excel. During this journey Ron walks you through many very interesting topics such as strategic maps and underpinning tools, guidance in facilitating vision workshops and lots of useful ways to build strategies - and how to implement them.
Furthermore there are many useful links and ideas. Normally the downsides always exist but in this case I having trouble finding any. This will book will be an important part of my work with BSC.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent Book 29 April 2012
Format:Paperback|Verified Purchase
I purchased this book because I am a jobseeker with a background in Loss Prevention, which involved a lot of data analysis and reporting to the tall chairs upstairs. The book takes you through Balanced Scorecards, preparation and presentation, and getting the support for your project to integration. It's all there; SWOT analysis, Change State, Iniative Matrix and Strategy Maps and honing the critical factors.

The real gem for me is the structure of Operational Dashboards where Ron takes you by chapter through the range of functions (using MATCH & INDEX instead of VLOOKUP and arguing that VLOOKUP lacks the operational diversity of MATCH and INDEX). It's all in there as basics; Pivots and microcharts, custom labels, formatting, Lists and Tables, inter-active charts, forecasting, targets and alerts, drilling, add-ins, finishing touches, intergration and publishing.

The book sets out the groundwork. It's up to you to further your research and get the skills but it made me go further with Excel, which in itself is the most powerful program I've ever used and amazingly diverse. Will it get me that statistical or analytical job? That's up to me too and I'm pushing for it.

As a sideline, I registered with Ron's website and got a welcoming email asking why I bought the book? This made it feel very personal. It all feels very organised and I have not put the book away on the shelf since buying it.
If you want all the answers, it isn't in this book with such a huge spectrum of matter but it gives you the groundwork and it suggests where to find the expertise. Nice one. Top marks from me.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
5.0 out of 5 stars So much about strategy I didn't know, so much about Excel I didn't...
I consider myself reasonably good at both strategic consulting and MS Excel. I do management consulting for a living, and I regularly write simulation model spreadsheets and... Read more
Published 4 months ago by Hugo Minney
5.0 out of 5 stars Excellent Book
Good book for people who have been out of touch with modern business management theory. Gives good back ground to what Balanced Score Card and why we need it. Read more
Published 13 months ago by Nanday
5.0 out of 5 stars Excellent
The book is indeed a valuable must have for any accountant or management consultant as It gives a multidimensional view of the business in a simple, practical and succinct way. Read more
Published on 30 Jun 2011 by Andrew
4.0 out of 5 stars Good enough to get into BI world
If you are looking for a general picture of the BI world and Excel capabilities then this is the right book. Read more
Published on 8 Sep 2010 by michaelsamba
5.0 out of 5 stars A Very Worthwhile Purchase
This book provides a comprehensive overview of the subject. It also has excellent 'work-through' examples of various techniques which can be used in Microsoft Excel when developing... Read more
Published on 23 Sep 2009 by Paul J. Travers
4.0 out of 5 stars Consolidation of advances made on this subject in recent years
I liked this book. having bought several on the subject, I found this incorporated the information and techniques introduced over the past few years and then some. Read more
Published on 19 Feb 2009 by Philip Adams
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category