top of page

TSY In House Training #101: Microsoft Office Excel Maximizing Pivot Table

TSY In House Training #101: Microsoft Office Excel Maximizing Pivot Table
Training in progress.

PivotTable is the most popular and useful tool in Microsoft Excel to summarise and analyse large amount of data. As each newer versions of Excel added more features to it, this 2-day course provides students with the additional knowledge and skills to use the features of PivotTable.

Date: 19th & 20th August 2019

Venue: Info Trek Computer Lab, Penang

Course Objectives:

Upon completion of this program, the participants will be able to:

  • Summarise and Analyse raw data

  • Consolidate multiple PivotTable

  • Connect to other External Data Source

  • Add Formula to enhance report

  • Create a Dashboard

  • Create Relationships (Excel 2013 onwards)


Completed Excel Basic Level training or have mastered the following basic skills:

  • Inserting and Deleting Worksheets, Rows, Columns and Cells.

  • Perform AutoFill.

  • Use basic formulas – Addition, Subtraction, Multiplication and Division.

  • Use basic functions – AutoSum.

Course Methodology:

This is a highly interactive training program, whereby participants are to gain the learning points through experiential activities. This program will be conducted through interactive lectures, practical exercises and group assignments.

Who Should Attend:

This course is intended for users of Microsoft Office Excel who want to learn about the features of Microsoft Office Excel PivotTable.

Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to


10 views0 comments


bottom of page