Breakthrough Performance for HR in Excel – Based on Excel 2007/10

Powerful Data Management and Reporting for Human Resources.


    In-House sessions are available upon request.


    Course Overview:

    This solution-based Microsoft® Excel course is tailored for human resources personnel who are seeking increase in productivity and improving their HR operation processes such as the tracking of work permits and passports renewal for foreign workers, tracking of training budgets, analysis of staff cost, short listing of job applicants, etc.


    Who Should Attend:

    Human Resources Managers and Executives who have to regularly prepare reports related to employees leave, training, payroll, etc , using data downloaded from systems. They are required to know how to format cells, auto-filter, sort, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.


    Learning Objectives:

    Upon completion of the course, participants will be able to:

    • Prepare HR reports in double quick time and respond to business needs with relevance.
    • Transform data from standard HR systems into meaningful and robust reports for management.

    Course Curriculum

    Section 1: How to effectively calculate overtime hours using Excel
    Section 2: Track expiry of work permits and passports using conditional formatting
    Section 3: Identify the oldest employees at a glance using conditional formatting
    Section 4: How to profile employees using Pivot Table, Age formula
    Section 5: How to monitor training cost spending against training budgets using formulas
    Section 6: Monitor training hours clocked by employees, job grade, department, etc
    Section 7: Create a job application form and capture the details to facilitate screening of job applicants using Excel forms
    Section 8: Compare last month report with current month report using VLOOKUP and conditional formatting
    Section 9: How to swop first name and last name and vice versa
    Section 10: Combine first and last names into one cell
    Section 11: Display the zeros in front of employee IDs
    Breakthrough Performance for HR in Excel – Based on Excel 2007/10 (2-Day) 14:00:00

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • SGD 600
    • 2 days
    • 1 Units
    • 840 Minutes
    • Wishlist

    Enrol With Confidence

    PayPal Acceptance Mark

    Registration Support

    If you require further assistance on registration matters, email to

    In-House Enquiry

    Achieve higher ROI with your training budget with In-House trainings, email to
    everydayExcel Business Lab is a training company offering Professional Microsoft® Excel Courses with a Business Perspective. We tailor-made Excel courses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resource, administration, business development, etc. Our excel course trainers are not just Masters of Excel who teach people how to use Excel. They are business analysts who can naturally appreciate the decisions made in businesses and the common business problems encountered and at the same time able to make expert use of what is available in Excel to solve analytic and reporting issues in business. Bottom-line for our client is always about how we can use Excel in a way to save a great deal of time and resources for the business. At EverydayExcel, we don't teach people how to use Excel as an end in itself. We teach people how to use it as a means to an end; that to apply the skills and techniques in solving solve their various business problems. For us, there is a huge difference in the two. We do not set out to train people to become gurus in using Excel who are unable to apply it to real-life business situations. We engage with our training participants in such a way that they are triggered to relate what they learn in Excel to their business problems that they face, and then go step by step to tell them how to approach them by creating powerful solutions in Excel. About Your Chief Trainer: Jason Khoo is the author of the two books "Excel Secrets for Highly Effective Marketers", "Hidden Secrets of Data Analysis with Excel" which are sold in all the major book stores in Singapore and in online Amazon. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.
    More Courses by everydayExcel Business Lab