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

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

List of contents

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.

About the author

Elliot Bendoly is Distinguished Professor of Management Sciences at the Fisher College of Business, Ohio State University. He serves as an associate editor for the Journal of Operations Management, a senior editor for Production and Operations Management, and an associate editor for Decision Sciences. His previously published books include (as co-editor) Visual Analytics for Management (2016) and The Handbook of Behavioral Operations Management (2015).

Summary

For students and practitioners interested in developing their skills in the construction of analytical tools and visual demonstrations in Excel. Covering everything from the basics of working in Excel, to a variety of critical analytical and custom visual techniques, and programmatic approaches to developing seamless professional tools.

Product details

• Authors: Elliot Bendoly, Elliot (Ohio State University) Bendoly, Bendoly Elliot, ELLIOT BENDOLY
• Publisher: Cambridge University Press ELT
• Languages: English
• Product format: Paperback / Softback
• Released: 30.06.2020
• EAN: 9781108738361
• ISBN: 978-1-108-73836-1
• No. of pages: 450
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Application software; Social sciences, law, business > Business > Miscellaneous; BUSINESS & ECONOMICS / Strategic Planning, COMPUTERS / Computer Science, MATHEMATICS / Applied, BUSINESS & ECONOMICS / Econometrics, computer science, Economic statistics, business strategy, Applied mathematics, Econometrics, Econometrics and economic statistics, Database Software, COMPUTERS / Business & Productivity Software / Databases, Spreadsheet software, COMPUTERS / Business & Productivity Software / Spreadsheets