Sale!

VBA for Modelers Developing Decision Support Systems with Microsoft Office Excel 5th Edition by S. Christian Albright ISBN 1285869613 978-1285869612

Original price was: $70.00.Current price is: $35.00.

Instant download VBA for Modelers Developing Decision Support Systems with Microsoft Office Excel 5th S. Christian Albright after payment

SKU: EB_36380 Category:

VBA for Modelers Developing Decision Support Systems with Microsoft Office Excel 5th Edition by S. Christian Albright – Ebook PDF Instant Download/Delivery:  1285869613, 978-1285869612

Full download VBA for Modelers Developing Decision Support Systems with Microsoft Office Excel 5th Edition after payment

 

Product details:

ISBN 10: 1285869613

ISBN 13: 978-1285869612 

Author: S. Christian Albright 

Now you can master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office. VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches you how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces you to the fundamentals of VBA for Excel. The second half of the book puts knowledge into action as it illustrates how to automate a number of management science models using VBA. You learn how to create user-friendly interfaces for inputs and results. This new edition improves code readability, introduces PowerPivot and the new Excel Data Model and shows you how to pass information between modules and user forms while avoiding the use of global variables. VBA FOR MODELERS, 5E offers insights you need to maximize your skills in VBA.

Table of contents:

Part I: VBA Fundamentals

Ch 1: Introduction to VBA Development in Excel

Ch 2: The Excel Object Model

Ch 3: The Visual Basic Editor

Ch 4: Recording Macros

Ch 5: Getting Started with VBA

Ch 6: Working with Ranges

Ch 7: Control Logic and Loops

Ch 8: Working with Other Excel Objects

Ch 9: Arrays

Ch 10: More on Variables and Subroutines

Ch 11: User Forms

Ch 12: Error Handling

Ch 13: Working with Files and Folders

Ch 14: Importing Data into Excel from a Database

Ch 15: Working with Pivot Tables and Tables

Ch 16: Working with Ribbons, Toolbars, and Menus

Ch 17: Automating Solver and Other Applications

Ch 18: User-Defined Types, Enumerations, Collections, and Classes

Part II: VBA Management Science Applications

Ch 19: Basic Ideas for Application Development with VBA

Ch 20: A Blending Application

Ch 21: A Product Mix Application

Ch 22: A Worker Scheduling Application

Ch 23: A Production-Planning Application

Ch 24: A Transportation Application

Ch 25: A Stock-Trading Simulation Application

Ch 26: A Capital Budgeting Application

Ch 27: A Regression Application

Ch 28: An Exponential Utility Application

Ch 29: A Queueing Simulation Application

Ch 30: An Option-Pricing Application

Ch 31: An Application for Finding Betas of Stocks

Ch 32: A Portfolio Optimization Application

Ch 33: A Data Envelopment Analysis Application

Ch 34: An AHP Application for Choosing a Job

Ch 35: A Poker Simulation Application

People also search for:

vba for modelers developing decision support systems
vba for modelers developing decision support systems with microsoft® excel
vba for modelers pdf
vba for modelers
vba for modelers chegg

Tags: S Christian Albright, VBA, Modelers, Decision Support Systems, Microsoft Office, Excel