advanced excel for scientific data analysis

عن الكتاب

This book will take you, my reader, beyond the standard fare of Excel. This is why the title starts with the word "advanced". This book is not a primer, and familiarity with Excel is presumed. You will learn how to make the spreadsheet do your bidding, not so much by prettying up its display, but by exploiting its considerable computational prowess to the fullest, and by adding to it with custom functions and custom macros where necessary. If Excel's built-in least squares facilities don't provide the covariance, don't handle statistical weights, don't supply orthogonal polynomials, or lack special tools for equidistant data, this book will show you how to make those tools. If Excel's fast Fourier transform routine is cumbersome, replace it, and go from there to perform time-frequency analysis. If you want to use the Runge-Kutta method, write a custom function to do so. If you need a deconvolution, there are several macros to perform it, in addition to the direct spreadsheet approach