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. 

 
at

No comments:

Post a Comment

Subscribe to: Post 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 ...

  • About #N/A Error
    This error indicates that a value is not available to a function or formula. Symptom Excel displays #N/A in one or more cells on a workshee...
  • Use of Advance Filter in MS Excel
    Advance filter available in "Data" ribbon is used to filter your data with some complex criteria. To use advance filter option you...
  • How to move texts from Notepad to Column in MS Excel?
    This is also known as "Import a Delimited Text File". Step 1: To import a Delimited Text File, the user has to go to the “DATA” ri...