1222 Courses in London

LED Light Therapy is a non-invasive treatment which can address skin problems such as: sun damage, acne, fine line and wrinkles. LED Facials are extremely popular and effective treatments which can treat a variety of skin concerns. They can easily be added onto any facial for extra income with minimal extra time and preparation required. The LED light absorbed by the skin energises cells to give beneficial improvement by: Produce & stimulate collagen, elastin and brighten the skin rejuvenation Improve Skin Elasticity, texture and tone Increase Blood Circulation Increase Oxygen Levels Increase collagen synthesis Help reduce fine lines and wrinkles Improve blood circulation Increase hydration naturally Calming redness & healing the skin after other aesthetic treatments Reduce breakouts and problem skin & prevent future breakouts killing bacteria Regulate the sebum production in the skin Target multiple skin conditions such as acne, pigmentation, rosacea, scaring Helps improve the sun damage/photo-ageing of the skin Course prerequisites We accept students aged 18 and over. Students must have good written and spoken English. No qualifications or certifications are required for this course. Students must have good written and spoken English. Course agenda This intensive course includes 4 hours of theory study via our e-learning portal and 5 practical hours delivering treatments to model clients. All courses are kept intimate with a maximum of 6 learners to a class. Areas covered in this course: Industry regulation Insurance Client care/consultation Contra-indications and precautions Application of brow lamination products Aftercare Maintenance Further treatment advice Promotion of this exciting treatment Practical demonstration Practice sessions Practical on-going assessments Health and Safety Be ready to treat your clients by upgrading your training with an exclusively discounted starter kit including LED Light Therapy machine with a 50% saving at 150.

Course summary This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course.

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

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 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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

AgileBA® Foundation and Practitioner The AgileBA® Foundation and Practitioner course takes you through a business understanding of the external and internal forces that underline the project from a business perspective, looks at modeling techniques, (As Is - To Be), and also provides an overview to project management (AgilePM) from an 'Agile' perspective. The course explains the role's relevance and involvement throughout the project. What You Will Learn At the end of this program, you will be able to: Understand business analysis in a project environment and the techniques used, as well as knowing more about the role of the business analyst in a project Business Analysis - Business Environment and Organizational Strategy Overview of AgilePM The Business Case Stakeholder Engagement/Analysis Techniques: Requirements and Estimating Prioritization Timeboxing Iterative Development Planning Facilitated Workshops Modeling - 'As Is - To Be' Making the transition to AgileBA

AgileBA® Foundation and Practitioner: In-House Trainingr: In-House Training The AgileBA® Foundation and Practitioner course takes you through a business understanding of the external and internal forces that underline the project from a business perspective, looks at modeling techniques, (As Is - To Be), and also provides an overview to project management (AgilePM) from an 'Agile' perspective. The course explains the role's relevance and involvement throughout the project. What You Will Learn At the end of this program, you will be able to: Understand business analysis in a project environment and the techniques used, as well as knowing more about the role of the business analyst in a project Business Analysis - Business Environment and Organizational Strategy Overview of AgilePM The Business Case Stakeholder Engagement/Analysis Techniques: Requirements and Estimating Prioritization Timeboxing Iterative Development Planning Facilitated Workshops Modeling - 'As Is - To Be' Making the transition to AgileBA

Automatic driving lessons with friendly, patient, experienced and fully qualified male and female driving instructors. Our current Automatic teaching vehicle is a Nissan Micra, which our students have again found has a simple logical layout and is easy to control with good all round visibility when driving, that is why we feel it is ideal as a learning car.

