Very practical guide to Excel's Solver
937594
I run Financial Modeling courses internationally and have been looking for a comprehensive, practical guide to Excel's Solver function for some time. It is one of my favorite functions in Excel and features in all my courses. Unfortunately, books on Excel usually give a very cursory treatment to Solver. Mark Harmon's book gives a very thorough treatment and is packed with practical examples. Mark knows what he is writing about and I unreservedly recommend the book to anyone wanting to gain an in-depth knowledge of Solver.
884268
At close to 600 pages and written in an easy to follow manner and geared now to Excel 2016.  While the reader should have at least an elementary knowledge of statistics, the examples are geared to the beginner with just basic knowledge of  Excel and standard elementary statistics.

The biggest addition I can make to the other fine reviews is that this book and the use of Excel for Data Munging provides a good resource for those venturing out into the modern obsession of machine learning.  Excel with the included tools provides a good resource for examining and manipulating a data source before venturing into more powerful Statistical and Machine Learning tools like R and Python.
982421
Although I have not completed the full book, I found it very good especially for beginners.  I was not conversant at all with Excel and found that I needed it for my employment as my employer had changed my job and I needed the basics.

I found the illustrations very good and easy to follow, and anything I needed to know found easy to find in the book.

I would recommend this book, especially to anyone with little or no knowledge of Excel.
3631939
There are exercises throughout the book that help explain all of the problems. The book makes it easy to understand the ery complicated formulas.
1344441
I was surprised at the quality of the instruction in this book. It seems to be much more informative of Excel's features than books I have read for prior versions of Excel. I always have considered myself an expert in Excel. This book has shown me wrong. There is a multitude of features and functions that I am extremely happy to see excellent instruction for.
921410
Great book for both beginner and advanced MS-Excel users, and is up-to-date with enhanced functionality. Dummies books are the best and can easily take the place of a class. I keep this in my office to refer to, as I work with Excel on a pretty regular basis. Very detailed and easy to follow I recommend it to all excel users who need to advance their skills in their business and workplace.
3278439
This is a great little solution manual.  It doesn't have computer exercise solutions, but the text itself gives most of the solution right after the exercises for Mathematica, Matlab, and Maple.  I am translating to Sage which is free and just as powerful.  Even though the text is from 1998, it was ahead of its time.  Pick up this and the text for less than five dollars combined and rediscover the joy of linear algebra!
3819905
An excellent consolidation of the tools of statistical methods, lean, and problem solving presented in an easy to read and easy to use format. Having developed and taught many seminars on these concepts, I found this to be one of the most useful and practical books on these subjects that I've seen in recent years. It presents just enough information to properly use the tools for one who has some degree of familiarity with them as well as for the newcomer to these concepts.
3273023
This instructional text provides good value in describing both new features of Office 2013 and giving tutorials of how to use all of the features of the program.  The videos included with this text are a useful supplement and introduction to the content of the in text lessons.  The only limitation on this excellent tutorial is that it tends to emphasize program features of the Office Suite rather than the useful content to be achieved with these features.  For example the Excel Lessons emphasize use of the menus, shortcuts and formatting commands rather than the how formulas and calculations should be used in constructing a useful spreadsheet.

AN EXCELLENT VALUE FOR ANYONE WHO MUST BECOME PROFICIENT IN THE BASIC FEATURES OF OFFICE 2013
1677427
Excellent compilation of algorithms that work on most any advanced method. My only problem is that the text sometimes is hard to read as it is covered by the spine, and the book is hard to have open and read an algorithm as you are preforming it, it keeps closing on itself. This would be an easy 5 stars if it was spiral bound.
3516293
I borrowed this book looking to perform one specific task, which I found at the end of a chapter. I spent an hour working through the entire chapter instead and easily learned, understood, and REMEMBERED how to perform a variety of tasks dealing with macros. The problems are simple, GOAL oriented with excellent recap sessions for memorization. Tasks designed as springboards for more advanced projects.

This book is extremely applicable to numerous problems businesses face when using excel. Work your way from basic formuals to writing VBA code and formatting the various Microsoft Office programs using excel. I was able to use the examples given in the book to have Excel command outlook to automatically email me if a date was 2 or 3 days away.

An excellent tool---worth the investment by any small business using excel. Great companion to the Help feature on excel.
3657841
Excellent book on Excel formulas.  Note the author assumes familiarity with Excel although, in my opinion, you don't need to be too familiar if you're used to working with applications and enjoy mathematics.
3523748
Having read most of the general purpose Excel manuals, I believe this one is the most detailed and easiest to understand. It delves into enough detail for more advanced users who want that bit more, but also provides less advanced users with great ideas to help them forward.
For me this is the standout Excel reference, its name of Excel Bible is for good reason. Highly recommended.
1011364
I have been reviewing Ivan Idris Numpy `beginner's guide', second edition of a great book. While in the first edition he started explaining iPython and Matplotlib, this second is an even more practical guide:  "less theory, more results". The first chapter deals with essentials as Python, iPython and libraries as NumPy, Matplotlib and Scipy and ends with applications to vectors and arrays using those tools. Just then in second chapter he goes deep into NumPy fundamentals  with many exercises using arrays, including passing from an array to a list (exercise that helps to understand what are the differences and advantages of each data type.)
Chapter 3 relates to common functions and applications to, example, finances and times. Chapter 4 deals with how to fit polynomials and also Smoothing and as an example, the Hanning function.  Chapter 5 is related to matrices and "ufuncs" (short by universal functions) including how to create it and use with a code. These ideas are applied to a classic, Fibonacci numbers but also to Lissajous curves and the drawing of sawtooth and triangle waves, and also how to work with bitwise comparison operations. Up to this point this is the perfect companion for a crash course on the uses of Python and libraries like NumPy;  however is also strong enough to be used as part of a college lecture or as the tool that should not be absent in your tool box and desk.  Is hard to summarize further chapters; is a very good book because Idris shows his ability to explain in clear and concise sentences and then he applies immediately to exercises in a variety of areas. If you can't find what you need in this book, the only solution might be a do it yourself solution, based in the' big book', the web!  In chapter 6 he explains applications to Linear Algebra including eigenvalues and eigenvectors, Fourier Transform, random numbers and applications to a gambling show. In chapter 7 he works with complex numbers, including sorting and searching, and even plays with Bessel functions. Chapter 8 deals on Assuring Quality with Testing and how to assert and compare arrays. Chapter 9 is one of my favorites, because Idris shows excellent examples on how to plot using Matplotlib, including animations! If you cannot impress your audience with these tools, likely they are dead. In Chapter 10 he goes deeper on libraries like Scipy (NumPy + SciPy are essentials on dealing with big arrays of data, like images) but this time Idris also give us hints in how to deal with audio processing.  Finally in Chapter 11, he talks about PyGame along with Matplotlib, Numpy and applications to ... Artificial Intelligence, and simulations of life.
Certainly one book can hardly cover ALL `what we need'.  However, is up to us to get the most of a tool.  If you work on Engineering or Science and are in need to deal with data, vectors, matrices, arrays, sounds or images, if you need to plot and to make things evident to others, if you need a data handling Swiss tool in your toolkit, this is it, clear, concise, full of many examples in so many areas that you will always have something to talk with others even from areas different to yours.  Read it, use it, enjoy it.
4281333
A terrific book covering key data analytics concepts, and how to execute them in Excel.  What I liked the most was the author's ability to explain what each analytical technique was designed to do, and how it worked - in layman's terms.  This switched more than a few lights on for me...now I'm much more confident at choosing an analytical method, and understanding how it will produce the insights I'm looking for.
211447
One of the best geometry books Ive seen in a long time. Its a great assortment of interesting topics and problems with detailed analysis of methods and techniques for their solutions. I like the idea of making connections and links from one theorem to another, from simple topics and issues to medium and more complicated ones. The author explains not only how to solve a problem, but shows why it is done in a specific way, compares the different approaches. It helps to solve difficult problems in the most efficient way and makes solutions look nonthreatening and relevant. I also like the authors approach in utilizing classic theorems and formulas in simplifying problems solutions. One such an impressive example is the application of Bretschneiders formula for the area of a quadrilateral and its variations, the Brahmagupta's formula being one of them. The author not just introduced these not very often encountered formulas and aquatinted readers with them, but showed how useful and efficient they are in practical matters. There are many other similar instances throughout the book.
Good selection of problems for readers own exercises with well written solutions at the end of the book for self-review.
Its a great buy, I highly recommend it.
2564097
For some time, I have wanted to program in Visual Basic for Applications as a means to automate Excel 2000/2002.  I have looked at many titles in the bookstore by various authors (experts in the field, unquestionably), but none seem targeted to the novice or intermediate user who simply wants to understand the VBA environment and how to benefit from its powerful capabilities.  If other books were trying to target such an audience, then they suffered from poor readability and simply too much material. This book instills confidence in novice users as the reader is given very succinct explanations on variables, procedures, subroutines/functions, and, of course, the Excel Object Model.  I have not been able to put the book down, practically speaking.
Extremely well organized, with generally very good and detailed graphics. It makes its point in roughly 325 pp. and features an excellent appendix dealing with constants, etc. I believe this book will forever relegate the more pricey books I have on the subject to a shelf in my technical library.  The others are authoritative books, to be sure, but I never gained confidence with the format. Reading other sources proved exhausting when compared to this book.  As an Excel user who wrote some macros in the Excel 95 version of the software, this book is a welcome addition.  The book contains probably a few typos, and perhaps an illustration or two (screen shots of the Excel or VB Editor interface) is unclear or improperly rendered  (such as in the section "Remove a Module"). Minor, minor details that won't matter in the overall scheme of things - this book rates very high in my opinion. Another plus: the CD ROM has the sample code used in many sections in the book as well as an "e-version" of the book itself.