How to Filter Data Microsoft Office Excel

Filtering in Microsoft Excel - At one data, particularly those serving on the list of students' grades, sometimes we want to find out who is the best, and we will only show the best that's all automatically. To carry out such a task, Excel is equipped with its own tools.

 if we want to do something like the above, it is the name we will perform a filter data. To filter this data is actually very easy, it's just that if we do not know how may seem difficult.
But you do not need to worry. If you do not know how to filter out the value of the student to determine the rankings, here I will share the tutorial. Go see the tutorial how fiter following data.

How to Filter Data In Microsoft Office Excel 2007

Here I use the data following list of exam score as a material for tutorial filter this data. This time we will clear the 3 children with the highest value and eliminate the data value other children.

 Steps: 

1. Blocks from A4 up to F14 (from number cell until 7,0)
2. If already on the block, in the Sort & Filter box select a filter. Now you value data is ready to be filtered. 
3. Then point your mouse pointer to the small arrow located on score. Select Number Filter and select the Top 10
4. Then a new window will appear as below. Change 10 down to 3, and finally click OK
   
   
    

     

   That tutorial to filter data in excel 2007. Immediately practice, Among tutorial this time, this may be useful for you.