Excel Formulas and Functions For Dummies, 3rd Edition
Publisher: Wiley / For Dummies
Final Release Date: February 2013
Pages: 408

Learn to:

  • Use functions and understand how they work within aformula
  • Take advantage of 150 built-in Excel functions
  • Evaluate investment performance or forecast collegeexpenses
  • Compare 15- versus 30-year mortgage rates

Got numbers to crunch? Master Excel's formulas and functions andput its power to work

Don't be intimidated by Excel! Functions and formulas are itssecret weapon, and this friendly guide helps you make sense ofthem. You'll unlock the mysteries of arrays, discover what goesinto a function, understand predictions and probability, analyzedata, learn to calculate important things like interest paymentsand depreciation, and much more!

  • Begin with the basics — first, get a clear understandingof workbooks and worksheets, cells, ranges, and tables
  • Formula for success — learn the proper way to enter aformula, how to include functions, and how to catch and correcterrors
  • Do the math — calculate payments, interest rates, how longit will take to pay off a loan, and cost/revenue comparisons
  • Statistics, STAT — understand mean, median, and mode, anduse the functions for calculating variance
  • No crystal ball needed — examine predictions andprobabilities and how to forecast trends
  • Fun with functions — find things using lookup, logical,and reference functions, and get information with the CELLfunction
  • Make a date with data — work with database functions,fine-tune criteria, and perform database calculations

Open the book and find:

  • Function tools that make life easier
  • Tips on taming errors
  • How Excel handles money
  • Data analysis techniques
  • All about dates and time in Excel
  • How to handle text
  • Several ways to SUM things up
  • The top ten functions you really should know
Product Details
About the Author
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $24.99
Formats:  ePub, Mobi, PDF