Cengage India

Home

Higher Education

VBA for Modelers: Developing Decision Support Systems with Microsoft® Office Excel®

Author(s): S. Christian Albright

ISBN: 9789355735577

5th Edition

₹1125

Binding: Paperback

Pages: 736

Trim Size : 241 x 181 mm

Refer Book > Order Inspection Copy >

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

Master VBA Capabilities: Demonstrates the power of VBA integrated with management science models.
Progressive Learning: Starts with simple automations before advancing to full decision support systems.
PowerPivot & Data Model: Introduces integrating multiple data tables within Excel.
Cleaner Code: Improved code readability promotes good programming practices.
Better Module Communication: New method for passing data between modules and user forms without global variables.

1. Introduction to VBA Development in Excel

2. The Excel Object Model

3. The Visual Basic Editor

4. Recording Macros

5. Getting Started with VBA

6. Working with Ranges

7. Control Logic and Loops

8. Working with Other Excel Objects

9. Arrays.

10. More on Variables and Subroutines.

11. User Forms

12. Error Handling.

13. Working with Files and Folders.

14. Importing Data into Excel from a Database.م

15. Working with Pivot Tables and Tables

16. Working with Ribbons, Menus, and Toolbars

17. Automating Solver and Other Applications

18. User-Defined Types, Enumerations, Collections, and Classes

Part II: VBA MANAGEMENT SCIENCE APPLICATIONS

19. Basic Ideas for Application Development with VBA

20. A Blending Application.

21. A Product Mix Application

22. A Worker Scheduling Application

23. A Production Planning Application

24. A Transportation Application

25. A Stock Trading Simulation Application

26. A Capital Budgeting Application

27. A Regression Application

28. An Exponential Utility Application

29. A Queuing Simulation Application

30. An Option Pricing Application

31. An Application for Finding Betas of Stocks.

32. A Portfolio Optimization Application.

33. A Data Envelopment Analysis Application.

34. An AHP Application for Choosing a Job.

35. A Poker Simulation Application.

S. Christian Albright

S. Christian Albright received both his B.S. degree in mathematics and his Ph.D. in operations research from Stanford. He then taught in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University until his retirement in 2011. He taught courses in management science, computer simulation and statistics to all levels of business students, including undergraduate, M.B.A. and Ph.D. students. He has published more than 20 articles in leading operations research journals in applied probability. After retiring, he worked for several years for the Palisade software company. Now living in Hilton Head, SC, he continues to revise several successful textbooks, including this edition, PRACTICAL MANAGEMENT SCIENCE and VBA FOR MODELERS.