TY - BOOK AU - Bluttman,Ken AU - Aitken,Peter G. TI - Microsoft Office Excel 2007 formulas & functions for dummies SN - 9780470046555 (pbk.) AV - HF5548.4.M523 B58372 2007 U1 - 005.54 22 PY - 2007/// CY - Hoboken, N.J. PB - Wiley KW - Microsoft Excel (Computer file) KW - Electronic spreadsheets KW - Business KW - Computer programs N1 - Includes index; 1. Tapping into formula and function fundamentals -- 2. Saving time with function tools -- 3. Saying "array!" for formulas and functions -- 4. Fixing formula boo-boos -- 5. Calculating loan payments and interest rates -- 6. Appreciating what you'll get, depreciating what you got -- 7. Using basic math functions -- 8. Advancing your math -- 9. Throwing statistics a curve -- 10. Using significance tests -- 11. Rolling the dice on predications and probability -- 12. Dressing up for date functions -- 13. Keeping well-timed functions -- 14. Using lookup, logical, and reference functions -- 15. Digging up the facts -- 16. Writing home about text functions -- 17. Playing records with database functions -- 18. Ten-plus tips for working with formulas -- 19. Ten-plus functions you really should know N2 - "This book helps readers to discover how to exploit the power of Excel 2007 with detailed instructions that explore specialized Excel functions. It explains how and why readers should use a particular function, then gives examples of how that function is used within a formula to solve real-world problems. Examples of Excel formulas and functions show how to compare 15 year vs. 30 year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more." ER -