عربي
عربي
Passionately developing careers since 2000.
عربي
عربي
Why Attend
Human Resources Specialists will learn to save precious hours from their daily tasks. We will provide participants with tips that will help them resolve in a fraction of the time the challenges they face when working on employee compensations, salary, leave, beneï¬ts and the like. In this training, participants will practice formatting techniques to convert data from diï¬erent sources and learn to make the best use of the most important formulas for HR. They will create meaningful charts and diagrams, use logical functions, and link their spreadsheet to other worksheets and applications. Participants will also automate some common Excel tasks, apply advanced analysis techniques and troubleshoot errors. Excel tools enable us to be more productive and eï¬cient participants will learn to leverage the powerful features of Excel for HR, auditing and other HR tasks.
Overview
Course Outline
Schedule & Fees
Methodology
This is a practical course with a multitude of hands-on exercises that human resources specialists will learn and practice in order to help them apply these time saving techniques in their daily work .
Course Objectives
By the end of the course, participants will be able to:
Apply Excel reporting expertise in human resources by enhancing data slicing and dicing, data massaging, and data analysis skills
Use pivot tables and pivot charts to efficiently perform automated report writing and analysis
Develop operational dashboards including business KPIâs
Repeat tasks and generate reports efficiently by recording, running and editing macros
Acquire numerous tips and tricks that will improve working efficiency
Target Audience
Human resources and administration specialists, compensation and beneï¬ts specialists, human resources reward and payroll professionals, human resources managers as well as anyone who perform HR and administration functions in their organizations on regular basis.
Target Competencies
Human resources reporting techniques
Analyzing human resources data
Data modeling
Integration with external data sources
Report structuring techniques
Automation of routine tasks
Charting and visualization techniques
Leveraging pivot table powers
Larimar will help you find what you are looking for
