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

by S. Christian Albright

Today’s learners master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Albright’s VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches 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 readers 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. Students learn to develop clean code and user-friendly interfaces for inputs and results. A new section familiarizes readers with PowerPivot and the new Excel Data Model. Novices as well as more experienced professionals will find the skills and background they need to maximize their VBA skills.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

736 pages, Kindle Edition

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.