Short Course

Data Analysis using Excel

Module Code: IT5200021
Duration: 6 hours
Course Fee: $ 530
VTC Staff/Student/Alumni: $ 450
Member of Supporting Organization: $ 450
Early Birds: $ 450

Intended Learning Outcomes

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

  • Perform basic data manipulation and data analysis
  • Generate charts to provide the graphical representation for various types of data.
  • Use conditional formatting to highlight important information
  • Apply Pivot tables to identify the key trends in the data
  • To import data from a non-excel sources
  • Create interactive dashboards for quick report purpose

Entry Requirements

  • Elementary knowledge of Microsoft Excel