This book/CD-ROM package shows professionals and students how to develop customized decision support systems for business problems using Microsoft Excel's Visual Basic for Applications (VBA). Early chapters cover basics of VBA, including general programing concepts, building dialog boxes, and debugging. Later chapters explain how VBA and Excel can be used to create specific decision support applications for problems in employee scheduling, transportation logistics, capital budgeting, pricing American and European options, and portfolio optimization. The CD-ROM contains exercise files. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More
This handbook 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 simple and nice 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. This book is for professional models or to complement a course in Management Science, or Operations Research thta includes survey of optimization, decision analysis, simulation, and other mathematical methods applied to business.
Read Less