Microsoft Excel for HR Professionals

Course Code: ASKHR7

Course Objective – Microsoft Excel for HR Professionals


By the end of the Microsoft Excel for HR Professionals course, you would be equipped with practical skills and techniques of Excel functions to manage HR data efficiently. The training focuses on relevant HR examples so that you can understand and apply them effectively.

Participants will learn and apply the Excel functions to manage staff records such as leaves, OT rates, Working Days, Payrolls and Training records. For the Advanced Excel functions, participants would be able to illustrate Management KPI with PivotTable & Slicer, HR Budgets on events and Compensation & Benefits of the organisation.

This is a course specifically for HR professionals. If you want to learn excel in general, we have the right courses for you.

Our Microsoft Excel 2013 – Basic course will equip you with the necessary skills to succeed in the workplace, regardless of your job title.

 

  • Course Dates and Venue

    Course Duration: 1 day (8 hours), 9:00am – 5:00pm

    CourseVenueOct-17Nov-17Dec-17Jan-18Feb-18Mar-18
    Microsoft Excel for HR ProfessionalsJTC Summit26-13-12-

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
  • Getting Data into Excel

    • Importing External Data
    • Managing Connections
    • Updating Source Data
    • Creating Links

    Highlighting Critical Data

    •  Applying Conditional Formatting
    • Managing Rules

    Essential HR Formulas & Functions

    • Using IF Functions
    • Nesting IF Functions
    • Combining Conditions using AND and OR Functions
    • Lookup Functions (VLOOKUP, HLOOKUP, INDEX and MATCH)
    • Performing Conditional Count, Sum and Average Calculations
    • Calculating Date Difference using DATEDIF
    • Using Common Text Functions

    Ensuring Data Validity, Protection and Collaborating

    • Applying Data Validation
    • Enforcing Worksheet and File Protection
    • Applying Sharing
    • Tracking and Reviewing Changes

    Analyzing Database with PivotTable and PivotChart

    • Creating Multiple Summaries
    • Grouping PivotTable Items
    • Using Slicers to Filter
    • Working with Report Filters
    • Extracting Records
    • Creating PivotChart
  • This course is designed for HR professionals and Microsoft Excel users who needs to perform calculations, summaries and data management in HR environment.

  • Hands on practice helps to ensure we understand and the step-by-step demonstration was easy to follow. The Trainer was patient and clear in delivery. – (26 Oct 2017)

    Trainer Sandra is very knowledgeable of Excel, the pace is perfect; explanation in a simple way and all can be understood, very patient. Very well done! – (22 Aug 2017)

    Using function & pivot table was very useful. – (22 Aug 2017)

Fees and Grants

$299.60 per participant (Inc. GST)

Tap on PIC Scheme or Cash Payout and PIC Bonus for Training of Employees. For more details, refer to IRAS Website.

Absentees will be charged the full course fee.

Registration

Click here to download registration form.

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Apply Online

Microsoft Excel for HR Professionals (ASKHR7)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name

Company Address

Postal Code

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.