Pivot table slicer vs filter (and special features) скачать в хорошем качестве

Pivot table slicer vs filter (and special features)

00:00 Use slicers to dynamically filter pivot tables 00:12 Switch on a slicer 00:23 Choose which slicers you want to switch on 00:40 Slicers DO NOT need to already be in the Pivot Table 01:04 Resize a slicer box 01:15 Slicer clicks are the same as choosing from the Pivot filter 01:42 Multi selection in slicer 01:52 Go back to showing all items in the slicer 02:00 Impact of a slicer whose field is not already in the Pivot Table 02:27 Slicer greyed out for combinations that don't exist in the pivot table 03:00 Custom each slicer individually (size) 03:29 Make the slicer fit better (horizontal vs vertical) 03:50 Change the slicer colors 04:03 Link pivot tables together, change one & all pivots change-    • Change all pivot tables at once based on f...   04:20 Slicer settings (change the name, sort order, hide/ grey out impossible combinations) Using slicers in an Excel Pivot table to make it easier to dynamically perform filters including items that are not an option in the Pivot Table. Provides additional information in that it will grey out the combination of choses that are not possible as you work on them.