External Advanced Excel (External Students)
Course Fee
15,000LKR
*50% off for university of kelaniya staff members and their children.
Method of Teaching
Combination of lectures & practical sessions
Duration
30 Hours (08 Days)
Sunday 01.00 pm - 05.00 pm
Medium
Sinhala Language
Course Content
Part 2: Excel VBA & Macros (Automation)
• Module 8: Macros and VBA Fundamentals
• Module 9: Excel Automation Projects
Part 3: Power BI (Data Analysis & Dashboards)
• Module 10: Power BI Fundamentals
• Module 11: Power BI Visualization & Reports
• Module 12: Power BI Dashboards (Practical Projects)
How to Register
We will notice when we are calling for the application
15,000LKR
*50% off for university of kelaniya staff members and their children.
Method of Teaching
Combination of lectures & practical sessions
Duration
30 Hours (08 Days)
Sunday 01.00 pm - 05.00 pm
Medium
Sinhala Language
Course Content
Part 1: Microsoft Excel (Beginner to Advanced)
• Module 1: Introduction to Excel
• Module 2: Data Management
• Module 3: Formulas & Functions
• Module 4: Data Visualization
• Module 5: Excel Dashboards
• Module 6: Advanced Excel Functions & Analysis
• Module 7: Working with Large Data
• Module 1: Introduction to Excel
• Module 2: Data Management
• Module 3: Formulas & Functions
• Module 4: Data Visualization
• Module 5: Excel Dashboards
• Module 6: Advanced Excel Functions & Analysis
• Module 7: Working with Large Data
Part 2: Excel VBA & Macros (Automation)
• Module 8: Macros and VBA Fundamentals
• Module 9: Excel Automation Projects
Part 3: Power BI (Data Analysis & Dashboards)
• Module 10: Power BI Fundamentals
• Module 11: Power BI Visualization & Reports
• Module 12: Power BI Dashboards (Practical Projects)
How to Register
We will notice when we are calling for the application
