20497 Other courses

Manual Handling of Inanimate Objects ensures that delegates hold an understanding of safe techniques to use when lifting and moving objects of varying size and weight, so as to avoid any injury to themselves or others.

The Diploma in Child Counselling and Child Psychology offers a deep dive into the complexities of the child mind, blending theory with a keen understanding of the challenges that children face in today’s world. This course equips learners with the knowledge to navigate child psychology’s essential aspects, from emotional development to behavioural patterns, providing a strong foundation in both counselling techniques and psychological principles. It’s perfect for those looking to make a positive difference in children’s lives, whether in educational settings, therapy, or other child-focused roles. As you explore child development and psychological theories, you’ll be guided through practical applications for understanding and addressing various issues that children may encounter. The course is carefully structured to ensure learners grasp the core concepts of child psychology, from understanding childhood trauma to developing effective counselling strategies. With insights into the emotional and psychological challenges children face, this diploma offers the tools to help professionals support children in overcoming barriers to their mental well-being. If you’re passionate about supporting children’s growth and mental health, this course is an excellent step towards enhancing your skills and understanding in this impactful field. Key Features: CPD Certified Diploma in Child Counselling and Child Psychology With Complete Career Guide 11 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Child Psychology Diploma Module 01: Child Psychology and Its Major Context Module 02: Understanding Child Development Module 03: The Scope and Stages of Child Development Module 04: The Areas of Child Development Module 05: Erikson's Theory of Child Development Module 06: Attachment and Relationship Building in Childhood Module 07: Impacts of Separation and Loss of Attachment Module 08: Factors That Influence Development Module 09: Cognitive Development Module 10: Social and Emotional Development Module 11: Moral and Ethical Development in Children Module 12: Personality and Intellectual Development in Children Module 13: Language Development Module 14: Problems of Infancy Module 15:Problems in Childhood and Adolescence Module 16: Problems of Adolescence Child Counselling Module 01: Counselling and Counsellors Module 02: Understanding Child Development Module 03: Factors That Influence Development Module 04: Cognitive Development Module 05: Social and Emotional Development Module 06: Personality and Intellectual Development in Children Module 07: Theories and Models of Counselling (Part 1) Module 08: Theories and Models of Counselling (Part 2) Module 09: Childhood and Adolescent Psychiatric Disorders Module 10: Counselling Children and Adolescents in Schools Module 11: Legal, Cultural and Ethical Issues in Professional Counselling Module 12: Counselling Stress and Anxiety Disorders Module 13: Counselling Trauma and Substance Abuse Module 14: Counselling Mood Disorders and Depression Module 15: Counselling Eating & Sleeping Disorders Module 16: Counselling Self-Harm and Suicide Module 17: Communication Skills and Empathy in Counselling ________________________________________________________________________ Complete Career Guide for Diploma in Child Counselling and Child Psychology (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Child Counselling. In addition to mastering the essentials of Child Counselling, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Child Counselling. Your dream career starts here! List of career guide courses included in Diploma in Child Counselling and Child Psychology With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand the major contexts of child psychology and its relevance. Analyze and comprehend the different stages of child development. Evaluate the impact of attachment and relationship dynamics on childhood. Identify and assess factors influencing cognitive and social-emotional development. Apply theoretical models to effectively counsel children and adolescents. Demonstrate communication skills and empathy in professional counselling settings. ________________________________________________________________________ Accreditation All of our courses, including the Diploma in Child Counselling and Child Psychology With Complete Career Guide course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Diploma in Child Counselling and Child Psychology With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring child counsellors Psychology enthusiasts Educators and teachers Social workers Parents seeking in-depth child development insights Career path Child Psychologist - £35K to 50K/year. Educational Consultant - £30K to 45K/year. Child Welfare Officer - £25K to 40K/year. School Counsellor - £28K to 42K/year. Family Support Worker - £22K to 35K/year. Certificates 11 CPD Accredited e-Certificates Digital certificate - Included 11 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Take the full advantage of Social Media Marketing Nowadays simply advertising your products on tv channels isn't good enough. It is the era of social networks and you can use it as a medium to advertise your product. So would you like to learn how to take full advantage of the social media and increase your sales? Then this course was made just for you. Social media marketing refers to the process of gaining traffic or attention through social media sites such as Facebook, Instagram or Twitter. It is a form of Internet marketing that utilizes social networking websites as a marketing tool. The goal of SMM is to produce content that users will share with their social network to help a company increase brand exposure and broaden customer reach. Social networking websites allow individuals, businesses and other organizations to interact with one another and build relationships and communities online. When companies join these social channels, consumers can interact with them directly. With this course, learn new ways to sell your product by effectively using the social media platforms. After completion of the course you will be capable of advertising your product in a way that will allow you to draw more customers. Course Highlights Extended Diploma in Social Media Marketing is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Extended Diploma in Social Media Marketing into 82 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 18 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Extended Diploma in Social Media Marketing Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Extended Diploma in Social Media Marketing is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Extended Diploma in Social Media Marketing is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Extended Diploma in Social Media Marketing - Updated Version Module 01: Social Marketing Social Marketing Introduction 00:01:00 Social Media Marketing - PROMO VIDEO 00:04:00 Marketing On Facebook & Instagram 00:19:00 Marketing On Twitter & YouTube 00:14:00 Module 02: Pinterest Marketing Introduction To Pinterest Marketing 00:01:00 Pintrest Marketing - Part 1 00:07:00 Pintrest Marketing - Part 2 00:16:00 Pintrest Marketing - Part 3 00:11:00 Module 03: LinkedIn Marketing Linkedln Marketing Intro 00:01:00 Linkedln Marketing - Part 1 00:06:00 Linkedln Marketing - Part 2 00:07:00 LinkedIn Marketing - Part 3 00:05:00 Module 04: Split Testing Introduction to Split Testing 00:01:00 Split Testing - Part 1 00:10:00 Split Testing - Part 2 00:05:00 Split Testing - Part 3 00:09:00 Module 05: Funnel Building Introduction to Funnel Building 00:01:00 Funnel Building - Part 1 00:04:00 Funnel Building - Part 2 00:07:00 Funnel Building - Part 3 00:09:00 Extended Diploma in Social Media Marketing - Old Version Social Media Marketing Introduction FREE 00:30:00 Understanding the Value of Social Media Buzz and What It Can Do For Your Business FREE 01:00:00 Developing a Winning Social Media Marketing Plan 01:00:00 Setup and Manage a Facebook Page That Works 01:00:00 Tweet Your Way to Online Prominence 01:00:00 Build Your Network with LinkedIn 01:00:00 Captivate Your Audience with YouTube 01:00:00 Conclusion 00:15:00 Search Engine Optimization What Is Search Engine Optimization? FREE 01:00:00 Search Engines That Use SEO FREE 01:00:00 Using SEO In Website Text 01:00:00 Using SEO For Google Ads 01:00:00 Using SEO For Article Marketing 01:00:00 Using SEO In Press Releases 00:30:00 Using Longtail Keywords 00:30:00 Using Google To Discover The Best Keywords 00:30:00 SEO For Video Ads 00:30:00 SEO In Photos 00:30:00 Blogging With SEO Marketing 01:00:00 Using A SEO Company 01:00:00 Facebook Marketing Basics Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 Marketing on Facebook 01:00:00 How Much Does Facebook Advertising Cost? 00:30:00 Create a content calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Twitter Social Marketing TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Instagram Marketing What is Instagram? 00:15:00 Instagram for Business 00:15:00 Instagram & Community 00:15:00 Pinterest Social Marketing Introduction 00:30:00 How to Use Pinterest 01:00:00 How to Win the Hearts of the Target Audience on Pinterest 01:00:00 Understanding Pinterest Etiquette 00:30:00 Marketing Strategies to Build Your Brand and Your Followers 02:00:00 Monetizing Pinterest through Market Hunting 01:00:00 Pinterest Tools to Use in Your Marketing Arsenal 00:15:00 Conclusion 00:15:00 Google Adwords Benefits of online advertising and AdWords FREE 00:30:00 Choosing a campaign type FREE 00:30:00 Measure your results 00:30:00 Blogging Basics Introduction 01:00:00 The Anatomy Of A Profitable Blog 03:00:00 Quick & Easy Optimization 00:30:00 Extending Your Blog's Functionality 00:15:00 Turbocharged Profit Strategies 01:00:00 Mock Exam Mock Exam- Advanced Extended Diploma in Social Media Marketing 00:30:00 Final Exam Final Exam- Advanced Extended Diploma in Social Media Marketing 00:30:00

Want to master basic algebra? Engineering, physics, pharmaceuticals and many other industries require excellent numerical skills, so it's important to know your algebra if you want to work in these fields. This Build Your Algebra Fundamentals (New version) Course will help you gain fundamental practical skills and help you reach a higher level of learning, whether you're a student or professional. This essential algebra course will train you to develop your critical thinking skills, so you can become a master at problem-solving and logical reasoning. Even if you have little or no knowledge of the subject, in just a few hours, you'll be able to tackle more advanced algebra equations and simplify equations with ease. You'll explore all levels of algebra, including common algebraic terminology, and will get the chance to tackle beginner and advanced problems. On course completion, you'll have the confidence to solve simple and more complex algebraic equations, with the ability to apply your newfound skills in the workplace. Highlights of this Build Your Algebra Fundamentals (New version) Course Familiarise with basic algebraic expressions and concepts Learn how to multiply and divide algebraic expressions Understand how to expand and simplify brackets Solve linear equations and inequalities with ease Expand your knowledge of algebraic identities Get an overview of polynomials in abstract algebra Familiarise with the coordinate plane and the axis of symmetry What you'll learn Higher Indices - Laws of Indices (Exponent) Formula - Change the subject of formula Rational Expressions - Simplification of Algebraic Fractions to its lowest form BODMAS - Adding and removing brackets in algebraic expressions Graphs - Coordinate Axis, Points and Line Graph Linear equations in one variable and word problems Linear Inequalities Simultaneous linear equations- Graphical method, Substitution method, Equating coefficient & cross multiplication method Graphical method of solving simultaneous linear equations Word problems with the help of simultaneous linear equations Quadratic equations using Factorization method and Quadratic Formula Quadratic equations using squaring complete method Equations reducible to quadratic equations Word problems of Quadratic equations Quadratic polynomials Knowledge of nature of roots of quadratic equations Zeros of polynomials α, β & γ Addition, Subtraction,Multiplication and Division of Algebraic Expressions Remainder Theorem & Factor Theorem Directed Numbers (Integers) Finding Numerical Value of Algebraic Expressions Factorization Techniques like common factors, regrouping , splitting the middle term and using identities Algebraic Identities like ( a - b ) ² , ( a + b ) ³ , a ³ - b ³ , ( a + b + c ) ² etc Requirements Knowledge of Mathematics till 5th grade Introduction Lecture 1 Introduction FREE 00:03:00 Fundamental concepts on Algebraic Expressions Lecture 2 What is Algebra FREE 00:02:00 Lecture 3 Simple Equations 00:05:00 Lecture 4 What are Polynomials 00:04:00 Lecture 5 Terms in Polynomials 00:03:00 Lecture 6 Degree of Polynomials 00:05:00 Lecture 7 Writing statements to algebraic form 00:04:00 Operations on Algebraic Expressions Lecture 8 Integers and common mistakes in solving integers 00:13:00 Lecture 9 Arrangement of Terms 00:07:00 Lecture 10 Powers on integers 00:04:00 Lecture11 Simplification using BODMAS 00:08:00 Lecture 12 Distributive Properties in Polynomials 00:04:00 Lecture 13 Simplify Polynomials 00:10:00 Lecture 14 Additions of Polynomials 00:06:00 Lecture 15 Subtractions of Polynomials 00:10:00 Indices ( Exponents) Lecture 16 The rules of Indices in algebra 00:11:00 Lecture 17 Fractional indices 00:10:00 Lecture 18 Understanding indices (practice questions) 00:07:00 Lecture 19 Problems from IGCSE Last year papers 00:09:00 Multiplication and Division of Algebraic expressions Lecture 20 Multiplication of monomial to Polynomial 00:09:00 Lecture 21 Multiplication of Polynomial by Polynomial 00:06:00 Lecture 22 Division of algebraic expression by a monomial 00:08:00 Lecture 23 Division of algebraic expression by another polynomial 00:09:00 Lecture 24 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 25 Rules of brackets 00:04:00 Lecture 26 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 27 Simplification of algebraic fractions 00:07:00 Lecture 28 Rules to solve linear equations in one variable 00:03:00 Lecture 29 Solving linear equations in one variable 00:07:00 Lecture 30 Solving complex linear equations in one variable 00:10:00 Lecture 31 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 32 What are Identities? 00:05:00 Lecture 33 Identity ( a + b ) ² 00:13:00 Lecture 34 Identity ( a - b ) ² new 00:07:00 Lecture 35 Identity a² - b² = (a-b) (a +b ) new 00:07:00 Lecture 36 -- Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c old 00:07:00 Lecture 37 Identity (x + a) (x + b) Identity Derivation & Application new 00:08:00 Lecture 38 Pascal's Triangle _ Identity ( a + b ) ³ new 00:07:00 Lecture 39 Identities( a - b ) ³, ( a ³ + b ³) and (a ³ - b ³) new 00:13:00 Lecture 40 - Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 41 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 42 - Linear Inequalities 00:12:00 Resolve into factors Lecture 43 - Factorization by taking out common factor 00:10:00 Lecture 44 - Factorization by grouping the terms 00:09:00 Lecture 45 - factorize using identity a ² - b ² 00:07:00 Lecture 46 - factorize using identity (a + b )² and (a - b )² (2) 00:08:00 Lecture 47 - factorize using identity ( a + b + c ) ² 00:05:00 Lecture 48 - factorization by middle term split 00:12:00 Algebraic Fractions Lecture 49 -Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 50 All that you need to know about co ordinate axis 00:04:00 Lecture 51 Some important facts needed to draw line graph 00:03:00 Lecture 52 - How to draw a line graph on coordinate plane 00:03:00 Lecture 53 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 54 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 55 Graphical method of solving linear equations 00:06:00 Lecture 56 Graphical method - more problems 00:10:00 Lecture 57 Method of Elimination by substitution 00:09:00 Lecture 58 Method of Elimination by Equating coefficients 00:11:00 Lecture 59 Method of Elimination by cross multiplication 00:07:00 Lecture 60 Equations reducible to simultaneous linear equations 00:12:00 Lecture 61 Word Problems on Linear equations 00:18:00 Polynomials Lecture 62 Polynomials and Zeros of polynomials 00:10:00 Lecture 63 Remainder Theorem 00:04:00 Lecture 64 Factor Theorem 00:08:00 Lecture 65 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 66 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 67 Zeros of polynomials α, β & γ 00:10:00 Lecture 68 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 69 Finding polynomials if zeros are known 00:06:00 Lecture 70 Practice problems on zeros of polynomials 00:10:00 Lecture 71Problems solving with α and β (part 1) 00:11:00 Lecture 72 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture73 what are Quadratic equations 00:03:00 Lecture 74 Solutions by factorization method 00:12:00 Lecture 75 Solutions by completing square formula 00:06:00 Lecture 76 Deriving Quadratic formula 00:05:00 Lecture 77 Practice problems by Quadratic formula 00:07:00 Lecture 78 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 79 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 80 Skilled problems on Quadratic Equations 00:07:00 Lecture 81 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 82 Nature of Roots of Quadratic Equations 00:09:00 Lecture 83 Word problems on quadratic Equations Part 1 00:13:00 Lecture 84 Word problems on quadratic Equations Part 2 00:11:00

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

Embarking on a journey through the realm of electrical substations, the 'Electrical Engineering for Electrical Substations' course illuminates the path for aspiring electrical engineers. Imagine plunging into the intricacies of electrical substations, a pivotal component in our electrified world. This course offers a unique blend of theoretical knowledge and practical insights, vital for anyone keen on mastering the core elements of electrics and electronics. From the fundamentals in Unit 1, diving into the design of earthing systems in Unit 2, to the nuanced introduction to substation design in Unit 3, students are equipped with a comprehensive understanding of this specialised field. Moreover, the course is an opportunity to enhance one's prospects in various electrical engineering jobs, paving the way for a lucrative career. The course builds a strong foundation in electrical engineering principles and opens doors to diverse opportunities such as electrical engineering apprenticeships. It serves as a stepping stone for those seeking to delve deeper into the field, potentially leading to roles in designing and managing the heart of electrical systems - the substations. This is more than just an educational journey; it's a route to a rewarding career marked by competitive electrical engineering salaries and fulfilling job roles. For those fascinated by the latest technological advancements, the course touches upon the electrifying world of electric car engines, integrating modern innovation with traditional electrical engineering concepts. This unique blend of old and new prepares learners for a future where electrical engineering expertise is valued and essential. Imagine being at the forefront of this exciting field, where every day brings new challenges and opportunities. Learning Outcomes Gain a comprehensive understanding of the basics of electrical substations. Acquire knowledge in designing effective earthing systems. Learn the principles of substation design and management. Develop an appreciation of the integration between traditional electrical engineering and modern innovations like electric car engines. Prepare for a diverse range of electrical engineering roles in various sectors. Why buy this Electrical Engineering for Electrical Substations? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Electrical Engineering for Electrical Substations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Electrical Engineering for Electrical Substations course for? Individuals aspiring to become electrical engineers. Professionals seeking to expand their knowledge in substation design and management. Students interested in pursuing a career in electrical engineering. Technicians aiming for an electrical engineering apprenticeship. Anyone interested in the technological aspects of electric car engines. Prerequisites This Electrical Engineering for Electrical Substations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electrical Engineering for Electrical Substations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Electrical Engineer: Average Salary £28,000 - £40,000 annually Substation Design Engineer: Average Salary £32,000 - £48,000 annually Electrical Project Manager: Average Salary £35,000 - £55,000 annually Senior Electrical Engineer: Average Salary £40,000 - £60,000 annually Electrical Engineering Technician: Average Salary £25,000 - £35,000 annually Renewable Energy Engineer: Average Salary £30,000 - £45,000 annually Course Curriculum Electrical Engineering for Electrical Substations Unit 1: Basics of Electrical Substations Module 1: Introduction To Electrical Substation 00:06:00 Module 2: Construction of Electrical Substation and Transformers 00:09:00 Module 3: Instrument Transformers and Principle of Operation of Trip Circuit 00:13:00 Module 4: Types Of Circuit Breakers And Fuses 00:23:00 Module 5: Types of Relays According to Function, Construction and Time Characteristics 00:06:00 Module 6: Definition of Busbar and Its Schemes 00:17:00 Module 7: Construction of Underground Cables 00:10:00 Module 8: Construction of Overhead Transmission Lines 00:15:00 Module 9: Comparison between Underground Cables and Overhead Transmission Lines@ 00:05:00 Module 10: Types of Switches In Power System and Substations 00:08:00 Module 11: Importance of Capacitor Banks in Power System 00:08:00 Module 12: Other Important Components in Electrical Substation 00:07:00 Module 13: Classification of Substations 00:05:00 Module 14: Relation between Voltage and Substations 00:02:00 Module 15: Air Insulated Substation and Gas Insulated Substation 00:09:00 Module 16: Importance of Ring Main Unit in Power System 00:07:00 Module 17:Extra Images 00:01:00 Unit 2: Design of Earthing System Module 1: Effect of Current on Human Body 00:09:00 Module 2: Types of Electric Hazards 00:08:00 Module 3: Classification of Earthing Systems 00:24:00 Module 4: Components of Earthing System 00:09:00 Module 5: Design and Resistance of Earthing Electrode 00:12:00 Module 6: Design and Resistance of Earthing Conductor 00:13:00 Module 7: Earth Resistance by Megger and Three Point Method 00:03:00 Module 8: Design Earthing or Ground Grid Using ETAP 00:21:00 Unit 3: Introduction to Design of Substation Module 1: What Ip or Ingress Protection 00:05:00 Module 2: Selection of Busbars in Electrical Substation 00:11:00 Module 3: Design of Substations 00:19:00 Module 4: Single Line Diagram of 66 to 11kv Substation 00:20:00 Assignment Assignment -Electrical Engineering for Electrical Substations 00:00:00

AML course will help you to learn how to handle regulatory expectations and protect your organisation, business, and profession from money laundering risks.

Overview The need for trained Adult Nursing professionals is growing fast in the UK. Right now, the NHS has a shortage of over 40,000 nurses, and most of these are in Adult Nursing. This means there are many job opportunities for people who are ready to learn and work in this field. Our Adult Nursing course is made to give you the right skills and knowledge to start or grow your career in healthcare. You will learn the basics of Adult Nursing, including how to give medicines, prevent infections, and help patients move safely. The course also teaches important daily care tasks like hygiene, nutrition, and oxygen support. Everything is taught with a strong focus on legal and ethical rules, so you know how to work safely and respectfully with every patient. This course helps you become confident in both your technical skills and your caring approach. Adult Nursing is a key part of the healthcare system. Whether in hospitals, care homes, or the community, Adult Nursing staff play a big role in patient care and recovery. By learning the core duties and responsibilities, as well as how Adult Nursing connects with wider health and social care, you’ll be ready to support others in need. This course prepares you to make a real difference in people’s lives while building a stable and meaningful career. 4o Learning Outcomes By the end of this Adult Nursing course, you will be able to: Understand key nursing practices used in different healthcare settings Follow legal rules and ethical standards in your daily work Communicate clearly and kindly with patients and team members Use proper hygiene and infection control methods Support patients with needs like eating, moving, and managing pain Apply health and social care values in your nursing work Who is this Course For? Healthcare assistants who want to move forward in their careers and learn more about adult nursing and patient care People working in other areas of healthcare who want to switch to nursing and need a strong base in adult nursing Care workers who want a better understanding of professional care standards, the law, and ethical care Support workers in hospitals, care homes, or clinics who want to improve their skills in giving medicine, handling infections, and helping patients move Anyone in health and social care aiming for career growth and needing to understand safeguarding and key care principles Process of Evaluation After studying the Adult Nursing Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Adult Nursing Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Adult Nursing course. Career Path This Adult Nursing course can lead to roles such as: Adult Nurse – £25,000 to £39,000 per year Healthcare Assistant – £20,000 to £27,000 per year Care Coordinator – £23,000 to £30,000 per year Community Support Worker – £21,000 to £28,000 per year Rehabilitation Assistant – £22,000 to £29,000 per year Course Curriculum Adult Nursing Module 1: Introduction to Nursing 00:17:00 Module 2: Working in Different Healthcare Settings 00:15:00 Module 3: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 00:52:00 Module 4: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 00:50:00 Module 5: Effective Communication in Nursing 00:47:00 Module 6: Health and Safety in Nursing 00:47:00 Module 7: Hygiene in Nursing 00:30:00 Module 8: Infection Control 00:57:00 Module 9: Asepsis in Nursing 00:16:00 Module 10: Medication Administration in Nursing 00:18:00 Adult Care in Different Life Stages 00:17:00 Module 12: Understanding Immune System in Nursing 00:28:00 Module 13: Rest and Sleep Management in Nursing 00:19:00 Module 14: Mobility and Immobility Issues of Patients in Nursing 00:17:00 Module 15: Pain Management for Nurses 00:24:00 Module 16: Nutrition in Nursing 00:25:00 Module 17: Fluid and Electrolyte Balance 00:23:00 Module 18: Assisting with Elimination 00:30:00 Module 19: Oxygenation in Nursing 00:30: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

Employers in the United Kingdom, particularly those in the health and social care sectors, are increasingly interested in their staff having a good understanding of various mental health problems. The demand for mental health skills and resources has steadily increased over the last decade, but it has increased since COVID19. Employees and employers have placed mental health awareness at the top of their priority lists. This Level 2 Certificate in Awareness of Mental Health course will teach you about various aspects of mental illness and will help you improve your skills. This Level 2 Certificate in Awareness of Mental Health qualification will help you to gain a thorough understanding of mental health needs and how to deal with them. The Level 2 Certificate in Awareness of Mental Health Problems course includes a wide range of mental health issues and how they affect individuals. You will also learn how to manage these illnesses and work with people on tackling mental health problems. Learning Outcomes After completing this course, the learner will be able to: Understand the fundamentals of Mental Health. Gain a solid understanding of stress, Anxiety, Phobias, Depression, Postnatal Depression and Schizophrenia. Gain in-depth knowledge about Dementia. Understand Bipolar Disorder and Eating Disorders. Understand Attention Deficit Hyperactivity Disorder (ADHD). Understand Obsessive-Compulsive Disorder (OCD). Understanding Post-Traumatic Stress Disorder (PTSD). Why Choose This Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. **Courses are included in this Level 2 Certificate in Awareness of Mental Health Bundle Course Course 01: Level 2 Certificate in Awareness of Mental Health Course 02: Level 5 Diploma in Family Support Worker Course 03: Level 3 Diploma in Healthcare Support Course 04: Level 3 Award in Health and Social Care Course **Other Benefits of Level 2 Certificate in Awareness of Mental Health Bundle Course Free 4 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Level 2 Certificate in Awareness of Mental Health course] Course Curriculum of Level 2 Certificate in Awareness of Mental Health Module 1: Understanding Mental Health Know what is meant by mental health and mental ill-health Understand how mental health care has changed over time Understand the social context of mental ill health Understand the legal context of mental ill health Module 2: Understanding Stress Understand the term 'stress' Understand possible causes of stress Understand how stress can affect an individual Understand how stress may be managed Module 3: Understanding Anxiety Understand the terms 'anxiety' and 'panic attack' Understand possible causes of anxiety Understand how anxiety can affect the individual and others Understand how anxiety may be managed Module 4: Understanding Phobias Understand the term 'phobias' Understand the possible causes of phobia Understand how a phobia can affect the individual and others Understand how phobias may be managed Module 5: Understanding Depression Understand the term 'depression' Understand the possible causes of depression Understand how depression affects the individual and others Understand how the demands of daily life can affect depression Understand how depression can be managed Module 6: Understanding Postnatal Depression Understand the term 'postnatal depression' Understand the causes of postnatal depression Understand puerperal psychosis Understand how postnatal depression can affect the mother and others Understand how preparation for the birth can help reduce the risk of postnatal depression Understand how postnatal depression may be managed Understand how puerperal psychosis may be managed Module 7: Understanding Bipolar Disorder Understand the term 'bipolar disorder' Understand the causes of bipolar disorder Understand how bipolar disorder can affect the individual and others Understand how bipolar disorder may be managed Module 8: Understanding Schizophrenia Understand the term 'schizophrenia' Understand the causes of schizophrenia Understand how schizophrenia can affect the individual and others Understand how schizophrenia may be managed Module 9: Understanding Dementia Understand the term 'dementia' Understand the causes of dementia Understand how dementia can affect the individual and others Understand how dementia may be managed Understand factors which may adversely affect a person with dementia Module 10: Understanding Eating Disorders Understand the term 'eating disorder' Understand the causes of eating disorders Understand how an eating disorder may affect the individual and others Understand how a specific eating disorder may be managed Module 11: Understanding Attention Deficit Hyperactivity Disorder Understand the term 'ADHD' Understand the causes of ADHD Understand how ADHD can affect the individual and others Understand the symptoms associated with ADHD Understand how ADHD may be managed Module 12: Understanding Obsessive-Compulsive Disorder - OCD Understand the term 'OCD' Understand the causes of OCD Understand how OCD can affect the individual and others Understand the thoughts and behaviour associated with OCD Understand how OCD may be managed Module 13: Understanding Post-Traumatic Stress Disorder - PTSD Understand the term 'PTSD' Understand the causes of PTSD Understand how PTSD can affect the individual and others Understand the symptoms associated with PTSD Understand how PTSD may be managed Assessment Method After completing each module of the Level 2 Certificate in Awareness of Mental Health Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Level 2 Certificate in Awareness of Mental Health course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Level 2 Certificate in Awareness of Mental Health course is ideal for anyone who wants to start a career in the mental health care sector or who already works in this field and wants to learn more about mental health awareness. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path If you enrol in this Level 2 Certificate in Awareness of Mental Health course, it could lead to a career in Education and Childcare. This is especially useful for careers like: Social Work Assistant (£12,500 to £25,000) Mental Health Nurse (£25,654 to £45,838) Psychological Wellbeing Practitioner (£25,654 to £45,838) Certificates Certificate of completion Digital certificate - Included