Now we will understand the important feature of pivot table that is Slicers.
Suppose if we add any particular category in our filter section, then in our pivot table on top there will be one category added, and then when we try to select multiple category we do not get it in proper understandable way.
If we want to check properly that what is being shown in pivot table, then we use Slicer.
Slices is located in analyze column of pivot table tools. We can see an option of 'Insert Slicer', when we click it, it will ask us that for what things we want slicer to add. Then when we select the things which we want, we will see the slicers of them appeared on our screen.
Slicers has one main drawback that is they cover a lot of area on our screen. So for that we can arrange our slicers size according to our need.
Now whatever data we want to see we can select them accordingly from slicers.
To remove slicers we can use 'clear filter' button on the top left corner of the slicers.
To completely remove slices from screen free will first ensure that no filter is ON, and then select the particular slicer and press 'Delete' key from our keyboard.
A slicer is a type of filter that can be applied to data in Excel. It allows the user to easily sort and filter data without having to use complex formulas or VBA code.
Slicers can help you find information quickly
They allow you to compare different datasets
They save time by automatically filtering your dataset for you
Slicers are a type of filter that allow users to quickly and easily filter data in Excel. They are very useful when you need to filter a large amount of data by one or two criteria which may be difficult to find on the spreadsheet.
We can create a slicer in MS Excel by following these steps:
Select the data you want to slice from the table, and then go to Insert > Slicer.
Drag the fields you want to see in your slicer into the white box on top of the screen.
Slicers make filtering data in a pivot table a breeze. Click the Insert Slicer command (and then select Insert Slicer in Excel 2007/2010) on the PivotTable Tools Analyze tab (PivotTable Tools Options tab in Excel 2007/2010), in the Filter group (Sort & Filter group in Excel 2007/2010).
Thank you very much.
I am satisfied.Teaching system is clear and very easy to understand.
I am happy this caurse
I am very happy, Free cuorse big opportunity.
Yes i am so glad to tell it is the best ever platform where i learn many of the features in ms excel and also sir who given a practical knowledge and the way sir explaining is good one thank you learn vern.
The course is very informative but questions asked in quiz section is totally different from what is taught in the video lectures. Please teach those things also which are asked in quiz.
VRUSHALI AJAYRAO GURAD
Diwakar Singh Chauhan
nice teaching language and easy to understand.
I have completed my excel course and my other 3 courses are in process. This is greate plate form to learn any course the teachers are well trained and qualified. Thank you and love you all from PAK.