Excel Basics to Blackbelt
Excel Basics to Blackbelt
Looking for an inspection copy?
Please email academicmarketing@cambridge.edu.au to enquire about an inspection copy of this book.
$52.00
USDExcel 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.
- Text includes instructions on calling MS MapPoint, XLStat, and RISKOptimizer through visual basic code operating in Excel workbooks
- Outlines approaches to leveraging Excel's powerful iteration mode for data history generation/simulation
- Purchase of the text grants access to examples demonstrating these techniques
Reviews & endorsements
'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 even 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-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 statistics-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
'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.' SciTech Book News
Product details
August 2008Adobe eBook Reader
9780511410888
0 pages
0kg
276 b/w illus. 21 tables
This ISBN is for an eBook version which is distributed on our behalf by a third party.
Table of Contents
- 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.
