50343 Courses

Official BRCGS Product Safety Management course: Vulnerability Assessment for Food Fraud. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

Official BRCGS Product Safety Management course: Root Cause Analysis Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

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

The Altherma 3 LT Monobloc Standard Installation Level 1 (R32) DUK-H11 training is a full day course covers everything you need to know to successfully install the Daikin Altherma 3 LT Monobloc.

ISO 13485:2016 specifies requirements for a quality management system where an organization needs to demonstrate its ability to provide medical devices and related services that consistently meet customer and applicable regulatory requirements. Such organizations can be involved in one or more stages of the life-cycle, including design and development, production, storage and distribution, installation, or servicing of a medical device and design and development or provision of associated activities (e.g. technical support). ISO 13485:2016 can also be used by suppliers or external parties that provide product, including quality management system-related services to such organizations.

The “ISO 20000: 2018 Lead Auditor” course provides comprehensive training in the ISO 20000: 2018 standard and all its requirements from the Lead auditor’s point of view, as well as basic skills necessary to Lead audit activities. It’s a practical-oriented training that should be considered “a must” for every ISO 20000: 2018 Lead auditor. The interactive training program, complete with quizzes, will provide the necessary technical knowledge and understanding of all ISO 20000: 2018 requirements to implement the requirement of the standard and complete ISO 20000: 2018 audit . This ISO Lead auditor training should be taken by individual with interest in conducting internal as well as third part audits according ISO 20000: 2018 standards.

Our studio is a peaceful Artist owned space, offering pottery and ceramic art classes on our farm in the Cheshire countryside. We have a range of pottery classes and ceramic art workshops, for beginners to experienced. We are close to St Helens, Wigan, Warrington, 20 miles from Manchester and Liverpool centre. - 5 mins M6 and M62 motorways.

Formation officielle BRCGS Food v9 (Norme Mondiale pour la Sécurité des Denrées Alimentaires version 9) pour les sites en français. Dispensée en ligne (Zoom) en direct par un partenaire de formation agréé BRCGS. Frais d'examen et de certificat inclus dans le prix.

