Advanced Excel does very well what it does, so your main concern is whether what it does interests you. The book is intended for engineers and scientists who do real computation, not intended for those making turnkey applications for businesses.
Three chapters describe the use of Excel for least squares fitting. Treatment is authoritative, including things like phantom relations, orthogonal polynomials, fitting to a Lorentzian, finding the derivative of data, and so forth. Although there is a lot of detail, it is well presented, and you will be able to follow without being an expert yourself. Less extensive but still detailed are chapters on Fourier analysis and on convolution and deconvolution. A brief introduction to numerical integration of ordinary differential equations is exactly that, introductory. Tons of references to other literature are provided.
So, if you have a specialized interest in these topics, this book is a must. What else is here?
Approximately the last half of the book is devoted to writing macros, and to a presentation of macros used in the first half of the book. The publisher maintains a web site where these can be downloaded, saving you the tedium and error of typing them into your computer from the book. The approach is to use message boxes to communicate with computation in VBA. VBA is used primarily as a programming language, and there is rather little about the Excel object model. You will learn very little about worksheet manipulation using VBA.
The reader with less interest in the applications, but an interest in applying Excel to their own problems, will also find a lot of interesting details here. The author knows a lot about Excel, and you will pick up not only the big picture, but also many useful details. For example, how to call Solver from a macro. How to line your charts up with the spreadsheet grid. How to make the most of Excel's graphic abilities.
This book is NOT the typical Excel book full of screen shots and low on content. It teaches by example. By going through the examples presented, you really will learn how to use Excel for your application too.
- Paperback: 704 pages
- Publisher: Oxford University Press; 2nd ed. edition (Sept. 1 2008)
- Language: English
- ISBN-10: 0195370228
- ISBN-13: 978-0195370225
- Product Dimensions: 23.4 x 4.6 x 15.5 cm
- Shipping Weight: 907 g
- Customer Reviews: 8 customer ratings
- Amazon Bestsellers Rank: #1,611,695 in Books (See Top 100 in Books)
- See Complete Table of Contents
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?