On course for success

Technical

Advanced Microsoft Excel [VILT]

Programme Overview

This course introduces Microsoft Excel users to the advanced features of the software application, in addition to the usual features such as creating and editing charts; modifying chart options; working with multiple worksheets and workbooks and use financial and logical functions. Participants will earn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables. In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.

Who Should Attend

Anyone whose chosen field of work requires the involvement of extensive and detailed use of the more complex MS Excel skills and functions.

Programme Objectives

By the end of the Advanced Microsoft Excel training course, participants will be able to use Microsoft Excel’s in-built features to import, analyse and present their data. The training is hands-on. Theory is introduced only as far as is required for practical application.

Participants are expected to follow-along with the guided examples in the training manual as well as complete all assigned exercises. While participants are expected to perform all tasks themselves, they are encouraged to discuss possible solutions amongst themselves to support individual learning.

Participants are encouraged to share actual problems they face in using Microsoft Excel in their daily work. In this way practical solutions can be created and shared with the entire class. A digital training manual will be provided provided. Participants are encourage to print a hard-copy if it will support their learning. Digital exercise files will also be provided.

Programme Outline

Modules Programme Description
Introduction to Power Query Learn how to use Microsoft Excel’s newest an most exciting tool to import and transform frequently changing data from external sources.
Data Tools Learn the tools that Excel provides to help clean your data including automatically splitting into columns, intelligence-based automatic pattern filling and data validation.
Data Analysis with PivotTables Deepen your knowledge of PivotTables by learning different ways you can summarize an
present the PivotTable data
Logical Functions A revision on the IF(), OR() and AND() functions
Text functions A revision on PROPER(), UPPER(), LOWER(), CONCAT()/CONCATENATE(), LEFT(), RIGHT(), MID(). Learn about LEN(), FIND(), SEARCH(), REPLACE(), SUBSTITUTE()
Formula Auditing Learn how to investigate why your functions and formulas are displaying errors.
Nested Functions A powerful technique involving using functions within other functions.
Conditional Formatting

Learn how to make specific data stand out using a variety of colour formatting, data bars and icons.

Goal Seek & Scenarios Learn how Excel can help you handle what-if situations to display the possible data you need.
Forecast Sheet Apply Excel’s powerful forecast functionality to statistically predict future data.

Programme Delivery

Date Time
20 June 20222 (Day 1)  

8:30 am - 12:00 pm

 

21 June 2022 (Day 2)
22 June 2022 (Day 3)
23 June 2022 (Day 4)

Your Investment

Package Stakeholder Non Stakeholder
Normal Price $490 (10% SBS) $500

Download Brochure here

Data Privacy Principles and Practices

Programme Overview

This programme will help you to develop the necessary knowledge, skills, and competence to effectively implement and manage a compliance framework on the protection of personal data. It will also cover the requirements to fulfill the role of Data Protection Officer (DPO) under the Data Privacy Practice as well as relevant regulations, including implementation requirements, necessary policies and processes, and important elements of effective data security management.

Who Should Attend

This programme is suitable for Officers or Senior officers who wish to have a quick and solid foundation in the area of data protection and privacy laws. These include professionals from Data Privacy, IT, Risk Management and Compliance departments.

Programme Objectives

By the end of this programme, participants will be able to:

  • Understand all aspects of Data Privacy Principles and Practices in detail;
  • Learn all essential Data Protection Officer (DPO) skills including, data protection impact assessments, and privacy impact assessments;
  • Acquire the necessary expertise to support an organisation in assessing the implementation of these new requirements; and
  • Learn the relevant processes to manage a team implementing the General Data Protection Regulation (GDPR).

Programme Outline

  • Introduction to Data Privacy Principles and Practices
  • Understand the Principles and Practices
  • Data Protection Officer
  • Understanding the General Data Protection Regulation (GDPR)
  • Implementation and Monitoring of Data Regulations

Programme Delivery

Date Time
20 June 20222 (Day 1)

1:30 pm - 5:00 pm

21 June 2022 (Day 2)
23 June 2022 (Day 3)

Your Investment

Package Stakeholder Non Stakeholder
Normal Price $900.00 (10% SBS) $1,100.00

Download Brochure here

Credit Risk Management

Programme Overview

Effective credit risk management is not only necessary to remain compliant in what has become a highly regulated environment, but it can offer significant business and competitive advantages if done correctly. This course is designed to cover various strategies and techniques for effective credit risk management. Starting with an understanding of the core credit risk philosophies, target market criteria as well as credit risk management frameworks. You will also learn credit risk rating and other practical and important considerations for corporate credit risk management practices.

Programme Outline

  1. Introduction – An overview of Corporate Credit Risk Management
  2. Credit Risk Management and Business
  3. Credit Risk Management Framework
  4. Credit Risk Management in Practice
  5. Corporate Credit Risk Management – Other considerations

Who Should Attend

This course is suited for:

  • New hires and management associates in banking (both conventional and Islamic);
  • Professionals in banking and corporate responsible for extending credit to borrowers/customers; and
  • Sales, relationship managers, product specialists and those in support functions, looking to deepen understanding of corporate credit risk

    Programme Delivery

    Date Time
    29 June 2022 9:00 AM – 12:00 PM & 2:00 PM – 5:00 PM
    30 June 2022

    Your Investment

    Package Stakeholder Non Stakeholder
    Normal Price $1,400(SBS 20%) $1,800

    Download Brochure here

    Root Cause Analysis

    Programme Overview

    Root Cause Analysis (RCA) is a method that is used to deal with a problem, error or failure by finding the ‘origin of problem’. This course is designed to help the employees to find out the root cause of any problems and fix it so that the problem does not repeat. This course lays emphasis on long-term focus attitude towards problem solving as shortterm focus does not help organisation in terms of profitability or growth. After joining this course, the participant will know why it is important to analyse the root cause of any problems and how important it is. The content is very crisp and short and it will help the reader in a great way to solve all the issues in the organisation.

    Programme Objectives

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

    • Get a clear idea of What is RCA;
    • Understand the importance of RCA;
    • Learn how to Use RCA for Boosting Productivity;
    • Understand the difficulties in RCA;
    • Learn effective RCA;
    • Analyse the root cause of any problems and how important it is; and
    • Solve all the issues in the organisation.

    Who Should Attend

    This programme is suitable for:

    • Managers;
    • Supervisors;
    • Project Leaders;
    • General Workforce;
    • Management Consultants;
    • Operations Department; and
    • Individuals who seek to learn on finding the origin of a problem.

    Programme Delivery

    Day Time
    18 July 2022 8:30 AM – 11;45 AM

    Your Investment

    Package Stakeholder Non Stakeholder
    Normal Price $290.00 (SBS 3%) $290.00

    Download Brochure here

    Liquidity Risk Management

    Programme Overview

    Liquidity risk is one of the main drivers of the 2008 global financial crisis. This course will give an overview of the challenges of managing liquidity risk as well as recommendations to address this important risk and how we an organization help to manage and reduce it, during normal times and with the challenges of COVID-19. This course is designed to cover the liquidity management lessons learned from the past crisis and how we can avoid making the same mistakes. It uses a structured approach to assess liquidity risk management, asset and liability management, and funding strategy.

    Understand how banks forecast, control and stress-test their liquidity sources and uses (on and off balance sheet) and build a contingency funding plan to address stress cash outflows, including how they are managing the challenges of cash flow to the COVID-19 crisis. Participants will also learn how to identify banks with weak liquidity and contingency planning within the context of the bank’s role within the financial system and develop knowledge of regulations and supervisory guidance on the management of bank liquidity

    Who Should Attend

    This programme is suitable for Officers or Senior officers who wish to have a quick and solid foundation in the area of data protection and privacy laws. These include professionals from Data Privacy, IT, Risk Management and Compliance departments.

    Who Should Attend

    This programme is suitable for anyone wishing to expand their knowledge of Fund Regulation and Reporting, including Compliance Officers and anyone working at Depositaries, Fund Administrators, and Asset Managers involved in Regulatory Reporting. It is also targeted anyone who is responsible for managing liquidity risk.

    Programme Delivery

    Date Time
    20 July  2022 (Day 1)

    9:00 AM - 12:00 PM

    & 2:00 PM - 5:00 PM

    21 JuLY 2022 (Day 2)

    Your Investment

    Package Stakeholder Non Stakeholder
    Normal Price $1000 (20% SBS) $1,250.00

    Download Brochure here

    ▲ Top