ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

Example of Pivot Table – Excel

EXAMPLE OF PIVOT TABLE
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.
Views: 8

Comments are closed.

Pin It