Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

Ankur Sharma
02 Jul 0 0

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter.

Please refer to sample dataset below:

To do Data Analysis:
Step 1) Apply Filter on the dataset.
Step 2) In Sales Amount column, click on Filter drop-down.
Step 3) Take Your cursor to Number Filters. A-List of Options will open up.
As highlighted in the screenshot below:
i) Please click on Top 10 - to see list of Top 10 Performers OR Bottom 10 Performers
ii) Please click on Above Average - to see list of Above Average Performers
iii) Please click on Below Average - to see list of Above Average Performers


Likewise, in the Date column, if You click on Filter drop-down, and take the cursor to Date Filters, a List of Options will open up.
As highlighted in the screenshot below, the Options will allow You to do Data Analysis across different periods, in a Click.


Isn't this Cool. Data Analysis in Few Clicks!


0 Dislike
Follow 1

Please Enter a comment


Other Lessons for You

How to add bullets Point in MS-EXCEL
There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal | 21 Jul

0 0

How to Insert a Pivot Table.
Let's learn how to Insert a Pivot Table.

Amey Vidvans | 22 Apr

0 0

How to create drop down function in Excel?
Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...

Ayush Agarwal | 26/11/2019

1 0

Vlookup is old, use Index Match function
Vlookup function has the below limitations. 1. The lookup range should always be on the right-hand side of the vlookup value. This is the biggest limitation. 2. If supposedly you need to look up a value...

Ayush Agarwal | 26/11/2019

0 0

Looking for Microsoft Excel Training classes?

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Microsoft Excel Training Classes?

Find best Microsoft Excel Training Classes in your locality on UrbanPro

Post your learning requirement is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more