Video: How to quickly create a pivot table 2. Watch the video below for a quick demonstration: The pivot table above shows total sales by product, but you can can easily rearrange fields to show total sales by region, by category, by month, and so on. Drag a numeric field into the Values area (e.g.Drag a 'label' field into the Row Labels area (e.g.In the Create PivotTable dialog box, check the data and click OK.On the Insert tab of the ribbon, click the PivotTable button.Start by selecting any cell in the source data: Compared to the time it would take you to build an equivalent report manually, pivot tables are incredibly fast. If you have well-structured source data, you can create a pivot table in less than a minute. Many people think building a pivot table is complicated and time-consuming, but it's simply not true. You can build a pivot table in about one minute Below are more than 20 tips for getting the most from this flexible and powerful tool. You can create a basic pivot table in about one minute, and begin interactively exploring your data.
They are the single best tool in Excel for analyzing data without formulas. Pivot tables are a reporting engine built into Excel.
