ExcelTip.com
ExcelTip.com
Account Icon Account Icon Account Icon
Google Exceltip.com
JOIN OUR NEWSLETTER
  and receive for joining:
Free eBook Learn More!
Free Excel ADD-IN
Free Weekly Excel Tip
4 e-books in cd-rom
F1 Formulas & Functions
F1 Formulas & Functions
F1 EXCEL
F1 eBook (Spanish)
F1 EXCEL
Financial Statements.xls
 

VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel

List Price: $57.95
Amazon.com Price: $57.95

Buy from Amazon.com

Product Details
  • Media: Paperback
  • Publisher: Duxbury Press (12 December, 2000)
  • ISBN: 0534380123
  • Average Customer Review: 5 out of 5 stars Based on 5 reviews.
  • Amazon.com Sales Rank: 17,243

Customer Reviews

5 out of 5 stars The key to Excel/VBA programming competence

VBA for Modelers is that rare computer book that takes its reader from novice to programmer. Albright gives plenty of examples of code for numerous real world applications. The first section of the book is an overview of VBA in general. The depth and approach of these chapters though make it advisable to have some VBA knowledge. I recommend for complete beginners that they drudge through at least the first several chapters one of those beginner books to get a feel for VBA. If you are not an avid programmer it can be bewildering as to how to go about using the VBA code you see in a beginner book to create an application for business. Albright shows you how in a manner that is easy to read and understand. The project for each chapter and the problems at the end of each chapter are the key to developing an understanding of VBA and how to apply it to your everyday problem solving with Excel. Work through these problems and you will be able to approach Excel/VBA apps with ease. Easily the best computer book I have ever read. Now if Albright would write a similar book for Access all would be well in the world.


5 out of 5 stars Simply the Best!

This book provides the necessary knowledge for building advanced systems for quantitative analysis in Excel.
It covers all relevant aspects of programming with VBA which are necessary for building a decision support system and introduces the concepts by examples often found in the book "Practical Management Science" from Winston and Albright. From a didactic point of view the structure is very good because the first examples are easy to understand while the later ones are quite sophisticated. All in all it is an excellent textbook for teaching graduate MBA students who are interested in programming and have a good background in management science.


5 out of 5 stars A VBA for Excel Jewel

VBA for Modelers by Albright is a jewel. The author, who's other books include Practical Management Science: Spreadsheet Modeling and Applications and Data Analysis & Decision Making with Microsoft Excel among others, targets this book for those with little or no programming experience. Forget the Excel VBA coverage in books like Benninga's Financial Modeling or Advanced Modeling in Finance Using Excel and VBA by Jackson and Staunton. Each of these books has strengths but their coverages of VBA is considerably more disjointed and sketchy. At best, Benninga and Jackson and Staunton can be said to "demonstrate" how VBA can enhance financial modeling in Excel, while providing little in the way of quality instruction on VBA.

Albright's strength is concise, effective language supplemented with numerous examples and an ample number of extended exercises which enable readers to solidify and extend understanding. Chapters 1-13 are a quality VBA primer for readers with little or no programming experience. A distinguishing feature of the book is the coverage in Chapters 14-30 where specific applications are demonstrated and extended. The real strength of this book is that it is written by a fine educator who develops understanding in a systematic and effective fashion. With some work on the reader's part this book provides rewarding results.



RECOMMENDED Microsoft Excel - VBA books



RECOMMENDED MICROSOFT EXCEL TIPS

Convert PDF Files to Excel






Excel VBA books
Accounting books
Business Plans
MS Office books
Taxes books

VIEW ALL BOOKS


  Advertise With Us                               

Tips

Add-In in VBA | Applications - Word, Outlook in VBA | Array Formulas | Cells, Ranges, Rows, and Columns in VBA | Counting | Custom Functions | Custom Functions in VBA | Database Formulas | Database in VBA | Date & Time Formulas | Date & Time in VBA | Events in VBA | Excel 2003 | Excel Chart | Excel Consolidating | Excel Counting | Excel Custom Functions using VBA | Excel Customizing | Excel Data | Excel Dates | Excel Editing | Excel Files | Excel Filter | Excel Format | Excel Formula | Excel General | Excel Grouping and Outlining | Excel Importing Text Files | Excel Information | Excel Keyboard Shortcuts | Excel Loan Formulas | Excel Macros - VBA | Excel Pivot Tables | Excel Printing | Excel Range Name | Excel Security - Protection | Excel Sorting | Excel Style | Excel Subtotals | Excel Summing | Excel Text | Excel Time | Excel Tools | Excel Worksheet, Workbook | Files, Workbook, and Worksheets in VBA | Financial Formulas | Formating in VBA | General Topics in VBA | Import and Export in VBA | Information Formulas | Keyboard & Other Shortcuts in VBA | Keyboard Formula Shortcuts | Links between Worksheet and Workbooks | Links in VBA | Logical Formulas | Lookup Formulas | Mail - Send and Receive in VBA | Menus, Toolbars, Status bar in VBA | Modules, Class Modules in VBA | Other Q&A Formulas | Printing in VBA | Protecting in VBA | Summing | Text Formulas | User Forms, Input boxes in VBA | Using Loops | Working with Formulas |

Tips by Version

Microsoft Excel 97 | Microsoft Excel 2000 | Microsoft Excel 2002 | All Microsoft Excel Versions | New in Excel 2002 | New in Excel 2003 - Office 11

Website

Home | Tip of Hour | Recommended Tips | Most Viewed Tips | Tips by Version | Submit a Tip | My Tips
Microsoft Excel Tutorials | Excel Links | Write for Us | About Us | Search Results | Tip Archives | Excel Forum | Excel Forum Archives

Excel Book

Excel 97 Book | Excel 2000 Book | Excel 2002 Book | Excel XP Book | Book Store

Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Varien