Excel Pivot Table Slicers: Learn how to add pivot table slicer to filter data in excel

Опубликовано: 06 Ноябрь 2024
на канале: Bitesize Excel
367
8

Introducing slicers in excel pivot tables. Have you seen a pivot table with slicers and want to know how to add these and format slicers. In this video we introduce Microsoft Excel slicers and how to use these visual filters with Pivot Tables to view your data in a new way. It also covers excel slicer formatting. A great beginners tutorial to watch alongside our other Pivot Table tutorials.

You can also download the file from our Google Drive: https://docs.google.com/spreadsheets/...

0:00 Introduction
0:40 Insert your Pivot Table
1:28 Inserting a slicer
1:56 Formatting and aligning your slicers
2:42 Filter Pivot Table and hide items with no data
3:17 Using a slicer to filter

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero! Check out our extensive selection of beginners Excel videos

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our Pivot Table playlist:    • Playlist  

And links to our other Pivot table videos:
Guide to Pivot Tables (with follow along file available):    • Beginners guide to Pivot Tables: lear...  
Introduction to Pivot Tables:    • Learn Pivot Tables in 7 Minutes | Int...  
Issues with PIVOT TABLES - fixing common errors:    • Issues with PIVOT TABLES - fixing com...  
Pivot Charts:    • Introduction to PIVOT CHARTS. Learn t...