5721 Courses

The Health and Wellbeing establishes a solid foundation for encouraging movement, improving nutrition, and increasing human function. You will gain an understanding of how physical activity and nutrition actually impact how we feel. Do you want to learn more about the science that characterizes our health? Would you like to work in wellness or healthcare? Then this Certificate in Wellbeing curriculum is for you. This Diploma course provides a solid foundation in well-being in health principles. This Certificate in Wellbeing program will teach you about health and social issues such as addiction, mood disorders, and nutrition. This course is a comprehensive guide that will prepare you to help others as a Social Worker, Counsellor, or Mental Health Worker. Furthermore, the skills and knowledge you will gain by taking this Certificate in Wellbeing course will help you move one step closer to your professional goals and develop your skills for a successful career. The Certificate in Wellbeing course emphasizes how to improve your competency as a person in your chosen field while also outlining important career insights in the relevant job sector throughout. This Certificate in Wellbeing course is a one-of-a-kind educational opportunity that will prepare you to work as a competent social worker or health worker. You could be a lifeline for people who struggle with health disorders and have a significant impact on their quality of life. The skills you learn here could lead to a lifelong career in which you can help those in need while also feeling proud of your accomplishments. The Certificate in Wellbeing course covers all of the most recent topics to keep you up to date with all the necessary information. This excellent course covers basic to advanced relevant topics, allowing you to improve your skills. You will be more productive at this work after completing this course. You will also receive easy-to-digest modules and learning materials in this masterfully designed course, allowing you to stand out in your future career. Furthermore, the relevant skills you will gain after completing this Health and Wellbeing course will add value to your resume. Learning Outcomes After completing this Certificate in Wellbeing course, the learner will be able to: Understand Stress and Stress Management. Gain a thorough understanding of Mental Health. Understand substance misuse. Understand the importance of healthy eating and drinking for adults. Gain in-depth knowledge about Dementia. Why Choose Certificate in Wellbeing Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Well-being 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 Certificate in Wellbeing Course MAIN COURSE: Diploma in Health and Wellbeing *** Additional Courses *** Safeguarding Vulnerable Adults Training Level 2 Certificate in Awareness of Mental Health Problems ***Other Benefits of Include in this Certificate in Well-being Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Certificate in Wellbeing course] This comprehensive and accurate Certificate in Wellbeing course is a great way to start your career as a social worker. You will gain a practical and theoretical understanding of this course, which will boost your employability in this field, help you stand out from the crowd, and boost your potential in no time. So, once you've finished this Certificate in Wellbeing course, you'll have the practical knowledge and skills to pursue a variety of career opportunities in the field. This Health and Wellbeing course can help you improve your reputation. You can tell the difference from the first lesson. This complete course includes all of the teachings that you can easily understand and apply to your abilities. Individuals attempting to make a career in this field will benefit from this course's understanding of the fundamentals and comprehensive education. Whether you are new to this field or want to improve your skills and have a successful career, our course can help you get there. This course covers all relevant topics. We are committed to providing you with the best educational experience possible as one of the leading course providers and most renowned e-learning specialists online. This Certificate in Wellbeing course was created in collaboration with experts and mentors to help you learn quickly and efficiently, at your own pace and ease. Enrol in our Certificate in Wellbeing course today to pursue your dreams and gain the experience, skills, and knowledge required to advance your professional development. Our Certificate in Wellbeing course will help you with the qualities you need to work towards your dream job. Course Curriculum of- *** Certificate in Wellbeing *** [ COURSE 01] >> Certificate in Well-being ** Curriculum Module 1: Introduction to Stress and Stress Management Understand what is meant by stress Know the effects of stress Understand possible causes of stress Understand how to recognise stress Know ways to prevent and reduce the effects of stress Module 2: Develop an Awareness of Mental Health Be aware of what is meant by mental health Be aware of some of the social and personal effects of mental ill-health Be aware of some of the responses to mental health issues Be aware of cultural diversity in relation to mental health issues Module 3: Develop an Awareness of Substance Misuse Know what substances are commonly misused and why Recognise possible signs of substance misuse Be aware of the social and personal effects of substance misuse Be aware of perceptions of and responses to substance misuse Module 4: Introductory Awareness of the Importance of Healthy Eating and Drinking for Adults Understand the importance of healthy eating Understand the importance of drinking enough to stay healthy Module 5: Dementia Awareness Know the most common types of dementia Know the signs and symptoms of common types of dementia Know about good practice in caring for an individual with dementia [ COURSE 02] >> Safeguarding Vulnerable Adults Training Curriculum Module 1: Basic Knowledge of Safeguarding Vulnerable Adults What is Adult Safeguarding? Who is a Vulnerable Adult? Who is Responsible for Safeguarding? Aims of Adult Safeguarding How to Safeguard a Vulnerable Adult Why is it Important to Protect Vulnerable Adults? What are the Safeguarding Vulnerable Adults Legislations? The Care Act 2014 & Mental Capacity Act Module 2: Vulnerability What Do You Understand by Vulnerable Adult People? Recognizing Vulnerable Adult at Risk Who is in Danger of Being Abused or Neglected? Module 3: Abuse of Vulnerable Adult What is Adult Abuse? Types & Symptoms of Adult Abuse Recognizing the Potential Abuser What Can You Do If You Recognize Abuse? An Overview of Human Trafficking Module 4: Responding To Concerns in Adult Safeguarding Raising a Safeguarding Concern Consent and Empowerment of the Adult When Raising a Safeguarding Concern Responding to Abuse and Neglect Professionals Concerns Module 5: Whistleblowing on Safeguarding Adult What is Whistleblowing in Adult Safeguarding? Why is Whistleblowing Important in Healthcare? The Whistleblowing Procedure for Safeguarding Adults Who Can You Blow the Whistle to in Healthcare? Are Whistleblowers Legally Protected? Module 6: Reporting & Procedure After Reporting Process for Reporting Safeguarding Concerns Recording & Reporting Safeguarding Issues Procedure After Reporting [ COURSE 03 ] >>Level 2 Certificate in Awareness of Mental Health Problems Curriculum 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 Module 9: Understanding Dementia Module 10: Understanding Eating Disorders Module 11: Understanding Attention Deficit Hyperactivity Disorder Module 12: Understanding Obsessive-Compulsive Disorder - OCD Module 13: Understanding Post-Traumatic Stress Disorder - PTSD Assessment Method After completing each module of the Certificate in Wellbeing, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Certificate in Wellbeing course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. 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 Certificate in Wellbeing course is ideal for individuals who want to learn more about their own and others' well-being. Certificate in Well-being course provides learners with flexible modules to suit their circumstances and interests. Requirements There are no specific requirements for this Certificate in Wellbeing course because it does not require any advanced knowledge or skills. Career path This Certificate in Wellbeing course will improve your CV and employability. After completing this course, you will have a competitive advantage when entering the relevant job field: Social Care Worker Recovery Worker Community Wellbeing Officer Counsellor Mental Health Care Worker Certificates Certificate of completion Digital certificate - Included

Level 3 Award in Education and Training - AET/PTLLS Course **WINTER SALE OFFER----WINTER SALE OFFER** Latest Updated (21 February 2024) Live Zoom Microteaching Session with Tutor Are you bored of searching the internet for a AET/PTLLS - Level 3 Award in Education and Training - AET course? Can't manage to discover a proper course that meets all of your requirements? Don't worry, you've just discovered the solution. Take a moment to browse through this comprehensive course that includes everything you need to succeed. The AET/PTLLS - Level 3 Award in Education and Training - AET Course is intended for individuals who want to work in education, most likely as early age instructors and trainers in a variety of contexts. This is the first step in becoming an entry-level teacher in the United Kingdom. Furthermore, the AET/PTLLS - Level 3 Award in Education and Training - AET Course is accredited by TQUK, one of the leading awarding organisations in the UK! AET/PTLLS - Level 3 Award in Education and Training - AET Course is the mandatory minimum qualification if you want to be a teacher or trainer in your chosen field in the UK. If you are thinking about getting into teaching, this AET/PTLLS - Level 3 Award in Education and Training - AET Course, is a great way to start. As a teacher, you can play a significant role in society and positively impact your students' lives. Currently, there is a huge demand for teaching jobs across the globe, and you know how satisfying it could be! So, if you aspire to be a changemaker, this is the ultimate course we can offer you. This AET/PTLLS - Level 3 Award in Education and Training - AET course is designed so that both freshers and those working in an educational setting can get the benefit. Further, through this course, the current teachers can achieve formal recognition of their skills. Awarding Body The AET/PTLLS - Level 3 Award in Education and Training - AET Course is accredited by TQUK. A certificate from this renowned awarding body will bring you out as a highly marketable candidate within the desired industry. There is Something More for You with This AET/PTLLS - Level 3 Award in Education and Training - AET Course. Although we understand, many of you only come to search for PTLLS or AET courses but still here is a small gift for learners. As a course provider, we highly value our learners' needs. That is why we are giving you some relevant courses with AET/PTLLS - Level 3 Award in Education and Training - AET Course. Because these extra teaching and training courses will benefit you. With these courses, you can further enrich your knowledge and employability skills. Here are those - Learning Outcomes of the AET/PTLLS - Level 3 Award in Education and Training - AET Course By the end of this course, you will be able to: AET/PTLLS: Identify and perform the roles of a teacher. AET/PTLLS: Explain and apply the teaching and learning approaches. AET/PTLLS: Plan a training session for your learners of different backgrounds. AET/PTLLS: Describe the teachers' attributes and expectations. AET/PTLLS: Prepare inclusive lessons and training sessions for your students. AET/PTLLS: Analyse the role, responsibilities and relationships in education and training. AET/PTLLS: Prepare and administer necessary assessments for your students. This PTLLS - Level 3 Award in Education and Training - AET Course will be the perfect choice for any individual to kickstart a new career. Anyone who wants to pursue a career in education will find it gratifying and enjoyable. It is a good occupation since you will not only satisfy your own growth. Also it will assist many learners in achieving theirs. It is also a high-demand business, with many schools and universities looking for qualified instructors. It is a job in which you will not only teach but also learn. The PTLLS - Level 3 Award in Education and Training - AET Course is a nationally recognised award for anybody who is presently teaching or training. Moreover, it will help those who desire to enter the field and get the necessary qualifications to work as a teacher or trainer. Special Note: Please be informed that apart from the initial fee, you have to pay GBP 169 when submitting assignments. Level 3 Award in Education and Training - AET/PTLLS Course The AET/PTLLS - Level 3 Award in Education and Training - AET course fulfils - AET/PTLLS: Industry requirements and will help you get a full grasp of a teacher and trainer's duties and responsibilities, AET/PTLLS: The boundaries imposed with regard to teaching, and how to present motivating class sessions to encourage students. By learning this AET/PTLLS - Level 3 Award in Education and Training - AET course you will learn about the role, responsibilities, and duties of a teacher. Besides, you will be able to identify the significance of your existence in your students' lives. Also, You will know how you can bring effective change to them with your influence through this AET/PTLLS - Level 3 Award in Education and Training - AET Course. Further, inclusive teaching and learning is a very important concept in an educational setting. That is why we have included this AET/PTLLS - Level 3 Award in Education and Training - AET Course in our course so that you can learn. Besides, you will get an in-depth idea about how to perform an assessment. Course Curriculum *** AET/PTLLS - Level 3 Award in Education and Training - AET Course *** Module 01: Understanding Roles, Responsibilities and Relationships in Education and Training Understand the Teaching Role and Responsibilities in Education and Training Understand Ways to Maintain a Safe and Supportive Learning Environment Understand the Relationships between Teachers and Other Professionals in Education and Training Module 02: Understanding and Using Inclusive Teaching and Learning Approaches in Education and Training Understand Inclusive Teaching and Learning Approaches in Education and Training Understand Ways to Create an Inclusive Teaching and Learning Environment Be Able to Plan Inclusive Teaching and Learning Be Able to Deliver Inclusive Teaching and Learning Be Able to Evaluate the Delivery of Inclusive Teaching and Learning Module 03: Understanding Assessment Understand Types and Methods of Assessment Used in Education and Training Understand How to Involve Learners and Others in the Assessment Process Understand the Role and Use of Constructive Feedback in the Assessment Process Understand Requirements for Keeping Records of Assessment in Education and Training ---------------------- AET/PTLLS - Level 3 Award in Education and Training - AET Course Qualification at a Glance Total Qualification Time (TQT) - 120 Hours Guided Learning Hours (GLH) - 48 Hours Credit Value - 12 Minimum Age - 19 Purpose of the AET/PTLLS - Level 3 Award in Education and Training - AET Course Qualification This AET/PTLLS - Level 3 Award in Education and Training - AET Course qualification is designed to prepare learners for employment and support them to progress to a teaching role within the workplace. It has been developed for those intending to work in the post-16 education and training sector. What Skills You Will Gain from this AET/PTLLS - Level 3 Award in Education and Training - AET Course You will gain the following marketable qualities through the Level 3 Award in Education and Training course. Different hiring managers are looking for these below-mentioned qualities. AET/PTLLS: Become an expert in education and training. AET/PTLLS: Learn about the teacher's role. AET/PTLLS: Master the learning and teaching approaches. AET/PTLLS: Increase your session planning skills. AET/PTLLS: Gain knowledge in teacher expectations & attributions. AET/PTLLS: Understand how to deliver inclusive sessions which engage and motivate learners. AET/PTLLS: Explain roles, responsibilities, and relationships in education and training. AET/PTLLS: Identify how to create assessments in education and training. AET/PTLLS - Level 3 Award in Education and Training - AET Course Assessment Method In order to be eligible for the certification, you need to complete the following assessments. Three written assignments One microteaching session - 60 Minutes (Which can be submitted as a recorded video) Please note that you will be given precise instruction in the course material about writing the assignments and performing the micro-teach session. Moreover, if you face any difficulty, your tutor will be there to support you. You must submit all assignments via the online portal with full tutor support. Certification As soon as you submit your assignments and micro-teaching video, your tutor will assess those. Based on the assessor's evaluation, you will be graded either achieved/not achieved yet. If you are in the achieved category, you will receive an accredited certificate from the renowned awarding body TQUK. Who is this course for? Level 3 Award in Education and Training - AET/PTLLS Course Wherever you work, this AET/PTLLS - Level 3 Award in Education and Training - AET course is a must for you if you want to become a trainer. Besides, this course is also appropriate for the following. Teacher & Trainer Consultant Job Hunters & School Leavers College or University Students & Graduates Tutors & Instructors Headmasters Education Consultants Education Providers Office Clerk & Administration Assistant Educational Psychologist Lecturer or Classroom Assistant Progression If you achieve this AET/PTLLS - Level 3 Award in Education and Training - AET Course qualification, you could progress to: AET/PTLLS: Level 3 Award in Assessing Vocationally Related Achievement AET/PTLLS: Level 3 Certificate in Assessing Vocational Achievement AET/PTLLS: Level 3 Award in Assessing Competence in the Work Environment AET/PTLLS: Level 4 Certificate in Education and Training AET/PTLLS: Level 4 Certificate for the Advanced Practitioner in Schools and Colleges AET/PTLLS: Level 4 Award for Technology Enabled Educators AET/PTLLS: Level 5 Diploma in Education and Training Requirements AET/PTLLS Course There are no fixed entry requirements for attending the AET/PTLLS - Level 3 Award in Education and Training - AET Course. However, you must be 19 years old or over upon certification. An interest in teaching adults and E-learning will be beneficial. Moreover, you must have basic ICT and time management skills. It will help you complete online written assignments. Since this is a Level 3 course, you must be ready to read through various texts, cross-reference, research theories or principles or practises of effective teaching. Finally, you need to demonstrate practical teaching skills via assessment work. Career path Level 3 Award in Education and Training - AET/PTLLS Course You can choose from a variety of professions either in teaching or training upon completion of the AET/PTLLS - Level 3 Award in Education and Training - AETcourse. These include - Primary School Teacher Secondary School Teacher Further Education Teacher Private Tutor Freelance Trainer Trainer at Your Workplace

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want In this BSL level 1 and 2 course, you will learn to communicate effectively with the deaf community as you progress from basic signing to more complex conversations and expressions. With this course, you will better understand sign language, bridging the gap between hearing and non-hearing individuals This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Grow your productive and receptive skills and understand topics such as everyday conversations, time and months of the year, numbers, travel and holidays, eating and drinking, shopping etc. Learn to spell out names and sign the British Sign Language alphabet Get acquainted with the grammatical structure and features of British Sign Language Ability to communicate using the correct hand, body, and head movements Build your BSL vocabulary on topics such as food, family, animals, colors, clothes and weather Learn the skills and knowledge to take part in the simple conversation in BSL Ability to sign essential home and leisure-related topics along with day-to-day aspects such as opinions, time, directions, and transport. Why British Sign Language (BSL) Level 1 & 2 Course right for you? British Sign Language helps disabled people who can't hear or speak to communicate in sign language through gestures, facial expression, and body language or anyone who want to improve their British sign language skills. This comprehensive online BSL course will help you understand Fingerspelling, exchanging personal information, signing families, numbers, colours, and much more. With the British sign language level 1 and 2 course, you will learn how to describe a person and clothes in sign language. By the end of this BSL level 1 and 2 online course, you will gain essential sign language skills and knowledge in signing almost all the necessary terminologies and words used in your daily life. You can also contact us for more information British Sign Language (BSL) Level 1 & 2 Course Details Accredited by International Practitioners of Holistic Medicine (IPHM) is a leading accredited organisation that certifies and regulates alternative therapists, healers, and training providers around the world. After completing the IPHM accredited course you will be eligible to apply for the insurance.   CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   Course Curriculum British Sign Language Introduction Introduction to BSL and Fingerspelling Fingerspelling A - Z A-z Fingerspelling Without Subtitles Fingerspelling -1st Name a to Z Fingerspelling Fill in the Blanks Fingerspelling - What is My Name and Where Do I Live Exchanging Personal Information Meeting People and Introductions Meeting People and Introduction Without Subtitles Questions Sign Families Families Signs Part 1 With Subtitles Families Signs Part 2 With Subtitles Family: Families Signs Families Signs Part 2 Without Subtitles Family Sentences: Exercise Who is My Family Family Sentences Homewore Numbers (Time, Calendar and Money) You will gain comprehension in numbers signs (0-100), numbers: exercises, bingo number games, time and calendar signs, calendars, and more. This module will also teach you: What is the Time With Subtitles What is the Time Without Subtitles Calendar Without Subtitles Calendar When is My Birthday Colours Colours Signs Colours Without Subtitles End of Course Exam Colours Games Colour: Draw a Colour Elephant Draw a Colour Elephant Transports Transports Sign With Subtitles Transports Signs Without Subtitles Vocabulary: Transport and Time Transport and Time Signs Without Subtitles Vocabulary: Transport Transport: Exercise Transports and Fingerspellling – Fill in the Gaps Answer Transports and Fingerspellling Fill in the Gap Weather Weather: Signs Weather Without Subtitles Weather: Questions What is the Weather and Time Answer What is the Weather and Times Answers Directions You’ll learn directions signs, directions signs without subtitles, directions: questions, questions for directions without subtitles, vocabulary: positives and negatives, how I should get their directions and more. You’ll also learn answers to how I should get their directions, non-manual features (Nmf) with subtitles, and more. This module will further teach you: Emotional Signs With Subtitles Emotional Signs Without Subtitles Emotional Stories Affirmative & Negative Affirmative & Negative Without Subtitles Activities/hobbies and Sports You will learn how to explain interests and bobbies with and with subtitles, hobbies, interests and activities, hobbies and interests: questions, sports signs, and more. Furthermore, you’ll further gain insights into: Sports Without Subtitles Hobbies_interests Questions Without Subtitles Hobbies Interests Questions With Subtitles Sports Club: Exercise Don’t Like or Like in Sports_hobbies_interests Description of a Person and Clothes Description of a Person Without Subtitles Describing Clothes Without Subtitles People and Clothes: Description of a Person People and Clothes: Describing Clothes Describing a Person and What They Are Wearing Animals Animals Signs A-z Animals Without Subtitles Animals: Questions About Pets Questions About Pets Without Subtitles Numbers (Money) Money: Number Signs Money Part 1 Without Subtitles Money: Signs Money Signs Part 2 Without Subtitles Foods and Drinks Foods & Drinks Foods & Drinks Without Subtitles Food and Drink: Menu Hurley’s Food and Drink Menu Without Images At the Restaurant Exam Level 1 Exam – Please take an exam at the beginner level. BSL Level 1 Exam Answers British Sign Language (BSL) at QLS Level 2 Handout Study Questions Forms From English to BSL Quiz Video Questions Forms Into Bsl Quiz Video Answers Questions Forms Into Bsl Video Questions Tags (Negation & Affirmation) With Subtitles Video Questions Tags (Negation & Affirmation) Without Subtitles Finger Spelling You’ll study handout fingerspelling – games 1 and 2: boggle, fingerspelling receptive skills on TV programmes, fingerspelling receptive skills on films, and fingerspelling receptive skills on films and TV programmes. You’ll also be provided with handouts for handshapes to show light, legs, eyes, people and ball, directional verbs with and without subtitles, multi-channel signs with and without subtitles, itemising/listings signs with 4 stories, and more. This module will also teach you: Video Opposites Signs With Subtitles Video Opposites Signs Without Subtitles Handouts : Opposites Signs Quiz Handouts First Letter of Your Name Homework. Quiz Video First Letter of Your Name and Surname With Bsl Guest Handout Answer: First Letter of Your Name and Surname With Bsl Guest Jobs Handout Asking Questions About the Jobs. Video: Asking Questions About the Job With Subtitles Video: Asking Questions About the Job Without Subtitles Video: Job Signs With Images Video: Job Signs Without Images Quiz Video: What is My Job? Jobs: Workplace Vocabulary Quiz Handout Answers: What is My Job. Buildings Video: Type of Buildings With Subtitles Video: Type of Buildings Without Subtitles Handouts: Type of Houses 1. Handouts: Type of Houses 2. Rooms in the House You’ll learn at-home signs, at-home (Rooms), what is in Each Room, how to describe each room with images of home signs, and more. Therefore, you’ll further learn: Video: at Home (Rooms) With Subtitles Video: at Home (Rooms) Without Subtitles Video: at Home – What is in Each Room With Subtitles Video: at Home – What is in Each Room Without Subtitles Quiz Video: How to Describe Each Room With Images Daily Routines You’ll understand how to explain day-to-day routines with and without images, daily routines, and more. This module will also provide you with: Handout: Daily Chores 1 Handout: Daily Chores 2 Quiz Video: My Day-to-day Routines Quiz Answer: My Day to Day Routines Travelling and Holidays You’ll learn BSL signs for countries and cities, countries signs, cities in the UK and Europe, and types of holidays with and without subtitles. Moreover, you’ll further gain comprehension of types of holidays, how to explain what you did on holiday, what you need to bring on holiday, and more. Furthermore, this module will provide you with: Handouts: What Do You Need to Bring on Holiday Video: at the Beach With Subtitles Video: at the Beach Without Subtitles Handouts: at the Beach Video: Holiday Questions With Subtitles Handouts: Holiday Questions Health and Medical Terminology You’ll understand health and medical terminology, treatments and how to ask questions with and without subtitles. Therefore, you will also learn: Handouts: Health and Medical Terminology Video Study: at the Doctors With Bsl Guest Video Quiz: Multi-choices Questions “at the Doctors With Bsl Guest ” Video Quiz Answers: Multi-choices Answers “at the Doctors With Bsl Guest” Technology Video Technology Terminology With Subtitles Video Technology Terminology Without Subtitles Handout Technology Terminology Educational Signs Video: Educational Signs With Subtitles Video: Educational Signs Without Subtitles Video: Deaf Education With Subtitles Video: Deaf Education Without Subtitles Handouts: Educational and Deaf Education Course Assessment Who should take this course? The British sign language course is designed for people who want to interact with the deaf and dumb community and anyone who is keen to work in social services for the hearing impaired. This course is suitable for those who aspire to become British Sign Language interpreter or translator. Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This British sign language course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs What is a BSL? BSL Stands for British Sign Language and is used to communicate with deaf people or people with hearing problems. It is a popular language worldwide and in the UK, especially as BSL was recognized as an official language by the UK in 2003. So you must acquire this skill and learn it at Lead academy at a budget-friendly price. How long does it take to learn BSL? Learning British Sign Language (BSL) from Level 1 to Level 6 is a unique journey that varies from person to person. On average, it can take between 60-100 hours of study to complete each level of BSL. Achieving all six levels would require 360 to 600 hours of learning. The duration can be flexible, spanning several years through part-time education, or it could be completed in a shorter period through an intensive program. What is the difference between BSL 1 and BSL 2? In BSL Level 1, you can learn to communicate with deaf people on various topics requiring simple everyday language. BSL Level 2 will enable you to develop functional BSL communication on a deeper level. What Kind of job can I do after learning the BSL levels? After completing the online BSL course with the lead academy, you can select many professions like a teacher of the Deaf, interpreter, Speech And Language Therapist, and more. What is the average income of a BSL interpreter? The interpreters' earnings vary based on their experience, geography, and cultural background. However, the statistics claim that a BSL interpreter earns between £20,000 and £35,000 a year. How will I purchase this course? First, select your desired course plan among the multiple existing course plans on the right side of your screen, then select the payment type, and once you made the payment, you can access the course any time you want. I made my payment. How will I get access to the BSL course? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. I am from outside the UK. Will I get access to the Course? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. When will I get the certificate? For a CPD-accredited PDF certificate, it will take 24 hours, however, for the hardcopy CPD certificate takes 5-7 business days, and for the Quality License Scheme certificate, it will take 7-9 business days. After Completing the Online BLS course Level 1 & 2, which course Should I enroll in to increase my learning? You can get into the Signature BSL Level 1 Award course as it is advanced. You will get a certificate that is accredited by the government body of the deaf community, which is known as a Signature. Additionally, you will attend an official exam as well.

