Using a Spreadsheet as a Database

This section examines the use of Excel as a Database program. Although Excel is a spreadsheet it has a range of powerful features which allow it to create and manipulate data.

Topics include:

Excel as a Database
Creating a Database
Sorting the Database
Using a Data Form
Viewing records based on certain criteria
Autofiltering records
Moving around a Database
Creating a Criteria Range
Creating Subsets of you Data
Pivot tables - Putting a Spin on your Data

---