In Microsoft Excel, a pivot table is a tool that allows you to quickly reorganize, rearrange, and summarize data in a variety of ways without changing any of the raw data. The word "pivot" means "a central point or pin," which in this case refers to the raw data (information) entered into the columns and rows of a spreadsheet.

Let's say you have a meeting set up with the executives in your company and you want to quickly show them the sales totals for each month, quarter, or year. A pivot table allows you to do so! So this tool is already a lifesaver so how can it possibly get better? How about adding a little style to make your pivot table pop?


To learn more about pivottables, check out our Mastering Excel Pivottables class.