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 12th April 2012 From India, Madras
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
Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page. Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)