[Online, NEW] Microsoft Excel Course - Advanced Level
Course Information
  • 18-Dec-2023
  • Online
  • Beatrice V. Xavier
  • English
  • RM 960 RM 880
    Until 12 Dec 2023
  • 9:00am - 5:00pm


This course covers the more advanced features of Microsoft Excel. Participants will learn the advanced features of Excel. They will learn to use data analysis tools like Pivot Tables, Goal Seek and Scenarios. They will also master lookup functions, protect valu- able information and automate tasks by recording and running a simple macro.



Upon completion of this course, participants will be able to understand and learn:

• Master lookup functions, use relevant text functions to clean up data

• Protect valuable information

• Analyze data with Pivot Table

• Tweak charts

• Automate tasks with macro and VBA



Interactive workshop and practical exercises and quizzes using unique, proven learning methods.



Attendees who have good knowledge of Excel, preferably Intermediate level users.

The course can be performed in either Excel 2016 or Office 365 Excel Application. Delegates are required to bring along a laptop with sufficient battery power and/or power charger.



• People who are ambitious and want to grow faster than their peers

• Anyone who wants to use Excel at its best, e.g. HR managers, project managers, revenue managers, finance managers and administrative personnel who are in the basic to intermediate group wishing to improve their competencies

• This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job



Date:    18-19 Dec 2023 (Mon-Tue)

Time:    9.00am - 5.00pm

Mode:    Online/ Interactive

Level:   Advanced


[HRD Corp Claimable]




 - Early Bird Offer (before 30 Nov 2023) – RM800

 - Special Offer (before 12 Dec 2023) – RM880

 - Normal Fee – RM960


Fee includes Course Notes, Certificate of Completion and 6% Service Tax


** OFFER **

- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.


HRDCorp Claimable Course:
Trainer MyCoiD: 429594X
Course Scheme: HRDCorp Claimable Course
Course Type: Remote Online Training (Public)
Course Code: 10001260482





Module 1: Quick Review 

• Essential shortcuts

• Flash Fill 10.30am Morning Tea Break


Module 2: Data Validation

• Data validation settings & options

• Create drop-down list 

• Custom Validation


Module 3 : Lookup Functions

• Vlookup and Hlookup Functions

• Xlookup (Office 365)


Module 4 : Tweak Charts 

• Linking cells to chart

• Conditionally format a series

• Using custom data labels

• Identifying the highest/lowest range 

• Using shapes/images in a series

End of Training



Module 5: Pivot Tables

• Understand PivotTable terms and layouts

• Adding field row, column, values 

• Show Report filter pages

• Explore ‘Summarize Values By’

• Grouping data

• Explore ‘Show Values As’ 

• Insert Slicers, Timeline

• Pivot Chart


Module 6 : What IF analysis 

• Goal Seek

• Scenario Manager


Module 7 : Protecting Data & Structure 

• File Encryption

• Protect Worksheet

• Multiple range/user password 

• Protect Workbook structure


Module 8 : Form Controls & Macros 

• Recording & running a Macro

• Assigning Macros

• Using Form Controls

End of Training



Microsoft Office Expert, HRD Corp Accredited Trainer

Beatrice is one of the pioneer trainers of Microsoft Office training programs. She is a holder of ICL and NCC Diplomas in Computer Studies, as well as a Microsoft Office User Specialist. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad
(PSMB/ HRD Corp).
Over the past 29 years, she has trained countless organizations both within and outside of Malaysia, including in Thailand and Brunei. She has rendered services to MNCs, Governments, SMEs and NGOs.

As a training consultant, she is well experienced in conducting customized, onsite and remote online trainings in both English and Bahasa Malaysia. Her patience, flexibility in tailoring the courses to the needs of the participants have made her training a success and her services much in demand. 



Enquiry: yes@sst2u.com


- General - (03 - 8604 7270)

- Teo (011 - 3178 9203)

- Logesh (012 - 503 0346)

- Siti (012 - 383 8603)

- Han (019 - 323 0507)