VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel (with Premium Online Content Printed Access Card) / Edition 3

VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel (with Premium Online Content Printed Access Card) / Edition 3

3.0 2
by S. Christian Albright
     
 

ISBN-10: 1439079846

ISBN-13: 9781439079843

Pub. Date: 08/04/2009

Publisher: Cengage Learning


PKG VBA FOR MODELERS + PAC helps students gain valuable experience in automating simple but repetitive spreadsheet tasks, as well as developing decision support systems for complex management science models.

Overview


PKG VBA FOR MODELERS + PAC helps students gain valuable experience in automating simple but repetitive spreadsheet tasks, as well as developing decision support systems for complex management science models.

Product Details

ISBN-13:
9781439079843
Publisher:
Cengage Learning
Publication date:
08/04/2009
Edition description:
Older Edition
Pages:
720
Product dimensions:
7.20(w) x 9.20(h) x 1.50(d)

Table of Contents


Part I: VBA FUNDAMENTALS. 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. 16. Working with Menus and Toolbars. 17. Automating Solver and Other Add-Ins. Part II: VBA MANAGEMENT SCIENCE APPLICATIONS. 18. Basic Ideas for Application Development with VBA. 19. A Blending Application. 20. A Product Mix Application. 21. An Employee-Scheduling Application. 22. A Production-Planning Application. 23. A Logistics Application. 24. A Stock-Trading Simulation Application. 25. A Capital-Budgeting Application. 26. A Regression Application. 27. An Exponential Utility Application. 28. A Queuing Simulation Application. 29. An Option-Pricing Application. 30. An Application for Finding Betas of Stocks. 31. A Portfolio Optimization Application. 32. A Data Envelopment Analysis Application. 33. An AHP Application for Choosing a Job. 34. A Poker Simulation Application.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel (with Premium Online Content Printed Access Card) 3 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago