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

Learn to:

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

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

Don't be intimidated by Excel! Functions and formulas are its secret weapon, and this friendly guide helps you make sense of them. You'll unlock the mysteries of arrays, discover what goes into a function, understand predictions and probability, analyze data, learn to calculate important things like interest payments and depreciation, and much more!

  • Begin with the basics — first, get a clear understanding of workbooks and worksheets, cells, ranges, and tables
  • Formula for success — learn the proper way to enter a formula, how to include functions, and how to catch and correct errors
  • Do the math — calculate payments, interest rates, how long it will take to pay off a loan, and cost/revenue comparisons
  • Statistics, STAT — understand mean, median, and mode, and use the functions for calculating variance
  • No crystal ball needed — examine predictions and probabilities and how to forecast trends
  • Fun with functions — find things using lookup, logical, and reference functions, and get information with the CELL function
  • 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