25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 6, 2014

Graham Joyce: IMG The Powell’s Playlist: Graham Joyce



The Ghost in the Electric Blue Suit is set on the English coast in the hot summer of 1976, so the music in this playlist is pretty much all from the... Continue »
  1. $17.47 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Microsoft Windows- Windows 95 General
5 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
12 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

This title in other editions

Balanced Scorecards & Operational Dashboards with Microsoft Excel

by

Balanced Scorecards & Operational Dashboards with Microsoft Excel Cover

 

Synopses & Reviews

Publisher Comments:

Balanced Scorecards help organizations translate strategy into action. Operational dashboards enable managers to monitor operations and tactics.  Balanced Scorecards and operational dashboards are in high use and high demand in for profit and non-profit organizations. The primary tool used to create Balanced Scorecards and operational dashboards is Microsoft Excel. Although Microsoft Excel is widely used for developing scorecards and dashboards, most developers become frustrated and do not develop adequate or maintainable solutions.

This title will show medium and advanced level Microsoft Excel users how to create robust, maintainable and dynamically updated scorecards and dashboards. No other book covers both scorecards and dashboards with Excel. This book will cover several versions of Excel, so companies who have not yet upgraded to 2010 will still find this book useful and applicable for data visualization and overall business strategy. While there are many books devoted to Balanced Scorecards, operational dashboards, performance management and data visualization, there are no books focused on how to combine those and then implement them in Microsoft Excel. Important additions/updates to this edition:

  1. Important content applicable to 2003, 2007, or 2010, any of which are still being used by thousands of corporations
  2. More examples for accelerating strategic performance
  3. New strategy map examples
  4. Creating a tactical action plan
  5. Sample metrics and benchmark sources
  6. Web-based project tracking tools
  7. More business mapping
  8. New section on drawing with SmartArt
  9. Leveraging power pivots and icons and graphics
  10. Creating dynamic charts and color scales
  11. New chapter on working with power pivots
  12. New chapter on Excel and Extra Capabilities

Synopsis:

Learn to maintain and update scorecards and dashboards with Excel

Microsoft Excel is the most commonly used tool to develop balanced scorecards and performance dashboards. Offering comprehensive coverage, this book is the only one of its kind to cover both scorecards and dashboards with Excel. The author addresses the technical and strategic features vital to using Excel to create robust, maintainable and dynamically updated scorecards and dashboards and then explains how to implement them in Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers to monitor operations and tactics.

  • Covers several versions of Excel for anyone who has not upgraded to the 2010 version yet
  • Presents new strategy map examples and examples for accelerating strategic performance
  • Shares sample metrics and benchmark sources
  • Details how to create a tactical action plan
  • Includes a new section on drawing with SmartArt, working with power pivots, and maximizing the capabilities of Excel
  • Discusses web-based project tracking tools and sample metrics and benchmark sources

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

About 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.

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

Product Details

ISBN:
9781118519653
Author:
Person, Ron
Publisher:
Wiley
Subject:
Spreadsheets - General
Subject:
Microsoft Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Balanced scorecards, monitor operations, operational dashboards, business metrics, performance managements, data visualization, implement balanced scorecards in Excel, implement operational dashboards in Excel, Microsoft Excel
Copyright:
Edition Description:
WebSite Associated w/Book
Publication Date:
20130122
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Pages:
480
Dimensions:
232.39 x 185.39 x 25.099 mm 24.32 oz

Other books you might like

  1. Handbook of Energy Engineering,... New Hardcover $129.95
  2. VMware vSphere Design Used Trade Paper $42.00

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Balanced Scorecards & Operational Dashboards with Microsoft Excel New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 480 pages John Wiley & Sons - English 9781118519653 Reviews:
"Synopsis" by , Learn to maintain and update scorecards and dashboards with Excel

Microsoft Excel is the most commonly used tool to develop balanced scorecards and performance dashboards. Offering comprehensive coverage, this book is the only one of its kind to cover both scorecards and dashboards with Excel. The author addresses the technical and strategic features vital to using Excel to create robust, maintainable and dynamically updated scorecards and dashboards and then explains how to implement them in Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers to monitor operations and tactics.

  • Covers several versions of Excel for anyone who has not upgraded to the 2010 version yet
  • Presents new strategy map examples and examples for accelerating strategic performance
  • Shares sample metrics and benchmark sources
  • Details how to create a tactical action plan
  • Includes a new section on drawing with SmartArt, working with power pivots, and maximizing the capabilities of Excel
  • Discusses web-based project tracking tools and sample metrics and benchmark sources

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

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.