Rating:
(8 reviews)
Author: Amazon Prime
ISBN : 1133190871
New from $128.76
Format: PDF, EPUB
Direct download links available Free VBA for Modelers: Developing Decision Support Systems (with Microsoft Office Excel Printed Access Card) [Paperback] from 4shared, mediafire, hotfile, and mirror link
Chris Albright's VBA FOR MODELERS, 4TH EDITION is an essential tool for helping you 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 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.
Direct download links available for Free VBA for Modelers: Developing Decision Support Systems
- Paperback: 720 pages
- Publisher: Cengage Learning; 4 edition (August 26, 2011)
- Language: English
- ISBN-10: 1133190871
- ISBN-13: 978-1133190875
- Product Dimensions: 1.1 x 7.2 x 9 inches
- Shipping Weight: 2.3 pounds (View shipping rates and policies)
Free VBA for Modelers: Developing Decision Support Systems
This is easily the best book I have ever seen on learning and using VBA for Excel. Unlike the "Dummies" series, this book is geared more towards those with operational or analytic inclinations (not just simply formatting or automating a spreadsheet). However, the first half of the book is also suitable for any VBA beginner that is interested in starting from the ground up. The second half has some very interesting and fun examples from OR/mgmt science/decision science that could actually be used on the job. Yet they are fun enough to work through even if you're not in that field, and don't require any "high-level" math to understand.
I'd say the main strengths of the book are as follows:
1)Very well written - I got the sense that the author went through a ton of trial and error (and googling) to figure out how to do the things he teaches in this book. Hence, it is written from the perspective of a real user rather than a typical computer book author who recycles old and sometimes suspect information from other sources without fully understanding it.
2)Comprehensive examples - the author never leaves you hanging without examples to illustrate what he teaches. Virtually every point comes with code examples that can be used to complete the exercises at the end of the chapters.
3)Comprehensive premium online content - the book comes with free access to premium online content that includes code examples in pre-constructed spreadsheets (so you can actually see how it works) and code-free spreadsheets for the exercises (the author gives you the data and your job is to write code for it). You also get to learn how to integrate code with Excel Solver and @Risk (you get limited access to @Risk with the book).