|
VBA For Modelers: Developing Decision Support Systems Using Microsoft Excel With VBA Program 2e Edition
This book helps students learn to use Visual Basic for Applications (VBA - a programming environment within Microsoft Office) as a means to automate methods and models and create special applications. With VBA, sophisticated management science techniques work behind a clean and simple interface. Gaining valuable experience, students will develop
applications that are user friendly and tailored to a specific problem while the "number crunching" takes place behind the scenes of Microsoft Excel
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.
|
