Introduction
Indepth Research Institute Advanced Microsoft Excel for Human Resource Professionals is a five-day training course that will help participants utilize Ms Excel tools to perform the daily activities in managing the company’s workforce, such as managing the varied requirements of employee’s payroll, timekeeping and records in.
Duration:
5 days
Course Level:
Objectives
By the end of the course one should be able to:
- Work with advance Excel
- Analyse data using excel
- Create dashboards for reports and presentation
- Work with excel as a risk management tool
- Easily manage the payroll using excel
Module 1: Introduction to advanced Excel
- Understand the shortcuts in excel
- 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 2: Data Analysis in Excel
- Introduction to the Excel insert tab
- Creating and designing tables
- Working with pivot charts and tables
- Working with charts for data presentation
- Work with slicers
- Sorting and filtering data and understanding references in Advanced excel
Module 3: 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
Module 4: Human Capital Risk Management
- Establishing the risk context and risk criteria
- How to Identify and approach a risk
- Understanding how to manage a risk
- Evaluating the risk management methodology
- Managing Human capital risks
Module 5: Payroll management
- Understand the billing calculator and how to activate your currency, text box and checkbox
- Introduction to the essential contents of the Excel Payroll
- Understand how to import data
- Use payroll formulas in Excel
- Use of the payroll analysis and the goal seek component
- Learn how to customize and save templates
- Learn how to creates macros and VBA to manage the payroll system
- Tracking changes and securing worksheets
Related Courses
Course Administration Details:
METHODOLOGY
The instructor-led trainings are delivered using a blended learning approach and comprise presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
ACCREDITATION
Upon successful completion of this training, participants will be issued an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).
TRAINING VENUE
The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.
ACCOMMODATION AND AIRPORT PICKUP
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.
- Email: [email protected]
- Phone: +254715 077 817
TAILOR-MADE
This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location. For further inquiries, please contact us on:
- Email: [email protected]
- Phone: +254715 077 817
PAYMENT
Payment should be transferred to the IRES account through a bank on or before the start of the course. Send proof of payment to [email protected]
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Do you need more information on our courses? Talk to us.
