Here is a crazy simple but effective Excel dashboard trick. Two level slicers!
Imagine you have a dashboard with a slicer. But the slicer has 300 options on it. We can all agree that it will be impossible to slice such a thing. But do you know that we can easily introduce a second slicer (on something like Product Category) to filter down the products first? Watch this video to learn the trick.
PS: There is a bonus trick in the video too. Watch until the end for it.
⏱ IN THE VIDEO:
===============
0:00 - The Two-Level Slicer - Quick Demo
0:37 - How to create two-level slicers?
4:06 - What if you do not have categories? (Bonus trick🤩)
📂 DOWNLOAD THE SAMPLE FILE:
=============================
Download the sample file to practice this concept: chandoo.org/wp/wp-content/upl...
👨💻MORE ON PIVOT TABLES & DASHBOARDS:
=====================================
Learn more about Pivot Tables & Dashboards using these videos:
Beginner to PRO - How to use Excel Slicers - • How to use Excel Slice...
Beginner to PRO - How to create Pivot Tables - • How to use Pivot Table...
Easy Dashboard Trick - Connect Two Charts to Same Slicer: • Link up two charts to ...
Using Hyperlinks to Make Multi-page Dashboard - • Make an AWESOME Multi-...
Make a Top 5 Dynamic Chart with this CRAZY Trick - • Create a Top 5 Dynamic...
[Advanced] Fully interactive and AWESOME Excel Dashboard - • How to create a fully ...
[Advanced] Make an AMAZING HR Dashboard with Excel - • Make an Amazing HR Das...
👨💻 END TO END ADVANCED EXCEL - COURSE
======================================
Want to learn end-to-end Excel for data analysis & reporting work? I run one of the best courses for this. Check out my Excel School program and sign up if interested - chandoo.org/wp/excel-school-p...
~
#dashboard #excel
~
What does a data analyst use to cut vegetables?
A slicer of course 🤣
6 авг 2024