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.

How to change the default font in Microsoft Office EXCEL

This article explains, how to set default font in MS Excel. To use your favorite font in MS Excel all the time, set it as the default. Changing the default font in Excel is simple, do following steps to change the default font in excel.

Click on File menu, then select the Options

In Microsoft Excel options click on General tab, then select the font and font size which you want to set as default.

Click OK.

Please visit other related articles

How to use Microsoft Office Excel: How to find duplicates in Excel
How to use Microsoft Office Excel: How to set default font in MS EXCEL?
How to use Microsoft Office Excel: Sorting and filtering in Excel
How to use Microsoft Office Excel: Excel formula guide for beginners

How to identify duplicates in Excel

Using COUNTIF function is the easiest way to find the duplicates in a excel.

Here is the formula to identify the duplicates

=COUNTIF(B:B,B2)>1
Input the above formula in C2, then select C2 and drag to fill the formula down to other cells.

Please visit other related articles

How to use Excel: How to find duplicates in Excel
How to use Excel: How to set default font in MS EXCEL?
How to use Excel: Sorting and filtering in Excel
How to use Excel: Excel formula guide for beginners