Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
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.
Find answers to the most frequently asked questions about Managing and Analyzing Data in Excel 2010.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.