Excel Formulas and Functions For Dummies (2nd Edition) : 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. Create worksheets to track costs and revenue. Take advantage of finance-related functions and learn how to sum and round numbers to get just the answers you need. Test for central tendencies, analyze deviation, and count items in a data sample. Apply statistical functions to develop sound predictions. Work with dates, times, and strings of text and pluck out pieces of data from a database. Get the most from several cool functions, such as the amazing IF and the workhorses HLOOKUP and VLOOKUP.
|Computers & Internet||Spreadsheets|