Slicer in MS Excel 2010

Slicer are visual controls that allow you to quickly and easily filter your data in an interactive way. Slicer lets you to slice your data by showing only the element stored in the tables. We can see the real usage of slicers in the Pivot table.

Slicer is a new feature in MS Excel 2010. It is a new command under PivotTable Options tab called Insert Slicer.

The slicer feature is being considerd to be one of the most prominent ones. It provides a rich visualization of your pivot table view so that one can dynamically segment and filter the data to display, just what one needs.

Slicers provide buttons that you can click to filter PivotTable data.

One can locate this feature from Insert menu. When the user selects the Insert Slicer, it will open a dialog box where we can select the dimensions we want to filter. Once the Slicers are created, the users can simply click the Slicer values to filter the PivotTable

Slicers can be tied to more than one PivotTable. Any filter you apply to your slicer will be applied to all the connected PivotTable. This is the unique advantage that clicers have over the Filter fields.

The major disadvantage in Slicer is it does not support backward compatibility.
And also the Slicers are huge, they take up most of the page.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: