Want to teach Hypnobirthing? My JOY hypnobirthing course will equip you with the skills to empower expectant mothers on their childbirth journey. Gain insights into how hypnotherapy fosters a calm mindset, alleviates discomfort, and prepares women for childbirth.
Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data
P900 - Maintenance and testing of control measures for domestic hot and cold water systems is there to provide the basis of competence of operatives undertaking the operation and monitoring of domestic hot and cold water systems in buildings. The objective is to enable the candidates to identify the risks posed by legionella bacteria and understand how to manage the risks in domestic water systems, to a standard which minimises the risk of exposure and ill health.
About this event This course is designed to prepare healthcare professionals working in primary and secondary care to provide appropriate and effective treatment and support for people with Asthma and COPD, which enables them to manage their condition and prevent progression across all stages of the disease. The content reflects the priorities for care identified in the NICE guidelines for the management of COPD in adults. Includes All course materials and certificate of attendance AB Health Group awards CPD points/certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00. Please note: this course is for health care professionals and nurses only. Annie Barr AB Health Group Organiser Description Annie Barr is a leading provider of high-quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high-quality care.
P900 - Maintenance and testing of control measures for domestic hot and cold water systems is there to provide the basis of competence of operatives undertaking the operation and monitoring of domestic hot and cold water systems in buildings. The objective is to enable the candidates to identify the risks posed by legionella bacteria and understand how to manage the risks in domestic water systems, to a standard which minimises the risk of exposure and ill health.
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
MJ Electrical Training offers a one-day online course for a Health & Safety Exemption, which can be used when applying for an ECS Labourers card. ECS (Electrotechnical Certification Scheme) is a card scheme for electrotechnical operatives in the UK. The ECS Labourer card is designed for those working in a supporting role within the electrotechnical industry.
MJ Electrical Training offers a one-day online course for a Health & Safety Exemption, which can be used when applying for an ECS Labourers card. ECS (Electrotechnical Certification Scheme) is a card scheme for electrotechnical operatives in the UK. The ECS Labourer card is designed for those working in a supporting role within the electrotechnical industry.
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
Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.