59409 Courses

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

The current global demand for clean energy has resulted in rapid growth in the renewable energy sector. As the renewable industry grows, so does the demand for talent to work within it, bringing lots of new career prospects. The industry is the perfect transition for individuals leaving the armed forces who will have benefitted from exposure to many of the skills and experience, as well as the work ethic, that are required to work within this exciting, fast-paced industry.

During the 'own my life' sessions. We will explore the culture of abuse and violence, misogyny and disrespect in relationships. 'Own my life' is a 11-12 week programme that looks at healthy vs unhealthy and abusive relationships. The course explores how women can regain ownership of our lives following abuse including finding and owning our mind, body, choices, relationships, world, feelings. We will explore the culture of abuse and violence, misogyny and disrespect in relationships. We will use lots of resources to make it fun and informative and we will have lots of time for discussion. Sessions are all free and childcare can be provided. The link to the website is here: https://www.ownmylifecourse.org/what where you can find out more information. All women who attend will be given an 'Own My life' Journal which provides space for reflective practice and includes all the information provided throughout the course. -Suitable for women in abusive relationships or after they leave/ perpetrator is removed. Sessions are held weekly at the Sherwood community centre and are run by experienced, friendly and welcoming facilitators.

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

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

Being a Mentor in the Early Years

This Paediatric First Aid Training Course is a QA Level 3 Award and is recognised by Ofsted and includes the requirements of the appointed person in the workplace. This 2 Day Paediatric First Aid QA Level 3 award course is suitable for school staff, child minders, nursery assistants and staff who look after children as part of their working requirements. It will be of particular interest to Child Minders, Teachers, Crèche Assistants and staff who have a responsibility for children whilst in their care. You can be assured that you are meeting your First Aid Training requirements by attending this Paediatric First Aid Course which is Ofqual regulated. This 2 Day Paediatric First Aid course can also be delivered directly in your workplace for 6-10 delegates for only £1180.00 +Vat. Delivered in Liverpool, Manchester and across North Wales. The prevention of accidents is obviously preferable to giving first aid. Nothing can replace adequate supervision of a child in a friendly and relaxed environment. Now and again however, accidents and illness do happen and you may be called upon to give first aid to a child in your care. It is important therefore, to make a plan for how you would deal with such an emergency situation. The current EYFS statutory framework requires at least one person who has a current Paediatric First Aid certificate to be on the premises or outings at all times when children are present. According to EYFS guidance for effective paediatric first aid training; Training is designed for workers caring for children in the absence of their parents The training leading to a certificate or a renewal certificate is a minimum of 12 hours The Paediatric first aid training certificate should be renewed every 3 years Resuscitation and other equipment include baby and junior models, as appropriate Training covers appropriate contents of a first aid box for babies and children Training should include recording accidents and incidents For more information on our Paediatric first aid training courses delivered directly in your workplace anywhere in Liverpool, please email us or why not call us on 0151 515 0416 and speak to our experienced and friendly staff. Paediatric First Aid Training 2 Day - Liverpool

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

Duration 5 Days 30 CPD hours

Come along to this free event to find out more about Dramatherapy! Whether you're looking to explore an alternative approach to traditional talking therapy for yourself, or you're a therapist/healthcare professional wanting to find out more, this workshop is free and open to all who are curious! The two hours will be both informative and experiential, allowing you to dip your toe into the theories and techniques of Dramatherapy. Tea, coffee and pastries provided! Course Leader: Abigail Nelson