Building Human Resources Dashboard Using Excel 2010 & 2013 ITBM
Price: SGD 728

    Course details

    An HR Dashboard can be designed in different ways and used for different things, but its primary purpose is to publish important HR metrics relatively quickly, at a reasonably high level. This two days course will empower you with the skills to gather information from the staff, sort it, analyze it, and repackage it for the consumption of management and the executive teams of organizations. There are numerous number of new tips you will learn irrespective of the Excel version used

    COURSE OUTLINE

    • Module 1. Formula and Functions Basic
    • Module 2. Statistical and Logical Functions
    • Module 3. Lookup and Reference Formulas
    • Module 4. Conditional Formatting
    • Module 5. Array and Database Functions
    • Module 6. Creating PivotTables
    • Module 7. Efficiency Tips
    • Module 8. Working with Dashboard

    TARGET AUDIENCE

    • HR professionals, HR Executives, HR Managers and Directors.
    Updated on 31 August, 2016

    About ITBM

    Instructional & Courseware Design

    • Customized CD Learning, e-Learning and Courseware for companies. Find out more now.

    Office Workflow Automation

    • When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
    See all ITBM courses
    Are you from ITBM ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or