27374 Courses

Overview of Virtual Interviewing for HR Join our Virtual Interviewing for HR course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Virtual Interviewing for HR course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Virtual Interviewing for HR course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Virtual Interviewing for HR Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Virtual Interviewing for HR. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Virtual Interviewing for HR 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 Virtual Interviewing for HR is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the Virtual Interviewing for HR course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Virtual Interviewing for HR Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction Jenn Flaa Bio 00:01:00 Welcome Seeker 00:01:00 Before We Begin 00:01:00 Bad RECRUITER Example Before for Recruiter 00:02:00 Module 02: Behave Professionally on Video Your Own Goal Seeker 00:01:00 Where Do I Look 00:02:00 How to Convey Confidence 00:02:00 How to Convey Power 00:02:00 First Impression Recruiter 00:01:00 What to Wear - Ladies 00:02:00 What to Wear - Men 00:01:00 Should I Wear Makeup? 00:02:00 Do Men Wear Makeup? 00:02:00 Your Hair on Video 00:01:00 What's Behind You 00:01:00 Good Background 00:01:00 How to Sit Confidently on Video 00:02:00 What To Do With Hands 00:01:00 Glare in Your Glasses 00:01:00 Practice Tips Recruiter 00:02:00 Before Interview Recruiter Explained 00:01:00 Lab 2 Recruiter 00:01:00 Module 03: During the Interview Why Video Interviews Are Popular 00:01:00 When to Schedule the Interview 00:01:00 What to Expect 00:02:00 Distractions 00:02:00 Pulling Focus Away from You 00:01:00 How in Person & Video Interviews Differ 00:03:00 How to Start & End Your Video Interview 00:01:00 Ending the Interview 00:01:00 Managing Time 00:01:00 #1 Pitfall 00:03:00 Module 04: Handling Video Fear and Nerves Fear of Being Seen & Revealing Yourself 00:01:00 Un-Nerving Yourself 00:02:00 Grounding Meditation 00:09:00 Module 05: Things of Recruiter #1 Things You Must Do 00:03:00 How to Critique A Candidate on Video 00:05:00 Visual Bias 00:04:00 How to Deal With Bad Video and Distraction 00:03:00 Manipulating with Video 00:01:00 Lab 5 Visual Bias 00:03:00 Module 06: Your Setup and Equipment Do I Need to Buy Equipment for This Interview? 00:01:00 Equipment Experiment - Easy, Affordable Setup 00:06:00 Upgraded Camera & Mic 00:04:00 What's On My Desk During Video Interviews? 00:01:00 Jenn's Office Setup with Ambient Light for Video Interviews 00:01:00 Jenn's Office Setup with Full Lighting and White Backdrop 00:01:00 Module 07: Your Introduction Video Should I Use a Script? 00:02:00 #1 Way to Bore Your Viewer 00:01:00 Video Check List Animated 00:01:00 Module 08: Bonus Tips Before The Video Interview 00:01:00 What If You Have an Accent? 00:01:00 What What Recruiter 00:01:00 4 Tips 00:02:00 4 Things to Avoid 00:01:00 Preparing for Your Video Interview 00:01:00 Your Eyes Communicate Too 00:04:00 Water 00:01:00 What if I Have a BAD Interviewer? 00:01:00 Video Foul 00:02:00 After' Example 00:02:00 Module 09: Wrap Up Jenn's Last Thoughts 00:01:00 Last Labs 00:03:00 The 10% To Remember 00:01:00

Follow your dreams by enrolling on the Recruitment and Selection Management course today and develop the experience, skills and knowledge you need to enhance your professional development. Recruitment and Selection Management will help you arm yourself with the qualities you need to work towards your dream job. Study the Recruitment and Selection Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Recruitment and Selection Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Recruitment and Selection Management course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Recruitment and Selection Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Recruitment and Selection Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Recruitment and Selection Management course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Recruitment and Selection Management course. The Recruitment and Selection Management course is designed by industry experts and is tailored to help you learn new skills with ease.  The Recruitment and Selection Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Recruitment and Selection Management when it suits you. Access the Recruitment and Selection Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The Recruitment and Selection Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Recruitment and Selection Management now and start learning instantly! What You Get Out Of Studying Recruitment and Selection Management With Janets: Receive a digital Certificate upon successful completion of the Recruitment and Selection Management course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Recruitment and Selection Management training course is delivered through Janets' online learning platform. Access the Recruitment and Selection Management content from any internet-enabled device whenever or wherever you want to. The Recruitment and Selection Management course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Recruitment and Selection Management course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Recruitment and Selection Management course. After successfully passing the Recruitment and Selection Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Recruitment and Selection Management qualification. Certification All students who successfully complete the Recruitment and Selection Management course can instantly download their digital certificate. You can also purchase a hard copy of the Recruitment and Selection Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Recruitment and Selection Management is ideal for those who already work in this sector or are an aspiring professional. This Recruitment and Selection Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Recruitment and Selection Management is open to all students and has no formal entry requirements. To study the Recruitment and Selection Management course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Recruitment and Selection Management is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Recruitment and Selection Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Recruitment and Selection Management - Updated Version Basics of Recruitment 00:50:00 History and Development of the Recruitment Industry 00:40:00 The Worldwide Employment Industry 00:40:00 The UK Recruitment Industry Statistics 00:25:00 The UK Recruitment Legislations Guide 00:20:00 How to Become a Successful Recruitment Consultant 00:45:00 Overview of the Recruitment Cycle 00:45:00 Candidate Management 01:30:00 Client Acquisition 01:20:00 Recruitment Strategy 01:00:00 Candidate Attraction 00:40:00 Developing a Business Strategy and Key Performance Indicators 01:00:00 How to Successfully Run a Recruiting Service 00:35:00 Recruitment and Selection Management - Old Version Recruitment and Selection Management 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: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 Activities Recruitment and Selection Management- Activities 00:00:00 Recommended Reading Recommended Reading: Recruitment and Selection Management 00:00:00 Mock Exam Mock Exam- Recruitment and Selection Management 00:20:00 Final Exam Final Exam- Recruitment and Selection Management 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Follow your dreams by enrolling on the Therapeutic Massage and Massage Salon Management course today and develop the experience, skills and knowledge you need to enhance your professional development. Therapeutic Massage and Massage Salon Management will help you arm yourself with the qualities you need to work towards your dream job. Study the Therapeutic Massage and Massage Salon Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Therapeutic Massage and Massage Salon Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Therapeutic Massage and Massage Salon Management course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Therapeutic Massage and Massage Salon Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Therapeutic Massage and Massage Salon Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Therapeutic Massage and Massage Salon Management course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Therapeutic Massage and Massage Salon Management course. The Therapeutic Massage and Massage Salon Management course is designed by industry experts and is tailored to help you learn new skills with ease. The Therapeutic Massage and Massage Salon Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Therapeutic Massage and Massage Salon Management when it suits you. Access the Therapeutic Massage and Massage Salon Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The Therapeutic Massage and Massage Salon Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Therapeutic Massage and Massage Salon Management now and start learning instantly! What You Get Out Of Studying Therapeutic Massage and Massage Salon Management With Janets Free PDF certificate upon successful completion of the Therapeutic Massage and Massage Salon Management Full one-year access to Therapeutic Massage and Massage Salon Management Course materials Instant assessment results with the Therapeutic Massage and Massage Salon Management No hidden fees with the Therapeutic Massage and Massage Salon Management Full tutor support available from Monday to Friday with the Therapeutic Massage and Massage Salon Management Study the Therapeutic Massage and Massage Salon Management at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Therapeutic Massage and Massage Salon Management Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Therapeutic Massage and Massage Salon Management Study the Therapeutic Massage and Massage Salon Management in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Therapeutic Massage and Massage Salon Management Description  The Therapeutic Massage and Massage Salon Management training course is delivered through Janets' online learning platform. Access the Therapeutic Massage and Massage Salon Management content from any internet-enabled device whenever or wherever you want to. The Therapeutic Massage and Massage Salon Management course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Therapeutic Massage and Massage Salon Management course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Therapeutic Massage and Massage Salon Management course. After successfully passing the Therapeutic Massage and Massage Salon Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Therapeutic Massage and Massage Salon Management qualification. Certification All students who successfully complete the Therapeutic Massage and Massage Salon Management course can instantly download their digital certificate. You can also purchase a hard copy of the Therapeutic Massage and Massage Salon Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Therapeutic Massage and Massage Salon Management is ideal for those who already work in this sector or are an aspiring professional. This Therapeutic Massage and Massage Salon Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Therapeutic Massage and Massage Salon Management is open to all students and has no formal entry requirements. To study the Therapeutic Massage and Massage Salon Management course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Therapeutic Massage and Massage Salon Management is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Therapeutic Massage and Massage Salon Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Massage Therapy Introduction to Massage Therapy 00:15:00 Massage History 00:15:00 The Role of A Massage Therapist 00:30:00 Tissues, Organs, & Neuromuscular systems 01:00:00 General Benefits of Massage 00:15:00 Various Massage Techniques Indian Head Massage 00:15:00 Facial Massage 00:30:00 Neck Massage 00:30:00 Back Massage 00:30:00 Full Body Massage 00:15:00 Swedish Massage 00:15:00 Therapeutic Massage Sports Massage 00:30:00 LomiLomi Massage 00:15:00 Anti-Cellulite Massage 00:15:00 Hot Stone Massage 00:30:00 Thai Foot Massage 00:15:00 Prenatal Massage 00:15:00 Medical Massage 01:00:00 Baby Massage 01:00:00 Trigger Point Therapy 00:05:00 Thai Massage 01:00:00 Reflexology 01:00:00 Massage Salon How A Massage Therapist Can Start A Business 01:00:00 Marketing Your Business 01:00:00 Complimentary Massages 00:15:00 Building Your Clientele 00:30:00 Other Ways To Market Your Business 01:00:00 Conclusion to Massage 00:15:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Follow your dreams by enrolling on the Adult Nursing - Patient Care and Wellbeing course today and develop the experience, skills and knowledge you need to enhance your professional development. Adult Nursing - Patient Care and Wellbeing will help you arm yourself with the qualities you need to work towards your dream job. Study the Adult Nursing - Patient Care and Wellbeing training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Adult Nursing - Patient Care and Wellbeing course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Adult Nursing - Patient Care and Wellbeing course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Adult Nursing - Patient Care and Wellbeing course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Adult Nursing - Patient Care and Wellbeing course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Adult Nursing - Patient Care and Wellbeing course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Adult Nursing - Patient Care and Wellbeing course. The Adult Nursing - Patient Care and Wellbeing course is designed by industry experts and is tailored to help you learn new skills with ease.  The Adult Nursing - Patient Care and Wellbeing is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Adult Nursing - Patient Care and Wellbeing when it suits you. Access the Adult Nursing - Patient Care and Wellbeing course modules from any internet-enabled device, including computers, tablets, and smartphones. The Adult Nursing - Patient Care and Wellbeing course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Adult Nursing - Patient Care and Wellbeing now and start learning instantly! Please note: This course only gives you the theoretical knowledge that you need to excel in this field. This Adult Nursing - Patient Care and Wellbeing doesn't entitle you to practise as a professional in this specific field. What You Get Out Of Studying Adult Nursing - Patient Care and Wellbeing With Janets: Receive a digital Certificate upon successful completion of the Adult Nursing - Patient Care and Wellbeing course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Adult Nursing - Patient Care and Wellbeing training course is delivered through Janets' online learning platform. Access the Adult Nursing - Patient Care and Wellbeing content from any internet-enabled device whenever or wherever you want to. The Adult Nursing - Patient Care and Wellbeing course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Adult Nursing - Patient Care and Wellbeing course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Adult Nursing - Patient Care and Wellbeing course. After successfully passing the Adult Nursing - Patient Care and Wellbeing course exam, you will be able to apply for a CPD-accredited certificate as proof of your Adult Nursing - Patient Care and Wellbeing qualification. Certification All students who successfully complete the Adult Nursing - Patient Care and Wellbeing course can instantly download their digital certificate. You can also purchase a hard copy of the Adult Nursing - Patient Care and Wellbeing course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Adult Nursing - Patient Care and Wellbeing is ideal for those who already work in this sector or are an aspiring professional. This Adult Nursing - Patient Care and Wellbeing course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Adult Nursing - Patient Care and Wellbeing is open to all students and has no formal entry requirements. To study the Adult Nursing - Patient Care and Wellbeing course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Adult Nursing - Patient Care and Wellbeing is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Adult Nursing - Patient Care and Wellbeing and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Adult Nursing Introduction to Adult Nursing 00:05:00 Communication in Nursing 00:15:00 Communication Theories in Nursing 00:30:00 Health and Safety in Nursing 01:00:00 Psychology of Older Age The Main theories in Developmental Psychology 00:07:00 What is 'Gerontology'? 00:09:00 What we consider as 'old age' 00:09:00 What is 'ageing' and how it happens 00:08:00 Common stereotypes of older people 00:08:00 How stereotyping affects older people 00:08:00 Life stages and Theories 00:11:00 What do we look forward to in our older age? 00:06:00 Mental Health and Old Age Memory-related issues 00:12:00 Learning disabilities 00:08:00 Alzheimer's disease and Dementia 00:09:00 Chronic illness and Disabilities 00:08:00 Substance abuse (addictions) 00:06:00 Improving Health and Wellbeing The effects of exercising 00:09:00 Is it worth eating 'healthy' in older age? 00:09:00 What else affects 'health' and 'wellbeing'? 00:08:00 Caring for older people 00:06:00 Dementia Awareness Awareness and Misunderstanding 00:30:00 Symptoms of Dementia 01:00:00 Prevention and Treatment 01:00:00 The Impact Of Stigma 01:00:00 Caring for Dementia Victims 02:00:00 Home Adaptations for People with Dementia 01:00:00 Mock Exam Mock Exam - Adult Nursing - Patient Care and Wellbeing 00:20:00 Final Exam Final Exam - Adult Nursing - Patient Care and Wellbeing 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The User Experience (UX) Fundamentals Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with an acknowledged certificate. This User Experience (UX) Fundamentals Course consists of several modules that take around 5 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Introduction to User Expericne, UX Roles and how to be a UX Designer What Is UI 00:05:00 Can I be a Ux Designer-updated 00:03:00 Different Role of Ux Designer 00:06:00 Major Parts of Ux Design 00:05:00 Human Centered Design, Double Diamond Model of Design and Root Cause analysis Human Centered Design 00:03:00 DoudIbe Diamond 00:05:00 Root Cause Analysis 00:02:00 Seven Stages of Actions 00:05:00 Five second test firstusability test 00:02:00 Assignment 00:03:00 What is Agile UX 00:06:00 Principles & Concepts of User Experience, Usability and Interaction Design Affordance And Signfiers 00:06:00 Affordance And Signifiers-examples-fix-video 00:06:00 Afforadances explained headshot 00:05:00 Natural Mapping with examples 00:09:00 Mentalmodels conceptual models 00:06:00 Working Memory 00:06:00 Working Memory Example 00:07:00 Recognition And Recall 00:04:00 Recognition examples 00:07:00 User Expectations 00:04:00 User Expectations examples 00:08:00 User expectation headshot 00:02:00 Peripheral Vision 00:05:00 Peripheral Vision examples 00:07:00 Context of Use 00:05:00 Context of use headshot 00:02:00 Why-stakeholders are important 00:04:00 Information Architecture 00:05:00 Information Architecture Examples 00:11:00 Human Behavior Patterns, Decision making, scanning patterns and Change Blindness Humans Lazy Behavior decision Paralsis And Scanning 00:05:00 Human Decisions-Old And New Brain 00:03:00 Humans Hate Change 00:03:00 Our Goals And Change Blindness 00:03:00 Human behavior decision Paralysis hate change Examples 00:08:00 F-z Patterns Cart Abondomnment, Form Field Conversions 00:07:00 Designing for Humans - How to design better products for humans Discoverability 00:06:00 Discover assignment 00:01:00 Learability 00:04:00 Feedback-4.MP4 00:03:00 Feedback Within Context Walmart 00:03:00 Feedback examples 00:08:00 Constraints With Examples 00:06:00 Consistancy With Examples.mp4 00:06:00 Slips And Mistakes With Examples 00:04:00 Designing For Errors With Examples 00:04:00 User In Control with Examples 00:05:00 Grouping And chunking with Examples 00:04:00 Humans Have Limits 00:07:00 How Developers can improve User Experience? Using desgin patters dont reinvent the wheel 00:05:00 Dont let users think do heavy calculation yourself 00:08:00 Speed and Delays 00:06:00 Smart Defaults 00:06:00 Guiding And Training Users 00:04:00 Barriers To Entry 00:05:00 Natural Language with Examples 00:08:00 Natural Language Forms 00:03:00 Google Analytics 00:05:00 Notification 00:07:00 Anticipatory Desgin 00:04:00 Assignment Assignment - User Experience (UX) Fundamentals 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the How to Become a Tour Guide today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The How to Become a Tour Guide is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The How to Become a Tour Guide Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the How to Become a Tour Guide, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Introduction Welcome to the Course 00:02:00 Who am I? 00:02:00 What are You Going to Learn? 00:11:00 Section 02: The Tourism Industry Trends 00:04:00 Different Kinds of Jobs 00:11:00 Definition 00:01:00 Different Tour 00:01:00 Pay 00:04:00 Section 03: Engaging with Customer Who are Your Customers? 00:05:00 Creating Great Experiences 00:12:00 How I Got Hundreds of Five Star Review 00:07:00 Tips & Tricks 00:03:00 How to Get People Like You 00:07:00 Section 04: Public Speaking Easier than You Think 00:02:00 Charisma 00:10:00 Practical Exercise 00:05:00 Tips & Tricks 00:04:00 Voice Exercise 00:04:00 Section 05: What to Talk about on Tour What to Talk about 00:15:00 How to Prepare Quickly for New Destination 00:08:00 Use Your Own Interest 00:01:00 Where to Find Fun Information 00:02:00 Section 06: Finding a Job Different Kinds of Jobs 00:02:00 Different Kinds of Organisation 00:04:00 Different Kinds of Tourist 00:03:00 What Do You Want? 00:02:00 How to Improve Your Chances of Finding a Job 00:08:00 How to Create Experience 00:02:00 Example Cover Letter 00:03:00 Job Interviews 00:09:00 Section 07: Problems on the Roads Hospital and Injury 00:05:00 Change of Plants 00:03:00 How to Handle Customer Complains 00:01:00 Bad News 00:04:00 Difficult People 00:05:00 Finding Your Way 00:02:00 Section 08: Different Destination Dealing with Languages 00:05:00 Dealing with Tourism Professional 00:05:00 Different Cultures 00:04:00 Tips and Money 00:02:00 Commissions 00:04:00 Section 09: Starting You Own Tourism Business Pros and Cons 00:05:00 Roadmap to Success 00:07:00 How I Did It 00:03:00 How My Boss Did It 00:03:00 Section 10: Becoming a Local Guide What is the Job? 00:02:00 Local Laws 00:02:00 Learn Your History 00:03:00 Learn by Doing 00:01:00 Make Connection 00:02:00 Section 11: Your First Trip Checklist What to Take 00:02:00 Meeting the Group 00:02:00 Introducing Yourself 00:02:00 First Info 00:02:00 Tour Busses 00:02:00 Checking into a Hotel 00:02:00 Dinner 00:01:00 Normal Days 00:06:00 Last Day 00:02:00 Section 12: Crash Course in Art History Classical Culture 00:06:00 Middle Ages 00:06:00 Symbolism 00:05:00 Renaissance 00:05:00 Baroque 00:09:00 Neoclassicism 00:02:00 Romanticism 00:03:00 From Impressionism to Now 00:06:00 Section 13: Creating Websites and Advertising Easy Way to Start a Website 00:04:00 Search Engine Optimisation 00:04:00 Booking System 00:02:00 Advertising 00:02:00 Review Sites 00:02:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The focus of this UX Design course is to introduce you to User Experience (UX) Design and design artefacts that enable you to meet your need in the most effective, practical and satisfying manner. Through this course, step up your skills in UX research if you want to be taken seriously as a UX designer. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Introduction to User Expericne, UX Roles and how to be a UX Designer What Is UI FREE 00:05:00 Can I be a Ux Designer-updated 00:03:00 Different Role of Ux Designer 00:06:00 Major Parts of Ux Design 00:05:00 Human Centered Design, Double Diamond Model of Design and Root Cause analysis Human Centered Design 00:03:00 DoudIbe Diamond 00:05:00 Root Cause Analysis 00:02:00 Seven Stages of Actions 00:05:00 Five second test firstusability test 00:02:00 06. Assignment 00:03:00 What is Agile UX 00:06:00 Principles & Concepts of User Experience, Usability and Interaction Design Affordance And Signfiers 00:06:00 Affordance And Signifiers-examples-fix-video 00:06:00 Afforadances explained headshot 00:05:00 Natural Mapping with examples 00:09:00 Mentalmodels conceptual models 00:06:00 Working Memory 00:06:00 Working Memory Example 00:07:00 06. Recognition And Recall 00:04:00 Recognition examples 00:07:00 User Expectations 00:04:00 User Expectations examples 00:08:00 User expectation headshot 00:02:00 Peripheral Vision 00:05:00 Peripheral Vision examples 00:07:00 Context of Use 00:05:00 Context of use headshot 00:02:00 Why-stakeholders are important 00:04:00 Information Architecture 00:05:00 Information Architecture Examples 00:11:00 Human Behavior Patterns, Decision making, scanning patterns and Change Blindness Humans Lazy Behavior decision Paralsis And Scanning 00:05:00 Human Decisions-Old And New Brain 00:03:00 Humans Hate Change 00:03:00 Our Goals And Change Blindness 00:03:00 Human behavior decision Paralysis hate change Examples 00:08:00 F-z Patterns Cart Abondomnment, Form Field Conversions 00:07:00 Designing for Humans - How to design better products for humans Discoverability 00:06:00 Discover assignment 00:01:00 Learability 00:04:00 Feedback-4.MP4 00:03:00 Feedback Within Context Walmart 00:03:00 Feedback examples 00:08:00 Constraints With Examples 00:06:00 Consistancy With Examples.mp4 00:06:00 Slips And Mistakes With Examples 00:04:00 Designing For Errors With Examples 00:04:00 User In Control with Examples 00:05:00 Grouping And chunking with Examples 00:04:00 Humans Have Limits 00:07:00 How Developers can improve User Experience? Using desgin patters dont reinvent the wheel 00:05:00 Dont let users think do heavy calculation yourself 00:08:00 Speed and Delays 00:06:00 Smart Defaults 00:06:00 Guiding And Training Users 00:04:00 Barriers To Entry 00:05:00 Natural Language with Examples 00:08:00 Natural Language Forms 00:03:00 Google Analytics 00:05:00 Notification 00:07:00 Anticipatory Desgin 00:04:00 Mock Exam Final Exam Assignment Assignment - UX Design 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Embark on a journey through Hydroponic Horticulture. From system design to pest management, this course provides a comprehensive understanding of hydroponic farming, ensuring you’re equipped with the knowledge for successful cultivation and business operations.

Master video editing with our Filmora 12 & VideoScribe course. From basic techniques to advanced features, transform your content into professional-grade videos. Perfect for aspiring editors and content creators.

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