Join Dennis Taylor for an in-depth discussion in this video Using numeric filters, part of Excel 2013: Managing and Analyzing Data.
…If you work with a list that contains numeric information…like this one, there's a compensation column in column K.…Applying a filter gives us special tools as we work with data of…that type, so we see the drop arrows for all the columns here.…And since the data in column K is all numeric, as we click…the drop arrow here for the filter, we see the term, Number filters.…You may recall that in previous movies if you've seen…them, there's a text filter, there's also a date filter.…Number filters provide us more choices then what we saw with text…filters, and much easier than some of the older versions of Excel.…
If we simply want to display those sets of data that relate to…people who have salaries above average, or…compensation levels in this case, above average.…There it is, above average.…And all these are above average.…We don't even necessarily have to know what that average is.…We're just seeing those above the midpoint, there.…And so, once again, a lot of these tools…almost self explanatory, but quite a few choices here.…
- Multiple key sorting
- Filtering single and multiple columns
- 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
- Converting lists to tables
Skill Level Intermediate
1. Sorting Data
2. Filtering Data
3. Advanced Filter
4. Creating Automatic Subtotals in Sorted Lists
5. Eliminate Duplicate Data
6. Data Analysis Tools
Converting lists to tables10m 45s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.