MS Excel Tutorial About PivotTable

PivotTable In MS Excel

The Excel Pivot table  is called summarize table which is created form an other complicated table. A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.

in this tutorials we explain that how a pivot table is created ? and how we summarize, analyze, explore and present your data.

For example we have a data about the student monthly test information of the three subject like English, Math and computer. This table contain the three month data of five student. as given below:

Oh look this data which is difficult to read and difficult To get the information about single student. Such as if we want to see the detail of student Irfan then it is not possible.

We do this very easily with pivot table as shown in below:

This table is obtain form first table which show the Record summary of student Irfan .

Hope you understand very clearly with this example . Now we explain the process of creating pivot Table.

Process of Creating Pivot table In Excel 2007

This is assume you have a table with record as shown in first picture. Select the very first cell of the table in our case B2.

Now click on Pivot Table in Insert menu form Table group and in appearing dialog box selected range is show in Table Range.

Select The New Worksheet Option or existing worksheet . In our case New Work Sheet is selected.

Click On ok button.

Now a panel on the left side of the worksheet is appear as shown in the image below:

Now drag the every field in specific aria

 for example in report filter insert the field

which you want to search. In our case Name

is inserted in Report filter so we can display

 the record of each student by selecting the name.

Marks placed in the Value aria box for

calculating the SUM of Marks.

 Now in the Column area, we'll put Month, and in the Row area we'll put Marks.

As you drag all the field on by one your pivot table is created in the worksheet.

After this step close the left panel (pivot table list Fields panel ).

Final Snapshot is as follow:

PMT() Financial Functions

Calculate the Sum of a Range Using AutoSum function

User Define Function (UDF) In Excel

Macros In Excel

Relative and Absolute Cell Reference in MS Excel

Page Setting and printing In MS Excel

Fill In Excel

How we use The Functions in MS Excel

How we Write Excel Formulas

Components of Excel 2007 Environment

Rounding The Numbers MS Excel

SUMIF FUNCTION In MS EXCEL

COUNTIF Function In MS Excel

COUNTBLANK Function In MS Excel

VLOOKUP Function In MS Excel

Pivot Table In MS Excel

Consolidation In MS Excel

Remove Duplicate Value In MS Excel

Convert Excel Data in to a Table