Authors: Ken Bluttman Peter AItken
total 376 pages, 20 chapters.


About This Book
This book is about the number-crunching side of Excel. Formulas are the
keystone to analyzing data — that is, digging out nuggets of important information.
What is the average sale? How many times did we do better than
average? How many days are left on the project? How much progress have
we made? That sort of thing.
Formulas calculate answers, straight and to the point. But that’s not all. Excel
has dozens of built-in functions that calculate everything from a simple average
to a useful analysis of your investments to complex inferential statistics.
But you don’t have to know it all or use it all; just use the parts that are relevant
to your work.
This book discusses more than 150 of these functions. But rather than just
show their syntax and list them alphabetically, we have assembled them by
category and provided real examples of how to use them alone, and in formulas,
along with step-by-step instructions and illustrations of the results.