Join Dennis Taylor for an in-depth discussion in this video Recognizing the limitations of standard filtering, part of Managing and Analyzing Data in Excel 2010.
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, …
- Multiple key sorting
- Single and multiple column numeric filters
- Creating a top-ten list with values or percentages
- Setting up subtotals
- Creating multiple-field criteria filters
- Creating unique lists from repeating field data
- Using the Remove Duplicates command
- Finding duplicate data with specialized arrays
- Counting the number of unique items in a list
- Using SUMIF and COUNTIF functions
- Working with the database functions such as DSUM and DMAX
Skill Level Appropriate for all
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.