Short Course

The Power of Excel

Module Code: IT5200019
Duration: 6 hours
Course Fee: (To be confirmed)

Intended Learning Outcomes

On completion of the module, students are expected to be able to:

  • use data analysis tools Different useful formulas such as vlookup, countif, sumif, etc. PivotTable Conditional Formatting
  • Using data analysis tools to analyse huge size of data
  • Using data analysis tools to find optimal solutions for problems in business environment
  • Using data analysis tools to build useful formulas in collaboration with functions for effective use

Entry Requirements

  • Secondary 5 or above