
VBA for Modelers
Developing Decision Support Systems with Microsoft® Office Excel®
- English
- PDF
- Available on iOS & Android
VBA for Modelers
Developing Decision Support Systems with Microsoft® Office Excel®
About this book
Now you can master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft® Office. VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches you how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today.The first half of the book introduces you to the fundamentals of VBA for Excel®. The second half of the book puts knowledge into action as it illustrates how to automate a number of management science models using VBA. You learn how to create user-friendly interfaces for inputs and results.This new edition improves code readability, introduces PowerPivot and the new Excel Data Model and shows you how to pass information between modules and user forms while avoiding the use of global variables. VBA FOR MODELERS, 5E offers insights you need to maximize your skills in VBA.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover
- Half Title
- Title
- Statement
- Copyright
- Dedication
- About the Author
- Contents
- Preface
- Part I: VBA Fundamentals
- Part II: VBA Management Science Applications
- Index