See buying choices for this item to see if it's one of the millions that are eligible for Amazon Prime.

20 used & new from $36.99

Have one to sell? Sell yours here
 
 
VBA for Modelers: Developing Decision Support Systems Using Microsoft® Excel
 
See larger image
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

VBA for Modelers: Developing Decision Support Systems Using Microsoft® Excel (Paperback)

by S. Christian Albright (Author)
4.3 out of 5 stars See all reviews (18 customer reviews)


Available from these sellers.


4 new from $174.86 16 used from $36.99
Also Available in: List Price: Our Price: Other Offers:
Paperback (2) $109.95 $89.05 70 used & new from $49.99

Customers Who Bought This Item Also Bought

Financial Modeling, 3rd Edition

Financial Modeling, 3rd Edition

by Simon Benninga
4.8 out of 5 stars (14)  $65.02
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

by John Walkenbach
4.2 out of 5 stars (30)  $31.49
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

by Rob Bovey
4.8 out of 5 stars (28)  $37.79
Practical Management Science (with CD-ROM, Decision Tools and Stat Tools Suite, and Microsoft Project 2003 120 Day Version)

Practical Management Science (with CD-ROM, Decision Tools and Stat Tools Suite, and Microsoft Project 2003 120 Day Version)

by Wayne L. Winston
4.1 out of 5 stars (14)  $150.55
Practical Management Science, Revised (with CD-ROM, Decision Making Tools and Stat Tools Suite, and Microsoft Project)

Practical Management Science, Revised (with CD-ROM, Decision Making Tools and Stat Tools Suite, and Microsoft Project)

by Wayne L. Winston
3.5 out of 5 stars (2)  $167.96
Explore similar items

Editorial Reviews

Product Description
This handbook helps students learn to use Visual Basic for Applications (VBA - a programming environment within Microsoft® Office) as a means to automate methods and models and create special applications. With VBA, sophisticated management science techniques work behind a simple and nice interface. Gaining valuable experience, students will develop applications that are user friendly and tailored to a specific problem while the "number crunching" takes place behind the scenes of Microsoft® Excel. This book is for professional models or to complement a course in Management Science, or Operations Research thta includes survey of optimization, decision analysis, simulation, and other mathematical methods applied to business.

About the Author
Chris Albright received his B.S. degree in Mathematics from Stanford in 1968 and his Ph.D. in Operations Research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. He has published over 20 articles in leading operations research journals in the area of applied probability, and he has authored other successful Duxbury titles including PRACTICAL MANAGEMENT SCIENCE, Second Edition, VBA FOR MODELERS, and DATA ANALYSIS AND DECISION MAKING, Second Edition. His current interest is in spreadsheet modeling, including development of VBA applications in Excel.

Product Details

  • Paperback: 576 pages
  • Publisher: South-Western College Pub; 1 edition (December 12, 2000)
  • Language: English
  • ISBN-10: 0534380123
  • ISBN-13: 978-0534380120
  • Product Dimensions: 9.2 x 7.4 x 1.2 inches
  • Shipping Weight: 2.4 pounds
  • Average Customer Review: 4.3 out of 5 stars See all reviews (18 customer reviews)
  • Amazon.com Sales Rank: #750,580 in Books (See Bestsellers in Books)

    Popular in this category: (What's this?)

    #62 in  Books > Computers & Internet > Business & Culture > Technical Support

Citations (learn more)

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product).
Check a corresponding box or enter your own tags in the field below.
(10)
(6)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

18 Reviews
5 star:
 (12)
4 star:
 (3)
3 star:
 (1)
2 star:
 (1)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
4.3 out of 5 stars (18 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
24 of 24 people found the following review helpful:
5.0 out of 5 stars A VBA for Excel Jewel, March 17, 2002
By TONY WINGLER (North Carolina) - See all my reviews
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.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
10 of 11 people found the following review helpful:
5.0 out of 5 stars The best book to learn VBA programming for Excel, June 20, 2004
By A Customer
I looked through some 5 rated books on the subject before and after buying this book. Honestly, this is just simply THE BEST. It introduces to the reader basically all the concepts you need to learn to start writing VBA code for excel. It is just excellent, because there is both theory and very practical examples. You do not need to know anything about programming to start this book. Only thanks to this book (the other books that I tried to read where just useless for me) currently I am writing VBA codes in excel, which allowed to decrease routine works with excel at work from several hours to a matter of several minutes. It is really fascinating.
If you do not know much about VBA programming in Excel. This is the book to get.
Reference books such as Excel 2002 VBA: Programmers Reference are not useful, because they are references, they do not really teach unless you know what you are looking for.
Before buying this book I tried Advanced modelling in finance using Excel and VBA. No comparison.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
7 of 7 people found the following review helpful:
4.0 out of 5 stars Gets your creative juices flowing!, April 14, 2005
By B. W. Holcomb (Cleveland, OH) - See all my reviews
(REAL NAME)   
The biggest problem that I see with learning VBA is not trying to figure out topics such as object hierarchy, syntax, or "if" statements (there are plenty of excellent VBA guides for that!) No, figuring out what to do with all of the "stuff" you just learned is the bigger challenge.

That is where Mr. Albright's book really stands out. While the first few chapters do provide some basic treatment of VBA, it's the other half of this book that really shines! Here you will find 16 full-blown programs that cover everything from industrial applications (process blending, product mix, production scheduling, etc.) to financial analysis programs (stock trading, portfolio optimization, etc) and much more.

In these 16 chapters is where you will learn to use all that "stuff." And not only use it, but get creative with it. Mr. Albright has done a brilliant job at not only walking through the code step-by-step, but also imparting to the reader the all important "why component." After spending some time with this book, you will undoubtedly be a better technical, and equally important, creative programmer.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

4.0 out of 5 stars Nice Book
It's a very nice book. makes it simple for Excel 2003. I hope we should get same kind of book for Excel 2007. This is my text book for my masters.
Published 5 months ago by Chirag Santwani

5.0 out of 5 stars A Great Book I Refer To Time And Time Again
I have an earlier edition of this book (when it was only 35 bucks.) And it tells you just what you need to know about modeling with VBA, concisely and with clarity. Read more
Published 12 months ago by Stephen Mack

5.0 out of 5 stars Very good book to learn VBA
In a class where learning VBA was a sink-or-swim endeavor, this book is a real life-saver.
Published 14 months ago by J. Weber

2.0 out of 5 stars VBA for Novice Modelers
This is not an advanced book. Most of the references are very generic in nature and utilize approaches that I've have used previously. I didnt get much out of this book.
Published 21 months ago by Spencer Wiley

1.0 out of 5 stars Aimed at a very specific audience: avoid if you are not a management scientist!
I am a little surprised at the high rating that this book seems to get from the current 13 reviewers but, then again, these are probably memebers of the books target audience... Read more
Published on July 9, 2006 by Nic Lightfoot

5.0 out of 5 stars Tells you just what you need to know
This book is excellent for the person who simply wants to expand their ability to use Excel without becoming a VBA expert. Read more
Published on November 10, 2004 by Douglas Mckenzie

5.0 out of 5 stars Excellent
Many Excel VBA books are a bunch of clever examples that you won't be able to apply to anything. This is the only book I have found with good examples about how to move around a... Read more
Published on September 21, 2004 by AM

5.0 out of 5 stars Excellent Book. More then satisfied !!!
Absolutely agree with Mr.Weiqin Xie. I took this book from corporative library with intention to get help for my first degree completion project in Industrial management, where I... Read more
Published on July 1, 2004 by A. Movshovich

5.0 out of 5 stars The best book to learn VBA for excel
I looked through some 5 rated books on the subject before and after buying this book. Honestly, this is just simply THE BEST. Read more
Published on June 20, 2004

3.0 out of 5 stars 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... Read more
Published on October 14, 2003

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


   


Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Bath Wonders from LUSH

LUSH bath bombs
Find bath bombs, bath melts, shower jellies, and more great gifts for yourself (or a friend!) from LUSH Fresh Handmade Cosmetics.

Shop LUSH now

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Buy Three Books, Get a Fourth Free

4-for-3 Books
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.
 

Get Deals on Tools

Shop for discounted power and hand tools
Save on power and hand tools in the Home Improvement Store, which offers thousands of tools for over 50% off.

Shop now

 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.



Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle
My Soul to Lose
My Soul to Lose by Rachel Vincent

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates