VBA for Modelers: Developing Decision Support Systems with Microsoft? Office? Excel Author: | Language: English | ISBN:
B00B7MB1E4 | Format: PDF
VBA for Modelers: Developing Decision Support Systems with Microsoft? Office? Excel Description
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.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version. - File Size: 20292 KB
- Print Length: 720 pages
- Publisher: Cengage Learning; 4 edition (September 24, 2013)
- Sold by: Cengage Learning
- Language: English
- ASIN: B00B7MB1E4
- Text-to-Speech: Not enabled
X-Ray:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #259,488 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #37
in Kindle Store > Kindle eBooks > Computers & Technology > Microsoft > Visual Basic - #62
in Kindle Store > Kindle eBooks > Business & Money > Economics > Statistics - #68
in Books > Computers & Technology > Microsoft > Development > VBA
- #37
in Kindle Store > Kindle eBooks > Computers & Technology > Microsoft > Visual Basic - #62
in Kindle Store > Kindle eBooks > Business & Money > Economics > Statistics - #68
in Books > Computers & Technology > Microsoft > Development > VBA
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).
VBA for Modelers: Developing Decision Support Systems with Microsoft? Office? Excel Preview
Link
Please Wait...