Excel Slicer Custom Sorting Hacks - Masterclass!
⬇️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/c...
Improve the useability of your reports with these tricks to custom sort Excel Slicer buttons, enabling them appear in a specific order that suits your needs.
Sort Slicers for months based on fiscal periods
Sort Slicer buttons based on a custom list
Sort a single Slicer for month & year
Sort Slicer buttons based on another column
🎓RELATED LESSONS:
Power Pivot & DAX Course: https://www.myonlinetraininghub.com/p...
Slicer Formatting Hacks: • Hidden Formatting Tricks for Slicers
LEARN MORE
===========
🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
📰 EXCEL NEWSLETTER - join 340K+ subscribers here: https://www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 The struggle
0:37 Sorting with custom lists
1:35 Sorting slicers for month & year
2:52 Custom sorting text labels
5:14 Custom sorting date slicers in data model
#excel #pivottables #slicers
Watch video Excel Slicer Custom Sorting Hacks - Masterclass! online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 31 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35,307 once and liked it 897 people.