944 Design courses in Guildford

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Elevate your skills in designing, delivering and evaluating engaging and interactive training that will leave a lasting impact on your team or organisation Course overview Duration: 2 days (13 hours) This Train the Trainer workshop will enable you to gain valuable insights and practice helping you to feel more comfortable and confident delivering training sessions. We will look at some training best practice tools and techniques to ensure you can deliver the learning outcomes required. The workshop covers the training cycle but focuses heavily on interactive and practical training techniques to bring learning to life for participants. There will be opportunities to practice delivery of real work-based training and receive feedback on delivery style. Objectives  By the end of the course you will be able to: Explain Kolb’s model of how adults learn Describe the 4 key learning styles and how to engage people with different learning styles Apply the training cycle to plan, design, deliver and evaluate your training Write SMART training objectives Use and select a variety of methods to make your training interactive, engaging and effective Describe ways to deal with difficult participants or situations that may arise Apply your training skills to deliver structured training sessions with more competence and confidence Content The Training Cycle Assessing needs Planning and preparing Implementing training Reviewing Assessing Assessing Needs Understanding the task Assessing the learner’s current ability Identifying the gap Planning and Preparing Having clear outcomes in mind What people learn: o Knowledge o Skill o Understanding How people learn: preferences and learning styles and methods suitable for each Planning a programme Planning a session – a systematic approach Assessing risk Writing and using SOPs in training Key Skills for Effective Training Explanation and Demonstration Questioning and Listening Observation and Feedback Facilitation and Debriefing skills Coaching Using questioning, listening and feedback to help learners solve problems and develop confidence Evaluation and Assessment How to measure reactions and participant satisfaction Use of tests and assessments to measure learning Organisational measures of learning transfer Leverage You will have the opportunity to deliver two training sessions on this programme and gain valuable feedback to support you in your ongoing training delivery. Participants are required to prepare a 15 minute training session. This can be something you have delivered before or something you’ve created for the course. Please prepare and include any visual aids you would usually use when speaking and bring them with you, f possible, please also bring your smart phone (with camera, and memory capacity for a short video clip to be added), and headphones.

“Most people thinking about suicide don’t want to die, they want the pain to stop, recognising the signs that someone is thinking about suicide is critical as is the ability to listen and to support that person away from wanting to take their own life” Programme Overview: This 1 day in-person programme provides Learners with the foundational knowledge and practical skills needed to effectively intervene in situations where someone may be contemplating suicide. Designed for individuals across various professions and community roles, this programme equips you with the tools to recognise the signs of suicide, initiate life-saving conversations, and connect at-risk individuals with appropriate resources. Whether you're a healthcare professional, educator, HR personnel, or concerned community member, this programme empowers you to make a real difference. Key Learning Outcomes: Understanding Suicide and Its Causes: Gain insights into the complex factors that can lead to thoughts of suicide and suicide behaviours, including mental health issues, emotional distress, and societal pressures. Recognising Signs: Learn how to identify the verbal, behavioural, and situational indicators that someone may be thinking of suicide. Effective Communication Techniques: Develop skills to engage in sensitive and supportive conversations, helping to de-escalate crises and offer hope to those in need. Immediate Intervention Strategies: Acquire practical tools and approaches for providing immediate support, including how to refer individuals to mental health professionals and other resources. Ethical Considerations: Understand the ethical responsibilities involved in suicide prevention, including confidentiality, consent, and the importance of self-care. Programme Format and Duration: This is a concise, focused programme delivered in person and lasting 1 day. The programme includes a mix of interactive presentations, real-life case studies, and role-playing exercises to ensure Learners leave with practical, actionable skills. Who Should Attend: Anyone in a position to support individuals with thoughts of suicide, including healthcare providers, educators, HR managers, community leaders, and social workers. No prior experience in mental health or suicide prevention is required. Certification: Upon completion, Learners can gain the Royal Society for Public Health (RSPH) Level 4 Award in Suicide First Aid®. This is a written assignment and upon completion Learners will receive an official qualification certificate from RSPH. Why This Programme Matters: By equipping yourself with the skills taught in this programme, you become a crucial part of the effort to reduce suicide rates and save lives. Every intervention can make a difference. We are incredibly grateful for the sponsorship of Jane Cattermole, from Mainly Mental Health which has allowed us to offer this training at a heavily subsidised rate.

The QA Level 2 Award in Principles and Practice of Moving People Safely (RQF) is a regulated and nationally recognised qualification that has been specifically designed for those who work, or intend to work, in a role that involves assisting and moving people.  This 1 day course provides candidates with a clear understanding of the principles of moving people safely and includes the opportunity to practise and apply these principles in a variety of situations; individually, in a team, and with the assistance of equipment.  Candidates will leave the course with the knowledge and skills required to move people safely whilst ensuring that the risk of personal harm is reduced and that health and dignity are retained.

Did you know that following a cardiac arrest, every minute without CPR and defibrillation reduces a casualty’s chance of survival by 10%?  Sudden cardiac arrest is one of the UK’s biggest killers, and yet statistics show that most of the British public are unaware of the life-saving difference they can make by performing CPR and defibrillation.  The QA Level 2 Award in Basic Life Support and Safe Use of an Automated External Defibrillator (RQF) qualification has been designed to provide candidates with the skills needed to administer safe, prompt and effective basic life support and use an AED safely in emergency situations.  With an estimated 60,000 out of hospital cardiac arrests occurring every year in the UK alone, make sure you are prepared!

The QA Level 3 Award in Administering Emergency Oxygen (RQF) qualification has been designed for those who are responsible for providing care to casualties where the administration of emergency oxygen may be required.  Over a half day period, candidates will learn about the clinical need for emergency oxygen and the safety considerations of this, as well as how to administer emergency oxygen when dealing with a range of conditions. Successful candidates will leave the course with the knowledge and skills needed to administer emergency oxygen both safely and effectively.  Achievement of this qualification confirms candidates have met both the theoretical and practical requirements, however, it does not imply a ‘license to practice’ – the scope of practice is determined by the organisation responsible for oxygen provision. This qualification does not allow candidates to obtain, store or administer oxygen without clinical governance.

This course is an infant, adolescent, and adult-certified course FOR A GROUP AT YOUR LOCATION OR OURS. First Aid/CPR/AED/Bleeding Control course certified. This is a group course designed for business staff training, churches, sporting venues, and anywhere where CPR/First Aid/AED/Bleeding Control is required.

Emergency Paediatric First Aid delivered by healthcare professionals - Educating through Experience

The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.

This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.