TRAINING.

Course Description

This comprehensive Microsoft Excel course covers a range of topics from basic data introduction to advanced financial analysis and visual basic programming. It includes practical lessons on Excel’s interface, shortcuts, formulae, data analysis, pivot tables, dashboard creation, and financial modeling, aimed at equipping learners with essential and advanced Excel skills over 90 hours of theory, practical, and assignments.

Objectives

• To provide a thorough understanding of Excel’s interface and options.
• To teach efficient data entry, manipulation, and analysis techniques.
• To equip learners with the skills to use various Excel functions and formulas effectively.
• To enable learners to create and use pivot tables, charts, and dashboards.
• To introduce financial analysis and modeling using Excel.
• To teach the basics of macros and Visual Basic for Applications (VBA) for automation.

Learning Outcome

By the end of this course, learners will:

• Be proficient in navigating and utilizing Excel’s interface and tools.
• Be capable of performing complex data analysis and manipulation.
• Be skilled in using a wide range of Excel functions for different tasks.
• Be able to create detailed reports, dashboards, and visual data representations.
• Have a foundational understanding of financial analysis and modeling.
• Be able to automate tasks using macros and VBA.

Target Audience

This course is designed for:

• Beginners looking to learn the basics of Microsoft Excel.
• Intermediate users aiming to enhance their data analysis and reporting skills.
• Professionals seeking to improve their efficiency and productivity using Excel.
• Financial analysts and accountants want to use Excel for financial modeling.
• Anyone interested in learning automation and advanced Excel techniques through VBA.

Training Outline

2 Functions & How to use (self study module)

1. 10 most popular functions – 10 functions                                                
2. Date and time functions – 25 functions                                                    
3. Logical functions – 11 functions                                                    
4. Text functions – 34 functions                                                        
5. Data Analysis using above functions                                                        
6. Compatibility functions – 41 functions                                                     
7. Lookup and reference functions – 25 functions                                                   
8. Math and trigonometry functions – 82 functions                                                 
9. Data Analysis using above functions                                                        

3 Data Analysis with Data Tables & Pivots        

1. Tables                                                  
2. Data Cleansing
3. Using Pivot Tables And Slicers To Describe Data
4. Graph & Charts                                                           

4 Dashboard & Reports 01        

1. Reports – Quick Method                                                         
2. Reports – Standard Method                                                    
3. Setting up to auto update                                                      

5 Dashboard & Reports 02        

1. Dashboard Designs                                                     
2. Represent of Analyzed data                                                   
3. Auto Update Reports & Summary Tables                                                      

6 Data Verification and Error Rectification       

1. Data Base Normalization & Standardization                                                  
2. How to Identify, Analyze and Rectify Errors                                                  
3. Excel Limitations, sheet Corrupt and Disabled issues                                                            

7 Macros & Visual Basic

1. Overview                                                         
2. Macro Creation                                                           
3. Macro Security                                                           
4. References                                                      
5. VBA & understanding of Codes                                                          
6. Running & Editing of Macros                                                  
7. User Forms & Debugging                                                        

8 Excel with AI   

1. Introduction to the AI                                                 
2. Microsoft AI member – Copilot                                                           
3. Go deeper with data                                                   
4. Identify insights                                                          
5. Focus on what matters                                                           
6. Generate formulas                                                     

9 In-depth Analysis        

1. Data Validation                                                           
2. Scenario Manager                                                       
3. Goal Seek Analysis                                                      
4. Sparklines                                                       
5. Conditional Formatting                                                          
6. Final Assessments                                                       

Course Description

This extensive course on Anti-Money Laundering (AML) and Countering the Financing of Terrorism (CFT) provides a thorough understanding of the regulatory framework and legal requirements in Sri Lanka. The course covers key legislation, such as the Prevention of Money Laundering Act, the Convention on the Suppression of Terrorist Financing Act, and the Financial Transactions Reporting Act. It also addresses practical approaches to identifying and preventing money laundering activities, including KYC protocols, risk assessments, mandatory reporting, and sanction screenings.

Objectives

• To provide comprehensive knowledge of AML and CFT regulations and legal frameworks in Sri Lanka.
• To understand the key legislation and amendments related to AML and CFT.
• To identify various methods used in money laundering and implement preventive measures.
• To equip learners with skills in KYC, customer due diligence, and risk assessments.
• To ensure compliance with mandatory reporting requirements, including CTR, EFT, and STR.
• To conduct effective UNSCR sanction screenings.
• To understand PEP and UBO guidelines and international sanctions.
• To analyze local and international case laws on AML.

Learning Outcome

By the end of this course, learners will:

• Have a detailed understanding of AML and CFT regulations in Sri Lanka.
• Be familiar with key AML legislation and its implications.
• Be able to identify and prevent money laundering methods.
• Be proficient in KYC procedures, customer due diligence, and conducting risk assessments.
• Understand and comply with mandatory reporting requirements (CTR, EFT, STR).
• Be skilled in conducting UNSCR sanction screenings.
• Understand PEP and UBO guidelines and international sanctions.
• Have knowledge of significant local and international AML case laws.

Target Audience

This course is designed for:

• Compliance officers and professionals in financial institutions.
• Legal professionals specializing in financial regulations.
• Employees of financial regulatory bodies.
• Individuals working in risk management and fraud detection.
• Auditors and accountants seeking to understand AML and CFT regulations.
• Professionals involved in financial services needing to comply with AML and CFT regulations.

Training Outline

1. Customer Due Diligence and Risk Based
2. Compliance With the Reporting Requirements Under The Ftra (Circular 01-2024)
3. CBSL Guideline-03-2019 – PEP
4. CBSL Guideline-04-2018 – UBO
5. Identifying And Avoiding Pyramid Schemes
6. Modern AML Threats & Impact
7. IFSCA Compliance Guideline 

Course Description

This comprehensive course on Employment Law spans 90 hours of theory, practical exercises, and assignments, providing an in-depth understanding of various employment-related legislations and their practical applications. The curriculum covers key acts and ordinances, such as the Employee Provident Fund Act, Industrial Disputes Act, and Minimum Wage Act, along with case studies and practical examples. This course aims to equip participants with the knowledge and skills necessary to navigate and apply employment laws effectively in their professional roles.

Objectives

• To provide a thorough understanding of employment laws and regulations.
• To explain the provisions and implications of key employment-related acts and ordinances.
• To analyze and interpret case law and legal decisions related to employment.
• To develop practical skills in applying employment laws to real-world scenarios.
• To ensure compliance with employment regulations and enhance legal knowledge in the workplace.

Learning Outcome

By the end of this course, learners will:

• Have a comprehensive understanding of major employment laws and their applications.
• Be able to interpret and apply provisions of various employment acts and ordinances.
• Be knowledgeable about the rights and obligations of employers and employees under the law.
• Be capable of resolving industrial disputes and understanding wage control regulations.
• Be skilled in handling employment termination, compensation claims, and retirement-related issues.
• Understand and apply case law and legal precedents in employment matters.

Target Audience

This course is designed for:

• HR professionals and managers responsible for employment law compliance.
• Legal practitioners specializing in labor and employment law.
• Business owners and executives needing to understand employment regulations.
• Employee relations and labor relations specialists.
• Anyone interested in gaining a detailed understanding of employment law.

Certificate in Practical Employment Law 

1. 1.  EPF & ETF Act
2. Shop and Office Employees [Regulation of Employment and Remuneration] Act No 19 of 1954 
3. Maternity Benefits Ordinance – No. 32 of 1939
4. Wages Boards Ordinance No 27 of 1941
5. National Minimum Wage of Workers Act, No. 3 of 2016
6. Gratuity Act No. 12 of 1983
7. Termination of Employment Act No. 45 of 1971 
8. Minimum Retirement Age Act – No 28 of 2021
9. Workmen Compensation Ordinance No. 19 of 1934
10. Trade Unions Ordinance No 14 of 1935
11. Employment of Woman, Young Persons and Children Act No. 47 of 1956
12. Factories Ordinance No 45 of 1942
13. Disciplinary Procedure of Workers
14. Important Case Laws

Course Description

The Six Sigma Black Belt Program is an extensive course designed to provide participants with in-depth knowledge and skills in Six Sigma methodologies, Lean principles, and quality management techniques. Spanning 180 hours of theory, practical application, and assignments each, the program covers the full spectrum of Six Sigma phases—Define, Measure, Analyze, Improve, and Control (DMAIC). Participants will also learn about Lean manufacturing, statistical analysis, design of experiments, and risk mitigation strategies, preparing them to lead quality improvement projects effectively.

Objectives

• To provide a comprehensive understanding of Six Sigma and Lean methodologies.
• To equip participants with the tools and techniques necessary for quality improvement.
• To teach advanced statistical methods for data analysis and process optimization.
• To develop leadership skills for implementing Six Sigma projects and team management.
• To prepare participants for Six Sigma Black Belt certification and practical application in real-world scenarios.

Learning Outcome

By the end of this course, learners will:

• Understand the history and evolution of Six Sigma and Lean manufacturing.
• Be proficient in using Six Sigma tools and techniques across all DMAIC phases.
• Be able to lead and manage Six Sigma projects and teams effectively.
• Have advanced skills in statistical analysis, process capability, and root cause analysis.
• Be capable of designing experiments, implementing Lean principles, and conducting risk analysis.
• Know how to apply control tools and methods to maintain process improvements.
• Be prepared for Six Sigma Black Belt certification.

Target Audience

This course is designed for:

• Quality management professionals and practitioners seeking to deepen their expertise.
• Engineers, project managers, and team leaders responsible for process improvement.
• Business analysts and consultants specializing in operational excellence.
• Individuals aspiring to become certified Six Sigma Black Belts.
• Any professional involved in or interested in implementing Six Sigma and Lean methodologies.

