Using slicers with formulas (2022 update) | Excel Off The Grid

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


★ Check out the blog post ★
https://exceloffthegrid.com/using-sli...


★ About this video ★
Slicers are an excellent tool for adding interactivity. When a user clicks on a slicer button, the results change to include only those selected items. Slicers are compatible with PivotTables, PivotCharts, Cube formulas, and Tables…but not standard formulas. So, let’s see how we can use a Table in a new way to get around this limitation.

0:00 Introduction
0:37 Creating the slicer
1:53 Count visible rows with SUBTOTAL
3:52 Connecting the Slicer to the formula
6:06 Using a LAMBDA function
9:16 Conclusion

★ 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 #PowerQuery