categories: Technology, Science & Productivity
Level: Specialized
Course Language: Arabic
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.
Free lessons
Creating tables in Excel - Format as table
Text Functions
Special pasting & Importing
1. Data Organization
Creating tables in Excel - Format as table
Text Functions
Special pasting & Importing
Date Functions
Formatting Dates
Conditional formatting in search and organization process
Polarizing: creating application forms for work
Automatic numbering , Validation & Custom number format
Contracts System Configuration
2. Leaves
New Vlookup Function Features
Linking data between sheets - SUMIFS + IFERROR function
3. Payroll
Compensation calculation
Linking payroll sheets
4. Evaluation
Creating an evaluation system: Building a Report
Data Migration - Macro
Linking data between worksheets
5. Improving Access
Creating an Interface
Dashboard - Pivot Tables
Dashboard - Building Dashboard
Labor Turnover - Calculate labor turnover
Employee Report
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.
This course requires providing a computer or smartphone, Excel program limit Accuracy 2016, and definitely practice and follow-up.
Advanced Computer Skills Trainer
1,218 Learners
3 Courses