Training Outline

I -MR chart, Run chart, Averages and ranges control charts, Averages and sigma control charts, C chart, U chart, Np Chart, P chart

11.2 Other control tools 

Visual factory, Total Productive Maintenance, MSA, Control Plan, FMEA

12. Design for Six Sigma 

12.1 DFSS – Design For Six Sigma

Course Description

The Six Sigma Green Belt Program is designed to provide participants with a comprehensive understanding of Lean Six Sigma methodologies, focusing on the DMAIC (Define, Measure, Analyze, Improve, Control) framework. Spanning 120 hours of theory, practical application, and assignments each, the program covers essential concepts such as process mapping, value stream mapping, data measurement, and analysis. Participants will learn to identify and reduce waste, improve processes, and maintain quality improvements in their organizations.

Objectives

• To introduce participants to Lean Six Sigma principles and the DMAIC framework.
• To teach techniques for identifying and eliminating waste and non-value-added activities.
• To develop skills in data collection, measurement, and statistical analysis.
• To provide tools for process improvement and control.
• To prepare participants for Green Belt certification in Lean Six Sigma.

Learning Outcome

By the end of this course, learners will:

• Understand the principles and history of Lean Six Sigma.
• Be able to apply the DMAIC framework to real-world projects.
• Identify and reduce waste using Lean principles.
• Collect and analyze data to improve processes.
• Utilize various tools and techniques for process improvement.
• Implement control measures to maintain process improvements.
• Be prepared for Green Belt certification in Lean Six Sigma.

Target Audience

This course is designed for:

• Professionals seeking to improve their skills in process management and quality improvement.
• Individuals responsible for implementing Lean Six Sigma projects within their organizations.
• Managers and team leaders looking to enhance operational efficiency.
• Business analysts and consultants specializing in process improvement.
• Anyone aspiring to become a certified Lean Six Sigma Green Belt.

Training Outline

1. Change management and why it is important to us 
2. What is Lean Six Sigma and the Importance of it 
3. History of Lean Six Sigma its principals 
4. Understanding Waste & Variation 
5. DMAIC Methodology & Tools and Techniques of Lean Six Sigma 
6. Benefits of Lean Six Sigma 

Course Description

The Six Sigma White Belt Program provides an introduction to the fundamental concepts and methodologies of Six Sigma. Over 90 hours each of theory, practical sessions, and assignments, participants will learn the basics of Six Sigma, its importance in improving business processes, and the foundational principles of quality and cost management. The program covers essential topics such as basic statistics, quality tools, Lean thinking, and process improvement techniques.

Objectives

• To introduce participants to the core principles of Six Sigma and Lean methodologies.
• To emphasize the importance of customer focus in business.
• To teach the basics of quality management and cost control.
• To provide an understanding of basic statistical methods used in Six Sigma.
• To familiarize participants with essential quality tools and Lean thinking.
• To outline the Six Sigma project methodology and guidelines for installation.

Learning Outcome

By the end of this course, learners will:

• Understand the importance of Six Sigma and its historical context.
• Recognize the significance of customer focus in business processes.
• Have a foundational knowledge of quality and cost management.
• Be able to use basic statistical tools and understand performance variables.
• Apply quality tools such as brainstorming, process mapping, and cause-and-effect diagrams.
• Identify and eliminate the 7 wastes using Lean thinking principles.
• Implement basic process improvement techniques like the Pull System, Jidoka, and JIT fundamentals.

Target Audience

This course is designed for:

• Beginners who are new to Six Sigma and Lean methodologies.
• Professionals looking to understand the basics of process improvement.
• Individuals interested in quality management and operational efficiency.
• Team members and leaders seeking to enhance their problem-solving skills.
• Anyone aiming to gain a foundational understanding of Six Sigma as a starting point for further certification.

Training Outline

1. Basics of Six Sigma (Class 01)

1.1 Why Six Sigma

1. Requirements as individual
2. Requirements as organization
3. Opportunities in the world of Six Sigma

1.2 History of TPS and Lean

1. When and how those concepts emerged
2. Key contributors
3. Jidoka and JIT as fundamentals
4. Modernization of Six Sigma

1.3 Customer focus

1. Importance of customer focus to business
2. Contrast a conventional project and a six-sigma project

1.4 Quality and cost

1. Definition of quality
2. Relationship between quality and cost

2. Introduction to Six Sigma Yellow Belt project (Class 02)

2.1 Installation guidelines

1. Project roles and responsibilities
2. Nonvalue added process
3. Set up project targets

2.2 Application of projects

1. Project description
2. Project overview
3. Project scope
4. Project leadership
5. Project teams
6. Project financials
7. Project management
8. Project payback
9. Project milestones
10. Project charters

3. Lean Practices (Class 03)

3.1 Introduction to lean concepts

1. Lean Thinking
2. Importance of visual aids

3.2 important lean tools

1. Kanban system
2. Poka-yoke
3. 6S system
4. Identification of 8 wastes
5. Kaizen

4. Quality Tools (Class 04)

4.1 Introduction

4.2 Applications of quality tools

1. Brainstorming
2. Process mapping
3. Cause and effect analysis
4. Pareto charts
5. Run charts
6. Histograms

5. Basic Statistics (Class 05)

5.1 Understanding performance variables

1. Types of variables and relationship to data
2. Statistical notation

5.2 Mathematical approaches

1. Normal distribution
2. Calculations – mean, median, mode
3. Calculation – Standard deviation, variance

5.3 Control methods

1. X bar chart
2. Range chart
3. Defect chart

6. Training Project (Class 06)

1. Recognize phase
2. Project introduction
3. Define phase
4. Measure phase
5. Analysis phase
6. Improvement phase
7. Control phase

Course Description

The Six Sigma Yellow Belt Program offers an introductory yet comprehensive understanding of Six Sigma principles and methodologies. Over 90 hours each of theory, practical sessions, and assignments, participants will explore the significance of Six Sigma in business improvement, learn basic statistical methods, and become familiar with essential quality tools and Lean thinking principles. The program also covers the DMAIC methodology and control methods to sustain process improvements.

Objectives

• To introduce participants to the fundamental principles of Six Sigma and Lean.
• To highlight the importance of customer focus in business processes.
• To teach the DMAIC (Define, Measure, Analyze, Improve, Control) methodology.
• To provide a basic understanding of statistical methods used in Six Sigma.
• To familiarize participants with essential quality tools and Lean thinking.
• To outline control methods for sustaining process improvements.

Learning Outcome

By the end of this course, learners will:

• Understand the importance and principles of Six Sigma and Lean.
• Recognize the role of customer focus in business improvement.
• Have a foundational knowledge of the DMAIC methodology.
• Use basic statistical tools to analyze and improve processes.
• Apply quality tools such as brainstorming, process mapping, and cause-and-effect diagrams.
• Utilize Lean thinking principles to identify and eliminate waste.
• Implement control methods like PDCA and control charts to sustain improvements.

Target Audience

This course is designed for:

• Professionals and team members new to Six Sigma and Lean methodologies.
• Individuals responsible for supporting Six Sigma projects within their organizations.
• Managers and team leaders seeking to enhance their process improvement skills.
• Business analysts and quality improvement professionals.
• Anyone aiming to gain a foundational understanding of Six Sigma and Lean to support further certification.

Training Outline

1. History and basics of Six Sigma (Class 01)

1.1 Why Six Sigma

1. Requirements as individual
2. Requirements as organization
3. Opportunities in the world of Six Sigma

1.2 History of TPS and Lean

1. When and how those concepts emerged
2. Key contributors
3. Jidoka and JIT as fundamentals
4. Modernization of Six Sigma

1.3 Five Lean Principles

1. Introduction of Muda, Mura, Muri
2. Explanation of five lean principles

2. Breakthrough vision and business principles (Class 02)

2.1 Customer focus

1. Importance of customer focus to business
2. Contrast a conventional project and a six-sigma project

2.2 Tool selection

1. Basic cause and effect relationship (y=mx)
2. Primary tools to be used in a six-sigma project
3. Logic of DMAIC improvement process

2.3 Quality and cost

1. Definition of quality
2. Relationship between quality and cost

3. Process management (Class 03)

3.1 performance yield

1. Nonvalue added processes

3.2 Importance of measurements and measuring systems

1. Establish performance baselines and benchmarks
2. Understanding defect opportunities

Course Description:

This online course focuses on data analysis and business intelligence using Power BI tools. Students will learn how to collect, process, and analyze data, as well as create reports and dashboards for business insights.

Objectives:

• Students will gain skills in handling raw data sets.
• They’ll learn to create data analysis models.
• Developing interactive reports and dashboards using Power BI is a key objective.

Learning Outcome:

• By the end of the course, students should be proficient in Power BI tools.
• They’ll be able to work with raw data and create insightful reports.

Target Audience:

• Professionals are interested in data science and business analytics.
• Anyone needing to use Power BI for data analysis in a business context.

Training Outline:

1 Introductions

1. Business Analysis
2. ERP & Role In The Business Analysis
3. Traditional BI and Self-Service BI
4. Introduction To The Microsoft Power BI – Desktop
5. Power BI Architecture
6. Introducing the Course Project

2 Connect & Transform the Raw Data

1. Intro to the Power BI Query Editor
2. Types of Power BI Data Connectors
3. Basic Table Transformations
4. Text, Number & Date Tools
5. Index & Conditional Columns
6. Grouping & Aggregating Data
7. Pivoting & Unpivoting
8. Modifying, Merging & Appending Queries
9. Connecting to Folders
10. Defining Hierarchies & Categories
11. Query Editing & Power BI Best Practices

3 Build a Relational Data Model

3.1 Intro to Database Normalization

3.2 Data Tables vs. Lookup Tables

3.3 Creating Power BI Table Relationships

3.4 “Star” vs. “Snowflake” Schemas

3.5 Active vs. Inactive Relationships

3.6 Relationship Cardinality

3.7 Connecting Multiple Data Tables

3.8 Filtering & Cross-Filtering

3.9 Hiding Fields from the Power BI Report View

3.10 Data Modeling & Power BI best Practices

4 Add Calculated Fields with DAX

1. Intro to Data Analysis Expressions (DAX)
2. Calculated Columns vs. Measures
3. Row Context vs. Filter Context in Power BI
4. DAX Syntax & Operators
5. Common Power BI Functions
6. Basic Date & Time Formulas
7. Logical & Conditional Statements
8. Text, Math & Stats Functions
9. Joining Data with RELATED
10. CALCULATE, ALL & FILTER Functions
11. DAX Iterators (SUMX, AVERAGEX)
12. Time Intelligence Formulas
13. DAX & Power BI Best Practices

05 Design Interactive Power BI Reports

1. Intro to the Power BI Report View
2. Adding Basic Charts to Power BI Reports
3. Formatting & Filtering Options
4. Matrix Visuals
5. Slicers & Timelines
6. Cards & KPIs
7. Power BI Map Visuals (Basic, Fill, ArcGIS)
8. Tree maps, Lines, Areas & Gauges
9. Editing Report interactions
10. Adding Drillthrough Filters
11. Linking to Report Bookmarks
12. Using “What-If” Parameters
13. Managing & Viewing Roles
14. Power BI Data Viz Best Practices

06 Publish Power BI Dashboard

1. Power BI Mobile App
2. Power BI Services

07 Case Study – Individual Assignment

Course Description

The Professional Diploma in Customs Procedures & Duty Calculations is an extensive program that delves into the mechanisms and regulations governing border management and customs operations. It covers the entire spectrum of customs activities, including the legal framework, revenue collection, trade facilitation, and compliance enforcement. The course is tailored to provide participants with practical insights into import and export procedures, the classification of goods using the Harmonized System, and the application of customs laws and regulations. Emphasizing Sri Lanka’s customs system, the program also contextualizes global customs practices to prepare participants for handling international trade operations effectively.

Key Topics Covered:

• Border Management Concepts
• Sri Lanka Customs Legal and Operational Framework
• Customs Procedures for Imports and Exports
• Harmonized Commodity Description and Coding System (HS Code)
• Practical Customs Operations and Documentation

Objectives

The primary objectives of this diploma course are to:

• Equip participants with a thorough understanding of customs procedures and border management.
• Provide detailed knowledge of the customs regulatory framework and its application in Sri Lanka.
• Develop skills for accurate duty calculations and efficient handling of import/export processes.
• Enhance the ability to navigate customs laws, regulations, and international trade requirements.
• Prepare participants for roles in customs brokerage, compliance, and trade facilitation.

Learning Outcomes

Upon completing the course, participants will be able to:

• Understand and explain the importance and principles of border management.
• Identify and categorize different types of goods for customs purposes accurately.
• Navigate the legal and procedural framework of Sri Lanka Customs.
• Perform customs duties and calculations with proficiency.
• Execute import and export procedures, ensuring compliance with legal and regulatory requirements.
• Utilize the Harmonized System for the classification of goods in international trade.
• Engage effectively with customs agencies and manage documentation for customs processes.
• Address and resolve issues related to customs inquiries, penalties, and litigations.

Target Audience

This diploma is ideal for individuals seeking to specialize in customs and international trade. It is particularly suitable for:

• Professionals working in customs brokerage or import/export businesses.
• Trade compliance officers and customs agents.
• Logistics and supply chain managers involved in cross-border trade.
• Legal professionals and consultants specializing in customs and trade law.
• Business owners and managers looking to expand their operations internationally.
• Government officials and employees of border control agencies.
• Graduates aiming to enter the field of customs and international trade.

1. The concept of Border Management

1. Types of borders and how borders are defined 
2. What is border management
3. Why border management is necessary
4. Agencies responsible to regulate the borders
5. Categorisation of goods for Customs purposes

2. Sri Lanka Customs and other border control agencies

1. History of Customs in Sri Lanka
2. Legal frame work and structure of Sri Lanka Customs 
3. Functions of Sri Lanka Customs
4. Collection of Revenue and Social Protection
5. Trade facilitation

3. Customs Law of Sri Lanka

1. Customs Ordinance and regulations published thereunder
2. Customs investigations and Customs Inquires
3. Forfeitures and penalties 
4. Recovery and prosecutions
5. Appeals and litigation against Customs
6. Revenue law and regulations published thereunder
7. Social protection law and regulations published thereunder

