From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using filters
- If you work with lists of data, there are certainly times when you are saying, "I don't need to see all this for the moment, "I want to focus on just the people "in a certain department, maybe marketing." Or at another time, "I just want to see "the full-time people here." Or at another time, "Let's focus on the people "with the best or the worst job rating." Any number of different reasons for not wanting to see all the data and focus on just the data you need to see, the feature is called Filter. You can, from the Home tab, far right, click Sort & Filter, and then Filter to get to it that way. You could also jump over to the Data tab, and you'll see filter there as well. As with other data management tools, make sure that your data has no empty rows or columns within it. If you work with the data frequently, that's not a concern. Simply click on one of the cells within the data. Here is Filter right here, click it. And we see filter arrows at the top of each column. And it's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Sorting data9m 44s
-
(Locked)
Inserting subtotals in a sorted list8m 39s
-
(Locked)
Using filters6m 43s
-
(Locked)
Splitting data into multiple columns8m 26s
-
(Locked)
Splitting and combining columnar data with Flash Fill6m 40s
-
(Locked)
Removing duplicate records2m 23s
-
(Locked)
Using validation tools10m 45s
-
(Locked)
-
-
-
-