Excel Functions & 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