Table slicers for advanced interactivity in Excel | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
https://exceloffthegrid.com/table-sli...

★ 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:    • Use slicers with PIVOTBY, GROUPBY & F...  

★ 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:   / exceloffthegrid  

#MsExcel