Excel Formulas & Functions for Dummies, 5th Edition

  • 5h 15m
  • Ken Bluttman
  • John Wiley & Sons (US)
  • 2019

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.

About the Author

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.

In this Book

  • Introduction
  • Tapping into Formula and Function Fundamentals
  • Saving Time with Function Tools
  • Saying “Array!” for Formulas and Functions
  • Fixing Formula Boo-Boos
  • Calculating Loan Payments and Interest Rates
  • Appreciating What You'll Get, Depreciating What You've Got
  • Using Basic Math Functions
  • Advancing Your Math
  • Throwing Statistics a Curve
  • Using Significance Tests
  • Rolling the Dice on Predictions and Probability
  • Dressing up for Date Functions
  • Keeping Well-Timed Functions
  • Using Lookup, Logical, and Reference Functions
  • Digging up the Facts
  • Writing Home about Text Functions
  • Playing Records with Database Functions
  • Ten Tips for Working with Formulas
  • Ten Functions You Really Should Know
  • Ten Really Cool Functions


Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 4.5 of 1501 users Rating 4.5 of 1501 users (1501)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)


Rating 4.5 of 297 users Rating 4.5 of 297 users (297)
Rating 4.4 of 1076 users Rating 4.4 of 1076 users (1076)