How To apply pivot Tables in order to pull out the Informative Entries from the Series of values


2 Answer(s)


Pivot tables, I believe are beyond the scope of this Excel course as are macros and VBA. Generally, pivot tables are used in data analysis and management reporting of matrices of tabular data.

A pivot table is an interactive worksheet table that provides a powerful tool for summarizing large amounts of tabular data.

STEPS TO CREATE A PIVOT TABLE
1) Highlight the cell where you'd like to see the pivot table.

2) Then, on the Insert tab, in the Tables group, click PivotTable button and click PivotTable from the popup menu. The Create PivotTable dialog box opens.

3) Select the range of data for the pivot table.

4) You can choose where you want the PivotTable report to be placed: New worksheet or Existing worksheet.

5) Click on the OK button.