4. Customs Import Procedure

1. Registration with Customs
2. Types of imports
3. Documents required to import
4. Clearance of FCL through Customs
5. Clearance of LCL through Customs

5. Customs Export Procedure

1. Registration with Customs
2. Types of Exports
3. Documents required to export
4. Clearance of exports through Customs

6. Classification of Goods in International Trade

1. World Customs Organization 
2. Harmonized Commodity Description and Coding System
3. Implementation of Harmonized System in Sri Lanka
4. Structure of HS Code
5. General Rules for the Interpretation of the Harmonized System
6. Explanatory Notes to the Harmonized System and other guides

7. Valuation of Goods in International Trade

1. World Trade Organization
2. WTO Valuation Agreement
3. Implementation of WTO Valuation Agreement in Sri Lanka
4. Six methods for the determination of Customs Value
5. Adjustments to the price actually paid or payable 

8. Computation of Import Levies

1. Introduction
2. Computation of Customs Duty
3. Computation of Value Added Tax (VAT)
4. Computation of Excise (Special Provision) Duty
5. Computation of CESS
6. Computation of other taxes

Course Description

This comprehensive PMP course offers an in-depth exploration of project management principles, techniques, and tools based on the PMBoK Guide by the PMI (Project Management Institute). It includes a blend of theoretical knowledge, practical skills, and hands-on assignments, covering the core processes and methodologies essential for managing projects effectively. Topics span from introductory concepts in project management to specialized areas like project risk and stakeholder management. The course is structured to support both traditional (predictive) and modern (adaptive/agile) project management practices, making it suitable for diverse project environments.

Key Components:

• Introduction to Project Management
• Project Environment and Organizational Structures
• Roles and Responsibilities of a Project Manager
• Comprehensive coverage of PMBoK Guide knowledge areas
• Emphasis on both predictive and adaptive project management methods

2. Objectives

The primary goal of the PMP course is to equip participants with the necessary skills and knowledge to become proficient project managers and to prepare them for the PMP certification exam. The course aims to:

• Provide a thorough understanding of the PMBoK Guide and its application.
• Develop competency in managing project integration, scope, schedule, cost, quality, resources, communication, risks, procurement, and stakeholders.
• Enhance practical skills through real-world assignments and case studies.
• Foster the ability to adapt project management approaches to different environments and organizational needs.
• Prepare participants to meet the PMP certification requirements and succeed in the PMP exam.

3. Learning Outcomes

Upon completing this course, participants will be able to:

• Demonstrate a deep understanding of project management concepts and PMBoK knowledge areas.
• Apply project management techniques effectively in both predictive and adaptive project environments.
• Develop comprehensive project plans addressing scope, time, cost, quality, and risk management.
• Manage project teams and stakeholders efficiently, ensuring clear communication and resource allocation.
• Evaluate and implement project procurement strategies and understand contract management.
• Use project management tools and methodologies to lead projects to successful completion.
• Be fully prepared to take and pass the PMP certification exam.

4. Target Audience

This PMP course is tailored for individuals who are looking to advance their careers in project management or those seeking to formalize their project management skills through certification. It is ideal for:

• Aspiring project managers looking to gain foundational knowledge and certification.
• Experienced project managers aiming to update and formalize their skills with the PMP credential.
• Professionals from various industries such as IT, construction, healthcare, and finance who manage projects.
• Team leaders, coordinators, or any professionals involved in managing project activities.
• Individuals seeking to understand project management principles and apply them effectively in their work.

Training Outline

1. Introduction to Project Management.  
2. Project Environment and Organization Structure.  
3. Role of a Project Manager. 
4. Predictive Project Management 
5. Adaptive Project Management.  
6. Project Integration Management.
7. Project Scope Management. 
8. Project Schedule Management. 
9. Project Cost Management. 
10. Project Quality Management. 
11. Project Resource Management. 
12. Project Communication Management. 
13. Project Risk Management. 
14. Project Procurement Management. 
15. Project Stakeholder Management. 

Course Description

The Shipping, Freight Forwarding & Clearing Course offers a detailed exploration of the logistics and operational aspects involved in transporting goods by air and sea. The curriculum covers the fundamental principles and practical processes of freight forwarding and clearing, emphasizing both the theoretical underpinnings and the real-world application. Participants will learn about the various documents required, methods used in shipping and forwarding, and the associated risks and mitigation strategies. The course also includes case studies to illustrate practical scenarios and enhance problem-solving skills. This course is designed to equip learners with the knowledge and skills to efficiently manage and execute shipping and logistics operations in a global context.

Key Topics Covered:

• Introduction to Freight Forwarding and Shipping
• Detailed Procedures for Freight Forwarding and Clearing by Air and Sea
• Documentation and Compliance in Shipping and Freight Forwarding
• Risk Management and Mitigation Strategies
• Practical Case Studies

Objectives

The primary objectives of this course are to:

