Excel Formulas & Functions For Dummies

There are more than 300 built-in functions in Excel X, from AGGREGATE to Z.TEST. The question is which ones will make my work easier? How and why should I use a particular function in my formulas?Excel Formulas and Functions For Dummies, 4th Edition is a thorough but easy-to-read coverage of powerful Excel functions. This book gives detailed step-by-step instruction on Excel’s 150 most useful functions. The use of each function will be illustrated by helpful, real-world examples showing how a function is used within a formula. Another 85 specialized functions will be described in abbreviated form. In this book readers will put the power of Excel functions and formulas to work so they can compare 15-year vs. 30-year mortgage terms, generate a series of dates, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate thereal cost of credit card purchases, create a discounted cash flow schedule, design a database, forecast college expenses and savings, determine election results, and lots more! Although this book covers the latest software version, Excel X, the techniques and functions described can be used on any version of Excel.