3454 Courses delivered Online

This Hotel & Hospitality Management Diploma with Holiday Representative Training will provide you with an understanding of the interrelationships between departments that drive performance in the hotel and resort industry. The course will introduce to the central philosophies of facilities and resource management, operating procedures and compliance requirements. You will focus on developing and maintaining effective teamwork and the management of staff relationships within a hospitality team. You will become proficient in developing food and beverage menus that meet cost requirements and the management of staff training processes. You'll learn about food service operations alongside a variety of academic disciplines, including foreign languages. This course covers a range of topics such as hotels, resorts, cruise ships, private / corporate owned restaurants and special catering events. You'll also be provided with cash handling, function, restaurant service, and barista skills. Who is this course for? Retail Customer Service and Visual Merchandising Training is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Retail Customer Service and Visual Merchandising Training is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Starting a Restaurant Are you ready for the challenge? 00:15:00 How to decide on a concept 00:30:00 Designing your restaurant 00:15:00 Friends and family 00:15:00 Writing a Business Plan 00:30:00 Insurance 00:15:00 Restaurant Organizations that you need to check out. 00:15:00 What are the best Catering Industry Trade Shows? 00:15:00 Managing a Restaurant Managing Yourself 00:30:00 Managing Others 00:30:00 Managing Your Money 00:15:00 Managing Your Food and Supplies 00:30:00 Managing Everything Else 00:30:00 Starting Food Catering Where You Work 00:15:00 Health and safety 00:15:00 Staff, Suppliers and Transport 00:00:00 Food Hygiene 01:00:00 Rules about Menus 00:15:00 Paperwork and Finances 00:15:00 Law 00:15:00 Food Business Food Business Basics 00:45:00 Put Together Your Business Concept 00:10:00 Identify Your Target Market 00:10:00 Identify Your Competition 00:10:00 Write A Mission Statement 00:10:00 Downline Basics 00:15:00 Equipment And Supplies 00:10:00 Marketing And Quality Control 00:10:00 Wrapping Up 00:05:00 Hospitality Introduction to Hospitality 00:15:00 Characteristics of the Hospitality Industry 00:15:00 Relationship Between the Hospitality Industry and Tourism 00:15:00 Types of Accommodation 00:15:00 Types of Room 00:30:00 Types of Hotel Guests 00:15:00 Hospitality Management Introduction to Hospitality Management 01:00:00 Influences Which Affect the Industry 00:05:00 The Development of the Hospitality Industry 00:05:00 Hospitality Brands 00:15:00 Accommodation 00:05:00 Food Service 00:05:00 Successful Quality Management 00:05:00 Holiday Representative Your Introduction to Becoming a Holiday Rep 00:15:00 Defining the Career of a Holiday Rep 00:30:00 Exploring the Various Types of Holiday Reps 00:30:00 Exploring the Origins and Growth of British Tourism 00:30:00 The Components of the Travel and Tourism Industry 00:15:00 Factors that Affect Your Career 00:30:00 Nailing the Teamwork Element Required to Surpass Expectations 01:00:00 The Standard Duties of Holiday Reps 00:15:00 The Legalities Holiday Reps Need to Know About 01:00:00 The Holiday Reps Role in Keeping their Guests Safe 00:30:00 Effective Handling of Customer Complaints 00:30:00 Administration Duties 00:15:00 Crushing It With Customer Services 00:30:00 Creating the Perfect Welcome Meeting 00:15:00 Guide to Selling Excursions 00:15:00 Preparing and Conducting Transfers Successfully 00:05:00 Tallying Floats and Converting Currencies 00:30:00 Mock Exam Mock Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Final Exam Final Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview of Recruitment Consultant Training The demand for skilled recruitment consultants is constantly growing as businesses across all industries seek to find the best talent to fuel their success. If you're looking for a rewarding and challenging career with excellent earning potential, becoming a recruitment consultant could be the perfect opportunity. The UK recruitment industry is worth over £141.2 billion and employs over 200,000 people. It is a dynamic and ever-changing sector that offers a variety of different specialisms. This means that there are always new opportunities to learn and grow. With the proper training and experience, you can become a highly sought-after recruitment consultant and build a successful career in this exciting industry.   Get a Quick Look at The Course Content: This Recruitment Consultant Training Course will help you to learn: Understand the key principles of recruitment Apply the latest recruitment techniques Source and attract high-quality candidates Assess and interview candidates Build strong relationships with clients Manage your workload effectively Start and run your own recruitment agency This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Recruitment Consultant Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Recruitment Consultant Training course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Recruitment Consultant Training course is for anyone who is interested in a career in recruitment. This includes: People who are new to the recruitment industry. Experienced recruiters who want to update their skills and knowledge. People who are looking to change careers from another sector. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Recruitment Consultant Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path There are a variety of different jobs that you can get into with a capability in recruitment. Here are just a few examples: Recruitment Consultant - £25K to £40K/year Senior Recruitment Consultant - £35K to £50K/year Recruitment Manager - £40K to £60K/year Head of Recruitment - £50K to £70K/year Recruitment Director - £60K to £80K/year Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Recruitment Consultant Training - Updated Version Module 1 - Introduction to Recruitment: Importance and Implications 00:17:00 Module 2 - An Overview of the Recruitment Industry 00:26:00 Module 3 - The UK Recruitment Legislation 00:19:00 Module 4 - Sales and Selling in the Recruitment Industry 00:11:00 Module 5 - The Recruitment Process 00:47:00 Module 6 - Key Performance Indicators for the Recruitment Industry 00:25:00 Module 7 - Candidate Attraction for Recruitment 00:35:00 Module 8 - Candidate Management 00:22:00 Module 9 - Candidate Interview Processes 00:24:00 Module 10 - Client Acquisition 00:36:00 Module 11 - Client Strategy in the Recruitment Sector 00:25:00 Module 12: Client Management 00:27:00 Module 13 - Steps to Starting and Running a Successful Recruiting Service 00:23:00 Recruitment Consultant Training - Old Version Recruitment Basics Introduction to Recruitment 00:15:00 Recruitment 01:00:00 Shortlisting 00:15:00 Selection 01:00:00 Definitions of Training and Development 00:15:00 Considerations in the Design of Training Programmes 00:15:00 Implementing Training 00:15:00 Learning Methods 00:30:00 Recruitment Module One - Getting Started 00:15:00 Module Two - Introduction to Recruitment 00:30:00 Module Three - The Selection Process 00:30:00 Module Four - Goal Setting 00:30:00 Module Five - The Interview 00:30:00 Module Six - Types of Interview Questions 00:30:00 Module Seven - Avoiding Bias in Your Selection 00:30:00 Module Eight - The Background Check 00:30:00 Module Nine - Making Your Offer 00:30:00 Module Ten - Orientation and Retention 00:30:00 Module Eleven - Measuring the Results 00:30:00 Module Twelve - Wrapping Up 00:15:00 Managing Recruitment Module One - Getting Started 00:30:00 Module Two - Defining and Knowing the Position 01:00:00 Module Three - Hiring Strategy 01:00:00 Module Four - Lure in Great Candidates 01:30:00 Module Five - Filtering Applicants to Interview 01:00:00 Module Six - The Interview (I) 01:00:00 Module Seven - The Interview (II) 01:00:00 Module Eight - Selection Process (I) 01:00:00 Module Nine - Selection Process (II) 01:00:00 Module Ten - Making an Offer 01:00:00 Module Eleven - Onboarding 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recruitment - Interview Process History of the Interviewing Process 00:30:00 The Recruitment and Selection Process 00:15:00 Factors in the Hiring Process 00:15:00 Cost Analysis 00:15:00 Job Analysis and Position Profiles 00:30:00 Determining the Skills You Need 00:15:00 Finding Candidates 00:30:00 Advertising Guidelines 00:00:00 Screening Resumes 00:30:00 Performance Assessments 00:30:00 Problems Recruiters Face 00:15:00 Interviewing Barriers 00:15:00 Non-Verbal Communication 00:15:00 Types of Questions 00:30:00 Case Study 00:15:00 Traditional vs. Behavioral Interviews 00:30:00 Other Types of Questions 00:15:00 The Critical Incident Technique 00:15:00 Listening for Answers 00:30:00 Difficult Applicants 01:00:00 Interview Preparation and Format 00:00:00 Other Interview Techniques 00:30:00 Scoring Responses 00:15:00 Checking References 00:30:00 Human Rights 00:15:00 Assignment Assignment - Recruitment Consultant Training 00:00:00

Level 1 First Award in Children's Play Learning and Development Do you intend to work in the field of early childhood education? The goal of this Level 1 First Award in Children's Play Learning and Development course provide practical skills required for working with children. This Level 1 First Award in Children's Play Learning and Development course describes the patterns of child development. Also, this Level 1 First Award in Children's Play Learning and Development course teaches how to promote children’s development through playing. Our Level 1 First Award in Children's Play Learning and Development course is perfect for learning about the principles of Early Years Practice. Enrol this Level 1 First Award in Children's Play Learning and Development course to establish a solid foundation in children’s play learning and development! Learning Outcomes Of Level 1 First Award In Children’s Play Learning And Development After completing the training learner will know about: Growth and development comprehension through this Level 1 First Award in Children's Play Learning and Development course. This Level 1 First Award in Children's Play Learning and Development course explains how to do children’s development through playing. The key person approach to child development has several advantages described in this Level 1 First Award in Children's Play Learning and Development course. You will know what the duties associated with the key person’s role by the Level 1 First Award in Children's Play Learning and Development course. Special Offers of this Level 1 First Award in Children's Play Learning and Development Course This Level 1 First Award in Children's Play Learning and Development Course includes a FREE PDF Certificate Lifetime access to this Level 1 First Award in Children's Play Learning and Development Course Instant access to this Level 1 First Award in Children's Play Learning and Development Course Get FREE Tutor Support to this Level 1 First Award in Children's Play Learning and Development Course Level 1 First Award in Children's Play Learning and Development Unlock the essentials of early childhood development with our Level 1 First Award in Children's Play Learning and Development course. This course provides a comprehensive understanding of the patterns of child development, ensuring you're well-equipped to support children's growth. Through the Level 1 First Award in Children's Play Learning and Development, you'll discover how play is a vital tool for promoting children's development. Ideal for those eager to learn the principles of Early Years Practice, this Level 1 First Award in Children's Play Learning and Development course prepares you to foster a positive and nurturing environment for young learners. Who is this course for? Level 1 First Award in Children's Play Learning and Development Anyone can join this Level 1 First Award in Children's Play Learning and Development course. Requirements Level 1 First Award in Children's Play Learning and Development To enrol in this Level 1 First Award in Children's Development Course, students must fulfil the following requirements. To join in our Level 1 First Award in Children's Development Course, you must have a strong command of the English language. To successfully complete our First Award in Children's Development Course, you must be vivacious and self driven. To complete our First Award in Children's Development Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this First Award in Children's Development Course. Career path Level 1 First Award in Children's Play Learning and Development Enrolling in this Level 1 First Award in Children's Play Learning and Development course can improve your resume and lead to many new career opportunities.

Welcome to a transformative journey where every child's safety and well-being matter profoundly. 'Child Sexual Exploitation Awareness Diploma' isn't merely a course; it's a beacon of hope, a commitment to safeguarding the most vulnerable. As the landscape of exploitation evolves, this course equips you with the knowledge and tools to identify, address, and prevent these atrocities. Together, let's make a stand for a safer world for our children. Learning Outcomes Master the intricacies of child sexual exploitation. Skillfully identify and provide support to those impacted, offering hope and assistance. Navigate and apply legislative frameworks effectively to advocate for vulnerable individuals. Develop and implement proactive strategies for prevention and intervention. Champion online safety, ensuring a secure digital environment for children and adolescents. Why choose this Child Sexual Exploitation Awareness Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Child Sexual Exploitation Awareness Diploma Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Child Sexual Exploitation Awareness Diploma for? Advocates committed to building safer communities for children. Professionals working closely with youth, seeking to enhance their protective capabilities. Policymakers dedicated to crafting impactful, child-centric regulations. Caregivers eager to strengthen their understanding of child protection. Digital citizens determined to ensure online safety for young users. Career path Child Protection Officer: £27,000 - £34,000 Victim Support Worker: £22,000 - £28,000 Child Welfare Specialist: £30,000 - £37,000 School Counsellor: £26,000 - £33,000 Online Safety Educator: £24,000 - £30,000 CSE Prevention Coordinator: £28,000 - £35,000 Prerequisites This Child Sexual Exploitation Awareness Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Child Sexual Exploitation Awareness Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Child Sexual Exploitation Introduction to Child Sexual Exploitation 00:12:00 Module 02: Forms of Child Sexual Exploitation Forms of Child Sexual Exploitation 00:14:00 Module 03: Identifying Victims of CSE Identifying Victims of CSE 00:14:00 Module 04: Child Criminal Exploitation Child Criminal Exploitation 00:08:00 Module 05: Impact on Victims and Society Impact on Victims and Society 00:17:00 Module 06: Legislation and Reporting Obligations Legislation and Reporting Obligations 00:16:00 Module 07: The Role of Professionals The Role of Professionals 00:19:00 Module 8: Prevention and Intervention Strategies Prevention and Intervention Strategies 00:00:00 Module 09: Online Safety for Children Online Safety for Children 00:16:00 Module 10: Supporting Victims and Survivors Supporting Victims and Survivors 00:19:00

Embark on a transformative journey with our course, 'Applied Behaviour Analysis (ABA) for Autism Spectrum Disorders.' This program is your gateway to understanding and applying the potent principles of ABA to empower individuals with Autism Spectrum Disorder (ASD). Dive into a world where compassion meets science, and learn how to make a profound impact on the lives of those affected by ASD. Our immersive curriculum guides you through every facet of ABA, equipping you with the skills and knowledge to bring about positive change. In this course, you'll start with an in-depth exploration of ASD, gaining insight into its nuances and challenges. As you progress, you'll master the foundational elements of ABA, learning to assess, evaluate, and develop effective behavioural strategies. Discover how to nurture skill acquisition while addressing challenging behaviours, and witness the remarkable transformations that result. Whether you aspire to be a practitioner, educator, or advocate, this course is your conduit to making a real difference in the world of ASD. Learning Outcomes Comprehend the intricacies of Autism Spectrum Disorder (ASD) and its impact on individuals and their families. Proficiently apply the foundational principles of Applied Behaviour Analysis (ABA) to design effective interventions. Conduct comprehensive assessments and evaluations to tailor ABA strategies to individual needs. Implement behavioural techniques to facilitate skill acquisition, fostering independence and development. Employ ABA interventions to address and reduce challenging behaviours, improving the quality of life for individuals with ASD. Why buy this Applied Behaviour Analysis (ABA) for Autism Spectrum Disorders? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Applied Behaviour Analysis (ABA) for Autism Spectrum Disorders for? Aspiring Behaviour Analysts and Therapists Educators and Special Education Professionals Parents and Caregivers of Individuals with ASD Healthcare and Mental Health Practitioners Advocates and Anyone Passionate About Making a Difference. Career path Behaviour Analyst: £30,000 - £60,000 Special Education Teacher: £25,000 - £45,000 Speech and Language Therapist: £30,000 - £50,000 Clinical Psychologist: £35,000 - £70,000 Autism Support Specialist: £25,000 - £45,000 School Counselor: £30,000 - £50,000 Prerequisites This Applied Behaviour Analysis (ABA) for Autism Spectrum Disorders does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Autism Spectrum Disorder (ASD) Introduction to Autism Spectrum Disorder (ASD) 00:19:00 Module 2: Foundations of Applied Behavior Analysis (ABA) Foundations of Applied Behavior Analysis (ABA) 00:19:00 Module 3: Assessment and Evaluation in ABA Assessment and Evaluation in ABA 00:20:00 Module 4: Behavioural Strategies for Skill Acquisition Behavioural Strategies for Skill Acquisition 00:20:00 Module 5: Behavioural Strategies for Reducing Challenging Behaviours Behavioural Strategies for Reducing Challenging Behaviours 00:15:00 Module 6: ABA Interventions for Communication and Social Skills ABA Interventions for Communication and Social Skills 00:15:00 Module 7: ABA Interventions for Daily Living and Self-Help Skills ABA Interventions for Daily Living and Self-Help Skills 00:16:00 Module 8: Transitioning and Maintenance of ABA Interventions Transitioning and Maintenance of ABA Interventions 00:19:00

BSL and British Sign Language: BSL and British Sign Language Course Online Do you want to know more about the (BSL) British Sign Language Course? Our (BSL) British Sign Language Course is designed with all the latest information on BSL and its legal and medical intelligence. Our (BSL) British Sign Language Course have various modules to give a detailed introduction to BSL. this (BSL) British Sign Language Course describes fingerspelling, basic vocabulary and phrases. Also, the (BSL) British Sign Language Course explains the numbers, family and relationships. This (BSL) British Sign Language Course also have details on colours, animals, and food. Advanced vocabulary, grammar and syntax are part of the (BSL) British Sign Language Course. You will clearly know how to improve conversational skills, deaf culture, storytelling and narration from the (BSL) British Sign Language Course. Moreover, poetry, literature, regional variations and interpreting are modules of this (BSL) British Sign Language Course lesson. Enrol our (BSL) British Sign Language Course to communicate with people with sign language. Learning Outcome of (BSL) British Sign Language Course After completing the (BSL) British Sign Language Course, learners will know about the: Introduction to BSL, fingerspelling, basic vocabulary and phrases. The (BSL) British Sign Language Course explains numbers, family and relationships. Colours, animals, and food are part of this (BSL) British Sign Language Course. Advanced vocabulary, grammar, syntax and conversational skills are explained in the (BSL) British Sign Language Course. This (BSL) British Sign Language Course includes deaf culture, storytelling and narration. Poetry, literature and regional variations are elaborated in the (BSL) British Sign Language Course. You will learn to do interpreting with this (BSL) British Sign Language Course. Legal and medical sign language ideas will be more strong with this (BSL) British Sign Language Course. Main Course: (BSL) British Sign Language Course Free Courses are including with this BSL and British Sign Language Course BSL and British Sign Language Course, We Offer a free Autism Training Course BSL and British Sign Language Course, We Offer a free Early Years Foundation Stage (EYFS) Training Course BSL and British Sign Language Course, We Offer a free Speech & Language TherapyCourse Special Offers of this BSL and British Sign Language: BSL and British Sign Language Course This BSL and British Sign Language Course includes a FREE PDF Certificate. Lifetime access to this BSL and British Sign Language Course Instant access to this BSL and British Sign Language Course Get FREE Tutor Support to this BSL and British Sign Language Course BSL and British Sign Language: BSL and British Sign Language Course Online A comprehensive introduction to BSL is given in multiple lessons of our BSL and British Sign Language Course. This British Sign Language (BSL) course teaches the basics of fingerspelling and basic vocabulary and phrases. Numbers, families, and connections are all explained in the British Sign Language Course (BSL). This BSL and British Sign Language Course also includes information on foods, animals, and colors. The British Sign Language (BSL) course covers advanced syntax, grammar, and vocabulary. You will gain a comprehensive understanding of how to improve your conversational skills, deaf culture, storytelling, and narrative through the (BSL) British Sign Language Course. In addition, this lesson from the British Sign Language Course (BSL) covers literature, poetry, regional variations, and interpretation. Who is this course for? BSL and British Sign Language: BSL and British Sign Language Course Online This (BSL) British Sign Language Course is perfectly suited for individuals who have an interest in the world of sign language. Special Note: Our Course is not a regulated course. If You want to get qualified, you can consider following options: Level 1 Award in British Sign Language (RQF) Requirements BSL and British Sign Language: BSL and British Sign Language Course Online To enrol in this BSL and British Sign Language Course, students must fulfil the following requirements. To join in our BSL and British Sign Language Course, you must have a strong command of the English language. To successfully complete our BSL and British Sign Language Course, you must be vivacious and self driven. To complete our BSL and British Sign Language Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this BSL and British Sign Language Course. Career path BSL and British Sign Language: BSL and British Sign Language Course Online This (BSL) British Sign Language Course will enable you to explore career options such as SEN Teacher BSL Instructor BSL Interpreter Teaching Assistant Social Worker

Level 5 Associate Diploma in People Management: Level 5 Associate Diploma in People Management Would you like to bring a big change to your company's performance with your Level 5 Associate Diploma in People Management skills? We have a Level 5 Associate Diploma in People Management course to boost your expertise. This level 5 associate diploma in Level 5 Associate Diploma in People Management course covers organisational performance, culture in action, professional attitudes, and appreciating people. Additionally, this level 5 associate diploma in Level 5 Associate Diploma in People Management course teaches students how to perform evidence-based medicine. Furthermore, how to maintain work relationships, workforce planning, and talent management techniques are covered throughout this level 5 associate diploma in Level 5 Associate Diploma in People Management course. Moreover, this level 5 associate diploma in Level 5 Associate Diploma in People Management course will help you recognise your performance, contributions, and the growth of leadership and management. Learning outcomes of Level 5 Associate Diploma in People Management course This Level 5 Associate Diploma in People Management course will explain: Performance of organisations and culture in action. This Level 5 Associate Diploma in People Management course teaches how to practice based on evidence. Professional behaviours and valuing people are also thoughts in our Level 5 Associate Diploma in People Management course. Moreover, this Level 5 Associate Diploma in People Management course explains the management of employment relationships. How to do workforce planning and talent management is described in our Level 5 Associate Diploma in People Management course. Throughout our Level 5 Associate Diploma in People Management course, you will receive acknowledgement of contribution and performance. Overall, this Level 5 Associate Diploma in People Management course is helpful to the development of leadership and management. Special Offers Of this Level 5 Associate Diploma in People Management course This Level 5 Associate Diploma in People Management course includes a FREE PDF Certificate. Lifetime access to this Level 5 Associate Diploma in People Management course Instant access to this Level 5 Associate Diploma in People Management course Get FREE Tutor Support from Monday to Friday in this Level 5 Associate Diploma in People Management course. [ Note: Free Digital certificate as soon as completing the Level 5 Associate Diploma in People Management course] Level 5 Associate Diploma in People Management Our Level 5 Associate Diploma in People Management course offers a deep dive into organizational performance and culture in action. This Level 5 Associate Diploma in People Management course also emphasizes professional attitudes and the value of appreciating people in the workplace. Additionally, our Level 5 Associate Diploma in People Management program equips students with the skills to apply evidence-based practices effectively. By enrolling in this Level 5 Associate Diploma in People Management course, you'll gain the knowledge and tools needed to drive success in any organization. Enhance your expertise in Level 5 Associate Diploma in People Management and take your career to the next level. Who is this course for? Level 5 Associate Diploma in People Management If you're looking to advance in an exciting and encouraging atmosphere in your HR profession, this level 5 associate diploma in Level 5 Associate Diploma in People Management course is for you. Special Note: Our Level 5 Associate Diploma in People Management Course is Knowledge-based not a regulated course. To get Qualified, you may choose the following options: CIPD CIPD-Intermediate CIPD-Advanced CIPD-hr-practice CIPD Level 3 Foundation Certificate in People Practice CIPD Level 5 Associate Diploma in People Management CIPD Level 5 Associate Diploma in Organisational Learning and Development CIPD Level 7 Advanced Diploma in Strategic Learning and Development Level-3-CIPD Requirements Level 5 Associate Diploma in People Management To enrol in this Level 5 Associate Diploma in People Management Course Course, students must fulfil the following requirements. To join in our Level 5 Associate Diploma in People Management Course, you must have a strong command of the English language. To successfully complete our Level 5 Associate Diploma in People Management Course, you must be vivacious and self driven. To complete our Level 5 Associate Diploma in People Management Course, you must have a basic understanding of computers. Career path Level 5 Associate Diploma in People Management Taking this Level 5 Associate Diploma in People Management course will help you land a position as an: HR manager HR director HR business partner Head of HR

Duration 5 Days 30 CPD hours This course is intended for This course is designed for programmatic developers looking to write programmatic customizations to both business logic and UI layers using Apex and Visualforce. You should have a good understanding of core object-oriented programming concepts and experience building declarative solutions on the Salesforce Platform. This course is also a great foundation builder if you're looking to earn your Salesforce Platform Developer I credential. IMPORTANT: Students are expected to follow the steps detailed in the Computer Set-up Guide for this class if you'll be using your own computer when attending a virtual or in-person class. Overview Learn modern tools for developing on the Salesforce Platform using Visual Studio Code, the Salesforce Extension Pack, and the Salesforce CLI. Write business logic customizations using Apex triggers and classes; those customizations will use SOQL and DML. Design programmatic solutions that take advantage of declarative customizations. Describe how your trigger code works within the basics of the Save Order of Execution. Describe some of the fundamental aspects of designing programs on a multi-tenant platform. Write Visualforce markup and code to customize the user interface. Use the built-in testing framework to test Apex and Visualforce. Learn how to customize and design applications programmatically on the Salesforce Platform. In this 5-day class, our platform experts will introduce you to Apex (Salesforce?s programming language) and Visualforce markup, so you can customize your Salesforce applications using code and explore how Apex interacts with declarative customizations on the platform. Learn how to retrieve, manipulate, and store data programmatically in data objects (sObjects), write and test custom logic, write Visualforce pages to customize your user interface, and deploy your solutions to another environment. Get an overview of the declarative automation tools available on the platform and a brief introduction to the Lightning Component framework. Plus, explore the nuances of working on a multi-tenant platform so you can extend the platform to meet business demands. Declarative Automation Create Formula Fields Create Roll-Up Summary Fields Understand Record Types Review Other Automation Tools Build a Data Model on the Salesforce Platform Programming with Apex Describe Key Aspects of Apex That Differentiate It from Other Languages, Such as Java and C# Describe Why Apex Transactions and Governor Limits Must Be Considered When Writing Apex Execute Simple Apex Use the sObject Data Type, the Primitive Data Types, and Basic Control Statements in Apex Using SOQL and SOSL to Retrieve Your Org?s Data Write a Basic Query Using Salesforce?s Query Language, SOQL Process the Result of a Query in Apex Create a Query Dynamically at Run-Time Use SOQL to Query Parent-Child Relationships Describe a Relationship Query Write a Query That Traverses a Child-to-Parent Relationship Write a Query That Traverses a Parent-to-Child Relationship Use SOSL to Search Data Using DML to Manipulate Your Org?s Data List the Differences Between the Ways You Can Invoke DML Operations Write Apex to Invoke DML Operations and Handle DML Errors Deployment What Is Deployment? Deploy Code Using Change Sets Use the Ant Migration Tool Review Managed and Unmanaged Packages Explore Salesforce DX Trigger Essentials Describe What a Trigger Is Used For Describe the Syntax of a Trigger Definition Use Trigger Context Variables Apex Class Essentials Describe How Apex Classes Are Used Define an Apex Class Determine What Data an Apex Class Can Access The Save Order of Execution, Apex Transactions, and Platform Events Describe Key Points in the Order of Execution Describe How Triggers Fit Into and Can Be Impacted by the Order of Execution Describe the Lifecycle of an Apex Transaction Describe the Memory Lifecycle for Static Attributes Use Platform Events for Immediate Error Logging Apex Testing Describe the Apex Testing Framework Create Test Data Write and Run an Apex Test Test Best Practices Strategies for Designing Efficient Apex Solutions Describe Best Practices for Writing Code That Is Easy to Maintain and Extend Write Triggers and Classes That Assume Batches of Data as Input Write Code That Works Efficiently with the Database, Both in Querying and Using DML Trigger Design Strategies List Declarative Mechanisms You Can Use to Implement Complex Business Logic, What Types of Problems They?re Best Used for, and Their Limitations Describe Ways in Which You Can Use Declarative Functionality to Improve Your Programmatic Solutions Working with Visualforce Create a Visualforce Page Reference a Standard Controller Launch a Visualforce Page Using a Custom Button Display Data from a Record in a Visualforce Page Reference Custom Controllers and Controller Extensions Work with List Controllers Visualforce Development Considerations and Testing Describe Common Limit Issues and Security Concerns Describe Strategies for Testing Visualforce Controllers Write Tests for Controller Constructors Write Tests for Action Methods, Getters, Setters, and Properties Lightning Components Create and Surface an Aura Component Create and Surface a Lightning Web Component Additional course details: Nexus Humans Salesforce Build Applications Programmatically on the Salesforce Platform (DEX450) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Salesforce Build Applications Programmatically on the Salesforce Platform (DEX450) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview of Level 3 Diploma in Health & Social Care If you are thinking about a career in Healthcare, you have the right mindset. In the UK, professionals in the health and social care sector enjoy the fulfilment of making a difference in people's lives but also benefit from competitive salaries. Our Level 3 Diploma in Health & Social Care provides a comprehensive understanding of the field and is designed to enhance your career prospects. Care Assistants and Healthcare Assistants can earn between £22,000 to £30,000 annually, while specialised roles like Social Workers may earn between £28,000 and £38,000. This sector offers both financial stability and significant growth potential. In this Level 3 Diploma in Health & Social Care, you'll learn about the fundamentals of health and social care. You will also learn effective communication tailored for care settings, understand the rights and responsibilities of healthcare workers, and explore the roles of caregivers and healthcare professionals. The course also covers promoting equality, diversity, and rights in care, understanding legal and ethical aspects of healthcare, safeguarding vulnerable individuals, risk management in health and social care and much more. By taking this course, you'll improve your job prospects and be equipped to make a real difference in the lives of others. The curriculum ensures that upon completion, you will be an attractive candidate for various roles in this sector and a more effective, empathetic, and informed professional. So what are you waiting for? Enrol today and start your success journey! Fast-Track Your Learning: Watch the Course Trailer Get a Quick Look at The Course Content: This Level 3 Diploma in Health & Social Care Course will help you to learn: Fundamentals of Health and Social Care, including core responsibilities and ethics. Effective Communication skills tailored for health and social care settings. Understanding and upholding the Rights and Responsibilities in care environments. The Role and Skills of a Caregiver and Healthcare Professional. Promoting Equality, Diversity, and Rights in Health and Social Care. Principles and Policies governing Health and Social Care work. Legal and Professional Standards of Practice in Health Care, in two comprehensive parts. Techniques for Safeguarding Vulnerable Individuals. Comprehensive knowledge of Health and Safety Responsibilities. Effective Risk Management strategies in Health and Social Care. Preparation for real-world scenarios through Mock and Final Exams. 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   Certificate of Completion - Digital/PDF Certificate After completing the Level 3 Diploma in Health & Social Care course, you can order your CPD-accredited Digital/PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals aspiring to enter the health and social care sector. Existing care workers seeking formal qualifications. Nurses and healthcare assistants aiming for career advancement. Support workers in residential or community settings. Anyone interested in understanding the complexities of health and social care. Requirements You don't need any educational qualification or experience to enrol in the Level 3 Diploma in Health & Social Care 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 This Level 3 Diploma in Health & Social Care isn't just an investment in your education; it's a step towards a rewarding and impactful career where you make a difference every day. Some potential career paths are: Care Assistant: £20,000 - £30,000 annually Healthcare Assistant: £22,000 - £32,000 annually Support Worker: £22,000 - £30,000 annually Senior Care Worker: £25,000 - £35,000 annually Nursing Assistant: £24,000 - £35,000 annually Residential Care Home Manager: £28,000 - £40,000 annually Level 3 Diploma in Health & Social Care FAQs Q: What is health care and social care? Healthcare is more easily understood. It is the care that professionals or pharmaceutical companies provide for well-defined illnesses, injuries, or diseases or to prevent such conditions. It also includes care for pregnant women, who may be healthy and may have healthy fetuses but need facilitation to give birth. Social care addresses a wide range of needs beyond healthcare, although the two are interrelated. It helps individuals better adapt to a social and family environment. The term and its boundaries need to be more well-defined. Q. What is level 3 of health and social care? A level 3 Health and social care qualification is equivalent to A-levels. It is usually done as a BTEC (however, if you're 19+, it's usually an NVQ or an Access course). You do one year for a Subsidiary Diploma, and after completing the second year, you get an Extended Diploma worth three A-levels. It's basically the go-to qualification if you want to go to university to study Nursing, midwifery, SALT (speech and Language), OT (occupational therapist), social work, etc. However, because it is so broad in modules you learn, you can work in some areas of schools. Q. Why do you want to study health and social care? Health and social care is an amazing learning field where you will learn how issues like mental health, poverty and the use of recreational drugs impact individuals. You will also learn different aspects of this arena.  You will learn- - Fundamentals of Health and Social Care. - Effective Communication skills tailored for health and social care. - Understanding and upholding the Rights and Responsibilities in care environments. - The Role and Skills of a Caregiver and Healthcare Professional. - Promoting Equality, Diversity, and Rights in Health and Social Care. - Principles and Policies governing Health and Social Care work. - Effective Risk Management Strategies in Health and Social Care. Q. What's the best career choice for health and social care? The best career choices in health and social care include:   - Nursing: Providing direct patient care and working in diverse healthcare settings. - Medicine: Diagnosing, treating illnesses, and leading healthcare teams. - Allied Health Professions: Specialised assessments and therapeutic interventions in physiotherapy, occupational therapy, and radiography. - Social Work: Supporting individuals and families facing challenging circumstances. - Counselling and Psychotherapy: Helping individuals navigate mental health challenges and providing therapy. - Public Health: Improving population health, developing policies, and promoting disease prevention. - Health Administration and Management: Overseeing healthcare facilities and ensuring efficient delivery of services. - Caregiving and Support Roles: Directly providing care and support to needy individuals. Q. What do you do for health and social care GCSE? To make an outstanding result, you have to cover these topics - - Personal Development and Relationships - Health, Social Care and Early Years Provision - Health and Wellbeing - Health, Social Care and Early Years in Practice Q. What is RQF Health and Social Care? The RQF Health and Social Care or RFQ Level 2 Diploma in Health & Social Care is a suitable qualification for those who are just starting employment in the social care industry or those who are already working as a social care assistant/worker. Q. Why I will study NVQ Health and Social Care? The NVQ Health and Social Care or Level 2/ Level 3/ Level/ Level 5 NVQ Health and social care programme will help you reach your fullest potential and make a more significant impact on the lives of the most vulnerable community members. You will look at equality and diversity, growth, and development, as well as the role of safeguarding and protection in health and social care.  Course Curriculum Module 1: Introduction to Health and Social Care Module 1: Introduction to Health and Social Care 00:19:00 Module 2: Communication and its Relevance Module 2: Communication and its Relevance 00:42:00 Module 3: Rights and Responsibilities as a Health and Social Care Worker Module 3: Rights and Responsibilities as a Health and Social Care Worker 00:38:00 Module 4: Role as A Caregiver and Healthcare Professional Module 4: Role as A Caregiver and Healthcare Professional 00:26:00 Module 5: Working in Health and Social Care: Promoting Equality, Diversity and Rights Module 5: Working in Health and Social Care: Promoting Equality, Diversity and Rights 00:49:00 Module 6: Important Principles and Policies in Health and Social Care Work Module 6: Important Principles and Policies in Health and Social Care Work 00:23:00 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 1) 00:50:00 Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 2) Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 2) 00:48:00 Module 9: Safeguarding Vulnerable Individuals Module 9: Safeguarding Vulnerable Individuals 00:52:00 Module 10: Health and Safety Responsibilities Module 10: Health and Safety Responsibilities 00:51:00 Module 11: Risk Management in Health and Social Care Module 11: Risk Management in Health and Social Care 00:03:00 Mock Exam Mock Exam - Level 3 Diploma in Health & Social Care 00:20:00 Final Exam Final Exam - Level 3 Diploma in Health & Social Care 00:20:00

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