Enrolled: 698 students
Duration: 1 day
Level: All Level


Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
HRD Corp Claimable Excel Basic Level 2 Training

HRD Corp Claimable Excel Basic Level 2 Training

The Excel Basic Level 2 training modules provide a systematic approach to learning Microsoft Excel, beginning with the fundamentals and then progressing to more complicated features and capabilities. Participants will gain a solid understanding of Excel’s data manipulation, inspection, and display capabilities.

Who Should to sign up for this Excel Basic Level 2 Training?

  • Office workers, including administrators, data analysts, and managers, who often utilize Excel in their professional roles, can enhance their skills and proficiency with this training program.
  • Small company owners: This program is designed to help you properly manage your firm by providing assistance in handling your own financial data and reports.
  • Workers and business owners: Both individuals and businesses seeking to enhance their employees’ proficiency in Excel may contemplate enrolling in this training. It is a highly prized proficiency in numerous sectors.
  • Attention HRD Corp plan Participants: If you are enrolled in the HRD Corp plan in Malaysia, you have the opportunity to claim the expenses for this Excel training as part of the scheme. This makes it a financially advantageous option for enhancing your skills.

There aren’t any requirements for taking this course.

Overview of the HRD Corp Claimable Excel Basic Level 2 Training

The Excel Basic Level 2 Training is inclusive of participants with diverse levels of Excel ability, ensuring accessibility for individuals seeking to enhance their Excel skills.

HRD Corp Claimable Excel Basic Level 2 Training Outline

Module 1: Complex Formulas and Functions

  • Engaging in the exploration of sophisticated functions such as VLOOKUP and IF.
  • Utilizing nested functions to perform intricate calculations.
  • Text functions are used to manipulate data in the form of text.

Module 2: Ensuring the accuracy and security of data

  • Advanced methods for validating data.
  • Securing worksheets and workbooks using passwords.
  • Collaborating on spreadsheets and monitoring modifications.

Module 3: focuses on data tables and the concept of what-if analysis.

  • Generating data tables for various scenarios.
  • Goal Seek and Solver are powerful tools used to solve intricate issues.
  • Utilizing the Scenario Manager to manage various situations.

Module 4: Advanced Charting Techniques

  • Enhancing charts by utilizing sophisticated formatting choices.
  • Generating composite charts.
  • Implementing trendlines and secondary axes.

Module 5: Overview of Macros and Automation

  • Creating and executing macros.
  • Fundamental principles of VBA (Visual Basic for Applications).
  • Automated tasks for recurring actions.


HRD Corp Course Request

Write down the training course you interested