What is pivot table

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.

Use of pivot table:

A PivotTable is especially designed for:

Querying large amounts of data in many user-friendly.

Moving rows to columns or columns to rows .

Filtering, sorting, grouping, and conditionally formatting the most useful feature.

Pivot table slicer:

Pivot Table Slicers are a visual filter in the form of an interactive button. There are several cool things that you can do with Pivot Table Slicer, like customize them, filter them, connect them to multiple Pivot Tables plus much more!

Design:

To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. ... To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.

How do you use pivot table design?

Change the style of your PivotTable

Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

Click Design, and then click the More button in the PivotTable Styles gallery to see all available styles.

Pick the style you want to use.

If you don't see a style you like, you can create your own.