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.

Excel’s PivotTables (Microsoft runs the words together, although you?ll find pivot tables in other spreadsheet programs) can provide those types of answers. Do you want to group data by category?