Excel Formulas and Functions For Dummies

Excel Formulas and Functions For Dummies
ISBN-10
0470770244
ISBN-13
9780470770245
Series
Excel Formulas and Functions For Dummies
Category
Computers
Pages
384
Language
English
Published
2010-04-15
Publisher
John Wiley & Sons
Authors
Ken Bluttman, Peter G. Aitken

Description

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.

Other editions

Similar books

  • Excel Formulas & Functions For Dummies
    By Ken Bluttman

    Even if you’re already pretty fancy when it comes to spreadsheets, you’ll want to have this book handy so you can find that one function you’re always forgetting.

  • Microsoft Office Excel 2007 Formulas and Functions For Dummies
    By Ken Bluttman, Peter G. Aitken

    This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing?

  • Statistical Analysis with Excel For Dummies
    By Joseph Schmuller

    What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how.

  • Excel 2019 All-in-One For Dummies
    By Greg Harvey

    The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries.

  • Excel Data Analysis For Dummies
    By Paul McFedries

    This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet.

  • Excel Formulas and Functions for Dummies
    By Ken Bluttman

    Describes the basics of formulas and fuctions of Microsoft Excel with information on such topics as calculating loan payments, using prediction and probability functions, using time functions, and working with text functions.

  • Excel Data Analysis For Dummies
    By Stephen L. Nelson, E. C. Nelson

    Most businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert.

  • Excel 2019 For Dummies
    By Greg Harvey

    The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

  • Financial Modeling in Excel For Dummies
    By Danielle Stein Fairhurst

    If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time!

  • Excel Formulas & Functions For Dummies
    By Ken Bluttman

    Excel Formulas & Functions For Dummies Excel Formulas & Functions For Dummies. case, text, 320–321 CASE function, 373 cash flow, 86 CEILING function, 126, 127–129 CELL function, 289–294 cells about, 13–17 address, 14 entering as ...