What is the process for using pivot table?

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

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.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 5 points N/A #177582

What is the process for using pivot table?

qa-featured

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
  • Posted on -
  • Question Category:

Editing photos for social media?

Previous

Can I make all columns the same?

Next

Related Questions