Start on a transformative journey with our Dog Training course. Unleash your pet's potential through expert guidance. Join now!

Dive into the fascinating world of crime analysis with our CPD Accredited Course designed to sharpen your understanding of crime patterns, trends, and data interpretation. This course unpacks the core principles of analysing criminal activity through a methodical and evidence-based approach. It’s ideal for professionals eager to elevate their knowledge and apply analytical thinking to enhance public safety strategies. With a focus on data handling, statistical methods, and crime mapping, you’ll discover how to interpret complex information to support investigative processes and policy-making. Delivered entirely online, this course respects your schedule and location while ensuring you receive up-to-date, engaging content. You’ll explore a range of analytical techniques used by experts in the field, all explained clearly and with a touch of wit to keep the material lively. Whether you work in law enforcement, security, or research, this course will enrich your expertise, helping you make sense of the numbers behind the headlines. Ready to delve deeper into crime analysis? This is your chance to boost your professional credentials without stepping outside your door. Learning Outcomes: It's your chance to start with ourCriminology course and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Crime Analysis - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Crime Analyst profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Crime Analysis Module 02: The Criminal Justice System in England and Wales Module 03: Classification of Crime Module 04: Crime Scene Module 05: Crime Mapping Module 06: Tactical Crime Analysis Module 07: Strategic and Administrative Crime Analysis Module 08: Criminal Behaviour and Psychology Module 09: Financial and Environmental Criminology Module 10: Criminal Justice Module 11: Criminal Profiling: Science, Logic and Metacognition Module 12: Phases of Profiling Module 13: Criminal Intelligence Analysis Module 14: Technology in Criminal Intelligence Analysis Module 15: Research Method and Statistics in Crime Analysis Module 16: Policing and Cyber Security Module 17: Forecasting Future Occurrences and Prediction Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Crime Analysis - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Crime Analysis - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Crime Analysis - CPD Accredited 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 Crime Analysis - CPD Accredited training.

