To create a PivotTable in Microsoft Excel, follow the steps below: Pivot tables should be your first resort when you need to quickly summarize large amounts of numeric data in a worksheet.

Drop-down lists are essential if you need to sort your data or create a pivot table. For example, Excel sees "Texas" and "Tezas" as two different states, and therefore two different values ...