PIVOT TABLE FUNCTION IN EXCEL

What is a pivot table?

A pivot table is a summary of your data, packaged in a chart that lets you report on and discover patterns based on your information. Pivot tables are particularly beneficial if you have lengthy rows or columns that hold worths you need to track the amounts of and conveniently contrast to one another.

To put it simply, pivot tables remove significance from that apparently limitless assortment of numbers on your display. As well as extra specifically, it allows you group your data in different ways so you can draw valuable verdicts more easily.

The “pivot” part of a pivot table originates from the truth that you can revolve (or pivot) the data in the table to watch it from a various point of view. To be clear, you’re not adding to, subtracting from, or otherwise altering your data when you make a pivot. Instead, you’re simply reorganizing the information so you can reveal useful info from it.

Select the range of cell that you want to create a pivot table.

Go to Insert, select Pivot table.

Create a Pivot table based on range.

Click on OK button

Pivot table has been created and looks like this,

There are major four field..

Columns – The headings at the top of the Worth’s area makes the Columns field.

Rows – The headings at the left of the Worth’s areas makes the Rows field.

Values – The Values field is what holds the calculations.

Q.1 How much unit cost of Pencil?

Drag Item in Rows field and Unit Cost in Value field

Q.2 What is the total sales of all region?

Drag Region in Rows and Total in Value field