★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]

★ Get the example file ★
[ Ссылка ]

★ 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 ★
[ Ссылка ]

★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]

#MsExcel

свернуть