Learn how to simplified HR Reports (Updated)

[mitsumi]

Learn how to simplified HR Reports
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 671 MB
Genre: eLearning Video | Duration: 29 lectures (3 hour, 52 mins) | Language: English

 Simplified HR Reports with Excel

What you'll learn

    Create simplified HR reports
    Create more convenient reports

Requirements

    You should be able to use Microsoft Excel

Description

This program aims to simplify the task of human resource personnel who deal with various types of data, ranging from recruitment, compensation, employee benefit, workforce planning and development programs.

It is particularly useful in HR workloads where the HR practitioner needs to perform calculation for salary adjustments and bonus. They will be exposed to "what if" analysis when it comes to a collective agreement on negotiation for bonus, salary and increment proposals for management.

Impress your management with the right techniques and skills on how to manage HR data efficiently and to perform the right analysis.

Basic Microsoft Windows knowledge is essential with the following pre-requisites:

    Able to switch between task applications
    Able to "Create", "Save", "Open" and "Print" spreadsheet
    Able to use "Undo" or "Redo" function
    Able to print a spreadsheet with headers and footers added
    Able to create simple formulas (additional, subtraction, multiplication and division)
    Able to create simple functions (Sum, Average, Count, Max & Min)

Upon completion of this program, participants will:

    Have a better comprehension on how functions work in Excel
    Be better able to handle text data
    Maximize the benefits of filters
    Be more confident in creating Excel reports
    Know how to use validation to ensure database integrity
    Be able to make fast decision with the use of the logical function
    Learn how to extract relevant data with LOOKUP functions
    Ensure they obtain data consistency with functions
    Analyzing Data with Statistical and Math Functions
    Work with Date Functions
    Know how to explore various possibilities with “What IF analysis"?
    Merging Data from Multiple Worksheets
    Know how to analyzing data with pivot table
    Identify the differences between custom formatting vs. conditional formatting
    Gain confidence and learn valuable tips

Who this course is for:

    Anyone who wants to learn how to simplify HR reports
    Human Resource department

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction