122 Educators providing Courses in London

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Hypnotherapy Training Course

Full stack, in depth , comprehensive in classroom 3 month training on Java programming. 1 lesson a week, the other days you work on your own on structured homework and supported with a 1-1 mentor.

Spiritual Awakening Level 1 allow your TRUE soul essence to light the way. Become aligned with Reiki Source Energy, vitality, and a happier and harmonic way of being.

Usually once a month, the 2024 dates are:- 2024 Saturday Classes: May 11th June 8th July 6th & 27th Sept. 7th Oct. 12th Nov. 9th Dec. 7th * Notes on 2-Person Classes Both the Tuesday 8.05pm class in Euston, and the Saturday courses in Westminster will focus on:  Learning how to relax  The use of the movements in Tai Chi Form (applications)  Applying the movements so that you maintain your own integrity (centre of balance)  Finding & working from the centre/core/Dantian  Developing the sense of ‘feel’ when working with someone else  Connecting your centre to your hands  Turning a partner’s energy around so as to unbalance him/her  We will also work on a 2-Person Tai Chi Form in order to understand applications of moves Posture, Balance, and Intention. By far the most important part of these classes is developing the ability to sense and be aware not only of one's own posture, balance, and intention, but also that of another person. Relaxation. Many of the exercises are ultimately about the ability to act from a very relaxed body and mind, so that (for example) if someone pushes towards you, you don't 'lock up' (the instinctive reaction), but instead you sense the push, and divert it. Initially it is this 'locking up' (which in effect makes you unable to move), that we are working on undoing. This is about getting more control of your sympathetic nervous system (fight & flight), the 'stress' system, so that in difficult situations, you 'roll with the punches' better.

Java Evenings Course. Basic Java syntax and principles of object-oriented programming. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm to 8pm.

This half day course is designed for voluntary and community organisations and those involved in community development who need to write funding applications and want to ensure that their bids are clear, focussed and meet the funders’ criteria.

This is a 13-week term. * Notes on 2-Person Classes Both the Tuesday 8.05pm class in Euston, and the Saturday courses in Westminster will focus on:  Learning how to relax  The use of the movements in Tai Chi Form (applications)  Applying the movements so that you maintain your own integrity (centre of balance)  Finding & working from the centre/core/Dantian  Developing the sense of ‘feel’ when working with someone else  Connecting your centre to your hands  Turning a partner’s energy around so as to unbalance him/her  We will also work on a 2-Person Tai Chi Form in order to understand applications of moves Posture, Balance, and Intention. By far the most important part of these classes is developing the ability to sense and be aware not only of one's own posture, balance, and intention, but also that of another person. Relaxation. Many of the exercises are ultimately about the ability to act from a very relaxed body and mind, so that (for example) if someone pushes towards you, you don't 'lock up' (the instinctive reaction), but instead you sense the push, and divert it. Initially it is this 'locking up' (which in effect makes you unable to move), that we are working on undoing. This is about getting more control of your sympathetic nervous system (fight & flight), the 'stress' system, so that in difficult situations, you 'roll with the punches' better.

Enhance your expertise in compressor and pump selection, operation, troubleshooting, and maintenance with EnergyEdge's comprehensive classroom training. Elevate your skills today!

About this Training Course On a day-to-day basis, one of the most common technologies utilised in well intervention is Coiled Tubing. This is prevalent in the oil industry and the technology is used during drilling, completion and production phases of Oil & Gas wells worldwide. This 5 full-day course will look at the following areas: Equipment for surface and pressure control Assembly components for bottom-hole Details of the different types of interventions performed with Coiled Tubing, and How to deal with fatigue and corrosion. The aim of this course is to enable the participants to gain key knowledge that they will require to actively and efficiently participate in the planning, design, and / or execution of a Coiled Tubing intervention. With this, the participants will learn how to calculate the string operating limits and the volumes and rates during nitrogen interventions. The course will walk the participants through the emergency responses and contingencies to deal with in various scenarios. Time will be allocated for the participants to work on the practical exercises as well as real field cases and problems. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, the participants will be able to: Plan, design, manage and execute interventions for Coiled Tubing Enhance operational performance during interventions for Coiled Tubing Explain the recommended equipment for various Coiled Tubing field conditions and applications Discuss the proper pressure control equipment for any particular well condition Learn about the most commonly used downhole tools and explain their function Understand how to calculate and define string limits for Coiled Tubing Learn how to work safely with liquid nitrogen Target Audience This course is aimed at Drilling and completion engineers Production engineers Surface/subsurface engineers Operations engineers Service company managers Field engineers This course will also benefit professionals who would like to increase their knowledge in the planning, design and/or execution of Coiled Tubing and Liquid Nitrogen interventions. Course Level Basic or Foundation Training Methods Other than the daily quizzes to reinforce the materials presented in the session, the participants will work through exercises such as: Selecting suitable BHAs for various operations Rigging up equipment in the correct order and preparing an outline testing programme Carrying out suitable calculations to perform an N2 lift Preparing an outline programme for a balanced cement plug Identifying issues in various videos & photos and suggesting mitigations Basic N2 safety quiz Final exercise will be preparing an outline programme for a Proppant Clean out, including a detailed Risk Register and Mitigation options Trainer Your expert course instructor has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. 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