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

ISBN-13: 9781108738361 / Angielski / Miękka / 2020 / 450 str.

Elliot Bendoly

Opis

Master the hidden capabilities of Excel and related applications, crafting tools to help you and others become blackbelts in analysis.

Spis treści

Section 1. Getting Oriented: 1. Necessary Foundations for Decision Support; 2. The Common Development Environment; 3. Acquisition, Cleaning and Consolidation; Section 2. Structuring Intelligence: 4. Estimating and Appreciating Uncertainty; 5. Visualizing Estimates, System Dynamics and Risk; Section 3. Prescription Development: 6. The 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.