52594 Courses in Cardiff delivered Online

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

The CIEH Introductory Certificate in Occupational Health and Safety provides an awareness of key health and safety issues, and the part that staff should play in keeping themselves and others free from harm at work. This course will give you a basic background in, and understanding of, general health and safety practices and the control measures required to reduce risks in the workplace.

Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care

Introduction to Diabetes (2-Day Course) - Norfolk ICB OnlyThis course is for those from the Norfolk ICB only using the unique booking code. Applicants not using this code nor Identifying themselves as Norfolk ICB employees will not be able to attend.Course Description:These two days of comprehensive training are designed for nurses, nurse associates, pharmacists, paramedics, and other Allied Healthcare Professionals (AHPs), and experienced healthcare assistants (HCAs) who are new to or fairly new to the field of diabetes care. If you've recently started seeing patients with diabetes, or are planning to; this course is tailored to provide you with the fundamental knowledge and skills required to confidently care for individuals with diabetes. The primary focus is on adults with Type 2 diabetes, although key recommendations and signposting for patients with Type 1 diabetes will also be covered.Diabetes presents a significant healthcare challenge, costing the NHS £10 billion each year and impacting patients and their families. Primary care professionals play a pivotal role in managing the ever-increasing numbers of people diagnosed with Type 2 diabetes. Good diabetes care is crucial and aligns with national and local policies supported by robust NICE guidance.These interactive days of learning will incorporate various methods, including case studies, to help you progress from basic knowledge to a more confident and positive approach in reviewing and managing patients with diabetes. 2 Day Introduction to diabetes management in primary care (This is intended to provide an overview the programme may change slightly) DAY ONE 09.15 Coffee and registration 09.30 Introduction and course objectives 09.45 Setting the scene - screening, diagnosis, prediabetes, patho-physiology and symptoms, remission in Type 2 diabetes 10.45 Coffee 11.00 Type 1 Vs Type 2 Diabetes 11.20 Metabolic Syndrome and Diagnostic Criteria 11.45 Diabetes Prevention Programme 12.15 Managing Diabetes in Primary Care and Supporting Lifestyle 12.30 Lunch 13.30 Pharmacological Management of Type 2 Diabetes 14.30 Methods for Monitoring Glucose 14.45 Diabetic Emergencies (hypos, HHS and DKA) 15.15 Sick Day Rules 15.30 Action plan, evaluation, and resources 15.45 Close DAY TWO 09.15 Coffee and registration 09.30 Review progress since Day 1 09.45 Macrovascular Complications 10.15 Modifiable Risk Factors leading to CVD 11.00 Coffee 11.20 Cholesterol & Hypertension Management 12.00 Microvascular Complications 12.30 Lunch 13.30 Diabetes and Emotional Wellbeing 14.30 Case Studies 15.30 Q&A, Evaluations 15.45 CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the physiology of diabetes and differentiate between Type 1 and Type 2 diabetes.2. Discuss methods for diagnosing diabetes and provide information to individuals newly diagnosed with Type 2 diabetes.3. Describe approaches that support achieving remission in Type 2 diabetes.4. Explain basic advice related to a healthy diet, various dietary approaches, and carbohydrate awareness.5. Discuss the modes of action of commonly used non-insulin medications.6. Identify major complications that may arise in individuals with long-standing diabetes and measures to limit or prevent them.7. Describe key advice for patients regarding the recognition and appropriate treatment of hypoglycaemia.8. Discuss DVLA guidance concerning driving and diabetes.9. Explain the risks of acute hyperglycaemia and provide advice to patients on self-managing illness periods.10. Provide examples of referral pathways to other services such as weight management, secondary care, podiatry, structured education, activity, and psychological services.11. Describe the process of routine foot review and factors influencing diabetic foot risk status.12. Discuss local recommendations for the appropriate use of blood glucose and ketone monitoring.13. Explain the key components and processes of an annual diabetes review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective diabetes care within primary care settings.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Coming soon! Embark on a dynamic journey towards administrative mastery with our Level 3 Business Administrator course. Tailored for individuals stepping into the vibrant world of business administration, be it through recent recruitment or a well-deserved promotion, this program is crafted to instil a distinctive set of skills and insights essential for success in the administrative landscape.

Learn how to use Master Projects and Resource Pools to create better visibility across projects. Course overview Duration: 4 hours This course shows you how to create Master Projects allowing you to roll several sub projects into a master view. It also shows techniques to create resource pools to share resources between projects to enable you to better manage your resource teams and check resource loading. This half day course looks at how to practically do this and setup both elements. This is aimed at existing users of Microsoft Project who need to create master schedules and share resources and loadings. Objectives  By the end of the course you will be able to: Create master projects Insert and update sub projects Create a resource pool Share resources between projects Check resource loadings between projects Content Working with multiple projects Consolidating projects Linking to sub projects Setting the master project as read only Saving consolidated projects Working on consolidated projects Setting task links between projects Getting source project information Removing projects from the consolidation Sharing resources Creating a resource pool Sharing resources Opening projects that share resources Updating the resource pool Refreshing the resource pool Opening a resource pool Removing resource sharing

Coming soon! Embark on a transformative odyssey into operational leadership with our Level 5 Operations Department Manager course. Meticulously designed for individuals venturing into the role of an Operations Department Manager, whether through recent recruitment or a well-deserved promotion, this program is a gateway to acquiring advanced skills and unique insights crucial for success in the realm of operations.

It is essential that those charged with responsibility for credit control and debt recovery have a full appreciation of the relevant law: no-one can negotiate effectively to recover a debt if they don't understand the ultimate sanctions they can apply. This programme is designed to give them a practical, up-to-date understanding of the law as it applies to your particular organisation. This course will help ensure that participants: Understand the relevant laws Know how and when to invoke legal processes Avoid legal pitfalls in debt collection negotiations Specific, practical learning points include: Definition of 'harassment' How to set up an in-house collection identity Whether cheques in 'full and final settlement' are binding The best steps to trace a 'gone away'... and many, many more. 1 Data protection and debt recovery There are a whole range of things which can be checked on members of the public and which are not affected by the restraints of the Data Protection Act. These will be explained in simple, clear terms so that staff can use this information immediately. 2 County Court suing The expert trainer will show how to sue for money owed, obtain judgment and commence enforcement action without leaving your desk. This module is aimed at showing how to make the Courts work for you instead of the other way around! 3 Enforcement of judgments There are many people who have a County Court Judgment (CCJ) against their debtor but who still remain unpaid. This session explains each of the enforcement methods and how to use them to best effect. Enforcement methods covered include: Warrant of Execution Using the sheriff (now known as High Court Enforcement Officers) Attachment of earnings Third Party Debt Orders Charging Orders (over property and goods) Winding-up companies and making individuals bankrupt 4 Office of Fair Trading rules on debt recovery Surprisingly few people are aware of the Office of Fair Trading rules on debt recovery and many of those that do know think they don't apply to them - but they do. Make sure you know what you need to! 5 New methods to trace elusive, absentee and 'gone away' debtors Why write the money off when you can trace the debtor and collect the money you are owed? 6 Credit checking of new and existing customers It makes sense to credit check would-be, new and existing customers to evaluate the likelihood of payment delays or perhaps not being paid at all. This session shows a range of credit checking steps, many of which can be done completely free of charge, including a sample credit application/ account opening form. 7 Late Payment of Commercial Debts Regulations Do your staff understand this legislation and how to use it to make people pay quicker than ever before? The trainer shows how. 8 The Enterprise Act The Enterprise Act made some startling changes to corporate and personal insolvency. What are the implications for credit control and debt recovery within your organisation?

Coming soon! Tailored for seasoned professionals, our Level 7 Senior Leader course is for those seeking to enhance their leadership capabilities, this program is designed for individuals aspiring to or currently occupying senior leadership roles. Delve into advanced concepts of strategic leadership, organizational effectiveness, and change management. Explore the nuances of decision-making at the executive level, honing your skills in navigating complex business landscapes.