Description
Excel Formulas & Functions For Dummies Book
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.
Features:
- 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
- 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
