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 & FILTER...
★ 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