47232 Courses in Bristol delivered On Demand

Overview This Criminology Diploma course will unlock your full potential and will show you how to excel in a career in Criminology Diploma. So upskill now and reach your full potential. Everything you need to get started in Criminology Diploma is available in this course. Learning and progressing are the hallmarks of personal development. This Criminology Diploma will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Criminology Diploma skills to help you advance your career. Acquire a comprehensive understanding of various Criminology Diploma topics and tips from industry experts. Learn in-demand Criminology Diploma skills that are in high demand among UK employers, which will help you to kickstart your career. This Criminology Diploma course covers everything you must know to stand against the tough competition in the Criminology Diploma field.  The future is truly yours to seize with this Criminology Diploma. Enrol today and complete the course to achieve a Criminology Diploma certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Criminology Diploma course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Criminology Diploma course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Criminology Diploma course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Criminology Diploma is suitable for anyone aspiring to start a career in Criminology Diploma; even if you are new to this and have no prior knowledge on Criminology Diploma, this course is going to be very easy for you to understand.  And if you are already working in the Criminology Diploma field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Criminology Diploma course is a win-win for you in all aspects.  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 This Criminology Diploma course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Criminology Diploma 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 Criminology Diploma course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Criminology Diploma Module 01: Introduction to Criminology and Profiling 00:23:00 Module 02: Classification of Crime 00:18:00 Module 03: Violent Crimes 00:29:00 Module 04: The Crime Scene 00:30:00 Module 05: Dealing with Crime 00:41:00 Module 06: Understanding Criminal Psychology 00:31:00 Module 07: Forensic Science 00:35:00 Module 08: Phases of Profiling 00:33:00 Module 09: Criminal Profiling: Science, Logic and Metacognition 00:28:00 Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice 00:22:00 Module 11: Victimology 00:25:00 Module 12: The Criminal Justice System in England and Wales 00:19:00

Overview As healthcare services expand in the UK, so does demand for skilled phlebotomy technicians to collect blood safely and effectively. Over 9 million blood tests were done by NHS last year alone. Our comprehensive phlebotomy course covers all the key principles and techniques aligned with industry standards so you can kickstart your career in this growing field. Learn blood composition, selection of equipment, techniques like venipuncture and dermal puncture, and implementation of quality guidelines - everything you need for professional blood collection. Join the thousands building expertise through our online phlebotomy course. Begin your rewarding career and play a key role in the healthcare ecosystem today! Phlebotomy! In this Phlebotomy & Blood Collection Procedure course, you will: Describe the role and principles of phlebotomy Identify the components of blood and their functions Select and prepare appropriate phlebotomy equipment Perform routine venipunctures safely Manage complications and assess patient variables Execute accurate dermal punctures Apply quality guidelines in phlebotomy Understand special blood collection procedures Implement infection control protocols Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Phlebotomy & Blood Collection Procedure course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Phlebotomy & Blood Collection Procedure course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Phlebotomy & Blood Collection Procedure course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Phlebotomy & Blood Collection Procedure is suitable for anyone aspiring to start a career in Phlebotomy & Blood Collection Procedure; even if you are new to this and have no prior knowledge on Phlebotomy & Blood Collection Procedure, this course is going to be very easy for you to understand.  And if you are already working in the Phlebotomy & Blood Collection Procedure field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Phlebotomy & Blood Collection Procedure course is a win-win for you in all aspects.  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 This Phlebotomy & Blood Collection Procedure course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Phlebotomy & Blood Collection Procedure 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 Phlebotomy & Blood Collection Procedure course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Phlebotomy & Blood Collection Procedure Module 01: Introduction to Phlebotomy 00:18:00 Module 02: Blood Circulation, Function, and Composition 00:28:00 Module 03: Phlebotomy Equipment 00:17:00 Module 04: Routine Venipuncture 00:25:00 Module 05: Venipuncture Complications and Pre-Examination Variables 00:27:00 Module 06: Dermal Puncture 00:15:00 Module 07: Quality Assessment and Management in Phlebotomy 00:20:00 Module 08: Special Blood Collection Procedure 00:16:00 Module 09: Infection Control and Risk Management 00:20:00 Assignment Assignment - Phlebotomy & Blood Collection Procedure 00:00:00

