Uploaded September 2023 | Updated September 2026, 9 hours ago
🔥 Unlock the power of Pivot Tables—transform your data into insights today! 👉 link.xelplus.com/yt-g-hidden-pivottable
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.
🌍 Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/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
🔥 Unlock the power of Pivot Tables—transform your data into insights today! 👉 link.xelplus.com/yt-g-hidden-pivottable
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.
🌍 Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/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
