Скачать или смотреть How to use Slicers in Excel to filter multiple PivotTables and charts - Tutorial & Walkthrough

PivotTables continue to be one of the most important features in Excel, and in this episode I walk through how to use Slicers, one of the best features for filtering your data in PivotTables. Slicers allow you to filter your PivotTables easily. They also can filter multiple PivotTables and PivotCharts at the same time. This makes Slicers really useful for creating an interactive dashboard in Excel for your teammates and colleagues to use. Skip to different sections in this tutorial:

Intro - 0:00
Create a PivotTable - 0:25
Format PivotTable - 2:55
Insert PivotTable Slicer - 5:40
Format Slicer to have multiple columns - 8:37
Copy/paste to make Slicer filter multiple PivotTables - 10:50
Disconnect PIvotTables from a Slicer - 14:02
Renaming PivotTables - 14:20
Take Advanced PivotTables class on Skillshare (see link below) - 15:50

👉 Advanced PivotTables class for creating a cohesive dashboard: https://skl.sh/3zIuXzx
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 TikTok:   / dear.analyst  
👉 Instagram:   / dear.analyst  
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...