Book Description
Put the power of Excel functions to work in your formulas
There are more than 400 builtin 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 easytoread 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 15year vs. 30year 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.
 Stepbystep instruction on Excel's 150 most useful functions
 Each function is illustrated by helpful, realworld examples
 85 specialized functions are described in abbreviated form
 Includes Excel’s mustknow functions
This book is a mustread for beginning to intermediate Excel users who want to find out how to use Excel’s powerful builtin functions.
Table of Contents
 Cover
 Introduction
 Part 1: Getting Started with Formulas and Functions
 Part 2: Doing the Math
 Part 3: Solving with Statistics

Part 4: Dancing with Data
 Chapter 12: Dressing Up for Date Functions
 Chapter 13: Keeping WellTimed Functions
 Chapter 14: Using Lookup, Logical, and Reference Functions
 Chapter 15: Digging Up the Facts
 Chapter 16: Writing Home About Text Functions

Chapter 17: Playing Records with Database Functions
 Putting Your Data into a Database Structure
 Working with Database Functions
 FineTuning Criteria with AND and OR
 Adding Only What Matters with DSUM
 Going for the Middle with DAVERAGE
 Counting Only What Matters with DCOUNT
 Finding Highest and Lowest with DMIN and DMAX
 Finding Duplicate Values with DGET
 Being Productive with DPRODUCT

Part 5: The Part of Tens
 Chapter 18: Ten Tips for Working with Formulas
 Chapter 19: Ten Functions You Really Should Know

Chapter 20: Ten Really Cool Functions
 Work with Hexadecimal, Octal, Decimal, and Binary Numbers
 Convert Units of Measurement
 Find the Greatest Common Divisor and the Least Common Multiple
 Easily Generate a Random Number
 Convert to Roman Numerals
 Factor in a Factorial
 Determine Part of a Year with YEARFRAC
 Find the Data TYPE
 Find the LENgth of Your Text
 Just in CASE
 Index
 About the Author
 Connect with Dummies
 End User License Agreement
Product Information
 Title: Excel Formulas & Functions For Dummies, 5th Edition
 Author(s):
 Release date: November 2018
 Publisher(s): For Dummies
 ISBN: 9781119518259