11748 Courses in Cardiff delivered Online

This course is a complete guide to Arduino. Designed with multiple practical projects, you can gain hands-on experience during this course. Programming and electronics fundamentals are also covered in the course.

Level 3 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Duration 1 Days 6 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 Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. 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 Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.

Throughout this workshop, you'll delve into strategies for promoting a healthy relationship with food, tailored to individuals across the spectrum of eating behaviors. Additionally, you'll learn the protocol for delivering the hypnotic gastric band, a powerful tool in managing weight and promoting healthier eating habits.

The aim of the Level 2 Diploma in Care - fast track mode (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care (fast track mode) qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care (fast track mode) qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care (fast track) will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.

Empathy is one of the key building blocks of great social interactions. A lot is talked about regarding empathy, but there is very little practical support to help you to understand empathy and help you to develop your skills in empathy. Learn how to develop your empathy by understanding other people's viewpoints and perspectives to build effective, authentic relationships.

Agile for Non-IT Practitioners - How Agile Project Management is Different and How It Can be Used for Non-IT Projects: On-Demand This course will provide guidance on how Agile can be used beyond software development projects, including how it differs from traditional project management. The course also will provide an overview of the Agile Scrum framework, which is one of the most popular Agile methodologies used.This course provides practical skills, concepts, and principles you can take back to the job and use to implement Agile practices in projects, as applicable. The goal of this course is to acquaint participants with the concepts of agile development methods and the specifics of the Scrum management framework. What You Will Learn You'll learn how to: Describe the Agile project management process and its benefits Use project management vocabulary and terminology Identify the characteristics of a successful project Create an initial project plan Identify and perform the major aspects of project initiation, project control, and close-out Identify and describe organizational change issues in implementing project management Getting Started Course goal and objectives Introducing Agile Scrum Framework Requirements and Product Definition Planning Agile Agile Practices Running a Sprint Summary

PRP has become a highly sought-after as a non-surgical procedure for facial and skin rejuvenation - book your course today and add this service to your business. Enhance your skills with this advanced rejuvenation treatment. Additional course details Course prerequisites A minimum of 21 years of age Prior Phlebotomy training (Introduction to Phlebotomy) Good command of English Course Contents Anatomy and physiology of the skin and blood Infection control Sharps and hazardous waste training First aid and anaphylaxis training Pre-study of PRP theory Phlebotomy Extraction, Preparation and Dosage Management How to achieve safe and predictable outcomes Patient management - expectations Practical training Clinical setup Professional live demonstrations This course was designed for learners to refresh their subject knowledge and practical skill; with prior dermal injection and phlebotomy experience, we suggest you attend our onsite training course for learners without previous training. Course Features CPD Accredited CourseVetted accredited trainingFully Online TrainingTrain your way on any deviceFull DemonstrationComplete end to end treatment demonstrationImmediate CertificationDelivered immediately after completion Frequently Asked Questions How long do I have to complete the training course? Once you have logged in and started your training course you will have 3 months to complete your training. Can I train straight away after making payment? Yes. Once you have completed payment our system will automatically enrol you onto the training course. You will then receive an email with instructions and a direct link to login and start your course. Can I get insurance once I have completed this training? Our online training courses are CPD accredited. Acquiring insurance based on completion and accreditation from our online training courses is insurer specific and as with most cases also takes into account your personal background and status. We advise that you contact your insurance to ensure your prerequisites meets their requirements and that this training course meets their specific criteria for insurance. We have a relationship with Insync Insurance which we recommend. Is this course accredited? Yes. This training course is accredited by the CPD group.

The complete guide to creating your own Pose Estimation apps: Learn the full workflow and get up to speed with developing 5 AI apps

Course Information Join us for a two-day immersive course crafted to equip participants with an in-depth understanding of remote audit methodologies. Delve into the nuances between remote and face-to-face audits, dissecting their respective strengths and limitations. Through practical scenarios tailored for remote audit conduct, this course stands as an essential counterpart to our on-site audits course The Auditing Course. Who Should Attend: Applicable across various domains of regulated research and development, this course proves invaluable in contexts requiring a quality system for audit. Participants with firsthand audit experience stand to gain the most benefit from this programme. Expanding on Previous Learning: This course extends its relevance to all forms of audits and further amplifies concepts explored in RQA's suite of research quality assurance courses, including: 'Research Quality Assurance for Good Laboratory Practice,' 'Good Clinical Practice Auditing – Principles and Practice,' and 'Good Manufacturing Practice for Investigational Medicinal Products.' Benefits include improved: Understand the processes of planning, conducting, reporting and follow-up of audits Recognising the importance of personal approach in developing positive audit outcomes Ability to analyse evidence and present logical audit findings Appreciate the importance of audit in continuing improvement. This course is structured to encourage delegates to: Discuss and develop ideas Solve problems Exchange information. Tutors Tutors will be comprised of (click the photos for biographies): Andrew Waddell Founder Director, Tower Mains Ltd Rosemary Ichaba Senior QA Associate, Tower Mains Ltd Cate Ovington Director, The Knowlogy Group Ltd Jean McWilliam Associate Director, Alexion Programme Please note timings may be subject to alteration. Day 1 09:00 Course Registration 09:15 Welcome and Introductions 09:35 Introduction to Audits Delegates explore the range of audits which they have experienced, define the purpose of each audit type and establish which of those audits are performed to meet regulatory requirements. 10:05 Introduction to Remote Audits Presentation to introduce the major differences between face-to-face audits and remote audits. The major elements of audits will be examined to determine where there may be differences. 10:30 Break 10:45 Workshop 1 - Remote Audits This workshop will examine participants experience or understanding of the differences between face-to-face and remote audits. 11:15 Workshop 1 - Feedback 11:35 Audit Preparation The essential steps in preparation for audits will be discussed with emphasis on remote audits. 12:05 Workshop 2 - Remote Audit Preparation Factors relating to the preparation for remote audits will be considered in discussion groups. 12:35 Workshop 2 - Feedback 12:50 Lunch 13:30 Audit Logistics Preparation for the audit includes many arrangements other than the audit content. 14:00 Workshop 3 - Audit Logistics Delegates will discuss some of the issues that may occur during the set up and conduct of remote audits and how to resolve them. 14:30 Workshop 3 - Feedback 14:45 Break 15:00 The Opening Meeting Presentation regarding the importance and content of the opening meeting. 15:20 Workshop 4 - Opening Meeting Delegates will consider the practicalities of arranging and conducting an opening meeting. 15:45 Workshop 4 - Feedback 16:10 Audit Conduct Tools Practical advice on preparation of some of the tools that will be valuable in the conduct of audits. 16:40 Questions and Answers An overview of the first day and a chance to ask questions 17:00 Close of Day Day 2 09:00 Reflections on Day 1 Recap on the topics covered and a chance for delegates to raise points. 09:15 Gathering Evidence Presentation on challenges of gathering evidence and conducting interviews during remote audits. 09:45 Workshop 5 - Remote Interviews Scenarios of different remote interviews will be played and delegates assess the strengths and weaknesses of each approach. 10:15 Break 10:30 Creating Audit Findings Ideas regarding how to create good audit findings will be discussed during this short presentation. 10:50 Workshop 6 - Creating Audit Findings Delegates will be provided with examples of evidence from an audit. They will discuss these and create their audit findings for presentation at the closing meeting. 11:35 The Closing Meeting The content and conduct of the closing meeting will be discussed. 11:55 Workshop 7(a) - Preparing for the Closing Meeting The findings from workshop 6 will be reviewed and a Lead Auditor selected to provide feedback in workshop 7(b) 12:15 Workshop 7(b) - The Closing Meeting The Lead Auditor from each group will hold a meeting to present the results (role play). 12:45 Lunch 13:30 The Audit Report This presentation will cover not only the essential contents of the audit report but also how to write the report in a manner that will generate the most positive reaction. 14:00 Workshop 8 - The Audit Report Delegates will be provided with an audit report from an audit conducted remotely and will conduct a peer review of the report in their breakout groups. 15:00 Workshop 8 - Feedback 15:20 Break 15:35 Audit Closure Presentation on how to conclude the audit with reference to post-audit activities. 15:55 Open Forum 16:30 Close of Course Extra Information Course material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking You will need a stable internet connection, a microphone and a webcam.