top of page

TSY In House Training #607: MICROSOFT EXCEL 2016: Advanced Level

TSY In House Training #604: MICROSOFT EXCEL 2016: Advanced Level
Training ongoing.

Managing data systematically and logically is very important to produce a proper report. The latest Microsoft Excel offers more features and enhancements to better manage your spreadsheet. In this Level, we will see how the basic knowledge of Excel will be used to support advanced results. We will explore the different techniques to summarise, link, consolidate and lookup data.

Date: 21th June 2024

Client: NationGate Solution (M) Sdn. Bhd., Prai, Penang

Course Objectives:

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

  • Group and summarise data using Outline.

  • Group and summarise data using PivotTable.

  • Use the What-If Analysis tools to facilitate decision making.

  • Use various Lookup & Reference functions for reporting.


Completed Excel Intermediate Level training or have mastered the following skills:

  • Perform various cell locking methods.

  • Use various Statistical functions for reporting.

  • Use various Logical functions for reporting.

  • Apply data filters.

  • Apply data standardization.

Who Should Attend:

This course is suitable for Administrative staff such as Human Resource, Sales and Marketing, Technical staff such as Engineers, IT and Analysts as well as Managers of all levels.

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.

More Training Pictures:

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


3 views0 comments


bottom of page