Instructor: Robin Wood - robin 'at' wctrain dot net
There should only be one database on a worksheet.
The database must be defined with the name "database".
The database can have a maximum 256 fields and 65,536 records.
When using a "Criteria" or "Extract" range the field names must be exactly the same as the database. To ensure they are the same, copy the field names from the original database.
Type the field names. Select the field names and the blank row below.
Click in the Name box, type Database and press Enter.
Click Data > Form. Enter the desired data into the form pressing the Tab key between fields. Press the Enter key to create a new record.
You may need to adjust the database range. Click inside the existing database range and select Insert > Name > Define. Select the named range you want to edit and adjust the range in the Refers to area of the dialog box.
Sorting DataSelect the field name that you want to sort by and click the Sort Ascending 
or Sort Descending 
button.
To sort on multiple fields, click Data > Sort.
You can subtotal any numeric column. Click Data > Subtotal.
To turn off subtotals, click Data > Subtotals > Remove All.
AutoFilterData > Filter > AutoFilter. Click the filter arrow next to the field name you want to filter. Select the item on the list that you want to filter by or select Custom.
Data > Filter > Show All or Data > Filter > Autofilter to turn off the filtering feature.
Highlight the database field names and press CTRL+C to copy. Paste the field locations to an empty range on the same worksheet. Select the new field names and the empty row below and name the range Criteria in the name box.
Use the same procedure to create an extract range. Use Extract as the range name.
Overview of Database Functions