Slicer in MS Excel 2010 Excel Tips

Slicer in MS Excel 2010

Posted Date: 05-Jul-2012	Category: Excel
Author: Nandhini	Member Level: Gold	Points: 15

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.

Post Comment:

Notify me by email when others post comments to this article.

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:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.