458 Courses in Sheffield

QA Level 2 Award In Safeguarding And Protecting Children, Young People And Adults At Risk (RQF) Face-to-Face Classroom: Half-day course Virtual Classroom: 2 sessions of 2 ½ hours For those who work with children, young people and vulnerable adults Promotes awareness of safeguarding, enabling learners to identify problems and show where to report these to Course Contents: Understand safeguarding and protection responsibilities Legislation, statutory guidance and national policies relevant to safeguarding and protection Different types of abuse Signs and indicators of abuse and neglect Actions to take when a safeguarding concern arises Benefits of this course: In 2018/2019, 415,050 concerns of abuse were raised In 2018/2019, there were nearly 400,000 children in need 52,300 children were subject to a child protection plan 63% of adult safeguarding concerns are for people over 65 1 in every 42 adults aged 85+ have required safeguarding enquires... Child abuse often goes unreported and unrecorded - till it is picked up on by someone who then does something about it. This Level 3 Safeguarding course gives people the skills and knowledge to make a real difference to a person's life! Accredited, Ofqual regulated qualification: Our Level 2 in Safeguarding training course will be a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Level 2 in Safeguarding Certificate provides information for best practice to make a real difference to protect the health and wellbeing of our most vulnerable. The Ofqual Register number for the QA Level 2 Award in Safeguarding and Protecting Children, Young People and Adults at Risk (RQF) is 601/8801/7

Highfield Level 1 Award In Health And Safety Within A Construction Environment (RQF) Highfield Level 1 Award in Health and Safety within a Construction Environment (RQF) One day course For those applying for the Green Labourer CSCS Card Includes the Health, Safety, Environment Test For Operatives and Specialists book or DVD by CITB! Face to Face: One day course + time for self-study required This course is supported by the Construction Industry Training Board (CITB) This course is designed to give learners a route to applying for the Green Labourer CSCS Card Course Contents: The purpose of a risk assessment The purpose of a method statement The legal requirements of risk assessments and method statements The common causes of work-related fatalities and injuries The implications of not preventing accidents and ill-health at work Health and safety definitions Hazards and potential risks of a a range of situations The importance of reporting accidents and near misses Accident reporting procedures Risk assessments and dynamic risk assessments The reasons for using safe manual handling in the workplace The employees' responsibilities under current legislation and official guidance in relation to manual handling in the workplace The procedures for safe manual handling Working at height Employees' legal responsibilities in relation to working at height Potential hazards when working at height Controlling risks and hazards while working at height Regulations regarding working at height COSHH: substances hazardous to health Common risks to health within a construction environment Drugs and alcohol Personal Hygiene Asbestos PPE (Personal Protective Equipment) Working around plant and equipment safely Benefits of this course: In 2018/19, 1.4 million people suffered from a work-related illness They have a much higher rate of work-related ill-health than those working in many other industries Construction workers have the highest rate of musculoskeletal disorders compared to other occupations This course develops learners’ knowledge and understanding of health and safety in a construction environment so they can work safely on a construction site Those who successfully complete this Level 1 Award in Health and Safety in a Construction Environment and have completed the CITB Health, Safety & Environment Test within the last 2 years can then apply for a Green Labourer CSCS card. Our Health And Safety In A Construction Environment Training Course is a nationally recognised, Ofqual regulated qualification accredited by Highfields Qualifications.This course leads to the obtainment of the CSCS labour card, allowing workers to work on construction sites.The Ofqual Register number for this course is 603/2442/9

QA Level 2 Award In Principles Of Manual Handling (RQF) Half day course (face to face), 2 sessions (virtual) Gives learners a good understanding of why manual handling is so important Gives learners the knowledge of safe manual handling principles Our full day course, Safe Moving and Handling, will also give learners sound practice in manual handling Course Contents: Common manual handling injuries Manual handling laws Responsibilities of employers and employees Manual handling risk assessments Safe movement principles associated with manual handling, including the body’s: Recognising a range of mental health conditions:Musculoskeletal systemCentre of gravityLever system Manual handling equipment:Types of manual handling aids and equipmentMaintenance and requirements for testing Theory of safe manual handling principles, including: Preparing for a lift Solo lifting, carrying and lowering an object Team manual handling Benefits of this course: 498,000 people people suffered from musculoskeletal disorders due to work related activities in 2018/2019 Of those, 138,000 were from people who had not suffered this before 6.9 million working days, or 26,436 working years, were lost due to work-related musculoskeletal disorders that year On average, each of those people had to take 16 days off work, with many never fully recovering from those injuries This course is there to help people avoid getting injured in the first place, saving both human suffering and cost to the employer and employee both Accredited, Ofqual regulated qualification Our Principles of Manual Handling Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Principles of Manual Handling Course fulfills the legal requirements and is a very good way to make sure you and your employees are trained in the principles of Manual Handling. The Ofqual Register number for this course is 603/2720/0

QA Level 1 Award In Fire Safety Awareness (RQF) Face to Face: Half-day course Virtual Classroom: Spread over 2 sessions of 2½ hr duration This course is an ideal way to ensure that all employees have a good understanding of fire safety Candidates will learn basic fire safety principles in order to ensure they are keeping themselves and others in the workplace safe at all times Benefits of this course: Candidates will learn basic fire safety principles in order to ensure they are keeping themselves and others in the workplace safe at all times Candidates will also learn what to do in the event of an emergency and the simple measures that can be taken to control the risk of fires With subjects covered in just half a day, this course is an ideal way to ensure that all employees have a good understanding of fire safety, whilst minimising disruption to your organisation’s day to day activity This course is also good for those who just want to know a bit more about keeping themselves and loved ones safe from possible fires Course Contents: Causes of Fire in the Workplace The Costs of Fires in the Workplace for Employers, Employees and Society Basic Fire Safety Duties and Responsibilities Actions to be taken in the event of a Fire Principles of Fire Risk Control Safe Use of Portable Fire Fighting Equipment Fire Safety Equipment Checks Accredited, Ofqual regulated qualification: TOur Fire Safety Awareness course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Fire Safety Awareness Training is of high quality and is a very good way to make sure your employees have an Awareness in Fire Safety. The Ofqual Register number for this course is 603/2627/X

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

A private beginner embroidery workshop from Hoop & Fred tailored just for you!

CPD Accredited, Interactive Workshop 2 - 4 hr sessions Learn how stress affects our mind and body Learn how to manage your stress and reduce them to an acceptable level Course Contents of 2 hour course: What is Stress Stress versus Pressure Statistics Absenteeism, Presenteeism and Leaveism Workplace Causes of Stress Personal Causes of Stress Short-Term and Long-Term Effects of Stress Coping Strategies Mental Resilience Benefits of this Workshop: In 2022/23. 875,000 people suffered from work-related stress, depression or anxiety The affects of stress are far reaching, affecting one's mind, body, social and personal life Become more aware of what stresses you, what is does to you and find ways to reduce those stress levels

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

EXPERT – MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! DERMAGRAFT AND ENRICHED NANO-MICROFAT TRANSFER FOR FACE, NECK & HANDS – VOLUMIZATION & REJUVINATION WHAT IS MICROFAT AND NANOFAT GRAFTING FOR FACE AND NECK LIFT? Microfat and enriched nanofat graft transfer (also known as autologous fat transfer or lipoinjection), to the face and the neck is a minimally invasive, short-lasting procedure with rapid recovery, and can be done under local anaesthesia. Following completion of the procedure, the patient can return to the normal daily life activities. But firstly, we need to clearly explain what the terms microfat and nanofat grafts mean…. Microfat is defined a small-diameter fat particle and is used to improve the appearance of wrinkles, grooves and the lack of volume and sagginess of the skin of the face and neck, in response to the aging process. Similarly, nanofat, is referred to as the smallest diameter fat particle. The main advantage of the nanofat is that it contains cells that have the ability to differentiate in any type of body cell. Stem cells – as they are called- play a very important role in the process of rejuvenation, as they can differentiate into cells called fibroblasts which in turn produce collagen thus making the skin firmer and more youthful in appearance. The Course can be divided into two stages: 1. In the first stage, fat cells will be obtained from one or more parts of the body and are then purified and injected into the face and the neck. The doctor will identify an area in your body where the fat will be obtained from. This area is usually the flanks, but fat can also be obtained from other areas such as the abdomen, and the outer and inner thighs. You will be given enough local anaesthesia to numb the area where the fat will be harvested from. Then, a small-diameter cannula called microcannula connected to a special vacuum syringe will be gently introduced under the skin to obtain the fat. During this process, you should not feel any pain, the local anaesthetic will have made you numb. After the fat is harvested, it will contain a mixture of fat cells, blood, water, and local anaesthetic. Therefore, this fat will not be pure. This mixture of fat, blood, water and local anaesthetic will then become filtered into a special filtering and processing device whereby all the blood, water and local anaesthetic are being washed out, so that pure fat remains. This fat is then further processed by passing it through special filters whereby it becomes a smaller-sized fat particle known as microfat and nanofat graft. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (theory), IN-CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course

