Excel 2016 Formulas

Introduction

There’s no arguing that formulas are the true engines of Excel. Employing various Excel functions, formulas enable Excel analysts to create aggregated reporting, complex calculation engines, clever dashboard models, and much more. Indeed, Excel analysts become more productive as their proficiency with Excel functions and formulas improves.

But building proficiency with Excel functions and formulas takes time. Given that Excel contains more than 400 functions, you could spend months, even years, learning which functions are best for certain tasks and which functions can be combined with others functions.

This is where this book comes in. Here, we will introduce you to the world of Excel formulas by guiding you through the various built-in functions Excel has to offer. Each chapter builds on the last, taking you from basic math functions to actually building your own custom functions.

As you’ll discover, leveraging Excel functions will not only make you more productive, but it will allow you to accomplish tasks that you didn’t know could be handled with Excel formulas.

What You Need to Know

This is not a book for beginning Excel users. If you have absolutely no experience with Excel, this is probably not the best book for you unless you’re one of a rare breed who can learn a new software product almost instantaneously.

To get the most out of this book, you should have some background using Excel. Specifically, we assume that you know how to

• Create workbooks, insert ...