top of page

TSY In House Training #372: Microsoft Office Excel Intermediate

TSY In House Training #372: Microsoft Office Excel Intermediate
Training in progress.

Date: 25th January & 1st February 2023

Venue: Lumileds Malaysia Sdn. Bhd., Bayan Lepas, Penang

Course Objectives:

Upon completion of this program, participants should be able to:

  • Create formulas and functions, like:

- COUNTIF Function

- AVERAGEIF Function

- SUMIF Function

  • Manage Table with using Auto Filters

  • Visualizing Data with Chart

  • Understanding tables, performing filter and sort and extracting information from data for analysis

  • Able to use simplified features and functions in Excel for data analysis


Basic knowledge of Windows is essential with the follow pre-requisites:

  • Have attended Microsoft Excel – Foundation Level, OR

  • Able to switch between task applications

  • Able to create a spreadsheet with simple formatting

  • Able to create a basic chart

  • Able to print a spreadsheet with headers and footers added

  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division

  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

Course 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.

Who Should Attend:

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

More Pictures:

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


5 views0 comments


bottom of page