9625 Courses in Cardiff delivered Online

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Speech Therapy: Speech Therapy Training Online Embark on a transformative journey with our Speech Therapy: Speech Therapy course, where Speech Therapy: Speech Therapy takes center stage in every module. Explore the intricate nuances of Speech Therapy: Speech Therapy, mastering essential techniques for effective communication enhancement. With Speech Therapy: Speech Therapy as the guiding principle, our Speech Therapy course ensures a comprehensive understanding of speech disorders and their therapeutic interventions. Delve deep into Speech Therapy strategies, equipping yourself with the skills needed to make a difference. This Speech Therapy: Speech Therapy course is more than just a learning experience; it's a pathway to expertise. Elevate your proficiency in Speech Therapy and unlock a world of opportunities. Enroll now and embrace the empowering realm of Speech Therapy: Speech Therapy with confidence! Discover the transformative power of our Speech Therapy: Speech Therapy course, where Speech Therapy: Speech Therapy expertise is woven seamlessly into every aspect of learning. Unleash the potential of Speech Therapy as you delve into specialized modules tailored for comprehensive understanding. With Speech Therapy: Speech Therapy at the forefront, master essential techniques and interventions for effective communication enhancement. Elevate your proficiency with Speech Therapy: Speech Therapy strategies that make a lasting impact. This course is not just about Speech Therapy; it's a holistic journey towards expertise. Enroll now to navigate the dynamic landscape of Speech Therapy confidently. Shape your future with Speech Therapy: Speech Therapy excellence-don't miss this opportunity to advance your skills and make a meaningful difference! Transform lives with our Speech Therapy: Speech Therapy course! Master the art of communication through our Speech Therapy: Speech Therapy program. Unlock the power of Speech Therapy: Speech Therapy techniques for effective interventions. Elevate your skills with our Speech Therapy: Speech Therapy course-your gateway to making a difference. Enroll now and embark on a fulfilling journey in Speech Therapy: Speech Therapy! Why Choose This Speech Therapy: Speech Therapy Course from Us Self-paced Speech Therapy course, access available from anywhere. Speech Therapy Course developed by industry experts. Free PDF certificate as soon as completing the Speech Therapy course. Special Offers of this Speech Therapy: Speech Therapy Course This Speech Therapy: Speech Therapy Course includes a FREE PDF Certificate. Lifetime access to this Speech Therapy: Speech Therapy Course Instant access to this Speech Therapy: Speech Therapy Course Get FREE Tutor Support from Monday to Friday in this Speech Therapy: Speech Therapy Course [ Note: Free PDF certificate as soon as completing the Speech Therapy: Speech Therapy Training course] Speech Therapy: Speech Therapy Training Industry Experts Designed this Speech Therapy: Speech Therapy Training course into 04 detailed modules. Assessment Method of Speech Therapy Training After completing each module of the Speech Therapy: Speech Therapy Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Speech Therapy Training After completing the MCQ/Assignment assessment for this Speech Therapy: Speech Therapy Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Speech Therapy: Speech Therapy Training This Speech Therapy: Speech Therapy Training course is for anyone Requirements Speech Therapy: Speech Therapy Training Students who intend to enrol in this Speech Therapy: Speech Therapy course must meet the following requirements: Speech Therapy: Good command of the English language Speech Therapy: Must be vivacious and self-driven Speech Therapy: Basic computer knowledge Speech Therapy: A minimum of 16 years of age is required Career path Speech Therapy: Speech Therapy Training Compete High provides the most expedient path to learning about Speech Therapy: Speech Therapy Training, as well as the opportunity to practice your skills in a corporate setting. Certificates Certificate of completion Digital certificate - Included

Psychiatry course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Psychiatry. Our course starts with the basics of Psychiatry and gradually progresses towards advanced topics. Therefore, each lesson of this Psychiatry is intuitive and easy to understand. So, stand out in the job market by completing the Psychiatry course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Psychiatry course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown Module 01: Introduction to Mental Health Module 02: Mental Health and Disorder Module 03: Psychiatry Training Module 04: Reasons and Outcomes of Psychiatric Disorder Module 05: Psychiatric Disorder in Children, Adolescents and Adults Module 06: Common Psychiatric Disorders Module 07: Stress and Anxiety Disorder Module 08: Personality Disorder Module 09: Schizophrenia Module 10: Treatment Methods Module 11: Providing Mental Health Support Module 12: Legislations about Mental Health CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Psychiatry course. Requirements To enrol in this Psychiatry course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Psychiatry. Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 Outside of the UK: £9.99 CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Tired of pests running the show? Our Methods of Pest Control course delivers sharp, straight-talking knowledge on how to identify, understand, and manage pests like a seasoned pro—minus the fluff. With structured modules covering everything from common infestations to strategic control methods, this course offers clear insight for anyone keen to master the science behind pest management. No gimmicks, just solid, actionable theory. Delivered entirely online, it’s tailored for those who prefer learning with flexibility—no need to leave your seat or suit up in overalls. Whether you're working in facilities, property care, food services, or you're just fed up with unwelcome guests, this course breaks it all down with clarity, purpose, and a touch of dry wit. Expect logical content, smart delivery, and a focus on real solutions—not recycled jargon. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Pest Control Module 02 : Different Types of Pests Module 03 : Insects and Mites Anatomy and Prevention Module 04 : Weeds Control Module 05 : Pesticide Formulations (Liquid and Dry) Module 06 : Pesticide Formulations and Adjuvants Module 07 : Plant Diseases and Disorders Module 08 : Pest Management Methods and IPM Module 09 : Pesticide Application Module 10 : Environmental Impacts of Pest control Module 11 : Regulations of Pest Control in the UK Learning Outcomes: Identify and classify various pest types for targeted control. Understand the anatomy of insects and mites to develop prevention strategies. Implement effective weed control measures to protect crops. Differentiate between liquid and dry pesticide formulations for precise application. Evaluate the environmental impacts of pest control techniques. Comply with UK regulations governing pest control practices. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Agricultural professionals and farmers Gardeners and horticulturists Environmental enthusiasts Pest control technicians Students pursuing agricultural studies Anyone interested in sustainable pest management Career path Pest Control Technician Agricultural Advisor Horticulturalist Environmental Consultant Crop Protection Specialist Pest Control Manager Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Develop essential critical thinking and problem-solving skills with our comprehensive guide. Enhance your ability to analyze, evaluate, and solve complex challenges. Unlock a powerful toolkit for success in academics, professional endeavors, and everyday life. Explore practical strategies and gain a competitive edge in decision-making. Elevate your cognitive abilities with this indispensable resource for personal and professional growth.

Domestic Violence and Abuse Awareness Diploma Course Online Unlock the Power of Domestic Violence and Abuse Awareness Diploma Course: Enrol Now! Domestic violence is often overlooked as it takes place behind closed doors and is a social taboo that is rarely discussed. This must be stopped, and raising awareness, education, and intervening at the earliest stages are the most effective ways to address this issue. This Domestic Violence and Abuse Awareness Diploma Course will provide you with a thorough understanding of domestic violence and abuse, as well as who is most vulnerable and how to assist both adult and child victims. The Domestic Violence and Abuse Awareness Diploma Course discusses the physical, mental and emotional impact that domestic abuse and violence have on victims. In this Domestic Violence and Abuse Awareness Diploma, you'll look at the barriers and unique challenges that some abuse victims face, the long-term repercussions, how financial abusers maintain control over their victims even after separation, and the impact domestic abuse can have on society, both socially and financially. Domestic abuse has devastating effects on children, whether they are the direct target of the abuse. In this Domestic Violence and Abuse Awareness Diploma Course, you'll learn about the various types of abuse a child may face, what warning signs to look for, and the long-term physical and mental health effects abuse has on children at various stages of development. Main Course: Domestic Violence and Abuse Awareness Diploma Course Free Courses included with Domestic Violence and Abuse Awareness Diploma Course Course 01: Level 2 Certificate in Awareness of Mental Health Problems Course 02: Drug and Alcohol Awareness Training Course 02: Level 2 Award in Suicide Awareness [ Note: Free PDF certificate as soon as completing the Domestic Violence and Abuse Awareness Diploma course] Domestic Violence and Abuse Awareness Diploma Course Online This Domestic Violence and Abuse Awareness Diploma Course consists of 10 modules. Course Curriculum of Domestic Violence and Abuse Awareness Diploma Course Module 01: An Overview of Domestic Violence & Abuse Module 02: Understanding the Dynamics of Domestic Violence Module 03: How Does Domestic Abuse and Violence Begin Module 04: The Impact of Domestic Violence on Victims Module 05: The Impact of Domestic Violence on Children & Young People Module 06: Assessing the Risks of Domestic Violence and Abuses on Children Module 07: Helping Children Recover from Domestic Module 08: The Ways of Supporting the Victim and Reporting Incidents Module 09: Understanding the Process of Record Keeping Module 10: Working with Victims of Domestic Abuse Assessment Method of Domestic Violence and Abuse Awareness Diploma Course After completing Domestic Violence and Abuse Awareness Diploma Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Domestic Violence and Abuse Awareness Diploma Course After completing the Domestic Violence and Abuse Awareness Diploma course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Domestic Violence and Abuse Awareness Diploma Course Online This Domestic Violence and Abuse Awareness Diploma Course is ideal for anyone who works or wants to work with vulnerable people, especially if you work or volunteer in domestic violence. Requirements Domestic Violence and Abuse Awareness Diploma Course Online To enrol in this Domestic Violence and Abuse Awareness Diploma Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Domestic Violence and Abuse Awareness Diploma Course. Be energetic and self-motivated to complete our Domestic Violence and Abuse Awareness Diploma Course. Basic computer Skill is required to complete our Domestic Violence and Abuse Awareness Diploma Course. If you want to enrol in our Domestic Violence and Abuse Awareness Diploma Course, you must be at least 15 years old. Career path Domestic Violence and Abuse Awareness Diploma Course Online

Behaviour Management: Behaviour Management Course Online This Behaviour Management: Behaviour Management Course is ideal for practitioners, parents, and other adults who want to help and support children with behaviour management and understand why children misbehave. This Behaviour Management: Behaviour Management Course provides learners with a thorough understanding of factors affecting behaviour, learning styles, the role of the adult and positive behaviour strategies. By the end of this Behaviour Management: Behaviour Management Course, the learner will know why children misbehave and how to effectively plan for their needs and learning styles. Learning Outcomes Of Behaviour Management: Behaviour Management Course After completing this Behaviour Management: Behaviour Management Course, learner will be able to: Understand factors affecting behaviours Gain a solid understanding of learning styles Understand the role of the adult Understand positive behaviour strategies in the early years Main Course: Level 2 Behaviour Management in the Early Years Course Courses including with this Behaviour Management: Behaviour Management Course bundle. Course 01: Level 4 Diploma in Child Counselling Course 02: Introduction to Psychology Course 03: Level 2 Award in Preparation for the Responsibilities of Parenting Course 04: Level 4 Diploma in Child Psychology Special Offers of this Behaviour Management: Behaviour Management Course: This Behaviour Management: Behaviour Management Course includes a FREE PDF Certificate. Lifetime access to this Behaviour Management: Behaviour Management Course Instant access to this Behaviour Management: Behaviour Management Course 24/7 Support Available to this Behaviour Management: Behaviour Management Course [ Note: Free PDF certificate as soon as completing the Behaviour Management: Behaviour Management Course] Behaviour Management: Behaviour Management Course Online This Behaviour Management: Behaviour Management Course consists of 04 modules. Course Curriculum of Behaviour Management: Behaviour Management Course Module 01: Factors Affecting Behaviours Module 02: Learning Styles Module 03: The Role of the Adult Module 04: Positive Behaviour Strategies Certification of Behaviour Management: Behaviour Management Course After completing the Behaviour Management: Behaviour Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Behaviour Management: Behaviour Management Course After completing Behaviour Management: Behaviour Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Behaviour Management: Behaviour Management Course Online This Behaviour Management: Behaviour Management Course is suitable for: Well-being and emotional needs coordinator Practitioners Adults interested in the well-being and emotional needs of young children. Childminders Requirements Behaviour Management: Behaviour Management Course Online To enroll in this Behaviour Management: Behaviour Management Course, students must fulfill the following requirements: Good Command over English language is mandatory to enrol in our Behaviour Management: Behaviour Management Course. Be energetic and self-motivated to complete our Behaviour Management: Behaviour Management Course. Basic computer Skill is required to complete our Behaviour Management: Behaviour Management Course. If you want to enrol in our Behaviour Management: Behaviour Management Course, you must be at least 15 years old. Career path Behaviour Management: Behaviour Management Course Online This Behaviour Management: Behaviour Management Course may lead you to a variety of career opportunities. Such as: Nursery nurse Child practitioner Level 4 Diploma in Child Psychology Childminder Teacher Youth work

Play Therapy: Play Therapy, CBT, ADHD, Dyslexia, Autism & SEN Teaching Assistant Course Do you want to understand the emotional and psychological changes in children? If so then you should join our Play Therapy: Play Therapy Course to understand the world of therapeutic play challenges. This Play Therapy: Play Therapy Course is prepared to provide the basics of play therapy. Also, this Play Therapy Training provides an explanation of the positive effects and achievements of play therapy. Moreover, the Play Therapy Training explains the theoretical foundation, setting arrangements and how to handle typical issues as a Play Therapy Training expert. Not only these but other modules of Play Therapy Training teach how to support children and help them to recover from disasters. Enrol in our Play Therapy: Play Therapy Course to meaningfully assist in children's recovery and development! Main Course: Play Therapy Course Courses you will get along with this Play Therapy: Play Therapy Course: Play Therapy Course Offers free Cognitive Behavioural Therapy Course Play Therapy Course Offers free ADHD Awareness Course Play Therapy Course Offers free Autism Training Course Play Therapy Course Offers free SEN Teaching Assistant Course Play Therapy Course Offers free Dyslexia Course [ Note: Free PDF certificate as soon as completing the Play Therapy: Play Therapy Course] Play Therapy: Play Therapy, CBT, ADHD, Dyslexia, Autism & SEN Teaching Assistant Course This Play Therapy: Play Therapy Course consists of 09 modules. Course Curriculum of Play Therapy: Play Therapy Course Module 01: Exploring the Concept of Play Therapy Module 02: Positive Effects and Achievements in Play Therapy Module 03: Theoretical Foundations of Play Therapy Techniques Module 04: The Play Settings: Therapist, Abused Child, and Materials Module 05: Typical Issues in Play Therapy Module 06: Play Therapy for Emotionally Abused Children Module 07: Play Therapy for Children Who Are Homeless Module 08: Creative Play Interventions for Disaster Recovery Module 09: Case Studies and Recent Trends in Play Therapy Assessment Method of Play Therapy: Play Therapy Course After completing Play Therapy: Play Therapy Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Play Therapy: Play Therapy Course After completing the Play Therapy: Play Therapy Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Play Therapy: Play Therapy, CBT, ADHD, Dyslexia, Autism & SEN Teaching Assistant Course Anyone interested in enhancing their abilities and preparing for their dream career can enrol in our Play Therapy: Play Therapy Course Training! Requirements Play Therapy: Play Therapy, CBT, ADHD, Dyslexia, Autism & SEN Teaching Assistant Course To enrol in this Play Therapy, CBT, ADHD, Autism & SEN Teaching Assistant Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Play Therapy: Play Therapy Course. Be energetic and self-motivated to complete our Play Therapy: Play Therapy Course. Basic computer Skill is required to complete our Play Therapy: Play Therapy Course. If you want to enrol in our Play Therapy: Play Therapy Course, you must be at least 15 years old. Career path Play Therapy: Play Therapy, CBT, ADHD, Dyslexia, Autism & SEN Teaching Assistant Course This Play Therapy: Play Therapy Course can assist you in getting a lucrative job as a Play Therapist, Child Psychologist, Play Therapy Training specialist or School Counselor with Play Therapy Training expertise.

Start Your Happiness Journey with Our Free Bonus Course Today! Join our Happiness Bonus Course and discover scientifically backed practices to cultivate joy, resilience, and well-being. Dive into modules covering neurotransmitters, mindfulness, gratitude, self-compassion, ACT, and more. Create your personalized happiness plan and balance peace, play, and purpose in your life. Don't wait for one day, start today! #HappinessCourse #Mindfulness #WellBeing #SelfCompassion #Resilience #Gratitude #ACT #Joy #MentalHealth #FreeCourse

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00