SHARE

The workshop caters for HR/Payroll Personnel who require the use of MS Excel for payroll reconciliation or reports generation. Through practical hands-on sessions, workshop participants will learn how to prepare accurate reports in a much shorter time, freeing up time to concentrate on more important tasks.

Overview

Curriculum

Introduction

  • Excel orientation
  • Creating a new spreadsheet
  • Formatting font & cells
  • Customising worksheet printouts
  • Setting up security restrictions and excel data protection
  • Shortcut key commands

 

Basic Excel Functions

  • Adding a group of numbers
  • Computing data based on dates

 

Text / Number Excel Functions

  • Showing count of characters of data in cells
  • Displaying partial content in other cells
  • Modifying presentation of data in cells
  • Rounding numbers (upwards & downwards)

 

Lookup Excel Functions

  • Comparing and verifying information gathered from different excel worksheets
  • Auto-formatting of important data

Time

9:00am to 6:00pm

Venue

8 Wilkie Road
#03-08, Wilkie Edge
Singapore 228095

Target Audience

HR Practitioners

Duration

8 Hours

Fees Per Pax
(Excluding GST)

S$300

(SDF Grant Available! Learn more)

Secure your seat !

Name
Invalid Input
Designation
Invalid Input
Company
Invalid Input
Telephone
Invalid Input
Email
Invalid Input
No. of Seats
Invalid Input
Invalid Input