excel2013 advanced filtering how to use

How to use excel2013 Advanced filtering:

Advanced filtering Step 1: Sift through the data for all the courses in which the test scores are above 85 points

Advanced Filter Step 2: First create a "conditional area" in the table, you need to be aware that all data is greater than or equal to a number, the condition area should be placed side-by-side in the same row!

Advanced Filter Step 3: Open the Data window after setting the criteria range, and click Advanced in the Sort and filter menu

Advanced Filter Step 4: Select the appropriate data area in the Advanced Filter dialog box that pops up, and the selection of the data area can be directly selected by pushing the mouse.

Advanced Filtering Step 5: Click "OK" after the selection, the system will automatically hide the data that does not meet the criteria, and will match the conditions of the data displayed on the above.