The Diploma in Security Guard at QLS Level 4 with Complete Career Guide Course provides a solid foundation for individuals aiming to progress in the security industry. Designed for those wishing to take on more responsibility, this course offers in-depth knowledge that prepares students for a variety of roles within the sector. The course is suitable for those looking to enhance their professional security career, whether they are new to the industry or seeking to formalise their knowledge. It focuses on the essential aspects of security roles, helping students understand the responsibilities and techniques that are key to succeeding in this field. Throughout the course, learners will gain a well-rounded understanding of security management, covering areas such as risk assessment, monitoring, and dealing with security threats. The structure of the course ensures that learners can absorb theoretical knowledge effectively while gaining insight into the wider security landscape. With a blend of theory and a comprehensive career guide, this programme empowers individuals to confidently advance in their security guard career. Take the next step in your career path by joining this course, designed to elevate your knowledge and support your professional journey. Good luck! Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Baker profession Free Assessment to test learners' knowledge and skills Accredited learning and widely certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Basic Concepts of Baking Module 02: Basic Ingredients of Baking Module 03: Glossary and Equipment Used in Baking Module 04: Types of Cakes Module 06: Baking Principles Module 06: Baking Principles Module 07: Cake Decorating Recipes Module 08: Cake Decorating Ideas Module 09: Frosting and Icing Module 10: Working with Different Pastes Module 11: Working with Glazes Module 12: How to Stack a Cake Module 13: Piping and Writing Module 14: Health, Safety and Food Hygiene Module 15: Troubleshooting Module 16: Cake Decorating Business Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Baking & Cake Decorating Online Course - CPD Accredited course. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Baking & Cake Decorating Online Course - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Baking & Cake Decorating Online Course - CPD Accredited training. Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Baking & Cake Decorating Online Course - CPD Accredited training.

The Statistics Analyst - CPD Accredited Course provides a dynamic and in-depth understanding of statistical analysis, designed for those seeking to develop their analytical abilities in various industries. Through this course, participants will gain a solid grounding in statistical methods, techniques, and tools that are essential for making data-driven decisions. The curriculum has been crafted to enhance learners’ understanding of key statistical concepts, empowering them to interpret and analyse data effectively. By completing this course, learners will be equipped with the knowledge to apply statistical analysis to real-world scenarios, boosting their analytical thinking and decision-making capabilities. With a focus on developing core analytical expertise, the course is ideal for individuals looking to advance their careers in data analysis, research, or any field where data plays a critical role. Whether you are pursuing a career in business, healthcare, or marketing, this CPD-accredited course offers a professional route to becoming a proficient statistics analyst. Learning Outcomes: It's your chance to start with ourITcourse and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Statistics Analyst - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Data Analyst profession Free Assessment to test learners' knowledge and skills · Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Statistics Module 02: Measuring Central Tendency Module 03: Measures of Dispersion Module 04: Correlation and Regression Analysis Module 05: Probability Module 06: Sampling Module 07: Charts and Graphs Module 08: Hypothesis Testing Module 09: Business Processes Module 10: Business Analysis Planning and Monitoring Module 11: Strategic Analysis and Product Scope Module 12: Ratio Analysis Module 13: Planning & Forecasting Operations Module 14: Ten Common Statistical Mistakes Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Statistics Analyst - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Statistics Analyst - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Statistics Analyst - CPD Accredited 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 Statistics Analyst - CPD Accredited training.

Dive into the intricate world of personal protection with this CPD Accredited Bodyguard Training course, expertly structured to explore every corner of the industry. From the psychology of situational awareness to the subtleties of surveillance, each module provides a detailed look into the role of a modern close protection officer. Whether you're new to the concept or brushing up your knowledge, this course walks you through key principles such as threat assessment, operational planning, and behavioural intelligence, all designed with precision and intent. You'll examine how protective strategies adapt across varied environments, the legal frameworks that shape the profession, and how global shifts—like the COVID-19 pandemic—have reshaped security protocols. With a sharp focus on professional bodyguarding, the course also covers sensitive areas like firearms awareness, anti-ambush procedures, medical response, and route reconnaissance. If you're looking for structured insight into the art of protection without the clichés, this training offers a clean, no-nonsense approach—just how a bodyguard would prefer it. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Bodyguard profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Introduction to Bodyguard Training Module 02: Personal Security Module 03: Laws and Legislation Module 04: Threat Assessment and Risk Management Module 05: Operational Planning Module 06: Behavioural Intelligence Module 07: Anti-Ambush Drills Module 08: Searching Techniques Module 09: On Foot Protection Module 10: Physical Intervention Module 11: Vehicle Escort Procedures Module 12: Route Reconnaissance Module 13: Surveillance and Basic Anti Surveillance Techniques Module 14: Firearms and Explosive Handling Module 15: Protectee Variations Module 16: Medical Emergency Assistance Module 17: How COVID-19 Affected Close Protection Services Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Bodyguard Training - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Bodyguard Training - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Bodyguard Training - CPD Accredited 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 Bodyguard Training - CPD Accredited training.

Master the art of running efficient and effective operations with this Advanced Diploma in Operations Management, designed for professionals aiming to refine their strategic approach. This course delves into the essentials of managing resources, optimising processes, and elevating productivity, ensuring you grasp the mechanics behind successful organisational operations. Whether you're overseeing supply chains or leading project delivery, the course sharpens your ability to make informed decisions that keep businesses ticking smoothly. Delivered entirely online, this CPD-accredited diploma fits seamlessly into your busy schedule without the need for physical attendance. With content carefully crafted to challenge your thinking and broaden your management perspective, it provides a valuable addition to your professional toolkit. Prepare to enhance your career prospects through a deeper understanding of operational excellence, all while enjoying learning that’s engaging, insightful, and refreshingly free from clichés. Course Curriculum: Module 01: Introduction to Operations Management Module 02: Project Management Module 03: Business Development and Succession Planning Module 04: Process Management Module 05: Supply Chain Management Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Management Module 08: Manufacturing & Delivery Operations Module 09: Quality Management Module 10: Managing Risk and Recovery Module 11: Performance Management Module 12: Talent Management Module 13: Communication Skills Module 14: Negotiation Techniques Module 15: Conflict Management Module 16: Stress Management Module 17: Time Management Module 18: Business Environment Module 19: Business Writing Skills 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%. Accredited Certificate After successfully completing this Operations Management - Advanced Diploma - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 15 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Operations Management - Advanced Diploma - CPD Accredited 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 Operations Management - Advanced Diploma - CPD Accredited training.

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst 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:04: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:04: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 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 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:07: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 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 Excel's 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 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:14: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 Lopps 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 Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00