• Provide an in-depth understanding of shipping, freight forwarding, and clearing processes.
• Equip participants with the skills to manage and execute logistics operations for air and sea freight.
• Familiarize participants with the essential documentation and regulatory requirements in international shipping.
• Develop the ability to identify, assess, and mitigate risks associated with freight forwarding and shipping.
• Enhance practical problem-solving abilities through the analysis of real-world case studies.

Learning Outcomes

Upon completion of this course, participants will be able to:

• Understand and explain the roles and processes involved in shipping and freight forwarding by air and sea.
• Accurately prepare and manage the required documentation for freight forwarding and shipping.
• Apply effective methods for the clearing of goods through customs and other regulatory bodies.
• Identify common risks in shipping and freight forwarding and implement strategies to mitigate these risks.
• Analyze and solve logistics challenges using knowledge gained from case studies and practical scenarios.
• Effectively manage and coordinate international logistics operations ensuring compliance and efficiency.

Target Audience

This course is ideal for individuals seeking to gain expertise in shipping and logistics. It is particularly suitable for:

• Logistics and supply chain professionals looking to enhance their knowledge in shipping and freight forwarding.
• Aspiring freight forwarders and clearing agents.
• Business owners and managers involved in international trade and logistics.
• Import/export coordinators and shipping clerks.
• Professionals in the transportation industry seeking to broaden their operational skills.
• Students and graduates aiming to enter the field of logistics and international trade.

Training Outline

1. Introduction to Freight Forwarding & Shipping 
2. Freight Forwarding & Clearing (Air & Sea) 
3. Documents used
4. Methods used
5. Risks Involved and How to mitigate them
6. Case studies
7. Shipping (Air & Sea) 
   1. Documents used
   2. Methods used
   3. Risks Involved and How to mitigate them
   4. Case studies

Course Description

The Practical Taxation with Returns eFiling course is designed to provide a thorough grounding in the principles and practices of taxation in Sri Lanka. Covering the complete spectrum of tax-related topics, from the basics of tax laws to advanced aspects of tax calculations and returns filing, this course is ideal for those seeking a practical understanding of the taxation system. Participants will learn about the various types of income subject to tax, the procedures for calculating tax liabilities, and the legal and administrative frameworks governing taxation. Emphasis is placed on hands-on practice in filing tax returns electronically, using the latest online platforms provided by the Inland Revenue Department (IRD). This course aims to equip learners with the knowledge and skills required to manage tax compliance effectively for individuals, partnerships, and companies.

Key Topics Covered:

• Introduction to Taxation and Tax Principles in Sri Lanka
• Detailed Examination of Taxable Income Sources
• Procedures for Registration and Calculation of Different Types of Income
• Practical Applications of Tax Deductions, Credits, and Payments
• Comprehensive Overview of Online Tax Return Filing and e-Services
• Legal and Administrative Aspects of Tax Compliance

Objectives

The main objectives of this course are to:

• Provide a comprehensive understanding of the taxation system in Sri Lanka, including tax laws and regulations.
• Develop practical skills in calculating various types of tax liabilities and understanding allowable and disallowable deductions.
• Equip participants with the ability to file tax returns electronically and navigate the online tax payment platforms.
• Enhance knowledge of the administrative provisions related to tax returns, assessments, and appeals.
• Prepare participants to handle the procedural and compliance aspects of tax administration effectively.

Learning Outcomes

Upon successful completion of this course, participants will be able to:

• Understand and apply the principles of taxation in Sri Lanka.
• Identify and classify various sources of income and their tax implications.
• Calculate assessable and taxable income for individuals, partnerships, and companies.
• Utilize tax tables and tools to compute personal and business income taxes.
• File tax returns accurately using the IRD’s online platforms and understand the submission process.
• Navigate the legal framework surrounding tax administration, including assessments, penalties, and appeals.
• Manage self-assessment tax payments and handle the collection procedures.
• Provide advice and support as authorized representatives, tax agents, or approved accountants.

Target Audience

This course is ideally suited for:

• Tax professionals and consultants seeking to enhance their knowledge and skills in practical taxation and e-filing.
• Accountants and finance managers responsible for managing tax compliance within organizations.
• Business owners and entrepreneurs who need to understand their tax obligations and the e-filing process.
• Individuals working in or aspiring to work in the fields of finance, accounting, or taxation.
• Students and graduates aiming to build a career in taxation or financial services.
• Legal professionals and consultants who advise clients on tax matters and compliance.

Training Outline

Session 1

Session 2

1. Introduction to employment income
2. Exempt employment income
3. Value of non-cash benefits
4. Advance Personal Income Tax (APIT)
5. Usage of APIT tables
6. Calculation of Assessable employment income

Session 3

1. Introduction to investment income
2. Calculation of Capital Gain/ Capital Gain Tax
3. Exempt investment income
4. Final Withholding Tax
5. Non-final WHT/Advance Income Tax (AIT)
6. WHT refund scheme for senior citizens