Whether you’re starting out in private practice, or have been in business for a while, this inspiring course will SAVE you time and money and help you build the practice and lifestyle you want … Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Extremely helpful course. The real life, practical examples and advice were invaluable...EMMA WARDROPPER Live Online Training – Join Jennifer Broadley for this inspiring, practical training – you will have plenty of opportunity to ask questions. Simply book your place and we will email you details of how to join the Zoom training the day before the event. BONUS RECORDING – the training is recorded in case anyone experiences technical difficulties on the day, so you also get a recording for a limited time afterwards to maximise your learning. Why take this course Although word of mouth is one of the best ways to get business, being a good counsellor or therapist isn’t always enough to fill your practice with clients – and that’s where the easy-to-learn, simple but effective business and marketing skills you will learn on this online course come in. Jennifer Broadley has been a qualified and practising psychotherapist for 10 years and has been in business for herself for well over 20 years. She brings her extensive knowledge of the personal and professional ups and downs to life in this practical and motivating day. You will also gain a wealth of time-saving devices and tips that others who have successfully built their thriving practices have used, all of which will allow you to focus more time on your clients. Jennifer built her business, Healthy Chat, from no clients to full practice within 2 years. She has tried-and-tested marketing strategies and will share with you the ones that have worked for her and the ones that haven’t. She is fully transparent with her client numbers, systems and finances so that you will leave the course clear about whether a full-time or part-time therapy practice is for you – and how to go about getting the work/life balance you want. I’ve learned so much! A must for everyone setting up a therapy businessHEALTH VISITOR What will you learn The essential actions to take when starting your practice from scratch – what’s worth spending money on and what’s not Confidence to take on your first client(s) or increase your client intake until you have a full practice Clear systems for starting or growing your counselling / therapy practice Tools to ensure clients easily find you, trust that you can help, and then book sessions with you Clarity about how long to work with a client – average timings and outliers (for stress, trauma, panic attacks, relationships, etc); when to keep a client and when to let a client go Key information that will help you decide how much to charge and when/whether to be flexible Important things to remember if you work with clients online Time-saving methods for client management: intake, treatment, ending well and future follow up How to manage yourself as a business owner – when to work hard, when to take time out How to make your therapy practice fit in with the lifestyle you want to live – and what to do to avoid becoming overwhelmed When (or whether) to let go of your full or part-time work and shift to letting your counselling practice support you financially How to get your 9 emotional needs met while working for yourself How to define your ideal client(s) and where to find them Practicalities: taking payments, tracking your numbers, meeting your targets, turnover v’s net income, paying VAT (or not), paying tax, chasing non-payments Creating a healthy, open attitude and language around money and finances How to set up your therapy practice to be financially successful and more… Brilliant, this online course has shown me what I need to focus on to build a successful private practice – and where to put my energy, money and time!COUNSELLOR Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am A context for the demand for HG therapy and counselling 11.00am Comfort break and discussion 11.30am Private Practice Design 1.00pm Lunch break 1.45pm Marketing your practice 2.45pm Comfort break and discussion 3.00pm Effective Therapy Sessions & Client Follow up 4.00pm Day ends Who is this course suitable for? Anyone who wants to set up a private therapy or counselling practice If you’re already in private practice and want to increase your client numbers, work less and earn more, you’ll also benefit from attending Anyone who is presently in full or part time salaried work and is considering moving to self employment or entrepreneurialism This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Talk through problems Check up call Help with single parenting dating issue Dating advice Your own coach for 3 weeks Mini sessions Depression and stress relief strategies 30 mins x 2 per week for 3 weeks Support and anxiety issues addressed Time convenience coaching Phone sessions Dating advice for singles https://relationshipsmdd.com/product/single-parent-coaching-package/

About this training course Gas well performance is dictated by the combination of inflow and outflow performance. The outflow performance of any gas well is at risk as soon as the gas rate becomes insufficient to lift the associated liquid water and condensate to surface. This condition is referred to as liquid loading and invariably causes intermittent production and significant loss of well capacity and reserves. Liquid loading can be mitigated by different types of gas well deliquification such as compression, velocity string, plunger lift, foam-assisted lift, gas lift and downhole pump. This 5 full-day course will first show how to predict and recognize liquid loading. Next, it will describe how to select, design, install and operate the best sequence of deliquification measures. It will also consider deliquification in the presence of other production threats such as water production and halite blockage. These topics will be illustrated by an abundance of field examples and case studies. The participants will be completing a case study during the training. This case study is preferably based on their own relevant data set. If no such data is available, an external data set will be provided instead. Prerequisites skills: It is necessary for the participants to have a basic knowledge of petroleum engineering and gas well performance. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives On completion of this course, the participants will be able to: Develop skills and tools to understand and model gas well liquid loading and deliquification Understand the principles and practicalities of different deliquification methods Learn how to compare, select and apply deliquification measures by taking own field case as example Target Audience This course is intended for production engineer, surveillance engineer, completion engineer, production/process chemist, reservoir engineer, production programmer, production operator as well as professionals responsible for selecting, installing, operating, monitoring and optimizing deliquification. Course Level Basic or Foundation Training Methods This course utilizes Excel worksheets first introduced in the Optimising Gas Well Performance course. To derive maximum learning value, the participants are requested to bring their own relevant set of field data to complete their own case study during the training. The list of data required will be shared beforehand so data can be timely collected and cleared for external use. The participants should be prepared to complete any unfinished exercises and assignments before next day's session starts. The instructor will be available to discuss any remaining queries after the completion of the course. Trainer Your expert course leader brings with him 35 years of oil and gas field experience within Shell of which 25 years as gas well production engineer. He has covered the full spectrum of activities moving from R&D to green field development to brown field surveillance and optimisation, to become a leading gas well performance and deliquification specialist. He likes to capture the complex reality of gas well inflow, outflow and reservoir performance by means of practical data-driven rules and tools that cover a wide range of conditions i.e. shallow-to-deep, prolific-to-tight, dry-to-wet, green-to-brown, 1-1/2'-to-9-5/8' tubing, and depletion-to-aquifer drive. Before his retirement in end 2020, he worked for various Shell affiliated oil and gas companies including Shell Malaysia, Petroleum Development Oman, NAM Netherlands and Shell R&D in Netherlands and USA. 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