This thorough guide to Excel formulas and over 100 of the most popular functions covers the basics of setting up formulas as well as more advanced skills such visualizing data.

Includes index. Understand how functions and formulas work together ; use formulas to evaluate and forecast your financials ; practice with step-by-step example functions.

Getting started with Excel formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Saying "array!" for formulas and functions ; Fixing formula boo-boos -- Doing the math. Calculating loan payments and interest rates ; Appreciating what you'll get, depreciating what you've got ; Using basic math functions ; Advancing your math -- Solving with statistics. Throwing statistics a curve ; Using significance tests ; Rolling the dice on predictions and probability -- Dancing with data. Dressing up for date functions ; Keeping well-timed functions ; Using lookup, logical, and reference functions ; Digging up the facts ; Writing home about text functions ; Playing records with database functions -- The part of tens. Ten tips for working with formulas ; Ten ways to get fancy with Excel ; Ten really cool functions.