Duration: 1 day
Time: 9am to 6pm

What Will Be Taught For This Excel Course?

This 1 day instructor led course will empower participants with the knowledge and skills which is important to many data analysis projects using human resources data. It is organized into technical chapters that focus on getting the data in Excel, preparing data for critical reporting, protecting sensitive data and automating repetitive data.. Participants will learn formatting techniques to convert data from different souces, and how to make the best use of most important formulas for HR.

Learning Objective

  • Transform raw data into information
  • Enhanced visibility to specific data
  • Create combination of column and line chart
  • Automate common, repetitive tasks through Macro
Module 1. Getting your data into Excel
  • Importing Data from Access
  • Importing Data from Text Files
  • Changing External Data Range Properties
  • Importing Data from Other Applications
  • Removing the Query Definition
Module 2. Highlight Your Critical Data
  • Applying Conditional Formats
  • Changing a Conditional Format
  • Adding a Conditional Format
  • Creating a Custom Conditional Format
  • Using Data Bars
  • Adding Sparkline
Module 3. Adding Names for frequently used data
  • Working with Range Names
  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Applying Range Names
  • Deleting Range Names
Module 4. Essential Formula for HR
  • Text functions for HR applications
  • Logical functions to get desirable results (IF, COUNTIF, SUMIF)
  • Lookup function for HR usage
  • Manage The Use of Dates (MONTH, YEAR, DAY)
  • 3D Formulas
Module 5. Using Combination Charts to Present your Result
  • Adding and Removing Gridlines
  • Formatting Gridlines
  • Formatting an Axis
  • Changing the Axis Scaling
  • Formatting the Data Series
  • Adding Data from Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Adding a Trendline
  • Creating a Chart Template
  • Applying a Chart Template
Module 6. Ensuring Data Validity
  • Applying Data Validation
  • Circle invalid data
  • Creating a Custom Error Message
  • Removing Data Validation
Module 7. Automating Repetitive task
  • Defining Macros
  • Running a Macro
  • Using a Shortcut Key
  • Opening the Visual Basic Editor Window
  • Using the Visual Basic Editor Window
  • Recording a Macro
  • Assigning a Shortcut Key
  • Deleting a Macro
Module 8. Add Interactivity to Your Worksheets
  • Using a Macro Button
  • Creating a Macro Button
  • Copying a Macro Button
  • Formatting a Macro Button
  • Moving/Sizing a Macro Button
  • Deleting a Macro Button
  • Adding a Macro to the Quick Access Toolbar
  • Changing a QAT Macro Button Image
  • Deleting a Macro Button from the QAT

Who Should Attend This Business Intelligence and Dashboarding Course Training?

  • HR Manager/ Executives
  • Training and Development

Pre-requisite

Before attending this course, participants must:

  • Attend the Microsoft Excel Basic & Intermediate course or equivalent course (Microsoft Excel - ICDL Core or MOS Core) OR
  • Successfully passed the Microsoft Excel Basic & Intermediate Assessment by COMAT OR
  • Have Microsoft Excel Basic & Intermediate level of knowledge as verified by HOD or HR representative
  w/o GST w GST
Course Fee $400 $428

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.