Excel Formulas and Functions For Dummies

Ken Bluttman has been a software developer for 20 years. He is the author of several books, including Excel Charts For Dummies. Peter Aitken has written about computers and programming for over 10 years and has written more than 35 books, including Excel Programming Weekend Crash Course.

Introduction. Part I: Putting the Fun in Functions. Chapter 1: Tapping into Formula and Function Fundamentals. Chapter 2: Saving Time with Function Tools. Chapter 3: Saying "Array!" for Formulas and Functions. Chapter 4: Fixing Formula Boo-Boos. Part II: Doing the Math. Chapter 5: Calculating Loan Payments and Interest Rates. Chapter 6: Appreciating What You'll Get, Depreciating What You've Got. Chapter 7: Using Basic Math Functions. Chapter 8: Advancing Your Math. Part III: Solving with Statistics. Chapter 9: Throwing Statistics a Curve. Chapter 10: Using Signifi cance Tests. Chapter 11: Rolling the Dice on Predictions and Probability. Part IV: Working with Data. Chapter 12: Dressing Up for Date Functions. Chapter 13: Keeping Well-Timed Functions. Chapter 14: Using Lookup, Logical, and Reference Functions. Chapter 15: Digging Up the Facts. Chapter 16: Writing Home about Text Functions. Chapter 17: Playing Records with Database Functions. Part V: The Part of Tens. Chapter 18: Ten Tips for Working with Formulas. Chapter 19: Ten Functions You Really Should Know. Chapter 20: Some Really Cool Functions. Index.