Workshop on Advanced Excel for Professional (English Medium)
Department
Business
Campus
Colombo /
Level
Workshops
Duration
02 DaysENTRY 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 15,000 (Per Day)