TSY In House Training #888: Microsoft Excel Intermediate to Advanced
This course is designed for those with basic knowledge of Excel who wish to progress to the most complicated functions and features in Microsoft Excel.
Date: 3rd & 4th July 2026
Client: NationGate Solution (M) Sdn. Bhd., Prai, Penang
Course Objectives:
By the end of the course, participant will be able to:
use the IF and VLOOKUP/HLOOKUP functions.
apply conditional formatting.
use Sparklines to show data trend.
create commonly used analysis charts.
create a PivotTable and PivotChart.
record macro
Pre-requisites:
Participant must have attended DATA ANALYSIS WITH MICROSOFT EXCEL (Basic) or have the basic knowledge of Microsoft Excel:
Managing Excel Workbooks (create, save, open)
Understanding the Worksheet / Column / Row / Cell
Applying Number Format (Number, Date, Time, Text)
Using Auto Fill for Number and Date & Time Format Data
Using AutoSum Functions (SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, PRODUCT)
Who Should Attend:
Participant who wants to create a report and perform calculation by using the Excel functions and features.
Training Methodology:
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.
More Training Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments