1610 Courses in London

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

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

professional financial modelling and data analysis courses

Slinger Signaller Training The aim of the NPORS Slinger Signaller Training or Slinger Signaller Course is to provide both theoretical and practical training in the safe and efficient operation of slinging and moving loads using hand signals or radios Guided by the Lift Supervisor. On successful completion of the slinger and signaller course you will be issued with the NPORS Slinger Signaller trained identity card with or without the CSCS Logo or testing can be carried out on your site nationwide or at our training centre in Gloucestershire NPORS Slinger Signaller Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Slinger And Signaller Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Slinger and Signaller Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Slinger Signaller Experienced Worker Test .This test is for operators who have received some form of training in the past or alternatively has been operating as a Slinger Signaller for a period of time. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. This test is held at our test centre in Gloucestershire or at your site nationwide. Discounts are available for multiple bookings Turn your Slinger Signaller red card to blue with our hassle free NVQ, for more information CLICK HERE Slinger Signaller Course Duration Novice: 2 days, maximum of 3 candidates Experienced Worker Test: 1 day test only, maximum of 6 candidates. Location: Tewkesbury Training Centre At Our Customers Site*: Our instructors travel throughout the UK to deliver the slinger signaller training *Mileage and accommodation charges may apply Certification NPORS Traditional card – lasts for 5 years and is mainly accepted with housebuilders, utilities, port and marine as proof of competence OR NPORS card with CSCS logo – accepted by all major building contractor’s. The initial card is the RED trained operator card which lasts for 2 years and can be upgraded to BLUE competent operator card further to completion of relevant NVQ. CSCS Health & Safety Test If you require the NPORS Slingers Red operator card with the CSCS logo on then you must have completed the operatives health and safety test within the last two years. In house certificates: suitable as proof of operator competence accepted for insurance and HSE compliance. Slinger Signaller Course Contents: A Slinger Signaller course typically covers a range of topics related to the safe operation of lifting equipment and the signalling procedures involved in crane and lifting operations. While specific course contents may vary depending on the training provider and the regulations of the region, here’s a general outline of what will be included: 1. Introduction to Lifting Operations: Overview of lifting equipment and machinery. Importance of safe lifting operations. Legal and regulatory requirements for lifting operations, LOLLER, PUWER and BS 7121. 2. Roles and Responsibilities of Slinger and Signaller: Duties of the slinger signaller. Understanding the roles of other personnel involved in lifting operations (crane operator, banksman, etc.). Importance of effective communication and coordination. 3. Health and Safety: Risk assessment and hazard identification. Personal protective equipment (PPE) requirements. Safe working practices around lifting equipment and machinery. 4. Lifting Equipment and Accessories: Types of lifting equipment (cranes, hoists, slings, etc.). Inspection and maintenance requirements for lifting gear. Proper selection and use of lifting accessories. 5. Signals and Communication: Standard hand signals for crane operations. Radio communication procedures between Crane Driver & The Slinger and Signaller. Clear and effective communication techniques. 6. Load Identification and Weight Estimation: Methods for identifying loads and determining their weights. Estimating centre of gravity and load stability. 7. Slinging Techniques: Types of slings and their applications. Correct methods for attaching and securing loads. Precautions for different types of loads (e.g., fragile, hazardous). 8. Lifting Operations Planning: Pre-lift checks and planning considerations. Site-specific factors affecting lifting operations (e.g., terrain, weather). Emergency procedures and contingency planning. 9. Practical Exercises and Demonstrations: Hands-on training with lifting equipment and machinery. Practice sessions for signalling and communication. Simulation of real-world lifting scenarios. 10. Assessment and Certification: Written tests to assess theoretical knowledge. Practical assessments of signalling and slinging skills. Certification upon successful completion of the course. It’s essential for the Slinger Signaller Course to provide a balance of theoretical knowledge and practical skills to ensure that participants can effectively carry out their duties as slinger signallers in various lifting operations. Additionally, the course should emphasise the importance of safety and adherence to regulations throughout all aspects of lifting operations. Slinger Signaller Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the Slinger Signaller and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment as a slinger signaller Our slinger and signaller training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS slinger Tester to your site nationwide, to reduce the amount of time away from work Other courses: Master the operation of essential machinery with our Lift Supervision Training, Telehandler Training, Cat & Genny Training, Ride-On Road Roller, Scissor Lift, Abrasive Wheel Training, Lorry Loader Training and Telehandler Training. Elevate your skills for safer and more efficient operations in construction and maintenance projects. Enrol today to advance your career prospects in these industries. Location Advantage: NPORS Slinger Signaller Training Near Me For those looking for a “NPORS Slinger Signaller Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

Unlock the potential of your primary school students with our exclusive workshop in Essex, UK. Join us for a full-day training on 'Empowering Young Minds: Cultivating Healthy Self-Esteem in Children.' Equip your staff with practical strategies to recognize and address self-esteem challenges, fostering a positive and affirming school environment. Contact us now to book your date and invest in the well-being of your students and staff.

Severe allergic reactions (anaphylaxis) can kill without immediate first aid. The UK is one of the top countries in the world for incidence of allergies. This course covers the management of anaphylaxis and the use of auto-injectors for the initial treatment of anaphylaxis.

Infection prevention and control is essential for all businesses, particularly where the working environment or work activities could put employees and those around them at risk of infection. This includes those working in healthcare, in close contact with people or animals, and those involved in the cleaning of human and animal waste. Infections can be easily spread, but by understanding the correct steps to take, the risk of their occurrence can be both prevented and controlled.

Falls prevention is a variety of actions to help reduce the number of accidental falls suffered by older people. Falls and fall-related injuries are among the most severe and common medical problems experienced by older adults. Training, supervision and tailored exercise programmes can reduce falls by as much as 54%.

Moving and Handling is so much more than lifting and carrying. Whether we lift, carry, support, push, pull and hold any load then we need to be aware of the correct way to do it. We are only born with one back and we need to look after it. This course will inform you of the legislation surrounding any moving and handling operation, the correct techniques to employ, the process of ergonomics and risk assessing. You should always be safe when moving and handling any load so this course is essential for your health. Course Aims: Explain the theory behind moving and handling Be aware of safe practice using a range of techniques when moving a variety of inanimate loads Manual handling defines “any transporting or supporting of a load by hand or by bodily force This includes: Lifting, putting down, pushing, pulling, carrying or moving Use of mechanical aids, e.g. tr By the end of this module you will be able to: Explain the term manual handling and provide examples Know who to contact Techniques for lifting Techniques for pushing and pulling Carry out manual handling safely Legislation