Excel Basics to Blackbelt

3. Auflage 2025
ISBN: 978-1-108-73836-1
Verlag: Cambridge University Press

Buch, Englisch, 450 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 833 g

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.

Autoren/Hrsg.

Bendoly, Elliot

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
• Wirtschaftswissenschaften Volkswirtschaftslehre Volkswirtschaftslehre Allgemein Ökonometrie
• Mathematik | Informatik EDV | Informatik Informatik
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
• Mathematik | Informatik Mathematik Numerik und Wissenschaftliches Rechnen Angewandte Mathematik, Mathematische Modelle
• Wirtschaftswissenschaften Betriebswirtschaft Management Unternehmensführung
• Wirtschaftswissenschaften Betriebswirtschaft Management Unternehmensorganisation & Entwicklungsstrategien

Inhaltsverzeichnis

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.

Über Autor(innen)

Bendoly, Elliot
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).