Excel Pivot Table Guide
One of the most commonly used tools in Excel
Pivot tables are an extremely useful function in Microsoft Excel used for displaying, filtering and sorting large amounts of data. The reason they are so useful is they can be configured to show any combination of data you want, and they can be formatted in the same way as any other table. The shortcut for a pivot table is Alt + D + P.