Pivot Table is a great feature of Microsoft Excel. It optimized your spread sheet table. I don't know too much about this feature but I can give you idea about this feature and also I can show you an example of this feature.

First of all create table like this.

Date	Item	Amount
01-Jan-2008	Milk	$2
01-Jan-2008	Sugar	$4
01-Jan-2008	Biscuits	$1
02-Jan-2008	Biscuits	$1
02-Jan-2008	Water	$10
02-Jan-2008	Milk	$3
02-Jan-2008	Mangos	$4
03-Jan-2008	Mangos	$5
03-Jan-2008	Books	$40
03-Jan-2008	Cerelac	$2
03-Jan-2008	Pepsi	$1

This table contains very very simple expense details with Date, Item and Amount. Put the cell pointer anywhere in table apply pivot table command from Data menu.

• Excel will ask data types. Keep here your cursor at default options and click on next
• Excel will ask range of data. If you already kept your cell pointer in table anywhere then all table will select automatically.
• Now Excel will ask about new sheet or existing sheet. Select here existing sheet and select any location in your existing sheet where you want to put your pivot table and click on Finish button.
• You can see a Blank pivot table. Select all three columns and feed them into pivot table. Date columns as Row, Item columns as Column and Amount column for sum.

Note: Different versions of Excel has some variations in these steps. Once you will try to make pivot table. You can understand easily.

Here is the result of Pivot Table.