Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Filter Analysis Look at the first row of this spreadsheet. Each of the labels has a drop down list. These are the filters. You can use more than one. Try filtering the Category for Educational clients, then add a couple from the Class filter. You can remove any filter by going to the drop down and selecting “Clear Filter.”   Here is a different view: Filter by Color.