Example of Pivot Table – Excel

1. Select any cell in the data dump > Select Insert > Select Table

Then, create a PivotTable from that table:

2. In the Insert tab, select Recommended PivotTables

Choose from one of Excel’s Recommended PivotTables. In this example, we have chosen to summarize Sum of Sales (in thousands)

by Region, Month and Product.

If you change your data dump, choose Analyze and then Refresh All, to refresh data in pivot table.

#softexperia #excel_tips_softexperia #pivot_tables_softexperia