Ms Excel Pps Download - Xls

Hello Guys,
Can someone please help me with a tutorial for Pivot tables, their formulae, V and H Look up in MS Excel sheet.
Warm Regards,
Balajee S

=VLOOKUP(A3,Sheet1!A:B,2,0)
A3 cell:- for getting the value from cell value in other sheet1
Sheet1!A:B:- selected Sheet1 and its column A to B
If A3 found in Sheet1 it will pick up the same row cell 2nd
Sheet 1
Name Value
b 1
d 2
c 3
a 4
Sheet 2
In this we picked the value from sheet 1
Name Value
c 3
d 2
a 4
b 1

pl find attached xls w
I called data in sheet2 from sheet 1, the unique key between is name

Find attached Excel tips. These will help you in understanding ....