Non-Certifiable

Leveraging Functions and Formulas using MS Excel

course details

Duration and Time

Training Time

9am-6pm

Course Duration

8 HRS

Course Information

Course Reference Number

TGS-2017500062

Funding Validity Period

16 Mar 2019 To
31 Dec 2024

Mode of Training

Classroom

At the end of the course, participants will be able to use Excel Functions and Formulas more effectively.

  • Using SUM, AVERAGE, MAX, MIN, COUNT, COUNTA Functions
  • Using Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR, DATE, TIME
  • Using Mathematical Functions: ROUNDDOWN, ROUNDUP, SUMIF
  • Using Statistical Functions: COUNTIF, COUNTBLANK, RANK
  • Using Text Functions: LEFT, RIGHT, MID, TRIM, CONCATENATE
  • Using Lookup Functions: VLOOKUP, HLOOKUP
  • Use Database Functions: DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
  • Using Logical Function: IF, NESTED-IF, ISERROR, OR, AND
  • Understanding Cell References in Formulas: Relative, Absolute, Mixed Reference
  • Using a 3-D reference within a SUM Function
  • Using TRANSPOSE Function
  • Data Validation: Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time
  • Handling Error displays in Formulas:#######, #REF!, #NAME?, #DIV/0!, #VALUE!
  • Auditing Functions: Trace precedent, dependent cells. Identify cells with missing dependents, Error Checking for Circular Reference, Watch Window

This course is suitable for participants who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations.

  • Learners must be able to read, write, speak and listen to English at secondary school level
  • Learner should have working knowledge of Microsoft Excel
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $300.00 $27.00 $210.00 (70% off course fee) $117.00
Non Small Medium Enterprises $300.00 $27.00 $150.00 (50% off course fee) $177.00
Singaporean Employees aged 40 years and above $300.00 $27.00 $210.00 (70% off course fee) $117.00

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $300.00 $27.00 $210.00 (70% off course fee) $117.00
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $300.00 $27.00 $150.00 (50% off course fee) $177.00

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

REGISTER TODAY

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration