What is your next education pathway ?
Workshop on Advanced Excel for Professional (English Medium)
Department
SCHOOL OF BUSINESS
Campus
Colombo Campus / Rajagiriya Campus
Level
Workshops
Method
Method
02 Days
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