Accessing the Layout Feature
Layout Feature - Wizard
Adding Fields
Adding the Fields to Your Pivot Table
All
Page Field
Average
Summary Function
Summary Function - Average
Summary Function - Average2
Column
Column Field
Fields
Column Field
Column Field
Column Field Hiding an Item
Data
Data Field
Fields
Data Field
Data Field
Data Source
Data Source
Dragging Fields
Dragging fields from the Pivot Table toolbar
Drop Column Fields Here
Dragging fields from the Pivot Table toolbar
Layout Feature - Wizard 1st Time
Drop Data Items Here
Dragging fields from the Pivot Table toolbar
Layout Feature
Drop Page Fields Here
Dragging fields from the Pivot Table toolbar
Layout Feature - Wizard 1st Time
Drop Row Fields Here
Dragging fields from the Pivot Table toolbar
Layout Feature
Field Label
Fields
Field Type
Fields
Fields
Adding the Fields to Your Pivot Table
Data Field
Dragging fields from the Pivot Table toolbar
Fields
Fields: Adding
Adding the Fields to Your Pivot Table
Fields: Dragging
Dragging fields from the Pivot Table toolbar
Grouping
Grouping
Hiding
Column Field Hiding an Item
Row Field Hiding a Item
Hiding: Column Field Item
Column Field Hiding an Item
Hiding: Row Field Item
Row Field Hiding a Item
Layout Feature
Layout Feature - Wizard
Layout Feature - Toolbar
Using the Layout feature within the Pivot Table Wizard.
Microsoft Excel List
Creating a Pivot Table
New Worksheet
Creating a Pivot Table
Page
Page Field
Page / Row
Fields
Page Field
Page Field
Page Field Dropdown List
Page Field Option
Pivot Table
Adding the Fields to Your Pivot Table
Creating a Pivot Table
Dragging fields from the Pivot Table toolbar
Fields
Layout Feature - Wizard 1st Time
Layout Feature - Wizard 2nd Time
The Pivot Table Toolbar
Using the Layout feature within the Pivot Table Wizard.
What is a Pivot Table
Pivot Table: Creating
Creating a Pivot Table
Layout Feature - Wizard 1st Time
Pivot Table: Wizard
Dragging fields from the Pivot Table toolbar
Using the Layout feature within the Pivot Table Wizard.
Pivot Table Overview
Overview
Pivot Table Template
The Pivot Table Template
Pivot Table toolbar
Adding the Fields to Your Pivot Table
Dragging fields from the Pivot Table toolbar
Layout Feature
The Pivot Table Toolbar
Pivot Table Wizard
Adding the Fields to Your Pivot Table
Creating a Pivot Table
Using the Layout feature within the Pivot Table Wizard.
PivotTable Wizard button
Layout Feature
Row
Row Field
Row Field
Row Field
Row Field: Hiding
Row Field Hiding a Item
Select Data.Pivot Table Report
Creating a Pivot Table
Sorting
Sorting Example - 1
Summary Function
Summary Function
Summary Function - Average
Summary Function - Average2
To Use Pivot Tables
When To Use Pivot Tables
Why Use Pivot Tables
Overview
Why Use Pivot Tables
Wizard
Layout Feature - Wizard
Wizard: Accessing the Layout Feature
Accessing the Layout Feature