An Excel pivot table is a table that has rows and columns, it allows you to analyse data by aggregating it across each column. It is built from an Excel table or a multi-dimensional Cube for example.