Excel Functions and Formulas in easy steps shows you how to use the power of Excel functions and formulas to take full advantage of this popular spreadsheet application. Learn how to:

• Save time by utilizing Excel functions to carry out often-used operations, for error checking and tracing cells.


• Build powerful spreadsheets using the features of Excel formulas.


• Explore all the categories of Excel functions including financial, logical, mathematical, lookup and other data-related functions.


• Review business-oriented scenarios and examples of functions in each of the groups.


• Create your own simple macros, and more.

Covering all recent versions of Excel including Excel in Office 365, this book will guide you through a myriad of Excel functions and formulas – clearly, concisely and in easy steps!

Table of Contents

1. Values and Formulas


2. Managing Formulas


3. Functions


4. Math & Trig and Logical


5. Date & Time and Text


6. Financial and Statistical


7. Lookup & Reference and Information


8. Database and Engineering


9. Compatibility, Cube and Web


10. User Defined Add-ins and Macros


11. Support and References