3919 Courses in Cardiff delivered Live Online

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

How to improve dating success Learning emotional intelligence Improve social awareness Training on emotional resilience Motivation and Patience training Learn Communication Skills Enhance Patience and Introspection Coping mechanisms for stress Learn how to understand people better Learn Assertive communication Improve observation skills Improve mental and physical attraction Are you tired of going on endless dates with no results? Do you struggle to communicate effectively with potential partners or build the confidence needed to succeed in the dating world? If so, Miss Date Doctor UK’s Dating Coach Course is here to help! Our comprehensive course is designed to provide individuals with the tools and knowledge needed to improve their dating skills and find meaningful relationships. Our expert coaches will guide you every step of the way, from developing your personal brand and building confidence to mastering communication skills and navigating online dating. The Dating Coach Course at Miss Date Doctor UK is ideal for anyone looking to enhance their dating experience, whether you’re single and searching for the right partner, or simply looking to improve your current relationship. Our course is tailored to meet the unique needs of each individual, and our coaches are dedicated to providing personalized support and guidance to help you achieve your goals. At Miss Date Doctor UK, we believe that finding love should be a fun and enjoyable experience. That’s why our Dating Coach Course is designed to help you approach dating with a positive and confident mindset, and to give you the skills and knowledge needed to make informed decisions about your dating life. Our course covers a wide range of topics, including building self-esteem, overcoming fears and anxieties, mastering communication skills, and navigating online dating platforms. Whether you’re looking to improve your social skills, build your confidence, or simply learn more about the dating world, Miss Date Doctor UK’s Dating Coach Course has everything you need to succeed. Our course is packed with the key pillars of improving your dating “personal development”, “relationship advice”, “self-improvement”, “emotional intelligence”, “interpersonal skills”, “communication techniques”, “love coaching”, “dating tips”, “online dating”, “dating apps”, and more! So why wait? Sign up for the Dating Coach Course at Miss Date Doctor UK today and start your journey towards a happier, healthier dating life! https://relationshipsmdd.com/product/dating-coaching-course/

PMI-RMP® Exam Prep: In-House Training This course is aimed at preparing the participant to pass the PMI-RMP® (Risk Management Professional) exam. The course will also provide practical tips and tools that can be used in any organization's project management risk practices. In this expanded session, you will also have time to practice your exam taking skills with coaching from a credentialed instructor. The course includes the tool RMP-IQ, with sample exam questions to practice for the exam and allow participants to see their knowledge level in the various domains. What You Will Learn At the end of this course, participants will be able to: Explain the value and benefits of the PMI-RMP® credential Perform a self-assessment of your knowledge and skills Prepare a study plan that will allow you to pass the exam Foundation Concepts The Risk Management Professional (PMI-RMP®) Exam PMI's Standard for Risk Management Portfolios, Programs and Projects Key risk definitions Risk management life cycle Levels of Risk Management Enterprise Risk Management Portfolio Risk Management Program Risk Management Project Risk Management Risk Strategy and Planning: Part 1 Task 1: Perform a preliminary document analysis Task 2: Assess project environment for threats and opportunities Task 3: Confirm risk thresholds based on risk appetites Risk Strategy and Planning: Part 2 Task 4: Establish risk management strategy Task 5: Document the risk management plan Task 6: Plan and lead risk management activities with stakeholders Agile, programs, and portfolio aspects of risk strategy and planning Risk Identification: Part 1 Objectivity and bias Task 1: Conduct risk identification exercises Risk Identification: Part 2 Task 2: Examine assumption and constraint analysis Task 3: Document risk triggers and thresholds based on context / environment Task 4: Develop risk register Agile, programs, and portfolio aspects of risk identification Risk Analysis: Part 1 Task 1: Perform qualitative analysis Risk analysis in an agile environment Risk Analysis: Part 2 Task 2: Perform quantitative analysis Task 3: Identify threats and opportunities Program and portfolio aspects of risk analysis Risk Response Task 1: Plan risk responses Agile, programs, and portfolio aspects of risk response planning Task 2: Implement risk responses Monitor and Close Risks: Part 1 Task 1: Gather and analyze performance data Monitor and Close Risks: Part 2 Task 2: Monitor residual and secondary risks Task 4: Monitor project risk levels Task 3: Provide information required to update relevant project documents Agile, programs, and portfolio aspects of monitoring and closing risks

