How to use Pivot Table in Excel?

Hello Team,

To use a Table for your pivot table:

1.    Select any cell in the data use the keyboard shortcut Ctrl-T to create a Table.

2.    Click the Summarize with PivotTable button (TableTools > Design)

3.    Build your pivot table normally.

4.    Profit: data you add to your Table will automatically appear in your Pivot table on refresh.

Regards,

Saiyid

Here is a link to follow step by steps.

http://www.excel-easy.com/data-analysis/pivot-tables.html