Q:

What is a pivot table in Excel?

A:

Quick Answer

A pivot table is one of the most powerful features of Excel that allows the user to extract significance from a large set of data. It is a summarization tool available in visualization programs, including spreadsheets and business intelligence software.

Continue Reading

Full Answer

A pivot table is capable of automatically sorting, counting and averaging a large amount of data in a single table or spreadsheet and displaying the results of summarized data in another table. A pivot in Excel can be inserted by clicking any single cell inside the data set, clicking PivotTable on the Insert tab, clicking OK to create the pivot table, which appears with a list of fields.

Learn more about Software

Related Questions

Explore