TSY In House Training #888: Microsoft Excel Intermediate to Advanced
- Jul 6
- 1 min read
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