Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Insert Tab

EXCEL 2010 INSERT RIBBON

Filter

EXCEL 2010 FILTER GROUP

One way to filter data in Excel 2010 is to use slicers. Slicers are used to quickly filter a pivot table. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable.

To get started, open your PivotTable and select anywhere in the table. Go to the Filter section in the Insert tab.

EXCEL 2010 PIVOT TABLE DATA
EXCEL 2010 INSERT SLICERS





Select Slicer and the Insert Slicers dialog box will appear (shown in the image to the right). Here you can select the fields you would like to filter. Select OK when finished. In our example, we are selecting Downline, Region and March Kits Sold. Each slicer will appear in your worksheet as shown in the image below.

EXCEL 2010 INSERT SLICERS





All the data is selected in the slicers, so all data is currently showing in the table.

You can move the slicers anywhere in your worksheet by clicking and dragging. Select the items within the slicers you want to filter. For example, we want to filter the Bronze field within the March Kits Sold.

EXCEL 2010 MOVE SLICERS

When clicking on Bronze, our table changes to show our selection (as shown in the image above). The fields highlighted in the slicers are the content included in the table above the slicers. Hold Ctrl to select multiple items.

All slicer’s update automatically when you change your data in the table. To clear a slicer’s filter, select Clear Filter .

Next Tutorial


This concludes the Filter tutorial.
Click next to continue to the Excel 2010 Links tutorial.