32603 PE courses in Cardiff delivered On Demand

Overview of IT Security Basics The world of IT security is growing fast. Every day, businesses face new cyber threats. They need skilled professionals to protect their data. This creates a huge demand for IT security experts. Our "IT Security Training Basics" course is perfect for anyone wanting to start in this field. You will learn the key parts of IT security, from network and operating system security to cryptography and web security. Each module is designed to give you a strong foundation and practical knowledge. This course is easy to follow and packed with useful information. It covers the latest trends and threats in IT security. By the end of the course, you will have the skills needed to help protect important information from cyberattacks. Join now and be part of the exciting world of IT security. Become proficient in IT Security Training Basics by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your IT Security Training Basics mastery is not limited to only conceptual frameworks! This IT Security Training Basics will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the IT Security Training Basics, we will provide experts who will support and guide you. So, add this IT Security Training Basics to your cart and boost your personal and career development. In this IT Security Training Basics, you will: Sharpen your skills to help you advance your 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 IT Security Training Basics career. Enrolling in the IT Security Training Basics can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! 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 IT Security Basics 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 IT Security Basics 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 IT Security Basics 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 IT Security Basics Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to IT Security Introduction to IT Security 00:16:00 Module 02: Security Policies and Procedures Security Policies and Procedures 00:16:00 Module 03: Network Security Network Security 00:13:00 Module 04: Operating System Security Operating System Security 00:14:00 Module 05: Cryptography and Encryption Cryptography and Encryption 00:15:00 Module 06: Web Security Web Security 00:14:00 Module 07: Wireless Security Wireless Security 00:13:00 Module 08: Emerging Trends in IT Security Emerging Trends in IT Security 00:15:00

Overview of Teaching Assistant Level 3 Join our Teaching Assistant Level 3 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 Teaching Assistant Level 3 course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Teaching Assistant Level 3 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 Teaching Assistant Level 3 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 Teaching Assistant Level 3. 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 Teaching Assistant Level 3 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 Teaching Assistant Level 3 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 Teaching Assistant Level 3 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 Teaching Assistant Level 3 Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Overview Speech & Language Therapy is a vital field, impacting countless lives in the UK. With over 2.5 million individuals experiencing communication disorders, there’s a growing need for qualified speech and language therapists. This Level 3 Diploma offers a comprehensive introduction to the discipline, equipping learners with the knowledge to support those with speech and language challenges. Throughout the course, you will explore the anatomy and science of speech, gain insights into linguistic disciplines, and learn about literacy and language development. You will also delve into the characteristics and causes of speech and language disorders in both children and adults, preparing you to address these challenges effectively. Whether you aspire to work in educational settings, healthcare, or private practice, this diploma provides a solid foundation in speech & language therapy. Join us to embark on a fulfilling journey where you can make a significant difference in the lives of those with speech and language difficulties. Become proficient in Level 3 Diploma in Speech & Language Therapy Course by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Level 3 Diploma in Speech & Language Therapy Course mastery is not limited to only conceptual frameworks! This Level 3 Diploma in Speech & Language Therapy Course will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Level 3 Diploma in Speech & Language Therapy Course, we will provide experts who will support and guide you. So, add this Level 3 Diploma in Speech & Language Therapy Course to your cart and boost your personal and career development. Learning Outcome Understand how speech science contributes to the development of spoken language understanding Consider how literacy and language development affect a child's academic progress Explain how Child Speech and Language Disorders influence a child's reading and writing skills Adopt some tried-and-true strategies to assist children who are having difficulty communicating Description Speech and Language Therapy (SLT) is an important health discipline that is responsible for the management and care of children and adults with communication and swallowing disorders.  Please note that this online training does not entitle you to practise as a registered speech and language therapist. If you are looking for a course to comply with HCPC's requirements, please contact the HCPC. Course design The course is delivered through our online learning platform, accessible through any internet-connected device such as laptop, tab or smartphones. There are no deadlines or teaching schedules, meaning you are free to study the course at your own pace.  You are taught through a combination of Video lessons Online study materials Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £109. There is an additional £10 postage charge for international students. CPD Certification from Institute of Mental Health After successfully completing the MCQ assessment of this course, you will qualify for the CPD Certificate from Institute of Mental Health, as proof of your continued professional development. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15. Endorsement This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To assess your learning, you have to participate in an automated multiple choice question exam. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. In addition, to enhance the depth of your knowledge regarding the course and further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish. After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Why study this course Whether you're an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and knowledge. Who is This course for? Speech And Language Therapy course is ideal for - People looking to develop skills and expertise in speech & language therapy People aspiring for new jobs/promotions at their existing jobs Anyone looking to learn a new skill or acquire some knowledge Requirements The Speech And Language Therapy course is open to all, with no entry requirements. All you need to have a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Course Curriculum Speech And Language Therapy Module 01: An Overview of Speech Therapy Module 01: An Overview of Speech Therapy 00:13:00 Module 02: The Science of Speech Module 02: The Science of Speech 00:20:00 Module 03: The Anatomy of Speech Module 03: The Anatomy of Speech 01:00:00 Module 04: Characteristic of Speech: Linguistic Discipline Module 04: Characteristic of Speech: Linguistic Discipline 00:27:00 Module 05: Literacy and Language Development Module 05: Literacy and Language Development 00:22:00 Module 06: Child Speech & Language Disorders Module 06: Child Speech & Language Disorders 00:32:00 Module 07: Adult Speech & Language Disorders Module 07: Adult Speech & Language Disorders 00:29:00 Module 08: How to Help a Child with SL Difficulties Module 08: How to Help a Child with SL Difficulties 00:25:00 Mock Exam Mock Exam - Speech And Language Therapy 00:20:00 Final Exam Final Exam - Speech And Language Therapy 00:20:00 Assignment Assignment - Speech And Language Therapy 2 weeks, 6 days

