Posted on May 16, 2018
Excel Lesson: Part 3
Pivot Table:
The purpose of Pivot Table is to create a selective summary report table from a list of raw data.
Rules:
- Must have all data filled in
Insert > Under Table > Pivot Table
To keep the Pivot Table column name the same as the raw data:
Design > Layout tab > Report Layout > Show in Tabular Forms
Replacing empty cells in Pivot table:
Right Click > Pivot Table Option > Layout & Format > For empty cells show:
Changing Formate:
Right click > Number Format
Grouping Data:
Show Value As:
Right click > Summarize Value By > selection options such as average, min and max
Types of Pivot Tables:
- Row and Value
- Across tabulated tablet: Row, Column and Value
- Row, Column (2 pivots) and values