How To Do A Pivot Table In Excel 2007?

Asked By 10 points N/A Posted on -
qa-featured

I am learning excel for a data mining class. I need to create a pivot table which will be using available data. How to do a pivot table in excel 2007?

SHARE
Answered By 55 points N/A #126473

How To Do A Pivot Table In Excel 2007?

qa-featured

First, locate the data on which the table is to be created. Select one of the desired cells. Right click on that cell and from the new opened options, click on insert and then on pivot table. Then, a new box will open marked pivot table. It will look like this: In the first radio button, select it and enter the starting and ending values of the cells using which the table is to be created. Alternatively, the red box at the end can be pressed so that you can drag and select the desired cells.

Choose between the third and fourth radio button to select where the table is to be placed and click ok. 

Related Questions