{"product_id":"balanced-scorecards-and-operational-dashboards-with-microsoft-excel-isbn-9781118519653","title":"Balanced Scorecards and Operational Dashboards with Microsoft Excel","description":"\u003cp\u003e\u003cb\u003eLearn to maintain and update scorecards and dashboards with Excel\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBalanced 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCovers Excel 2010 back to Excel 2003\u003c\/li\u003e \u003cli\u003eShows how to develop consensus on strategy and operational plans with the executive teams\u003c\/li\u003e \u003cli\u003eDetails steps in creating tactical action plans\u003c\/li\u003e \u003cli\u003eGives step-by-step guidance in creating the most powerful management dashboards\u003c\/li\u003e \u003cli\u003ePuts over ten years of experience in one book\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eBalanced Scorecards \u0026amp; Operational Dashboards with Microsoft Excel, Second Edition\u003c\/i\u003e is the ultimate resource for enhancing your strategic and operational performance.\u003c\/p\u003e \u003cp\u003eIntroduction xxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I Strategic Performance with Balanced Scorecards 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1 Accelerating Strategic Performance 3\u003c\/p\u003e \u003cp\u003eChapter 2 Developing Your Strategic Foundation 17\u003c\/p\u003e \u003cp\u003eChapter 3 Preparing to Build Your Balanced Scorecard 31\u003c\/p\u003e \u003cp\u003eChapter 4 Step-by-Step to Building Your Strategy Map 47\u003c\/p\u003e \u003cp\u003eChapter 5 Step-by-Step from Strategy to Action 61\u003c\/p\u003e \u003cp\u003eChapter 6 Step-by-Step to Selecting Metrics and Setting Targets 71\u003c\/p\u003e \u003cp\u003eChapter 7 Step-by-Step to Developing Your Implementation Plan 85\u003c\/p\u003e \u003cp\u003eChapter 8 Step-by-Step to Rollout and Strategic Reviews 91\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Operational Performance with Dashboards 101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9 Developing Executive and Operational Dashboards 103\u003c\/p\u003e \u003cp\u003eChapter 10 Mapping Your Operational Processes 109\u003c\/p\u003e \u003cp\u003eChapter 11 Identifying Critical Metrics and Key Performance Indicators 121\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Building Maps, Scorecards, and Dashboards 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 12 Creating Dashboards for Decision-Making 135\u003c\/p\u003e \u003cp\u003eChapter 13 Drawing Process and Strategy Maps 147\u003c\/p\u003e \u003cp\u003eChapter 14 Using Microsoft Excel for Balanced Scorecards and Dashboards 157\u003c\/p\u003e \u003cp\u003eChapter 15 Text-Based Dashboards 167\u003c\/p\u003e \u003cp\u003eChapter 16 Custom Labels and Formatting 183\u003c\/p\u003e \u003cp\u003eChapter 17 Working with Data That Changes Size 207\u003c\/p\u003e \u003cp\u003eChapter 18 Retrieving Data from Lists and Tables of Data 229\u003c\/p\u003e \u003cp\u003eChapter 19 Creating Miniature Charts and Tables 243\u003c\/p\u003e \u003cp\u003eChapter 20 Controlling Charts with Menus, Combo Boxes, and Buttons 267\u003c\/p\u003e \u003cp\u003eChapter 21 Working with PivotTables 283\u003c\/p\u003e \u003cp\u003eChapter 22 Working with PowerPivot 297\u003c\/p\u003e \u003cp\u003eChapter 23 Smoothing Data and Forecasting Trends 317\u003c\/p\u003e \u003cp\u003eChapter 24 Identifying Targets and Displaying Alerts 331\u003c\/p\u003e \u003cp\u003eChapter 25 Building Powerful Decision-Making Charts 347\u003c\/p\u003e \u003cp\u003eChapter 26 Drilling to Detail 371\u003c\/p\u003e \u003cp\u003eChapter 27 Using Excel Add-ins for Extra Capabilities 385\u003c\/p\u003e \u003cp\u003eChapter 28 Finishing Touches 395\u003c\/p\u003e \u003cp\u003eChapter 29 Data Integration Methods 405\u003c\/p\u003e \u003cp\u003eChapter 30 Publishing Balanced Scorecards and Dashboards 425\u003c\/p\u003e \u003cp\u003eIndex 441\u003c\/p\u003e \u003cp\u003e\u003cb\u003eRon Person\u003c\/b\u003e 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eDrive strategic performance with Balanced Scorecards and operational dashboards\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBalanced 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUnderstand how and why Balanced Scorecards work\u003c\/li\u003e \u003cli\u003eDevelop your strategic foundation, build your strategy map, select metrics, and set targets\u003c\/li\u003e \u003cli\u003eCreate executive and operational dashboards to aid in decision-making\u003c\/li\u003e \u003cli\u003eIdentify critical metrics and key performance indicators\u003c\/li\u003e \u003cli\u003eExamine the pros and cons of using Excel so you can leverage its power\u003c\/li\u003e \u003cli\u003eProvide more information with miniature charts and tables\u003c\/li\u003e \u003cli\u003eSmooth data, forecast trends, and display alerts\u003c\/li\u003e \u003cli\u003ePublish with PowerPoint templates or in secure formats\u003c\/li\u003e \u003cli\u003eAdd extra functionality to Excel\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988786692325,"sku":"NP9781118519653","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118519653.jpg?v=1761781586","url":"https:\/\/k12savings.com\/es\/products\/balanced-scorecards-and-operational-dashboards-with-microsoft-excel-isbn-9781118519653","provider":"K12savings","version":"1.0","type":"link"}