4328 OV courses in Cardiff delivered Live Online

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Details This course is aimed at Water and Wastewater managers, field managers, asset managers and others involved in meeting compliance within the Water industry. As Wastewater Treatment compliance now comes under increasing regulatory scrutiny from OFWAT the overall ability of the Water Industry to effectively oversee and manage the Wastewater Treatment process comes under sharper focus. Demonstrating the competence of those responsible will likely become increasingly the focus of public awareness and form a key strand of the regulator’s investigation. Main themes Demonstrate an understanding of the current regulatory framework pertaining to pollution incidents Understand the sources of pollution Understand pollution risks specific to the Water and Wastewater industry Critically analyse the stakeholders’ views of pollution from the Water and Wastewater industry Understand the importance of stakeholder communication, feedback and involvement in the context of pollution incidents Understand the impact of pollution in terms of the environment, customers, cost, H&S and from the regulatory perspective Describe the cumulative effect of point source and diffuse sources of pollution Describe and explain the collective responsibilities and ethical and moral issues as pertaining to pollution incidents Critically evaluate the use of internal systems and mechanisms for delivery of pollution risk reduction strategies Develop a pollution risk reduction strategy appropriate to your organisation. Instructions This online course will be delivered using CISCO Webex. You will need a suitable device with a camera and microphone like a laptop. If you have any questions about what is required, please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.

Birth Right Hypnobirthing is a full antenatal birth preparation course for pregnancy. Particularly useful for those who are scared of giving birth. Whether this is your first or tenth baby this information is essential. Whether you're looking for a natural birth or support for your caesarean birth this course will support you and give you the tools for the best birth for you.

Mental Health First Aid (MHFA) England Training with Mindmaps Wellbeing Enhance workplace wellbeing and mental health awareness with MHFA England-certified training by Mindmaps Wellbeing. Our expert-led courses, delivered by Registered Mental Health Nurses and Healthcare Educators, equip you with the skills to recognize, support, and respond to mental health challenges. Whether online or in-person, our training ensures flexible learning options without compromising quality. Join us to gain certification as a Mental Health First Aider and access exclusive benefits like ongoing peer support, expert forums, and resources for self-care. Book now with Mindmaps Wellbeing and take the first step toward a healthier, more supportive environment for all.

This offering is for an initial session exploring your enneagram map report , which is included. The test I use is from Aephoria, and it will give you your tritype (your strategies for thinking, feeling and doing) as well as your instinctual variant, which is helpful information about where you tend to focus your attention. Once you have your map, we will unpack the information together, and if you wish, go on to explore it over a series of sessions, using creative tools and practices to find its meaning and wisdom for you in your life.

This comprehensive online interior design course includes 12 self study modules, and weekly 1:1 telephone and or video consultations. I will personally guide and inspire you through your creative learning journey.

COURSE INTRODUCTION  The purpose of this course is to introduce / refresh participants’ knowledge and skills in the essential aspects of diabetes management in their practice setting.  AIMS AND OBJECTIVES  Identify their current knowledge of diabetes care and how confident they feel about offering advice to a patient with diabetes and or their family. Purpose and outcomes of the main treatment options for people with diabetes . Discuss the importance of addressing the person’s needs and how regular clinic visits impact on the management of diabetes All course materials and certificate of attendance Accreditation 6 CPD points awarded completion. Accredited by One Awards (*Certificate £30) and CPD Standards (*Certificate free) Discuss how to build relationships and establish an environment that enables the person with diabetes to take an active role in their diabetes management  COURSE CONTENTS OVERVIEW  Aetiology and diagnosis of type 1 and type 2. Difference between type 1 and type 2 diabetes  Implications for practice  Management goals TYPE 1  Treatment and management options  Carbohydrate awareness  Challenges in self-management  Hypoglycaemia and hyperglycaemia  Screening and the annual review TYPE 2  First line treatment and step-wise options  Food choices and relation to risk  Activity and type 2 diabetes  Cardiovascular disease and type 2 diabetes  Screening and annual review  SUPPORTING PEOPLE WITH DIABETES AND THEIR FAMILY  Seeing the person not the disease  Consultation skills  Ongoing support needs .  Food and lifestyle messages for diabetes  Annual review and screening including foot care advice  Blood glucose monitoring  Consultation skills and relationship building  Complications and treatment options  WHO SHOULD ATTEND?  Nurses HCAs

Our OISC Level 3 accreditation training course is designed as a two-day, extensive course. We offer participants a detailed look into immigration advice, following on from Level 2 OISC training. In this course we aim to cover the syllabus at Level 3 of OISC standards. Course Overview:   Our OISC Level 3 Training Course, a comprehensive two-day program designed to provide an extensive understanding of immigration advice at an advanced level. Building upon the knowledge acquired in Level 2 training, this course delves deeper into the intricacies of UK and EU immigration and asylum law, equipping participants with expert knowledge and skills. Our aim in this course is to cover the Level 3 syllabus as per the standards set by the Office of the Immigration Services Commissioner (OISC). By attending our training, you will gain a comprehensive understanding of the advanced structures and frameworks of UK immigration law. We will explore the complexities of asylum and human protection law, as well as the European Economic Area (EEA) Regulations 2006.   Looking to fast track your OISC Level 3 training? Join our 1 day fast track training course   Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 3 Syllabus? The OISC Level 3 Training introduces new learning objectives for immigration adviser applicants. The course includes: Advanced structures and frameworks of UK immigration law Asylum and Human Protection law European Economic Area (EEA) Regulations 2006 Appeals and High Court proceedings   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course.   Who can attend the OISC Training Level 3 classes? The OISC Training Level 3 seminars cover complicated immigration frameworks and processes. Although no previous qualification is needed to attend these courses, participants should have completed Level 1 and Level 2 assessments before progressing with this last step. The OISC Level 3 Training course is aimed at those who wish to obtain in-depth knowledge on UK and EU immigration law.

Our OISC Level 2 preparation course is a two-day training course which offers a closer look at immigration advice and follows on from the training at Level 1. Throughout this course, we cover the syllabus at Level 2, as according to OISC standards. View our course dates below, delivered via Microsoft Teams Course Overview:   Take your expertise to the next level with our OISC Level 2 Accreditation Course. Designed as a two-day training program, this course builds upon the foundation established in Level 1 training. Delving deeper into immigration advice, we cover the Level 2 syllabus as prescribed by the OISC. Throughout this course, you’ll explore intermediate structures, frameworks, and concepts of UK immigration law. Gain insights into Humanitarian Protection and Asylum law, as well as the complexities of European Economic Area (EEA) free movement law. Additionally, our curriculum covers Business immigration law and Points-Based System (PBS) visas, along with the intricacies of detention and bail. We’ll also address major immigration offences to ensure a well-rounded understanding. Don’t forget to check out our Exam Technique Training (Level 2) which is designed to help prepare learners for their accreditation exam.   Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 2 Syllabus? The OISC Level 2 Training introduces new learning objectives for immigration adviser applicants. The course includes: Intermediate structures, frameworks and concepts of UK immigration law Humanitarian Protection and Asylum law European Economic Area (EEA) free movement law Business immigration law and PBS visas Detention and bail Major immigration offences   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. Who can attend the OISC Training Level 2 classes? The immigration procedures and structures introduced by the OISC Level 2 Course follow directly on from the objectives covered in the Level 1 Training. For this reason, participants should attend an OISC Level 2 class only after completing the Level 1 assessment. This course is also useful for participants who aim to become acquainted with UK immigration law. On the other hand, those who hold an OISC accreditation and wish to learn more about the latest development in this field can also benefit from this training class.

Our OISC Level 1 training course is designed as a two-day, entry-level course, offering participants an introduction into Immigration Advice. In this course, we aim to cover the syllabus at level one, as according to OISC standards. View the OISC Level 1 course dates below, delivered on Microsoft Teams. Course Overview:   Our OISC Level 1 Training Course, your gateway to comprehensive knowledge in Immigration, EU, and Asylum law. Our course is specifically designed to equip participants with the fundamental understanding needed to excel in the level one assessments, with a strong focus on fulfilling the core requirements set by the OISC (Office of the Immigration Services Commissioner). Designed as a comprehensive two-day entry-level course, it serves as an excellent introduction to Immigration Advice. Our aim is to cover the level one syllabus prescribed by the OISC, ensuring that you meet the standards set by the regulatory body. By enrolling in our OISC Level 1 training course, you’ll gain the essential knowledge, skills, and confidence required to navigate the complex world of immigration law effectively. Whether you’re looking to launch a career in immigration advice or seeking to enhance your existing expertise, this course will lay a solid foundation for your professional journey. Don’t forget to check out ourExam Technique Training (Level 1) which is designed to help prepare learners for their accreditation exam. Are you interested in setting up your own OISC law firm? Join our Setting Up An OISC Firm course, where you’ll learn the requirements, processes and key information about running a firm as well as receive handy resources and materials. Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 1 Syllabus? Based on the latest syllabus, published by the Office of the Immigration Services Commissioner, the OISC Level 1 Training Course covers the following: Analysis of the structures, terminology, ethical practices and frameworks of immigration law Asylum and protection law European Economic Area (EEA) free movement law British Naturalisation and British Citizenship registration Business immigration law Appeals process and structures of the Asylum and Immigration Tribunal Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. How is the OISC Level 1 exam structured? The OISC Level 1 exam is structured into two parts: The first part comprises 20 multiple-choice questions. You have 1 hour and 15 minutes to complete this section of your OISC exam. There is only one correct answer for each question. The second part presents different scenario-based questions to be answered within 1 hour and 15 minutes. You should provide answers which are legible and written clearly in plain English. Detailed instructions on how to complete each section of your OISC Level 1 exam will be provided during the course, to ensure that each candidate is adequately prepared to pass the test.