Overview of Handyperson/Handyman The handyman and handywoman industry in the UK is on the rise! With over 28 million households, the need for reliable individuals who can handle various home maintenance and repair tasks is continuously increasing. This comprehensive Handyperson/Handyman course is designed to provide you with the practical skills and essential knowledge needed in the handyperson industry. You'll develop a comprehensive understanding of the trade, from mastering essential tools and equipment to tackling electrical work, plumbing, carpentry, and construction projects. We prioritize health and safety practices, ensuring you work efficiently in a secure environment. By taking this Handyperson/Handyman course, you will be prepared for various job opportunities. Whether you want to fix household appliances or undertake small construction projects, this Handyperson/Handyman course has you covered. Gain the skills and confidence to succeed as a handyperson in the UK. This Handyperson/Handyman 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 Handyperson/Handyman. 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 Handyperson/Handyman 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 Handyperson/Handyman 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 Handyperson/Handyman 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 Handyperson/Handyman 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 Handyperson/Handyman 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 1: Introduction to Handyperson Introduction to Handyperson 00:22:00 Module 2: Basic Tools and Equipment Basic Tools and Equipment 00:22:00 Module 3: Electrical Work Electrical Work 00:23:00 Module 4: Plumbing Skills Plumbing Skills 00:19:00 Module 5: Appliances Appliances 00:18:00 Module 6: General Carpentry General Carpentry 00:26:00 Module 7: Basic Maintenance Skills Basic Maintenance Skills 00:14:00 Module 8: Walls and Floors Walls and Floors 00:19:00 Module 9: Painting and Decorating Painting and Decorating 00:17:00 Module 10: Drilling, Tiling and Welding Drilling, Tiling and Welding 00:22:00 Module 11: Construction Projects Construction Projects 00:16:00 Module 12: Health and Safety at Work Health and Safety at Work 00:27:00 Module 13: Starting Own Business for Handyperson Starting Own Business for Handyperson 00:27:00

Overview The cleaning industry in the UK is a thriving sector, with a growing demand for skilled professionals who can ensure the highest standards of cleanliness and hygiene. Whether you're an aspiring cleaner, an entrepreneur seeking to establish a cleaning business, or a seasoned professional looking to advance your career, the "Cleaning Supervisor" course offers a comprehensive pathway to success. With a focus on practical skills, industry knowledge, and effective management techniques, this Cleaning Supervisor course empowers you to navigate the diverse cleaning challenges faced in residential, commercial, and industrial settings. From mastering the art of house cleaning to maintaining pristine office spaces, and from managing staff to delivering exceptional customer service, this Cleaning Supervisor course equips you with the tools to thrive in a competitive market. Join us and unlock a world of opportunities in the dynamic cleaning industry, where attention to detail and a commitment to excellence are the keys to success. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Cleaning Supervisor skills to help you advance your career. Acquire a comprehensive understanding of various Cleaning Supervisor topics and tips from industry experts. Learn in-demand Cleaning Supervisor skills that are in high demand among UK employers, which will help you to kickstart your career. This Cleaning Supervisor course covers everything you must know to stand against the tough competition in the Cleaning Supervisor field.  The future is truly yours to seize with this Cleaning Supervisor. Enrol today and complete the course to achieve a Cleaning Supervisor certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Cleaning Supervisor course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Cleaning Supervisor course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Cleaning Supervisor course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Cleaning Supervisor is suitable for anyone aspiring to start a career in Cleaning Supervisor; even if you are new to this and have no prior knowledge on Cleaning Supervisor, this course is going to be very easy for you to understand.  And if you are already working in the Cleaning Supervisor field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Cleaning Supervisor course is a win-win for you in all aspects.  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 This Cleaning Supervisor course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Cleaning Supervisor 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 Cleaning Supervisor course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Cleaning Supervisor Module 1 The Diversity of Cleaning Jobs 00:26:00 Module 2 Cleaning Equipment, Products and Clothing 00:24:00 Module 3 House Cleaning 00:22:00 Module 4 Food Kitchen and Commercial Kitchen Cleaning 00:23:00 Module 5 Bathrooms and Toilets 00:22:00 Module 6 Office Cleaning 00:19:00 Module 7 Cleaning External Surfaces and Areas 00:18:00 Module 8 Dealing with Non-Routine Waste 00:21:00 Module 9 Chemical Safety, Keyholding and Alarm Codes for Cleaners 00:21:00 Module 10 Starting a Cleaning Business and Planning for it 00:14:00 Module 11 Running the Business with Quality Service 00:22:00 Module 12 Customer Satisfaction 00:23:00 Module 13 Management of Staff 00:22:00 Module 14 Marketing, Advertising and Sales 00:24:00 Module 15 Expansion Management 00:17:00 Module 16 Skills of an Effective Administrator 00:17:00 Module 17 Representing Your Boss and Company 00:36:00 Module 18 Organisational Skills 00:27:00 Module 19 Communication Skills 00:27:00

Overview of Palliative and End of Life Care In the golden hush of twilight years, the tenderness of care weaves stories of solace. With an ageing population of over 12 million aged 65 and above, the UK witnesses an escalating demand for palliative and end of life care. Our Palliative and End of Life Care Training course is your gateway to enter this realm of profound impact. With the industry set to burgeon by 20% in the next decade, there's an ever-present need for skilled professionals to champion dignified and compassionate end of life journeys. Dive deep into holistic assessments, navigate the nuances of legal considerations, and become a pillar of support in those poignant final chapters. Here lies your chance to carve a career and touch lives in the most profound way. Embrace the calling. This Palliative and End of Life Care Training Course covers the following topics: Understand the principles of palliative and end of life care. Determine and identify stages of illness accurately. Conduct a holistic assessment for patients in palliative. Develop and utilise advanced care planning for patients. Provide appropriate care at the end of life and post-death. Navigate legal issues and access further support in palliative. In this Palliative and End of Life Care Training course, you will: Sharpen your skills to help you advance your Palliative and End of Life Care career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your career. 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 Palliative and End of Life Care course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Palliative and End of Life Care 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 Palliative and End of Life Care course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Palliative and End of Life Care 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 Palliative and End of Life Care Module 1: Introduction to Palliative & End of Life Care 00:45:00 Module 2: Identification of the Stage of Illness 00:15:00 Module 3: Palliative Care Holistic Assessment 00:15:00 Module 4: Advance Care Planning 00:30:00 Module 5: Care at the End of Life 00:15:00 Module 6: Care after Death 00:15:00 Module 7: Further Support, Training and Development 00:10:00 Module 8: Legal Issues 00:30:00 Module 9: Glossary of Terms 00:15:00 Module 10: Appendices 00:10:00 Assignment Assignment - Palliative and End of Life Care 00:00:00

Join our Microsoft Excel 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 Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel 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! You will Learn The Following Things: 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 Microsoft Excel. 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 After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel 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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel 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 Microsoft Excel 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 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:03: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:03: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.mp4 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 Little Slice of Pie Charts 00:05: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:06: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.mp4 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 Excels 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 The 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:13: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 Loop 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 00:00:00

Overview of Care Certificate (Standard 1 to 15) Join our Care Certificate (Standard 1 to 15) 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 Care Certificate (Standard 1 to 15) course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Care Certificate (Standard 1 to 15) 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! Get a quick look at the course content: This Care Certificate (Standard 1 to 15) 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 Care Certificate (Standard 1 to 15). 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 Care Certificate (Standard 1 to 15) 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 Care Certificate (Standard 1 to 15) 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 Care Certificate (Standard 1 to 15) 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 Care Certificate (Standard 1 to 15) 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 The Care Certificate Preparation Framework and Information Leaflet 00:00:00 Standard 01: Understand Your Role 00:32:00 Standard 02: Your personal development 00:13:00 Standard 03: Duty of Care 00:35:00 Standard 04: Equality and Diversity 00:27:00 Standard 05: Work in a Person Centred Way 00:36:00 Standard 06: Communication 00:36:00 Standard 07: Privacy and dignity 00:27:00 Standard 08: Fluids and nutrition 00:15:00 Standard 09: Mental Health, Dementia and Learning Disabilities 00:41:00 Standard 10: Safeguarding Adults 00:40:00 Standard 11: Safeguarding Children 00:07:00 Standard 12: Basic life support 00:08:00 Standard 13: Health and Safety 00:51:00 Standard 14: Handling information 00:18:00 Standard 15: Infection control 00:13:00

Overview Join our Deep Tissue Massage Therapy 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 Deep Tissue Massage Therapy course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Deep Tissue Massage Therapy 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! You Will Learn Following Things: 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 everything you must know to stand against the tough competition. The future is truly yours to seize with this Deep Tissue Massage Therapy. 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 This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Deep Tissue Massage Therapy. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo. Certificate of Achievement After completing the Deep Tissue Massage Therapy course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Deep Tissue Massage Therapy 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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Deep Tissue Massage Therapy 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 Deep Tissue Massage Therapy 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 Introduction Introduction 00:01:00 Massage Tables-The 4 Most Important considerations 00:06:00 Creams and Oils-Whats Great and whats not 00:04:00 The Set up-Dont do what i did 00:05:00 This factor makes a huge difference 00:03:00 It's all in the timing 00:04:00 Contraindications of Massage, intake forms and more 00:01:00 Why i Don't include these things in my massages 00:04:00 Do no Harm 00:01:00 The Perfect Person to Practice your massage on 00:01:00 Why Most Therapists don't last! 00:07:00 Now is the time to put the time in 00:02:00 Some Final Points 00:02:00 Putting it all together 00:02:00 The Massage Strokes Correct and Incorrect Ways General Stroke 00:02:00 Kneading 00:01:00 Scissor Stroke 00:01:00 Acupressure Techniques 00:03:00 Forearms 00:02:00 Full Body Deep tissue Massage Massage Start Sequence 00:05:00 Back Sequence 1 00:15:00 Back Sequence 2 00:08:00 Back of Legs 00:09:00 Legs Prone Stretching 00:02:00 Neck 00:05:00 Arms 00:05:00 Front of Legs Stretching 00:03:00 Full Massage Sequence Full Body Massage Sequence 00:56:00

Overview of Disability Awareness & Inclusion Training Basics In an increasingly diverse and inclusive workplace, understanding and accommodating people with disabilities is essential for any organisation that values equal opportunities and a thriving work environment. This comprehensive Disability Awareness & Inclusion Training program provides participants with a deep understanding of disabilities, their impact on individuals, and the legal and ethical frameworks that govern disability inclusion in the workplace. According to the Office for National Statistics (ONS), 14.1 million people in the UK have a disability, representing 20.4% of the population. This number is expected to rise as the population ages. Despite this significant proportion, people with disabilities are still underrepresented in the workforce. The ONS reports that only 52.2% of people with disabilities are employed, compared to 83.1% of people without disabilities. This presents a significant opportunity for businesses to tap into a largely untapped talent pool and skills. By embracing Disability Awareness & Inclusion Training, organisations can gain a competitive advantage, enhance their reputation, and foster a more diverse and productive work environment. Upon completion of this Disability Awareness & Inclusion Training, participants will be able to learn about: Define disability and identify different types of disabilities. Understand the legal and ethical frameworks governing disability inclusion in the workplace. Apply the social model of disability to understand the barriers faced by people with disabilities. Identify and address attitudinal and environmental barriers that hinder disability inclusion. Implement effective communication strategies when interacting with people with disabilities. Contribute to creating an inclusive workplace that values and accommodates people with disabilities. 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 Disability Awareness & Inclusion Training course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Disability Awareness & Inclusion Training 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 Disability Awareness & Inclusion Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Disability Awareness & Inclusion Training 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: Concept of Disabilities and Inclusion Concept of Disabilities and Inclusion 00:12:00 Module 02: Disability and The Law Disability and The Law 00:11:00 Module 03: Models of Disability Models of Disability 00:11:00 Module 04: General Duties of Employers and Workers' Representatives General Duties of Workers' Representatives 00:08:00 Module 05: Ensuring Health and Safety for Disabled People Ensuring Health and Safety for Disabled People 00:16:00 Module 06: Managing Workers with Disabilities Managing Workers with Disabilities 00:11:00 Module 07: Effective Communication Strategies with Disabled People Effective Communication Strategies with Disabled People 00:09:00 Module 08: Recruiting People with Disabilities Recruiting People with Disabilities 00:12:00 Module 09: Promotion Promotion 00:09:00 Module 10: Creating An Inclusive Workplace Creating an Inclusive Workplace 00:13:00

Overview of Addiction and Mental Health - Dual Diagnosis Join our Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis. 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 Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis 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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis 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 Promotional Video Promotional 5 minute video 00:06:00 SAMHI Dual Diagnosis Intro video SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6) 00:19:00 Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9) 00:15:00 Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10) 00:10:00 Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13) 00:13:00 Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18) 00:19:00 Module 2 - Addictions & Mental Health Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7 00:13:00 Module 2 Addictions & Mental Health: VIDEO PART 4 content part 00:17:00 Module 2 Addictions & Mental Health: VIDEO PART 5 content part 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 6 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 7 content part 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 8 content part 00:12:00 Module 2 Addictions & Mental Health: VIDEO PART 9 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 10 content part 00:13:00 Module 3 - Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 00:23:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part 00:09:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part 00:18:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7 00:12:00 Module 4 - Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part 00:10:00 Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part 00:19:00 Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part 00:16:00 Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part 00:11:00 Module 5 - Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content partVIDEO PART 8 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12 00:19:00 Module 6 - Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2 00:20:00 Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00