EXCEL2007 – HOW TO CREATE PIVOT TABLE
For describe the pivot table , I have given sample data. Just go through first
|DISTRICT||SALES REP NAME||SALES|
While go through you found there are three columns namely DISTRICT, SALES REP NAME, SALES.
To find out who is making more sale, follow the steps
2. Goto Insert menu, select Insert Pivot table
3. It will show a menu
In table range, it showing as Table1 as we already selected the range. We can change the data selection also.
Choose new worksheet, for convenient . You can use existing worksheet also, but you have to give the cell reference.
4. Then the screen shows
Just drag Sales Rep Name into Row labels and Sales into Values
Now, see the data are sorted and summed in the sheet. It gives data in meaningful way very beautifully.
See, if you want to check in which State having more sales, Then remove sales rep name and insert District into the Row labels.
Even, we can do, Districtwise, Sales rep wise as follows
If you drag the District into column labels, then it shows beautifully
This is very simple to use.
Hope it is useful to you. I will post more in coming days. I suggest you to give comments on this article along with your requirements and suggestions to develop into good article.
Please email at vinodkumar2001 if you free.