Beschreibung:
Make Excel do the math and make sense of your dataUse the Insert Function dialog box, array formulas and functions,and moreExcel 2007 has more than 500 built-in functions. This book looks atthe top 150, so you can find out which ones will make your lifeeasier. Want to compare a 15-year mortgage to a 30-year mortgage?Forecast expenses for your college freshman? See how your onlinebusiness is doing? Here's the fun and easy way!Discover how to* Create worksheets to track costs and revenue* Tell the difference among average, median, and mode* Work with statistical functions* Develop forecasts and track trends* Manipulate strings and work with database functions
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 andFunctions.Chapter 4: Fixing Formula Boo-Boos.Part II: Counting on Your Money.Chapter 5: Calculating Loan Payments and Interest Rates.Chapter 6: Appreciating What You'll Get, Depreciating WhatYou Got.Chapter 7: Using Basic Math Functions.Chapter 8: Advancing Your Math.Chapter 9: Throwing Statistics a Curve.Chapter 10: Using Significance Tests.Part III: Doing the Math.Chapter 11: Rolling the Dice on Predictions and Probability.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.Part IV: Working with Data.Chapter 16: Writing Home about Text Functions.Chapter 17: Playing Records with Database Functions.Part V: The Part of Tens.Chapter 18: Ten-Plus Tips for Working with Formulas.Chapter 19: Ten-Plus Functions You Really Should Know.Index.