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

Mr. Paul Toh

1 Day

Click on the selected date to apply now or download registration form to apply later.

Intake 01
20 Jul 09

Intake 02
24 Aug 09

Intake 03
26 Oct 09

Intake 04
30 Nov 09

Download Form

S$500 (Inclusive of GST)

NUS Extension (#12-01 Park Mall)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Excel Functions and Formulas

Course Objectives

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