In database if we want to display specific data only, then we have to apply some condition on database. Which data have been satisfied the condition those data only will be appeared to the user. While hiding the other data .This process is called Filter in Excel.
It is done to make it easier to focus on specific information in a large dataset or table of data.
Filtering does not remove or modify data; it merely changes which rows or columns appear in the active Excel worksheet.
When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row. Excel gives you many options when it comes to filtering your data.
By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to
see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data that you want to see.
To learn Filter in Excel at TCCI.
Call us @ 9825618292