Use SLICERS🔪 in Excel Pivot Tables📊
Use "SLICERS"🔪 in PivotTables📊 in Excel
#excel #exceltutorial #exceltips #exceltraining #excel #exceltips #shorts #short #shortvideo #shortsvideo
If you work a lot with pivot tables, you probably often apply various filters to reports.
To avoid clicking the filter area and checking the boxes next to the data you need, I recommend using slicers.
A slicer is the same as a filter—visual and convenient.
❓ How do I do this?
In the pivot table field list, select the field you want to add a slicer to and right-click it. Select "Add as Slicer" from the context menu.
A slicer will appear on the sheet, listing all the elements of the field by which you can filter the table.