Ensuring effective customer due diligence is vital in managing the risk of all forms of financial crime. However, this presents increasing challenges, particularly when dealing with customers remotely. 3-hour live, instructor-led virtual workshop Suitable for anyone who wants to learn more about KYC/CDD Gain a solid understanding of and practical ability to deliver robust due diligence Earn a certificate of completion and receive a £100 discount on the ICA Certificate in KYC and CDD (if you choose to go on to further study). What will I learn? CDD - what is it and why bother? The risk-based approach to CDD CDD requirements, skills, and good practice Core 'Know Your Customer' frameworks What is like working in 'Know Your Customer'
ICA Essentials - Anti Money Laundering The challenge of managing money laundering risks in a global marketplace is one that demands a co-ordinated approach and a common understanding of evolving and emerging trends in both regulation and criminal activity. 3-hour live, instructor-led virtual workshop Gain a solid understanding of core AML and counter terrorist financing issues Earn a certificate of completion and receive a £100 discount on the ICA Certificate in Anti Money Laundering (if you choose to go onto further study). Understanding money laundering Sanctions, terrorist, and proliferation financing Strategic approach to protecting your firm Anti money laundering and countering the financing of terrorism.
Logistics for Traders: Importance, Role and Benefits. This session will look at how logistics is a critical component within the supply chain but is often overlooked.
SEO Description: Elevate the standard of health and safety in your care home with our comprehensive 3-hour CPD Care Home Legionella Management Course. Specifically crafted for care home professionals, this online course empowers facility managers, maintenance teams, and health and safety officers with essential skills and knowledge to manage legionella risks effectively. Aligned with HSE ACOP L8 guidelines, the course offers in-depth learning about prevention, assessment, and control of legionella in care environments. Gain a CPD Certificate upon completion, showcasing your commitment to upholding the highest standards in care home safety. Join our expert-led live sessions for a practical and engaging learning experience, ensuring your care home remains a safe and compliant haven for residents and staff.
Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros
An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items
Sanctions and sanctions compliance presents unique challenges and risks to a business. Requirements are continually changing in response to changing geopolitical events. Therefore, developing an up-to-date, foundational understanding of the threat, together with current best practice, can help you ensure that you or your firm complies with international requirements. 3-hour live, instructor-led virtual workshop Suitable for anyone who wants to learn more about sanctions risk Gain a solid understanding of the fundamentals of sanctions risk Earn a certificate of completion and receive a £100 discount on the ICA Certificate in Managing Sanctions Risk (if you choose to go on to further study) What will I learn? Defining sanctions The international context of sanctions Building a sanctions governance framework Sanctions lists and screening Managing sanctions alerts The cost of getting it wrong The challenge of change.