Excel formulas and functions for dummies - Ken Bluttman

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 builtin functions in Excel 2010. Want to calculate a loan payment? How about finding a trend in your data? Its all covered with stepbystep 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, youll brush up on Excel Do the math
create worksheets to track costs and revenue Simple to sophisticated
take advantage of financerelated 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 sound predictions Make the data work for you
work with dates, times, and strings of text and pluck out pieces of data from a database Whats your function?
get the most from several cool functions, such as the amazing IF and the workhorses HLOOKUP and VLOOKUP Open the book and find: Tips for tapping into formula and function fundamentals How to catch errors and audit formulas Steps for moving from basic to advanced math functions How to solve problems with statistics Best practices for working with data How to compare, find, and measure text Ways to use lookup, logical, and reference functions How to put data into a database structure Learn to: Use Excels builtin formulas to make everyday calculations Determine what functions to use in your formulas Create amortization tables, calculate classroom grades, or evaluate investments Design a database