Excel Functions & Formulas


Who Should Attend

For those who want to know how to use MS Excel functions and formulas

Facilitators
Mr. Paul Toh
Duration
1 Days
Intakes & Registrations
Click on your preferred date below to register. Only online registrations will be accepted.

Intake 01

14 Jan 13

Intake 02

22 Feb 13

Intake 03

22 Mar 13

Intake 04

5 Apr 13

Intake 05

20 May 13

Intake 06

Intake 07

Intake 08

Intake 09

Intake 10

Intake 11

Intake 12

Fee

S$500 (Inclusive of GST)

*WDA pre-approved course
Step 1.
Please click here for the grant amount.
Step 2.
Key in the reference number CRS-N-0018802.

Venue
10 Kent Ridge Crescent Block ADM, Level 6

Course Objectives

By the end of the course, participants will know how to use Excel functions and formulas to perform the correct calculations in Microsoft Excel


Course Outline

The Performance Dashboards & Analysis Perspectives

  • Dates and Times Functions
    • DATE Function
    • DAY Function
    • WEEKDAY Function
    • WORKDAY Function
    • EDATE Function
    • EOMONTH Function
    • NETWORKDAYS Function
    • NOW Function
    • TIME Function

  • Special Conditional Formatting
    • Flag/Mark/Highlight Duplicates in Excel
    • Colour Every Second Row. Colour all Odd/Even Rows
    • Automatically Expand/Contract Alternate Row Colors/Color Banding

  • Customising Data Validation
    • Limit the Total
    • No Leading or Trailing Spaces
    • Prohibit Weekend Dates
    • Prevent Duplicates
    • Create Dependent Lists`

  • Solving Calculation Problems
    • Solving Averaging Problems
    • Solving Minimum Problems
    • Solving Summing Problems
    • Solving Counting Problems

  • Conversion Problems
    • Converting Strings to Dates
    • Converting Forced Text to Numbers
    • Converting Numbers to Text
    • Converting Imported Information to Numeric Values
    • Removing Non-printing Characters

  • Round Functions
    • ROUND Function
    • ROUNDUP Function
    • ROUNDDOWN Function
    • MROUND Function
    • EVEN Function
    • ODD Function

  • Lookup Functions
    • VLOOKUP Function
    • HLOOKUP Function
    • LOOKUP Function
    • MATCH Function
    • INDEX Function

  • Handling Error Displays
    • Stop the #N/A! Error in VLOOKUP
    • Avoid Error Displays in Formulas
    • Hide Error Values and Error Indicators in Cells