In this section, I'll introduce you to Excel's ten main categories of built-in functions: Database, Date and Time, Engineering, Financial, Logical, Information, Lookup and Reference, Math and Trigonometry, Statistical, and Text. We'll look at the functions that are most widely useful, with examples where they'll be helpful.
Excel includes 12 database functions you use to identify values in an Excel table that match your specified criteria. (A table is a flat-form database you create on a worksheet; Chapter 10 explains how to create tables and gives you examples of using the database functions.) Table 6–1 explains the database functions.
Table 6–1. Excel's Database Functions