Excel Formulas & Functions for Dummies

by Ken Bluttman and Peter G. Aitken

Book Overview

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

• Format: Paperback
• Language: English
• ISBN: 1119518253
• ISBN13: 9781119518259
• Release Date: October 2018
• Publisher: For Dummies
• Length: 400 Pages
• Weight: 1.24 lbs.
• Dimensions: 0.7" x 7.4" x 9.2"

Customer Reviews

Great for learning/or a reference for beginner to intermediate!

This has been very helpful. If you are a beginner to intermediate at Excel formulas this will be a very good book for you. I got it for work and have been able to get moving rapidly with more complex worksheets.

Really Helps at Work

I have to create a lot of Excel spreadsheets at work, and was always sort of intimidated by the functions in Excel. Instead of using functions, I spent a lot of time entering numbers and then finding the answer by hand, and just typing the answer in an empty cell. If any of the data changed, I would have to do all of the calculations over again, and hope that I didn't make any mistakes. This book explains each of the Excel functions in a really clear and easy to understand way, and walks you through how to use them step by step. I'm using more and more functions in my spreadsheets now. I don't have as many mistakes as before, because the functions do the calculations automatically, even when you change some of the data. I keep this book in my desk and look at it all the time. The people I work for have noticed the difference in the quality of my spreadsheets, and I'm getting a lot of complements. They're even coming to me to ask for advice! I definitely recommend this book if you use Excel at work.

A Really Helpful Book

I always found it hard to understand how functions work. It's one thing to use the autosum button to add some numbers together. It's another thing to use functions and know which one to use. But now this Excel book has come to my rescue. The book is well designed by explaining the basics first. Then the book is organized by categories of functions. I recommend it highly!

Great book!

I've been using Excel for years, including formulas, but this book really expanded my knowledge about Excel and all the built-in functions. I highly recommend this book!

I finally understand!

I've been using excel for a year or so but was always afraid to try formulas aside from really simple ones. I was also nervous about the functions because I wasn't sure what they did. This book has been a huge help. It makes things really clear. It explains all the details so I feel I have a real grasp of the topic.