Pivot table: -Pivot table make it easy to arrange and summarize complicated data and drill down the details.

Process: -

ü Select your data range

ü Click on insert tab

ü Click on pivot table

ü Define the condition as you need

Chart: -Chart is graphical representation of sheet data. Excel can build a chart automatically based on existing data. There are available many types of charts like column, bar, pie, line etc.

Column chart: -This chart is used to show the comparison between various data series. The data items of data series is represented on chart through vertical strip.

ROLL	NAME	PHY	CHE	MATH	TOTAL
1	RAJ	78	87	67	232
2	SOHAN	45	87	78	210
3	JILANI	67	98	98	263
4	AMIT	89	76	45	210
5	IRSHAD	67	56	67	190

Process: -

ü Select your data range

ü Click on inset tab

ü Click on chart

ü Select any chart style

Bar chart: -This chart is used to show the comparison between various data series. The data items of data series is represented on chart through horizontal strip.

ROLL	NAME	PHY	CHE	MATH	TOTAL
1	RAJ	78	87	67	232
2	SOHAN	45	87	78	210
3	JILANI	67	98	98	263
4	AMIT	89	76	45	210
5	IRSHAD	67	56	67	190

Pie Chart: -This chart is used to show the percentage of sum data series. The data items of data series are represented by percentage wise.

COUNTRY NAME	POPULATION
INDIA	20%
PAKISTAN	10%
JAPAN	20%
CHINA	40%
NEPAL	10%

Line chart: -This chart is used to show the data series through the line whose value change time to time.

OVER	10	20	30	40	50
INDIA	70	140	210	300	360
PAKISTAN	70	140	220	270	320