• Search...

categories: Business & Professional Skills

Data
MS Excel
Productivity
SDG 4: Quality Education
SDG 8: Decent Work and Economic Growth
SDG 9: Industry, Innovation and Infrastructure

Excel for HR

Duration: 4 h 18 m / 21 lessons

Level: Specialized

Course Language: Arabic

By the end of this course, you will be able to

  • Use advanced statistical and mathematical functions, conditional formatting, pivot tables, and advanced graphs, to help you analyze data and make strategic decisions.

  • Design an integrated data dashboard that contains a set of data related to human resources.

  • Create a customized program that meets your needs in the field of human resources management, and can be constantly developed and expanded.

Course details

  • 4 h 18 m/21 lessons
  • Last updated: 26/11/2023
  • 14 learning resources
  • Course completion certificate

Course Content

Free lessons

1.

Creating tables in Excel - Format as table

14 Minutes
learning resources
2.

Text Functions

12 Minutes
learning resources
3.

Special pasting & Importing

6 Minutes
learning resources
1.

Creating tables in Excel - Format as table

14 Minutes
learning resources
2.

Text Functions

12 Minutes
learning resources
3.

Special pasting & Importing

6 Minutes
learning resources
4.

Date Functions

10 Minutes
learning resources
5.

Formatting Dates

6 Minutes
learning resources
6.

Conditional formatting in search and organization process

15 Minutes
learning resources
7.

Polarizing: creating application forms for work

10 Minutes
learning resources
8.

Automatic numbering , Validation & Custom number format

17 Minutes
learning resources
9.

Contracts System Configuration

9 Minutes
learning resources
1.

New Vlookup Function Features

14 Minutes
learning resources
2.

Linking data between sheets - SUMIFS + IFERROR function

11 Minutes
learning resources
1.

Compensation calculation

14 Minutes
learning resources
2.

Linking payroll sheets

10 Minutes
1.

Creating an evaluation system: Building a Report

11 Minutes
learning resources
2.

Data Migration - Macro

12 Minutes
learning resources
3.

Linking data between worksheets

13 Minutes
1.

Creating an Interface

12 Minutes
2.

Dashboard - Pivot Tables

9 Minutes
3.

Dashboard - Building Dashboard

14 Minutes
4.

Labor Turnover - Calculate labor turnover

17 Minutes
5.

Employee Report

13 Minutes

About this course

Human resources management is one of the important and fundamental matters for the success of any business, as major institutions and companies in various sectors in the countries of the world depend on it. It is no secret to those working in this field how important it is to use Excel in organizing administrative work, so we have prepared the “Excel HR” course. You'll learn to create advanced spreadsheets to manage information, organize employee and payroll data, analyze performance and career transition data, and prepare innovative reports. In other words, you will be able to professionally employ Excel in human resources management without previous experience and employ Excel skills to serve the most important administrative functions.

Course requirements and prerequisites

This course requires providing a computer or smartphone, Excel program limit Accuracy 2016, and definitely practice and follow-up.

Mentor

Looking for help?