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 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