Tutorial Pivot Table Excel. In this tutorial you will learn these pivottable features in detail along with examples. You have two options.
Use a pivottable to construct a cross tabulation for marital status and housing type for the data provided. After clicking that pivot table button you ll be met with a popup that asks where you d like to place your pivot table. 2 dimensional pivot tables activate the sales datasheet click on insert tab click on pivot chart table button select all the data.
Pivot tables insert a pivot table.
Here is the sample file. You have two options. The pivottable fields pane appears. To insert a pivot table execute the following steps.