Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

by Elliot Bendoly

Overview

This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service professionals and students. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised, with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration, including methodical discussions of problem structuring and evaluation, as well as numerous case examples from practice.

Product Details

ISBN-13:	9781108738361
Publisher:	Cambridge University Press
Publication date:	05/28/2020
Edition description:	3rd Revised ed.
Pages:	450
Product dimensions:	6.97(w) x 9.92(h) x 0.79(d)

About the Author

Elliot Bendoly is Distinguished Professor of Management Sciences at the Fisher College of Business, Ohio State University. He serves as an associate editor for the Journal of Operations Management, a senior editor for Production and Operations Management, and an associate editor for Decision Sciences. His previously published books include (as co-editor) Visual Analytics for Management (2016) and The Handbook of Behavioral Operations Management (2015).

Table of Contents

Section 1. Getting Oriented: 1. Necessary Foundations for Decision Support; 2. The Common Development Environment; 3. Acquisition, Cleaning and Consolidation; Section 2. Structuring Intelligence: 4. Estimating and Appreciating Uncertainty; 5. Visualizing Estimates, System Dynamics and Risk; Section 3. Prescription Development: 6. The Analytics of Solution Search; 7. Searches in Highly Complex and Uncertain Landscapes; Section 4. Advanced Automation and Interfacing: 8. VBA Editing and Code Development; 9. Application and User Interfacing; Glossary of Key Terms; Appendix A: Workbook Shortcut (Hot Key) Reference; Appendix B: Blackbelt Ribbon Add-In Tools and Functions.

What People are Saying About This

From the Publisher

“There's nothing else out there that covers the full potential of Excel in the way that this text does. It's easy to read even if you're a novice to graphical decision support tool development, but it has gems that I doubt some of the most advanced developers are even aware of. The presentation of various approaches to leveraging Excel with other applications such as MS MapPoint, XLStat and RISKOptimizer is particularly valuable. Similarly eye-opening are the unique tactics Bendoly presents for capitalizing on many of the built-in but underutilized capabilities of Excel. The application examples provided serve as the building blocks for a whole universe of DSS development now made accessible to readers at all levels. This book should become a standard reference for analysts and consultants regardless of industry.”
Daniel Bachrach, University of Alabama

“This is a must book for people seeking to get the best out of the wonderful tool of Excel. It fits in the sweet spot between the “Excel made simple” and the math and stat based Excel technical manuals. The practical feel of the book is conveyed through such evocative section headings as Harvesting Intelligence and Leveraging Dynamic Analysis. Though each of the chapters is worthy of comment, I think that Chapter 9, Scenario Generation and Optimization is of particular interest to managers wanting to put some real muscle behind their search for the best decision in the face of uncertainty. All together, this book is a major contribution to the business literature.”
Richard B. Chase, University of Southern California

“Excel is the duct tape of decision support – handy, pervasive, and surprisingly effective. Bendoly's book helps users unlock its considerable power while avoiding costly errors. You'll be amazed at all you can do with a spreadsheet.”
Thomas H. Davenport, Babson College

Editorial Reviews

Review of previous edition: 'There's nothing else out there that covers the full potential of Excel in the way that this text does. It's easy to read even if you're a novice to graphical decision support tool development, but it has gems that I doubt some of the most advanced developers are even aware of. The presentation of various approaches to leveraging Excel with other applications such as MS MapPoint, XLStat, and RISKOptimizer is particularly valuable. Similarly eye-opening are the unique tactics Bendoly presents for capitalizing on many of the built-in but underutilized capabilities of Excel. The application examples provided serve as the building blocks for a whole universe of DSS development now made accessible to readers at all levels. This book should become a standard reference for analysts and consultants regardless of industry.' Daniel Bachrach, University of Alabama

Review of previous edition: 'This is a must-read book for people seeking to get the best out of the wonderful tool of Excel. It fits in the sweet spot between the 'Excel made simple' and the math- and stat-based Excel technical manuals. The practical feel of the book is conveyed through such evocative section headings as Harvesting Intelligence and Leveraging Dynamic Analysis. Though each of the chapters is worthy of comment, I think that the chapter on Scenario Generation and Optimization is of particular interest to managers wanting to put some real muscle behind their search for the best decision in the face of uncertainty. All together, this book is a major contribution to the business literature.' Richard B. Chase, University of Southern California

Review of previous edition: 'Excel is the duct tape of decision support – handy, pervasive, and surprisingly effective. Bendoly's book helps users unlock its considerable power while avoiding costly errors. You'll be amazed at all you can do with a spreadsheet.' Thomas H. Davenport, Babson College

Review of previous edition: 'Excel Basics to Blackbelt provides the guidance and tools needed to help anyone develop a solid analytical skill set from the ground up. The skills I learned were instrumental in helping me differentiate myself from my peers and [become] a go-to resource for both my team members and clients.' Geoffrey Grant, Deloitte

From the Publisher