Learning Agile or Scrum without the necessary work context is ineffective; more importantly, learning Agile or Scrum without a platform to practice and apply them on an ongoing basis is futile. IIL's Mastering Hybrid Approaches for Projects workshop provides both context and practice across all aspects of the value delivery system including waterfall, hybrid, and Agile approaches. This workshop provides options that span the value delivery spectrum for developing scope, estimating durations, managing schedules, and tracking progress. For example, participants will learn how to organize scope with a WBS and prioritize it with a backlog as well as lead the day-to-day work with a task board. The workshop also covers how to integrate iterations and releases into a high-level predictive schedule. The project team is the heart of the project. This workshop explains various team roles along with key leadership skills such as emotional intelligence and decision making. Key tenets of Agile practices, such as servant leadership and self-managing teams are explored along with the different types of meetings, such as daily stand-ups, iteration planning, and demonstrations. Those who attend will be better prepared to situationally apply agile and hybrid concepts. In addition, this course provides the structure for critical thinking to occur: to know and understand when to apply a predictive approach, when to apply an adaptive approach and when and how to combine them in a tailored and customized hybrid approach that meets the needs and demands of the project and the organization. The learning experience design is rooted in real world perspectives, leveraging team exercises based on a comprehensive case study.

SAFe® DevOps: In-House Training This course provides a comprehensive overview for understanding the DevOps skills needed to accelerate time-to-market by improving the flow of value through the Continuous Delivery Pipeline. You will map the current value stream through the delivery pipeline from idea to cash and identify practices that will eliminate bottlenecks to flow. The course will build an understanding of the complete flow of value from Continuous Exploration to Continuous Integration, Continuous Deployment, and Release on Demand. What you will Learn After attending the class, attendees should be able to: Explain how DevOps enables strategic business objectives Apply a CALMR approach to DevOps to avoid automating broken processes Understand how successful DevOps requires continuous exploration, continuous integration, continuous deployment, and the ability to release to end users on demand Incorporate continuous testing and continuous security into the delivery pipeline Use value-stream mapping to measure flow and identify bottlenecks in the end-to-end delivery process Select DevOps skills and tools strategically for the fastest, most compelling results Prioritize DevOps solutions and investments for the greatest economic benefit Design and implement a multi-phased DevOps transformation plan tailored to their organization Work with all roles and levels in the organization to continually optimize the value stream Introducing DevOps Mapping your Continuous Delivery Pipeline Gaining alignment with Continuous Exploration Building quality with Continuous Integration Reducing time-to-market with Continuous Deployment Delivering Business Value with Release on Demand Taking action

Who is this course suitable for? Required to undertake asbestos fibre counting as part of their work Considering a career in asbestos analysis Responsible for managing asbestos analysts Prior Knowledge and Understanding Candidates for this course are expected to be aware of HSG 248 Asbestos: The Analysts' Guide (July 2021), and in particular Appendix 1, Fibres in air: sampling and evaluation of by phase contrast microscopy. Candidates will preferably have prior experience of analysing fibre count samples and may already be participating in a quality control scheme. In addition, candidates are expected to have had training to cover the core competencies outlined within the foundation material detailed within Table A9.1 of HSG248 Asbestos: The Analysts' Guide (July 2021). This may be achieved by In -house learning or through the P400 foundation module.

