These macros and functions are provided in uncompiled, computer-readable, easily modifiable form readers can therefore use them as starting points for making their own personalized data analysis tools. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks.
It focuses on three areas-least squares, Fourier transformation, and digital simulation-and illustrates these with extensive examples, often taken from the literature.
Advanced Excel For Scientific Data Analysis takes off from where most books dealing with scientific applications of excel end. Excel is by far the most widely distributed data analysis software but few users are aware of its full powers.