• 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • HRDFApproved & Claimable

Course Objectives

  • a greater understanding of the functionality and potential of Pivot Tables.
  • able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage
  • add to the statistical analysis of your data, deal with, troubleshoot and utilise Pivoted data in many different contexts


Prior use of Pivot Tables or our Excel Advanced course.

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who want to further enhance their knowledge and practical uses of Microsoft Excel.


This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise  

Course Modules

  • Module 1 – Pivot Table Fundamentals
  • Module 2 – Creating Basic Pivot Tables
  • Module 3 – Pivot Table Views
  • Module 4 – Pivot Table Calculations
  • Module 5 – Pivot Charts
  • Module 6 – Working With Data Sources

Contact us for more information


Login with your social account


Don’t have an account with us?

Edit Profile


Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account


By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?