Excel Formulas & Functions For Dummies

by Ken Bluttman

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.

Genres: Reference, Science, Technology, Nonfiction, Computers, Productivity, Software

402 pages, Kindle Edition

Published October 26, 2018

Reviews

[Lynn Cansler]

Maybe helpful for a beginner, but this book is not as helpful a reference as Microsoft for an advanced user. Any time I need help, Microsoft has a video on any function. I'm also learning a lot from Excel webinars.

[Angelina Teneva]

Having had to lookup and manipulate text strings for the past 3 years, I can hardly say there were any surprises in that section of the book, although it did provide a good summary.

Fianncial modelling, forecasting and statistics formulae, however, were a different kettle of fish and I will be sure to revisit if I ever find myself in need of creating analysis on the basis of those.

[S]

005.54 BLU

[Reena]

eh. it was okay, but for that thick a book, it didn't have as many formulas as I was expecting. But it's a good basic book to get started with.

[Katie]

Wish I'd read this years ago. Would've saved me so much time and so many headaches. Very hand how-to to keep around your desk in case you need a reminder.