Microsoft Excel - Function Slicers (slice ANYTHING)
Автор: BCTI
Загружено: 2024-12-12
Просмотров: 3889
Learn a great workaround for Excel Slicers' limitations and extend their operational use beyond Pivot Tables and Data Tables. Now, you can slice ANYTHING with any standard Excel function.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:17 History of Slicer Use
00:54 Overview of Features Used
01:29 Review of the GROUPBY Function
03:16 File Download Instructions
Project 1: Single Filter
03:28 GROUPBY - No Filters
06:19 Setting Up the Slicer Controls
06:41 Creating a Product Pivot Table
08:46 Understanding the COUNTIF Logic
10:31 Creating Custom Headings
Project2: Multiple Filters (AND)
12:05 Compound Filters Using AND Logic
15:20 Adding the 2nd Slicer Filter (AND Logic)
Project3: Multiple Filters (OR)
16:21 Adding the 2nd Slicer Filter (OR Logic)
Project4: Filtering Dynamic Array Functions
17:52 Filtering other Functions (FILTER Function)
18:47 Custom Sort Logic
Project5: Filtering Traditional Functions
20:16 Filtering Dashboard Functions
24:59 Calculate Filtered Average
25:25 Calculate Filtered MAX
25:36 Calculate Filtered MIN
26:00 Conclusions
26:24 Thinking about the Big Picture
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
