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.

Prerequisites
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