Workshop on Advanced Excel for Professional (English Medium)

Department

Business

Campus

Colombo /

Level

Workshops

Duration

02 Days

ENTRY REQUIREMENTS

  • Those who seek to learn Advanced Excel for use in a business environment

Commencement

  • 31st October 2019
  • 7th November 2019

Course structure and modules

  • Basic Formulas
  • Filtering
  • Vlookup, Hlookup, Index
  • Working with forms
  • Date and Time Formulas
  • Database Functions
  • Statistical Analysis
  • Advanced Formulas & other advanced features with pivot tables
  • Trend Analysis & Graphs
  • Scenario Analysis
  • Financial Functions (with IRR)
  • Financial Statement Analysis

Programme Fees

  • Course Fee: LKR 9,000