Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs
by: Elliot Bendoly
Print Length 页数: 450 pages
Publisher finelybook 出版社: Cambridge University Press; 3 edition (28 May 2020)
Language 语言: English
ISBN-10: 1108738362
ISBN-13: 9781108738361
Book Description
This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization,data analysis,and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants,service professionals and students. This ‘fast track’ enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications,make use of intelligent data visualization and analysis techniques,automate activity through basic VBA designs,and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised,with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration,including methodical discussions of problem structuring and evaluation,as well as numerous case examples from practice.
Contents
Associated Links
Preface
Section 1-Getting Oriented
1Necessary Foundations for Decision Support
2The Common Development Environment
3 Acquisition,Cleaning,and Consolidation
Section 2-Structuring Intelligence
4Estimating and Appreciating Uncertainty
5 Visualizing Data,Dynamics,and Risk
Section 3-Prescription Development
6The 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
