From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Top 10 (value or percent) option

Top 10 (value or percent) option - Microsoft Excel for Mac Tutorial

From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Start my 1-month free trial

Top 10 (value or percent) option

- [Instructor] We're looking at a worksheet called Top 10 filter, and you probably already have a guess as to what that means. This is the filtering feature that only works on numeric type columns. For example, in this worksheet here, column J would be the obvious example. So, column H, column K. Let's apply a filter, first of all, from the data tab in the ribbon choose filter. And then let's take a look at the data in column J, the compensation numbers, the salaries, and so on. Click the drop arrow there. Move the dialogue box over to the left. Choose one. Top 10. And, immediately, we see that this could be Bottom 10. If we choose Top 10, what do we see? In the background, the the top 10 compensation amounts in the entire list. Not necessarily in sorted order, and they're not in this case. But we see the top 10, there they are. Now, that's the top 10 items, there's another choice here. Instead of the actual items, we could be looking at the top 10%. Now, this list has about 740…

Contents