1223 Management courses in Redhill

City & Guilds Level 3 Award in Direct Emergency Rescue and Recovery of Casualties from Confined Spaces - 6160-07 - This course is designed to introduce delegates to the basics of rescue and recovery of casualties from confined spaces. Understanding emergency arrangements as set by legislation and employers, some of the equipment required to rescue a casualty and safety of the rescue team. Note: A pre-requisite qualification is required to complete this course. Delegates must hold a valid 6160-08 qualification. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-07-level-3-award-in-direct-emergency-rescue-and-recovery-of-casualties-from-cs/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 3 Award in Supervising Teams Undertaking Work in Confined Spaces - 6160-05 - This course is designed to provide delegates with enough understanding of Safe Systems of Work to be able to authorise works and issue permits. It identifies the employer’s responsibilities within their own policies to allocate duties to competent employees. To achieve this qualification the delegate must hold the level 2 qualification relevant to their own work environment including the use confined space equipment. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-05-city-guilds-level-3-award-in-supervising-teams-undertaking-work-in-confined-spaces/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to use power tools. By the end of the course delegates will have an understanding of the correct operational procedures of power tools. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

The aim of the CCNSG Safety Passport is to ensure a basic knowledge of health and safety for all site personnel to enable them, after appropriate site induction, to work on site more safely with lower risk to themselves and others. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346 or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City & Guilds Level 2 Award in Working in High Risk Confined Spaces - 6160-03 - This course is designed to provide delegates that need to enter medium and high risk confined spaces with an in-depth understanding of legislation, regulations and safe systems of work. This course includes recognising all risk levels of confined spaces. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-03-city-and-guilds-level-2-award-in-working-in-high-risk-confined-spaces/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

City and Guilds level 2 Award in Entrant and Entry Controller for Confined Spaces (Medium Risk) - 6160-09 - This course is designed to provide delegates that need to enter confined spaces and hazardous areas with an in-depth understanding of the Legal requirements and the associated legislation, hazard identification and suitable control measures. Book via our website @ https://www.vp-ess.com/training/confined-spaces/6160-09-city-and-guilds-level-2-award-in-entrant-and-entry-controller-for-confined-spaces-(medium-ri/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

CS1 - (Medium Risk) Confined Space Entry And Entry Control - This course is designed to provide delegates that need to enter confined spaces with an in-depth understanding of the requirements of the law, associated regulations and safe systems of work. This course covers access, egress and safe working practices in confined spaces. Book via our website @ https://www.vp-ess.com/training/confined-spaces/cs1-confined-space-entry-with-escape-sets/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

We all tend to have challenges throughout our lives that cause varying levels of pressure. It is healthy and essential that people experience such challenges because up to a certain point an increase in pressure improves performance and quality of life. Too much pressure can be harmful and affect our health and wellbeing. This participative half-day workshop will explore the causes and impact of stress and provide an opportunity to learn some new ideas and techniques to cope with it. Practical tasks and exercises will be used to promote discussion and participants will be encouraged to share their own experiences and approaches. By the end of the workshop participants will be able to: Understand the causes and symptoms of stress and how to spot them Become more aware of personal habitual behaviours and approaches that get in the way of dealing with stress productively Learn ideas and approaches that help you to cope with the thoughts, emotions and physical feelings that happen in stressful and difficult situations Review and evaluate learning and have an action plan to take back and put into practice at work 1 Welcome, introductions and objectives Breaking the ice 2 Stress Its sources and effects on you Defining stress, its signs and symptoms 3 Exploring your 'default' habits Their consequences in stressful situations 4 Dealing with perception Strategies and approaches for coping with stress 5 Setting goals with positive outcomes Review and evaluation of learning Action planning

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

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors