How to use a Slicer in a Pivot Table in Excel
In this tutorial you will see the steps for adding a slicer to a pivot table in Excel, and then using slicers to filter the data.
You can filter your Pivot Table with Slicers and Timelines and have the applied filters visually displayed.
This video is about filtering excel data with slicers. Slicers provide buttons that you can click to filter your PivotTables, also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
Once you have inserted the slicer, you can filter the data by simply clicking on the item.
At the end you will know how to use slicers in Excel to quickly and easily filter your pivot tables.
If you find this useful, please drop a 👍 on the video and subscribe 🧐
Timestamp:
00:00 Intro
00:26 Adding the slicer
01:33 Use my slicer
01:55 This is how you do it!
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator templa...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel