Microsoft Office Excel 2007 Formulas & Functions For Dummies

This entry was posted by Friday, 1 April, 2011
Read the rest of this entry »

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 You’ll 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@#

 

Comments are closed.