Publisher's Synopsis
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
