• 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • HRDFApproved & Claimable

Course Objectives

  • Use COUNTIF function – Test
  • Use SUMIF function
  • Use VLOOKUP & HLOOKUP to search for data
  • Use the Change Case function
  • Calculate a Period of Time Between Two Dates
  • Use Array Formulas
  • Use Database functions
  • Use Auditing Tools to Check for Errors
  • Validate data in a Worksheet


Knowledge of Microsoft Excel (Foundation) is essential with the follow pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to insert and delete Row & Column
  • Print a spreadsheet with headers and footers applied
  • Insert, Delete and Rename a worksheet 

Target Audience

The target audience for this course is Managers, Assistant Managers, Supervisors, Team Leaders, Executives and Staff who wish to gain the skills and understand the formulas and functions syntax. Learn how do they apply in a nested formulas environment?


This program will be conducted with interactive lectures, PowerPoint presentation, discussions, and practical exercises

Course Modules

  • Lesson 1 – Formulas and Functions Basic
  • Lesson 2 – Statistical and Logical Functions
  • Lesson 3 – Lookup & Reference Formulas
  • Lesson 4 – Text Formulas 
  • Lesson 5: Date & Time Formulas 
  • Lesson 6 – Array and Database Functions

Contact us for more information


Login with your social account


Don’t have an account with us?

Edit Profile


Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account


By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?