Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

Hooking up slicers to one pivot table in Excel 2010 provides a programming-free way to create dashboards. One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer.

To add a slicer to a table, with your cursor already somewhere in the table, head to the Design ribbon, select Insert Slicer and then choose which column (s) you’d like to filter.

To add a Slicer, click inside the PivotTable, and choose PivotTable Tools > Options > Insert Slicer. Click the checkbox for each Slicer to add to the worksheet, and click OK.

Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.