# Pivot Table

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

## Content

DsExcel .NET provides users with the ability to display aggregated data in a spreadsheet using pivot tables - a data summarization tool that can perform complex analysis of information stored in cells for exploring, analyzing and manipulating bulk data in a worksheet.
Pivot tables not only help in categorizing data but they also help in computing the totals and average of the values in the cells as per the summary functions defined in the built-in functions list.
For incorporating and using pivot tables in worksheets, you can perform the following tasks:

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