A tailored programme dedicated to equipping you with the necessary skills and techniques for increasingly demanding board and governance responsibilities.

The course will provide learners with a general knowledge of skills and competences required to work in finance and office administration, thus improving on and enhancing the learners’ skill set as well as their future opportunities.

Course outline

Module 1: Accounting
Module 2: Business skills
Module 3: Fiscal related matters
Module 4: Business IT

Contact hours - 75
Self-Study hours - 19
Hands-on hours - 95
Assessment hours - 4

Prerequisites

The entry requirements are limited to a good command of the English language and a general O-level standard of education.
Previous experience in an office or finance department is preferable, but not a pre-requisite.

Who should attend?

The course is aimed at:

• individuals employed in an office setup such as clerks or junior accounting staff looking at increasing their existing skill set;
• women returning to work and early school leavers who wish to pursue an office based job.

Learning outcomes

Upon completion of this course, learners will be able to carry out routine book keeping entries and to pass adjustments (manually or in accounting software) allowing them to close off the books of account and prepare basic financial statements. They will know what documentation to retain and will be able to monitor banking facilities and create internal controls. They will be familiar with a number of new business skills that will see them being familiar with EU funding procedures, health and safety issues and social media. Learners will also be able to carry out administrative tasks in connection with the company’s fiscal obligations and will be more familiar with Office applications which they can then use to communicate and make better presentations.

Welcome to the Mapfre MSV Life Insurance Policy E-Learn.

In the next hour you will go through a brief overview of the portal and understand the elements within.

eLearn finalisation - DRAFT

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.

Four days of blended workshops, which will prepare you for every step in managing a project.

• Develop hard (managerial) and soft skills
• How to develop a formal project management plan, including scope, budget, and schedule, as well as quality management and communications plan among others (templates provided)
• Practical communication skills, such as planning and running meetings, efficient written and verbal communication, etc.
• How to manage multiple projects

Classification and measurement under IFRS 9

This course provides training for Officers/officials/Practitioners experienced in data protection issues, for new Data Protection Officers who need to be trained in data protection matters and for any person who, in the carrying out of his duties, processes personal data, including personal data representatives, chief information officers, IT Managers, compliance officers, internal auditors, records managers, human resources managers, administration officers and marketing managers. 

The training programme is intended for individuals working in the public or the private sector. This could include all industries including the financial services and i-gaming sectors.

Course outline

Module 1: The GDPR; The Data Protection Act, 2018 (Cap.586); and related legislation including the ePrivacy Directive
Module 2: Privacy Impact Assessments and Data Protection Audits

Contact hours - 40
Self-Study hours - 60
Hands-on hours - 16
Assessment hours - 2

Lectures are 3 hours each and are held once a week.

Prerequisites

A good command of the English language to an approximate MQF level 3 standard. Previous exposure to office environments including roles in finance an advantage.

Learning outcomes 

• An understanding of the way that the Act, and related legislation, works;
• An understanding of what has to be done to achieve compliance;
• The ability to review practices and procedures and introduce Data Protection controls in business processes;
• The ability to conduct on his/her own initiative Data Protection Audits and Privacy Impact Assessments and be able to take part in initiatives relating to information security

Assessment

FORMATIVE 

Formative feedback is provided throughout the course using a choice of dedicated email or e-learning platform discussion and personal messaging.

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.