Skip To Content
Useful Excel Formulas and Functions is a Program

Useful Excel Formulas and Functions

Self-paced

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Useful Excel Formulas and Functions

Who Should Attend

This course is intended for users of Microsoft Excel 2016, who want to learn about useful formulas and functions.

Course Duration

1 Day / 7 Hours

Course Outline

Formulas with Multiple Operators

  • Perform simple calculation using math operators
  • Inserting and Editing a Function
  • AutoCalculate and Manual Calculation

Range Names

  • Defining Names
  • Using and Managing Defined Names 

Using Logical Functions (IF)

  • Understand the IF Syntax
  • Writing the first IF statement
  • And Or Functions with IF
  • Nested IF

Lookup and Reference Functions

  • Vlookup
  • Lookup
  • Understand Exact and Approximate Match
  • Index and Match

Date & Time Functions

  • Today()
  • Year()
  • Month()
  • Day()
  • Date()
  • DateIF()

 Using Text Functions

  • Left
  • Right
  • Mid
  • Len
  • Find
  • Text
  • CONCANTENATE

Course Objectives

This course will enable participants to learn to use existing Functions available in Microsoft Excel to perform calculation or data manipulation

Pre-requisites

  • Simple typing using the keyboard
  • Navigating using the mouse
  • Managing files and creating folders
  • Experience in formulating formulas in Microsoft Excel

Price

 Original course fee $270 (before GST)
 After funding for NTUC Union Member $20 (with GST)


Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees