# Excel Formulas and Functions For Dummies, 3rd Edition

### eBook Details:

**Paperback:**408 pages**Publisher:**For Dummies; 3rd edition (February 26, 2013)**Language:**English**ISBN-10:**1118460847**ISBN-13:**978-1118460849

### eBook Description:

**Excel Formulas and Functions For Dummies, 3rd Edition**

- Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
- Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
- Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide whether to buy or lease a car, calculate the actual cost of credit card purchases, forecast college expenses, design a database for your own use, and much more
- Serves as an excellent resource for all versions of Excel, including the latest version 2013

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

** Excel Formulas and Functions For Dummies, 3rd Edition** helps you put the power of Excel to work in your daily life.

**From the Back Cover**

**Learn to use Excel for practical, day-to-day calculations**

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

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

**Learn to use Excel for practical, day-to-day calculations**

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

[download id=”1875″]