Excel Slicers can make your pivot tables, charts & dashboards DYNAMIC. They are one of my absolute favourite features. In this succinct yet practical video, learn all about how to set up & use slicers, like a PRO.

Video topics ⏱
==============

0:00 Introduction
0:29 When to use SLICERS?
1:15 How to insert a slicer?
2:03 Advanced Slicer tips
2:39 Customizing the Slicer look
3:55 More than one slicer on a pivot
4:26 Amazing Dynamic chart with two slicers

Example workbook
====================

A Detailed article + Tips on slicers https://chandoo.org/wp/introductiont...

Sample workbook https://chandoo.org/wp/wpcontent/upl...

Learn more about SLICERS & Pivot Tables
======================================

1⃣ Excel Slicers Complete Guide (article) https://chandoo.org/wp/introductiont...
2⃣ Connect one slicer to two or more pivots    • Easily link Slicers to more than one ...  
3⃣ All about Excel pivots (8 examples in 10 minutes)    • How to use Pivot Tables in Excel  A ...  
4⃣ Advanced Excel Pivot Table Tricks (playlist)    • Easily link Slicers to more than one ...  

Other Excel Basics videos (playlist)    • How to create & use Drop Down lists l...  

Love what I do? Join the classes for more
========================================

If you enjoy my videos, you are going LOVE my online classes for Excel / Power BI. Visit https://chandoo.org/wp/trainingprogr... and pick something that you want to learn.

Have a beautiful day

#ExcelTricks #Slicers