N/APosted 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
How to operate pivot tables in Excell 2010
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.