• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

45124 Courses

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.7(160)

By Janets

Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 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. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content 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 Thank you 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 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£25

Creative Card Making / Handmade Greeting Card Course

By One Education

Step into the colourful world of card design where creativity meets charm. This Creative Card Making / Handmade Greeting Card Course is perfect for anyone who enjoys crafting, celebrating, or simply wants to add a personal touch to life’s special moments. From birthdays and weddings to seasonal greetings and heartfelt messages, you'll explore how to craft beautiful handmade cards that leave a lasting impression. With each module, you'll discover design techniques, layout tricks, and ideas to bring your imagination to paper – all from the comfort of your own space. This course brings together flair and fun with easy-to-follow guidance. Whether you're new to crafting or just keen to sharpen your creative edge, you’ll find the inspiration to design with confidence. No glitter explosions or artistic tantrums here – just clear, enjoyable lessons to help you create keepsake-worthy cards for every occasion. Let your creativity take the lead, one fold at a time. Key Features The Creative Card Making / Handmade Greeting Card course includes the following offers: CPD Quality Standards Accredited Creative Card Making / Handmade Greeting Card Course Lifetime Access No Hidden Fees 24/7 Tutor Support Certificate Available with reasonable price Discover a wealth of learning opportunities with our diverse range of online courses including Creative Card Making / Handmade Greeting Card. From professional development to personal enrichment, we offer courses in a variety of subjects including business, technology, arts, languages, and more. This Creative Card Making / Handmade Greeting Card course is carefully curated by industry experts and delivered through engaging multimedia content, interactive quizzes, and hands-on projects to ensure an immersive learning experience. Curriculum Module 1: Introduction To Creative Card Making Module 2: Design Elements And Principles For Handmade Greeting Cards Module 3: Card-Making Techniques Module 4: Creating Unique Folds And Pop-Up Cards Module 5: Hand Lettering And Calligraphy Module 6: Card-Making Business Why This Online Course is Better for You: Unlike traditional classroom settings, our online Creative Card Making / Handmade Greeting Card course offers flexibility and convenience tailored to fit your busy lifestyle. With 24/7 access to Creative Card Making / Handmade Greeting Card course materials and the ability to learn at your own pace, you can study whenever and wherever it's most convenient for you. Plus, our online platform provides a supportive community of fellow learners and dedicated instructors to guide you every step of the way. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Creative Card Making / Handmade Greeting Card course is designed for anyone eager to expand their knowledge and skills, regardless of their background or experience level. Whether you're a working professional looking to upskill, a student seeking supplemental education, or an enthusiast pursuing a passion project, our courses are accessible to learners of all ages and abilities. Career path Invest in your future and unlock new career opportunities with our online Creative Card Making / Handmade Greeting Card course. Gain valuable skills and credentials that are in high demand in today's competitive job market. Whether you're looking to switch careers, climb the corporate ladder, or start your own business, This course provide the expertise and certification you need to succeed. Certificates Digital certificate Digital certificate - £9 Hard copy certificate Hard copy certificate - £15 A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Creative Card Making / Handmade Greeting Card Course
Delivered Online On Demand1 hour
£12

Functional Skills in Maths & English Course

5.0(2)

By Training Express

