Excel Basics to Blackbelt

An Accelerated Guide to Decision Support Designs

Elliot Bendoly (Autor)

Buch | Hardcover

344 Seiten

2008
Cambridge University Press (Verlag)
978-0-521-88905-6 (ISBN)

Infos

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 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.

Autor

Dr Elliot Bendoly is an Associate Professor in Information Systems and Operations Management at Emory University's Goizueta Business School. Prior to academia he worked as a research engineer for the Intel Corporation. He holds a PhD from Indiana University in the fields of Operations Management and Decision Sciences, with an Information Systems specialization in ERP and Knowledge Management. His research has been published in a wide range of elite academic journals including the Journal of Operations Management, the Journal of Applied Psychology, Production and Operations Management, Information Systems Research and MIS Quarterly, among others (full vita at www.bizbreed.com). Dr Bendoly is also the co-editor of Strategic ERP Extension and Use (Stanford University Press, 2005) which complements the 2008 Cambridge University Press text catering to the ramp up of tool-developer skills and the integration of applications such as Map Point, XL State, and RiskOptimizer in Excel for decision support system creation. His current research focuses on operational issues in IT utilization and behavioral dynamics.

Inhalt

Part I. Getting Oriented: 1. Necessary foundations for decision support; 2. The development environment; 3. Getting data - acquisition, linkage and generation; Part II. Harvesting Intelligence: 4. Structuring problems and option visualization; 5. Simplification tactics; 6. The analytics of optimization; 7. Complex optimization; Part III. Leveraging Dynamic Analysis: 8. Controlled simulation analysis; 9. Scenario generation and optimization; 10. Visualizing complex analytical dynamics; Part IV. Advanced Automation and Interfacing: 11. VB editing and code development; 12. Automated application calls; 13. Guided and user-friendly interfaces; Glossary of key terms; Appendix: shortcut (hot key) reference.

Produkt-Details

• Zusatzinfo: 21 Tables, unspecified; 276 Halftones, unspecified
• Verlagsort: Cambridge
• Sprache: englisch
• Maße: 178 x 254 mm
• Gewicht: 810 g
• Themenwelt: Mathematik / Informatik ► Mathematik ► Finanz- / Wirtschaftsmathematik
• ISBN-10: 0-521-88905-7 / 0521889057
• ISBN-13: 978-0-521-88905-6 / 9780521889056
• Zustand: Neuware