Use slicers with PIVOTBY, GROUPBY & FILTER in Excel | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Get the example file ★
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 ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel

[@stevereed5776]

Thank you Mark, great to see a different use of the PIVOTBY function (rather than the usual videos) and with slicers, this makes it very powerful. Can't wait to get hold of it now!!

[@ExcelOffTheGrid]

The good news is that you can use this technique with FILTER right now. 👍

[@ivanbork4175]

Very interesting, and very well introduced.
I´m looking forward to the update that include this function.

[@ExcelOffTheGrid]

Hopefully it comes soon, but might be a little while yet.

[@IvanCortinas_ES]

Spectacular BYROW-LAMBDA-SUBTOTAL combination. Thanks for sharing Mark. Excellent tool research.

[@ExcelOffTheGrid]

Glad you enjoyed it. I've got more on that function combination coming next week too. 👍

[@valeriastrafe5104]

Cant wait for these formulas to be available in my Excel version

[@Excelvenky]

This is amazing and totally speechless 🤩.. gratitude and thanks

[@ExcelOffTheGrid]

Thank you. I’m glad you liked it 😁

[@whowhatwhenwhyhow9265]

Thank you. Great video, great teacher.

[@ExcelOffTheGrid]

Thank you. I’m glad you liked it.

[@DataVisualisation]

Very elegant and fast solution 👏

[@ExcelOffTheGrid]

Thank you! 😊

[@jerrydellasala7643]

Very nice!

[@ExcelOffTheGrid]

Thank you! Cheers!

[@MichaelBrown-lw9kz]

Wow, this is impressive.

[@ExcelOffTheGrid]

Thanks - I really like this slicer technique, there is a lot of potential with it.

[@VenemAcademy]

Thnx Mark. Is this new function the traditional pivot table killer? Does this also work with datamodels through Power Pivot?

[@ExcelOffTheGrid]

Yes, this is the new function. Personally, I don’t think it will be a PivotTable killer.
It doesn’t work directly with Power Pivot. You would need to spill some CUBE functions, then work with that spill range. So, I’m sure there could be ways, but probably quite flakey & difficult.

[@mahmoudfawzi]

do you have a complete course for VBA? i'd love to attend and even pay for that

[@ExcelOffTheGrid]

Sorry, we don't have a VBA course. It's on the roadmap, but might be a way off yet.

[@kebincui]

🌹🌹

[@ExcelOffTheGrid]

Thanks Kebin 😁