36224 Courses in Cardiff delivered Online

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

Raise achievement across your school with Precision Teaching Plus, a simple tool that empowers TAs to support children retain their learning. All the tools to easily tailor this powerful teaching approach to individual children and their targets.

Level 5 - Three QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

In this day and age, it’s crucial to know everything there is to know about international economic sanctions. With AGRC’s Certificate in Sanctions Compliance, you will acquire the theoretical and practical knowledge and skills to comply with any sanction imposed and protect your business from penalties and reputational damage. Over the past several decades, international economic sanctions have become a central instrument in global governance, being employed by both sovereign states and international organisations. More recently, there has been a shift towards ‘smart’ or targeted sanctions that aim at the political and economic elites of targeted countries (e.g., through asset freezes and travel bans) rather than a more comprehensive sanctions approach (e.g., large-scale trade or oil embargoes) that has a detrimental effect on civilian populations. In the era of financial globalisation, such ‘smart’ sanctions entail increased compliance obligations for state institutions and private organisations which, if not met, carry significant fines, penalties, and other adverse consequences. Study method Online, self-paced Duration 25 hours Access to content 365 days Certification Certificate in Compliance Additional info Exam(s) / assessment(s) is included in price Description This certificate provides a thorough understanding of sanctions and an opportunity to explore the recent global trends in economic sanctioning, while tracing the roles of the relevant actors within this complex framework. You will examine the motives and rationale behind such decisions, the effects and consequences experienced not only by the targeted parties but also those doing business with them, either directly or indirectly. The certificate is structured to offer the relevant knowledge with reference to practical examples that will enable for a sanctions compliance strategy to be conducted in an effective manner, essential to mitigating the sanctions risk. Topics Covered • Definition of sanctions • Framework and legal basis • The international framework • Multilateral sanctions • Unilateral sanctions and key sovereign states • The legal and institutional framework • Categories of restrictive measures • Administration of sanctions • Managing and mitigating sanctions risk • Sanctions compliance programmes • Processes and systems • Sanctions screening and evasion Expected Learning Outcomes Upon completing this certification, you will be able to: • Understand sanctions and the importance of compliance • Understand why it’s important to comply • Review and understand the global sanctions framework • Define a sanctions compliance programme and governance framework • Define sanctions lists and screening • Manage alert investigations • Understand sanctions risk • Determine how much your institution is vulnerable to sanctions risks • Apply modern methodologies that will increase the efficiency and effectiveness of your programme • Protect your institution from dealing with embargoed individuals or entities • Understand the best practices for sanctions compliance controls Who is this course for? Financial crime and regulatory compliance professionals Professionals working within the sanctions environment who wish to certify their knowledge Operational staff who need to understand the importance of sanctions compliance Regulators Consultants AML, compliance, and risk professionals Anyone working in financial services interested in attaining a better understanding of how sanctions work Requirements No previous knowledge or experience is required, although it is assumed that participants have good knowledge of English and sound educational background.

Course Overview The comprehensive Cisco ASA Certificate Course has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Cisco ASA Certificate Course today, and learn from the very best the industry has to offer! This best selling Cisco ASA Certificate Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Cisco ASA Certificate Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Cisco ASA Certificate Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Cisco ASA Certificate Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Cisco ASA Certificate Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Cisco ASA Certificate Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Cisco ASA Certificate Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Active Training Tools has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Active Training Tools today, and learn from the very best the industry has to offer! This best selling Active Training Tools has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Active Training Tools is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Active Training Tools is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Active Training Tools is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Active Training Tools, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Active Training Tools will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Active Training Tools to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Facebook Ads and Marketing has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Facebook Ads and Marketing today, and learn from the very best the industry has to offer! This best selling Facebook Ads and Marketing has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Facebook Ads and Marketing is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Facebook Ads and Marketing is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Facebook Ads and Marketing is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Facebook Ads and Marketing, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Facebook Ads and Marketing will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Facebook Ads and Marketing to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Complete SAS Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete SAS Programming today, and learn from the very best the industry has to offer! This best selling Complete SAS Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete SAS Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete SAS Programming is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Complete SAS Programming is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Complete SAS Programming, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Complete SAS Programming will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Complete SAS Programming to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Adobe photoshop Posters Making has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Adobe photoshop Posters Making today, and learn from the very best the industry has to offer! This best selling Adobe photoshop Posters Making has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Adobe photoshop Posters Making is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Adobe photoshop Posters Making is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Adobe photoshop Posters Making is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Adobe photoshop Posters Making , you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Adobe photoshop Posters Making will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Adobe photoshop Posters Making to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Solidworks Fundamentals Course has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Solidworks Fundamentals Course today, and learn from the very best the industry has to offer! This best selling Solidworks Fundamentals Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Solidworks Fundamentals Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Solidworks Fundamentals Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Solidworks Fundamentals Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Solidworks Fundamentals Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Solidworks Fundamentals Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Solidworks Fundamentals Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.