What is your next education pathway ?

Workshop on Advanced Excel for Professional (English Medium)

Department
Department
SCHOOL OF BUSINESS
Campus
Campus
Colombo Campus / Rajagiriya Campus
Level
Level
Workshops
Method
Method
Duration
Method
02 Days
Medium
Medium
English

Entry Requirements

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

Commencement

  • 31st October 2019

  • 7th November 2019

Programme Fees

  • Course Fee: LKR 15,000 (Per Day)

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