top of page

TSY In House Training #157: MICROSOFT EXCEL 2016: Pivot Table and Vlookup

TSY In House Training #157: MICROSOFT EXCEL 2016: Pivot Table and Vlookup
Training started.

PivotTable & the VLOOKUP Function is the most popular and powerful feature in Microsoft Excel. PivotTable summarises and analyses large amount of data; while VLOOKUP helps you to search and retrieve relevant information for your reporting.

Date: 9th September 2020

Venue: Jinko Solar Technology Sdn. Bhd., Prai, Penang

Course Objectives:

After completing this course, students will be able to:

  • Summarise and Analyse raw data

  • Add Formulas to enhance the PivotTable report

  • Use VLOOKUP Function in different ways


Completed Excel Advanced Level 3 (Advanced) training or have mastered the following skills:

  • Performing AutoFill.

  • Creating and Formatting a Table.

  • Performing common Formulas & Functions:

  • Addition, Subtraction, Multiplication and Division.


  • Referencing Relative and Absolute data.

Who Should Attend:

This course is suitable for users who are required to crunch and analyse large amount of data.

Training Methodology:

This program will be conducted through interactive lectures, practical exercises and group assignments. Case studies on real-world scenarios are included to demonstrate the practicability of the lessons.

Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to


5 views0 comments


bottom of page