10600 Opportunities courses in Cardiff delivered On Demand

Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care This Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course is designed for those who want to begin a career in mental health and lay a solid foundation of mental health fundamentals. The Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course will assist you in assessing work-related mental health issues, determining levels of risk to staff, and implementing strategies to reduce workplace stress. Learning Outcomes After completing this Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course, the learner will be able to: Understand the basics of nursing. Know how to work in different types of healthcare settings. Understand legal, professional standards of practice and ethical aspects of health care. Understand the importance of communication in nursing. Gain a solid understanding of health and safety in nursing. Gain in-depth knowledge about hygiene and infection control in nursing. Understand asepsis in nursing. This Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course aims to teach you everything you need to know about the Mental Capacity Act (MCA) of 2005 and the Deprivation of Liberty Safeguards (DOLS). Learn about the most recent mental health knowledge to help you excel in your chosen mental health career. With the MCA and DOLS training, you will learn the skills required to assess mental capacity and provide care or treatment to people who lack capacity. Main Course: Level 5 Mental Health Care Free Courses Course 01: Mental Health Support Worker Course 02: Level 3 Award in Health and Social Care [ Note: Free PDF certificate as soon as completing the Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course] Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care Course Curriculum of Level 5 Mental Health Care Module 01: An Overview of Mental Capacity Act Module 02: Assessing Mental Capacity Module 03: How to make Best Interest Decision Module 04: Mental Capacity Advocates and Forward Planning Module 05: Treatment Protocols for People Who Lack Capacity Module 06: Confidentiality and Record Keeping Module 07: Public Bodies and Services Created by MCA Act 2005 Module 08: Interface with Legislation, Policy and Procedures Module 09: Deprivation of Liberty Safeguards Module 10: Lawful Deprivation Module 11: Legal Background to DOLS Module 12: The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic Module 13: Liberty Protection Safeguards (LPS) Assessment Method of Level 5 Mental Health Care After completing Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care 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 Level 5 Mental Health Care After completing the Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care 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 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care This Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course is ideal for: Nursing Assistants Nursing Associates Nursing Home Manager Anyone wants to start their career in nursing Requirements Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care To enrol in this Level 5 Mental Health Care Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 5 Mental Health Care Course. Be energetic and self-motivated to complete our Level 5 Mental Health Care Course. Basic computer Skill is required to complete our Level 5 Mental Health Care Course. If you want to enrol in our Level 5 Mental Health Care Course you must be at least 15 years old. Career path Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care Enrolling on this Level 5 Mental Health Care Diploma & Psychiatric Disorders with Health & Social Care course can lead you to the following job opportunities: General Nurse Health and Social Care Workers Carers Midwives Other Health Care Professionals

Advance Your Career with Our Level 4 Teaching Assistant Course Are you ready to enhance your role in education? Our Level 4 Teaching Assistant: Level 4 Teaching Assistant course is your pathway to greater responsibility and impact in the classroom. As a Level 4 Teaching Assistant, you’ll develop advanced skills in supporting both students and teachers, positioning yourself as an essential member of the educational team. With our Level 4 Teaching Assistant: Level 4 Teaching Assistant course, you'll master techniques in classroom management, lesson delivery, and individualized student support. This Level 4 Teaching Assistant: Level 4 Teaching Assistant qualification is designed to empower you with the knowledge and confidence needed to lead small groups, assist in curriculum planning, and contribute to the overall learning environment. Enrolling in the Level 4 Teaching Assistant program means you’ll receive expert guidance, ensuring you’re fully equipped to excel in your role. The Level 4 Teaching Assistant: Level 4 Teaching Assistant course is tailored to fit your schedule, offering flexible learning options that allow you to balance your career and studies. By completing the Level 4 Teaching Assistant course, you’ll open doors to new career opportunities, whether you aim to specialize in areas like Special Educational Needs or move into senior teaching assistant roles. Becoming a Level 4 Teaching Assistant is your step towards a more rewarding and impactful career in education. Take the next step—enroll in the Level 4 Teaching Assistant: Level 4 Teaching Assistant course today and transform your future in education! Special Offers of this Level 4 Teaching Assistant: Level 4 Teaching Assistant Course: This Level 4 Teaching Assistant: Level 4 Teaching Assistant Course includes a FREE PDF Certificate. Lifetime access to this Level 4 Teaching Assistant: Level 4 Teaching Assistant Course Instant access to this Level 4 Teaching Assistant: Level 4 Teaching Assistant Course 24/7 Support Available to this Level 4 Teaching Assistant: Level 4 Teaching Assistant Course [ Note: Free PDF certificate as soon as completing the Level 4 Teaching Assistant: Level 4 Teaching Assistant Course] Level 4 Teaching Assistant: Level 4 Teaching Assistant Online Training The Level 4 Teaching Assistant: Level 4 Teaching Assistant course is designed to elevate your role in education by providing advanced skills and knowledge. As a Level 4 Teaching Assistant, you'll gain expertise in classroom management, student support, and lesson planning. This Level 4 Teaching Assistant: Level 4 Teaching Assistant course prepares you for leadership roles and specialized responsibilities, making you a more integral part of the educational team. Ideal for career advancement, the Level 4 Teaching Assistant: Level 4 Teaching Assistant course empowers you to make a significant impact in the classroom. Who is this course for? Level 4 Teaching Assistant: Level 4 Teaching Assistant Online Training This Level 4 Teaching Assistant: Level 4 Teaching Assistant course is for experienced teaching assistants who are eager to advance their careers and take on more significant roles in the classroom. It's perfect for those who want to deepen their expertise, move into leadership positions, or specialize in areas like Special Educational Needs (SEN). Whether you’re currently in a teaching assistant role or looking to enhance your qualifications, this Level 4 Teaching Assistant: Level 4 Teaching Assistant course is designed to help you make a greater impact in education. Requirements Level 4 Teaching Assistant: Level 4 Teaching Assistant Online Training To enrol in this Level 4 Teaching Assistant: Level 4 Teaching Assistant Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 4 Teaching Assistant Course. Be energetic and self-motivated to complete our Level 4 Teaching Assistant Course. Basic computer Skill is required to complete our Level 4 Teaching Assistant Course. If you want to enrol in our Level 4 Teaching Assistant Course, you must be at least 15 years old. Career path Level 4 Teaching Assistant: Level 4 Teaching Assistant Online Training After completing this Level 4 Teaching Assistant: Level 4 Teaching Assistant course, you can investigate well-liked and in-demand professions in the Level 4 Teaching Assistant industry such as: Senior Teaching Assistant Higher Level Teaching Assistant (HLTA) Specialized Support Roles Education Leadership

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

Youth Work: Youth Work 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 Diploma Level 2 course will teach you how to organise youth work: youth work and youth engagement activities. The fundamentals of outdoor management and the skills and responsibilities of youth workers will be discussed. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. Learning Objectives Youth Work: Youth Work After completing this Youth Work: Youth Work Diploma Level 2 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? Unlimited access to the Youth Work Diploma Level 2 course. Instant e-certificate and hard copy dispatch by next working day. Course material developed by qualified professionals. Self-paced learning is accessible via laptop, tablet and smartphone. 24/7 Learning assistance and tutor support. No hidden fees or exam charges. Discounts on bulk purchases. >> Courses including this Youth Work: Youth Work Diploma Level 2 course Course 01: Youth Work Diploma Level 2 Course 01: Drug and Alcohol Awareness Training Course 02: Level 2 Award in Suicide Awareness [ Note: Free PDF certificate as soon as completing the Youth Work: Youth Work Diploma Level 2 Course] Youth Work: Youth Work Course Curriculum Youth Work: Youth Work Diploma Level 2 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 Certification Youth Work: Youth Work After completing the Youth Work: Youth Work Diploma Level 2 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. Assessment Method Youth Work: Youth Work After completing Youth Work: Youth Work Diploma Level 2 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. Who is this course for? Youth Work: Youth Work This Youth Work: Youth Work Diploma Level 2 is open to people of all backgrounds. Individuals in related professions can also enrol in this Youth Work: Youth Work Diploma Level 2 course to refresh or strengthen their skills. Requirements Youth Work: Youth Work To enrol in this Youth Work: Youth Work Diploma Level 2 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 Enrol in the Youth Work: Youth Work Diploma Level 2 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 2 Safeguarding Children: Safeguarding Children Course Online Unlock the Power of Level 2 Safeguarding Children Course: Enrol Now! Level 2 Safeguarding Children: Safeguarding Children Course is a topic that must be taken seriously and prioritized by anyone who has regular contact with children in any capacity. Recent research indicates that while the statistical likelihood of a child being neglected or abused is low, mistreatment is still prevalent in today's society. Level 2 Safeguarding Children: Safeguarding Children Course is a collective responsibility shared by everyone who works with or comes into contact with children regularly. Safeguarding is only effective when everyone plays their part, from teachers to educational support staff to nurses to caregivers. It is the right of every child to grow up in a safe and nurturing environment where they are protected from physical or emotional abuse. In this Level 2 Safeguarding Children: Safeguarding Children Course, you will learn the fundamentals of safeguarding, such as recognizing when a child is at risk of abuse, the national safeguarding framework, how to make a referral, and when to report your safeguarding concerns. By the end of this Level 2 Safeguarding Children: Safeguarding Children, you will have a thorough understanding of the key principles of child safeguarding and safeguarding laws and how to take appropriate action if you suspect a case of abuse or neglect. Enrol on this Level 2 Safeguarding Children: Safeguarding Children Course today and discover the essential skills and knowledge needed to keep the children in your care safe at all times. Main Course: Level 2 Safeguarding Children Free Courses included with Level 2 Safeguarding Children: Safeguarding Children Course: Course 01: Level 2 Certificate in Understanding Safeguarding and Prevent Course 02: Level 1 Certificate in Skills for Working in Child Care Industries [ Note: Free PDF certificate as soon as completing the Level 2 Safeguarding Children: Safeguarding Children Course] Level 2 Safeguarding Children: Safeguarding Children Course Online This Level 2 Safeguarding Children: Safeguarding Children Course consists of 06 modules. Course Curriculum of Level 2 Safeguarding Children: Safeguarding Children Course Module 01: Basic Knowledge of Children Safeguarding Module 02: Children and The Law Module 03: Legislation and Policies That Surround Safeguarding Children Module 04: Child Abuse & Its Types Module 05: Responding to Disclosure Module 06: The Role of Health and Other Professionals Assessment Method of Level 2 Safeguarding Children: Safeguarding Children Course After completing Level 2 Safeguarding Children: Safeguarding Children 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 Level 2 Safeguarding Children: Safeguarding Children Course After completing the Level 2 Safeguarding Children: Safeguarding Children 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 2 Safeguarding Children: Safeguarding Children Course Online This Level 2 Safeguarding Children: Safeguarding Children Course is ideal for those who work with children or are responsible for caring for children, such as: Teachers Child Care Worker Health Care Professional Support Workers Paediatric Nurses Childminders Playworkers Anyone in a profession where children are under their supervision Special Note: Level 2 Safeguarding Children: Safeguarding Children Course is knowledge Based course. Requirements Level 2 Safeguarding Children: Safeguarding Children To enrol in this Level 2 Safeguarding Children Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 2 Safeguarding Children: Safeguarding Children Course. Be energetic and self-motivated to complete our Level 2 Safeguarding Children: Safeguarding Children Course. Basic computer Skill is required to complete our Level 2 Safeguarding Children: Safeguarding Children Course. If you want to enrol in our Level 2 Safeguarding Children: Safeguarding Children Course, you must be at least 15 years old. Career path Level 2 Safeguarding Children: Safeguarding Children Course Online Opportunities in this Level 2 Safeguarding Children: Safeguarding Children Course field include: Teaching Social Work Childminding/Nannying Paediatric Nursing Support Work

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

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

Dog Training: Dog Training Course Online Do you wish to assist your pet with wellness, medical, and grooming tasks? The Dog Training: Dog Training Course is intended to provide applicants with the skills and information needed to work with dogs. This Dog Training: Dog Training Course covers everything you need to know about this topic and making a career out of it. Through this exclusive Dog Training: Dog Training Course, learners will be able to understand how to care for a dog. Also, this Dog Training: Dog Training Course describes canine first aid. Through the Entry Level Award in Dog Training and Husbandry (Entry 3) course, you will understand the perfect sports for dogs. Our Dog Training Course will teach you how to do these things, what the differences are, and how to do them well in simple and practical ways. Enrol now in our Entry Level Award in Dog Training and Husbandry (Entry 3) course to achieve your goals and get the expertise, know-how, and experience needed to further your career. Main Course: Entry Level Award in Dog Training and Husbandry (Entry 3) Course Free Courses are including with this Dog Training: Dog Training Course Along with The Dog Training Course, We Offer a free Dog First Aid Course Along with The Dog Training Course, We Offer a free Level 5 Animal Care Course Special Offers of this Dog Training: Dog Training Course This Dog Training Course includes a FREE PDF Certificate. Lifetime access to this Dog Training Course Instant access to this Dog Training Course Get FREE Tutor Support to this Dog Training Course Dog Training: Dog Training Course Online The foundational information of dog training and husbandry is covered in this course before sharing advanced expertise. With the help of this Dog Training: Dog Training Course, you will gain a thorough understanding of Dog Training and Husbandry, along with practical application tactics and in-depth expertise. The Dog Training course is offered entirely online. You can access this Dog Training: Dog Training Course from anywhere in the globe as long as you have access to the internet and a smart device. Who is this course for? Dog Training: Dog Training Course Online This Dog Training: Dog Training Course is suitable for anyone working in animal care or who wants to learn more about dog training and husbandry. Requirements Dog Training: Dog Training Course Online To enrol in this Dog Training: Dog Training Course, students must fulfil the following requirements. To join in our Dog Training: Dog Training Course you must have a strong command of the English language. To successfully complete our Dog Training: Dog Training Course, you must be vivacious and self driven. To complete our Dog Training: Dog Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Dog Training: Dog Training Course. Career path Dog Training: Dog Training Course Online After completing this Entry Level Award in Dog Training and Husbandry (Entry 3) course, you may able to pursue a variety of promising career opportunities, such as dog trainer, dog sitter or dog behaviourist counsellor.

Criminal Psychology: Criminal Psychology Are you fascinated to become a Criminal Intelligence Analyst? We've created a course on Criminal Psychology to provide you the know-how, abilities, and methods you'll need to succeed in this fascinating area. We ensure that you obtain a comprehensive understanding of the Criminal Psychology examination process by covering a wide range of topics in our Criminal Psychology course. The fundamentals of criminal intelligence are covered in this Criminal Psychology course to examine the intelligence process. Samples of a National Intelligence Model from the United Kingdom are used in the Criminal Psychology course to help clarify the concepts. This Criminal Psychology course will teach you how to evaluate data sources, criminal psychology, and decision-making. You will be an expert on the English and Welsh criminal justice systems after completing this course on Criminal Psychology. Don't miss the chance to become a criminal intelligence analyst. Join up for our Criminal Psychology course right away to open the doors to a world of crime-solving opportunities. Learning outcome of Criminal Psychology You will learn how to process criminal intelligence as a professional criminal intelligence analyst Criminal Psychology will teach learners about Evaluation of Source and Data, Analysis and Analytical Process You will be knowledgeable about Intelligence-Led Policing, Decision Making in Criminal Psychology Criminal Psychology course will equip your understanding about Criminal Psychology, Criminal Justice System in England and Wales Main Course: Criminal Intelligence Analyst (Criminal Psychology) Free Course is including with this Criminal Psychology: Criminal Psychology Course. Along with The Criminal Psychology: Criminal Psychology Course, We Offer a free Criminoly & Profiling Course Special Offers of this Criminal Psychology: Criminal Psychology Course This Criminal Psychology: Criminal Psychology Course includes a FREE PDF Certificate. Lifetime access to this Criminal Psychology: Criminal Psychology Course Instant access to this Criminal Psychology: Criminal Psychology Course Get FREE Tutor Support to this Criminal Psychology: Criminal Psychology Course Criminal Psychology: Criminal Psychology You will learn about the many facets of criminal science with this course on criminology and psychology. You will study criminal psychology and crime scenes in order to deal with crimes. The phases of profiling and forensic science will also be covered. You will learn about victimology, offender and criminal profiling in this course on psychology and criminology. The criminal justice systems in Wales and England will also be covered. Who is this course for? Criminal Psychology: Criminal Psychology Everyone would benefit from taking this Criminal Psychology: Criminal Psychology course. Requirements Criminal Psychology: Criminal Psychology To enrol in this Criminal Psychology: Criminal Psychology Course, students must fulfil the following requirements. To join in our Criminal Psychology: Criminal Psychology Course, you must have a strong command of the English language. To successfully complete our Criminal Psychology: Criminal Psychology Course, you must be vivacious and self driven. To complete our Criminal Psychology: Criminal Psychology Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Criminal Psychology: Criminal Psychology Course. Career path Criminal Psychology: Criminal Psychology A certificate as a criminal intelligence analyst will add value to your resume and broaden your career options.

Customer Service: Customer Service Course Online Are you looking to enrich your telephone etiquette skills? Join our Customer Service: Customer Service Course to master the art of useful contact over the phone. This Customer Service Course teaches all the aspects of phone etiquette and using proper phone language. The Customer Service: Customer Service Course describes how to eliminate phone distractions. Inbound and outbound calls are part of this Customer Service Course. Through the Customer Service Course, handling rude or angry callers. Moreover, Customer Service Course describes handling interoffice calls and voicemail messages. This Customer Service Course is helpful for correcting poor telephone etiquette and wrapping up. Enrol this Customer Service: Customer Service Course to empower your skills and expertise! Learning Outcomes of Customer Service: Customer Service Course After completing this Customer Service: Customer Service Course, you will be able to: Understand various aspects of phone etiquette via Customer Service Course. This Customer Service Course describes how to use proper phone language. Customer Service Course explains how to handle inbound and outbound calls. You can learn how to eliminate phone distractions through the Customer Service Course. Know how to handle rude or angry callers and much more with the help of this Customer Service Course. Main Course: Telephone-Etiquette Course Free Courses are including with this Customer Service: Customer Service Course Customer Service Course, We Offer a free Close Protection Course Special Offers of this Customer Service: Customer Service Course This Customer Service Course includes a FREE PDF Certificate. Lifetime access to this Customer Service Course Instant access to this Customer Service Course Get FREE Tutor Support to this Customer Service Course Customer Service: Customer Service Course Online Giving students a solid understanding of the foundations of first-rate customer service is the aim of the Customer Service: Customer Service course. This customer service course provides guidance on how to resolve complaints, win back customers, and deal with challenging circumstances. By enrolling in this Customer Service: Customer Service course, you will also learn how to control your stress when dealing with difficult clients. After completing the Customer Service: Customer Service course, you'll know more about how to effectively communicate with clients and comprehend their needs. Who is this course for? Customer Service: Customer Service Course Online This Customer Service: Customer Service Course is perfect for students, business experts or stay-at-home parents. Requirements Customer Service: Customer Service Course Online To enrol in this Customer Service: Customer Service Course, students must fulfil the following requirements. To join in our Customer Service: Customer Service Course, you must have a strong command of the English language. To successfully complete our Customer Service: Customer Service Course, you must be vivacious and self driven. To complete our Customer Service: Customer Service Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Customer Service: Customer Service Course. Career path Customer Service: Customer Service Course Online After completing this Customer Service: Customer Service Course, you may be able to pursue a variety of promising career opportunities related to this Telephone-Etiquette field.