Overview of Dialectical Behaviour Therapy (DBT) Dialectical Behaviour Therapy (DBT) Training offers a powerful way to help people with complex emotional needs. This course is designed to teach you how to use DBT effectively in various settings. You'll learn essential skills like mindfulness, emotion regulation, and distress tolerance. Each skill is crucial for helping clients manage their emotions and improve their lives. In this training, you'll cover all the core modules of DBT. From understanding its principles to applying it with different populations, you'll gain a thorough grasp of this approach. The course also highlights how to use DBT in clinical environments and addresses important ethical considerations. By completing this DBT Training, you’ll be well-equipped to make a real difference in mental health care. Enhance your skills and become a valued professional in the field. This course is a great step toward advancing your career and helping others. Become proficient in Dialectical Behaviour Therapy (DBT) Training by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Dialectical Behaviour Therapy (DBT) Training mastery is not limited to only conceptual frameworks! This Dialectical Behaviour Therapy (DBT) Training will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Dialectical Behaviour Therapy (DBT) Training, we will provide experts who will support and guide you. So, add this Dialectical Behaviour Therapy (DBT) Training to your cart and boost your personal and career development. In this Dialectical Behaviour Therapy (DBT) Training, you will: Sharpen your skills to help you advance your 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 Dialectical Behaviour Therapy (DBT) Training career. Enrolling in the Dialectical Behaviour Therapy (DBT) Training can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! 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 Dialectical Behaviour Therapy (DBT) 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 Dialectical Behaviour Therapy (DBT) 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 Dialectical Behaviour Therapy (DBT) 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 Dialectical Behaviour Therapy (DBT) 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 DBT Introduction to DBT 00:19:00 Module 2: Mindfulness Skills Training Mindfulness Skills Training 00:20:00 Module 3: Emotion Regulation Skills Emotion Regulation Skills 00:19:00 Module 4: Interpersonal Effectiveness Skills Interpersonal Effectiveness Skills 00:16:00 Module 5: Distress Tolerance Skills Distress Tolerance Skills 00:26:00 Module 6: Application of DBT in Specific Populations Application of DBT in Specific Populations 00:29:00 Module 7: Implementation of DBT in Clinical Settings Implementation of DBT in Clinical Settings 00:28:00 Module 8: Ethical and Professional Considerations in DBT Practice Ethical and Professional Considerations in DBT Practice 00:19:00

