Excel Formulas And Functions for Dummies - Softcover

Bluttman, Ken

Softcover

ISBN 10: 047056816X ISBN 13: 9780470568163

Publisher: For Dummies, 2010

Synopsis

Put the power of Excel formulas and functions to work for you!

Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.

You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier.

• See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula
• Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
• Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
• Includes essential coverage of an additional 85 functions

In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.

About this title

From the Back Cover

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 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

• What's 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 Excel's built-in 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

About the Author

Ken Bluttman has been a software developer for 20 years. He is the author of several books, including Excel Charts For Dummies.

Peter Aitken has written about computers and programming for over 10 years and has written more than 35 books, including Excel Programming Weekend Crash Course.

Edition details

• Publisher: For Dummies
• Publication date: 2010
• ISBN 10: 047056816X
• ISBN 13: 9780470568163
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 384