S. Christian Albright received his B.S. degree in mathematics from Stanford in 1968 and his Ph.D. in operations research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. His current interest is in spreadsheet modeling, including development of VBA applications in Excel. Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability. He has also published a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS.
VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel (with Premium Online Content Printed Access Card) / Edition 3by S. Christian Albright
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.See more details below
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.
- Cengage Learning
- Publication date:
- Edition description:
- Older Edition
- Product dimensions:
- 7.20(w) x 9.20(h) x 1.50(d)
Meet the Author
More from this Author
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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >