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...