263 Courses in London

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

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation 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. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Adobe Authorised Training Centre. Classroom based course with study materials and certificate of completion included. Apple Final Cut Pro X is a revolutionary video editing application that makes it possible for beginners and seasoned professionals to achieve stunning results. This one day workshop introduces students to the primary feature set and functionality of Final Cut Pro X. Students will learn to perform a range of editing functions while familiarising themselves with the user interface. Description Completing this course will enable you to do the following and more: Become familiar with the Final Cut Pro User interface Learn Workflow & Media Management Understand Events and Projects Organise your files and your system Use Keywords and Ratings Import, Edit, and Trim video Mark clips Use Trimming techniques Learn Ripple, Roll and Extended edits Use the Slip and Slide tools Perform Transitions and Effects Use and modify transitions Apply filters Use Colour Balancing to improve images Edit Audio and use filters Finishing and final output For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone who wishes to learn Final Cut Pro X from scratch or wants to improve their existing knowledge of the program. Requirements Attendees should have basic Mac skills. You will need a free Zoom account to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Gain the knowledge and skills to manage ear wax buildup with our "Management of Ear Wax Training" course. Ideal for healthcare professionals.

This Python Machine Learning online instructor led course is an excellent introduction to popular machine learning algorithms. Python Machine Learning 2-day Course Prerequisites: Basic knowledge of Python coding is a pre-requisite. Who Should Attend? This course is an overview of machine learning and machine learning algorithms in Python SciKitLearn. Practical: We cover the below listed algorithms, which is only a small collection of what is available. However, it will give you a good understanding, to plan your Machine Learning project We create, experiment and run machine learning sample code to implement a short selected but representative list of available the algorithms. Course Outline: Supervised Machine Learning: Classification Algorithms: Naive Bayes, Decision Tree, Logistic Regression, K-Nearest Neighbors, Support Vector Machine Regression Algorithms: Linear, Polynomial Unsupervised Machine Learning: Clustering Algorithms: K-means clustering, Hierarchical Clustering Dimension Reduction Algorithms: Principal Component Analysis Latent Dirichlet allocation (LDA) Association Machine Learning Algorithms: Apriori, Euclat Other machine learning Algorithms: Ensemble Methods ( Stacking, bagging, boosting ) Algorithms: Random Forest, Gradient Boosting Reinforcement learning Algorithms: Q-Learning Neural Networks and Deep Leaning Algorithms: Convolutional Network (CNN) Data Exploration and Preprocessing: The first part of a Machine Learning project understands the data and the problem at hand. Data cleaning, data transformation and data pre-processing are covered using Python functions to make data exploration and preprocessing relatively easy. What is included in this Python Machine Learning: Python Machine Learning Certificate on completion Python Machine Learning notes Practical Python Machine Learning exercises and code examples After the course, 1 free, online session for questions or revision Python Machine Learning. Max group size on this Python Machine Learning is 4. Refund Policy No Refunds

This is the follow on course for those who want complete knowledge of all Beauty Therapy. Students will need to have completed their NVQ Level 2 in order to progress to this level. This is the perfect course for being able to offer any treatment you require. You can choose from 25 evening or a 'Fast Track' of ONLY 10 Days plus coursework, case studies and homework. This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. Although our Tutors have been teaching NVQ levels at many Colleges for over 15 years now, we started the 'Academy' so that the teaching revolved around the student and not around making targets, politics and college protocols! Although we set dates, our students have an opportunity to pick and choose and to the best of our ability, we will structure special dates around them. This is what makes us completely unique and probably why we are the most features teaching school on a multitude of TV Channels!! There are many Colleges and Schools that can teach you but whatever you do, even if you do not choose us to learn with us, please make sure the school has 100% pass rate as some of the biggest private schools only have between 50-75% pass rates!! You will need to BOOK SOON TO AVOID DISAPPOINTMENT!! Here at 'The Angel Academy of Teaching and Training', we have 2 different routes of NVQ Level 3: Here are the two NVQ Level 3 options: NVQ Level 3 Massage Route: Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The Course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Indian Head Massage Indian Head Massage traditionally was an ancient healing process known to relieve headaches, stress and tension. Hair was strengthened and conditioned too with the use of certain oils. Today, the fashionable hair salons provide the use of Indian Head Massage as a means of relaxation, and it ' s popularity is increasing rapidly. On-Site practitioners now visit offices to provide treatments, bringing Indian Head Massage into our working day. In fact, Indian Head Massage is more than a massage, it is an overall healing therapy which involves chakra, colour and crystal therapy. Essential oils can be added to the scalp by a trained aromatherapist to induce a real state of well-being. Benefits of becoming certified at Indian Head Massage: Take Indian Head Massage to the employees in the large corporations Incorporate it as an extra into existing treatments to give you 'the edge' Many customers prefer to keep their clothes on Very little workspace is needed. Just a chair! Pre-Blended Aromatherapy This unit is designed to give you an insight into aromatherapy oils. Enjoy discovering the therapeutic and relaxing effects of acupressure massage using pre-blended essentials oils The course will teach the following: The benefits of using pre-blended oils Shiatsu massage Pressure points Oils and their benefits Health and Safety Related Anatomy and Physiology Client Consultation and Contra-indications After-Care Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Your extra unit is: Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Realated Anatomy Health and Safety Client Consultation and Contra-indications Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace NVQ Level 3 General Route: Body Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical body treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring, pigmentation, cellulite and 'Orange Peel' creping. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical facial treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring and pigmentation. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Electrical Epilation Electrolysis gives you the skills necessary for a treatment to remove unwanted hair, using alternating current and blend techniques. Individual hairs can be treated effectively and safely. The course will teach the following: Be able to safely carry out an electrical epilation treatment on most areas of the body Understand how to correctly work to remove unwanted hair Related Anatomy and Physiology Preparation of the work area Health and Safety Client Consultation and Contra-indications After-Care Your extra unit is: Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace IF YOU REQUIRE ANY FURTHER INFORMATION CHECK OUT OUR PROSPECTUS, CALL US, ASK A QUESTION ONLINE AND PAY YOUR DEPOSIT NOW TO AVOID DISAPPOINTMENT! Dates and Costs Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! Course Days Dates Cost NVQ Level 3 ** FAST TRACK OPTION ** 14 OPEN OPEN £2499 NVQ Level 3 ** FAST TRACK OPTION ** 14 2/10/2023 15/10/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 12/11/2023 25/11/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 8/12/2023 21/12/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 1/01/2024 14/01/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 15/02/2024 28/02/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 2/03/2024 16/03/2024 £2499

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

About this Virtual Instructor Led Training (VILT)  This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models. The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects; Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation; Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns. Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size; Understand how to compute P50, P90 and P99 for different projects driven by resource risk; Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90. Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads. Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants. Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Trainer Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects. Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares. Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions. Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours). 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