Excel 2003 Step by Step Database Tutorial

Using the Database Tools

Creating lists in Excel

© Ted French

Using the Database Tools

Note: For help on these steps, refer to the image above.

Once you have created the database, you can use the tools located under the drop down arrows beside each field name to sort or filter your data.

Sorting Data

1. Click on the drop down arrow next to the Last Name field name.
   
   
2. Click on the Sort Ascending option to sort the database alphabetically from A to Z.
   
   
3. Once sorted, Graham J. should be the first record in the table and Wilson . R should be the last.

Filtering Data

1. Click on the drop down arrow next to the Program field name.
   
   
2. Click on the Business option to filter out any students not in the business program.
   
   
3. Click OK.
   
   
4. Only two students - G. Thompson and F. Smith should be visible since they are the only two enrolled in the business program.
   
   
5. To show all records, click on the drop down arrow next to the Program field name.
   
   
6. Click on the All option.
   
   

Return to Index page

• Excel Database Overview
• Creating Tables and Lists
• Entering Data Correctly
• Rows are Records
• Columns are Fields
• Creating the List
• Using the Database Tools
• Expanding the Database
• Formatting the Database