Meeting Excel's Built-in Functions

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.

Database Functions

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


Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.