These are the following steps of Pivot Table in MS Excel given below:
1) Highlight your data
2) On Insert Ribbon, select Pivot Table
3) Choose to place your pivot table either on an existing worksheet or a new worksheet
4) Select which fields you would like to use as your columns, rows, values etc. (here I click and dragged each field into a quadrant of the pivot table menu)
5) To group by quarter instead of by month per our example, right click on any of the month column labels and select Group and Select how you would like to group your data and click OK
6) Sort your data for easy analysis
0 Comments