What is the process for using pivot table?

Asked By Jeanne L Jackson 20 points N/A Posted on - 04/20/2015

I need to use a pivot table in Excel but I'm not sure how to use it? I know how to sort in Excel, but I've never used a pivot table before, and I'd really like just some general steps. Say for example I have 5 columns and each column has 5 subsets. Any help on doing this? Thanks.

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

• Answer Accepted: No
• Question Category: Others

Answered By Dave Crinit 5 points N/A #177582

What is the process for using pivot table?

Actually, using Pivot tables in Excel is very easy,

• Insert >> Table >> Pivot table

• To create Pivot tables after entering the data,
  • Go to Data menu >> Pivot table >> ok
• In order to summarize the data at the point of creating the pivot table,
  • Click on a cell >> insert >> pivot table >> select the preferred cell range or the fields and set the summarizing options if necessary >> ok

 

About Dave Crinit

Questions
0

Answers
211

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/20/2015
• Question Category: Others