Excel 2016 Formulas
Michael Alexander is a Microsoft Certified Application Developer and author of several books on Microsoft Access and Excel. He runs a free tutorial site at datapigtechnologies.com. Dick Kusleika develops Access- and Excel-based solutions, and conducts Office training seminars in the U.S. and Australia. He writes the popular blog dailydoseofexcel.com. John Walkenbach is a renowned authority on Excel. He has written hundreds of articles, thirty-plus books, created the award-winning Power Utility Pak, and developed the popular spreadsheetpage.com.
Excel 2016 Formulas
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 sheets, save files, and complete other basic tasks.
Navigate a workbook.
Use the Excel Ribbon and dialog boxes.
Use basic Windows features, such as file management and copy-and-paste techniques. What You Need to Have
This book was written with Excel 2016 as a base, but most of the material also applies to Excel 2007-2013. If you're using a version prior to Excel 2016, you may find that a handful of functions (such as the new Forecasting functions introduced in Excel 2016) will not be available to you. Any function not available in all four versions of Excel will be called out in each chapter.
If you are using a version of Excel prior to 2007, we highly recommend you pick up a previous edition of this book. The changes introduced in Excel 2007 are so extensive that you might be hopelessly confused if you try to follow along using an earlier version of Excel.
To download the examples for this book, you need to access the Internet. The examples are discussed further in the "About This Book's Website" section, later in this Introduction.
Note that the examples for this book were created on the Windows platform. For you MAC users, we can't guarantee that all examples will work with Excel for Mac. Excel's cross-platform compatibility is pretty good, but it's definitely not perfect.
As far as hardware goes, the faster the better. And, of course, the more memory in your system, the happier you'll be.
Conventions in This Book
Take a minute to skim this section and learn some of the typographic conventions used throughout this book.
You use the keyboard to enter formulas. In addition, you can work with menus and dialog boxes directly from the keyboard-a method you may find easier if your hands are already positioned over the keys.
Formulas usually appear on a separate line in monospace font . For example, we may list the following formula:
Excel supports a special type of formula known as an array formula . When you enter an array formula, press Ctrl+Shift+Enter (not just Enter). Excel encloses an array formula in brackets in order to remind you that it's an array formula. When we list an array formula, we inc