Recognizing the limitations of standard filtering


show more Recognizing the limitations of standard filtering provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Recognizing the limitations of standard filtering

Despite the power and capability of the Filtering tool, there are some situations that you just cannot handle. Now, there have been huge improvements in filtering and in prior versions, by the way, filter was often referred to as auto filter, but we have another category called Advanced Filters. Not to be covered in this particular movie. Let's talk about those situations that filter does not cover. Let's apply the filter to this list here and imagine that the following request came up. We'd like to create a list here consisting of those people whose salaries are above 80,000 or whose years of service are 20 or more.

Now if we start with salary here and choose a number filter for all those that are Greater Than Or Equal to 80,000, there we go. If we now click the Year Filter and choose Number Filters and here we are interested in those who have been here 20 or more years. I think if you haven't tried this, you're already thinking what's going to happen here. We are...

Recognizing the limitations of standard filtering
Video duration: 1m 56s 1h 32m Appropriate for all

Viewers:

Recognizing the limitations of standard filtering provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...