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

Product Description

Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach to a level of mastery that will allow them to develop user interfaces and automated applications. To accomplish this, the major theme of the text is "the integration of the basic"; as a result readers will be able to develop decision support tools that are at once highly intuitive from a working-components perspective but also highly significant from the perspective of practical use and distribution. Applications integration discussed includes the use of MS MapPoint, XLStat and RISKOptimizer, as well as how to leverage Excel's iteration mode, web queries, visual basic code, and interface development. There are ample examples throughout the text.
Product Details

* Amazon Sales Rank: #362285 in Books
* Published on: 2008-07-07
* Original language: English
* Number of items: 1
* Binding: Hardcover
* 344 pages

Editorial Reviews

Review
"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

About the Author
Elliot Bendoly is an associate professor at Emory University's Goizueta Business School. He holds a Ph.D. from Indiana University in the fields of operations management and decision sciences with an information systems specialization in ERP and knowledge management. Professor Bendoly serves on the editorial boards of the Journal of Operations Management and Decision Sciences. His research has been published in leading academic journals, including the Journal of Operations Management, Production and Operations Management, MIS Quarterly, ISR, Journal of Applied Psychology, Decision Sciences, and the Journal of Service Research. He is also the co-editor of Strategic ERP Extension and Use. He has served as the academic liaison for APICS and is a co-founder of the Behavioral Dynamics in Operations Management (BDOM) Network. He has lectured on decision support at research institutions such as Harvard, as well as to practitioners at firms such as AT Kearney and Price Waterhouse Coopers.
Customer Reviews

A novel look at the power of Excel!5
A novel look at the power of Excel. Great for people new to Excel2007, but also easily transferable to Excel2003. I had no idea it was this easy to develop amazing visual applications in Excel - The seamlessness of integration between Excel and other applications as well as the Internet was a new one for me as well.

I'm a Psychology Professor, and not in any way an "excel geek" and I found this book approachable, useful, and surprising! It's a relief to finally have something like this on my desk. Where have books like this been all this time?"

E. Christine Whitley

SO USEFUL! Broad application possibilites.5
I had no idea what Excel could do for me before reading this book. I'm in the field of medicine. I was able to create a customizable interface for large research experiments. This allowed me to do repeated experiments with variable numbers of groups, subjects and variables.

I automatically generated worksheets for data entry, statistical analysis, and elegant methods to present this data (including color, legends, error bars, etc.).

This made my work so much more efficient and my life SO MUCH EASIER!

Thanks, Dr. Bendoly.