921 Design courses in Godalming

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Crisis Media Training Benefits  There are many reasons why businesses and organisations suddenly find themselves trending on social media or being talked about in the broadcast media. When something goes wrong, your every move is watched and then commented on online, putting you and your teams under even more pressure. So if the worst should happen and you find yourself or your company or business suddenly in the public eye, you need to be prepared. We’ll help you learn how to manage your response ensuring clarity and confidence. It’s vital you don’t leave a vacuum for others to fill so let us help you respond effectively. Why would I ever need Crisis Training? Brand reputation is the most important asset we have in the digital media age. Audiences want to engage with organisations which have credibility and authenticity. A crisis – not always of your making – can quickly undermine that if it’s handled badly. Communication is at the heart of crisis media training and we can show you how to deal with a wide range of situations, address concerns and criticism and ensure your message reaches audiences under the most pressured circumstances. Who needs to attend the training? Crisis Media Training isn’t just for the most senior CEO’s or Managing Directors. In order to support the authenticity of your response it’s important the people on the ground can talk to the public. And in the age of social media, if you’re talking to the public, you’re talking to the media. So the people dealing with the crisis are the people who should know how to communicate in a crisis. There are times when the top bosses must talk as they are accountable and are happy to demonstrate that level of responsibility. But the media will also ask to talk to the people handling the problem and we can show them how. How do I book Crisis Media Training? We can help you create the perfect training to stress test your messaging and make sure you’re ready to deliver your message if you find yourselves unexpectedly in the news. We’ll help you deal with challenging questions and diffuse the most tense of interviews. But our main criteria is that we design the training you want so we’ll work with you to create the perfect course. All you have to do is give one of our friendly team a ring on 0754 533 4269 or email us.

“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.

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

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

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.