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

by Elliot Bendoly

Overview

For students and practitioners interested in developing their skills in the construction of analytical tools and visual demonstrations in Excel. Covering everything from the basics of working in Excel, to a variety of critical analytical and custom visual techniques, and programmatic approaches to developing seamless professional tools.

Product Details

ISBN-13:	9781108853446
Publisher:	Cambridge University Press
Publication date:	05/28/2020
Sold by:	Barnes & Noble
Format:	eBook
File size:	76 MB
Note:	This product may take a few minutes to download.

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