Microsoft Office Excel 2007 formulas & functions for dummies - Bluttman, Ken (Wiley Pub., 2007)
Includes index
Make Excel do the math and make sense of your data. Use the Insert Function dialog box, array formulas and functions, and more. Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which
Ch. 1 - Tapping into formula and function fundamentals -- - Ch. 2 - Saving time with function tools -- - Ch. 3 - Saying "array!" for formulas and functions -- - Ch. 4 - Fixing formula boo-boos -- - Ch. 5 - Calculating loan payments and interest rates -- - Ch. 6 - Appreciating what you'll get, depreciating what you got -- - Ch. 7 - Using basic math functions -- - Ch. 8 - Advancing your math -- - Ch. 9 - Throwing statistics a curve -- - Ch. 10 - Using significance tests -- - Ch. 11 - Rolling the dice on predications and probability -- - Ch. 12 - Dressing up for date functions -- - Ch. 13 - Keeping well-timed functions -- - Ch. 14 - Using lookup, logical, and reference functions -- - Ch. 15 - Digging up the facts -- - Ch. 16 - Writing home about text functions -- - Ch. 17 - Playing records with database functions -- - Ch. 18 - Ten-plus tips for working with formulas -- - Ch. 19 - Ten-plus functions you really should know