Back to Search
ISBN 9781119518259 is out of print and is currently unavailable, alternate formats (if applicable) are shown below.
Available options are listed below:

Excel Formulas & Functions for Dummies (Out of print)

AUTHOR Bluttman, Ken
PUBLISHER For Dummies (11/06/2018)
PRODUCT TYPE Paperback (Paperback)

Description

Put the power of Excel functions to work in your formulas

There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.

With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel.

  • Step-by-step instruction on Excel's 150 most useful functions
  • Each function is illustrated by helpful, real-world examples
  • 85 specialized functions are described in abbreviated form
  • Includes Excel's must-know functions

This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions.

Show More
Product Format
Product Details
ISBN-13: 9781119518259
ISBN-10: 1119518253
Binding: Paperback or Softback (Trade Paperback (Us))
Content Language: English
Edition Number: 0005
More Product Details
Page Count: 400
Carton Quantity: 20
Product Dimensions: 7.40 x 0.70 x 9.20 inches
Weight: 1.10 pound(s)
Feature Codes: Index, Price on Product, Illustrated
Country of Origin: US
Subject Information
BISAC Categories
Computers | Business & Productivity Software - Spreadsheets
Computers | Business & Productivity Software - Office Suites
Computers | Reference
Dewey Decimal: 005.54
Descriptions, Reviews, Etc.
jacket back
  • Understand how functions work within a formula
  • Take full advantage of built-in Excel functions
  • Evaluate and forecast investments and expenses

Put Excel's powerful functions to work for you!

Excel contains a whopping 400+ built-in functions. Now before your eyes glaze over, this book has sorted out the 150 most useful ones and provided step-by-step instructions on how to use each within a formula. Helpful, real-world examples show you how to take advantage of Excel's power for basic tasks, like determining your business's average sale, computing classroom grades, forecasting college expenses, determining the REAL cost of large credit card purchases, or just cataloging your recipe collection. Add Excel to your team!

Inside...

  • Essential Excel functions
  • Real-world examples using each function in a formula
  • Using Excel to make decisions
  • Saving time with function tools
  • Calculating interest rates
  • Applying significance tests
  • Working with database functions
Show More
publisher marketing

Put the power of Excel functions to work in your formulas

There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.

With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel.

  • Step-by-step instruction on Excel's 150 most useful functions
  • Each function is illustrated by helpful, real-world examples
  • 85 specialized functions are described in abbreviated form
  • Includes Excel's must-know functions

This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions.

Show More

Author: Bluttman, Ken
Ken Bluttman is the author of numerous computer books and articles. He recently released O'Reilly's Access Hacks as well as Excel Charts for Dummies. Ken is also at work on his next O'Reilly book: The Access Data Cookbook (due out at the end of 2005). His technical chops include Microsoft Office, XML, VBA, VB.Net, SQL Server, and assorted web technologies.Ken is a musician, nature lover, and as time allows spins a good dish in the kitchen. Visit Ken at www.bluttman.com.
Show More
List Price $29.99
Your Price  $20.69
Paperback