Excel Filter _How to filter and find data which is important

 

An additional tool within the Pivot Tables feature set are ‘Slicers’. Slicers are graphical filters

ideal for analysts or customers who like to examine data from many different perspectives.

Timeline Slicer - 

 1. Open the AirlineParts.xlsx spreadsheet and highlight cells A1:F3889

2. From the Ribbon select INSERT : PivotTable

3. Verify the ‘New Worksheet’ radio button is selected

4. Click the ‘OK’ button

Advanced Filtering

In the first part of this chapter we reviewed how Slicers may be used for quick filtering. In this

section we’ll demonstrate how to employ additional Pivot Table features which allow us to

extend our analysis by specifying conditions.

Please find below types 

1. The top 10 airplane parts sold by category?

2. The bottom 10 airplane parts sold by category?

3. The top 10 airplane parts sold by Quarter?

4. How many parts sold more than 800 in quantity?

Similarly we may change to show the bottom 10.

9. Click the drop-down arrow of ‘Row Labels’

10. From the menu select ‘Value Filters’ then ‘Top 10’

11. The following prompt will appear, click the drop-down box that says ‘Top’, change

to ‘Bottom’

12. Click the ‘OK’ button

To remove a filter

Click the drop-down arrow of ‘Row Labels

From the menu select Clear Filter From