5580 Courses in Cardiff delivered Online

Land management plays a pivotal role in shaping the sustainable future of our environment and communities. This CPD accredited course offers a detailed exploration of key principles, including soil conservation, resource allocation, and land use planning. It’s designed to equip professionals with a thorough understanding of the strategies essential to managing land efficiently while balancing environmental, economic, and social factors. Whether you work in agriculture, property development, or environmental consultancy, this course brings valuable insights to your fingertips. Delving into topics such as sustainable resource stewardship and legal frameworks governing land use, the course is structured to enhance your knowledge and decision-making capabilities. Its content is crafted to fit busy professionals seeking flexible, online learning that fits neatly around their schedule. Expect clear explanations, relevant case studies, and up-to-date information that keeps you informed on the latest trends and challenges within land management. All this, with a professional tone lightly sprinkled with wit to keep the journey engaging and far from dull. Course Curriculum: Module 01: Land Management: An Introduction Module 02: Land Use and Land Use Planning Module 03: Soil Management Module 04: Land Degradation and Management Module 05: Weed Management Module 06: Watershed Management Module 07: Irrigation Management Module 08: Land Tenure, Administration and Transection Module 09: Land Registration and Acquisition Module 10: Land Law Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Land Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Land Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Land Management - CPD Accredited training.

Discover the joy of growing your own fresh herbs, vegetables, and fruits right from your kitchen windowsill or small garden patch. This Kitchen Gardening course offers a delightful dive into nurturing plants in confined spaces, perfect for anyone looking to bring a touch of green into their daily routine. Whether you have a sprawling garden or just a cosy corner, this course provides clear guidance on selecting the right plants, maintaining healthy soil, and optimising growth conditions without ever needing to leave your home. Designed for enthusiasts keen on cultivating edible delights without the fuss, this course explains the essentials of planting, watering, and caring for your kitchen garden with confidence and flair. Expect to learn clever tips on seasonal planting, pest control, and sustainable gardening practices—all delivered in a friendly, approachable style. Ideal for those who fancy a fresher plate and a greener thumb, this accredited course is a garden-fresh treat for mind and table alike. Course Curriculum: Module 01: Introduction to Kitchen Gardening Module 02: Planning for Kitchen Gardening Module 03: Choosing Vegetables for Your Garden Module 04: Choosing Crops for Your Garden Module 05: Preparing Your Soil with Care Module 06: Preparing the Bed and Planting Your Crops Module 07: Maintaining your Garden and Best Practices Module 08: Practicing Eco-Friendly Pest Management Module 09: Harvesting Your Crops and Storing Safely Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Kitchen Gardening - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Kitchen Gardening - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Kitchen Gardening - CPD Accredited training.

Course Overview Learn the Latest Skills | Acknowledged by CPD & QLS | Acknowledged Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Even while there are millions of people who aspire to start a new life abroad, the vast majority of them will never realize their ambitions. Taking a TEFL (TESOL) Course is a terrific way to get started on the path to a new life of living and working abroad if you want to be one of those people who make it happen. Through this course, you will acquire the fundamental abilities required to train as an English language teacher. This involves a critical comprehension of the grammar and structure of the English language as well as a variety of classroom management abilities and language teaching methodologies. What Will You Learn? Gain the fundamental knowledge of the principles of teaching English as a foreign language Discover a wide range of approaches and methods for teaching foreign students Develop the practical skills to deliver engaging, informative and inclusive lessons Explore the role and responsibilities of a TESOL teacher & understand the challenges teacher and students may face Receive an internationally acknowledged teacher education lesson on successful course completion Learn effective methods for teaching the four language skills: reading, writing, speaking and listening Understand the basics of classroom management to create dynamic lesson plans Get expert career guidance and understand your job opportunities & requirements for teaching roles What classes are included in this package? Earn a digital certificate upon successful completion There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? You will learn everything that is needed regarding Teaching English as a Foreign Language. This is an excellent opportunity for anyone from any academic background to learn more and advance their learning, launch a new career or reinvigorate an existing one. Career Path Training offered by the TEFL (TESOL) Course could potentially benefit a range of roles, but would particularly enhance careers in: Teacher Consultancy Life Coach Career Counsellor Other Administrative Roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the TEFL (TESOL) Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Course Content Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Mental health is just as important as physical health. However, a healthy body will not do you good if your mental health is abysmal. And the sad thing is that many people struggle with their mental health. And most people don't even realise that they need professional help. Therefore, we created this Mental Health Support Worker Training - Level 3 course. If you want to learn about mental health and help people suffering from mental health issues, this course is for you. You will gain the skills to understand various mental health conditions and how to work with and provide treatment for people struggling with their mental health. Get started with our course now and get proper mental support worker training to help people with their mental health. Enrol now and get certified! Please note: This course only gives you the theoretical knowledge you need to excel in this field. This Mental Health Support Worker Training - Level 3 doesn't entitle you to practise as a professional in this field. What Will You Learn? Overview of mental health support worker Learn about different anxiety and mood disorders How to treat various mental illness Laws and policies concerning mental health Have a strong, flexible mental aptitude and adapt to unpredictable situations What classes are included in this package? Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? Mental Health Support Worker Training - Level 3 is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. Career Path Training offered by the Mental Health Support Worker Training - Level 3 could potentially benefit a range of roles but would particularly enhance careers in: Health Care Assistant Support Worker Home care support worker Clinical Psychiatrist Nurse Neuropsychologist Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment On successful completion of the Mental Health Support Worker Training - Level 3, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Module 1: Introduction to Mental Health Module 2: Overview of Mental Health Support Worker Module 3: Childhood and Adolescent Psychiatric Disorders Module 4: Stress and Anxiety Disorders Module 5: Schizophrenia Module 6: Personality Disorders Module 7: Mood Disorders Module 8: Eating & Sleeping Disorders Module 9: Self-Harm and Suicide Module 10: Medication and Therapy in the Treatment of Mental Illness Module 11: Mental Health Legislation and Services Module 12: Community Mental Health Teams (CMHTs) Module 13: The Participation of the Service User

The 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle is designed for individuals who aspire to teach English to non-native speakers. This extensive course offering covers everything from foundational language teaching strategies to more advanced classroom management and lesson planning. With the CPD accreditation, you can be confident in the quality and credibility of the course content, equipping you with the knowledge needed to teach English effectively in diverse educational settings. Throughout the three courses, learners will gain insight into the most effective teaching methodologies, the nuances of different cultural contexts, and the skills required to create engaging, structured lessons. The course allows flexibility, meaning you can study at your own pace and at a time that suits you, all while enhancing your professional qualifications. This package provides a solid foundation for those wishing to teach English globally, setting you on the right path to becoming a confident and competent English teacher. Course Curriculum: Module 01: Introduction to IELTS Module 02: IELTS Test Format Module 03: Grammar for IELTS: Basics of Grammar Module 04: Grammar for IELTS: The Basics of Sentence Module 05: Grammar for IELTS: Structure of Sentence Module 06: Grammar for IELTS: Punctuation & Capitalisation Module 07: The Listening Section Module 08: The Reading Section [Academic] Module 09: The Writing Section [Academic] Module 10: The Speaking Section Module 11: IELTS [General Training] Module 12: IELTS Life Skills Module 13: What To Do Before The IELTS Test? Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. This 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle provides you with the required knowledge and skills to achieve a rewarding career in a rapidly growing industry. By enrolling today, you can take your knowledge to a whole new level and quickly reap the rewards of your study in relevant fields. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics. The courses in the 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle bundle are relevant, reliable, and up-to-date. Moreover, since the courses are CPD QS accredited, they will boost your career and improve your CV. Industry experts design the 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle to ensure you learn everything thoroughly. All three courses in the bundle will help you to give your career a boost. We look forward to sharing our knowledge and experience to help you become more confident and comfortable with the topic. Enrol today and start your journey to career development. These comprehensive courses are available in this 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle Course 01: 120 hours TEFL (TESOL) Course 02: English: Spelling, Pronunciation and Grammar Course 03: IELTS Preparation ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle training.

The Clinical Coding - CPD Accredited 3 Courses Bundle offers a structured, no-nonsense introduction to the essential aspects of clinical coding, all from the comfort of your own screen. Whether you’re already familiar with ICD-10, OPCS-4 and SNOMED CT, or wondering if they’re characters from a sci-fi novel, this bundle lays it all out with clarity and precision. From decoding medical terminology to understanding the legal and ethical considerations of working with confidential health records, this course trio has the full alphabet soup of clinical coding covered. Split across 13 well-defined modules, the content delves into the fundamentals of clinical records, explores classification systems used globally, and explains the logic behind code assignment—yes, there is logic, we promise. With CPD accreditation to give your CV a boost and a strong focus on knowledge that’s relevant across healthcare settings, this course bundle is ideal for those who prefer accuracy over guesswork and order over chaos. Let’s just say, if your idea of fun involves turning symptoms into structured data, you’re in the right place. Course 01: Clinical Coding Course 02: Medical Law Course 03: Medication ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Clinical Coding Module 01: Introduction to Clinical Coding Module 02: Introduction to Clinical Records Its Confidentiality Module 03: Clinical Terminology and Jargons Module 04: Introduction to ICD-10 Coding Module 05: General Coding Standards of ICD-10 Module 06: ICD-10 5th Edition Codes (Chapter 1 to 4) Module 07: ICD-10 5th Edition Codes (Chapter 5 to 10) Module 08: ICD-10 5th Edition Codes (Chapter 11 to 15) Module 09: ICD-10 5th Edition Codes (Chapter 16 to 22) Module 10: Introduction to OPCS-4 Module 11: Introduction to SNOMED CT Module 12: Other types of Clinical Coding Module 13: Legal and Ethical Aspects of Working in a Clinical Environment Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Clinical Coding - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Clinical Coding - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Clinical Coding - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Clinical Coding - CPD Accredited 3 Courses Bundle training.

