How to operate pivot tables in Excell 2010

Asked By Pam Gouin 10 points N/A Posted on - 02/06/2015

I have a large set of data and I heard about pivot tables, however I have no idea how to achieve this. How can I summarize my data sheet into tables and charts? I have over 1000 entries of data that needs to be analyzed for my research and needs to be done quick

• Status: Open
• Question Views: 631
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Hamthler itali 0 points N/A #162863

How to operate pivot tables in Excell 2010

HELLO

 

Pivot table is the very useful and powerful features of the excel. Pivot table is used for extract the large and data set. Now i will explain that how to insert the pivot table. There are following steps

you need to click on the single cell of the data set then click on the pivot table. Then you need to click on the ok button.

Now you can drag whatever field you want to insert into your pivot table.

Such as product, Quantity and rate.

 

.

In the pivot table you can sort your data set and also you can filter your required data in your pivot table.

About Hamthler itali

Questions
0

Answers
100

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/17/2015
• Question Category: MS Excel