VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel

by S. Christian Albright

This handbook helps students learn to use Visual Basic for Applications (VBA - a programming environment within MicrosoftA(R) 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 MicrosoftA(R) 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.

720 pages, Paperback

First published December 12, 2000

Reviews

[Sonya · Rating 3 out of 5]

Painful read... but very thorough. I must say I got my foot in the VBA door with this book.

[Rishika Gupta · Rating 5 out of 5]

It is a highly useful book for learning how to automate, analyse, and build powerful models in Excel using Visual Basic for Applications. It helps readers understand programming logic through practical business and financial modelling examples. The book is especially valuable for students, analysts, and professionals who want to enhance efficiency and create complex solutions. It’s a strong foundation for anyone looking to master modelling with VBA.

[Rick · Rating 5 out of 5]

Perfect for learning VBA even if you have never programmed before.
I've been teaching an intro VBA course with the Albright's book since third edition I think. While I describe it as being written by a business guy who likes to code and not a programmer who likes business, it stands above similar books because it has exercises in every chapter.