If you’re responsible for handling, preparing, or serving food, you already know that safety isn’t just a good idea—it’s the foundation of everything. This CPD Accredited Level 2 Food Safety bundle brings together three essential courses designed to help you stay sharp, informed, and confidently compliant with the latest hygiene and food handling standards. Whether you’re in catering, hospitality, retail, or manufacturing, this bundle offers the knowledge needed to help keep food safe and customers smiling (ideally with a full stomach). Delivered entirely online, this flexible, fuss-free bundle is built for those who want clarity without the clutter. Each course is structured to take you through key food safety principles, allergen awareness, and hygiene regulations—without the waffle. CPD-certified and professionally written, it’s suitable for individuals or teams looking to stay in line with UK food safety requirements while avoiding unnecessary jargon. No fluff, no filler—just straight-talking content that gets the job done. These comprehensive courses are available in this Level 2 Food Safety - CPD Accredited 3 Courses Bundle Course 01: Level 2 Food Safety Course 02: Food Allergen Awareness Training Course 03: Food Labelling Regulations Training ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Food Hygiene and Safety: Legislation Module 02: Bacteria and Microbiological Hazards Module 03: Physical, Chemical and Allergenic Hazards Module 04: Food Storage Module 05: Display and Service for Maintaining Food Safety and Hygiene Module 06: Personal Hygiene Module 07: HACCP and Food Premises Module 08: Cleaning Module 09: Reopening and Adapting Your Food Business During COVID-19 Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Level 2 Food Safety - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Level 2 Food Safety - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Level 2 Food Safety - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Level 2 Food Safety - CPD Accredited 3 Courses Bundle training.