How can we interrupt the isolation of disabled, challenging and other ‘different’ children and adults? This is our lead workshop/training day and is both a values primer and a practical guide to successful strategies for developing inclusive practice in educational and non educational settings for children and young people of all ages. This is practical plus being a ‘hearts and minds’ day. What does inclusion mean? Can we imagine what an inclusive school look like? What do we have to do? The day gives those present opportunities to reflect on their attitudes and practice in relation to the inclusion of children and adults who are different or challenging. The Keys can be presented as a powerful interactive Keynote for large conferences. A great way to launch a conference as the first key is ‘welcome’. Learning Objectives Increased confidence regarding developing inclusive practice in mainstream schools and other settings Access to a wider range of practical strategies to impact on behaviour problems Deeper understanding of core values surrounding inclusion of disabled and challenging children and adults Opportunity to reflect on professional attitudes and behaviour towards parents and pupils New skills and processes to make inclusion successful Course Content The course answers the questions : Why inclusion? What is inclusion? How do we go about including high profile children or young people? What does inclusion have to do with me? Best delivered over the course of a full day, ‘Keys to Inclusion’ introduces participants to 6 guiding Ideas that underpin inclusive practice. The importance of WELCOME Inclusion is about Adults’ learning Taking the Long View Giftedness as a new paradigm for understanding disability and difference The Intentional Building of Relationships – ‘Circle of Friends’ work as an example of this Not doing it alone – the importance of Teams in developing inclusive practice.

Front-line communication plays a vital role in shaping the public perception of every organisation. This course is designed to help delegates organise their ideas and communicate clearly and effectively through email. By improving written communication skills, delegates will become more concise, communicate with conviction, and foster meaningful dialogue with their audience. These skills are essential for professionals who interact with the public, as improved communication leads to greater internal and external customer satisfaction. Delegates will learn how to: Write clearly and professionally, enhancing public perception of expertise Communicate more efficiently in writing, reducing wasted time and increasing profitability Craft concise, rapport-building messages for internal and external customers, fostering productivity and a positive workplace environment Topics Covered: Benefits of using email Determining the purpose of an email Steps to take before writing Inflection in written messages Effects of instant messaging and text messaging on communication Basic email structure and planning Writing effective subject lines Paragraph structure and organisation Including relevant details and summarising problems effectively Proper use of CC and BCC fields Why typing in all caps is considered shouting! Proofreading techniques This Email Etiquette course is a 90-minute interactive virtual session. Upon registration, delegates will receive online login instructions prior to the class date. This format allows delegates to enhance their skills conveniently from their home or office while improving their professional communication abilities.

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

Duration 2 Days 12 CPD hours This course is intended for Anyone managing the performance of others, including executives, managers, supervisors and team leaders will benefit from this course. Overview Explain how coaching can help employees achieve their full potential Recognize common coaching challenges Explain the key principles of the Thought model Explain the four steps of the GROW model Identify important guidelines for providing feedback Apply strategies that will motivate employees In the face of rapid, disruptive change, companies understand that command-and-control leadership is no longer viable. As a result, many firms are moving toward a coaching model in which managers facilitate problem solving and encourage employees? development by asking questions and offering support and guidance rather than giving orders and making judgments. Leaders can use the GROW and Thought models of coaching to become more skilled at listening, questioning, and drawing insights out of the people they supervise. This course will help you develop coaching skills that motivate employees to reach their full potential. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training. 1. The Purpose and Effect of Coaching What is Coaching? Characteristics and Beliefs of the Effective Coach Coaching Obstacles Knowing When to Manage and When to Coach 2. Coaching and The Thought Model The CFTAR Thought Model Point of View and Belief Systems Applying The Thought Model Facts vs. Stories 3. Coaching with the GROW Model Goals in the Context of GROW Clarifying the Current Reality Exploring the Past Developing Options and Choosing the Approach Creating the Final Plan 4. Navigating The Coaching Process Dimensions of Trust Identifying Obstacles and the SPAR Process Overcoming Resistance Giving Feedback Effectively Motivating Your Employee