1190 Management courses in Royston, Hertfordshire

Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle

This is an essential programme for members of staff whose role exposes them to aggressive or violent behaviour. 1 What's happening? Issues around us Risks in context Personal experiences 2 Safety fundamentals Following internal policy and procedure Personal safety and lone working Use of technology 3 Nipping issues in the bud Recognising early warning signs Avoiding causing problems for ourselves 4 Calming - Reaching - Controlling Tips and techniques for potentially calming a situation Reaching and building rapport Accelerants - tips on avoiding accelerating a situation Assertiveness techniques Non-verbal behaviour Active listening and the use of questions and distractions Exploring ways forward and identifying win/wins Avoiding the secondary argument Fogging The 'drama triangle' If all else fails... 5 Harassment, stalking and on-line bulling What constitutes harassment and definition of stalking On-line bullying Steps to take 6 Reporting principles Importance of incidence reporting Taking care of us What next?

Course Outline: What is “Diversity and Inclusion”?  The Cultural Contact Lens - understanding different people's experiences  The Social Ecological Model - understanding how individual elements sit within and impact upon social change  Finding your ‘why’, and the Business Case for D&I  Going above and beyond the Law - the Equality Act (2010) and protected characteristics  Becoming comfortable with feeling uncomfortable  Privilege, power, and the Cycle of Oppression  An introduction to allyship  Summary and questions

This is an opportunity to benchmark your current and future safety and health vision and priorities in line with global models of safety, and to benefit from good practice gathered from leading organisations from around the world. Through lively discussion, debate and exercises, including benchmarking, gap analysis and case studies, leaders attending this programme deepen their understanding of how to use their skills to drive their organisation to the next level in its safety and health performance. The programme is designed to help leaders:

All employees should be aware of and knowledgeable about health and safety in the workplace. This course is ideal for all staff and employees at all levels, providing them with the underpinning health and safety knowledge that they will require to work safely and efficiently on a daily basis.

Are you an EDI Officer, HR Specialist, Leader or Manager? Or the nominated EDI champion for your team? Maybe you've been given the EDI portfolio on behalf of your Board or department? Or if you're aiming to make a difference via your diverse staff network or union, all change-makers are welcome!

A fire, or similar emergency can happen at any time in your workplace. Fire safety awareness refers to the knowledge and understanding of the precautions and measures that individuals can take to prevent fires from occurring and to minimize the damage caused by fires. This course will ensure that your staff and their managers all know what to do to maximize safety in the event of a fire or a gas leak.

The duty of care is a legal requirement and comes with the job role for any Care worker. It is part of the code of conduct for healthcare support workers and adult social care workers in England and applies as soon as someone receives treatment or care. Employees also have a duty of care to other workers.

The Food Hygiene Regulations 2006 are considered to be the most important food safety and hygiene regulations in the UK. These regulations go one step further than the Food Safety Act 1990 as they specify that ALL food businesses have a legal obligation to make sure that food they prepare and serve to the public is safe and hygienic.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print