Workshops
Workshop on Advanced Excel for Professional (English Medium)
![NIBM](https://www.nibm.lk/wp-content/uploads/2021/07/icon-1.png)
![NIBM](https://www.nibm.lk/wp-content/uploads/2021/07/icon-1.png)
Department
Business![NIBM Programmes](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-campus.png)
![NIBM Programmes](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-campus.png)
Campus
Colombo /![NIBM Programmes](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-level.png)
![NIBM Programmes](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-level.png)
Level
Workshops![NIBM](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-duration.png)
![NIBM](https://www.nibm.lk/wp-content/themes/nibm-theme-child/images/icons/icon-duration.png)
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)