Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 going to get results here for people who meet both criteria at the same time, and the original statement was if the salary is greater than 80,000 or the years are 20. There's no way that we can handle this with a standard filter.
We must use an advanced dilter. Thinking along similar lines, imagine if you wanted to-- and I'll pull back all of the data by Clearing-- you wanted to come up with a list consisting of those manufacturing people who are full- time and at the same time, those quality control people who are contract, admittedly an unusual combination, but trying to pull together disparate fields using the Or as a joining word, that's one way to describe it, is not going to work with regular filter. I think for most people, filter is going to handle 95% to 100% of what you need most of the time, but there is an advanced filter to handle these kind of unusual situations typically involving the word Or in different columns.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91304 Viewers
80 Video lessons · 138231 Viewers
59 Video lessons · 57057 Viewers
52 Video lessons · 70715 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.