How To Do A Pivot Table In Excel 2007?

Asked By G.Adam 10 points N/A Posted on - 09/08/2016

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?

• Status: Open
• Question Views: 374
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Qamar Khan 55 points N/A #126473

How To Do A Pivot Table In Excel 2007?

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. 

About Qamar Khan

Questions
5

Answers
27

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/08/2016
• Question Category: MS Excel