How to add pivot Table in Excel

Pivot table give some clear view for the data structure

Select the range

Go to insert tab

Give with the pivot table

You can select the areas which you need to project