479 Courses in Sheffield

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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

The Portable Appliance Testing course or PAT testing course as it is more commonly known is one of our most popular courses as it does not require you to have any formal previous qualifications and once completed, will enable you to offer your services. In the commercial setting, the law places a responsibility on all employers to ensure that the electrical equipment to be used by their staff and the public, should be fit for purpose and safe for use. Hence, all portable appliances have to be regularly checked and maintained by a competent person.

Confined Space Risk Management and Permits - This course includes a basic level of confined space knowledge with the opportunity to use confined space equipment in a simulated environment and a team exercise of creating and reviewing a safe system of work. Note: A pre-requisite qualification is required to complete this course. Day 1 is a CS1 course and the Confined Space Risk Management (CSRM) can be completed as a 1 Day add-on. Any of following courses can be completed as a pre-requisite within 12 weeks of the CSRM; CS1, CS2, 6160-09. Book via our website @ https://www.vp-ess.com/training/confined-spaces/confined-space-risk-management-and-permits/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

Gain expertise in IFRS accounting for the oil and gas sector with our industry-focused training course. Enroll today with EnergyEdge.

ADVANCED 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! Lipolysis (Fat Disolving) achieves good results in the following body zones: – Chin (double chin) – Hips (love handles) – Stomach (abdominal area) – Thighs (saddlebags) – Upper arms (arm toning) – Pseudo gynecomastia (male breasts) – Back (bra fat or muffin top) The acids present in Aqualyx cause fat destruction in the body. Aqualyx main active ingredient is deoxycholic acid. Deoxycholic acid is a bile acid, synthesized in the human liver. The fatty acids are then released into the body, to be broken down by our usual metabolic processes in the liver. Naturally occurring bile acid is used by the body to emulsify fat. Aqualyx comes in a water based injection that dissolves fat cells that it comes into contact with. A single vial will be sufficient. Small are for larger areas, such as the abdomen or the inner thigh, anywhere between 5 to 10 vials One treatment of AQUALYX® usually includes only 1 or 2 injection sites, as well as a local anaesthetic solution of lidocaine which is used to irradicate any pain and make the procedure as comfortable as possible. Course Content Disinfection, Health & Safety. Consultation and timings including data protection, medical history and client consent Skin Types Skin analysis Pre and post treatment procedures Injection protocol and techniques Safe handling needles, before, during and after treatment Product knowledge Setting up Treatment procedure Results clients can expects and managing expectations Contractions and aftercare advice Treatment planning and pricing Post care instruction Fat dissolving products (Lemon Bottle), very safe. Lemon Bottle is a high-concentration fat dissolve solution that combines Riboflavin (vitamin B2) and other premium ingredients that create fat decomposition by accelerating metabolism of fat cells. Become a certified Lemon Bottle fat-dissolving treatments expert with our comprehensive and accredited courses designed specifically for UK practitioners. We have the perfect course to suit your needs, focusing on the Lemon Bottle system. Minimal swelling, minimal pain. Begins working immediately.   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 INTERMEDIATE | Advanced Course

About this Training Course In turbulent times for the entire Energy Sector, Oil & Gas E & P segments are coming under tremendous pressure to reinvigorate. Oil Majors like Shell Plc are no longer termed as Oil & Gas Company but also branded as SHELL Energy, with technology at its forefront. The Risks, Scope and Context of Engineering, Procurement, Construction, Installation and Commissioning (EPCIC) Projects is evolving rapidly. Thus, the success of a project is dependent on the practical 'know how' in scoping, contract drafting, negotiation and execution competencies. Understanding the essential ingredients of contracts and mastering the international contracting principles will equip the participants to identify vague and ambiguous clauses, avoid dangerous and often hidden terms, and better understand the controlling position in a project. In this 3 full-day course, the participants will find out how to negotiate legacy contracts where parties are not allowed to edit any clauses during the bidding process. The participants will learn from the Case Law Reports and analysis to take home lessons learned from bitter experiences of their peers in the industry. It is designed to help those who need a solution to manage current contractual issues or those who execute contracts regularly and want to be more proficient in managing their contracts and projects, with changing contexts. The course is developed with the underlying objectives for the participants to: Enhance their current knowledge of the legal principles governing international Contracts from formation, execution to breaches, redresses and dispute resolution either as a party or as a consortium member or as a coverture. Manage Consortium and Joint Venture Partners inter-relationship and contractual responsibilities. Identify dangerous exposures due to joint and severally liable requirements of consortium-based contracts. Effectively Manage Risks of Projects, with Enforceable Contract Documents, by learning the purpose and potential benefits of maintaining evidence in compliance to the contract clauses. Learn the Contract Enforcement Nuggets of Owners and the Variation Claims Strategies of the Contractors. Allocation of contract management related roles / assignments and WBS within consortium partners for effective project management and profitable results. Use of Contract Terms & Conditions for enhancing project performance, monitoring, reporting, and achieving timely completion, thereby avoiding delays and disputes. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completion of the course, the participants will have learnt: Project management strictly in accordance with the contract and the corporate strategies. How to ensure that Variations Order claims are appropriately managed in turnkey and lump-sum contracts. Manage contemporary challenges and market factors with direct or indirect impact on the contracts. Managing all members of the Supply Chain from vendors to logistics services providers. Cost Engineering and Performance Management. How to manage Consortium Partners, Contractors, and Owner's representatives. When and how to obtain / grant extension of time (EOT) and costs. Ability to identify rights and obligations of each party to a contract instead of making subjective decisions. Ability to be firm in negotiations without violating terms of the agreements. Ability to spot different legal systems, contract laws and arbitration rules. Ability to negotiate and avoidance of disputes and resolution in amicable manner, in accordance with the provisions of the contract. Competency in developing and maintaining documentary evidence and traceability for all works executed during the project. Target Audience This course is specially curated for professionals from International Oil & Gas Industries including Offshore & Marine Sectors. They include the heads of strategic business units, contracts managers, project directors, project managers, general managers, corporate legal counsels, procurements and supply chain managers, lawyers and legal professionals engaged in the EPCIC Segments of the Oil & Gas Industry.   Course Level Intermediate Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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

Immerse Medical are experienced at teaching first aid to young people within the educational sector. We have designed this workshop style programme specifically for those in KS3/4. The sessions are fun, engaging and focus on fundamental life saving skills. Using interactive gamification, students gain hands on experience, which they will draw upon in real life medical emergencies. These sessions are perfect as part of phase 2 of National Citizenship Service (NCS) and Duke of Edinburgh (DofE) Awards. Key points Meets national curriculum secondary education guidelines– We’ve designed this programme to exceed the requirements of the 2020 guidelines. Training by doctors, nurses and paramedics – We have years of experience working on the front line of emergency medicine; giving us real world knowledge and skills in managing injured or unwell people. Latest equipment & technology – We utilise technology enhanced learning to provide a realistic opportunity to practice fundamental life saving skills in a safe environment. More than first aid – While participating in this workshop young people will also develop their ability to work as part of team, communicate effectively and think critically in high pressure situations leading to an overall increase in personal confidence. Check out the skills included in the videos below. First Aid Courses For Young People Programmes and sessions for young people focusing on how to keep each other safe and what to do if something goes wrong. Sessions are designed with age and national curriculum in mind, from 1 hour tasters to sessions for large groups, perfect as part of NCS and Duke of Edinburgh programmes. Our training for young people is fun, engaging and focuses on fundamental life saving skills.  All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

HACCP Level 3 Training Courses

About this training course Business Impact: The main aim is to provide insight and understanding of data analytics and machine learning principles through applications. Field data is used to explain data-analysis workflows. Using easy to follow solution scripts, the participants will assess and extract value from the data sets. Hands-on solution approach will give them confidence to try out applicable techniques on data from their field assets. Data analysis means cleaning, inspecting, transforming, and modeling data with the goal of discovering new, useful information and supporting decision-making. In this hands-on 2-day training course, the participants learn some data analysis and data science techniques and workflows applied to petroleum production (specifically artificial lift) while reviewing code and practicing. The focus is on developing data-driven models while keeping our feet closer to the underlying oil and gas production principles. Unique Features: Eight business use cases covering their business impact, code walkthroughs for most all and solution approach. Industry data sets for participants to practice on and take home. No software or complicated Python frameworks required. Training Objectives After the completion of this training course, participants will be able to: Understand digital oil field transformation and its impact on business Examine machine learning methods Review workflows and code implementations After completing the course, participants will have a set of tools and some pathways to model and analyze their data in the cloud, find trends, and develop data-driven models Target Audience This training course is suitable and will greatly benefit the following specific groups: Artificial lift, production and facilities engineers and students to enhance their knowledge base, increase technology awareness, and improve the facility with different data analysis techniques applied on large data sets Course Level Intermediate Advanced Training Methods The course discusses several business use-cases that are amenable to data-driven workflows. For each use case, the instructor will show the solution using a data analysis technique with Python code deployed in the Google cloud. Trainees will solve a problem and tweak their solution. Course Duration: 2 days in total (14 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Prerequisites: Understanding of petroleum production concepts Knowledge of Python is not a must but preferred to get the full benefit. The training will use the Google Collaboratory environment available in Google-Cloud for hands-on exercises Trainees will need to bring a computer with a Google Chrome browser and a Google email account (available for free) Trainer Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA. Highlighted Work Experience: At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe. Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements. Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics. Developed a workshop on digital oilfield approaches for production engineers. Patents: Principal inventor: 'Smarter Slug Flow Conditioning and Control' Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells' Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution' Worldwide Experience in Training / Seminar / Workshop Deliveries: Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&T, Louisiana State, U of Southern California, and U of Houston. He has conducted seminars, bespoke trainings / workshops globally for practicing professionals: Companies: Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others. Countries: USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela. Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic. 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

About this Virtual Instructor Led Training (VILT)  Electrification of the transportation sector will impact the power system in several ways. Besides the additional load, local impact on the grid needs to be managed by the grid operators. Simultaneously charging of many electric vehicles (EVs) might exceed the limits in specific locations. On the other hand, EVs can provide flexibility and other ancillary services that will help grid operators. This 3 half-day VILT course will provide a complete overview of integrating electric vehicles (EVs) into the power grid. It will cover the whole value chain from grid operations to the car battery. This includes the control room, possible grid reinforcement, demand side management and power electronics. This course will demonstrate the impact on the grid and solutions for a safe & cost-effective grid plan and operation, with examples of successful integration of EVs. The course will also provide vital knowledge about technology used for EVs such as power electronics, demand side management, communication and batteries. In this context, the focus will be on power electronics as it has the highest impact on the grid. The grid planning tool, pandapower, is introduced as an open source tool for power system modelling. The set-up of the training course allows for discussion and questions. Questions can be formulated by the participants upfront or during the training. This course is delivered in partnership with Fraunhofer IEE. Training Objectives At the end of this course, the participants will: Understand the charging options for EVs and its impact on the grid and batteries Identify system services for EVs with regards to voltage quality at the point of common coupling Discover what are the 'grid friendly' and grid supporting functions in EVs Uncover the different applications, standards and data researched on EVs Examine the application of a grid planning tool (pandapower) for power system modelling Be able to develop code snippets with pandapower Apply and execute a code example for power system modelling with pandapower Target Audience EV and grid project developers and administrators Power grid operators and planners EPC organisations involved in grid development EV/ battery manufacturers and designers EV transport planners and designers Government regulators and policy makers Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes breaks per day, including time for lectures, discussion, quizzes and short interactive exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end of every session/day. Trainer Our first course expert is Head of Department Converters and Electrical Drive Systems at Fraunhofer IEE and Professor for Electromobility and Electrical Infrastructure at Bonn-Rhein-Sieg University of Applied Sciences. He received his engineering degree in automation in 2008 by the THM Technische Hochschule Mittelhessen (FH Giessen-Friedberg). Afterwards he studied power engineering at University of Kassel and received his diploma certificate in 2010. In 2016 he received the Ph.D. (Dr.-Ing.) from the University of Hannover. The title of his dissertation is Optimized multifunctional bi-directional charger for electric vehicles. He has been a researcher at the Fraunhofer IEE in Kassel since 2010 and deals with power converters for electric vehicles, photovoltaics and wind energy. His current research interests include the bidirectional inductive power transfer, battery charger and inverter as well as new power electronic components such as SiC MOSFETs and chokes. Additionally, our key expert is Chairman of the IEEE Joint IAS/PELS/IES German Chapter and a member of the International Scientific Committee of the EPE Association. Our second course expert is deputy head of energy storage department at Fraunhofer IEE. Prior to this he was the Director of Grid Integration department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, our course expert was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a degree of electrical engineering of the University of Kassel, Germany. In 2003 he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the 'Institute of Solar Energy Supply Technology' (now Fraunhofer IEE) in Kassel. In 2004 he started his career at RWE TSO with main focus on wind power integration and congestion management. Our course expert is chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Our third course expert is Research Associate at Fraunhofer IEE. He is actively working on different projects related to the integration of electric vehicle charging into the electric distribution grid. The focus of this work concerns time series based simulations for grid planning and operation in order to investigate the effect of a future rollout of electric vehicles and charging infrastructure on economics e.g. costs for grid reinforcement. He completed his master degree (MSc.) in Business Administration and Engineering: Electrical Power Engineering at RWTH Aachen University, Germany. Our trainers are experts from Fraunhofer Institute for Energy Economics and Energy System Technology (Fraunhofer, IEE), Germany. The Fraunhofer IEE researches for the national and international transformation of energy supply systems 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 about post training coaching support and fees applicable for this. Accreditions And Affliations