Register now or log in to join your professional community.
Pivot table is option which is used to compare various values, you can see this option in the "inset" tab. the first option is pivot table.
step one, select all those data which is to be compared and then click on pivot table. now you can start comparing various values.
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
It's a lot harder to explain a pivot table than to show you how one works, so let's take a look.
Pivot Table is one of the popular MS excel tool/feature. Pivot Table is used for the analysis of high volume data. It summarize the high volume data into a condensed group or sub group and makes it easy for the data analyst. This function can be somehow done with the sumifs and sumif formula, but Pivot table makes you worry free and it the best one.
For the uses of Pivot Table, you need to have data in excel having enough rows and few columns (for e.g. Inventory data, Inventory Code, Price, Qty, Location, and some other data). Then, you need to go the Insert Tab, click Insert Pivot Table, it then says in a same sheet or new one, select new one as it is more easy for new user and then it allows you to select the range of the table, select the range. Now, go the the pivot table and select report filter, some rows and others as you wish. However, everytime you change the data, you need to refresh the Pivot Table. I personally find it easy to use in Classic display mode which you can change by going it the pivot table options.
Enjoy!!!
