Bendoly (operations management and decision sciences, Emory U.) takes mere mortals and turns them into super-users while explaining the powers of this ubiquitous software tool. With accessible text and plenty of useful graphics, he explains the development environment of Excel, then challenges readers to acquire, link, and generate data to create useful, organized intelligence.. He shows how to structure problems and visualize options, and gives a series of simplification tactics that produce effective data groupings for decision support. He explains the analytics of optimization, including complex optimization, and demonstrates leveraging dynamic analysis, including controlled simulation analysis, scenario generation and optimization. His sections on visualizing complex analytical dynamics, advanced automation and interfacing are especially good. This should be on every manager's bookshelf as a reference, but Bendoly's excellent exercises also make this a strong self-study guide and classroom text. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)
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.