Excel File: [ Ссылка ]
Excel Courses: [ Ссылка ]

Excel Slicers (msft): [ Ссылка ]
Excel Pivot Filter (msft): [ Ссылка ]

2 ways to add Pivot Table Filter Fields (page fields) to row, column, and value fields while still showing in the filter field.

The first method is simple and the second method is complex but highly versatile.

Excel Courses:
- VBA/Macro Course: [ Ссылка ]
- Building Professional Forms: [ Ссылка ]
- Email Course: [ Ссылка ]

Chapters:
0:00 Intro
0:30 Pivot Table Data Setup
1:12 Pivot Table Field - The Issue
1:38 Solution 1 - Easy
4:01 Solution 2 - Complex (But Fun)

TeachExcel.com

#msexcel #howto #tutorial

свернуть