Excel, like many other spreadsheet programs, allows the user to create a database, also known in Excel as a List.
By using your worksheet as a database you can easily store and manipulate complex data or large amounts of data.
You can use the database in Excel to:
Database Range or List
A database range is a rectangular range of worksheet cells defined as a database.
In the example the database range or List would extend from B2 to G8.
Record
A record is a single row in the list.
Each record contains the same categories of data as every other record in the list.
Field
Each column in the List is a separate field.
Text, numbers, dates, formulae or functions can be entered into any field.
Computed Field
A field containing formulae or functions, ie VALUE from above.
Field Name
A field name is a name that identifies the data stored in a field.
The top row of the List should contain the field names.