VBA for Modelers
Developing Decision Support Systems with Microsofti?1/2 Officei?1/2 Excel, International Edition (with Premium Online Content Printed Access Card)
3rd Edition
Will be published approx. on 3. August 2009
Book
Mixed media product
720 pages
978-0-538-74646-5 (ISBN)
Description
VBA FOR MODELERS, 3e, International Edition helps students gain valuable experience in automating simple but repetitive spreadsheet tasks, as well as developing decision support systems for complex management science models.
More details
Edition
3rd edition
Language
English
Place of publication
Florence
United States
Publishing group
Cengage Learning, Inc
Target group
College/higher education
Weight
1157 gr
ISBN-13
978-0-538-74646-5 (9780538746465)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
S. Christian Albright received both his B.S. degree in mathematics and his Ph.D. in operations research from Stanford University. 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 has 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 and is the author of several successful textbooks.
Content
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.
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.