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.
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.
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
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
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
A personalised resilience profile and 60 minute coaching and exploration session for those who want to develop their capacity to adapt positively in an ever changing world.
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/
Aftereffects face to face training customised and bespoke.
This comprehensive online interior design course includes 12 self study modules, and weekly 1:1 telephone and or video consultations. I will personally guide and inspire you through your creative learning journey.
Our OISC Level 3 accreditation training course is designed as a two-day, extensive course. We offer participants a detailed look into immigration advice, following on from Level 2 OISC training. In this course we aim to cover the syllabus at Level 3 of OISC standards. Course Overview: Our OISC Level 3 Training Course, a comprehensive two-day program designed to provide an extensive understanding of immigration advice at an advanced level. Building upon the knowledge acquired in Level 2 training, this course delves deeper into the intricacies of UK and EU immigration and asylum law, equipping participants with expert knowledge and skills. Our aim in this course is to cover the Level 3 syllabus as per the standards set by the Office of the Immigration Services Commissioner (OISC). By attending our training, you will gain a comprehensive understanding of the advanced structures and frameworks of UK immigration law. We will explore the complexities of asylum and human protection law, as well as the European Economic Area (EEA) Regulations 2006. Looking to fast track your OISC Level 3 training? Join our 1 day fast track training course Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 3 Syllabus? The OISC Level 3 Training introduces new learning objectives for immigration adviser applicants. The course includes: Advanced structures and frameworks of UK immigration law Asylum and Human Protection law European Economic Area (EEA) Regulations 2006 Appeals and High Court proceedings Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. Who can attend the OISC Training Level 3 classes? The OISC Training Level 3 seminars cover complicated immigration frameworks and processes. Although no previous qualification is needed to attend these courses, participants should have completed Level 1 and Level 2 assessments before progressing with this last step. The OISC Level 3 Training course is aimed at those who wish to obtain in-depth knowledge on UK and EU immigration law.