N/APosted 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.
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