What is a Pivot table? A Pivot table is a data analysis tool that people can create in Excel. It is typically used to share information as it can sort, group, reorganize, count, summarize, average, or ...

For instance, if a cell in one worksheet has a sales number, you can display that value in another worksheet by adding a reference to that cell.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.