★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
https://exceloffthegrid.com/table-slicers/
★ About this video ★
Having looked at how to use slicers with PIVOTBY and FILTER in the previous video.
Let's take this a step further and discover how we can use Table slicers for more advanced user interactivity:
- How to get slicer selections as a list
- Change filter context
- Create disconnected slicer tables
- Build a reusable LAMBDA function for slicer selections
0:00 Introduction
0:23 Data & creating slicers
1:00 Slicer selection formula
4:47 Changing filter context
6:14 Disconnected table slicers
7:37 fxSlicerSelection function
10:00 Conclusion
Previous slicer video: https://youtu.be/jFU5Cdd7Ys8
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel