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.

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

 

Related Questions