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.

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.