MGA Training Centre

Enhancing Your MS Excel Skills

Home >Digital Academy> Enhancing Your MS Excel Skills

ENHANCING YOUR MS EXCEL SKILLS

Course Objectives

The MS Excel program is designed to build the capacity of participants to:

  1. Apply Advanced Data Validation and Conditional Formatting Techniques.
  2. Use Advanced Filtering Techniques and Structured Tables Effectively.
  3. Create Dynamic Reports and Dashboards for Decision-Making
Focus Areas

  1. Conditional and Logical Function
  2. Data Validation
  3. Lookup Functions
  4. Data Cleaning and Transformation
  5. Pivot Tables
  6. Creating Interactive Dashboards
Who Should Attend?

This course is designed for :

MTC STRATEGIC HR PLANNING

Course Objectives

The MTC Strategic HR Planning program is designed to develop the capacity of participants to:
        1. Identify skill gaps, succession risks, and workforce constraints.
       2. Develop a practical HR plan.
       3.Translate strategy into an actionable plan.

Focus Areas

Key topics to be covered during the session include:
     a. Stages of an HR Plan Development.
     b. HR-Specific Internal & External Analysis.
     c. Human Resource Action Plan and Strategies.
     d. HR Implementation Planning
     e. Monitoring & Evaluation of HR Plan
     f. Risk Management in HR Planning

Who Should Attend?

This course is designed for :

MTC HR ANALYTICS

Course Objectives

The MTC HR Analytics program is designed to build the capacity of participants to use data to
        1. Anticipate talent needs.
        2. Understand performance and workforce trends.
        3. Make confident staffing decisions that support organizational goals.

Focus Areas

a. Foundations of HR Analytics
b. Key Performance Metrics – Practical Usage
     i. Recruitment and Hiring Metrics
     ii. Attrition and Retention Metrics
     iii. Employee Engagement Metrics
     iv. Employee Experience Metrics
     v. Performance Metrics
     vi. Learning & Development Metrics
    vii. Diversity, Equity and (DEI) Metrics
c. HR Data Collection, Management and Ethics
d. Translating HR Analytics into Actions

Who Should Attend?

This course is designed for :

COMPANIES WE HAVE WORKED WITH