2639 Courses in Cardiff delivered Live Online

Autocad face to face training customised and bespoke. In-person

Tools and techniques to make solving problems and decision-making a breeze!

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

training at home, fitness, personal trainer, workout, health

Introducing the Love Coach Miss Date Doctor Package: Your Personalized Path to Relationship Success Are you tired of navigating the complexities of modern dating? Are you seeking guidance and support in your quest for love and meaningful connections? Look no further than the Love Coach Miss Date Doctor Package. Designed to empower individuals like you, this comprehensive coaching program is your ultimate resource for achieving relationship success. With our team of experienced love coaches, we offer personalized guidance tailored to your unique needs and goals. Our package combines proven coaching techniques, expert advice, and practical tools to transform your love life. We understand that every individual and relationship is different, so we customize our approach to meet your specific requirements. Key Features of the Love Coach Miss Date Doctor Package: One-on-One Coaching: Benefit from personalized coaching sessions with our certified love coaches who will provide expert guidance and support throughout your journey. Relationship Assessment: Gain insights into your dating patterns and relationship history through an in-depth assessment. Identify strengths, areas for growth, and potential roadblocks. Dating Strategies: Learn effective dating strategies, including tips for attracting the right partner, building chemistry, and creating a lasting connection. Communication Skills: Develop essential communication skills to express your needs, navigate conflicts, and build a deeper understanding with your partner. Online Dating Optimization: Master the art of online dating with our guidance on profile creation, messaging etiquette, and leveraging dating platforms to maximize your chances of success. Self-Discovery and Confidence Building: Unlock your true potential by gaining a deeper understanding of yourself, boosting self-confidence, and embracing self-love as the foundation for healthy relationships. Relationship Maintenance: Learn the art of nurturing and maintaining a thriving relationship through effective problem-solving, intimacy-building techniques, and shared growth. Emotional Support: Benefit from ongoing emotional support as you navigate the ups and downs of your relationship journey. Our love coaches are here for you every step of the way. This package supports the following requirements: relationship coach, love consultant, dating advisor, relationship expert, dating coach, personal love coach, relationship guidance, love mentor, dating support, romantic relationship coach. Don’t let uncertainty and frustration hold you back from finding the love and happiness you deserve. With the Love Coach Miss Date Doctor Package, you’ll gain the tools, insights, and confidence to embark on a successful relationship journey. Take the first step towards a fulfilling love life and unlock your true potential today. 3 sessions x 1 hour https://relationshipsmdd.com/product/love-coach-miss-date-doctor-package/

  Being ISO 27701 Certified proves your Information Privacy Systems Audit experience, skills and knowledge, and demonstrates you are capable in the assessment of vulnerabilities, Compliance with GDPR and institutional controls within the enterprise.   Gain an in-depth understanding of GDPR solutions and how they map to compliance requirements Learn how to perform and lead Privacy Information Management System (PIMS) certification audits to ISO 19011 standards Enhance your existing or learn with new skills in the field of Data Protection Candidates deliver Assurance services to organisations by advising on conformance with PIMS requirements Become a Technical expert on the preparation required for ISO 27701 Certification Understand a Privacy Information Management System (PIMS) and its processes based on ISO/IEC 27701 Identify the relationship between ISO/IEC 27701, ISO/IEC 27001, ISO/IEC 27002, and other standards and regulatory frameworks Acquire the competences of the auditor's role in planning, leading, and following up on a management system audit in accordance with ISO 19011. Learn how to interpret the requirements of ISO/IEC 27701 in the context of a PIMS audit About This Course   ISO 27701 Internal Auditor Certification;    Confirms your knowledge and experience Quantifies and markets your expertise Demonstrates that you have gained and maintained the level of knowledge required to meet the dynamic challenges of a modern enterprise Is globally recognized as the mark of excellence for the Information Privacy Audit professional Increases your value to your organization Gives you a competitive advantage over peers when seeking a new role Is administered by the International Examination & Certification Board (IECB), based in Estonia, and fully aligned to the ISO/IEC 17024:2012 standard (Conformity assessment - General requirements for bodies operating certification of persons)   Certified Individuals:    Are highly qualified, experienced professionals in the field of Data Protection Systems Audit Provide the enterprise with a Certification route for Information Privacy Assurance that is recognized by multinational clients, lending credibility to the enterprise Are excellent indicators of proficiency in control requirements creation and monitoring Demonstrate competence in five domains, including standards and practices; organization and management; processes; integrity, confidentiality and availability; and software development, acquisition and maintenance Demonstrate a commitment to providing the enterprise with trust in and value from your Privacy Compliance Framework Maintain ongoing professional development for successful on -the -job performance   The below job practice is organized by domains. Each domain is covered in the course.   Domain 1-The Process of Auditing Information Privacy Systems and Solutions   Provide audit services in accordance with ISO 19011 audit standards to assist the organization in protecting and controlling information privacy systems.    Domain 2 - Governance and Management of Information Privacy Technology   Provide assurance that the necessary leadership and organizational structures and processes are in place to achieve objectives and to support the organization's strategy.    Domain 3-Information Systems Acquisition, Development and Implementation   Provide assurance that the practices for the acquisition, development, testing and implementation of information systems meet the organization's strategies and objectives.    Domain 4-Information Systems Operations, Maintenance and Service Management Provide assurance that the processes for information systems operations, maintenance and service management meet the organization's strategies and objectives.   Domain 5-Protection of Personally Identifiable Information (PII) Assets   Provide assurance that the organization's policies, standards, procedures and controls ensure the confidentiality, integrity and availability of PII.   Prerequisites   A thorough understanding of current Data Protection legislation, Information Security & Risk Management knowledge as well as ISO 19011 Auditing Standards is required to successfully pass the examination. What's Included?   Teas, Coffees, refreshments and a full Lunch* Course Slides Study Guide Exam Fees * For Classroom based Courses only Accreditation   Who Should Attend?   Auditors seeking to perform and lead Privacy Information Management System (PIMS) certification audits Managers or consultants seeking to master a PIMS audit process Individuals responsible for maintaining conformance with PIMS requirements Technical experts seeking to prepare for a PIMS audit Expert advisors in the protection of Personally Identifiable Information (PII)   Assessment     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 3 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success. Our Guarantee   We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras. The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE.   *FREE training offered for retakes - come back within a year and train for free. Provided by   This course is Accredited by NACS and Administered by the IECB

'RCN Accredited Asthma and COPD' CourseThis course is a collaborative offering between your employer and BBO Training Ltd., designed to equip experienced healthcare professionals working in primary care settings with a comprehensive and holistic approach to managing patients with asthma and COPD. Even for those already holding a Diploma in either of these areas, the course has proven to be highly valuable, as indicated by positive evaluations from healthcare professionals.Course AimThe primary objective of this course is to provide qualified healthcare professionals with the necessary knowledge and skills to deliver effective asthma and COPD services in collaboration with their medical colleagues within the community healthcare setting. The course aims to raise awareness of these chronic conditions within the community, ensuring safe practice through the utilization of Patient Group Directions (PGDs) and protocols where appropriate. Participants will be clinically and theoretically prepared to establish and manage review and diagnostic clinics within their competency framework. Furthermore, the course emphasizes the clear differentiation between asthma and COPD.Clinical Practice Program and CompetenciesThroughout the course, you, along with your primary mentor, will organise and validate your clinical engagements, both under supervision and independently. By the time of your final assessment, these forms should be fully completed and ready for submission, accompanied by both your and your mentor's evaluations. Additionally, maintaining a log of all clinical hours and interactions is required, with a minimum of 36 hours.Teaching and Learning ApproachUpon completing this course, students will have the opportunity to:1. Participate in various sessions, including workshops, simulations, discussions, seminars, and tutorials, which can be conducted either virtually or in-person.2. Gain practical experience in asthma and COPD management within their local healthcare settings.3. Develop an in-depth understanding of treatments, including their composition, efficacy, indications, contraindications, and mechanisms of action, through clinical practice.4. Enhance advisory skills related to respiratory care on a broader scale.5. Attend dedicated sessions for clinical practice.6. Document a minimum of 36 hours of supervised clinical practice and maintain an ongoing reflective diary.Expected Course ContentWorkshops, Discussion Groups, Lectures, and Assessment: 40 hoursClinical Practice: A minimum of 36 hoursVisits and Private Study: 44 hoursPrivate study time is essential for reading, conducting factual research on treatments through online sources, and accessing the library for literature searches. This time will facilitate writing, referencing, completing your reflective diary, and preparing for the final assessment.AssessmentSuccessful completion of all components is required. Components 2 to 4 must be passed to complete the course. A resit option is available for any component that is not initially passed, limited to one attempt.1. Reflective Diary: This ongoing document, produced by the student throughout the course, is validated by both the student and mentor. While not directly marked, its completion is integral to your portfolio of evidence.2. Clinical Outcomes: These must be validated and passed by your mentor, with all outcomes achieved, along with a log of clinical hours.3. VIVA: A minimum pass mark of 50% is required.4. Test of Knowledge: A minimum pass mark of 50% is necessary (conducted at the end of the initial study days).Learning OutcomesUpon completion of this course, students will be capable of:1. Evaluating and showcasing clinical competence through a reflective diary/log.2. Demonstrating clinical assessment and treatment proficiency in a VIVA examination and knowledge assessment.3. Effectively educating individuals about self-management and enhancing their understanding of their condition.4. Displaying sensitivity and competence in obtaining comprehensive patient histories.5. Adapting care for diverse patient groups and their unique needs.6. Fulfilling professional responsibilities, including meticulous record-keeping and maintaining confidentiality.7. Teaching the use of various inhalers and assessment equipment.8. Developing fundamental assessment and examination techniques for respiratory conditions.9. Operating with Patient Group Directions and protocols for asthma and COPD care.10. Assessing, planning, implementing, and evaluating individual patient needs comprehensively.

Duration 1 Days 6 CPD hours This course is intended for Security IT business-level professionals interested in cloud security practices Security professionals with minimal to no working knowledge of AWS Overview Assimilate Identify security benefits and responsibilities of using the AWS Cloud Describe the access control and management features of AWS Explain the available methods for providing encryption of data in transit and data at rest when storing your data in AWS. Describe how to secure network access to your AWS resources Determine which AWS services can be used for monitoring and incident response This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services are available to you and why and how the security services can help meet the security needs of your organization. Prerequisites Working knowledge of IT security practices and infrastructure concepts, familiarity with cloud computing concepts 1 - Security on AWS Security design principles in the AWS Cloud AWS Shared Responsibility Model 2 - Security OF the Cloud AWS Global Infrastructure Data center security Compliance and governance 3 - Security IN the Cloud ? Part 1 Identity and access management Data protection essentials Lab 01 ? Introduction to security policies 4 - Security IN the Cloud ? Part 2 Securing your infrastructure Monitoring and detective controls Lab 02 ? Securing VPC resources with Security Groups 5 - Security IN the Cloud ? Part 3 DDoS mitigation Incident response essentials Lab 03 ? Remediating issues with AWS Config Conformance Packs 6 - Course Wrap Up AWS Well-Architected tool overview Next Steps Additional course details: Nexus Humans AWS Security Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AWS Security Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Private online Italian lessons

The main subject areas of the course are: Building construction and the uses of asbestos Survey types Bulk sampling and material assessments Survey reports Quality control