Overview of Microbiology Lab Technician The "Microbiology Lab Technician - CPD Certified" course offers a pathway into the growing field of microbiology in the UK. This course is perfect for anyone looking to start a healthcare, research, or environmental science career. With a projected industry growth rate of 7% over the next decade, there is a high demand for skilled microbiology lab technicians. This course delves into essential topics such as cell structure, microbial diversity, and the role of microorganisms in the environment. It's not just theoretical knowledge-you'll also learn about microbial metabolism, controlling microbial growth, and the significance of immunity and vaccines. These practical skills are invaluable for careers in healthcare, pharmaceuticals, and food safety. By completing this course, you can prepare for a rewarding career as a microbiology lab technician, with salaries ranging from £18K to £30K annually. Gain valuable knowledge and practical skills to contribute to vital sectors and enhance your career prospects. Become proficient in Microbiology by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Microbiology mastery is not limited to only conceptual frameworks! This course will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the course, we will provide experts who will support and guide you. So, add this course to your cart and boost your personal and career development. In this Microbiology Lab Technician - CPD Certified, you will: Understand fundamental concepts of microbiology and its applications. Explain cell structure and organisation in microorganisms. Describe the chemical metabolism processes in microbes. Identify methods for controlling microbial growth. Differentiate between prokaryote and eukaryote microbial diversity. Recognise the importance of microorganisms in the environment. Enrolling in the Microbiology Lab Technician - CPD Certified can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! 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 Microbiology Lab Technician 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 Microbiology Lab Technician 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 Microbiology Lab Technician 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 Microbiology Lab Technician 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 Microbiology Laboratory Technician Module 01 : Introduction to Microbiology 00:28:00 Module 02 : Cell Structure and Organisation 00:31:00 Module 03 : Microbial Diversity Prokaryote Diversity 00:25:00 Module 04 : Microbial Diversity Eukaryote Diversity 00:32:00 Module 05 : Viruses, Viroids, and Prions 00:22:00 Module 06 : Interactions between Microbes and Humans 00:28:00 Module 07 : Human Microbial Diseases 00:30:00 Module 08 : Microorganisms in the Environment 00:19:00 Module 09: Laboratory Equipments (Part-01) 00:26:00 Module 10: Laboratory Equipments (Part-02) 00:15:00 Module 11: Solutions Used in Clinical/Medical Laboratory 00:17:00 Module 12: Sterilisation, Disinfection and Decontamination 00:18:00 Module 13: Laboratory Accidents and Safety 00:18:00

Overview of Urban Farming and Gardening Join our Urban Farming and Gardening 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 Urban Farming and Gardening course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Urban Farming and Gardening 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 Urban Farming and Gardening 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 Urban Farming and Gardening. 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 Urban Farming and Gardening 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 Urban Farming and Gardening 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 Urban Farming and Gardening 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 Urban Farming and Gardening 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 Urban Farming and Gardening 00:15:00 Module 2: Essential Gardening Tools and Equipment 00:15:00 Module 3: Planning and Budgeting for Urban Farming 00:14:00 Module 4: Soil Preparation and Planting Techniques 00:14:00 Module 5: Pest Management and Plant Health 00:15:00 Module 6: Sustainable Practices in Urban Farming 00:14:00 Module 7: Plant Care and Harvesting 00:14:00 Module 8: Design and Construction for Urban Gardens 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 Criminal Law Join our Criminal Law 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 Criminal Law course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Criminal Law 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 Criminal Law 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 Criminal Law. 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 Criminal Law 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 Criminal Law 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 Criminal Law 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 Criminal Law Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Overview of Payroll Management In the dynamic world of business, payroll management stands as a critical backbone, ensuring that employees receive their rightful compensation in a timely and accurate manner. As the economy expands and regulations evolve, the demand for skilled payroll professionals continues to rise. This comprehensive course empowers aspiring payroll experts with the essential knowledge and hands-on skills to navigate the complexities of UK payroll administration. Delve into the intricacies of payroll management in the UK with this meticulously crafted course designed to equip you with the expertise to handle payroll responsibilities confidently. From mastering the fundamentals of payroll legislation and employee records to processing monthly payrolls and generating reports, this course provides a holistic understanding of the payroll process. Get a quick look at the course content: This Payroll Management Course will help you to learn: Demonstrate proficiency in UK payroll legislation and company settings. Effectively manage pension schemes and various pay elements. Confidently process monthly payrolls, handle pre-update reports, and update payroll records. Master e-submissions, year-end procedures, and historical data management. Navigate employee departures, manage final payroll runs, and generate comprehensive reports. 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 Payroll Management. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Payroll Management 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 course is designed for individuals seeking to build a rewarding career in payroll management, including: Aspiring payroll professionals seeking an entry-level position in the field. Existing payroll professionals aim to enhance their skills and knowledge. HR professionals are seeking to expand their expertise in payroll management. Business owners are seeking to gain a deeper understanding of payroll processes. Individuals seeking a career transition into the field of payroll management. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Payroll Management 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 field of payroll management offers a range of promising career opportunities in the UK, with competitive salaries and strong job growth prospects. Here are some potential career paths with average salaries: Payroll Administrator: £20K to £26K/year Payroll Officer: £28K to £325K/year Payroll Supervisor: £30K to £40K/year Payroll Manager: £40K to £50K/year Head of Payroll: £50K to £60K/year Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Module 01: Payroll System in the UK 01:05:00 Module 02: Payroll Basics 00:10:00 Module 03: Company Settings 00:08:00 Module 04: Legislation Settings 00:07:00 Module 05: Pension Scheme Basics 00:06:00 Module 06: Pay Elements 00:14:00 Module 07: The Processing Date 00:07:00 Module 08: Adding Existing Employees 00:08:00 Module 09: Adding New Employees 00:12:00 Module 10: Payroll Processing Basics 00:11:00 Module 11: Entering Payments 00:12:00 Module 12: Pre-Update Reports 00:09:00 Module 13: Updating Records 00:09:00 Module 14: e-Submissions Basics 00:09:00 Module 15: Process Payroll (November) 00:16:00 Module 16: Employee Records and Reports 00:13:00 Module 17: Editing Employee Records 00:07:00 Module 18: Process Payroll (December) 00:12:00 Module 19: Resetting Payments 00:05:00 Module 20: Quick SSP 00:09:00 Module 21: An Employee Leaves 00:13:00 Module 22: Final Payroll Run 00:07:00 Module 23: Reports and Historical Data 00:08:00 Module 24: Year-End Procedures 00:09:00

Join our Manual Handling Course 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 Manual Handling Course course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Manual Handling Course 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 Manual Handling Course. 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 Manual Handling Course course, you can order your CPD-accredited Digital/PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Manual Handling Course 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 Manual Handling Course 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 Manual Handling Course Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to Manual Handling Introduction to Manual Handling 00:28:00 Module 02: Manual Handling Injuries, Prevention and Reporting Accidents Manual Handling Injuries, Prevention and Reporting Accidents 00:16:00 Module 03: Manual Handling Risk Assessments and Legislation Manual Handling Risk Assessments and Legislation 00:18:00 Module 04: Reducing, Controlling Risks and Safe Practices Reducing, Controlling Risks and Safe Practices 00:10:00