Did you know that there are several methods for filtering data in a pivot table? "You can use a slicer to create a high-level filter, then use AutoFilter to dive deeper and instead of adjusting filters to show dates, you can use a PivotTable Timeline". This video highlights the key things you need to know about AutoFilters, Slicers and PivotTable Timeline.

Content
Intro 00:03
AutoFilter 00:40
Multiple filters 03:14
Adjust column width 03:54
Slicers 04:10
Fill empty cells 06:55
Slicer settings 07:20
Connect slicers to multiple pivot tables 09:31
PivotTable Timeline 11:23

Don't forget to like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!

Connect with me on:
Instagram @youexceltutorials
Facebook @youexceltutorials
LinkedIn @bunmisanusi

Link to download the exercise file [ Ссылка ]

Other relevant videos
Excel Tables [ Ссылка ]
Pivot Table - Comprehensive introduction [ Ссылка ]

*Description from Microsoft
#msexcel #youexceltutorials

свернуть