We can use filtering in Excel to quickly extract certain data from your spreadsheet. By filtering information in a worksheet, you can find values quickly.
It actually hides the rows or columns containing data that do not meet the filter criteria you define. Excel has an Auto Filter feature that makes it very easy to extract data from your spreadsheet.

To use the Auto Filter:
1) Click on any cell in your spreadsheet.
2) Select the Home tab.
3) Under the Editing group, go to the Sort and Filter option and select the Filter button.
4) Drop-down menus will appear next to each cell heading.
5) Clicking on any drop-down menu will provide you with options for filtering.

Filter in used in excel to sort the data as per our requirement.
for example of we want to find the details of a particular person we can go to filter den text filter, then contains and customer filter can be chosen for sorting names or amount.