Roll up your sleeves and start working with functions from ABS to ZTEST Get your hands dirty and dig for the nuggets in your data! This book shows you how, walking you through over 150 built–in functions in Excel 2010. Want to calculate a loan payment? How about finding a trend in your data? It?s all covered with step–by–step instructions and illustrations, so you can put the power of Excel functions to work. Put the fun in functions — from using the Insert Function dialog box and array functions to correcting formulas, you?ll brush up on Excel Do the math — create worksheets to track costs and revenue Simple to sophisticated — take advantage of finance–related functions and learn how to sum and round numbers to get just the answers you need Statistically speaking — test for central tendencies, analyze deviation, and count items in a data sample Dive into forecasting — apply statistical functions to develop...