Harnessing the Power of Formulas and Functions in Excel (2016)IT Short Courses

Enquire MoreRegister NowCorporate Courses

DurationOne day
Course Dates20 Feb 2024 9:00am - 20 Feb 2024 5:00pm
10 May 2024 9:00am - 10 May 2024 5:00pm
28 Aug 2024 9:00am - 28 Aug 2024 5:00pm
11 Nov 2024 9:00am - 11 Nov 2024 5:00pm

Course Fee

Member $277.95
Non-Member $327
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • Course fees updated with 9% GST for 2024

Funding Available

    SDF Grant Amount: S$28.00
    Course Reference No.: TGS-2020502563
    SkillsFuture Credit
  3. (Individual Singaporean aged 25 and above)
    Pre-approved SkillsFuture funding of S$500.00

Click HERE for more info on SkillsFuture.



One of Excel’s key strengths is its power of formulas and functions where it can display data in a format that is suitable for reporting.

Key Takeaways

This course takes the Excel user to a realm where he/she will be introduced to cell manipulation as well as discover techniques of fine-tuning formulas and the introduction of some Advanced Excel functions relating to text, logical and information that assist in providing the necessary information or changing the representation of how data is presented.

Who Should Attend

Those needing to extract information from their worksheet models as well as how to tidy up their data in a format that is acceptable for reporting are especially encouraged to attend.

Programme Outline

Module 1: Cell Manipulation in Excel

  • Applying Conditional Formatting to a Range
  • Filling a Range by using the Fill Handle & Flash-filling a range
  • Creating a Series using Excel Series command
  • Using the Go To Special Dialog Box
  • Displaying Worksheet Formulas using Ribbon command & using a function
  • Printing Worksheet Formulas
  • Converting a Formula to a Value
  • Apply Paste Special Function

Module 2: Building Basic Formulas and Functions in Excel

  • Understanding Excel Formulas
  • Creating an Excel Formula
  • Understanding Relative, Absolute and Mixed Cell Referencing
  • Using Relative, Absolute and Mixed Cell Referencing in Formulas
  • Understanding Excel Functions
  • Creating an Excel Function through various methods
  • Using the AutoSum
  • Using some common Excel Functions
  • Understanding Excel’s Formula-Related Errors
  • Apply Automatic Checking for Possible Errors in Formula Usage

Module 3: Working with some Advanced Excel Functions

  • Logical and Information Functions
  • Applying a Logical Function in Excel
  • Getting Data with Information Functions
  • Text Functions
  • Working with Characters and Codes
  • Converting Text
  • Formatting Text
  • Removing Unwanted Characters from a String
  • Extracting a Substring
  • Searching for Substrings
  • Substituting One Substring for Another


Not only a good foundation in Excel is essential for this course but learners preferably should have attended the Level 3 Beyond Advanced course before enrolling for this course. Having attended the Level 2 Advanced course is advantageous.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because, at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing and putting ideas into practice.

If you are interested in this corporate programme, please complete the following form and one of our representatives will get back to you as soon as possible.

I would like to receive marketing, advertising and promotional messages via:
(Please untick if you do not wish to receive)

MDIS values your privacy and we are committed to safeguarding your personal data in compliance with the Personal Data Protection Act 2012. By providing your personal details, you have authorised MDIS to share with you our marketing, advertising and promotional materials.

Quick Information

One of Excel's key strengths is its power of formulas and functions where it is able to display data in a format that is suitable for reporting.

Contact Details

  +65 6842 6666