Learn How To Simplified Hr Reports Like A Pro

Tags: Microsoft Office

Simplified HR Reports with Excel

Last updated 2022-01-10 | 4.7

- Create simplified HR reports
- Create more convenient reports

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

Course content

13 sections • 29 lectures

Formula Guidelines 1 lectures

Formula Guidelines Preview 23:34

In this video, you'll learn about Formula Guidelines

Eliminate Unwanted Data 3 lectures

Working With Table Preview 05:13

In this video, you'll learn how to work with "Table function in Microsoft Excel"

Working With Filter Preview 08:49

In this video, you'll learn how to work with Filter function in Microsoft Excel

Remove Duplicates Preview 04:26

In this video, you'll learn how to "Remove Duplicates" in Microsoft Excel

Extract Relevant Data With LOOKUP Functions 3 lectures

LookUP Function Preview 06:39

In this video, you'll learn how to use "LookUP Function" in Microsoft Excel

Match Function Preview 10:36

In this video, you'll learn how to use "Match Function" in Microsoft Excel

Index Function Preview 07:12

In this video, you'll learn how to use "Index Function" in Microsoft Excel

Making Fast Decision With Logical Function 2 lectures

IF Function Preview 09:23

In this video, you'll learn how to use "IF Function" in Microsoft Excel

IF Error Preview 05:05

In this video, you'll learn how to use "IF Error Function" in Microsoft Excel

Ensuring Data Consistency With Function 1 lectures

Ensuring Data Consistency With Function Preview 06:11

In this video, you'll learn about "Ensuring Data Consistency With Function"

Using Validation To Ensure Database Integrity 1 lectures

Using Validation To Ensure Database Integrity Preview 12:23

In this video, you'll learn about "Using Validation To Ensure Database Integrity"

Analyzing Data With Statistical And Math Functions 5 lectures

Analyzing Data With Statistical And Math Functions Preview 07:14

In this video, you'll learn about "Analyzing Data With Statistical And Math Functions"

Average VS AverageA Preview 04:49

In this video, you'll learn about "Average VS AverageA"

Count IF VS Count IFS Preview 07:40

In this video, you'll learn about "Count IF VS Count IFS"

AverageIF VS AverageIFS Preview 06:57

In this video, you'll learn about "AverageIF VS AverageIFS"

SUMIF VS SUMIFS Preview 07:18

In this video, you'll learn about "SUMIF VS SUMIFS"

Working With Data Functions 3 lectures

Date Function Part1 - Date Calculation Preview 02:13

In this video, you'll learn about "Date Function Part1 - Date Calculation"

Date Function Part2 - Use Date Function Preview 03:37

In this video, you'll learn about "Date Function Part2 - Use Date Function"

Date Function Part3 - Calculate A Period Of Time Between Two Dates Preview 05:18

In this video, you'll learn about "Date Function Part3 - Calculate A Period Of Time Between Two Dates"

Exploring Various Possibilities With What IF Analysis 4 lectures

What Is IF Analysis - Scenarios Preview 08:44

In this video, you'll learn about "What Is IF Analysis - Scenarios"

What Is IF Analysis - Data Table Preview 08:40

In this video, you'll learn about "What Is IF Analysis - Data Table"

What Is IF Analysis - Goal Seek Preview 03:34

In this video, you'll learn about "What Is IF Analysis - Goal Seek"

What Is IF Analysis - Solver Preview 12:16

In this video, you'll learn about "What Is IF Analysis - Solver"

Merging Data From Multiple Worksheets 2 lectures

Data Consolidate By Position Preview 05:07

In this video, you'll learn about "Data Consolidate By Position"

Data Consolidate By Category Preview 06:05

In this video, you'll learn about "Data Consolidate By Category"

Analyzing Data With Pivot Table 1 lectures

Analyzing Data With Pivot Table Preview 14:53

In this video, you'll learn about "Analyzing Data With Pivot Table"

Working With Text Files 2 lectures

Split Names & Dates Preview 05:49

In this video, you'll learn how to "Split Names & Dates"

Concatenate, Trim & Substitute Preview 08:11

In this video, you'll learn how to "Concatenate, Trim & Substitute"

Useful Tips 1 lectures

Useful Tips Preview 14:23

In this video, you'll learn some of the "Useful Tips" you can use in Microsoft Excel