Use slicers with PIVOTBY, GROUPBY & FILTER in Excel | Excel Off The Grid
Автор: Excel Off The Grid
Загружено: 2024-02-29
Просмотров: 35951
Описание:
★ 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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Продвинутый метод Excel, о котором вам никто не рассказывал [Комбинация DROP REDUCE LAMBDA STACK]](https://ricktube.ru/thumbnail/kBhRyXkqefI/mqdefault.jpg)
