Vba For Modelers: Developing Decision Support Systems With Microsoft Office Excel, 4Ed

by Albright

Chris Albright's VBA FOR MODELERS, 4TH 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® Office. VBA FOR MODELERS 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. About the AuthorS. Christian Albright 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. He has also published a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS.

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.