There are more than 400 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, 5th 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.