How to Create Pivot table excel | Step by Step excel pivot table tutorial

 

How to create pivot table in excel | Step by Step pivot table tutorial

Pivot  tables are one of the most remarkable and valuable highlights in Excel. With very little effort, you can utilize a pivot table to construct gorgeous reports for huge informational indexes. A PivotTable is an incredible tool to calculate, summarize, and analyze. This article is an introduction to Pivot Tables and their advantages, and a step by step excel pivot table tutorial. 

Date	Product	Sales
02/10/2020	Washing Machine	1773844.97
02/10/2020	Microwave Oven	1265.6
02/10/2020	Television	808208.9
02/10/2020	Mobile	961986.66
02/10/2020	Refrigerator	2383.81
09/11/2020	Washing Machine	1454183.58
09/11/2020	Microwave Oven	53415.14
09/11/2020	Television	450141.67
09/11/2020	Mobile	916872.61
09/11/2020	Refrigerator	33754.16

Using the above sample data we will discuss the step by step tutorial of Pivot table in Excel.

Select the data which you want to make pivot report like above.

After selecting the data in excel for pivot table report, 

• Click on the "Insert" menu, this will display sub menu under the "Insert" menu. 
• Click the "Pivot Table"  icon, this display the two options Pivot Table and Pivot Chart.
• Click on "Pivot Table" option, here we explaining the step by step by method of Pivot Table, so select the "Pivot Table" in the excel.
• After selecting the Pivot Table option you can see the pop window like below.

• Selected data table range will be displayed like above, if we want to change the data range, from here also we can change data range for the pivot table.
• Next  you can choose the option for where you want the Pivot Table report to be placed. select the "New Worksheet", this will display the Pivot Table in new worksheet.
• Then click OK to  display the pivot table report.

• After clicking the OK, we need configure the data which we want to display in the Pivot table. We can select the fields to add in the pivot table. Select the fields which you want to displayed in the pivot table report.
• Based on the fields which we selected that will be available for the report filter, column labels, row labels and values.
• Here we selected Date as column labels, Product as row labels and values as sales amount. Based on this configuration the pivot table in excel will be displayed like below.