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 [Email Removed For Privacy Reasons]. Your suggestions and feedback are welcome.
Thanks & regards,
Raja C S N
From India, Madras
Acknowledge(1)
Amend(0)
39Please 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 [Email Removed For Privacy Reasons]. Your suggestions and feedback are welcome.
Thanks & regards,
Raja C S N
From India, Madras
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Pivot Table Secrets.pdf
PIVOT TABLE SAMPLE.zip
New Microsoft Office Excel Worksheet (3).xls