I have recently conducted a one day workshop on MS OFFICE for a German based MNC in Chennai. The example I have used to teach about PIVOT TABLE was rated as "simple and effective" by most of the participants.
I just thought that I could share it to members of CITEHR also.
Please download the zip file which contains an excel file and step by step guide PPT file. (Note: You need MS office 2007 or 2010 to use these files)
If you require any further clarification on this example, please feel free to write to me at
Your suggestions and feedback are welcome.
Thanks & regards,
Raja C S N,
Sr Trainer / Consultant / Content Creator
(Soft Skills Trainer & MS Office Trainer)
Chennai. +91 9 44 555 1653
We need to name worksheets in such way that it should give a hint on its contents. The small is also better. I have used ED-1, ED-2 etc., to indicate Employee Data-1, Employee Data-2 etc., That's all.
Raja C S N