Learnit Training

4. Data filters

In this lesson, working with data filters is handled.
With a data filter you can easily search for data files.
Data filters are especially useful for large data files such as a customer base.

This lesson uses the file customers.
Here you can download the customers file.
The file can then be saved to your own computer. For example in "My Documents".

Open the file Customers

Click the File tab and the Open button opens the customers file you just saved.

Figure 4.1 The file customers

The formatting

First, we'll add formatting to the table so it looks neat.
Click the Home tab if it is not already activated.

 

Figure 4.2 Home Tab

Data filters can then be added to the table by clicking the "Format as table" button.

A list of formats is opened.
Choose a format from.

Figure 4.3 Choose a format

 

Figure 4.4 Make sure the table is selected

Make sure the table is selected correctly.
If it has gone well, the Format window shows as table: = $A $1: $E $16
Click OK.

The result

Figure 4.5 Customer database with data filters

Using the Data filter

In the previous exercise we added formatting and a data filter to the table.
In This exercise we will work with the data filter.

The format and data filter has been added to the table.
The filter is visible in the column header row.

Figure 4.6 The data filter

Click on the arrow behind last Name

Figure 4.7 Set Filter for last name


Uncheck (select All).
Check the box next to Dirken.


Figure 4.8 Select the desired filter

Filter result

Figure 4.9 Result Filter

Last name now contains a button with a filter icon. This means that the last Name field is filtered.

Click the button after last name again.
Select the option (select All)
All customers are visible again.

Create a list of people from Hilversum or Amsterdam.

The result

Figure 4.10 Result filtering on all people from Hilversum or Amsterdam

Solution:

You can filter out Hilversum and Amsterdam by clicking on the arrow behind place.
Make sure only Hilversum and Amsterdam are checked.