Welcome to the Anti Money Laundering Training.

The course is subdivided into sections that explain better the process of AML and how to prevent it.

Initial final draft - v0.1   --- REVIEWED

2nd final draft - v0.2 --- PUBLISHED INTERNALLY (SCRIPT FORWARDED TO MAPFRE)

3rd final draft - v0.3 --- PUBLISHED INTERNALLY

4th final draft - v0.4 --- PUBLISHED and REVIEWED INTERNALLY

Final voice over recording - planned after script feedback from MAPFRE

5th final draft - v0.5 --- PUBLISHED INTERNALLY

Objectives

By the end of this course candidates will master the techniques of using the right excel tools to solve problems more efficiently. Also new features in the current Excel version will be highlighted.

Topics covered include Conditional Formatting wizard, Flash Fill, Name Manager, various functions (string, maths, logical, lookup), pivot tables, slicers and pivot charts to build a BI dashboard.

Having practiced all of these new skills extensively during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more proficiently.

Training Methodology

We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our delegates and can be applied directly in the training. Training sessions are conducted as hands-on workshops.

Each delegate will be given a digital courseware manual to refer to after the course.

Course Outline

Apply Fill Tools, Conditional Formatting and Filtering

• Using advanced Fill Series options
• Flash Fill
• Apply advanced conditional formatting and filtering
• Creating filters
• Managing conditional formatting rules
• Conditional Formatting with Sorting & Filtering

Working with Data

• Getting External Data
• Restricting Cell Entries to Certain Data Types
• Data Validation Tools
• Removing Duplicate Rows from a Worksheet
• Sorting Data on a Single & Multiple Criteria
• Sorting Data Using Cell Attributes
• Using AutoFilter
• Filtering Data Using Cell Attributes
• Removing Duplicates in a Table

Using Formulas

• Apply functions in formulas
• Functions Wizard
• Absolute vs Relative Referencing
• Using SUM, COUNT, SUBTOTAL
• Using nested functions
• Using the IF, AND, and OR functions
• Using the VLOOKUP function
• Using the NOW and TODAY functions
• Using text manipulation functions like LEFT, RIGHT, MID, TRIM, CONCATENATE

Data Analysis & and Manipulation using PivotTables & PivotCharts

• Create and manage PivotTables
• Modifying field selections and options
• Filters in PivotTables
• Creating slicers
• Create and manage PivotCharts
• Manipulating options in existing PivotCharts 
• Multiple PivotTables on same Sheet
• Applying styles to PivotCharts
• Building a BI Dashboard

Welcome !

We would like to thank you for registering to the Webinar: COVID-19: Challenges and opportunities for SMEs

On this page you will find relevant links to the elearns that look into the various aspects discussed during the webinar.

We hope you will find the elearns of interest.

Test Space for SCORM Packages

Testing Auto Enrollment

Short course for General Data Protection Regulation, abridged and suitable for ages 8 and upwards

General Data Protection Regulation eLearning

Course Overview

The ISO 27001 Lead Auditor course is a PECB (Professional Evaluation and Certification Board) official course. The three-day intensive course will help you develop the skills needed to audit an Information Security Management System (ISMS). You'll also be able to manage a team of auditors, by applying widely-recognised audit principles, procedures and techniques.

PECB is officially accredited under ISO 17024 from ANSI. They are the first personnel certification body to be accredited by a National Accreditation Authority.

You will gain the skills and knowledge needed to plan and perform audits, compliant with the certification process of the ISO/IEC 27001:2013 standard. Through practical exercises, you will learn the following skills:

• Mastering audit techniques
• Managing audit teams and audit program
• Communicating with customers
• Conflict resolution

Course outline

You will learn the following content:

• Normative, regulatory and legal framework related to information security
• Fundamental principles of information security
• ISO 27001 certification process
• Information Security Management System
• Detailed presentation of the clauses 4 to 8 of ISO27001

Planning and Initiating an ISO 27001 audit

• Fundamental audit concepts and principles
• Audit approach based on evidence and on risk
• Preparation of an ISO 27001 certification audit
• ISMS documentation audit
• Conducting an opening meeting

Conducting an ISO 27001 audit

• Communication during the audit
• Audit procedures: observation, document review, interview, sampling techniques, technical verification, corroboration and evaluation
• Audit test plans
• Formulation of audit findings
• Documentating non-conformities

Concluding and ensuring the follow-up of an ISO 27001 audit

• Audit documentation
• Quality review
• Conducting a closing meeting and conclusion of an ISO 27001 audit
• Evaluation of corrective action plans
• ISO 27001 surveillance audit
• Internal audit management program

Exam track 

You'll take the ISO/IEC 27001 Lead Auditor exam as part of the course.

You will also get one year free PECB membership, and be able to apply for the following titles depending on your experience:

• Certified ISO/IEC 27001 Provisional Auditor
• Certified ISO/IEC 27001 Auditor
• Certified ISO/IEC 27001 Lead Auditor

Learning objectives

Participants will gain the knowledge to conduct internal or external audits of an Information Security Management System, either as a sole auditor, a member of an audit team, or as the team leader. Specifically, you will:

• Learn how to plan and carry out an ISO 27001:2013 audit
• Learn report writing and how to document an Information Security system
• Recognise the role of the auditor
• Understand, and be able to implement processes within the Information Security management system
• Be able to improve your organisations conformance with ISO/IEC 27001:2013
• Learn how to identify gaps in an Information Security management system
• Satisfy training needs for Exemplar Global certification

Prerequisites 

It is recommended that you have already attended Information Security Management System (ISMS) Foundation training, or have a basic knowledge of ISO/IEC 27001:2013 and ISO/IEC 27002:2013.

Prior to attending the course, you must also have:

• 5 years of professional experience
• 2 years of security experience
• 300 hours audit activity
• Professional references proving your experience

What’s included

• The Information Security Management System (ISMS) implementation methodology
• Student manual - containing over 400 pages of information and practical examples
• Certificate - worth 31 CPE (Continuing Professional Education) credits
• Courseware
• Up-to 12 hours of instructor-led training each day
• 24-hour lab access
• Hands-on training through Lecture | Lab | ReviewTM
• Digital courseware (if available)

This cyber security course immerses the students into an interactive environment where they are shown how to scan, test, hack and secure their own systems - ethically. The lab intensive environment gives each student in-depth knowledge and practical experience with the current essential cyber security systems.

Students begin by understanding how perimeter defences work and how to scan and attack their own networks, no real network is harmed. Finally, students then learn how intruders escalate privileges and what steps can be taken to secure a system.

Course outline

• Introduction to Ethical Hacking
• Footprinting and reconnaissance
• Scanning networks
• Enumeration
• System hacking
• Malware Threats
• Evading IDS, Firewalls and Honeypots
• Sniffers
• Social engineering
• Denial of Service (DoS)
• Session hijacking
• Hijacking webservers
• Hacking web applications
• SQL injection
• Hacking wireless networks
• Hacking Mobile Platforms
• Cloud Computing
• Cryptography

Prerequisites

• Knowledge of TCP/IP
• Basic knowledge of Information Systems
• Basic knowledge of Networking

Who should attend?

• IT Security Officers
• Auditors
• Security professionals
• Site Administrators
• Anyone who is concerned about the integrity of the network infrastructure

Learning outcomes

By the end of this course, students would be able to understand:

• Key issues plaguing the information security world, incident management process, and penetration testing
• Various types of footprinting, footprinting tools, and countermeasures
• Network scanning techniques and scanning countermeasures
• Enumeration techniques and enumeration countermeasures
• System hacking methodology, steganography, steganalysis attacks, and covering tracks
• Different types of Trojans, Trojan analysis, and Trojan countermeasures
• Working of viruses, virus analysis, computer worms, malware analysis procedure, and countermeasures
• Packet sniffing techniques and how to defend against sniffing
• Social engineering techniques, identify theft, and social engineering countermeasures
• DoS/DDoS attack techniques, botnets, DDoS attack tools, and DoS/DDoS countermeasures
• Session hijacking techniques and countermeasures
• Different types of webserver attacks, attack methodology, and countermeasures

Overview

• Understand the history, role and structure of the standard-setter, the International Accounting Standards Board (IASB)
• Comprehend the objectives and concepts of financial reporting
• Identify the different steps in the standard-setting process
• Understand IFRS and its applicability in a worldwide context

 

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

Understand the difference between measurement at amortised cost and at fair value.

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

Overview

• Understand the importance of the concept of derecognition of financial instruments for banks
• Recognise for which balance sheet line items is the concept of derecognition of financial instruments applicable

 

Detailed Objectives

•Obtain understanding of applying the concept of derecognition in the case of factoring transaction

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

• Covering the definition of a financial instrument and a derivative
• Covering the scope of IAS 32 and 39.
• Testing the gained knowledge through exercises and questions.

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

• Understand to which financial instruments impairment applies
• Link impairment rules to classification and measurement under IAS 39

 

Detailed Objectives

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Overview

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Overview

Showing you when hedge accounting can be useful and the application of hedge accounting

 

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Overview

Showing you when hedge accounting can be useful and the role of fair value hedges

Detailed Objectives

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

• Understand the basics of hedge accounting
• Understand how the macro fair value hedge model is positioned in IAS 39
• Understand the MFVH model relates to other hedge accounting models

 

Detailed Objectives

A) Why macro fair value hedge?

• Understand why an alternative MFVH-model is necessary for banks to effectively apply hedge accounting
• Which assets and liabilities are eligible hedged items in a macro fair value hedge accounting model

 

B) MFVH process steps

• Understand the various steps that are part of a standard MFVH model: bucketing, designation, effectiveness testing, MFVH adjustments, amortisations & releases and pull to par adjustments

 

C) Journal entries:

• Understand the macro fair value hedge accounting adjustments
• Post amortisation adjustments and releases of MFVH-adjustments

 

D) Impact on Practical considerations:

• Understand what practical difficulties banks face when applying a macro fair value hedge accounting model

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

Overview

 

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Overview

• Understand the overall model of classification and measurement of financial assets
• Understand and apply the concepts of business model assessment and SPPI test, relevant to debt instruments
• Identify the different business models for debt instruments: hold to collect, hold to collect and sell and other
• Understand the classification and measurement of equity instruments

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Overview

 

 

At the end of the e-learning an exam tests your knowledge of the topics discussed during the e-learning.

 

Detailed Objectives

A) Case 1 - Scoping

• Identify the account balances that would potentially be impacted by IFRS 9 
• Recognise which subtopic of IFRS 9 (i.e. impairments or classification and measurement) is potentially relevant for each account balance and what balance sheet and income statement   volatility could be expected.

 

B) Case 2 – Classification & Measurement:

• Decide on an individual assessment versus a portfolio assessment
• Apply the BM (business model) and SPPI (solely payments of principal and interest) tests for debt instruments
• Apply the classification and measurement assessment to equity instruments
• Identify information sources and processes relevant for the classification and measurement assessment

 

C) Case 3 - Impairment

• Identify the level at which the impairment assessment is to be performed (portfolio, sub-portfolio, instrument)
• Identify (relevant) triggers for significant increase in credit risk
• Identify (relevant) information for calculating ECL (expected credit losses)
• Evaluate relevance of (new) information for IFRS 9 application