Saturday, August 31, 2013
Friday, August 30, 2013
How to use Slicer for effective filtering of Pivot Data in MS Excel?
About Slicers in MS Excel
Slicers provide buttons that you can click to filter PivotTable data. 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 report.Step 1: To get the Slicer option you have to go the "Insert" Ribbon's "Filter" tool. There you will have two options 1) Slicer and 2) Timelines.
Step 2: Create you pivot table and then click Slicer. You will get the Slicer selection list.

Step 3: Select the Year and Margin or all three. You will get the slicer of your pivot table.
Subscribe to:
Comments (Atom)
Preface 2nd Edition
The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS ...
-
Microsoft Excel provides several layers for protecting your sheet and workbook. For example, you can protect your entire workbook, or you ca...
-
Cómo insertar Control Calendar en MS Excel? Spanish Version of this blog To insert the calendar control you first have to enable your "...
-
Sometime we have to fill lot of repetitive data in excel and that becomes very cumbersome. During such cases Flash Fills newly included in M...