Pivot Table in excel

Knowledge resource 1018 views 1 replies

How to make a Pivot Table? What is use of it

How can we apply a formula from Pivot Table to excel sheet

Replies (1)

Originally posted by :Rajesh

" How to make a Pivot Table? What is use of it
How can we apply a formula from Pivot Table to excel sheet
"

pivot tables are used to view data in summarized and attractive form.u can make a pivot table of max. 3 fields.. its given in data menu

u have to first select the range

and then change the layout....drag the field name into row....column....n data

take tht field in data whose sum u want then finish

its done


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register