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

preview_player
Показать описание
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.

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! :-)

And links to our other Pivot table videos:
Рекомендации по теме
Комментарии
Автор

Hi Mam, how to freeze the slicer in specific column

vickyrodriguez