# Pivot Table

You can easily display aggregated data in a spreadsheet with DsExcel using pivot tables.

## Content





DsExcel Java allows users to display aggregated data in a spreadsheet using pivot tables.

A pivot table is a data summarization tool that can perform complex information analytics for the data stored in cells. This facilitates users to explore, analyze and manipulate bulk data in a worksheet.

Inserting pivot tables not only helps in categorizing data in a worksheet but also helps in computing the totals and average of the values in the cells based on the summary functions defined in the built-in functions list.

In order to work with pivot tables in spreadsheets, refer to the the following tasks:

*   [Create Pivot Table](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/CreatePivotTable)
*   [Pivot Table Settings](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/PivotTableSettings)
*   [Pivot Table Style](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/ApplyStyleToPivotTable)
*   [Pivot Table Filter](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/PivotTableFilter)