Session 4

1. Introduction to business income
2. Allowable deductions
3. Disallowable deductions
4. Calculation of the capital allowance
5. Calculation of the Assessable charge/balancing allowance
6. Exempt business income
7. Calculation of the assessable business income using final accounts (individuals/partnerships/Companies)

Session 5

1. Qualifying payments
2. Reliefs
3. Income tax calculation (Individuals/Partnerships/Companies)
4. Tax credit
5. Self Assessment tax payments
6. Statement of Estimated Tax (SET)
7. Online Tax Payment Platform

Session 6

1. Administration provisions of Inland Revenue Act
2. Returns
3. Assessments
4. Appeals
5. Collection procedure
6. Penalties

Sessions 7 & 8

1. Value Added Tax (VAT)

Session 9 – eServices

1. IRD web site
2. Introduction to e-services
3. Online return filling
4. Other e-services provided by IRD

Session 10 & 11 – eReturns Filing 

1. Calculation of Income tax liability (Individuals/partnerships/companies)
2. Filing of returns
3. Submission of returns on-line

Session 12 – Administration Provision 

1. Assessments
2. Penalties
3. Administrative reviews and appeals
4. Recovery procedure
5. Authorized representatives
6. Tax agents
7. Approved accountants

Course Description

The Treasury Management & Financial Markets course is an extensive program aimed at equipping participants with a robust understanding of how financial markets operate and the strategic role of treasury management. The course covers various types of financial markets, including money markets, capital markets, and foreign exchange markets, alongside an introduction to derivatives and futures. Participants will delve into the mechanisms of equity and fixed income securities, and the distinctions between debt and equity financing. The course also focuses on treasury management principles, including the objectives, functions, and best practices of treasury departments, and explores investment strategies, risk management, and financial planning. Additionally, the course addresses regulatory aspects and the importance of compliance in financial operations.

Key Topics Covered:

• Overview of Financial Markets and their Instruments
• Principles and Practices of Treasury Management
• Investment Strategies and Risk Management in Treasury
• Functions of Treasury Operations: Middle and Back Office
• Comprehensive Financial Planning and Portfolio Management
• Regulatory Framework and Compliance in Financial Markets

Objectives

The primary objectives of this course are to:

• Provide a comprehensive understanding of the structure and functioning of financial markets.
• Equip participants with the skills to effectively manage treasury operations within an organization.
• Develop expertise in investment strategies and risk management in various market conditions.
• Enhance knowledge of financial planning, portfolio management, and tax planning.
• Ensure a thorough understanding of regulatory issues and compliance in financial markets.

Learning Outcomes

Upon successful completion of this course, participants will be able to:

• Understand and navigate primary, secondary, and over-the-counter (OTC) financial markets.
• Analyze and utilize different money market and capital market products.
• Develop investment strategies in fixed income and equity markets, understanding the trade-offs between debt and equity financing.
• Manage foreign exchange (FX) transactions and mitigate risks in derivative and futures markets.
• Comprehend the functions and objectives of the treasury department and implement best market practices.
• Formulate and execute investment strategies tailored to various market conditions.
• Identify and mitigate risks associated with treasury operations.
• Manage the middle and back office functions efficiently.
• Plan and manage investments, including collective investment schemes and retirement planning.
• Navigate the regulatory environment concerning financial markets, including compliance with money laundering, insider dealing, and corporate governance regulations.

Target Audience

This course is ideally suited for:

• Financial professionals and managers involved in treasury and financial market operations.
• Aspiring treasury analysts and financial market traders.
• Corporate finance professionals responsible for managing company finances and investments.
• Investment managers and portfolio analysts seeking to deepen their understanding of financial markets.
• Business graduates and students aiming to enter the fields of treasury management or financial markets.
• Risk management professionals focused on financial markets and treasury operations.
• Individuals involved in compliance and regulatory roles within financial institutions.

Course Outline:

1. Financial Markets
   1. Primary/Secondary/OTC/Exchange Traded Markets
   2. Money market products
   3. Capital Market products
   4. Fixed income securities
   5. Equity market & investment strategies
   6. Debt vs Equity 
   7. FX Markets
   8. Introduction to Derivative & Futures Markets
   9. Commodity Market
2. Treasury Management
   1. Introduction
   2. Objective of Treasury Department
   3. Functions of Treasury
   4. Best market practices of Treasury
   5. Treasury Policies
   6. Investment Strategies in different market conditions
3. Treasury Risk Management
   1. Risks involved in Treasury and mitigation methods
   2. Functions of Middle Office
   3. Functions of Back Office
4. Investment Management & Planning
   1. Collective Investment Schemes
   2. Financial Planning
   3. Portfolio Mix
   4. Tax planning
   5. Insurance Planning
   6. Retirement Planning
5. Financial Markets Regulations
   1. Money Laundering
   2. Insider Dealing
   3. Corporate Governance