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
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
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
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.
Figure 4.10 Result filtering on all people from Hilversum or Amsterdam
You can filter out Hilversum and Amsterdam by clicking on the arrow behind place.
Make sure only Hilversum and Amsterdam are checked.