• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

52876 Courses in Sheffield delivered Online

Excel - advanced (In-House)

By The In House Training Company

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Excel - advanced (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Making of a Champion Making of a Champion helps support and develop young people to reach their potential. Modules include: Motivation Goal setting Work Commitment Dedication Courage Winning attitudes

Making of a Champion
Delivered OnlineFlexible Dates
Price on Enquiry

A level tuition

By Wessex Tutors & Exam Centre

A level one-to-one tuition

A level tuition
Delivered in Southampton or OnlineFlexible Dates
Price on Enquiry

Mental Health and Wellbeing

By Underscore Group

Learn a range of tools and techniques to boost your resilience and facilitate sustained performance in stressful times. Course overview The aim of this session is to equip all employees with a range of tools and techniques to boost their resilience and facilitate sustained performance in stressful times.  Objectives  By the end of the course you will be able to: Have a deeper understanding of mental health and application of mindfulness tools Use techniques to manage anxiety and attentional control apply techniques to improve attention stay focussed on key daily goals and manage their wellbeing. Content Boost your resilience. Explain the PERMA Model. Apply tools and techniques to boost your resilience. Learn how to measure your resilience and discover where to improve. Apply resilience building techniques for Mental Health Reducing stress through mindfulness techniques. Apply tools and techniques to manage anxiety and guide relaxation. Explain the psychology of achieving a balanced connection and living with purpose. Apply mindfulness techniques for balance and flow Focusing techniques to improve productivity. Apply techniques to attention control and learn how to be fully present and in the moment. Apply practical tools and techniques to stop distraction, improve focus and manage fear and fatigue

Mental Health and Wellbeing
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Arcserv (3 - Days )

By Nexus Human

Duration 3 Days 18 CPD hours

Arcserv (3 - Days )
Delivered OnlineFlexible Dates
Price on Enquiry

Diversity and Inclusion

By Underscore Group

Understand what diversity and inclusion is and how to manage it affectively in the workplace. Course overview Duration: 1 day (6.5 hours) Diversity and Inclusion in the workplace will help you develop an understanding of why diversity and inclusion is important to a business, what it is and how individuals and teams can work effectively together and harness the power that comes from valuing diversity and promoting inclusion. Objectives  By the end of the course you will be able to: Describe why diversity and inclusion is important in teams and organisations Explain and overcome unconscious bias and other beliefs that cause exclusion and impact the workplace Recognise your own diversity and understand the value of diversity and inclusion in teams Develop an Action Plan to create an inclusive work climate Content Understand Diversity and Inclusion What the Equality Act 2010 says about diversity Understanding protected characteristics Learn how to create an optimum climate to unlock the power of a diverse teams Understanding Yourself and Unconscious Bias Identify your own unique characteristics and how these could impact your performance Examine self-limiting beliefs and how these can impact personal performance Experience how unconscious bias impacts our information gathering, problem solving, judgement and decision making Creating a Diverse and Inclusive Team Climate Understand the importance of respect, the role of trust and what valuing diversity really means Apply the ABC Model to the creation of a diverse climate:Awareness – be alert, self-aware and aware of othersBoundaries – understand how things can go wrong when working with others: boundaries, banter and bullyingCoaching – learn listening and coaching skills to promote inclusion Create an achievable, personal action plan that can be applied immediately in the workplace to improve diversity, promote teaming and create an inclusive work climate

Diversity and Inclusion
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Food Hygiene Level 2

By Prima Cura Training

This is a full day session that will aim to provide a more in-depth understanding of Food Hygiene. It meets UK and EU legal requirements for food handlers & matches RSPH and CIEH level 2 syllabus

Food Hygiene Level 2
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Liberty Protection Safeguards (LPS) Update: DOLs

By Prima Cura Training

LPS was introduced in the Mental Capacity (Amendment) Act 2019 and is designed to simplify the process of authorising the care and treatment of a person who lacks capacity to consent to it, where it constitutes a deprivation of liberty. The LPS system introduces new structures, roles, and responsibilities for organisations so it is essential that staff and managers understand the implementation of LPS.

Liberty Protection Safeguards (LPS) Update: DOLs
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Resources for Learning Qualitative Research: Guided Group

5.0(1)

By Quirkos Software

If you are new to qualitative research or if you want some initial help to engage with the materials appropriately, then this webinar programme is for you. Doing Qualitative Research is a free curated resource we developed that takes researchers through the whole research cycle, not just the analysis. There is a heavy emphasis on what it is like to 'do' qualitative research in a robust, ethical and professional manner, with practical exercises and reflexive tasks suggested throughout. We are running two, one-hour webinars together with asynchronous, self-directed engagement with the course materials, to help a peer-group of researchers work through the resources on the parts of the qualitative research process they need help with. We understand that not everyone needs to cover the same materials and concepts, or at the same pace. In the first station, discussion with your peers and the facilitator, will help you choose which parts of the Doing Qualitative Research course to focus on before the second webinar. The concluding webinar uses group work and discussion for you to additionally practice one of the most important aspects of the qualitative research paradigm; reflexivity. You will identify what you have learned and how this affects what you will do next with your learning and research. The webinars are facilitated by our Qualitative Research Specialist Dr Cathy Gibbons. Cathy has almost 20 years' experience of teaching qualitative methods across a wide spectrum of disciplines within and beyond the social sciences. The session is free, and runs as two 2hr sessions, 2 weeks apart.

Resources for Learning Qualitative Research: Guided Group
Delivered OnlineFlexible Dates
FREE

'Advanced Cancer Pain Management' by Dr Kate Marley

5.0(80)

By Wirral Palliative Care Education Hub

'Advanced Cancer Pain Management' by Dr Kate Marley, Consultant in Palliative Medicine based in Woodlands Hospice, Aintree. This presentation will cover assessment of patients and selection of procedures and a brief overview of procedures available plus of course how to refer. Dr Marley is a consultant in Palliative Medicine based in Woodlands Hospice, Aintree. She underwent Palliative Medicine Specialty Training in the Mersey region and has worked in many of the hospices in this area. Her day to day roles include medical lead for IMPaCT North, Education co-lead for LUHFT and Palliative Medicine lead for the Joint Pain and Palliative Care Service in conjunction with the Walton Centre.

'Advanced Cancer Pain Management' by Dr Kate Marley
Delivered OnlineJoin Waitlist
FREE