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 - chandoo.org/wp/introduction-to-slicers/

📁 Sample workbook - chandoo.org/wp/wp-content/uploads/2021/11/excel-basics-slicers.xlsx

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

1️⃣ Excel Slicers - Complete Guide (article) 👉 chandoo.org/wp/introduction-to-slicers/
2️⃣ Connect one slicer to two or more pivots - youtu.be/0HU8Hej6ong
3️⃣ All about Excel pivots (8 examples in 10 minutes) - youtu.be/aofsdpjvK7w
4️⃣ Advanced Excel Pivot Table Tricks (playlist) - youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx

🐣🐥🐤 Other Excel Basics videos (playlist) - youtube.com/watch?v=KSQiMdGi3-0&list=PLmejDGrsgFyD6hcPzkJ1AJ8_HJ1t5awax

😍 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 chandoo.org/wp/training-programs/ and pick something that you want to learn.

Have a beautiful day 😀🌞🌼

#ExcelTricks #Slicers

• How to use Excel Slicers like a PRO: Basics + 5 Advanced Tricks ( Download)
• How To Use Slicers in Excel: User Guide for Beginners ( Download)
• Using Excel Slicers to Filter Data ( Download)
• Pros Use This Technique to Avoid PivotTables ( Download)
• Excel Slicers, EVERYTHING You Need to Know - includes workbook with step by step instructions ( Download)
• Slicers in Excel‼️ #excel ( Download)
• How to Use Microsoft Excel Slicers - A Quick Guide ( Download)
• Excel - Use Slicers to Filter Data ( Download)
• Master Excel 2024: Advanced Filter, Sort, and Switch Functions for Data Analysis ( Download)
• Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names ( Download)
• Use slicers with PIVOTBY, GROUPBY & FILTER in Excel | Excel Off The Grid ( Download)
• Quick And Easy Way To Insert Slicers In Excel ( Download)
• How to Use Slicers for Pivot Tables in Excel 2016 ( Download)
• Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX) ( Download)
• Using Slicers in Excel to Filter ( Download)