Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Balanced Scorecards and Operational Dashboards with Microsoft Excel

Balanced Scorecards and Operational Dashboards with Microsoft Excel [Kindle Edition]

Ron Person
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £33.99
Kindle Price: £21.01 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £12.98 (38%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £21.01  
Paperback £23.11  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Product Description

Product Description

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.

From the Back Cover

Drive strategic performance with Balanced Scorecards and operational dashboards Balanced Scorecards help translate business strategy into action. Performance dashboards are critical for monitoring operations and tactics. This fully updated guide shows you how to create and implement a program of Balanced Scorecards and dashboards using Excel, the preferred tool for the job. Incorporating the latest enhancements, it leads you step by step through the process, preparing you to leverage these tools for improved performance in your organization. Understand how and why Balanced Scorecards work Develop your strategic foundation, build your strategy map, select metrics, and set targets Create executive and operational dashboards to aid in decision–making Identify critical metrics and key performance indicators Examine the pros and cons of using Excel so you can leverage its power Provide more information with miniature charts and tables Smooth data, forecast trends, and display alerts Publish with PowerPoint templates or in secure formats Add extra functionality to Excel

Product details

  • Format: Kindle Edition
  • File Size: 14973 KB
  • Print Length: 480 pages
  • Publisher: Wiley; 2 edition (9 Jan 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00B9TS828
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #223,044 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Excellent 11 Sep 2013
Format:Paperback|Verified Purchase
Purchased this to refresh my Excel skills. It does exactly what it says - it has taught me a lot.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.5 out of 5 stars  6 reviews
6 of 6 people found the following review helpful
5.0 out of 5 stars Covers a lot more than just how to build Balanced Scorecards 3 Nov 2013
By Amazon Customer - Published on
Format:Kindle Edition|Verified Purchase
After looking over some reviews and quickly glancing through a copy at a bookstore, I bought this book specifically to learn about PowerPivot and other Excel techniques that I could use to create efficient and effective management reporting (dashboards or otherwise). Considering myself an experience, intermediate level Excel user, I found the book more useful than I expected. Before getting into specifics about Excel for dashboards, the author, Ron Person, spends a great deal of time providing background on what makes a good scorecard, etc. -- a dashboard primer. He offers practical advice on the up-front work needed to create a good dashboard and potential pitfalls of not doing your homework.

When it comes to Excel techniques, he takes great pains to illustrate simple constructs that can be carried out in several generations of Excel and / or points out what would need to be done to accomplish the same or similar. I was surprised at how many "general" Excel techniques I picked-up, including learning about functions I never thought I would use, like REPT (repetition of text) that I assumed was some esoteric text function. Being exposed to the CAMERA functionality (a tool I had never heard of before) was a revelation -- I don't know why this feature of Excel hasn't been more heavily promoted.

Finally, he not only includes links to examples and test data that you can use to practice the techniques he covers, but he provides a generous compliment of links and references to other websites that either provide further information or complimentary material on such things as color palettes (choosing the right colors for dashboard elements).

I know I will be referring back to this book often for additional tips and tricks to improve my capabilities with Excel.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great book for BI's who work only with Excel 27 Sep 2013
By Luis Py - Published on
Format:Paperback|Verified Purchase
The book is a great tool to find new perspectives in the generation of new format and displays for KPI's tables and sheet. It could be useful for intermediate and advanced Excel user. Specially, if you have read the Stephen Few's books, this is the appropiate book to read in order to apply the learning in Excel.
1 of 1 people found the following review helpful
5.0 out of 5 stars Worth the Read 25 Mar 2013
By Kelly R. Estes - Published on
Format:Kindle Edition|Verified Purchase
Great source for developing a balanced scorecard and dashboard. This book provides step by step guidance from strategy to execution.
4.0 out of 5 stars Very good book on Balanced Scorecards 25 Jun 2013
By David Stong - Published on
Format:Paperback|Verified Purchase
This an exceptional book for just about any level of Scorecard user, I found it to be both informative and a valuable reference resource. This alone would have gotten it five stars....BUT I personally felt the sections on operational dashboards detracted from a great book.

If you need to know about dashboards Steven Few has some exceptional works out there.

Again my personal feelings are that Ron Person's efforts would have been better spent focusing entirely on Balanced Scorecards.
4.0 out of 5 stars Recommended, even for the intermediate users 4 Jun 2013
By Cheng Yi Chiao - Published on
Format:Paperback|Verified Purchase
This book predominantly focuses on MS office (2003 to 2010) so it does cover the full range and the author understands the pains of backward compatibility. If you are an openoffice use or IBM Symphony user, this book is not for you.

What I loved most is the description of the addons in excel I never knew existed. ASAP and Powerpivot being two of them.

The author also details some of the hidden functionality of excel, however if you are an excel power user, it may not be of interest to you.

Overall good, but a bit pricey for close to 30 bucks
Were these reviews helpful?   Let us know
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