VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel (with VBA Program CD-ROM) / Edition 2

VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel (with VBA Program CD-ROM) / Edition 2

by S. Christian Albright
     
 

Learn more effective modeling techniques than ever before! VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS USING MICROSOFT EXCEL shows you the easy way to automate methods and models and create special applications. You'll learn sophisticated techniques through a simple and clean interface, so there's no more long nights of trying to make it work. And

See more details below

Overview

Learn more effective modeling techniques than ever before! VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS USING MICROSOFT EXCEL shows you the easy way to automate methods and models and create special applications. You'll learn sophisticated techniques through a simple and clean interface, so there's no more long nights of trying to make it work. And because it works with Microsoft Excel, you'll be saving time while the program crunches all the numbers.

Product Details

ISBN-13:
9780495106838
Publisher:
Cengage Learning
Publication date:
01/03/2006
Edition description:
2ND BK&CDR
Pages:
704
Product dimensions:
9.10(w) x 7.40(h) x 1.10(d)

Table of Contents

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. 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 Queueing 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.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >