4431 Courses delivered Online

Overview This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course. Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry. In This Microsoft Excel: Master Power Query Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Microsoft Excel: Master Power Query skills to help you advance your career. Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts. Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career. This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.  The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.  And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Microsoft Excel: Master Power Query course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Microsoft Excel: Master Power Query Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Plumbing and air conditioning are essential services for every home and business. The UK plumbing and air conditioning industry is worth over £50 billion and employs over 500,000 people. There is a high demand for skilled plumbers and air conditioning engineers, and the average salary for these roles is above the national average. In the heart of every building lies a complex system of pipes, drains, vents, and heating units. Become an indispensable part of this foundational architecture with our comprehensive Plumber course that offers training in Plumbing as well as Heating, Ventilation, and Air Conditioning (HVAC). According to the Office for National Statistics, the construction industry in the UK has been steadily growing, creating a heightened demand for skilled plumbers and HVAC technicians. Unlock the gateway to a resilient, well-paid career and gain mastery over everything from the UK plumbing standards to advanced domestic hot water system installations. Take your chance to learn from a meticulously designed curriculum covering all aspects of modern plumbing and HVAC systems. You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Plumbing Sanitary System Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Plumbing Sanitary System Training course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Plumbing Sanitary System Training is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Plumbing Sanitary System Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Plumbing Sanitary System Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Plumbing Sanitary System Training Welcome to the Course 00:01:00 Course Content 00:07:00 Introduction 00:02:00 Sewage Types 00:03:00 Sewage Systems 00:07:00 Important Terms 00:01:00 Drainage Trap 00:03:00 Drainage Branch 00:01:00 Building Drain 00:02:00 Building Sewer 00:01:00 Sanitary Drainage Pipes 00:03:00 PVC Pipes 00:02:00 HDPE Pipes 00:01:00 Pipes Connection 00:02:00 Pipes Test 00:01:00 Pipes Support 00:01:00 Pipes Slope 00:04:00 Pipes Sizing Part 1 00:04:00 Pipes Sizing Part 2 00:05:00 Important Notes 00:03:00 Hydraulic Jump 00:04:00 Cleanouts 00:05:00 Floor Drains 00:04:00 Trench Drain 00:01:00 Oil Interceptor 00:01:00 Gully Trap 00:04:00 Grease Interceptor 00:04:00 Inspection Chamber & Manholes 00:02:00 Inspection Chamber & Manholes Locations 00:02:00 Inspection Chamber & Manholes Dimensions 00:03:00 Inspection Chamber & Manholes Specifications 00:03:00 Inspection Chamber & Manholes Distances 00:40:00 Slow Down Chamber 00:03:00 Sump Pit & Sump Pump 00:03:00 Sump Pump Flow Rate Calculation 00:03:00 Sump Pit Volume Calculation 00:03:00 Sump Pump Head Calculation 00:02:00 Septic & Holding Tank 00:06:00 Septic & Holding Tank Volume 00:03:00 Septic & Holding Tank Notes 00:02:00 Thank You 00:01:00

A Footpath to Wellness: Dive into the World of Reflexology Have you ever dreamt of walking a path paved with holistic healing? Where fingertips become instruments of well-being, and the map lies not on paper but etched on the soles of your feet? Step into the fascinating realm of Reflexology - Acupressure and Foot Reading, and unlock a treasure trove of ancient wisdom for yourself and others. The UK's wellness industry is booming, with a £4.2 billion market estimated to rise further. People yearn for natural, self-directed approaches to health, and reflexology fits the bill perfectly. This comprehensive Reflexology - Acupressure and Foot Reading course empowers you to tap into this growing trend, equipping you with the knowledge and skills to navigate the intricate landscape of the feet. This course is your compass on this rewarding journey. From identifying key acupressure points to deciphering the secrets hidden in foot shapes and colours, you'll gain the knowledge and confidence to embark on a fulfilling career or elevate your self-care routine. Ready to walk the path to holistic wellness? Enrol today and start reaping the benefits of Reflexology - Acupressure and Foot Reading! You will Learn The Following Things: Identify the main acupressure points on the feet and their uses. Explain the tools used in reflexology treatments. Recognise medical conditions that can benefit from reflexology. Analyse the feet to gather insights about a person's health. Practice sequences for reflexology sessions. Apply knowledge to provide reflexology treatments. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Reflexology - Acupressure and Foot Reading. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Reflexology - Acupressure and Foot Reading course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Massage Therapists: Expand your repertoire with a complementary therapy rooted in traditional Chinese medicine. Aspiring Reflexologists: Build a solid foundation for a fulfilling career in holistic healing. Footwear Enthusiasts: Deepen your understanding of how feet reveal fascinating insights about our health and personality. Stress Warriors: Discover self-care techniques to combat tension and promote deep relaxation. Health-curious Individuals: Embark on a journey of self-discovery, learning to read the stories your feet tell. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Reflexology - Acupressure and Foot Reading course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Reflexologist - £18K to £30K per year. Spa Therapist - £16K to £25K per year. Wellness Coach - £20K to £35K per year. Natural Health Practitioner - £22K to £40K per year. Salon Owner - £30K to £60K per year. Course Curriculum Section 01: Introduction Introduction 00:03:00 Section 02: Main Acupressure Points Large Intestine 4 00:02:00 Lung 10 00:01:00 Small Intestine 3 00:01:00 Heart 7 00:02:00 Pericardium 6 00:01:00 Kidney 3 00:02:00 Liver 3 00:01:00 Stomach 36 00:02:00 Section 03: Tools we can use in our treatment Tools we can use in our treatment 00:02:00 Section 04: Certain Medical Conditions Anxiety 00:05:00 Headaches 00:04:00 Fibromyalgia 00:05:00 Menstrual Disorders 00:02:00 Insomnia 00:05:00 Arthritis 00:04:00 COLDS AND FLUS 00:02:00 Asthma 00:02:00 Section 05: Foot Reading Introduction 00:02:00 Start by Reading the Feet in Consultation 00:02:00 Zones 00:05:00 Toe Line Meanings 00:04:00 Section 06: Size of Feet Size of Feet 00:01:00 Arches 00:02:00 Section 07: Colour of the Feet Colour of the Feet 00:03:00 Nails 00:04:00 Skin Conditions 00:05:00 Section08: Gaps between Toes Gaps between toes 00:02:00 Section 09: Foot Sequence Foot Sequence 00:04:00 Section 10: Congratulations on Completing your Course Congratulations 00:01:00 Assignment Assignment -Reflexology - Acupressure and Foot Reading 00:00:00