The Functional Skills in Maths & English Course provides an excellent opportunity to strengthen your essential skills in the most approachable and engaging way. Whether you're aiming to improve your understanding of numbers or boost your ability to communicate clearly, this course helps build a strong foundation. You’ll gain the confidence to tackle everyday situations, from budgeting and measuring to writing emails and reading instructions. This online course is designed for anyone wanting to refine their Maths and English abilities, without the need for physical attendance. With clear, easy-to-follow modules, you’ll have the flexibility to learn at your own pace and revisit topics as needed. Whether you're looking to gain a qualification or simply enhance your personal development, the course caters to your needs, ensuring you’re fully prepared for the challenges that come your way. Take the first step in strengthening your Maths and English skills today, and watch your confidence grow. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Numbers Module 02: Multiples Factors Module 03: Fractions and Power Module 04: Percentages and Averages Module 05: Expressions Module 06: Decimals Module 07: Exponents and Radicals Module 08: Graphs Module 09: The Profit and Loss Module 10: Perimeter and Area Module 11: Probability Module 12: Reading Module 13: Writing Module 14: Speaking Module 15: Grammar, Spelling and Punctuation Module 16: Sentence Structure Module 17: Composition Writing Learning Outcomes: Apply numerical concepts confidently for real-world problem-solving. Demonstrate proficiency in various aspects of linguistic communication. Interpret and create graphical representations with precision. Analyse and assess financial data, including profit and loss scenarios. Utilise probability concepts in decision-making processes. Construct grammatically sound sentences and compositions. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aiming to enhance mathematical and language skills. Students seeking foundational knowledge for further education. Professionals desiring a comprehensive functional skill set. Job seekers looking to boost their employability. Those pursuing a career in finance, communication, or administration. Adults returning to education for personal or career development. Aspiring entrepreneurs aiming to understand business concepts. Individuals wanting to excel in both numerical and linguistic domains. Career path Data Entry Clerk Administrative Assistant Customer Service Representative Retail Associate Receptionist Sales Support Assistant Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Functional Skills in Maths & English Course
Delivered Online On Demand1 hour
£12

Level 3 Tattoo Infection Control

5.0(3)

By School Of Health Care

Level 3 Tattoo Infection Control Are you willing to prevent infection with tattoos? We have created a broad tattoo infection control level 3 advanced diploma for learning the methods for sterilisation and disinfection. This tattoo infection control level 3 advanced diploma explains tattoo artists' hygiene standards and how to prevent infection in tattoo parlours. Also, the tattoo infection control level 3 advanced diploma goes into detail about prepping and caring for the skin. Moreover, this tattoo infection control level 3 advanced diploma also covers bloodborne pathogens and cross-contamination prevention. Additionally, the tattoo infection control level 3 advanced diploma teaches first aid and emergency response. Unlock your potential with our tattoo infection control level 3 advanced diploma course! Special Offers of this Tattoo Infection: Tattoo Infection Training Course: This Tattoo Infection: Tattoo Training Course includes a FREE PDF Certificate. Lifetime access to this Tattoo Infection: Tattoo Training Course Instant access to this Tattoo Infection: Tattoo Training Course 24/7 Support Available to this Tattoo Infection: Tattoo Training Course Level 3 Tattoo Infection Control This Tattoo Infection: Tattoo course consists of 07 modules. Course Curriculum of Tattoo Infection: Tattoo Course Module 01: Understanding Infection Control in Tattoo Module 2: Techniques for Sterilisation and Disinfection Module 3: Hygiene Practices for Tattoo Artists Module 04: Skin Preparation and Aftercare Module 05: Infection Prevention in Tattoo Studios Module 06: Bloodborne Pathogens and Prevention of Cross-Contamination Module 07: Emergency Response and First Aid. Assessment Method of Tattoo Infection: Tattoo Online After completing the Tattoo Infection: Tattoo Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Tattoo Infection: Tattoo Online After completing the Tattoo Infection: Tattoo course, you can instantly download your certificate for FREE. Who is this course for? Level 3 Tattoo Infection Control The tattoo infection control level 3 advanced diploma is intended to serve a broad spectrum of learners who are keen to further their tattoo-related knowledge and abilities. Requirements Level 3 Tattoo Infection Control To enrol in this Tattoo Infection: Tattoo Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Tattoo Infection: Tattoo Course. Be energetic and self-motivated to complete our Tattoo Infection: Tattoo Course. Basic computer Skill is required to complete our Tattoo Infection: Tattoo Course. If you want to enrol in our Tattoo Infection: Tattoo Course, you must be at least 15 years old. Career path Level 3 Tattoo Infection Control Your job in this field may benefit from this tattoo infection control level 3 advanced diploma.

Level 3 Tattoo Infection Control
Delivered Online On Demand2 hours
£12

Diploma in Counselling and Psychology

By Training Tale

Diploma in Counselling and Psychology Are you concerned about your prospects? Our expertly designed Diploma in Counselling and Psychology course is here to solve all of your problems at once. Learn all the necessary skills to join the psychology & counselling industry with confidence. It is a demanding profession, with the average salary of a Psychologist in the UK around 55,000 GBP. This qualification enables you to pursue a rewarding career in a rapidly growing counselling and psychology sector. Through this Diploma in Counselling and Psychology course, you will gain a thorough understanding of Counselling and Psychology. Learn how to assist people in dealing with personal and professional challenges. There are numerous opportunities to work in well-established institutions and companies. Enrol on our Diploma in Counselling and Psychology course today, become an expert in human minds, and take the first step toward a psychologist or counsellor career. Courses are included in this Diploma in Counselling and Psychology Bundle Course Course 01: Diploma in Counselling and Psychology Course 02: Diploma in Mastering Psychology Course 03: Clinical Psychology Diploma Others Included of Diploma in Counselling and Psychology Bundle Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Diploma in Counselling and Psychology course] Diploma in Counselling and Psychology Detailed course curriculum of the Diploma in Counselling and Psychology Course: Module 01: Introduction: Toward an Integrative Approach in Counselling Module 02: Therapeutic Relationship: Exploring Clients' Symptoms and Strengths Module 03: Powered by Struggles and Strengths Module 04: Positive Psychology in Counselling: What is It? Module 05: Psychoanalytic Therapy Module 06: Adlerian Therapy Module 07: Existential Therapy Module 08: Person‐Centred Therapy Module 09: Gestalt Therapy Module 10: Behaviour Therapy Module 11: Cognitive‐Behaviour Therapy Module 12: Reality Therapy Module 13: Feminist Therapy Module 14: Family Therapy Assessment Method After completing each module of the Diploma in Counselling and Psychology Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Diploma in Counselling and Psychology course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Diploma in Counselling and Psychology This Diploma in Counselling and Psychology course is suitable for anyone who wants to start a career as a psychologist or counsellor, as well as professionals who want to test their existing skills and knowledge. Requirements Diploma in Counselling and Psychology There are no specific requirements for this Diploma in Counselling and Psychology course because it does not require any advanced knowledge or skills. Career path Diploma in Counselling and Psychology After completing this Diploma in Counselling and Psychology course, candidates may pursue careers. Certificates Certificate of completion Digital certificate - Included

Diploma in Counselling and  Psychology
Delivered Online On Demand15 hours
£12

Psychology of Old Age Certificate

4.3(43)

By John Academy

Understand adult psychology and know how to deal with them in the Psychology of Old Age Certificate course. Throughout the course, you will understand adult psychology and explore whether the career in 'caring' or 'psychology' is for you or not. You will learn about 'Alzheimer's disease' and 'dementia' and also understand the difference between these two diseases. The course shows you how common people stereotype the older people and how it affects them. You will also learn about 'developmental psychology', and substance abuse in older people. Lastly, the course teaches you how to improve health and wellbeing of old people. Here, you will learn the effects of exercising, eating healthy in older age, caring for old people and more. Who is the course for? Anyone who wants to learn about 'old age' psychology Anyone who is interested in various topics related to psychology Anyone who is planning their career in psychology Anyone who is looking after the elderly and would like to learn theories of 'old age' 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. 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 recognised 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: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. About Your Course About your tutor FREE 00:02:00 About your course 00:03:00 Introduction to Psychology of Older Age What is 'Developmental Psychology'? 00:05:00 What is 'Gerontology'? 00:09:00 What we consider as 'old age' 00:09:00 What is 'ageing' and how it happens 00:08:00 Psychology of Older Age Common stereotypes of older people 00:08:00 How stereotyping affects older people 00:08:00 Life stages and Theories 00:11:00 What do we look forward to in our older age? 00:06:00 Mental Health and Old Age Memory-related issues 00:12:00 Learning disabilities 00:08:00 Alzheimer's disease and Dementia 00:09:00 Chronic illness and Disabilities 00:08:00 Substance abuse (addictions) 00:06:00 The Quality of Life What is 'Quality of Life'? 00:05:00 Loneliness factors in the elderly population 00:07:00 Coping with grief and bereavement 00:07:00 'Mild' and 'severe' depression 00:07:00 Fear of dying ('death anxiety') 00:09:00 Improving Health and Wellbeing The effects of exercising 00:09:00 Is it worth eating 'healthy' in older age? 00:09:00 What else affects 'health' and 'wellbeing'? 00:08:00 Caring for older people 00:06:00 Thank You & Good Bye! 00:02:00 Mock Exam Mock Exam - Psychology of Old Age Certificate 00:20:00 Final Exam Final Exam - Psychology of Old Age Certificate Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Psychology of Old Age Certificate
Delivered Online On Demand3 hours 41 minutes
£11.99

Raising Awareness on OCD: Strategies and Support

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Raising Awareness on OCD: Strategies and Support bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Raising Awareness on OCD: Strategies and Support bundle will help you stay ahead of the pack. Throughout the Raising Awareness on OCD: Strategies and Support programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Raising Awareness on OCD: Strategies and Support course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. Courses are included in this Raising Awareness on OCD: Strategies and Support Bundle? Course 01: OCD Awareness Course 02: Cognitive behavioural therapy Course 03: Dialectal Behaviour Therapy (DBT) Course 04: Cerebral Palsy Awareness Course 05: Concussion and Brain Injury Awareness Course 06: Domestic Violence and Abuse Awareness - Level 2 Course 07: Mental Health Laws and Awareness - Level 2 Course 08: Biohacking Your Physical and Mental Health Course 09: EFT - Emotional Freedom Technique Course 10: Counselling Course Course 11: Personal Hygiene As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Raising Awareness on OCD: Strategies and Support to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Raising Awareness on OCD: Strategies and Support: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable and in-demand skills without leaving your home. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 1: OCD Awareness Module 01: Introduction to Obsessive-Compulsive Disorder What is an Obsessive Compulsive Disorder? Understanding OCD Common Obsessions Compulsions Common Anxiety Disorders Other Disorders Reasons behind OCD Module 02: Signs, Symptoms and Causes of OCD Signs and Symptoms Causes Module 03: Identifying and Treating Specific OCD Symptoms Doubting and Checking Categories of Doubting Steps to Overcome Doubt and Control Checking Treating Shaming Treating Hoarding Revealing Common Superstitions and Rituals Summary Module 04: Treatment for OCD Introduction Cognitive Behavioural Therapy Cognitive Therapy Serotonin Reuptake Inhibitors Herbal Treatments Summary Module 05: Treating Children with OCD OCD in Children What is CBT? Developmental issues in CBT Principles and Strategies of CBT CBT for Children Benefits of Using CBT with Kids and Youth How to Treat a Child with OCD? Summary Module 06: Overcoming OCD Common Types of OCD Distortion Dismissing Unreasonable Doubts Control over Thoughts Assessing and Writing OCD narratives Summary Module 07: Relapse Prevention and Recovery Process of Recovery Returning to Work Effective Relapse Prevention Relationship with Partner Relationship with Children Summary Module 08: Living with OCD Families with OCD How Does OCD Affect Families? Diagnosis of Relatives Coping Up with Family Member's OCD Self-Care Helping Family and Friends Summary Course 2: Cognitive behavioural therapy Psychology of Stress Individual experiences of 'stress' Stress Management Psychology of 'Anxiety' Anxiety Disorders Coping with Anxiety Final Words Course 3: Dialectal Behaviour Therapy (DBT) Introduction Introduction What is Counselling & Psychotherapy About Dialectical Behaviour Therapy (DBT) DBT Strategies & 'Life Skills' Treatment by DBT DBT for Psychological Disorders Effectiveness of DBT Course 4: Cerebral Palsy Awareness Understanding Cerebral Palsy Causes and Symptoms of Cerebral Palsy Epidemiology of Cerebral Palsy Diagnosis of Cerebral Palsy Principles of Treatment Principles of Rehabilitation: Occupational and Physical Therapy Care Planning Typical Child vs Child with Cerebral Palsy Child, Family and Therapist Working as a Team Course 5: Concussion and Brain Injury Awareness Introduction To Brain Injury Concussion Awareness Acquired Brain Injury Sports-related Concussion And Brain Injury Rehabilitation Prevention Course 6: Domestic Violence and Abuse Awareness - Level 2 Introduction to Domestic Violence & Abuse The Components of Domestic Violence The Impact of Domestic Violence on Victims The Impact of Domestic Violence and Abuse on Children Assessing the Risks of Domestic Violence and Abuses on Children Supporting the Victim and Reporting Incidents Record Keeping Course 7: Mental Health Laws and Awareness - Level 2 The Mental Capacity Act Interface with Legislation, Policy and Procedures Deprivation of Liberty Safeguards The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic Mental Health Legislation and Services Liberty Protection Safeguards (LPS) Course 8: Biohacking Your Physical and Mental Health Introduction Sleep - So MUCH More Than Just Rest Blue Light & Red Light Mindfulness & Movement What You Put In Your Mouth is KEY! Hidden Secret - 'Cryotherapy' Importance Of PURE Air Final Thoughts & Recommendations Course 9: EFT - Emotional Freedom Technique What Is EFT (Emotional Freedom Technique)? EFT and Emotions, The Brain (EFT with the body) EFT Procedure Detailed Instructions of EFT Applying EFT to Physical Issues Treating Children with EFT EFT That Can Improve/ Heal Life & Tips Doing Business with EFT Course 10: Counselling Course Introduction to the course Understanding Psychotherapy Starting Psychotherapy Practice Your Potential Clients in Therapy Different Types of Psychotherapy Internet-Based Therapy Course 11: Personal Hygiene Introduction to Personal Hygiene and a Brief History Looking Clean, Smelling Clean Improving and Maintaining Oral Health Care of the Eyes Ear Care Secrets Foot & Nail Care in Personal Hygiene Hair Care Hygienic Ways Hygienic Approach to Skin Care Maintain Good Toilet Hygiene Potential Hygiene Guidelines Personal Hygiene During Coronavirus Pandemic CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Raising Awareness on OCD: Strategies and Support bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Raising Awareness on OCD: Strategies and Support
Delivered Online On Demand
£53

Law Conversion Course

5.0(2)

By Training Express

The Law Conversion Course is a perfect opportunity for those looking to switch careers or enhance their knowledge in the legal field. This online programme is designed for graduates from non-law backgrounds who are keen to explore the world of law and pursue a career in it. Whether you're interested in becoming a solicitor or barrister, this course covers the essential legal principles, providing a robust understanding of the law. With a strong focus on critical thinking, legal research, and communication, you’ll develop a solid foundation that can set the stage for your future legal studies or career. Designed for those who are eager to dive into the law without the need for in-person attendance, this course is ideal for anyone looking to gain a strong understanding of legal concepts. The flexibility of an online format allows you to study at your own pace, making it easier to balance alongside your other commitments. With an emphasis on law theory, you'll be well-equipped to tackle the challenges of further legal study or to confidently enter the legal sector in the future. This course offers the perfect blend of detailed learning and career-relevant insights Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Law and Legal Systems Module 02: Contract Law Module 03: Criminal Law Module 04: Constitutional and Administrative Law Module 05: Introduction to Human Rights Law Module 06: Tort Law Module 07: Property Law Module 08: Equity and Trusts Module 09: Legal Research Project Learning Outcomes Analyse legal principles and their applications in diverse contexts. Demonstrate a comprehensive understanding of Contract, Criminal, and Constitutional Law. Evaluate the impact of Human Rights Law on contemporary legal issues. Apply knowledge of Tort, Property, and Equity and Trusts in practical scenarios. Conduct effective legal research, showcasing analytical and critical thinking skills. Develop a solid foundation for pursuing a successful career in law. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Graduates seeking a career transition into law. Professionals in related fields aspiring to enhance legal knowledge. Individuals with a keen interest in understanding legal systems. Those pursuing a diverse and challenging legal education. Career changers aiming for a rewarding path in law. Students looking to build a strong foundation in legal principles. Individuals intrigued by the dynamics of human rights and constitutional law. Anyone wanting a comprehensive understanding of legal concepts. Career path Solicitor Barrister Legal Consultant Compliance Officer In-House Counsel Legal Researcher Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Law Conversion Course
Delivered Online On Demand1 hour
£12

JumpStart to Jira for Administrators | Jira Administration (TTDV7540)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This is an introductory-level course for Administrators who are new to Jira (this is NOT for experienced Jira admin or users). Students should have a background in basic administration. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment, exploring several practical use cases that provide context as to where and when to use Jira, students will learn about: user management global and project permissions project roles schemes configuration of issue types, workflows, and screens Tracking issues is a critical component of any project management strategy. JIRA provides a web based single repository for creating, tracking and reporting on feature requests, bugs reported, or managing workflow. Geared for administrators new to Jira, JumpStart to Jira for Administrators | Jira Administration is a two-day, hands-on course that explores the most important tasks required to set up Jira, providing students with ample hands-on experience using common administration tasks. This hands-on course enables the Student to administer a JIRA instance and ?learn by doing?. The focus of this course is on Best Practices, and practical skills. Getting started with JIRA Administration JIRA conceptual review Core concepts Terminology Infrastructure JIRA roles Groups vs Roles Overview Project roles Creating a role Project scaling JIRA User management Project Resolution Project status Resolved status Resolution date Schemes Overview Project scope schemes Adding users to schemes Issue type schemes Notification schemes Permission schemes Issue security schemes working with schemes JIRA as a Platform Overview What can be configured Basic JIRA project setup Advanced project setup Workflows Overview Designing a workflow Defining a workflow Implementing a workflow Deploying workflows Workflow events Transitions and sub-tasks Custom Fields Overview Field types Field context Limiting contexts Adding contexts Screens and field configuration Best practices for custom fields User Lifecycle Overview Adding users Adding third-party users Modifying users Deactivating users Remote JIRA Access Overview Emails SQL REST Webhooks XML and RSS Command Line Interface Integrating JIRA with other applications Migrating Data into JIRA Overview Migration steps The CSV importer JIRA cloud migration Summary and Best Practices Looking back at the ?Big Picture? Optional - Jira Certification Prep Review Additional course details: Nexus Humans JumpStart to Jira for Administrators | Jira Administration (TTDV7540) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the JumpStart to Jira for Administrators | Jira Administration (TTDV7540) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

JumpStart to Jira for Administrators | Jira Administration (TTDV7540)
Delivered OnlineFlexible Dates
Price on Enquiry

30 Day Yoga Challenge and Detox Diet Transformation System

By iStudy UK

The 30 Day Yoga Challenge and Detox Diet Transformation System is designed to promote physical wellness and weight loss, emotional wellness, and spiritual wellness. During this in depth training, you will learn how to create miracles, healing and happiness in your own life. You'll learn how to use yoga to transform your physical, spiritual and emotional well-being. This course is designed to help you create positive health habits that will dramatically improve the quality of your life on all levels. Whatever you may be dealing with can be healed, transformed and you can break through to the next level. Begin by following this comprehensive system. You will also learn the amazing Shakira Yoga. The rest of the part trains you about Detox diet including the knowledge about anti-ageing raw foods diet, and more. What Will I Learn? In 30 days you will learn basics, fundamentals as well as intermediate through advanced yoga, meditation and cleansing dietary practices through video, audio and ebooks Requirements Physical Requirements: Yoga mat, rug or soft surface Suggested: Yoga strap, block and stability ball + some shopping for healthy ingredients for the diet plan + green smoothie cleanse Who is the target audience? This course is created for women and men ages 16 through 60 with all levels of physical ability All levels of ability with videos and material for beginners, intermediate and up to advanced level practices. Introduction and Course-Wide Materials Intro to this Course and Hello From Dashama FREE 00:05:00 READ THIS FIRST: Quick Start Success Guide. Ebooks and Written Material 01:00:00 Yoga Q&A 00:34:00 Diet Q&A 01:11:00 Meditations Read this First: Create a Daily Meditation Practice 00:05:00 Chakra Balancing Guided Meditation 00:09:00 Samadhi Meditation Devi Prayer 00:21:00 Yoga Nidra Meditation 00:13:00 Guided Meditation shifting your paradigm 00:17:00 Soul Healing Guided Meditation 01:08:00 Day 1 Day 1: Read This 00:05:00 Salute the Sun! Rise & Shine with Yoga 00:05:00 Grounding Yoga 00:19:00 Day 2 Day 2 Read This 00:05:00 How to Stengthen Weak Legs 00:07:00 Day 3 Day 3: Read This 00:05:00 Meditation For Beginners 00:06:00 Beginners Vinyasa Sun Salute B 00:06:00 Day 4 Day 4: Read This 00:05:00 Yoga for Hips & Lower Back- ALL Levels 00:06:00 Beginners Shoulders Mat Vinyasa 00:03:00 Day 5 Day 5: Read This 00:05:00 Fire Practice - Vigorous Vinyasa 01:22:00 Day 6 Day 6: Read This 00:05:00 Miracle Manifestation Yoga Life in Balance 00:05:00 Day 7 Day 7: Read This 00:05:00 Intermediate Surya Namaskar Variation 00:10:00 Day 8 Day 8: Read This 00:05:00 Yoga for Hips & Inner Thighs 00:09:00 Day 9 Day 9: Read This 00:05:00 Day 10 Day 10: Read This 00:05:00 Balance Yoga Sequence- Level 2/3 00:05:00 Shakira Yoga! Hips Don't Lie. All levels 00:06:00 Day 11 Day 11: Read This 00:05:00 Wild Thing Yoga Sequence 1 week agoMore 00:04:00 Day 12 Day 12: Read This 00:05:00 6 Pack Yoga Abs part 1 00:04:00 Day 13 Day 13: Read This 00:05:00 Back Bend Bridge Leg Sequence 00:08:00 Day 14 Day 14: Read This 00:05:00 Mantras and the Power of Om 00:04:00 6 Pack Yoga Abs Part 2 00:03:00 Day 15 Day 15: Read This 00:05:00 Sixth Chakra Practice Eyes Closed Yoga 01:11:00 Day 16 Day 16: Read This 00:05:00 Bali Booty Yoga Practice 01:09:00 Day 17 Day 17: Read This 00:05:00 HANDSTAND Press Up- Yoga 00:05:00 Day 18 Day 18: Read This 00:05:00 Face Massage and Yoga 00:09:00 Day 19 Day 19: Read This 00:05:00 Standing Shoulders and Hamstrings Sequence 00:05:00 Day 20 Day 20: Read This 00:05:00 All Levels Prayer Twist Vinyasa 00:04:00 Anti-Aging Raw Food Snack- Weight Loss Diet with Dashama 1 week agoMore 00:05:00 Day 21 Day 21: Read This 00:05:00 Advanced Core Power Sequence- Vinyasa Yoga Level 23 00:07:00 Day 22 Day 22: Read This 00:05:00 Hips & Heart Sequence- Vinyasa Yoga 23 00:05:00 Day 23 Day 23: Read This 00:05:00 Advanced Standing Balance Bow Airplane Half Lotus 00:09:00 Yoga for Knee Injury 00:11:00 Day 24 Day 24: Read This 00:05:00 Yoga for a Shoulder Injury 00:27:00 Day 25 Day 25: Read This 00:05:00 Bed Yoga Stomach Massage 00:08:00 Day 26 Day 26: Read This 00:05:00 Beginners Balance Yoga Sequence 00:05:00 Day 27 Day 27: Read This 00:05:00 Bed Yoga Morning Energizer 00:08:00 Day 28 Day 28: Read This 00:05:00 Yoga for Lower Back Pain 00:15:00 Day 29 Day 29: Read This 00:05:00 Bliss Breath Pranayama 00:06:00 Day 30 Day 30: Read This 00:05:00 Bed Yoga Wide Leg Forward Bend 00:03:00 Next Steps Lower Back Strength and Stretch 00:06:00 Seated Forward Bends For tight hamstrings and lower back 00:08:00 Warrior Standing Power Sequence 00:06:00 Full Practice 80 minutes - All Levels 01:22:00 Dive Bomber Push Ups aka Swoop Through Push Ups 00:02:00 Yoga to Advance Your SPLITS 00:04:00 Full Wheel Drop Backs - Advanced Practice 00:03:00 Rise and Shine with Yoga Sun Salutations 00:05:00 Resources Resource - 30 Day Yoga Challenge and Detox Diet Transformation System 00:00:00 Course Certification

30 Day Yoga Challenge and Detox Diet Transformation System
Delivered Online On Demand17 hours 13 minutes
£25