Essential skill for all mental health professionals This 2-day workshop gives you the opportunity to see demonstrated, experience, and practice the steps of this powerful technique in a small group under the careful guidance of our expert tutor… -------------------------------------------------------------------------------- * Accredited CPD Certificate : 12 hours * Length 2 days (9:30am - 4:00pm) -------------------------------------------------------------------------------- > Excellent course. A brilliantly encouraging and supportive environment in > which to learn > > HARRIET, WORKSHOP PARTICIPANT > Life-changing! A great weight has been lifted off my shoulders. > > NURSE (PREVIOUSLY TRAUMATISED BY A CAR ACCIDENT) WHY TAKE THIS COURSE We have over 20 years of experience in teaching the rewind technique to health and welfare professionals – we’ve drawn on that experience to develop a course which gives you enough time to thorough absorb and practice the technique, understand why it works and to experience it yourself, so that you leave confident in your ability to use the rewind safely and effectively. The Rewind Technique* is an effective psychological intervention for successfully treating trauma and phobias and one of the most important skills you need to master to be able to work successfully with any anxiety disorder or condition which may have developed as a result of unresolved trauma. Even the most severe phobic and post-traumatic stress (PTSD) symptoms can be successfully addressed using the the rewind technique taught on this 2-day course, which has been refined [https://www.humangivens.com/college/rewind-technique-training-workshop/#refined]* in line with understandings from neuroscience to make it as safe and reliably effective as possible. An essential therapeutic technique to have in your therapeutic ‘toolkit’, it is important to learn and practice it under the careful guidance of our expert tutor [https://www.humangivens.com/college/rewind-technique-training-workshop/#note] – you will leave the course knowing how to use the rewind technique safely and effectively having watched live demonstrations, had plenty of time to practice the steps involved with fellow students, the opportunity to experience the technique yourself and more. [https://www.humangivens.com/college/rewind-technique-training-workshop/#gain] Our workshop has limited numbers so you will have plenty of opportunities for asking questions and the tutor, who has extensive clinical experience. Using the rewind technique you can, often surprisingly quickly, detraumatise bad memories, stop flashbacks and other PTSD symptoms, cure phobias, banish nightmares and reduce anxiety so you can help the victims of abuse, rape, violence, car accidents, fire, terrorism and panic attacks, heart attacks and other life-threatening experiences. Another key benefit of this technique is non disclosure – there is no need for people to repeatedly revisit or talk about specific details of the events that have traumatised them.  This helps avoid embedding the trauma further and making the situation worse – as can sometimes inadvertently happen in other therapeutic approaches to treating trauma – and helps prevent the therapist or counsellor being vicariously traumatised by what they might hear. It is also invaluable when working therapeutically with people who have suffered persistent physical or sexual abuse, and people with OCD. People suffering from other conditions, such as depression, addictions or uncontrollable anger, may have experienced a traumatic event, which needs to be successfully detraumatised in order for them to move on with their lives. As a result of our training in the rewind technique – which we have been delivering for over 20 years – our graduates have brought relief to literally thousands of people  (eg. case history / PTSD Resolution). -------------------------------------------------------------------------------- PLEASE NOTE This is a powerful technique, which needs to be implemented with care – we recommend you take the time to learn it in person in a small group with a skilled and highly experienced tutor who can guide you through the important steps involved, oversee you as you practise them, answer your questions and give you crucial direct feedback. The version of the rewind technique* you will learn on this course has been refined in line with understandings from neuroscience to make it as safe and reliably effective as possible. The course is taught over two days to ensure you have enough time to thoroughly absorb and practice the steps involved so that you are confident in using it and know how to do so safely and effectively with clients. You will also learn when it is NOT appropriate to use this technique and how to ensure you avoid embedding any trauma further, or making a phobia worse. Guided imagery and visualisation skills form an essential part of the rewind technique, which is why they are a requirement for attending this course. > This has huge potential to change people's lives for the better. I can't wait > to put what I've learnt here to good use > > PSYCHIATRIC SUPPORT WORKER    WHAT WILL YOU LEARN * How to detraumatise people quickly and safely * The necessary skills to treat even severe phobias * Why this version of the rewind technique is so effective, and how it works Under careful guidance from the tutor, you will: * revisit key skills for relaxing clients in order to successfully work using the technique * walk and talk through a step-by-step breakdown of the rewind technique * see a live demonstration of working with a phobia or trauma * practice each stage of the rewind technique in pairs * practice the entire process, with other course participants, under supervision You will also gain: * Vital tools for psycho-education – both adding to your own understanding and to pass on to clients * A clear understanding of the fear response and how PTSD and phobias develop * The detrimental impact traumas and phobias can have on a person’s life * The crucial role of the pattern-matching processes in the brain in triggering phobic responses and post traumatic stress symptoms * How the main treatment techniques for treating post traumatic stress disorder (PTSD), sub-threshold trauma and phobias (including EMDR, EFT and CBT) work – their advantages and disadvantages * Why the rewind technique draws on the innate ability we all have to recover from trauma * Pre-disposing factors for suffering a problematic post-traumatic response (or developing a phobia) * Why critical incident debriefing increases the incidence of PTSD * How this version of the rewind technique has been modified to make it safer and more reliable * Trauma-focused rewinding: the psycho-biological reason why this refined rewind technique works so consistently well * A step-by-step breakdown of the essential stages of the rewind technique * The chance to see a live demonstration of working with a phobia or trauma You will leave with: * The confidence to begin using the technique ethically and safely * A clear understanding of the advantages of using a non-intrusive psychological technique to treat trauma, PTSD and phobias (where the client does not have to go into details about or repeatedly ‘revisit’ what has traumatised them) * What to do if a client as an abreaction * Important information about when not to use this technique – and what can be done instead * An understanding of how the rewind technique can be used to work with Complex Trauma and cases involving ‘freeze’, shutdown or dissociative responses * How you can carefully apply this technique to relieve a huge range of anxiety disorders * Greater confidence in dealing with anxiety disorders and distress caused by trauma, phobias and flashbacks * An understanding of how rapidly transformative this technique can be; on the last afternoon we view a filmed therapy session (and follow up) in which Joe Griffin uses the rewind technique to relieve a young man of his severe shark phobia There is also plenty of opportunity for you to ask questions and to experience and practice, under careful guidance, the various stages of the rewind technique yourself. WHO IS THIS COURSE SUITABLE FOR? Anyone working with distressed, phobic or traumatised people, who has already taken our Guided Imagery and Visualisation workshop (and ideally the Therapeutic Power of Language workshop too) as these skills are essential components of the rewind technique. If you help traumatised people (including children) or people suffering from any form of phobia or anxiety disorder – this includes: psychotherapists, counsellors, mental health nurses, OTs, health visitors, social workers, psychiatrists, GPs, clinical psychologists, midwives, welfare officers, youth workers, hypnotherapists and those working with traumatised members of public services, such as: firefighters, police, paramedics and military personnel – you will find the rewind technique and associated skills hugely helpful. -------------------------------------------------------------------------------- COURSE REQUIREMENTS Guided imagery, relaxation and visualisation are an integral component of the Rewind Technique – if you don’t already have experience in using these skills therapeutically with others you must complete our Guided Imagery and Visualisation for Therapeutic Change workshop before attending this course (this is always run the day before our rewind technique training). This is to ensure you get the most out of this 2-day course and also have the necessary skills for practising the rewind technique safely and effectively.  You would also find it useful to attend the Therapeutic Power of Language workshop beforehand if you can. All 3 workshops count towards Part 1 of the HG Diploma. Ros Townsend’s live online training Trauma: Patterns of the past is also useful for anyone working with or supporting someone suffering from unresolved trauma, or who would like to understand their own experiences of trauma better. She also runs a workshop on working with Complex Trauma. -------------------------------------------------------------------------------- *ABOUT THE REWIND TECHNIQUE The Rewind Technique originated from one developed by Richard Bandler, one of the founders of NLP, when it was called the Visual/Kinaesthetic Dissociation protocol.  A variant of this was developed by Dr David Muss, who called it the Rewind Technique. The version of the Rewind Technique you will learn on this 2-day course was refined by Joe Griffin and Ivan Tyrrell, co-founders of the human givens approach, to make it as reliably effective and safe as is possible by aligning the method with their insights into how trauma and phobias are processed in the brain. HG Therapists now follow a specific Rewind Protocol which follows the essential steps of the process that Griffin and Tyrrell set out. -------------------------------------------------------------------------------- COURSE FORMAT This intense 2-day training proceeds through a blend of talks, live demonstrations, skill-developing exercises, practice sessions (under careful guidance) and deconstruction of filmed examples of the technique being used, including one with a severely traumatised young woman. There is also plenty of opportunity for networking and discussion during the breaks. The course was previously entitled: The fast phobia and trauma (PTSD) cure – a 2-day workshop in the rewind technique -------------------------------------------------------------------------------- This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

First Aid training – Emergency First Aid at Work (EFAW) (FAA Award Level 2) is QCF, Ofqual and HSE approved awarding organisation. -------------------------------------------------------------------------------- This course delivered over a minimum of 6 hours is both practical and theoretical covering responsibilities of the first aider, reporting, first aid hygiene, bleeding, shock, seizures, assessments, resuscitation, angina, heart attacks, choking, minor injuries and dealing with an unresponsive casualty, compliant with the latest health and safety executive regulations and guidelines. ATTIRE AND DRESS CODE We would recommend for all female candidates to wear trousers, comfortable shoes so that they can all practice the technique of CPR effectively on the CPR manikins. Dates for 2024 (please choose one for your course): 29 April,  24 June, 30 September, 28 October, 18 November, 23 December Duration : 6 hours (1 day) Time: 9:30am to 5:30pm Fee: £105.00 Location – The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk)) Two Certificates on completion (available for collection from the Academy in between 7 to 10 days) Regulated Certificate – valid for 3 years Verifiable CPD Certificate – 6 hours