Excel Video 9 picks up where Excel Video 8 left off. Excel Video 8 showed how label filters can filter Pivot Table data based on the row or column labels in the table. You can also filter based on the values in the data section of the Pivot Table, and these value filters offer a variety of ways to select data. You can select all of the data than equals a given amount (x) , does not equal x, is greater than x, is greater than or equal to x, is less than x, is less than or equal to x, or between x and y. Combining label filters and value filters should make your Pivot Tables even more powerful.
- 12 жыл бұрын
Excel Video 9 Value Filters in Pivot Tables
- Рет қаралды 49,972
Пікірлер: 8