John Wiley & Sons Excel Formulas & Functions For Dummies Cover Put the power of Excel functions to work in your formulas There are more than 400 built-in function.. Product #: 978-1-119-51825-9 Regular price: $25.14 $25.14 Auf Lager

Excel Formulas & Functions For Dummies

Bluttman, Ken


5. Auflage Dezember 2018
400 Seiten, Softcover
Wiley & Sons Ltd

ISBN: 978-1-119-51825-9
John Wiley & Sons

Jetzt kaufen

Preis: 26,90 €

Preis inkl. MwSt, zzgl. Versand

Weitere Versionen


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.

Introduction 1

Part 1: Getting Started with Formulas and Functions 5

Chapter 1: Tapping Into Formula and Function Fundamentals 7

Chapter 2: Saving Time with Function Tools 37

Chapter 3: Saying "Array!" for Formulas and Functions 55

Chapter 4: Fixing Formula Boo-Boos 65

Part 2: Doing the Math 83

Chapter 5: Calculating Loan Payments and Interest Rates 85

Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 103

Chapter 7: Using Basic Math Functions 119

Chapter 8: Advancing Your Math 137

Part 3: Solving with Statistics 159

Chapter 9: Throwing Statistics a Curve 161

Chapter 10: Using Significance Tests 199

Chapter 11: Rolling the Dice on Predictions and Probability 209

Part 4: Dancing with Data 227

Chapter 12: Dressing Up for Date Functions 229

Chapter 13: Keeping Well-Timed Functions 247

Chapter 14: Using Lookup, Logical, and Reference Functions 257

Chapter 15: Digging Up the Facts 289

Chapter 16: Writing Home About Text Functions 303

Chapter 17: Playing Records with Database Functions 327

Part 5: The Part of Tens 343

Chapter 18: Ten Tips for Working with Formulas 345

Chapter 19: Ten Functions You Really Should Know 359

Chapter 20: Ten Really Cool Functions 367

Index 375
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.