Read What Students and Professionals Just Like You Are Saying About
Step-By-Optimization With Excel Solver:
↓
"Step-By-Step Optimization With Excel Solver is the "Missing Manual" for the Excel Solver. It is pretty difficult to find good documentation anywhere on solving optimization problems with the Excel Solver.
This book came through like a champ!
Optimization with the Solver is definitely not intuitive, but this
book is. I found it very easy to work through every single one of the examples.
The screen shots are clear and the steps are presented logically. The downloadable Excel spreadsheet with all example completed was quite helpful as well.
Once again, it really amazing how little understandable documentation there is on doing real-life optimization problems with Solver.
For example, just try to find anything anywhere about the well-known Traveling Salesman Problem (a salesman needs to find the shortest route to visit all customers once).
It is a tricky problem for sure, but this book showed a quick and easy way to get it done. I'm not sure I would have ever figured that problem out, or some the other problems in the book, without this manual.
I can say that this is the book for anyone who wants or needs to get up to speed on an advanced level quickly with the Excel Solver.
It appears that every single aspect of using the Solver seems to be covered thoroughly and yet simply. The author presents a lot of tricks in how to set the correct Solver settings
to get it to do exactly what you want.
The book flows logically. It's an easy read.
Step-By-Step Optimization With Excel Solver got me up to speed on the Solver quickly and without to much mental strain at all. I can definitely recommend this book."
Pam Copus
Sonic Media Inc.
"As Graduate student of the Graduate Program in International Studies (GPIS) at Old Dominium University, I'm required to have a thorough knowledge of Excel in order to use it as a tool for interpreting data, conducting research and analysis.
I've always found the Excel Solver to be one of the more difficult Excel tools to totally master. Not any more.
This book was so clearly written that I was able to do almost
every one of advanced optimization examples in the book as soon as I read through it once.
I can tell that the author really made an effort to make this manual as intuitive as possible.
The screen shots were totally clear and logically presented.
Some of the examples that were very advanced, such as the venture capital investment example, had screen shot after screen shot to ensure clarity of the difficult Excel spreadsheet and Solver dialogue boxes.
It definitely was "Step-By-Step" just like the title says.
I must say that I did have to cheat a little bit and look at the Excel spreadsheet with all of the book's example that is downloadable from the book. The spreadsheet was also a great help.
Step-By-Step Optimization With Excel Solver is not only totally easy to understand and follow, but it is also very complete. I feel like I'm a master of the Solver.
I have purchased a couple of other books in the Excel MaSter Series (the Excel Statistical Master and the Advanced Regression in Excel book) and they have all been excellent.
I am lucky to have come across this book because the graduate program that I am in has a number of optimization assignments using the Solver.
Thanks Mark for such an easy-to-follow and complete book on using the Solver. It really saved me a lot of time in figuring this stuff out."
Federico Catapano
Graduate Student
International Studies Major
Old Dominion University
Norfolk, Virginia
Read What Students and Professionals Just Like You Are Saying About
Step-By-Optimization With Excel Solver:
↓
"I'm finished with school (Financial Economics major) and currently work for a fortune 400 company as a business analyst. I find that the statistics and optimization manuals are indispensable reference tools throughout the day.
I keep both eManuals loaded on my ipad at all times just in case I have to recall a concept I don't use all the time. Its easier to recall the concepts from the eManuals rather then trying to sift through the convoluted banter in a text book, and for that I applaud the author!
In a business world where I need on demand answers now this optimization eManual is the perfect tool.
I just recently used the bond investment optimization problem to build a model in excel and help my VP understand that a certain process we're doing wasn't maximizing our resources.
That's the great thing about this manual, you can use any practice problem (with a little outside thinking) to mold it into your own real life problem and come up with answers that matter in the work place!!"
Sean Ralston
Sr. Financial Analyst
Enogex LLC
Oklahoma City, Oklahoma
"Excel Solver is a tool that most folks never use. I was one of those people. I was working on a project, and was told that solver might be helpful. I did some research online, and was more confused than ever. I started looking for a book that might help me. I got this book, and was not sure what to expect.
It surpassed my expectations!
The book explains the concepts behind the solver, the best way to set up the "problem", and how to use the tool effectively. It also gives many examples including the files. The files are stored online, and you can download them so you can see everything in excel.
The author does a fantastic job on this book. While I'm not a solver "expert", I am definitely much smarter about it than I was before.
Trust me, if you need to understand the solver tool, this book will get you there!
"
Scott Kinsey
Missouri
"The author, Mark, has a writing style that is easy to follow, simple, understandable, with clear examples that are easy to follow.
This book is no exception.
Mark explains how solver works, the different types of solutions that can be obtained and when to use one or another, explains the content and meaning of the reports available. Then he presents several examples, goes about defining each problem, setting it up in excel and in solver and interpreting the solution.
It is a really good book that teaches you how to apply solver (linear programming) to a problem.
Luis R. Heimpel
El Paso, Texas