How to take column wise report using pivot table

Pivot table helps you to analyse and summarize your data especially when the size of data is very high. The power of pivot table is beyond the scope of this blog.

Step 1:

Select the data table from excel sheet

DATA TABLE IN EXCEL

Step 2 :

Select pivot table

INSERT PIVOT TABLE

Step 3 :

Select the table data you want to manipulate

CHOOSE THE DATA FROM DATA TABLE

Step 4 :

Choose the pivot table details

CHOOSE PIVOT TABLE DETAILS

Step 5 :

Report

PIVOT TABLE REPORT

Similar posts

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization

Thanks +deepajayaprakash payyanakkal  for your support

+Consumerfed IT Division

http://javabelazy.blogspot.in/