979 Environment courses in London

This IRATA training course is for candidates who already have an IRATA Level 2 qualification, plus 1,000 hours of work on ropes, one year of experience from your previous Level 2 assessment and a Level 2 certificate that is still in date.

Effective report writing, the exchange of information, ideas, opinions and decisions between people at all levels, internally and externally, makes a vital contribution to organisational success.

See how plastic bottle tops are remelted into beautiful objects!

Our Stoma Care Training course allows learners to gain theoretical and practical stoma care knowledge.

Check out this Emergency First Aid at Work from Knight Training. Ensure the safety of your employees and take on the Emergency First Aid at Work Course that Knight Training offer at: https://knight.training/products/emergency-first-aid-at-work

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' 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 in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

Enhance your Nutrition and Hydration skills with practical training and expert guidance

Bespoke tuition for small groups.

Employee Assistance Programme Training

Course Introduction for VTCT upgrade The VTCT qualification is recognised around the world and will allow you to be employed in a clinic, salon or allow you to set up your own business. The Federation of Holistic Therapists and the Association of Reflexology, two of the biggest Holistic Therapy organisations which both accept members with this qualification. Description Reflexology uses many techniques to manipulate reflex zones found in the feet, of which correspond to a specific body part. The zones have been mapped and this enables the Reflexologist to treat the whole body via these reflex zones on the feet. The treatment is primarily used for the stimulation of all bodily systems and aiding relaxation. Reflexology is performed frequently within the Health Service personnel and has a role in comforting and supporting terminally ill patients. This 5 day VTCT Course leads to practitioner status, focusing on providing you with knowledge of the principles of reflexology, competence in dealing with clients, correct use of consultation techniques and good use of planning treatments. You will also learn the benefits and techniques of reflexology and how to target certain key areas such as: Pregnancy or Hand Massage. Duration 5 days, 10.00am – 5.30pm. Practical elements are covered over 5 days attendance at our Academy. Theory elements are covered by homestudy. Qualification Structure T/501/9101 - Knowledge of Anatomy, Physiology and Pathology for Complementary Therapies F/501/9117 - Provide Reflexology A/501/9116 - Reflective Practice for Reflexology Y/501/9253 - Principles and Practice of Complementary Therapies K/501/9256 - Health, Safety and Hygiene for Complementary Therapies H/501/9255 - Business Practice for Complementary Therapies D/501/9111 - Knowledge of Less Common Pathology for Complementary Therapies Course Contents Health, safety, hygiene and security with regard to the complementary therapy industry. Principles and practice of the complementary therapy industry. Knowledge and understanding of anatomy, physiology and common pathology of the human body. How to prepare for and provide an effective reflexology treatment and adapt to client requirements. Contra-indications and contra-actions, advice to be given to the client, record-keeping, evaluation of treatments and reflection on professional practice. Recognising Body Language Stress and Illness Analysis of Posture Legal Aspects, Code of Conduct and Ethics Advanced Techniques including the use of Meridian lines and Chakra's Home Study You can register your place and receive your lifetime membership. You can then make a start on some of the theory work sent to you by us here at the Academy. This includes your Anatomy and Physiology assignments that you can work on in the privacy of your own home. This allows you to have more time to focus on the practical when the class meets together. Approx. 5-10 hours per week need to total your home study time spent. The home work will need to meet the quality of National Standards. You will also be expected to complete 100 reflexology treatments from the start to the end of the course. You will also need to complete some assignments that will be required for your portfolio and a work-book will need to be completed. There are also 2 small exams that will be taken at the Academy in order to assess your understanding of Health and Safety and Anatomy and Physiology. These are multiple choice assessments and are nothing to worry about! Included in the Course Comprehensive course materials, handouts and work-book Online Resources: Virtual Learning Environment packed with extensive support materials, resources, help and advice Post-training support by phone, instant messaging or email (if desired) Assessment of practical/written work included (Must be sent Recorded Delivery) VTCT QCF Diploma in Reflexology Lots of fun and knowledge from Tutors with a whole wealth of skills and experience Light refreshments including tea, herbal tea, coffee and water Cost Training - £999