3449 Courses in Cardiff delivered On Demand

Provide assistance and comfort to injured athletes and martial artists. By taking this Martial Arts First Aid course, you will realise that Martial Arts activities have their own set of challenges and common injuries due to their reliance on muscles and bones. This can result in potentially painful wounds or life-threatening injuries, but after completing this exclusive Martial Arts First Aid training, you will be fully prepared to help casualties. Through this Martial Arts First Aid course, you will quickly learn how to identify and treat all associated injuries. This Martial Arts First Aid course teaches professional methods for preserving life and safety in the event of an accident or crisis. You will learn how to stabilise the situation before medical personnel arrive, as well as how to relieve pain and distress. It is a fantastic way to support the Martial Arts industry while also contributing to the community. Why choose this Martial Arts First Aid course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Learning Outcomes After completing this Martial Arts First Aid course, the learner will be able to: Understand the basics of Martial Arts First Aid. Know how to carry out an emergency First Aid Kit. Gain in-depth knowledge of CPR & recovery positions. Gain a solid understanding of common injuries such as ear injuries, dental injuries, choking, fainting, etc. Recognise Medical Emergencies. Know how to prevent injury. Know how to keep health records. Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Martial Arts First Aid course. Who is this course for? This Martial Arts First Aid course is ideal for any potential First Aider who wishes to provide medical assistance to those who practice any form of Martial Arts. This could also be useful for instructors or practitioners. Requirements There are no particular requirements for this Martial Arts First Aid course because it doesn't call for any specialized training.

Unlock your creative potential with our Interior Design Masterclass: Concepts and Creativity. Dive into the art of space planning, color theory, sustainable design, and more. Elevate your skills with practical knowledge, digital tools, and professional insights. Join us for a transformative journey into the world of interior design.

Unlock the power of coding with our all-inclusive Ruby course. Whether you're starting from scratch or elevating your programming skills, this course is tailored for a seamless learning curve in Ruby 3.2.

Delve into the art of storytelling across time, language, and culture with our Comparative Literature Exploration Course. This online learning journey opens a window into the minds of celebrated authors, thinkers, and poets from around the globe, while drawing thoughtful parallels between their works. With a focus on analysis, interpretation and context, this course offers a deeper appreciation of how literature connects humanity—regardless of where or when it was written. You’ll explore major themes, literary movements and stylistic approaches that have shaped written expression across centuries. Whether you're drawn to epic verse, modern novels or philosophical prose, this course encourages a fresh perspective on global literature through comparative reading. Ideal for literature lovers, aspiring critics, or anyone with a curious mind, it’s a rewarding way to read between the lines and see familiar texts in entirely new light. Key Features of Comparative Literature Exploration course: 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 of Comparative Literature Exploration Course: Module 01: Introduction to Comparative Literature Module 02: Literary Theory and Comparative Analysis Module 03: Epic Tales Across Cultures Module 04: Love, Identity, and Magical Realism Module 05: Literary Movements and Themes Module 06: Comparative Study of Literary Genres Module 07: Regional Focus Literature from Asia and Africa Module 08: Postcolonial and Contemporary Global Voices Learning Outcomes of Comparative Literature Exploration: Analyze diverse literary traditions, identifying universal storytelling elements for cross-cultural insights. Apply literary theory, honing skills in nuanced comparative analysis of diverse texts. Explore epic tales across cultures, deciphering commonalities in heroic narratives. Examine themes of love, identity, and magical realism in global literature. Trace the evolution of literary movements and identify recurring thematic patterns. Conduct a comparative study of varied literary genres, understanding their distinctive features. Accreditation This Comparative Literature Exploration 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. Certificate After completing this Comparative Literature Exploration course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Literature enthusiasts seeking a global perspective on storytelling. Students interested in exploring diverse cultural narratives and literary traditions. Individuals curious about the intersection of love, identity, and magical realism. Readers wanting to comprehend the evolution of literary movements and themes. Those intrigued by the craft of storytelling and eager to explore genres. Career path Comparative Literature Researcher Literary Analyst Cultural Content Curator Editorial Consultant International Literature Educator Cross-Cultural Communications Specialist 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.

Overview The need for trained Adult Nursing professionals is growing fast in the UK. Right now, the NHS has a shortage of over 40,000 nurses, and most of these are in Adult Nursing. This means there are many job opportunities for people who are ready to learn and work in this field. Our Adult Nursing course is made to give you the right skills and knowledge to start or grow your career in healthcare. You will learn the basics of Adult Nursing, including how to give medicines, prevent infections, and help patients move safely. The course also teaches important daily care tasks like hygiene, nutrition, and oxygen support. Everything is taught with a strong focus on legal and ethical rules, so you know how to work safely and respectfully with every patient. This course helps you become confident in both your technical skills and your caring approach. Adult Nursing is a key part of the healthcare system. Whether in hospitals, care homes, or the community, Adult Nursing staff play a big role in patient care and recovery. By learning the core duties and responsibilities, as well as how Adult Nursing connects with wider health and social care, you’ll be ready to support others in need. This course prepares you to make a real difference in people’s lives while building a stable and meaningful career. Learning Outcomes By the end of this Adult Nursing course, you will be able to: Understand key nursing practices used in different healthcare settings Follow legal rules and ethical standards in your daily work Communicate clearly and kindly with patients and team members Use proper hygiene and infection control methods Support patients with needs like eating, moving, and managing pain Apply health and social care values in your nursing work Who is this Course For? Healthcare assistants who want to move forward in their careers and learn more about adult nursing and patient care People working in other areas of healthcare who want to switch to nursing and need a strong base in adult nursing Care workers who want a better understanding of professional care standards, the law, and ethical care Support workers in hospitals, care homes, or clinics who want to improve their skills in giving medicine, handling infections, and helping patients move Anyone in health and social care aiming for career growth and needing to understand safeguarding and key care principles Process of Evaluation After studying the Adult Nursing Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Adult Nursing Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Adult Nursing course. Career Path This Adult Nursing course can lead to roles such as: Adult Nurse – £25,000 to £39,000 per year Healthcare Assistant – £20,000 to £27,000 per year Care Coordinator – £23,000 to £30,000 per year Community Support Worker – £21,000 to £28,000 per year Rehabilitation Assistant – £22,000 to £29,000 per year Course Curriculum Adult Nursing Module 1: Introduction to Nursing 00:17:00 Module 2: Working in Different Healthcare Settings 00:15:00 Module 3: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 00:52:00 Module 4: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 00:50:00 Module 5: Effective Communication in Nursing 00:47:00 Module 6: Health and Safety in Nursing 00:47:00 Module 7: Hygiene in Nursing 00:30:00 Module 8: Infection Control 00:57:00 Module 9: Asepsis in Nursing 00:16:00 Module 10: Medication Administration in Nursing 00:18:00 Adult Care in Different Life Stages 00:17:00 Module 12: Understanding Immune System in Nursing 00:28:00 Module 13: Rest and Sleep Management in Nursing 00:19:00 Module 14: Mobility and Immobility Issues of Patients in Nursing 00:17:00 Module 15: Pain Management for Nurses 00:24:00 Module 16: Nutrition in Nursing 00:25:00 Module 17: Fluid and Electrolyte Balance 00:23:00 Module 18: Assisting with Elimination 00:30:00 Module 19: Oxygenation in Nursing 00:30:00

Overview of Art Therapy Course Art therapy is becoming more popular as people understand the importance of mental health. In the UK, over 1.6 million people receive psychological therapies through the NHS every year. Our Art Therapy Course is designed to help learners use art to support people who are dealing with trauma, anxiety, or emotional stress. This course shows how creative activities can help people feel better and find new ways to express themselves. The Art Therapy Course covers many useful topics. You will learn how the brain works, how art affects emotions, and how to support children, adults, and families through creative methods. The course also includes mindful art techniques, reflective writing, and therapeutic drawing. These tools are used by professionals to help people open up and feel calm. With this course, you can learn how colour, shapes, and drawing can support mental wellbeing. In the UK, the demand for art therapists is growing. Private sessions can cost between £50 and £120 an hour. After finishing the Art Therapy Course, you can work in schools, the NHS, care homes, or even run your therapy sessions. This Art Therapy Course helps you build a strong foundation to support others through creativity. Whether you're starting a new career or adding to your skills, the Art Therapy Course is a great way to learn how art can heal. Learning Outcomes By the end of this Art Therapy Course, learners will be able to: Understand the basic ideas behind art therapy and how it connects to mental health. Use simple brain science to guide helpful creative therapy sessions. Try mindful art techniques using colour and creative expression. Apply art therapy with children, adults, and families in different situations. Use drawing and reflective writing to support emotional healing. Plan and design full art therapy sessions for different groups. Who is this course for? This Art Therapy Course is for anyone who wants to use creativity to support others: Healthcare workers who want to bring creative ways to help patients deal with stress, trauma, or emotional struggles. Teachers and school staff who want to use art therapy to support students with stress, behaviour, or emotional needs. Care workers in community centres, care homes, or hospices who want to help people through creative and calming activities. Anyone interested in mental health and creativity, who wants to use art therapy for personal or family wellbeing. People changing careers who are thinking about working in mental health and want a strong starting point. Process of Evaluation After studying the Art Therapy Course Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Art Therapy Course Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the Art Therapy course. Career Path Completing this Art Therapy Course can lead to many rewarding roles, such as: Art Therapist – £25,000 to £45,000 a year Mental Health Support Worker – £18,000 to £28,000 a year Therapeutic Activities Coordinator – £20,000 to £32,000 a year Community Wellbeing Facilitator – £22,000 to £35,000 a year Children’s Art Therapy Assistant – £19,000 to £30,000 a year Course Curriculum: Module 01: Introduction to Art Therapy Introduction to Art Therapy 00:17:00 Module 02: Art Therapy: Psychology and Neuroscience Art Therapy: Psychology and Neuroscience 00:18:00 Module 03: Art Therapy in Practice Art Therapy in Practice 00:18:00 Module 04: Creative Therapy Creative Therapy 00:14:00 Module 05: Mindful Creativity: Colour and Creation Mindful Creativity: Colour and Creation 00:17:00 Module 06: Art Therapy Techniques and Applications Art Therapy Techniques and Applications 00:34:00 Module 07: Using Mindfulness in Art Therapy Using Mindfulness in Art Therapy 00:26:00 Module 08: Drawings Drawings 00:35:00 Module 09: Reflective Writing Reflective Writing 00:22:00 Module 10: Art Therapy for Children Art Therapy for Children 00:21:00 Module 11: Art Therapy for Adults Art Therapy for Adults 00:18:00 Module 12: Art Therapy for Family Art Therapy for Family 00:33:00 Module 13: Illness and Art Illness and Art 00:15:00 Module 14: The Art Therapist The Art Therapist 00:20:00

You will learn how to develop reliable and scalable serverless applications, following the microservices architecture. We will develop event-driven microservices with AWS serverless services that come with the power of the cloud, high availability and high scalability by nature following serverless design patterns and best practices.

The Nursing & Midwifery Mini Bundle is a must-have for anyone ready to break into the fast-moving, high-impact world of healthcare. Whether you're aiming for hospitals, maternity clinics, ambulance services, or community health roles, this bundle delivers unmatched relevance. With Nursing, Paediatric First Aid, Neonatal Nursing, Paramedic Training, and First Aid packed into one focused program, you're not just learning—you’re becoming hireable. This bundle was built to align with frontline recruitment trends and help you stand out now, not someday. Description Professionals trained in Nursing, Paediatric First Aid, Neonatal Nursing, Paramedic Training, and First Aid are in constant demand—and this bundle puts you right in the hiring line. Healthcare recruiters need people who bring a multi-skilled profile, not just a single qualification. That’s why this compact yet complete bundle blends Nursing with critical-care qualifications like Neonatal Nursing, Paramedic Training, and both First Aid and Paediatric First Aid. The truth? Waiting longer to get your foot in the door only gives others the edge. This is your chance to enter Nursing, explore Neonatal Nursing, apply for Paediatric First Aid roles, and even be considered for emergency support positions needing Paramedic Training or First Aid accreditation. And because you get all five in one, your CV starts where most others end. FAQ Q: What kind of jobs can I apply for with this bundle? A: Roles across Nursing, Neonatal Nursing, First Aid, Paramedic Training, and Paediatric First Aid, including nursing assistant, paramedic aide, and maternal health support. Q: Will this help me stand out to employers? A: Absolutely. Employers love seeing skills in Nursing, Paediatric First Aid, Neonatal Nursing, Paramedic Training, and First Aid combined in one candidate. Q: Do I need experience to benefit from this bundle? A: No experience is needed. Whether you're starting out or switching paths, this bundle introduces you to all five key areas. Q: Can I use this to work in emergency care? A: Definitely. With Paramedic Training, First Aid, and Paediatric First Aid included, you're covering essential emergency-readiness requirements. Q: Why is this bundle better than individual courses? A: Instead of five separate enrolments, this bundle gives you Nursing, Neonatal Nursing, First Aid, Paediatric First Aid, and Paramedic Training—all in one place, for one price. Q: How fast can I start applying for jobs? A: Many candidates begin job hunting as soon as they complete their Nursing, First Aid, and Paramedic Training segments—don’t wait.

If you’re ready to step into one of the most reliable and respected roles in healthcare, the Diploma in Phlebotomy Mini Bundle was built for you. With a targeted mix of Phlebotomy, Nursing, Administrative Assistant, Health and Social Care, and Public Health, this bundle gives you the edge to break into clinical, support, and patient-focused roles across hospitals, clinics, and care homes. Description Healthcare is one of the most stable and rewarding industries worldwide—and this bundle brings together the key skills to help you succeed in it. At the forefront is Phlebotomy. The ability to support medical teams through blood collection and lab coordination is essential in both public and private sectors. Skilled Phlebotomy professionals are always in demand. Strong Phlebotomy skills often open the door to broader opportunities in Nursing. Whether you're looking to transition into Nursing or simply work alongside nurses, having a solid understanding of Nursing makes you more effective and employable in any healthcare setting. But clinical skills alone aren’t enough. That’s where Administrative Assistant training becomes vital. Efficient and organized Administrative Assistant professionals are the backbone of any medical office. With Administrative Assistant know-how, you’re not just helping patients—you’re making the system work. The broader view of care is covered under Health and Social Care. Employers need staff who understand holistic patient needs. Health and Social Care experience is especially valuable in roles that blend emotional intelligence with technical competence. Finally, you can’t ignore the importance of Public Health. Understanding Public Health trends, community health issues, and prevention strategies makes you a more well-rounded professional. Roles in Phlebotomy, Nursing, and Health and Social Care increasingly require Public Health awareness. From hospitals to home care, this bundle makes you stand out in roles where empathy meets skill. With all five areas—Phlebotomy, Nursing, Administrative Assistant, Health and Social Care, and Public Health—you’re getting a job-ready foundation without the job-seeking frustration. FAQ Q: What careers can this bundle help me get into? A: Phlebotomist, Healthcare Assistant, Nursing Support Worker, Clinical Administrator, and Public Health Support roles. All of these value Phlebotomy, Nursing, Administrative Assistant, Health and Social Care, and Public Health. Q: Do I need a medical background to benefit? A: No. This bundle is a perfect starting point for anyone interested in Phlebotomy, Nursing, Administrative Assistant, Health and Social Care, and Public Health careers. Q: Is this bundle a good entry point into healthcare? A: Yes. It’s an ideal introduction to Phlebotomy, Nursing, Administrative Assistant, Health and Social Care, and Public Health, making you a strong candidate in both public and private sectors.

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