VBA for Modelers: Developing Decision Support Systems with Microsoft® Office Excel®
By S. Christian Albright
About your course materials
Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft® Office, with this essential tool. Chris Albright’s VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students 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 students to the fundamentals of VBA for Excel®. The second half puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn how to use applications to present a user-friendly interface for inputs and results.
This new edition improves code readability, introduces PowerPivot and the Excel Data Model and demonstrates a new method to pass information between modules and user forms that avoids using global variables.
Frequently asked questions
How do I enroll in or join my course?
How do I redeem an access code, or what if my code isn't working?
Why can't I access my course?
Where can I find my eBook or textbook?
What if I don't have access to my course materials yet?
About this product
Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft® Office, with this essential tool. Chris Albright’s VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students 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 students to the fundamentals of VBA for Excel®. The second half puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn how to use applications to present a user-friendly interface for inputs and results.
This new edition improves code readability, introduces PowerPivot and the Excel Data Model and demonstrates a new method to pass information between modules and user forms that avoids using global variables.
STUDENTS GAIN SUCCESS IN SIMPLE AUTOMATIONS BEFORE TACKLING MORE COMPLEX CHALLENGES. Students begin with simple macros for automating common spreadsheet tasks before progressing to complete decision support systems.
STUDENTS LEARN TO MAXIMIZE THE POTENTIAL CAPABILTIES OF VBA. The author effectively illustrates the power of VBA when coupled with management science models.
Table of contents
Chapters
Part I: VBA Fundamentals
Resources
Instructor resources for this title can include manuals, test banks, educator guides, multimedia and companion sites. Sign in to see what is available.
Pricing and formats
Give students more with Cengage Unlimited
Choose the Cengage content and Learning Platform that fit your course while giving students access to Cengage Learning Platforms and our entire eBook library with one subscription.
4-12 month student access
eBook
Give students digital access to textbook content with tools to highlight, bookmark and search as they read.
Paperback
Related products
Quantitative Methods for Business
An Introduction to Management Science: Quantitative Approaches to Decision Making
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Business Analytics: Data Analysis & Decision Making
Quantitative Methods for Business
Still need support?
