1251 Management courses in Tring

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 three-day FAW course is our most thorough First Aid course. It is designed for you if you are a nominated First Aider in a hazardous environment, such as a factory or a construction site, as well as providing you with complete training for any other work situation.

This one-day course will help you meet your regulatory requirements if your risk assessment indicates that first aid training covering emergency protocols only, is sufficient for your workplace.

This course is suitable for operatives required to Work at Height, and will give operatives a sound foundation on the requirements of the Work at Height Regulations 2005 and other relevant regulations. Also highlights the principles of how fall protection systems / equipment should be selected and used. This course will provide delegates with the knowledge and practical experience to enable them to work safely at height using a variety of basic systems and techniques. Book via our website @ ESS | Working at Height Module 2 - Safe Work at Height (General Operative) | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This course is suitable for operatives required to Work at Height, providing a sound foundation on the requirements of the Work at Height Regulations 2005 in conjunction with a basic understanding of the types of fall protection systems and equipment available, its use, its limitations and unsafe practices. Suitable for individuals working around but not directly Working at Height. It allows the delegate to identify a working at height area and understand the procedures and regulations that control it. Book via our website @ ESS | Working at Height Module 1 - Safe Work at Height Awareness | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

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

Standard or Custom Excel courses at Introduction, Intermediate, Advanced and Super User level. Click on the link below for full details: Excel 365 courses

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

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.

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.