Learn how to simplified HR Reports

Learn how to simplified HR Reports, available at $49.99, has an average rating of 4.5, with 29 lectures, based on 432 reviews, and has 3676 subscribers.

You will learn about Create simplified HR reports Create more convenient reports This course is ideal for individuals who are Anyone who wants to learn how to simplify HR reports or Human Resource department It is particularly useful for Anyone who wants to learn how to simplify HR reports or Human Resource department.

Enroll now: Learn how to simplified HR Reports

Summary

Title: Learn how to simplified HR Reports

Price: $49.99

Average Rating: 4.5

Number of Lectures: 29

Number of Published Lectures: 29

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Create simplified HR reports
Create more convenient reports

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Formula Guidelines

Lecture 1: Formula Guidelines

Chapter 2: Eliminate Unwanted Data

Lecture 1: Working With Table

Lecture 2: Working With Filter

Lecture 3: Remove Duplicates

Chapter 3: Extract Relevant Data With LOOKUP Functions

Lecture 1: LookUP Function

Lecture 2: Match Function

Lecture 3: Index Function

Chapter 4: Making Fast Decision With Logical Function

Lecture 1: IF Function

Lecture 2: IF Error

Chapter 5: Ensuring Data Consistency With Function

Lecture 1: Ensuring Data Consistency With Function

Chapter 6: Using Validation To Ensure Database Integrity

Lecture 1: Using Validation To Ensure Database Integrity

Chapter 7: Analyzing Data With Statistical And Math Functions

Lecture 1: Analyzing Data With Statistical And Math Functions

Lecture 2: Average VS AverageA

Lecture 3: Count IF VS Count IFS

Lecture 4: AverageIF VS AverageIFS

Lecture 5: SUMIF VS SUMIFS

Chapter 8: Working With Data Functions

Lecture 1: Date Function Part1 – Date Calculation

Lecture 2: Date Function Part2 – Use Date Function

Lecture 3: Date Function Part3 – Calculate A Period Of Time Between Two Dates

Chapter 9: Exploring Various Possibilities With What IF Analysis

Lecture 1: What Is IF Analysis – Scenarios

Lecture 2: What Is IF Analysis – Data Table

Lecture 3: What Is IF Analysis – Goal Seek

Lecture 4: What Is IF Analysis – Solver

Chapter 10: Merging Data From Multiple Worksheets

Lecture 1: Data Consolidate By Position

Lecture 2: Data Consolidate By Category

Chapter 11: Analyzing Data With Pivot Table

Lecture 1: Analyzing Data With Pivot Table

Chapter 12: Working With Text Files

Lecture 1: Split Names & Dates

Lecture 2: Concatenate, Trim & Substitute

Chapter 13: Useful Tips

Lecture 1: Useful Tips

Instructors

Info Trek
Office Specialist Trainer

Rating Distribution

1 stars: 4 votes
2 stars: 9 votes
3 stars: 57 votes
4 stars: 153 votes
5 stars: 209 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu