Microsoft Excel 2010/ 2013 for Human Resource (Foundation)

Course details

This 1 day instructor led course will empower participants with the knowledge and skills which is important to many data analysis projects using human resources data. It is organized into technical chapters that focus on getting the data in Excel, preparing data for critical reporting, protecting sensitive data and automating repetitive data.. Participants will learn formatting techniques to convert data from different souces, and how to make the best use of most important formulas for HR.

COURSE OUTLINE

• Module 1. Getting your data into Excel
• Module 2. Highlight Your Critical Data
• Module 3. Adding Names for frequently used data
• Module 4. Essential Formula for HR
• Module 5. Using Combination Charts to Present your Result
• Module 6. Ensuring Data Validity
• Module 7. Automating Repetitive task
• Module 8. Add Interactivity to Your Worksheets

LEARNING OBJECTIVE

• Transform raw data into information
• Enhanced visibility to specific data
• Create combination of column and line chart
• Automate common, repetitive tasks through Macro

TARGET AUDIENCE

• HR Manager/ Executives
• Training and Development

PRE-REQUISITE

Before attending this course, participants must:

• Attend the Microsoft Excel Basic & Intermediate course or equivalent course (Microsoft Excel - ICDL Core or MOS Core) OR
• Successfully passed the Microsoft Excel Basic & Intermediate Assessment by COMAT OR
• Have Microsoft Excel Basic & Intermediate level of knowledge as verified by HOD or HR representative