Leveraging Functions and Formulas using MS Excel

COURSE details

Course Duration

8 HRS

Course Reference Number

TGS-2017500062

Funding Validity Period

16 Mar 2019 To
31 Dec 2024

Mode of Training

Classroom

Course Timing

9am-6pm

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.

Course Outline

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

COURSE FEES


Company Sponsored

Full Fee GST Broad-based Funding
($2 per training hour)
Nett Fee Payable (incl. GST)
$300 $27 $16 $311

Self-Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$300 $27 $327

Date & REGISTRATION

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