1133 Courses in Cardiff

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Level 2 HACCP Training Courses

Introducing “Hire a Therapist” Package: Personalized Support for Your Mental Health and Emotional Well-being Are you considering seeking professional support for your mental health and emotional well-being? Miss Date Doctor’s “Hire a Therapist” Package offers you personalized and confidential counselling sessions with experienced therapists to help you navigate life’s challenges, overcome obstacles, and achieve personal growth. Therapy provides a safe and supportive space to explore your thoughts, emotions, and concerns with the guidance of a skilled therapist. Our team of dedicated therapists is committed to helping you enhance your overall well-being and lead a more fulfilling life. Here’s how the “Hire a Therapist” Package can support you: Personalized Assessment: Our therapists will conduct a thorough assessment to understand your unique needs and goals for therapy. Individualized Approach: Your therapy sessions will be tailored to address your specific concerns and support your personal growth. Emotional Support: We offer a compassionate and non-judgmental environment where you can freely express your feelings and experiences. Confidentiality: Your therapy sessions are completely confidential, ensuring a safe space for open and honest communication. Coping Strategies: Our therapists will equip you with practical coping strategies to manage stress, anxiety, and other emotional difficulties. Self-Exploration: Therapy encourages self-discovery and self-awareness, helping you gain insights into your thoughts, behaviours, and emotions. Goal Setting: Together with your therapist, you’ll set achievable goals to work towards positive change and personal growth. Flexible Sessions: “Hire a Therapist” Package offers flexibility in scheduling sessions, accommodating your availability and preferences. The “Hire a Therapist” Package at Miss Date Doctor is designed to provide you with personalized support and guidance on your journey to better mental health and emotional well-being. Our skilled therapists are committed to helping you overcome challenges, enhance your resilience, and lead a more fulfilling life. Invest in your mental and emotional health and take the first step towards positive change with the “Hire a Therapist” Package. Embrace the opportunity to explore your thoughts and feelings in a confidential and supportive environment. Let our experienced therapists guide you towards a brighter and more empowered future. 3 x 1 hour sessions https://relationshipsmdd.com/product/hire-a-therapist-package/

Introducing In-Person Couples Therapy Package: Strengthening Relationships Through Personalized Guidance and Connection Are you and your partner facing challenges in your relationship, longing for effective communication, intimacy, and mutual understanding? Miss Date Doctor’s In-Person Couples Therapy Package offers you and your partner the opportunity to engage in face-to-face therapy sessions, fostering a deeper connection and personalized guidance to enhance your relationship. Relationships can experience ups and downs, and sometimes external guidance is needed to navigate through difficult times. Our experienced couples therapists are committed to providing you and your partner with a safe and supportive space to address concerns, improve communication, and strengthen your bond. Here’s how the In-Person Couples Therapy Package can support you: Personalized Couples Assessment: Our therapists will conduct a thorough assessment to understand your relationship dynamics, strengths, and areas that need improvement. Tailored Therapy Sessions: In-person couples therapy offers personalized sessions that cater to your unique needs and relationship goals. Communication Enhancement: We’ll provide effective communication tools and techniques to promote healthy and open dialogues between you and your partner. Conflict Resolution Skills: Our therapists will guide you in developing constructive conflict resolution strategies to navigate disagreements. Reigniting Intimacy: In-person therapy can help you and your partner reconnect emotionally and physically, fostering a deeper sense of intimacy. Emotional Connection: We’ll focus on building emotional connection and understanding between you and your partner. Navigating Transitions: Whether it’s a life change or milestone, therapy can help you navigate transitions while maintaining a strong relationship. Shared Growth: The In-Person Couples Therapy Package promotes shared growth, allowing you and your partner to evolve together as a couple. The In-Person Couples Therapy Package at Miss Date Doctor is designed to strengthen your relationship through face-to-face interaction and expert guidance. Our experienced couples therapists provide a secure environment for open conversation and collaborative problem-solving. Invest in the growth and well-being of your relationship and take the first step towards enhanced connection with the In-Person Couples Therapy Package. Embrace the opportunity to improve communication, address challenges, and build a resilient and loving partnership. Let our skilled therapists guide you and your partner towards a stronger and more fulfilling relationship journey. 1 hour session x3 https://relationshipsmdd.com/product/in-person-couples-therapy/

A Day in Wales. Join me for this fantastic photography workshop of woodland, lakes and waterfalls.In this course we cover all of the above. What do you need to bring with you?Camera/lenses/Spare memory card/batteries/tripod - A digital camera with "semi-automatic/manual" controls (Aperture and Shutter priority) is recommended to get the most from the course. Filters (if you have them) A packed lunch/snacks The relevant user manual for your camera Warm/waterproof clothing and suitable footwear - weather can be unpredictable all year round in Snowdonia. A notepad and pen What happens in bad weather?I monitor weather forecasts and if conditions are predicted to be completely unsuitable, to ensure both your safety and enjoyment of the day, it may be necessary to cancel a workshop. I will endeavour to provide at least 24hrs notice, although this cannot always be guaranteed; you will be offered either a full refund or a place on a future course.

Advice for singles and if you are in a relationship Your own dedicated coach 2 x 50 min chats per month Coaching on relationships Support and advisory tools on strategies Emotional intelligence knowledge and information Someone to talk to all year round Dating advice for singles X 2 phone sessions https://relationshipsmdd.com/product/m-d-d-consistent-relationship-support-package/

Looking for expert relationship advice? Our Relationship Coaching Session is the perfect solution for anyone seeking guidance and education on how to improve their relationships. Our one-hour session provides instant advice from a qualified relationship coach, covering a wide range of topics to help you better understand and improve your relationships. During the session, you’ll learn how to communicate more effectively, identify and overcome relationship obstacles, and develop strategies to strengthen your relationships. Our coach will cover different areas such as trust building, conflict resolution, and creating a healthy relationship dynamic. SPECIAL OFFER FOR NEW CUSTOMERS ONLY: As a new customer, you’ll receive a free 30-minute follow-up call to ensure that you’re making progress and getting the support you need. Whether you’re struggling with a current relationship or just want to improve your overall relationship skills or have a relationship problem which is upsetting you, our Relationship Coaching Session can help. Don’t wait to take the first step towards better relationships. Book your session today! https://relationshipsmdd.com/product/relationship-coaching-session/

Introducing Co-Parenting Counseling Package: Nurturing Healthy Co-Parenting Relationships for the Well-being of Your Children Are you facing challenges in co-parenting and seeking support to build a healthy and cooperative co-parenting relationship? Miss Date Doctor’s Co-Parenting Counseling Package offers you a constructive and nurturing environment to enhance communication, resolve conflicts, and prioritize the well-being of your children. Co-parenting after separation or divorce can be complex and emotionally charged. Our experienced counselors specialize in co-parenting dynamics and are here to assist you in navigating the journey of raising your children together in a positive and supportive manner. Here’s how the Co-Parenting Counseling Package can support you: Effective Communication: Our counselors will help you develop open and effective communication strategies, ensuring that you can discuss parenting matters calmly and constructively. Conflict Resolution: Co-parenting counseling focuses on resolving conflicts in a healthy and respectful manner, reducing tension and promoting a harmonious co-parenting relationship. Creating a Co-Parenting Plan: We’ll work with you to create a comprehensive co-parenting plan that outlines responsibilities, schedules, and agreements, providing clarity and structure for both parents and children. Child-Centered Approach: The well-being of your children is paramount. Co-parenting counseling emphasizes a child-centered approach, ensuring that their needs and feelings are considered in decision-making. Co-Parenting Boundaries: Establishing healthy boundaries is essential for successful co-parenting. Our counselors will help you set clear boundaries and expectations for co-parenting interactions. Parenting Consistency: Consistency is crucial for children’s stability. Co-parenting counseling promotes parenting consistency between households to provide a sense of security for your children. Handling Transitions: Our counselors will assist you in managing transitions between households, ensuring that they are as smooth and stress-free as possible for the children. Conflict Minimization: Co-parenting counseling aims to minimize conflict and create a more harmonious environment for all family members involved. The Co-Parenting Counselling Package at Miss Date Doctor is designed to empower you and your co-parent to build a positive and supportive co-parenting relationship. Our counsellors provide guidance and support to ensure that your children grow up in a loving and stable environment, even after separation or divorce. Invest in the well-being of your children and take the first step towards nurturing a healthy co-parenting relationship. Embrace the opportunity to create a positive and cooperative co-parenting dynamic, focused on the best interests of your children. Let our skilled counsellors guide you towards a brighter co-parenting future filled with understanding, cooperation, and mutual respect 3 X 1 hour https://relationshipsmdd.com/product/co-parenting-counselling-package/

