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

Показать описание

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

#MsExcel

Excel Off The Grid

Рекомендации по теме

Комментарии

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!!

stevereed

You're the GOAT! Thank you!

Could you maybe do another video about all the different calcations in GROUPBY and PIVOTBY? I love what ARRAYTOTEXT in combination with SUBSTITUTE does. Maybe examples for LAMDA?

Another question: I've noticed that in my version there's an extra option in GROUPBY called field_relationship. Do you know what that one does?

ennykraft

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

ivanbork

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

IvanCortinas_ES

Thank you. Great video, great teacher.

whowhatwhenwhyhow

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

Excelvenky

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

valeriastrafe

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

VenemAcademy

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

mahmoudfawzi

Mark, How to use coupon code in your academy?

Al-Ahdal

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

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

You DON'T Need PivotTables Anymore (Here Is Why)

Excel’s Missing Feature: Slicers for PIVOTBY

Connect Slicers with GROUPBY Function in Excel 365 | Dynamic Modern Excel Dashboards | LAMBDA

5 Problems with PIVOTBY vs Pivot Tables in Excel

A Slicer For The GROUPBY Function

NEW! Discover Excel’s : PivotBy & GroupBy Formulas : Will they take over Pivot tables in 2024?

Excel PivotBy function - use multiple fields in rows and columns | @efficiency365

12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!

WHOA 😲 This Alternative to PIVOT TABLES Can Transform Your Excel Game!

Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates)

Google Sheets Query with Pivot

Excel Dynamic Array Video#4: Pivot table with total row, FILTER, UNIQUE, SORT, SORT & SUMIFS

Google Sheets Pivot Tables - Basic Tutorial

How to Analyze Data using Pivot Table in Excel | MS EXCEL TUTORIAL 2023 | Tutort Academy

Multiple Headings in a Pivot Table - 2010 Excel Pivot Tables

Make pivot tables with the Google Sheets query

Analyze Sales Rep Performance with GPT

MS Excel Toronto - Building Interactive Dashboards in Microsoft 365 Excel - Michael Olafusi

How to Pivot Text Values in Excel - Get Text Into a Pivot Table

Excel Skills for Business: Intermediate I - w6 ǀǀ Final assessment ǀǀ Macquarie University

How To Create Excel Charts With Dynamic Arrays

Excel Skills for Business: Intermediate I // Week 4,5,6 And Final exam Answer, Coursera Quiz Solve

Export Webpage to PDF using Power Automate Bot #PowerAutoamte #Export #PDF #PowerAutomateDesktop