Dear All,

I recently conducted a one-day workshop on MS Office for a German-based MNC in Chennai. The example I used to teach about PIVOT TABLE was rated as "simple and effective" by most of the participants. I thought of sharing it with members of CITEHR as well.

Please download the zip file, which contains an Excel file and a step-by-step guide PowerPoint 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 rajacsn@gmail.com. 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 9445551653

From India, Madras
Attached Files (Download Requires Membership)
File Type: zip PIVOT TABLE SAMPLE.zip (1.56 MB, 2165 views)

Acknowledge(0)
Amend(0)

Hi,

We need to name worksheets in a way that provides a hint about their contents. Keeping it concise is also preferable. I have used ED-1, ED-2, etc., to signify Employee Data-1, Employee Data-2, etc. That's all.

Regards,
Raja C S N


From India, Madras
Acknowledge(0)
Amend(0)

Dear Raj ji. The Excel sheet is PASS WORD PROTECTED please provide Regards, PBS KUMAR
From India, Kakinada
Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.