Introducing Pre-Marital Counselling London Package: Building a Strong Foundation for a Lifelong Partnership Are you planning to tie the knot and seeking guidance to ensure a strong and healthy foundation for your marriage? Miss Date Doctor’s Pre-Marital Counselling London Package offers you expert support and valuable insights to prepare for a fulfilling and lasting partnership. Pre-marital counselling is a proactive approach that helps couples explore their expectations, communication styles, and potential areas of growth before entering into marriage. Our experienced counsellors in London are dedicated to helping you lay the groundwork for a successful and harmonious marriage. Here’s how the Pre-Marital Counselling London Package can support you: Effective Communication: Our counsellors will guide you in developing open and effective communication skills to express your feelings and needs clearly, fostering understanding and connection. Conflict Resolution: Pre-marital counselling addresses conflict resolution strategies, ensuring that you are equipped with healthy ways to navigate disagreements and challenges in your marriage. Exploring Expectations: We’ll help you and your partner explore and align your expectations about various aspects of marriage, such as roles, finances, family, and lifestyle. Strengthening Intimacy: Pre-marital counselling provides a safe space to discuss emotional and physical intimacy, fostering a deeper connection and understanding between you and your partner. Financial Planning: Our counsellors will assist you in creating a financial plan, emphasizing financial transparency and teamwork to manage shared resources. Building Trust: Trust is a fundamental aspect of a successful marriage. Pre-marital counselling helps you and your partner build and strengthen trust through open and honest discussions. Shared Values and Goals: We’ll explore your shared values and long-term goals, ensuring that you are aligned in your vision for the future. Handling Life Transitions: Pre-marital counselling can prepare you for various life transitions, such as starting a family, changing careers, or dealing with unexpected challenges. The Pre-Marital Counselling London Package at Miss Date Doctor offers you an opportunity to invest in the foundation of your marriage. Our skilled counsellors provide a safe and supportive space to discuss important topics, discover each other’s strengths, and build a solid framework for a successful partnership. Take the first step towards a joyful and harmonious marriage with the Pre-Marital Counselling London Package. Embrace the opportunity to grow together, nurture your relationship, and create a lasting bond that will withstand the tests of time. Let our experienced counsellors guide you towards a fulfilling and loving marriage that stands the test of time. 3 x 1 hour https://relationshipsmdd.com/product/pre-marital-counselling-london-package/

Introducing the Occupational Therapy Package: Empowering Independence and Enhancing Daily Living Are you seeking specialized support to enhance your daily living skills and regain independence in your life? Miss Date Doctor’s Occupational Therapy Package offers you expert guidance and personalized interventions to overcome challenges and achieve your goals. Occupational therapy is a client-centered approach that focuses on improving functional abilities and promoting independence in various aspects of life. Our experienced occupational therapists are committed to empowering you to participate fully in meaningful activities and overcome obstacles that may be affecting your daily functioning. Here’s how the Occupational Therapy Package can support you: Comprehensive Assessment: Our occupational therapists will conduct a thorough assessment of your physical, cognitive, and emotional abilities to understand your unique needs and challenges. Personalized Goals: Based on the assessment, we’ll work with you to set personalized goals that align with your aspirations and desired outcomes. Functional Interventions: Through a range of evidence-based interventions, we’ll address challenges related to self-care, productivity, and leisure activities, helping you regain independence in your daily life. Adaptive Techniques: Our therapists will introduce you to adaptive techniques and assistive devices that can support your engagement in various activities and promote greater autonomy. Workplace Support: For individuals seeking occupational therapy for work-related challenges, we’ll provide support and recommendations to improve workplace ergonomics, time management, and productivity. Cognitive Strategies: If cognitive challenges are affecting your daily functioning, our occupational therapists will introduce cognitive strategies to enhance memory, attention, and executive functions. Sensory Integration: For individuals experiencing sensory processing difficulties, our therapists will employ sensory integration techniques to help you better process sensory information and improve daily functioning. Lifestyle Modification: Occupational therapy goes beyond managing symptoms; it aims to improve overall well-being. We’ll work with you to make lifestyle modifications that promote health and balance. The Occupational Therapy Package at Miss Date Doctor is tailored to meet your unique needs and goals. Our compassionate occupational therapists will collaborate with you every step of the way to ensure that your therapy experience is positive, empowering, and transformative. Experience the benefits of occupational therapy and embrace a more independent and fulfilling life. Invest in your well-being and unlock your potential to thrive in everyday activities. Take the first step towards empowerment and enhanced daily living with the Occupational Therapy Package. Let our expert therapists guide you towards a life filled with greater independence, productivity, and satisfaction. 4 X 1 hour https://relationshipsmdd.com/product/occupational-therapy-package/