Excel for HR Professionals

Microsoft Excel training at Intellisoft

Course Duration for Microsoft Excel for HR Training: 2 days


Where: Intellisoft Training Room @ Fortune Centre
Using: Microsoft Excel 2010 / 2013.
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details. SkillsFuture credits ready for Singaporeans.
UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.

Learn Excel at Intellisoft Singapore
Learn Excel at Intellisoft Singapore

In just 2 days, HR Professionals will learn the tips that save hours to resolve the difficulties they face on a daily basis in doing employee compensations, salary, leave, benefits etc.

In this practical training, participants will learn formatting techniques to convert data from different sources,  and how to make the best use of most important formulas for HR.

They are able to manipulate charts and diagrams, use logical functions and link their spreadsheet to other worksheets and applications.

 You will learn 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.

 What will you get:

  • Quality training is delivered by Microsoft Certified Trainers from the industry.
  • Participants get the easy to read and understand manual specially designed for this course to take back for practice and future reference.
  • All formulas and functions from these files could be directly used at workplace.
  • Ability to ask questions on the spot and maximize your learning.

You can register online for the Advanced Excel for HR Training.

If you want to join our other Excel course in Singapore & improve your skills, we have multiple courses – Basic Excel for Analytics, Advanced Excel Courses in Singapore & VBA Macro Programming Courses.

Go To Top

After completion of the Advanced Excel for HR Training, you will be able to do the following easily: 1.    Calculate the tax deductible  amount based on the different salary range.

2.  Display first name, last name with prefix in one single column from three different columns.

3.  Find years of service of employees.

4.   Find the total salary expenses in different regions, different departments.

5.  Total  number of employees in the company  in different departments.

6.   Find the total salary given to employees of a particular department or designation in a particular month.

7.   Find number of employees joined on particular date/month in any department in any country.

8.  Calculate the bonus based on overall performance of an employee.

9.   Find the number of leaves taken by any employee, find the designation of an employee from his salary.

10.  Count number of directors or any designation in a company.

11.  Display the records according to department, by hire date, by salary etc.

12.    Calculate the total overtime hours for employees for any month.

13.   View summarized salary for all the different countries in different departments.

14.   Set the status, department of an employee through data validation.

15.    Validate the hire date upon data entry.

16.   Calculate salary based on overtime hours.

17.    Calculate the net pay of an employee from his/her daily pay and leaves taken.

18.   Consolidate overtime hours and rate for two employees

19.    Compare employee’s involvement in department from the working hours using charts.

20.    Find total number of employees working in specific department from specific dates, and much more in this 2 day HR focused Microsoft Excel 2010 workshop. Register today!

Go To Top

Excel Training @Intellisoft
Excel Training @Intellisoft

COURSE OUTLINE

Lesson 1:

  •  Learning formula fundamentals
  •  Creating formulas and their automatic application
  • Using references & named ranges

Lesson 2:

  • Using special text functions for HR applications
  • Using logical functions to get desirable results

Lesson 3:

  • Using pivot table and charts
  • Create a PivotTable Framework

Lesson 4:

  • Lookup function for HR usage

Lesson 5:

  • Protecting your data forms from invalid data entry
  • Recording MACROS & automating Work

Lesson 6:

  • Linking several worksheets
  • Combining several workbooks to create a summary

Lesson 7:

  • Securing and reviewing your worksheet
  • Tracking changes and comments
  • Hiding and protecting formulas

Full of  Practical, Hands on Exercises based on HR work. A Laptop for doing the exercises is provided in the class room for all participants. What are you waiting for? Register for Excel for HR Executives.

Go To Top

This course is designed for: New and Experienced HR professionals from:

  •     Admin Professionals
  •     Compensation and Benefits Professionals
  •     HR Reward and Payroll Professionals
  •     HR Managers
  •     Anyone who perform HR functions in their organizations on daily basis

This course is extremely practical with multitude of hands on exercises that HR Executives will learn to apply in routine HR work and present meaningful information to the management. You can attend the HR workshop on Excel at Intellisoft Systems.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.

Applicable for Company Sponsored Singaporeans & PRs.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need here. We’ll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Register for the 2 Days of Excel for HR training today by simply clicking on the chosen course date available at the top of this page. Need Help?

  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066 – 9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Excel for HR training.

We also offer Corporate Trainings for Advanced Excel 2010 version. If you have a group of people, we can arrange to conduct the Advanced  Excel for HR   training at your office location too. Just contact us for details.

Master Excel
&
Enhance Your Productivity

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!