Janaki

On pivot tables try here

http://peltiertech.com/Excel/Pivots/pivotstart.htm

On the functions I think you will need to be more specific

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Janaki Subramanian" wrote in message
...
I need some help in excel for creating a pivot table and
some important functions which we will be using on a
frequent basis