HOW TO FILTER DATA IN EXCEL
INTRODUCTION
In general sense, the filter is a method or tool that is used to show only certain amount of information from selected data and in Microsoft Excel, filters can be used to narrow down the data in your worksheet and allowing you to view only the information you need.
A filter can be applied to perform various types of operations on both types of data (Number & Text) and by using it, we can perform the following tasks.
1. Sorting in data: Arrange data in ascending or descending order.
2. Hide and Unhide: Filter is used to hiding or unhides data items.
3. Filter the data: This feature is used to filter the selected data item.
SIMPLE FILTER EXAMPLE
1. Open the Microsoft Excel.
Run -> excel -> Click on ‘Ok’ button.
2. Enter the following data items
Emp. Code
|
Emp. name
|
Dept.
|
Basic Salary
|
E101
|
Smith
|
Admin
|
$ 28,000
|
E102
|
Alex
|
Sales
|
$ 20,000
|
E103
|
David
|
Purchase
|
$ 19,500
|
E104
|
Sam
|
Sales
|
$ 21,000
|
E105
|
Cloudia
|
HR
|
$ 27,000
|
E106
|
Drothi
|
DEO
|
$ 16,500
|
E107
|
Amma
|
Receptionist
|
$ 15,000
|
3. Go to “Data” Menu and click on “Filter” tool.
Note: As you click on "Filter" tool, it will automatically add the filter buttons in the top of selected columns, see the below image.
0 Comments