Use slicers with PIVOTBY, GROUPBY & FILTER 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/slicers-w...

★ About this video ★
Microsoft recently announced the GROUPBY and PIVOTBY functions for Excel. Because these new functions provide PivotTable type functionality, many have asked if we can use Slicers with these functions.

The answer is, Yes!

So, in this video, we are looking at how to use slicers with PIVOTBY and FILTER in Excel.

0:00 Introduction
0:23 Data & creating slicers
1:06 PIVOTBY Function
3:35 Connect the slicer
5:56 FILTER Function
7:01 Add new data
7:45 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