3070 FA courses in Cardiff delivered Live Online

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

Logistics for Traders: Importance, Role and Benefits. This session will look at how logistics is a critical component within the supply chain but is often overlooked.

This course will equip non-registrants to allocate patients safely into face to face or telephone appointments, with an appropriate practitioner or service. The course will also equip non-registered staff to question for, recognise and allocate patients with urgent health needs.

A 10 week SATs Success course for students in year 6. Tutoring in English and Tutoring in Maths in a small group year 6 tutor session.

I am an experienced EFT Practitioner, Mindfulness Teacher, Therapist and Coach who specialises in helping women eliminate stress and anxiety. I offer sessions worldwide via the internet, or face to face in Halwill Junction, Okehampton and Exeter, Devon, UK. I also teach classes and run retreats. I love to empower my clients so that they can help themselves. I would love to hear from you, so please do get in touch.

Aimed for GP reception staff and HCAs, who work face to face booking patients in or HCAs doing the initial triage/observations. Receptionists and HCAs working in the urgent care setting or walk in centres may also find this beneficial as they also book patients in and monitor the waiting room.

COURSE INTRODUCTION  The purpose of this course is to introduce / refresh participants’ knowledge and skills in the essential aspects of diabetes management in their practice setting.  AIMS AND OBJECTIVES  Identify their current knowledge of diabetes care and how confident they feel about offering advice to a patient with diabetes and or their family. Purpose and outcomes of the main treatment options for people with diabetes . Discuss the importance of addressing the person’s needs and how regular clinic visits impact on the management of diabetes All course materials and certificate of attendance Accreditation 6 CPD points awarded completion. Accredited by One Awards (*Certificate £30) and CPD Standards (*Certificate free) Discuss how to build relationships and establish an environment that enables the person with diabetes to take an active role in their diabetes management  COURSE CONTENTS OVERVIEW  Aetiology and diagnosis of type 1 and type 2. Difference between type 1 and type 2 diabetes  Implications for practice  Management goals TYPE 1  Treatment and management options  Carbohydrate awareness  Challenges in self-management  Hypoglycaemia and hyperglycaemia  Screening and the annual review TYPE 2  First line treatment and step-wise options  Food choices and relation to risk  Activity and type 2 diabetes  Cardiovascular disease and type 2 diabetes  Screening and annual review  SUPPORTING PEOPLE WITH DIABETES AND THEIR FAMILY  Seeing the person not the disease  Consultation skills  Ongoing support needs .  Food and lifestyle messages for diabetes  Annual review and screening including foot care advice  Blood glucose monitoring  Consultation skills and relationship building  Complications and treatment options  WHO SHOULD ATTEND?  Nurses HCAs

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Learning how to have a better relationship Introspection test Learn where you are going wrong Love language testing Learn about boundaries Establishing your relationship needs Address past negative relationship patterns Learn about boundaries Relationship facets relationship course 2-hour session relationship training and 1 phone call 30 mins Coaching and relationship skills education https://relationshipsmdd.com/product/relationship-course-express-package/