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.
Autorentext
Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written numerous articles and books on a variety of technical topics. His latest projects include large-scale cloud-based applications and mobile app development.
Klappentext
- 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
Zusammenfassung
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.
Inhalt
Introduction 1
About This Book 1
Foolish Assumptions 2
How to Use This Book 2
Icons Used in This Book 2
Where to Go from Here 3
Part 1: Getting Started with Formulas and Functions 5
Chapter 1: Tapping Into Formula and Function Fundamentals 7
Working with Excel Fundamentals 8
Understanding workbooks and worksheets 8
Introducing the Formulas Tab 11
Working with rows, column, cells, ranges, and tables 13
Formatting your data 17
Getting help 19
Gaining the Upper Hand on Formulas 19
Entering your first formula 20
Understanding references 22
Copying formulas with the fill handle 24
Assembling formulas the right way 25
Using Functions in Formulas 27
Looking at what goes into a function 29
Arguing with a function 30
Nesting functions 32
Chapter 2: Saving Time with Function Tools 37
Getting Familiar with the Insert Function Dialog Box 37
Finding the Correct Function 39
Entering Functions Using the Insert Function Dialog Box 40
Selecting a function that takes no arguments 41
Selecting a function that uses arguments 42
Entering cells, ranges, named areas, and tables as function arguments 43
Getting help in the Insert Function dialog box 48
Using the Function Arguments dialog box to edit functions 49
Directly Entering Formulas and Functions 49
Entering formulas and functions in the Formula Bar 49
Entering formulas and functions directly in worksheet cells 51
Chapter 3: Saying Array! for Formulas and Functions 55
Discovering Arrays 56
Using Arrays in Formulas 57
Working with Functions That Return Arrays 61
Chapter 4: Fixing Formula Boo-Boos 65
Catching Errors As You Enter Them 65
Getting parentheses to match 66
Avoiding circular references 68
Mending broken links 70
Using the Formula Error Checker 72
Auditing Formulas 75
Watching the Watch Window 78
Evaluating and Checking Errors 79
Making an Error Behave the Way You Want 81
Part 2: Doing the Math 83
Chapter 5: Calculating Loan Payments and Interest Rates 85
Understanding How Excel Handles Money 86
Going with the cash flow 86
Formatting for currency 86
Choosing separators 88
Figuring Loan Calculations 90
Calculating the payment amount 91
Calculating interest payments 93
Calculating payments toward principal 94
Calculating the number of payments 96
Calculating the number of payments with PDURATION 97
Calculating the interest rate 98
Calculating the principal 101
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 103
Looking into the Future 104
Depreciating the Finer Things in Life 106
Calculating straight-line depreciation 108
Creating an accelerated depreciation schedule 109
Creating an even faster accelerated depreciation schedule 111
Calculating a midyear depreciation schedule 112
Measuring Your Internals 114
Chapter 7: Using Basic Math Functions 119
Adding It All Together with the SUM Function 119
Rounding Out Your Knowledge 124
Just plain old rounding 124
Rounding in one direction 126
Leaving All Decimals Behind with INT 131
<…