Dear All,
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

From India, Madras

Attached Files (Download Requires Membership)
File Type: zip PIVOT TABLE (1.56 MB, 2127 views)

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

From India, Madras
Dear Raj ji. The Excel sheet is PASS WORD PROTECTED please provide Regards, PBS KUMAR
From India, Kakinada

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server