15908 Courses delivered Online

Safeguarding: Level 2 Safeguarding and Prevent Course Online Introducing Safeguarding: Level 2 Safeguarding and Prevent Course "Empowering the Next Generation" Online course! Anyone who wants to work in local authorities, schools, colleges, uniformed services, or health and social care must understand safeguarding and the prevention duty, as well as how to incorporate these principles into their daily work practices. This Safeguarding: Level 2 Safeguarding and Prevent Course will increase your understanding of safeguarding and the Prevent duty, the responsibilities and procedures involved, and how to effectively raise concerns. The Safeguarding: Level 2 Safeguarding and Prevent Course covers extremism, British values, cyberbullying, and online grooming. Through this Safeguarding: Level 2 Safeguarding and Prevent Course, you will also learn the meanings of the terms "radicalization," "extremism," and "terrorism," as well as how to effectively comply with the Prevent duty. Why choose this Safeguarding: Level 2 Safeguarding and Prevent Course from the School of Health Care? Self-paced Safeguarding: Level 2 Safeguarding and Prevent Course, access available from anywhere in the world. High-quality study materials that are easy to understand. Safeguarding: Level 2 Safeguarding and Prevent Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Safeguarding: Level 2 Safeguarding and Prevent Course. Main Course: Level 2 Certificate in Understanding Safeguarding and Prevent Free Courses included with Safeguarding: Level 2 Safeguarding and Prevent Course Course 01: Level 2 Certificate in Preparing to Work in Adult Social Care Course 02: Safer Recruitment Training Course [ Note: Free PDF certificate as soon as completing the Safeguarding: Level 2 Safeguarding and Prevent Course] Safeguarding: Level 2 Safeguarding and Prevent Course Online This Safeguarding: Level 2 Safeguarding and Prevent Course consists of 03 modules. Course Curriculum of Safeguarding: Level 2 Safeguarding and Prevent Course Module 01: Understanding the Prevent Duty Module 02: Understanding Safeguarding Module 03: Understanding Online Safety Assessment Method of Safeguarding: Level 2 Safeguarding and Prevent Course After completing Safeguarding: Level 2 Safeguarding and Prevent Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Safeguarding: Level 2 Safeguarding and Prevent Course After completing the Safeguarding: Level 2 Safeguarding and Prevent Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Safeguarding: Level 2 Safeguarding and Prevent Course Online This Safeguarding: Level 2 Safeguarding and Prevent Course is suitable for those who want to better understand safeguarding and the Prevent duty, the responsibilities and procedures involved, and how to raise concerns effectively. Special Note: Our Level 2 Safeguarding and Prevent Course is not a regulated course. If you prefer to get qualified, you can look at the following options: NCFE CACHE Level 2 Certificate in Understanding Safeguarding and Prevent Level 2 Protecting Children and Young People (RQF) Level 3 Designated Safeguarding Lead Training (RQF) Requirements Safeguarding: Level 2 Safeguarding and Prevent Course Online To enrol in this Safeguarding: Level 2 Safeguarding and Prevent Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Safeguarding: Level 2 Safeguarding and Prevent Course. Be energetic and self-motivated to complete our Safeguarding: Level 2 Safeguarding and Prevent Course. Basic computer Skill is required to complete our Safeguarding: Level 2 Safeguarding and Prevent Course. If you want to enrol in our Safeguarding: Level 2 Safeguarding and Prevent Course, you must be at least 15 years old. Career path Safeguarding: Level 2 Safeguarding and Prevent Course Online After completing this Safeguarding: Level 2 Safeguarding and Prevent Course, candidates may pursue a career in: Local Government Administrative Assistant (£17,500 to £24,500) Higher Education Lecturer (£33,000 to £54,000) Social Worker (£24,000 to £40,000)

Youth Work: Youth Work Course online Youth workers plan, organise and supervise community programs for young people. It enables young people to naturally develop their voice, influence, and place in society, allowing them to reach their full potential. Young people need to develop strong interpersonal and social skills. This Youth Work: Youth Work Course will teach you how to organise youth work and youth engagement activities. This Level 2 Youth Work Certificate course will be discussed the fundamentals of outdoor management and the skills and responsibilities of youth workers. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. You will be introduced to various methodologies and models that have influenced modern youth work practices through both practical and theoretical training. This Youth Work: Youth Work Course's lessons have been designed so that anyone with no prior knowledge of the subject can easily dive into them. So, enrol this Youth Work: Youth Work Course now and successfully start your career. Learning Objectives After completing this Youth Work: Youth Work Course, the learner will be able to: Understand the fundamentals of youth work. Recognise who are youth workers. Know the role and approaches of youth workers. Explain the ethical conduct and principles in youth work. Describe the social change in youth development work. Know the National Youth Agency (NYA). Explain youth work according to the EU. Know the mental health of youth workers. Deal with stress. Describe youth justice and social work. Why choose this Youth Work: Youth Work Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Youth Work: Youth Work Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Youth Work: Youth Work Course. Courses You will GET: Course 01: Care Certificate Course 02: Level 2 Youth Work Certificate [ Note: Free PDF certificate as soon as completing the Youth Work: Youth Work Course] Youth Work: Youth Work Course online Course Curriculum of Youth Work: Youth Work Course Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Youth Work: Youth Work Course. Who is this course for? Youth Work: Youth Work Course online This Youth Work: Youth Work Course is open to people of all backgrounds. Individuals in related professions can also enrol in this Youth Work: Youth Work Course to refresh or strengthen their skills. In addition, students can take this Youth Work: Youth Work Course to gather professional knowledge besides their study or for the future. Requirements Youth Work: Youth Work Course online To enrol in this Youth Work: Youth Work Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Youth Work: Youth Work Course. Be energetic and self-motivated to complete our Youth Work: Youth Work Course. Basic computer Skill is required to complete our Youth Work: Youth Work Course. If you want to enrol in our Youth Work: Youth Work Course, you must be at least 15 years old. Career path Youth Work: Youth Work Course online Enrol in the Youth Work: Youth Work Course today to learn the skills and knowledge required to work with young people and organise youth activities. Opportunities in this field are: Youth Worker Working within a community organisation. PE Teacher Social Worker

Level 5 & 3 Nutrition & Diet - Nutritional Therapy Online Unlock the Power of Nutritional Therapy: Nutritional Therapy Course: Enrol Now! The general public is becoming more aware of the importance of dietary habits to overall human health. We are what we eat, and how we approach our daily diets has a significant impact on all aspects of health and wellbeing. Because of the importance of dietary balance, millions of adults around the world have begun to take their dietary habits more seriously, proactively monitoring and controlling what they put into their bodies. Nonetheless, professional nutritionists' advice and support are required to guide health-conscious individuals in the right direction. This Nutritional Therapy: Nutritional Therapy Course will help you become a confident nutritional therapist and build more advanced skills. The Nutritional Therapy: Nutritional Therapy Course discusses the basics of human nutrition, micronutrients and macronutrients, digestion and detoxification, dietary balance and its importance to human health, principles of healthy eating, weight loss and weight management concepts and much more. Enrol on this Nutritional Therapy: Nutritional Therapy Course today and gain the appropriate skills and expertise needed to start your career as a successful nutritionist. Main Course: Nutritional Therapy Course Free courses included with Nutritional Therapy Course Course 01: Level 2 Award in Nutrition and Health Course 02: Diet and Nutrition (Diploma Level 5) Course 03: Level 3 Certificate in Nutrition Course 04: Level 2 Certificate in Understanding Nutrition and Health Course 05: Level 2 Award in Improving Personal Exercise, Health and Nutrition Special Offers of this Nutritional Therapy: Nutritional Therapy Course: This Nutritional Therapy: Nutritional Therapy Course includes a FREE PDF Certificate. Lifetime access to this Nutritional Therapy: Nutritional Therapy Course Instant access to this Nutritional Therapy: Nutritional Therapy Course 24/7 Support Available to this Nutritional Therapy: Nutritional Therapy Course [ Note: Free PDF certificate as soon as completing the Level 5 & 3 Nutrition & Diet - Nutritional Therapy: Nutritional Therapy Online Course] Level 5 & 3 Nutrition & Diet - Nutritional Therapy Online This Nutritional Therapy: Nutritional Therapy course consists of 15 modules. Course Curriculum of Nutritional Therapy: Nutritional Therapy Course Module 01: Introduction to Nutrition Module 02: Fundamentals of Nutrition- I Module 03: Fundamentals of Nutrition- II Module 04: Digestion and Detoxification Module 05: Eating Disorders Module 06: Maintaining a Balanced Diet Module 07: Basis of Healthy Eating Module 08: Nutrition and the Immune System Module 09: Understanding the Diet Related Diseases Module 10: Understanding Women’s Health Module 11: Necessity of Nutrition for Different People Module 12: Controlling Weight Module 13: Managing Weight Loss Module 14: Techniques Applied for Anti-ageing Module 15: The Function of a Nutritionist Assessment Method of Nutritional Therapy: Nutritional Therapy After completing Working in Nutritional Therapy: Nutritional Therapy course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Nutritional Therapy: Nutritional Therapy After completing the Working in Nutritional Therapy: Nutritional Therapy course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Level 5 & 3 Nutrition & Diet - Nutritional Therapy Online This Nutritional Therapy: Nutritional Therapy Course is suitable for anyone looking to transform a passion for diet and human health into rewarding career life. Requirements Level 5 & 3 Nutrition & Diet - Nutritional Therapy Online To enrol in this Nutritional Therapy: Nutritional Therapy Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Nutritional Therapy: Nutritional Therapy Course. Be energetic and self-motivated to complete our Nutritional Therapy: Nutritional Therapy Course. Basic computer Skill is required to complete our Nutritional Therapy: Nutritional Therapy Course. If you want to enrol in our Nutritional Therapy: Nutritional Therapy Course, you must be at least 15 years old. Career path Level 5 & 3 Nutrition & Diet - Nutritional Therapy Online After completing this Nutritional Therapy: Nutritional Therapy Course, candidates may choose to pursue an extensive range of careers, including: - Professional Nutritionist, Public Health Nutritionist, Clinical Nutritionist, Community Nutritionist, Therapeutic Nutritionist.

The Fire & Security Engineer Course offers an essential foundation in fire safety principles tailored for professionals seeking to deepen their understanding of this critical field. Covering key areas such as fire safety legislation, effective fire safety measures, and emergency evacuation procedures, this course provides a clear, structured pathway to mastering the essential knowledge required in fire safety management. Each module is designed to deliver clear and precise information, enabling learners to confidently navigate the complexities of fire safety regulations and procedures. This online course is ideal for those who wish to enhance their knowledge without the need for physical attendance. The content is carefully developed to suit remote learning, providing flexible access to all course materials. Whether you are involved in facility management, security, or health and safety, this course equips you with a solid understanding of how to create safer environments and respond efficiently during fire emergencies. A strong grasp of fire safety legislation and measures is key to ensuring the safety of people and property, making this course a valuable addition to any professional portfolio. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Fire Safety Module 02: Fire Safety Legislation Module 03: Measures of Fire Safety Module 04: Fire Emergency Evacuation Procedures Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Fire & Security Engineer training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Fire & Security Engineer training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Give a compliment to your career and take it to the next level. This Raising Awareness on OCD: Strategies and Support bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Raising Awareness on OCD: Strategies and Support bundle will help you stay ahead of the pack. Throughout the Raising Awareness on OCD: Strategies and Support programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Raising Awareness on OCD: Strategies and Support course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. Courses are included in this Raising Awareness on OCD: Strategies and Support Bundle? Course 01: OCD Awareness Course 02: Cognitive behavioural therapy Course 03: Dialectal Behaviour Therapy (DBT) Course 04: Cerebral Palsy Awareness Course 05: Concussion and Brain Injury Awareness Course 06: Domestic Violence and Abuse Awareness - Level 2 Course 07: Mental Health Laws and Awareness - Level 2 Course 08: Biohacking Your Physical and Mental Health Course 09: EFT - Emotional Freedom Technique Course 10: Counselling Course Course 11: Personal Hygiene As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Raising Awareness on OCD: Strategies and Support to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Raising Awareness on OCD: Strategies and Support: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable and in-demand skills without leaving your home. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 1: OCD Awareness Module 01: Introduction to Obsessive-Compulsive Disorder What is an Obsessive Compulsive Disorder? Understanding OCD Common Obsessions Compulsions Common Anxiety Disorders Other Disorders Reasons behind OCD Module 02: Signs, Symptoms and Causes of OCD Signs and Symptoms Causes Module 03: Identifying and Treating Specific OCD Symptoms Doubting and Checking Categories of Doubting Steps to Overcome Doubt and Control Checking Treating Shaming Treating Hoarding Revealing Common Superstitions and Rituals Summary Module 04: Treatment for OCD Introduction Cognitive Behavioural Therapy Cognitive Therapy Serotonin Reuptake Inhibitors Herbal Treatments Summary Module 05: Treating Children with OCD OCD in Children What is CBT? Developmental issues in CBT Principles and Strategies of CBT CBT for Children Benefits of Using CBT with Kids and Youth How to Treat a Child with OCD? Summary Module 06: Overcoming OCD Common Types of OCD Distortion Dismissing Unreasonable Doubts Control over Thoughts Assessing and Writing OCD narratives Summary Module 07: Relapse Prevention and Recovery Process of Recovery Returning to Work Effective Relapse Prevention Relationship with Partner Relationship with Children Summary Module 08: Living with OCD Families with OCD How Does OCD Affect Families? Diagnosis of Relatives Coping Up with Family Member's OCD Self-Care Helping Family and Friends Summary Course 2: Cognitive behavioural therapy Psychology of Stress Individual experiences of 'stress' Stress Management Psychology of 'Anxiety' Anxiety Disorders Coping with Anxiety Final Words Course 3: Dialectal Behaviour Therapy (DBT) Introduction Introduction What is Counselling & Psychotherapy About Dialectical Behaviour Therapy (DBT) DBT Strategies & 'Life Skills' Treatment by DBT DBT for Psychological Disorders Effectiveness of DBT Course 4: Cerebral Palsy Awareness Understanding Cerebral Palsy Causes and Symptoms of Cerebral Palsy Epidemiology of Cerebral Palsy Diagnosis of Cerebral Palsy Principles of Treatment Principles of Rehabilitation: Occupational and Physical Therapy Care Planning Typical Child vs Child with Cerebral Palsy Child, Family and Therapist Working as a Team Course 5: Concussion and Brain Injury Awareness Introduction To Brain Injury Concussion Awareness Acquired Brain Injury Sports-related Concussion And Brain Injury Rehabilitation Prevention Course 6: Domestic Violence and Abuse Awareness - Level 2 Introduction to Domestic Violence & Abuse The Components of Domestic Violence The Impact of Domestic Violence on Victims The Impact of Domestic Violence and Abuse on Children Assessing the Risks of Domestic Violence and Abuses on Children Supporting the Victim and Reporting Incidents Record Keeping Course 7: Mental Health Laws and Awareness - Level 2 The Mental Capacity Act Interface with Legislation, Policy and Procedures Deprivation of Liberty Safeguards The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic Mental Health Legislation and Services Liberty Protection Safeguards (LPS) Course 8: Biohacking Your Physical and Mental Health Introduction Sleep - So MUCH More Than Just Rest Blue Light & Red Light Mindfulness & Movement What You Put In Your Mouth is KEY! Hidden Secret - 'Cryotherapy' Importance Of PURE Air Final Thoughts & Recommendations Course 9: EFT - Emotional Freedom Technique What Is EFT (Emotional Freedom Technique)? EFT and Emotions, The Brain (EFT with the body) EFT Procedure Detailed Instructions of EFT Applying EFT to Physical Issues Treating Children with EFT EFT That Can Improve/ Heal Life & Tips Doing Business with EFT Course 10: Counselling Course Introduction to the course Understanding Psychotherapy Starting Psychotherapy Practice Your Potential Clients in Therapy Different Types of Psychotherapy Internet-Based Therapy Course 11: Personal Hygiene Introduction to Personal Hygiene and a Brief History Looking Clean, Smelling Clean Improving and Maintaining Oral Health Care of the Eyes Ear Care Secrets Foot & Nail Care in Personal Hygiene Hair Care Hygienic Ways Hygienic Approach to Skin Care Maintain Good Toilet Hygiene Potential Hygiene Guidelines Personal Hygiene During Coronavirus Pandemic CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Raising Awareness on OCD: Strategies and Support bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Guide children’s behaviour with positive techniques in our Children's Social Behaviour Training course.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! 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 Microsoft Excel. 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

A beginner's level course that will help you learn data engineering techniques for building metadata-driven frameworks with Azure data engineering tools such as Data Factory, Azure SQL, and others. You need not have any prior experience in Azure Data Factory to take up this course.

Duration 1 Days 6 CPD hours This course is intended for This course is targeted towards developers looking to build a career as a Node.js developer. This course offers you a deep but gentle dive into Node.js. You will start off by discovering the basic building blocks of the modern JavaScript language, which are necessary for you to have a good grasp of Node.js, before delving into the fundamentals of Node.js.Most courses quickly dive into Node.js forgetting that, at the end of the day, Node.js is still JavaScript. This can be challenging for JavaScript newbies who are then trying to build a solid house on a shaky foundation.This course overcomes that obstacle by beginning with a quick introduction to the modern JavaScript language (ES6+). You will then discover Node's asynchronous programming model and examine Node's module system, including built-in modules and application modularization, as well as the NPM third-party module registry. We will finish off by working on a simple web application API using the Hapi.js and Knex.js frameworks. Introduction to Node.js The Basics of Node.js The Module System Asynchronous Programming with Node.js Building the API: Part 1 Building a Basic HTTP Server Setting up Hapi.js Understanding Requests Building the API: Part 2 Working with the DB Using Knex.js Authenticating Your API with JWT Testing Your API with Lab Additional course details: Nexus Humans Beginning API Development with Node.js training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Beginning API Development with Node.js course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Property is more than bricks and mortar—it’s a world shaped by negotiation, insight, and well-timed decisions. This course takes a closer look at the full journey of buying and selling property, from the initial stages of property marketing through to the legal steps of conveyancing. It’s built for learners who want a firm understanding of the estate agency process without the fluff—just clear, concise insight into how the industry works from the inside out. You’ll explore how properties are valued, marketed, and sold, along with the rules that keep everything ticking legally. Whether you're considering a career in property sales or simply want to get clued up on how homes move from one owner to the next, this course lays the groundwork with straight-talking modules and logical structure. Perfect for those who prefer substance over sales pitch. Key Features of Property Sales, Property Marketing & Conveyancing Bundle CPD Accredited Course Instant PDF certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Property Sales, Property Marketing & Conveyancing Curriculum Course 01: Residential Property Sales Course 02: Property Management Training Course 03: Property Development Diploma Course 04: Estate Agent: Listing, Letting and Selling Property Course 05: Property Law and Taxation Course 06: Property Marketing and Negotiation Course 07: Social Housing Management Course 08: Mortgage Advisor Course Course 09: Contract Manager Course 10: Document Control Course 11: Conveyancing Accreditation This courses are CPD 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 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Property Sales, Property Marketing & Conveyancing basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Property Sales, Property Marketing & Conveyancing Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.