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.

Essential Microsoft Excel functions to streamline your everyday ... Insert data and create a pivot table (or several!) First, ...