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
Смотрите видео Excel Slicer Custom Sorting Hacks - Masterclass! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MyOnlineTrainingHub 31 Октябрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 35,307 раз и оно понравилось 897 людям.