Cool Excel Trick 💡Use Slicer Buttons With a Hidden Pivot Table
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Here is a simple Excel trick on how to use Pivot Table slicers in a formula based report. Basically you get to connect your formulas to slicer buttons. We'll use a hidden Microsoft Excel Pivot Table to get the slicer functionality and connect the pivot table outcome to the Excel formulas.
🌍 My Online Excel Courses ► https://www.xelplus.com/courses/
🎬 LINK to more YouTube Shorts videos: • Shorts (Tips, Tricks & Office Pranks)
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Watch video Cool Excel Trick 💡Use Slicer Buttons With a Hidden Pivot Table online, duration hours minute second in high quality that is uploaded to the channel Leila Gharani 10 September 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 47,639 times and liked it 1.8 thousand visitors.