About this Training Course The drill string is the simplest piece of equipment in use on a drilling rig and at the same time, the most critical piece. We use the qualifier 'basic' because although 99% of the drill string comprises plain tubes that are just screwed together, the lowest section, just above the bit, can go to extreme loading and is fitted with highly sophisticated electronics packages providing both positional and lithological data as well as a steering system to drive and orient the bit. The principle tasks of the drill string are also deceptively simple. These are to: Convey each drill bit to the bottom of the hole and then to retrieve it when worn, Act as a conduit to convey drilling fluid at high pressure down to the bit and Transmit torque from surface to bit, occasionally in concert with a hydraulic motor to drive this bit. This 3 full-day course will cover in detail what it takes to decide on minimum drill string specifications, which are able to support the loads to which it will be subjected. In addition to the need to use a drill string with minimum strength requirements, we also need to ensure that we can prevent drill string failure. If the failure consists of a small split or leak of any kind, then the time involved may be little more than that required for a roundtrip to change the bit. If the string parts, then the recovery is likely to take a considerable amount of time. In a worst case scenario, the fish in the hole may prove impossible to retrieve, requiring a sidetrack. A less than optimal design of the string will reduce the efficiency of the operation and almost always leads to premature bit wear. This is particularly true when we are unable to measure and control the dynamics of the drill string as a whole and the bottomhole assembly in particular. Axial vibrations, torsional vibrations and lateral vibrations may take place in various degrees of severity. The behaviour of the drill string while operating under torsional vibrations is thought to be of great importance and may result in torsional buckling. This course will also cover the drilling optimization limiters, how to identify them and how to remove them. This is done by understanding the drill string dynamics - by operating under the most favourable conditions and by measuring the dynamics in the vicinity of the bit (or at the bit) in order to make timely adjustments. Training Objectives The course homes in what office staff needs to know and plan for and what field staff needs to know and implement. By the end of this course, participants will be familiar with: Critical dimensions of common drill pipe and weld-on tool joints and its relation to yield for calculation of tensile, torsional and burst resistance. Make-up torque of connections that relate to the tool joint dimensions and the torsional strength of that connection. Use of design factors and safety factors on tensile and torsional strength in relation to new and worn state. Conditions which could lead to drill pipe collapse. Situations where limitations on sinusoidal (snake) and helical buckling will apply and the influence of radial clearance and deviation. Failure of drill pipe (fatigue) and the circumstances under which these would occur (rotation across doglegs, pipe in compression etc). Mechanism under which hardbanding would induce casing wear and the methods applied to measure and prevent any significant wear. Drill pipe inspection methods we apply to identify early flaws/cracks/corrosion, to measure dimensions, to inspect tool joints etc. Common BHA components, including heavy wall drill pipe, their external/internal dimensions, connections (API, proprietary) and appearance (such as spiral). Significance of thread compounds to ensure the correct make-up torque is applied. Significance of drill string/BHA 'neutral point' in the context of drill string component failure. Basic design principles for a BHA make-up in a vertical, low/medium deviated and highly deviated well in terms of weight transfer and drag/torque. Stabilization principles for a pendulum (vertical), a stabilized (vertical or tangent), a build and a drop-off assembly. BHA design and stabilization in relation to mitigation/elimination of vibration and to the elimination of tension, torsion or fatigue failure. Matching bit aggressiveness, gauge length, BHA stabilization, steerability and Mechanical Specific Energy (MSE) to mitigate the severity of any vibration. Bit efficiency and reduction of wear by understanding mechanical and hydraulic limiters. How to perform a passive or active drill-off test. Importance of being conversant with API 7G RP and/or equivalent data books, to look up/check the recommended tensile/torque and other parameters for the drill string in use. Target Audience This course is intended for staff directly or indirectly involved in the delivery of challenging wells such as junior to senior well engineers, both in office-based planning and operations and field-based operator/contractor supervisory staff such as company men and toolpushers. Trainer Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations