3847 Courses in Liverpool delivered Live Online

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Improve your riding and gain world-class qualifications as a snowboard instructor. With 4 - 11 week training options, you can ride for a month or a whole season.

The RQF Level 3 Outdoor First Aid Course is designed for individuals engaging in outdoor activities, offering advanced training in managing emergencies specific to outdoor environments. Here's a concise overview: Specialised Training: Tailored for outdoor enthusiasts, professionals, and leaders involved in remote outdoor activities or expeditions. Comprehensive Skills: Covers assessing and managing injuries, trauma care, medical emergencies, and evacuation procedures relevant to outdoor settings. Scenario-Based Learning: Simulated outdoor emergencies, providing practical application of skills in realistic scenarios encountered during outdoor pursuits. Remote Environment Preparedness: Emphasis on handling emergencies where immediate medical assistance might be limited, focusing on adaptability and resource utilisation. Hands-on Training: Practical sessions demonstrating wilderness-specific first aid techniques, including the use of specialised equipment. Communication and Decision-making: Training in effective communication and teamwork during outdoor emergencies, fostering quick and coordinated responses. This course equips outdoor enthusiasts, guides, and professionals with advanced first aid skills, preparing them to manage a wide array of outdoor emergencies in remote or challenging environments. Suitability - Who should attend? The RQF Level 3 Outdoor First Aid Course is suitable for: Outdoor Enthusiasts: Hikers, climbers, campers, and adventurers seeking skills to manage emergencies during outdoor pursuits. Professional Guides: Outdoor leaders, expedition leaders, and instructors responsible for group safety during outdoor activities. Workers in Remote Environments: Forestry workers, park rangers, and those working in remote or wilderness settings where immediate medical help might be limited. Sports Coaches: Coaches involved in outdoor sports or activities requiring knowledge of first aid in outdoor environments. Volunteers and Community Members: Individuals participating in community-based outdoor programs or volunteering in remote areas. Professionals with Outdoor Responsibilities: Individuals whose roles involve outdoor responsibilities and the need for advanced first aid skills in such settings. It's ideal for anyone seeking to enhance their ability to respond to outdoor emergencies where access to immediate medical assistance is limited. Outcome / Qualification etc. The outcomes of completing the RQF Level 3 Outdoor First Aid Course include: Advanced First Aid Skills: Proficiency in managing a broad range of outdoor-specific injuries and medical emergencies encountered in remote settings. Confidence and Preparedness: Enhanced confidence to assess, manage, and provide first aid in challenging outdoor environments. Scenario Adaptability: Ability to adapt first aid skills to diverse outdoor scenarios and make informed decisions in remote or adverse conditions. Effective Communication: Improved communication and teamwork skills essential for coordinating responses to outdoor emergencies. Emergency Preparedness: Understanding evacuation procedures, resource improvisation, and utilising outdoor-specific first aid equipment. Certification: Attainment of an accredited qualification demonstrating competence in outdoor first aid management. Completing this course ensures participants are well-equipped to respond competently and effectively to a wide array of outdoor emergencies. Training Course Content UNIT 1 OUTDOOR EMERGENCY ACTION Module 1 Introduction Module 2 What is outdoor first aid? Module 3 First aid equipment Module 4 Summon assistance Module 5 Monitoring Module 6 Scene survey Module 7 Primary survey Module 8 Secondary assessment Module 9 Resuscitation and AED Module 10 Disorders of respiration Module 11 Wounds and bleeding Module 12 Hypovolaemic shock UNIT 2 OUTDOOR INCIDENT MANAGEMENT DAY 2 Module 1 Incident management Module 2 Bones, joints and muscle injuries Module 3 Head and spinal injuries Module 4 Chest and abdominal injuries Module 5 Major illnesses Module 6 Anaphylaxis Module 7 Extreme heat and cold Module 8 Burns Module 9 Eye injuries Module 10 Poisoning Module 11 Bites and stings Module 12 Written assessment and course closure Course delivery details The delivery of the RQF Level 3 Outdoor First Aid Course typically involves a combination of: Classroom Sessions: In-person training covering theoretical aspects of outdoor first aid, including lectures, discussions, and presentations. Practical Workshops: Hands-on sessions allowing participants to practice first aid skills specific to outdoor scenarios, utilising equipment and simulations. Outdoor Simulations: Realistic scenario-based training in outdoor environments, replicating emergencies encountered during outdoor activities. Interactive Learning: Engaging activities, group exercises, and case studies to reinforce learning and encourage interactive participation. Qualified Instructors: Training facilitated by experienced and certified outdoor first aid instructors knowledgeable about outdoor emergency management. Assessment and Certification: Evaluation of skills and understanding through practical assessments, quizzes, or examinations leading to certification upon successful completion. This mixed approach ensures a comprehensive understanding and practical application of first aid skills tailored for outdoor settings. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid Expenses Travel costs and lunch required, there are many cafes and sandwich bars here in Much Wenlock to buy your lunch, you may eat it in the training room. All training material, books, qualification certificates are included in the price Continuing Studies After completing the RQF Level 3 Outdoor First Aid Course, individuals may pursue further studies or complementary training, including: Advanced Outdoor First Aid Courses: Specialised courses focusing on specific aspects like wilderness trauma, advanced rescue techniques, or extended wilderness medical training. Wilderness Medicine Certification: Advanced programs offering in-depth knowledge in wilderness medicine, ideal for those aiming for higher expertise in outdoor medical care. Leadership and Outdoor Education Courses: Studies in leadership, outdoor education, or adventure sports coaching, complementing first aid skills for leadership roles in outdoor settings. Specialised Rescuer Certifications: Training in technical rescue skills, rope rescue, water rescue, or other specialized rescue techniques relevant to specific outdoor activities. Medical Certification Programs: Pursuing medical certifications or courses in emergency medicine, paramedicine, or healthcare, enhancing medical expertise for outdoor settings. Continued education allows individuals to deepen their understanding, broaden their skill set, and specialise further in managing emergencies in diverse outdoor environments

Supervising First Aid for Mental Health | RQF Level 3 The RQF Level 3 Supervising First Aid for Mental Health course is designed to provide individuals with the knowledge and skills to effectively supervise and support others in the workplace who may be experiencing mental health issues or distress. This course aims to equip participants with a deeper understanding of mental health, enabling them to provide guidance, reassurance, and signposting to appropriate professional help. Understanding Mental Health: Participants will gain a comprehensive understanding of mental health, including common mental health conditions, their causes, and the impact they can have on individuals and workplaces. They will learn to recognize signs and symptoms of mental health issues and develop an understanding of the stigma and misconceptions surrounding mental health. Promoting a Positive Mental Health Culture: Participants will explore strategies to promote a positive mental health culture in the workplace. This includes raising awareness, reducing stigma, and fostering a supportive and inclusive environment that prioritises mental well-being. Providing Mental Health Support: Participants will learn how to provide immediate and practical support to individuals experiencing mental health issues or emotional distress. They will be trained in active listening skills, effective communication techniques, and providing non-judgmental and empathetic support. Signposting and Referral: Participants will develop the skills to signpost individuals to appropriate professional help and resources. They will learn about available support services, both within and outside the workplace, and how to facilitate access to these services. Crisis Management: Participants will be prepared to respond to mental health crises and emergencies. They will learn how to assess risk, manage situations involving self-harm or suicidal ideation, and understand the importance of maintaining personal and professional boundaries. Supporting Workplace Mental Health Policies: Participants will understand the importance of workplace mental health policies and how to support their implementation. They will explore the role of supervisors in promoting mental health, identifying potential triggers or stressors in the workplace, and implementing strategies to support employee well-being. Successful completion of the RQF Level 3 Supervising First Aid for Mental Health course indicates that participants have developed the necessary knowledge and skills to effectively supervise and support individuals experiencing mental health issues in the workplace. They will be equipped to provide guidance, signposting, and initial assistance, contributing to a mentally healthy and supportive work environment. It's important to note that this course does not qualify participants as mental health professionals or therapists. It is focused on providing basic mental health support and guidance in the workplace context. If participants wish to pursue more in-depth training or a career in mental health, they may consider further studies or qualifications in mental health counseling, psychology, or related fields. Suitability - Who should attend? The RQF Level 3 Supervising First Aid for Mental Health course is suitable for individuals who have a responsibility for supervising and supporting others in the workplace, particularly in relation to mental health. It is beneficial for supervisors, managers, team leaders, human resources personnel, and anyone in a position of authority or influence within an organization. This course is relevant for individuals across various industries and sectors who wish to develop their understanding of mental health, enhance their skills in supporting others, and contribute to creating a mentally healthy work environment. It is especially suitable for those who have regular interactions with employees or colleagues and are involved in promoting well-being and providing guidance. The course is valuable for individuals in roles where they may be responsible for implementing mental health policies, supporting employees facing mental health challenges, or providing initial assistance in crisis situations. It equips participants with the knowledge and skills to recognize signs of mental health issues, provide appropriate support and signposting, and contribute to fostering a positive mental health culture within their organization. While there are no strict prerequisites for enrolling in the RQF Level 3 Supervising First Aid for Mental Health course, some prior knowledge or experience in mental health awareness or first aid can be beneficial. However, the course is designed to accommodate learners with varying levels of understanding and experience in the field. It's important to note that this course does not qualify participants as mental health professionals or therapists. It focuses on providing fundamental knowledge, skills, and guidance for workplace mental health support. If you require more advanced or specialised training in mental health, it may be necessary to consider additional qualifications or seek professional development opportunities in specific areas of interest. Before enrolling in the course, consider the specific requirements and recommendations of your workplace or industry. Discuss the suitability and relevance of the course with your employer or supervisor to ensure it aligns with your professional development goals and responsibilities within your organization. Outcome / Qualification etc. Upon successful completion of the RQF Level 3 Supervising First Aid for Mental Health course, participants can expect to achieve several learning outcomes: Comprehensive Understanding of Mental Health: Participants will develop a thorough understanding of mental health, including different mental health conditions, their causes, and their impact on individuals and workplaces. They will gain knowledge about the prevalence of mental health issues and the importance of promoting mental well-being in the workplace. Recognition of Mental Health Issues: Participants will be able to recognize signs and symptoms of common mental health conditions, enabling them to identify when someone may be experiencing mental health issues or emotional distress. They will develop skills in observation, active listening, and empathy to assess the well-being of others. Effective Support and Signposting: Participants will acquire the skills to provide immediate support and guidance to individuals experiencing mental health issues. They will learn active listening techniques, effective communication strategies, and non-judgmental approaches to engage with and support others. They will also be able to signpost individuals to appropriate professional help and resources. Creation of a Mentally Healthy Workplace: Participants will understand their role in promoting a mentally healthy workplace culture. They will learn strategies to reduce stigma, raise awareness, and create a supportive environment that prioritizes mental well-being. They will also gain knowledge on how to implement workplace mental health policies and practices. Crisis Management and Referral: Participants will be prepared to respond to mental health crises and emergencies. They will develop skills in assessing risk, managing situations involving self-harm or suicidal ideation, and understanding the importance of timely and appropriate referral to professional mental health services. Supervision and Support Skills: Participants will develop skills in supervising and supporting others in the workplace who may be experiencing mental health issues. They will gain confidence in initiating conversations about mental health, providing guidance, and creating an atmosphere of trust and understanding. Successful completion of the RQF Level 3 Supervising First Aid for Mental Health course indicates that participants have achieved a higher level of knowledge and skills in supporting individuals with mental health challenges in the workplace. They will be equipped to provide appropriate support, signposting, and supervision, contributing to a mentally healthy and supportive work environment. It's important to note that while the course provides valuable knowledge and skills, participants should not consider themselves as mental health professionals. Ongoing professional development and engagement with mental health resources and services are essential to stay updated and provide the best support possible. Training Course Content DAY 1 Module 1 Introduction Module 2 What is first aid for mental health? Module 3 Identifying mental health conditions Module 4 Providing advice and starting a conversation Module 5 Stress Module 6 Drugs and alcohol Module 7 First aid action plan for mental health - including practical assessment Module 8 Mental health in the workplace Module 9 Depression Module 10 Anxiety Module 11 Written assessment - paper 1 DAY 2 Module 1 Syllabus and day 1 recap Module 2 Post-traumatic stress disorder Module 3 Self-harm Module 4 Suicide Module 5 Eating disorders Module 6 Personality disorders Module 7 Bipolar disorder Module 8 Psychosis Module 9 Schizophrenia Module 10 Written assessment paper 2 and course closure Course delivery details Classroom-based Training: Many training providers offer the course through traditional classroom-based sessions. Participants attend in-person training conducted by qualified instructors. These sessions provide opportunities for interactive discussions, practical exercises, case studies, and group activities to enhance learning and understanding of the course material. Blended Learning: Some training providers may offer a blended learning approach, combining both online and face-to-face components. Participants may complete certain modules or theory-based learning online at their own pace. The in-person sessions are then focused on interactive discussions, practical skills demonstrations, and group activities. Online Learning: In certain cases, the course may be delivered entirely online. Participants can access course materials, videos, interactive modules, and assessments through a dedicated online learning platform. Online learning offers flexibility in terms of when and where participants can engage with the course content. In-house Training: Organisations may opt for in-house training where a qualified instructor delivers the course directly to their employees or staff members. This can be customized to suit the specific needs and context of the workplace, allowing for more tailored discussions and examples relevant to the participants' roles and environment. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid Expenses Travel costs and lunch required, there are many cafes and sandwich bars here in Much Wenlock to buy your lunch, you may eat it in the training room. All training material, books, qualification certificates are included in the price. Continuing Studies Upon completing the RQF Level 3 Supervising First Aid for Mental Health course, there are various opportunities for continuing studies and professional development in the field of mental health and workplace well-being. Here are some options to consider: Advanced Mental Health Training: If you wish to deepen your knowledge and skills in mental health, you may consider pursuing advanced training courses. These could include specialized courses on specific mental health conditions, such as depression, anxiety, or post-traumatic stress disorder (PTSD). Advanced courses can provide you with a more in-depth understanding of specific areas within the mental health field. Mental Health First Aid Instructor Training: If you have a passion for teaching and training others, you might consider becoming a certified mental health first aid instructor. Instructor training programs can equip you with the necessary skills and qualifications to deliver mental health first aid courses to others. This allows you to contribute to building a mentally healthier workforce by educating and empowering others. Workplace Well-being Programs: Many organizations are investing in workplace well-being programs to support the mental health of their employees. You could explore opportunities to get involved in developing and implementing such programs within your organization. This might involve collaborating with human resources, management, or well-being teams to design initiatives that promote mental health, resilience, and work-life balance. Higher Education and Further Studies: If you're interested in pursuing a more extensive education in mental health, you may consider enrolling in higher education programs related to psychology, counselling, or mental health. This could include undergraduate or postgraduate degrees, diplomas, or certifications that provide a deeper understanding of mental health theory, research, and clinical practice. Continuous Professional Development (CPD): Engaging in continuous professional development is essential in staying updated with the latest research, best practices, and developments in the field of mental health. Attend workshops, conferences, webinars, and seminars focused on mental health topics. These activities will enhance your knowledge and skills and ensure you stay current with evolving practices in the mental health field. Volunteer and Community Work: Engaging in voluntary work or community initiatives related to mental health can provide valuable hands-on experience and further develop your skills. Consider volunteering with mental health organizations, helplines, or community groups that focus on mental health support and advocacy. Remember to stay informed about the guidelines, regulations, and requirements set by relevant professional bodies or organizations in your country or region. This will help you align your continuing studies and professional development with recognised standards and qualifications. Continuing studies and professional development not only enhance your knowledge and skills but also demonstrate your commitment to the field of mental health and workplace well-being.

WANT TO LOSE WEIGHT, HAVE MORE ENERGY AND FEEL MORE HAPPY? The Menopause Lifestyle Project is a group programme and an opportunity to work with me in person, in the studio. The 4 week course is educational and will introduce you to what menopause is, why it happens, symptoms related to it and how you can best manage your lifestyle during this period. There is also be an introduction to strength training and a video programme to follow, either at home or in the gym. For more details on the next programme please get in touch.

CORPORATE TRAINING There are currently 13 million women going through menopause in the UK. 4.3 million of them are aged between 45-55 years old, which is the fastest growing demographic in the workforce SB Wellbeing provides training for companies who are serious about providing support for their female staff going through menopause. Also, up-skilling managers and leaders on what they need to know.  Manager training includes what menopause is, how it can affect the individual at work, as well as the bigger picture of how it can impact the business, and how best to support them.    Colleague training is for anyone going through menopause or supporting someone who is. It's fully inclusive and highly interactive.  The two programmes can be run back to back or separately and be delivered via webinar or in-person. For more information and to book your training please get in touch. Here's what people are saying... " Thank you Sally for an amazing presentation yesterday – I had lots of the team say how good it was and how much they had learnt." - Leonard Design Architects, Nottingham "Just to say everyone absolutely loved training session 1!! The feedback from the second session was ace!! - Co-op Academy, Failsworth   "Open & frank conversation. Very factual and a great all round guide" - tp bennett, London   "The more staff that have this training the better, especially principle/director level." - tp bennett, London

Learn how to support employees living with chronic health conditions and get answers to your workplace wellbeing questions from recognised experts in the field.