Skip to content

VBA for Modelers Developing Decision Support Systems Using Microsoft Excel

Best in textbook rentals since 2012!

ISBN-10: 0495106836

ISBN-13: 9780495106838

Edition: 2nd 2007

Authors: S. Christian Albright

List price: $192.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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.
Customers also bought

Book details

List price: $192.95
Edition: 2nd
Copyright year: 2007
Publisher: Brooks/Cole
Publication date: 1/3/2006
Binding: Paperback
Pages: 704
Size: 7.25" wide x 9.00" long x 1.00" tall
Weight: 2.332
Language: English

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 as well as a number of…    

Introduction to VBA Development In Excel
The Excel Object Model
The Visual Basic Editor
Recording Macros
Getting Started With VBA
Working with Ranges
Control Logic and Loops
Working with Other Excel Objects
Arrays
More on Variables and Subroutines
User Forms
Error Handling
Working with Files And Folders
Importing Data into Excel from a Database
Working with Pivot Tables
Working with Menus and Toolbars
Automating Solver and Other Add-Ins
Basic Ideas for Application Development with VBA
A Blending Application
A Product Mix Application
An Employee-Scheduling Application
A Production-Planning Application
A Logistics Application
A Stock-Trading Simulation Application
A Capital-Budgeting Application
A Regression Application
An Exponential Utility Application
A Queueing Simulation Application
An Option-Pricing Application
An Application for Finding Betas of Stocks
A Portfolio Optimization Application
A Data Envelopment Analysis Application
An AHP Application for Choosing a Job
A Poker Simulation Application