Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This Microsoft Excel Course?

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

Module 1. Formula and Functions Basic
  • Formula basics
  • Using cell references
  • Copy formula without changing cell reference
  • Transpose formula
  • Using nested functions
Module 2. Statistical and Logical Functions
  • Perform calculation using CountIF
  • Perform calculation using SumIF
  • Perform calculation using AverageA
  • Using IF function to prevent division by zero
  • Using IsError function to avoid error display
  • Creating multiple conditions using nested IF
  • Using logical function OR, And within IF
Module 3. Lookup and Reference Formulas
  • Using Vlookup to find specific data
  • Using Hlookup to find values in rows
  • Using Match and Index to retrieve data
Module 4. Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Custom Number Formats
Module 5. Array and Database Functions
  • Using Array Formulas
  • Calculate the difference between Maximum and Minimum values
  • Using Frequency function to Count responses
  • Using Database functions DSum and DCount
Module 6. Creating PivotTables
  • Creating a PivotTable Report
  • Adding PivotTable Report Fields
  • Selecting a Report Filter Field Item
  • Refreshing a PivotTable Report
  • Changing the Summary Function
  • Adding New Fields to a PivotTable
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Deleting PivotTable Report Fields
  • Creating Report Filter Pages
  • Formatting a PivotTable Report
  • Creating a PivotChart Report
  • Publishing PivotTable Reports to the Web
Module 7. Efficiency Tips
  • Shortening worksheets names
  • Protecting cells containing formulas
  • Using Data Validation
  • Displaying Formula syntax
  • Using Auditing Tools for errors checking
  • Tracing precedent and dependent
  • Excel Tips - Comparing cells between worksheet
  • Adding comments to worksheet
Module 8. Working with Dashboard
  • Working with Forms Control
  • Using charts with Forms Control
  • Adding Simple Macro for Forms Control

Who Should Attend This Microsoft Excel Training?

HR professionals, HR Executives, HR Managers and Directors.

  w/o GST w GST
Course Fee $680 $727.60

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD).
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.



Please click on the course date to enrol.