Data Analytics for Human Resource Managers using Advanced Excel Course train in maintain huge chunks of data and also to convert dashboard data into user friendly visuals. The job of a HR is not an easy task especially when one has to manage a huge number of employees and data. To help them perform their mundane tasks and analyze data well, dashboards can play a very effective role.
Upon Successful Completion Of Data Analytics for Human Resource Managers Using Advanced Excel Course, Participants Will Be Able To:
- Work with Excel formulas and charts for analysis
- Work with Excel for data visualization
- Work with excel for HR roles such as payroll management, risk management and decision making
- Use Excel for Creating reports dashboards
Who Should Attend Data Analytics For Human Resource Managers Using Advanced Excel Short Course?
- Human Resource Professionals
- General Managers
- Office Administrators
Detailed Course Outline
Module 1: Introduction to Advanced Excel
- Introduction excel shortcuts
- Understand various excel setting
- Understand the excel layout
- Working With Microsoft Excel Fundamentals and numeric data
- Saving Excel in different formats
- Importing data into Excel
Module 2: Advanced Excel Formulas and Macros
- Work with various advanced Excel data functions
- Learn how to work with arrays and lists
- Work with advanced logical formulas in excel
- Work with advanced text formulas in excel
- Understanding the basics of VBAs and Macros
Module 3: Data Visualization and analysis in Advanced Excel
- Creating and Designing tables
- Working with charts for data presentation
- Work with slicers, sorting and filtering data and understanding the use references
- Data summary and analysis using pivot tables and charts
- Linking several worksheets
- Combining several workbooks to create a summary
- Securing and reviewing your worksheet
- Tracking changes and comments
Module 4: Management and Decision making
- Understand how to Identify, evaluate and manage business capital risk
- Monte Carlo Simulation for Decision making
- Decision Trees for Decision making
- Forecasting
- Learn Payroll Management
- Understand Return of investment
Module 5: The HR dashboard and Analytics for presentation and reports
- Introduction to data index and page layouts
- Work with predictive attrition and animated macro charts
- Understand the Vlookup and Hlookup analysis
- Learn BVG and leave analysis, FNF and Exit Analysis
- Learn how to group data and understand the Bradford Factor
- Learn the HR update and HR Update calendar
- Develop operational dashboards including business KPI’s
- Use pivot tables and pivot charts to efficiently perform automated report writing and analysis
METHODOLOGY
Corporate Staffing Services Data Analytics for Human Resource Managers using Advanced Excel Course training is an instructor led training delivered using a blended learning approach and combines presentations, guided sessions of practical exercise and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.
ACCREDITATION
Upon successful completion of this training, participants will be issued with a certificate certified by the
National Industrial Training Authority (NITA).
TRAINING VENUE
The training will be held at Corporate Staffing Services Training Centre.
SIGN UP
When we receive your details, Lucy will call you with more information on the training.
N.B: Would you like us to consider you for a job opening? Boost your job search. Upload Your CV Here. It's FREE
