UEN No.: 198802365N

Search
Contact Us

Leveraging Functions and Formulas using MS Excel

REGISTER TODAY

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.

DOWNLOAD PDF 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

Select a date below

15 Nov
27 Dec
SHARE
Course Outline

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

Related Courses

MS Excel

Advanced Data Visualisation using Power BI

IT

24 HRS

WSQ

MS Excel

Perform Spreadsheet Functions 24 hours

IT

24 HRS

WSQ

MS Excel

Dashboards using Power Query

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

message US

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

whatsapp US

Training hotline

Give us a call at
+65 6737 5761

CALL US
IT Courses
Soft Skills Courses
About Us
Resources

Offering an extensive range of courses conducted by our pool of accredited trainers, we take pride in providing training solutions to meet your learning and professional objectives.

Connect With Us