Struggling to understand the shifting moods, emotional highs, and depressive lows of bipolar disorder? This CPD-accredited course bundle offers a thoughtful and informed deep dive into the complexities of bipolar disorder, how it intersects with depression, and what therapeutic approaches look like from a psychotherapist’s perspective. Through a trio of structured courses—Bipolar Disorder, Psychotherapist Training, and Depression Counselling—you’ll explore diagnosis, behavioural patterns, and key psychological frameworks, all designed to build confidence in navigating the subject matter with clarity. Whether you're supporting someone with bipolar disorder, working in a mental health setting, or simply wish to learn more with a purpose, this bundle helps illuminate the landscape without fluff or filler. It’s informative, relevant, and delivered with professional insight. No vague jargon. No mystical promises. Just accessible knowledge grounded in theory and thoughtful instruction—wrapped in an engaging format that doesn’t feel like wading through a psychology textbook from 1974. Course 01: Bipolar Disorder Course 02: Psychotherapist Training Course Course 03: Depression Counselling Diploma **Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Bipolar Disorder Module 01: Mental Illness Module 02: Bipolar Disorder Module 03: Associated Problems That Frequently Co-occur with Bipolar Disorder Module 04: Strategies for Managing Symptoms of Bipolar Disorder Module 05: Social Inclusion Module 06: Caring for and Helping Someone with Bipolar Disorder Module 07: Challenges for Those with Bipolar Across the Lifespan Module 08: Risk and Bipolar Experience Module 09: Treatment and Medication for Bipolar Disorder Module 10: Psychotherapy for Bipolar Disorder Module 11: Raising Awareness About Bipolar Disorder Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Bipolar Disorder Awareness - CPD Accredited 3 Courses Bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Bipolar Disorder Awareness - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Bipolar Disorder Awareness - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Bipolar Disorder Awareness - CPD Accredited 3 Courses Bundle training.

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn all the essential skills to become an expert in Cupping Therapy. From this comprehensive Professional Cupping Therapy course, you will be able to understand the principles of Cupping Therapy. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Professional Cupping Therapy is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Professional Cupping Therapy course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Professional Cupping Therapy course, learn the vital abilities and knowledge you require to succeed in your life.   Introduction Welcome to my course! 00:01:00 Learn the 2 different cupping techniques in under 2 minutes 00:02:00 Ok, so let's get serious for a minute. What is so wrong about the red marks? 00:02:00 So How Does Cupping Work? 00:03:00 What Types Of Cups Should I Buy And Why? 00:03:00 These Cups People Swear By, But I have Just Had No Luck with Them 00:02:00 A Rundown On How To Do Cupping On Someone's Back 00:04:00 The Contraindications to Cupping 00:02:00 What should you do your treatment on? 00:01:00 Let's have a little practice shall we? 00:03:00 It's cupping time! The Upper Body And Limbs How this Section Of The Course Works 00:02:00 Neck Pain/Neck Tension 00:05:00 How To Do Cupping For Neck Pain And Tension 00:03:00 How To Do Cupping For The Neck On Someone Else 00:05:00 Some Advanced Techniques For Neck Pain And Tension 00:08:00 Neck Exercises To Relieve Pain 00:02:00 Shoulder/Rotator Cuff Pain/Shoulder Impingements 00:11:00 How To Do Cupping For Rotator Cuff and shoulder problems 00:13:00 Exercises to do for rotator cuff problems 00:06:00 Frozen Shoulder 00:05:00 Exercises For Frozen Shoulder 00:03:00 Extension Exercise For Upper Back Pain Relief 00:03:00 Chest/Respiration/Colds 00:05:00 Biceps Tendonitis/Upper Arm Pain 00:04:00 Tennis Elbow Pain/Forearm Extensor Pain 00:03:00 How To Do Cupping For Tennis Elbow And Extensors Pain 00:03:00 Home Exercises For Tennis Elbow 00:04:00 Golfers Elbow Pain 00:01:00 Carpal Tunnel Syndrome/Wrist Pain 00:02:00 How To Treat Carpal Tunnel Syndrome, Golfer's Elbow And Forearm Pain 00:03:00 Home Exercises For Carpal Tunnel Syndrome 00:01:00 Advanced Techniques For The Arms And Forearms 00:03:00 Hand/Thumb Pain 00:02:00 Home Trigger Point release Techniques For Thumb/Hand Pain 00:03:00 How To Do Cupping For Relaxation/Stress Relief 00:04:00 How To Do A Relaxing Cupping Massage For The Back And Neck 00:07:00 It's cupping time! The Lower Back And Limbs Welcome To Section 3 00:02:00 Lower Back Pain 00:04:00 How To Do Cupping For The Lower Back And Sciatica 00:07:00 Sciatica Summary 00:03:00 Sciatica 00:05:00 Sciatica Summary 00:03:00 Hip Pain, Piriformis Syndrome, Bursitis, S.I. Joint Dysfunction And Buttock Pain 00:07:00 How To Do Cupping For Hip Pain 00:03:00 Hamstring Strains, Hamstring Pain 00:01:00 How To Do Cupping For The Hamstrings 00:04:00 Thigh Pain and Groin Strains 00:01:00 How To Do Cupping For The Thigh (Quadriceps) and groin area 00:04:00 How To Do Cupping For Iliotibial Band Syndrome 00:03:00 Knee Pain, Runners Knee, Meniscal Pain 00:01:00 How To Do Cupping For Knee Pain 00:03:00 Calf Pain, Calf Cramps and Tired And Sore Calves 00:03:00 How To Do Cupping For The Calf 00:04:00 How To Stretch The Calf Muscles Correctly 00:02:00 Advanced Techniques For The Thighs, Hamstrings And The Lower Leg 00:02:00 Ankle Sprains, Chronic Ankle Pain 00:07:00 A Quick Word About Treating Acute Sprains And Strains 00:03:00 How To Do Cupping For Ankle Pain And Sprains 00:05:00 Treating Chronic Ankle Pain 00:03:00 Plantar Fasciitis/Heel Spur, Foot Pain and Tired Feet 00:02:00 How To Do Cupping For Plantar Fasciitis And Generalized Foot Pain 00:02:00 A Great Home Exercise For Plantar Fasciitis And Any Foot Pain 00:01:00 How Long Should You Stretch A Muscle For? Here is the answer 00:01:00 How Often Should You Treat Someone? 00:03:00 A Word about acupressure and also static cupping What about using static cupping? 00:02:00 Treating using acupressure points as well 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00