VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
||Author: S. Christian Albright|
List Price: $58.95
Our Price: Click to see the latest and low price
Publisher: Duxbury Press (12 December, 2000)
Sales Rank: 54,456
Average Customer Rating: 4.57 out of 5
Customer ReviewsRating: 3 out of 5
Not what they are marketing!
This is not definitely a book for someone that doesn't know the basics of VBA. Even that the book claims to be useful for beginners, which is the main marketing hook, many things simply doesn't makes any sense if you don't have some background in VBA. I recommend this book for anyone with an intermediate or advance level knowledge of VBA, who wants to get an insight on how to use its power for developing "management science type" modeling solutions.
Rating: 5 out of 5
Perfect for the Excel user
I started reading this book because I was interested in creating decision support systems for Microsoft Excel. Because of time constraints, i did not get to read the whole book. However, the first 6 or 7 chapters of this book have helped me grasp the basics of VBA perfectly. I have saved a great many hours (spent previously doing repetitive mind-numbing tasks in excel) by writing a few simple lines of code (and remember, I have very little programming experience). I hope to learn even more by reading the whole book, but trust me, this book is worth its price, just for the first few chapters
Rating: 5 out of 5
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.
· Microsoft Excel 2002 Formulas (With CD-ROM)
· Excel 2002 Power Programming with VBA
· Excel 2002 VBA: Programmers Reference
· Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science
· Advanced modelling in finance using Excel and VBA