Course Overview
This course is designed to educate the HR Manager on how to use Excel as a better tool for their Office work.
Duration
5 days
Target Audience
- HR Managers
- General Managers
- Office Administrators
Course Level:
Course Objectives
- 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
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
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.
