Excel PivotTablesLesson 65Free preview
Excel PivotTable Values
This lesson is part of Excel · All levels
Summary
The Values field contains summarized numbers, and Excel automatically selects aggregates such as Sum or Count according to the data type. You can change it by using Value Field Settings to Average, Max, Min, or Count. If the numerical data contains empty cells, note whether the result is Sum or Count so that the interpretation of the report remains correct.
Key points
- Values contain a summarized numerical field
- Intuitive aggregation: sum for numbers and count for text
- The Value Field Settings change to Average, Max, Min, etc.
- Number format settings are available on the same dialog
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.