219 ETC courses in London

NPORS Shunter Vehicle (N243)

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

About this Training Course There are various kinds of geophysical data available. They are separated into seismic and non-seismic (multi-physics) data. Non-seismic or multi-physics data (which includes gravity, magnetics, electrical, electromagnetics, spectral etc - apart from providing complimentary information to seismic) is the main source of information for very shallow subsurface applications such as engineering, mapping pollution, archaeology, geothermal energy, and related areas. This 5 full-day blended course will focus specifically on seismic data which is the main method used in the Oil & Gas industry. In this blended course, participants will be equipped to understand that seismic data represents the movement of the surface, resulting from waves generated by a source, dynamite or vibrator which are reflected by changes in the subsurface rocks. The basic principles of acquisition and processing will be explained and insights into advanced methods, allowing a much more accurate interpretation of seismic data than previously considered possible, will also be provided. This blended course contains an introduction to Machine Learning and its important role in all aspects of seismic acquisition, processing, and interpretation. There is no need to know in detail how the algorithms work internally but it is necessary to know how to use them correctly to achieve optimum results. Training Objectives By attending this course, participants will be able to acquire the following: Obtain an understanding of the strengths and limitations of geophysical methods, specifically seismic, and the costs and risks involved, and how to reduce these. Be able to communicate more effectively with staff in other disciplines. Understand the potential applications of seismic data and know how to formulate the requirements needed for prospect and field evaluation. Gain an awareness of modern seismic technology. Apply the learning in a series of practical, illustrative exercises. Know what types of questions to ask to assess the necessary quality of a seismic project in its role in a sequence of E&P activities Target Audience The blended course is intended for non-geophysicists who have intensive interaction with geophysicists. But it may be of interest to those who want to know about the recent progress made in geophysics, leading to amazing imaging results, which could not be imagined a decade ago. The blended course will bring to the attention of the geologists, petrophysicists and reservoir/petroleum engineers an awareness of how the data they will work with is acquired and processed by the geophysicist. It will introduce the concepts that are of importance in geophysics and thus relevant for non-geophysicists to know and be able to communicate with geophysicists as well as formulate their requests. Course Level Intermediate Trainer Your expert course leader has degree in Geology (University of Leiden), a Master's degree in Theoretical Geophysics (University of Utrecht) and a PhD in Utrecht on 'Full wave theory and the structure of the lower mantle'. This involved forward modelling of P- and S-waves diffracted around the core-mantle boundary and comparison of the frequency-dependent attenuation of the signal with those obtained from major earthquakes observed at long offsets in the 'shadow zone' of the core. These observations were then translated into rock properties of the D' transition zone. After his PhD, he joined Shell Research in The Netherlands to develop methods to predict lithology and pore-fluid based on seismic, petrophysical and geological data. He subsequently worked for Shell in London to interpret seismic data from the Central North Sea Graben. As part of the Quantitative Interpretation assignment, he was also actively involved in managing, processing and interpreting Offshore Seismic Profiling experiments. After his return to The Netherlands, he headed a team for the development of 3D interpretation methods using multi-attribute statistical and pattern recognition analysis on workstations. After a period of Quality Assurance of 'Contractor' software for seismic processing, he became responsible for Geophysics in the Shell Learning Centre. During that period, he was also a part-time professor in Applied Geophysics at the University of Utrecht. From 2001 to 2005, he worked on the development of Potential Field Methods (Gravity, Magnetics) for detecting oil and gas. Finally, he became a champion on the use of EM methods and became involved in designing acquisition, processing and interpretation methods for Marine Controlled Source EM (CSEM) methods. After his retirement from Shell, he founded his own company, specialising in courses on acquisition, processing and interpretation of geophysical data (seismic, gravity, magnetic and electromagnetic data), providing courses to International and National energy companies. In the last couple of years, he became keenly interested in the use of Machine Learning in Geophysics. Apart from incorporating 'Artificial Intelligence' in his courses, he also developed a dedicated Machine Learning course for geophysics. 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)  The Subsea Production Engineering Virtual instructor Led Training (VILT) course provides an overview of all of the functionalities and key interfaces of subsea equipment. The VILT course will refer to relevant industry engineering standards for subsea equipment, subsea tie-backs and critical operational requirements. The sessions will cover challenges associated with equipment design and installability, as well as a new module on subsea tie-backs. The primary learning objectives for this VILT course are met through a combination of interactive presentations, discussion and exercises. Training Objectives By the end of this VILT course, participants will be able to: Apply the requirements of related industry standards (API 6A/ 17D, API 17A etc.) engineering standards Understand the barrier and qualification requirements Identify the barriers in place given a specific mode of operation Evaluate and select which tree alternatives are valid based on the key design drivers Identify and describe the key design drivers Explain the importance of well kill rate Describe which tree alternatives are valid for certain scenarios based on an evaluation of the key tree design requirements Examine what effects subsurface requirements may have on tree design Understand the challenges associated with designing equipment for manufacturability and installability Recognise the implications of design changes to specific components and the effects on transportation and installation (such as what type of vessels, lifting equipment, and tools to use and the logistical requirements) Recognise the implication of design changes on manufacturability of subsea equipment Target Audience This VILT course provides a comprehensive understanding of the equipment used in subsea production systems. It is designed for petroleum engineers, production engineers, subsea project engineers and is also highly suitable for cost, planning, offshore installation and offshore operations engineers. Anyone directly or indirectly involved with subsea equipment will benefit from attending this VILT course - from engineers installing the equipment to procurement staff looking to understand more. Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. 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

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

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! This course theory will help you to understand: We will cover all you need to know in order for you to treat your patients confidently and safely. The Theory will cover; Anatomy and physiology Ageing Characteristic of the ideal skin booster Product Introduction Treatment Method Contraindication Complication management Pre & Post-treatment advices Using Products like Toskani, Skinecos, Jalupro etc. Using Products , PROFHILO, recommended for midd and low part of the face as well as other delicate areas of skin such as the neck, décolletage, hands or knees. Practice will enable you to learn in 1-day ONE-TO-ONE Training We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. A certification of hands-on training will be provided upon completion of the course. You will perform this procedure on live models injecting superficially and administrating the product (skinbooster) into the subcutaneous layer. This will happen under the supervision and guidance of highly experienced aesthetic practitioners. You will practice injectables with needle on; Face, Neck, Decolatege & Hands 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

Overcome social awkwardness and social anxiety the fast, fun and easier way. DO YOU find yourself drying up or going blank when under pressure, or get tongue-tied when someone makes a smart remark? One of the reasons that you dry up or get tongue-tied – is because you are programmed to go into your head and try to think of something to say. Most of us have become left-brain dominant because of the way we’ve been educated and we don’t know how to activate our powerful and more creative right-brain. This is why the "I Don't Know what to Say" Improvisation Course is so effective at overcoming social difficulties. It gives you access to your spontaneous right-brain, and in fact, enables you to operate from both right and left-brain together. It is probably one of the fastest and most effective ways of building verbal confidence as well as liberating you on all sorts of levels.

Sewing machine class for absolute beginners. The class will cover setting up a machine, learning about thread, bobbins, needles, feet, fabric, basic maintenance, tools, making seams and hems, understanding seam allowances, and you will create a cushion cover to take home with you.

1-2-1 bespoke training course