Microsoft Excel Skills training for Human Resource (HR) and Admin Professionals


Course Cover

Register for this course

We are proud to offer this course in a variety of training formats to suit your needs. We use the highest quality learning facilities to make sure your experience is as comfortable as possible. Our face to face calendar allows you to choose any classroom course of your choice to be delivered at any venue of your choice - offering you the ultimate in convenience and value for money.


June 2024

Code Date Duration Location Fee Action
MEH03 24 Jun 2024 - 5 Jul 2024 10 days Nairobi, Kenya KES 159,000 | $2,200 Register
MEH03 17 Jun 2024 - 28 Jun 2024 10 days Kampala, Uganda $3,300 Register
MEH03 17 Jun 2024 - 28 Jun 2024 10 days Accra, Ghana $4,400 Register
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].

June 2024

Date
Duration
Location
Fee
Action
24 Jun - 5 Jul 2024
10 days
Nairobi
KES 159,000 $2,200
17 Jun - 28 Jun 2024
10 days
Kampala
$3,300
17 Jun - 28 Jun 2024
10 days
Accra
$4,400
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].


INTRODUCTION

In this course, HR and administration professionals 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, benefits and the like.

In this training, participants will practice formatting techniques to convert data from different 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 efficient. By attending, participants will learn to leverage the powerful features of Excel for HR, auditing, and other HR tasks.  Explore the use of Excel as an audit and analysis tool, as well as, selected features that help prepare accurate reports

DURATION

10 days.

WHO SHOULD ATTEND

This course is beneficial to Admin Professionals, Compensation and Benefits Professionals, HR Reward and Payroll Professionals, HR Managers as well as anyone who performs HR functions in their organizations on daily basis.


Course Level:

COURSE OBJECTIVES

Upon completion of this course the participant will:

  • Learn how to resolve the difficulties they face on a daily basis in doing employee compensations, salary, leave, benefits and much more.
  • Learn the formatting techniques to convert data from different sources.
  • Learn how to make the best use of important formulas for HR.
  • Learn how to manipulate charts and diagrams, use logical functions, and link their spreadsheet to other worksheets and applications.
  • Understand how to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
  • Apply Excel reporting expertise in HR and administration 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

TOPICS TO BE COVERED

HR reports

  • Listing reports with custom views
  • Preparing reports using pivot tables
  • Consolidation of data

Cells and name ranges

  • Creating name ranges for data
  • Using name ranges for values calculations
  • Creating names from selection command
  • Creating a 3-D formula
  • Updating name ranges
  • Editing name ranges

HR data formatting

  • Formatting numbers
  • Formatting dates
  • Conditional formatting
  • Avoiding duplication of employee records
  • Data bars for performance appraisal
  • Icon sets for job level
  • Color scale for employees grades
  • Greater or less than for earnings
  • Based on a formula
  • Setting warnings on residency expiry date

Automate HR repetitive tasks

  • Creating macros for HR reports
  • Using macros for monthly reports
  • Saving macros in personnel macros workbook
  • Assigning macros to quick access toolbar

Data calculations

  • Date and time functions for attendance
  • Working days
  • Years of service

Logical and statistical functions

  • Employee pay increase and bonus (paste special)
  • Implement HR policies
  • Statistical functions for HR data
  • Sumif / sumifs / count / countif / countifs / subtotal
  • Average / averageif / averageifs

Lookup functions

  • Vlookup and hlookup
  • Approximate and exact match
  • Index and match functions

Creating masters with data validation

  • Employee status, locations and grades
  • Employee designations, nationalities and departments
  • Date and number validation
  • Custom validation

Leave records and calculations

  • Is the employee eligible for leave or bonus? If function
  • Accrued leave
  • Leave taken records
  • Leave balance

Payroll and benefits

  • Payroll sheet and salary slips
  • Using attendance data to calculate payroll

End of service calculations

  • Computing gratuity
  • Computing cashable leave

HR charts and graphs

  • Speedometer chart
  • Performance against range
  • Spinner

Comprehensive exercises

  • Calculating gratuity
  • Salary increment calculator
  • Performance review scores

Related Courses


Course Administration Details:

TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on 

Tel: +254 (020) 211 3814.

Mob: +254 715 077 817, +250789621067

Email: [email protected] or [email protected]

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Indepth Research Institute (IRES) admission criteria.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional 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 with an Indepth Research Institute(IRES) certificate.

TRAINING VENUE

The training is residential and will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: [email protected][email protected]

Mob: +254 715 077 817/ +250789621067

Tel: 020 211 3814

PAYMENT

Payment should be transferred to IRES account through bank before the course start date

Send proof of payment to [email protected] or [email protected]


Share this course:


Who else has taken this course?


# Job Title Organisation Country
1 Human Resource Management Officer Malawi Electoral Commission Malawi

Related Courses

People who took this course also viewed: