Excel Formulas and Functions For Dummies

by Ken Bluttman

Grab these Excel formulas and functions to make your life easier!

Are you intimidated by major financial choices, like which loan to get or how to grow your savings? Don't worry—we all are! But Excel Formulas & Functions For Dummies, 4th Edition can take some of the pain out of the data organization and analysis processes. This step-by-step reference sheds light on Microsoft Excel's 150 most useful functions, and offers detailed instructions on how to implement them. Additionally, each function is illustrated by helpful, real-world examples that show how they are used within a larger formula. To take your knowledge of Excel's functions a step further, 85 specialized functions are described in abbreviated form so you can use Excel to better support your decision-making process when securing a mortgage, buying a car, computing classroom grades, evaluating investment performance, and more.

Functions are predefined formulas that you can use to make data analysis a bit easier within the Microsoft Excel framework. Functions use specific values, called arguments, to calculate a variety of things, from simple sums and averages to more complicated loan payments.

Explore the 150 most useful functions that help Microsoft Excel make your life easier Access real-world examples of how functions fit into larger formulas Discover 85 specialized functions, which are described in abbreviated form and take your knowledge of Excel to the next level Understand how Microsoft Excel can help you make key decisions, such as whether to go with a 15-year or 30-year mortgage

Excel Formulas & Functions For Dummies, 4th Edition brings order to chaotic data—and helps you make decisions with confidence!

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

554 pages, Kindle Edition

Published November 30, 2015

Reviews

[Lynn Cansler · Rating 2 out of 5]

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 · Rating 3 out of 5]

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 · Rating 3 out of 5]

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 · Rating 5 out of 5]

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.