Find Top Performers In 3 Clicks In Excel
Hello Everybody and welcome to Excel Made Easy
I’m your guru and in this video I’ll tell you how to find the top performers or the top, highest values in your data of any size in just 3 clicks. I have taken very simple example, There are few names of the best stars as of today and here are the hypothetical movie revenues for them say for their lifetime and we would now like to find out which of these is, which, which 10% or 20% of these are the top people, Alright so are the top revenue earners. So how to you do that in just 3 clicks. Very Simple. Just select the complete data, click on conditional formatting, go to top bottom rules and click on top 10%. Now here you can define top 10 % or top 20% or top 30% whatever and you can also choose the color to be used in that. Let us use the green color. So here we are finding the top 30% which will be highlighted with green color in just 3 clicks. Here you have Jhonny Depp, Morgan Freeman and Eric Bana. Now this data is totally hypothetical.
This is so very simple. You can do it with data of any which size, it can be any size at all. Alright. I hope you like this video. You can download this training file from my website myelesson.org So until the next video, this is your guru signing off for the day. Have a wonderful day ahead
Happy Learning.