Ticker

6/recent/ticker-posts

Advance Excel (Filter)

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.




4. Now click on any filter button and select the filter conditions.










ADVANCE FILTER >>














Post a Comment

0 Comments