| Title : | VBA for modelers. : Developing decision support systems with Microsoft Office Excel | | Material Type: | printed text | | Authors: | S. Christian Albright, Author | | Edition statement: | 4th Edition | | Publisher: | Mason, Ohio : South-Western Cengage Learning | | Publication Date: | 2012 | | Pagination: | xx, 700 p. | | Layout: | ill. (b & w) | | Size: | 24 cm | | ISBN (or other code): | 978-1-133-58423-0 | | Class number: | 005.133 | | Abstract: | Chris Albright's VBA For Modellers, 4E, International Edition is an essential tool for helping students learn to use Visual Basic for Applications (VBA) as a means to automate common spreadsheet tasks, as well as to create sophisticated management science applications. VBA is the programming language for Microsoft(R) Office. VBA For Modelers, 4E, International Edition contains two parts. The first part teaches students the essentials of VBA for Excel. The second part illustrates how a number of management science models can be automated with VBA. From a user's standpoint, these applications hide the details of the management science techniques and instead present a simple user interface for inputs and results. | | Contents note: | 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 and Tables; 16. Working with Ribbons, Menus, and Toolbars; 17. Automating Solver and Other Applications; 18. User-Defined Types, Enumerations, Collections, and Classes
Part II: VBA Management Science Applications
19. Basic Ideas for Application Development with VBA; 20. A Blending Application; 21. A Product Mix Application; 22. A Worker Scheduling Application; 23. A Production Planning Application; 24. A Transportation Application; 25. A Stock-Trading Simulation Application; 26. A Capital Budgeting Application; 27. A Regression Application; 28. An Exponential Utility Application; 29. A Queuing Simulation Application; 30. An Option Pricing Application; 31. An Application for Finding Betas of Stocks; 32. A Portfolio Optimization Application; 33. A Data Envelopment Analysis Application
Index. |
VBA for modelers. : Developing decision support systems with Microsoft Office Excel [printed text] / S. Christian Albright, Author . - 4th Edition . - Mason, Ohio : South-Western Cengage Learning, 2012 . - xx, 700 p. : ill. (b & w) ; 24 cm. ISBN : 978-1-133-58423-0 | Class number: | 005.133 | | Abstract: | Chris Albright's VBA For Modellers, 4E, International Edition is an essential tool for helping students learn to use Visual Basic for Applications (VBA) as a means to automate common spreadsheet tasks, as well as to create sophisticated management science applications. VBA is the programming language for Microsoft(R) Office. VBA For Modelers, 4E, International Edition contains two parts. The first part teaches students the essentials of VBA for Excel. The second part illustrates how a number of management science models can be automated with VBA. From a user's standpoint, these applications hide the details of the management science techniques and instead present a simple user interface for inputs and results. | | Contents note: | 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 and Tables; 16. Working with Ribbons, Menus, and Toolbars; 17. Automating Solver and Other Applications; 18. User-Defined Types, Enumerations, Collections, and Classes
Part II: VBA Management Science Applications
19. Basic Ideas for Application Development with VBA; 20. A Blending Application; 21. A Product Mix Application; 22. A Worker Scheduling Application; 23. A Production Planning Application; 24. A Transportation Application; 25. A Stock-Trading Simulation Application; 26. A Capital Budgeting Application; 27. A Regression Application; 28. An Exponential Utility Application; 29. A Queuing Simulation Application; 30. An Option Pricing Application; 31. An Application for Finding Betas of Stocks; 32. A Portfolio Optimization Application; 33. A Data Envelopment Analysis Application
Index. |
|
Home
VBA for modelers.
