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.

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

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 ...