Microsoft Office Excel 2007 Formulas & Functions For Dummies
Make Excel do the math and make sense of your databrbrbrUse the Insert Function dialog box, array formulas and functions, and morebrbrExcel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here’s the fun and easy way!brbrDiscover how tobr* Create worksheets to track costs and revenuebr* Tell the difference among average, median, and modebr* Work with statistical functionsbr* Develop forecasts and track trendsbr* Manipulate strings and work with database functionsbIntroduction./bpbPart I: Putting the Fun in Functions./bpChapter 1: Tapping into Formula and Function Fundamentals.pChapter 2: Saving Time with Function Tools.pChapter 3: Saying Array! for Formulas and Functions.pChapter 4: Fixing Formula Boo-Boos.pbPart II: Counting on Your Money./bpChapter 5: Calculating Loan Payments and Interest Rates.pChapter 6: Appreciating What Youll Get, Depreciating What You Got.pChapter 7: Using Basic Math Functions.pChapter 8: Advancing Your Math.pChapter 9: Throwing Statistics a Curve.pChapter 10: Using Significance Tests.pbPart III: Doing the Math./bpChapter 11: Rolling the Dice on Predictions and Probability.pChapter 12: Dressing Up for Date Functions.pChapter 13: Keeping Well-Timed Functions.pChapter 14: Using Lookup, Logical, and Reference Functions.pChapter 15: Digging Up the Facts.pbPart IV: Working with Data./bpChapter 16: Writing Home about Text Functions.pChapter 17: Playing Records with Database Functions.pbPart V: The Part of Tens./bpChapter 18: Ten-Plus Tips for Working with Formulas.pChapter 19: Ten-Plus Functions You Really Should Know.pbIndex./bbKen Bluttman/b has been working as a software developer for nearly two d@#