Name: Essentials Of Sepsis Recognition & Escalation For Care & Support Staff
Price: 350 GBP
Availability: InStock

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Course Overview:</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">The "Management of Ear Wax Training" course is designed to provide healthcare professionals with the knowledge and skills necessary to effectively assess, manage, and provide safe and appropriate treatment for individuals with ear wax buildup (cerumen impaction). This course is relevant for nurses, audiologists, medical practitioners, and other healthcare providers who encounter patients with ear wax-related issues.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Duration:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">2 days (12 hours) for new learners.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">1 day (6 Hours) for experienced learners.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><span id="isPasted" fr-original-style="" style="box-sizing: border-box;">By the end of the course, participants will be able to:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1. <span id="isPasted" fr-original-style="" style="box-sizing: border-box;">Learn about the causes, symptoms, and risk factors associated with ear wax impaction.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2. <span id="isPasted" fr-original-style="" style="box-sizing: border-box;">Learn various techniques for ear wax removal, including irrigation, manual removal, and instrumentation.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">3. <span id="isPasted" fr-original-style="" style="box-sizing: border-box;">&nbsp;<span id="isPasted" fr-original-style="" style="box-sizing: border-box;">Recognise potential complications and adverse events that may arise during or after ear wax removal.</span></span></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">1. Anatomy and Physiology of the Ear:<br fr-original-style="" style="box-sizing: border-box;">Understand the structure and functions of the ear, including the ear canal and the role of ear wax.<br fr-original-style="" style="box-sizing: border-box;">Recognise normal variations in ear wax composition.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">2. Ear Wax Impaction:<br fr-original-style="" style="box-sizing: border-box;">Learn about the causes, symptoms, and risk factors associated with ear wax impaction.<br fr-original-style="" style="box-sizing: border-box;">Understand the potential complications of untreated ear wax buildup.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">3. Assessment and Diagnosis:<br fr-original-style="" style="box-sizing: border-box;">Develop skills in assessing individuals for ear wax impaction using otoscopy and patient history.<br fr-original-style="" style="box-sizing: border-box;">Understand the importance of differentiating ear wax impaction from other ear-related conditions.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">4. Ear Wax Removal Techniques:<br fr-original-style="" style="box-sizing: border-box;">Learn various techniques for ear wax removal, including irrigation, manual removal, and instrumentation.<br fr-original-style="" style="box-sizing: border-box;">Understand the indications, contraindications, and limitations of each technique.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">5. Patient Preparation and Communication:<br fr-original-style="" style="box-sizing: border-box;">Understand how to prepare patients for ear wax removal procedures.<br fr-original-style="" style="box-sizing: border-box;">Develop effective communication skills to explain the procedure, set expectations, and address concerns.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">6. Infection Control and Safety:<br fr-original-style="" style="box-sizing: border-box;">Learn about infection control measures and techniques to ensure the safety of patients during ear wax removal procedures.<br fr-original-style="" style="box-sizing: border-box;">Understand the importance of maintaining aseptic conditions.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">7. Practice Sessions:<br fr-original-style="" style="box-sizing: border-box;">Engage in hands-on practice sessions to demonstrate ear wax removal techniques using simulation models or task trainers.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">8. Complications and Aftercare:<br fr-original-style="" style="box-sizing: border-box;">Recognise potential complications and adverse events that may arise during or after ear wax removal.<br fr-original-style="" style="box-sizing: border-box;">Learn about appropriate aftercare instructions and patient education.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">9. Legal and Ethical Considerations:<br fr-original-style="" style="box-sizing: border-box;">Understand the legal and ethical aspects of ear wax removal procedures, including consent and documentation.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><b id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course materials and resources for reference:</b><br fr-original-style="" style="box-sizing: border-box;">Upon successful completion of the course, participants will receive a certificate of attendance, validating their training in the management of ear wax and their ability to perform safe and effective ear wax removal using&nbsp;water irrigation and&nbsp;microsuction techniques.<br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Participants&#39; understanding of ear wax management principles and their ability to perform safe and effective ear wax removal procedures will be assessed through practical demonstrations, simulated scenarios, and discussions.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span id="isPasted" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking. <strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please note the price quoted is based on a one-day duration and will therefore increase as your needs increase. &nbsp;</strong></strong></span></p>

Guardian Angels Training

Gain the knowledge and skills to manage ear wax buildup with our "Management of Ear Wax Training" course. Ideal for healthcare professionals.

Management of Ear Wax Training

General Admission

London

<blockquote style="color: rgb(74, 74, 74); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ADVANCED</strong></p></blockquote><p style="color: rgb(74, 74, 74); text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(74, 74, 74); text-align: center;"><img src="https://harleyeliteacademy.com/wp-content/uploads/2023/09/certified.png" alt="" width="179" height="110" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></p><p style="color: rgb(74, 74, 74); text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(74, 74, 74); text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 CPD POINTS</strong></p><p style="color: rgb(74, 74, 74); text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(74, 74, 74); text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 DAY INTENSIVE COURSE&nbsp;</strong></p><p style="color: rgb(74, 74, 74); text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(74, 74, 74); text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ONLINE or IN-CLINIC</strong></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style="color: rgb(74, 74, 74);">NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available!</span></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-id="259c3fe1" data-element_type="widget" data-widget_type="text-editor.default" style="color: var( --e-global-color-text ); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var( --e-global-color-text );"><section data-responsive="true" data-is-screen-width="true" data-col-margin="0" data-row-margin="0" fr-original-style="" style="box-sizing: border-box;"><div data-content-width="980" data-is-mesh="true" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-internal="true" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-internal="true" fr-original-style="" style="box-sizing: border-box;"><div data-packed="false" data-min-height="63" fr-original-style="" style="box-sizing: border-box;"><div data-id="7caaf0b" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(74, 74, 74); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><div data-id="1813dafa" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: var( --e-global-color-primary ); box-sizing: border-box;" fr-original-style=" color: var( --e-global-color-primary );">This course theory will help you to understand:</h2></div><div data-id="3dc0fa7" data-element_type="widget" data-widget_type="text-editor.default" style="color: var( --e-global-color-text ); box-sizing: border-box;" fr-original-style=" color: var( --e-global-color-text );"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will cover all you need to know in order for you to treat your patients confidently and safely.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Dermapen&reg; offers certified microneedling training &amp; certification as part of its education program. The curriculum &nbsp;is available for purchase by all skin care practitioners. The microneedling training will take a look into the history and science of microneedling.</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">4 hour microneedling training core course</li><li fr-original-style="" style="box-sizing: border-box;">The history, improvements and leaders in skin micro-needling</li><li fr-original-style="" style="box-sizing: border-box;">Product usage protocols</li><li fr-original-style="" style="box-sizing: border-box;">Treatment guidelines</li><li fr-original-style="" style="box-sizing: border-box;">Indications and contraindications</li><li fr-original-style="" style="box-sizing: border-box;">Before and after patient care</li><li fr-original-style="" style="box-sizing: border-box;">Comparative and adjunctive skin therapies</li><li fr-original-style="" style="box-sizing: border-box;">Treatment and technical demonstration Certification testing</li></ul></div><div data-id="7caaf0b" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: var( --e-global-color-primary ); box-sizing: border-box;" fr-original-style=" color: var( --e-global-color-primary );">Practice will enable you to learn in 1-day ONE-TO-ONE Training</h2></div><div data-id="259c3fe1" data-element_type="widget" data-widget_type="text-editor.default" style="color: var( --e-global-color-text ); box-sizing: border-box;" fr-original-style=" color: var( --e-global-color-text );"><section data-responsive="true" data-is-screen-width="true" data-col-margin="0" data-row-margin="0" fr-original-style="" style="box-sizing: border-box;"><div data-content-width="980" data-is-mesh="true" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-internal="true" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-internal="true" fr-original-style="" style="box-sizing: border-box;"></div></div></div></section><div data-packed="false" data-min-height="271" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will also have the opportunity to view a micro needling treatment demonstration at the conclusion of the training.&nbsp;After each lesson, there will be a short quiz. Upon successful completion of the course, you will receive a certificate and title of Dermapen&reg; Certified Practitioner.</p></div></div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">You need to be medically qualified as a&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">doctor, dentist, nurse, pharmacist or paramedic</strong>&nbsp;with full governing body registration and&nbsp;<a href="http://harleyeliteacademy.com/product/dermal-filler-training-course-london/" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">have completed a Foundation Filler Course</a>&nbsp;and to have administered a number of cases.</li></ul><h2 style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Additional information</h2><table style="margin-right: calc(0%); width: 100%; border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;" fr-original-style="margin-right: calc(0%); width: 100%;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><th style="color: rgb(0, 0, 0); box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); background: rgb(236, 236, 236);" fr-original-style=" color: rgb(0, 0, 0);"><div style="text-align: center; box-sizing: border-box;" fr-original-style="text-align: center;">ATTENDANCE</div></th><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;">ONLINE (Theory), IN CLINIC (Practice)</p></td></tr><tr fr-original-style="" style="box-sizing: border-box;"><th style="color: rgb(0, 0, 0); box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); background: rgb(236, 236, 236);" fr-original-style=" color: rgb(0, 0, 0);"><div style="text-align: center; box-sizing: border-box;" fr-original-style="text-align: center;">COURSE LEVEL</div></th><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;">INTERMEDIATE | Advanced Course</p></td></tr></tbody></table></div><section style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style=" color: rgb(74, 74, 74);"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></div></div></div></section></div><div data-id="7caaf0b" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style=" color: rgb(74, 74, 74);"><section style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style=" color: rgb(74, 74, 74);"><br fr-original-style="" style="box-sizing: border-box;"></section></div>

Harley Elite Academy (HeLa)

Aesthetic Practitioner

MICRONEEDLING COURSE | Dermapen

Theory (Online)

Practice (In Clinic

Nuneaton

PFTP Ltd

IMI MOT

MOT Tester

MOT Testing – Classes 4 and 7 (IMI Level 2)

General admission

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Identify the components of the Microsoft Project environment</li><li>Create a new project plan</li><li>Create the project schedule</li><li>Use different views to analyse the project plan</li><li>Create, allocate and manage resources in a project plan</li><li>Finalise a project plan</li><li>Track progress</li><li>View and report project plan information</li></ul><p>' 1 year email support service</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li>Alexandra - CIAL</li></ul><p>'</p><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Microsoft Project</strong></p><ul><li>Recap on project management concepts</li><li>Project environment overview</li><li>The 3 databases: Tasks, Resources and Assignments</li><li>Different ways of displaying the Project Plan</li><li>Access Help</li></ul><p><strong>Creating a Project Plan</strong></p><ul><li>Create a New Project Plan</li><li>Project Information</li><li>Create and apply the project calendar</li><li>Defining recurring exceptions to the calendar</li><li>Defining the calendar's work weeks</li><li>Create the Summary tasks</li><li>Create the Work Breakdown Structure</li></ul><p><strong>Task creation and scheduling</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Task editing and the Task Information window</li><li>Task Durations</li><li>Defining Milestones</li><li>Manual Scheduling vs Automatic Scheduling</li><li>Changing the Task's Calendar</li><li>Create a split in a Task</li><li>Create Task Relationships</li><li>Adding Lag or Lead to a Relationship</li><li>Identifying the Critical Path</li><li>Adding Constraints and Deadlines to Tasks</li><li>Create Recurring Activities</li><li>Adding Notes and links to Tasks</li></ul><p><strong>Managing Resources</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Resource editing and the Resource Information window</li><li>Resource Types</li><li>Fixed Costs vs Variable Costs</li><li>Adding Resource Costs</li><li>Defining when costs accrue</li><li>Changing the Resource Calendar and Availability</li><li>Project calendar vs Resource and Task Calendar</li><li>Assigning Resources to Tasks</li><li>Effort Driven Scheduling</li><li>Resolving Resource Overallocation</li></ul><p><strong>Tracking the Project Progress</strong></p><ul><li>Setting a Project Baseline</li><li>Entering Actuals</li><li>Different ways of viewing the Progress</li><li>Checking if the Project is on track</li></ul><p><strong>Viewing and Reporting Project Detail</strong></p><ul><li>Adding Tasks to the Timeline and sharing it</li><li>Modifying the Timescale and Zoom level</li><li>Formatting the Gantt View</li><li>Filtering and Grouping Tasks</li><li>Print and Troubleshoot the Gantt View</li><li>Using built-in Reports in Microsoft Project</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Project Introduction - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Macros & VBA - In-company

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Customise tables and charts</li><li>Customise formatting with styles and themes</li><li>Modify pictures in a document</li><li>Create customised graphic elements</li><li>Insert content using Quick Parts</li><li>Control text flow</li><li>Use templates to automate document creation</li><li>Perform mail merges</li><li>Use macros to automate common tasks</li></ul> <p>'1 year email support service</p> <p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Excelent enviroment for training. Tahnk you.</strong></p> </li><li>Jenny Price - ACER</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Working with Tables and Charts</p> <ul> <li>Sort Table Data</li><li>Control Cell Layout</li><li>Perform Calculations in a Table</li><li>Create a Chart</li></ul> <p>Customising Formats Using Styles and Themes</p> <ul> <li>Create and Modify Text Styles</li><li>Create Custom List or Table Styles</li><li>Apply Document Themes</li></ul> <p>Using Images in a Document</p> <ul> <li>Resize an Image</li><li>Adjust Image Appearance</li><li>Integrate Pictures and Text</li><li>Insert and Format Screenshots</li><li>Use the Snipping tool</li></ul> <p>Creating Custom Graphic Elements</p> <ul> <li>Create Text Boxes and Pull Quotes</li><li>Draw Shapes</li><li>Add WordArt and Other Text Effects</li><li>Create Complex Illustrations with SmartArt</li></ul> <p>Inserting Content Using Quick Parts</p> <ul> <li>Insert Building Blocks</li><li>Create and Modify Building Blocks</li><li>Insert Fields Using Quick Parts</li></ul> <p>Controlling Text Flow</p> <ul> <li>Control Paragraph Flow</li><li>Insert Section Breaks</li><li>Insert Columns</li><li>Link Text Boxes to Control Text Flow</li></ul> <p>Using Templates</p> <ul> <li>Create a Document Using a Template</li><li>Create a Template</li></ul> <p>Using Mail Merge</p> <ul> <li>The Mail Merge Features</li><li>Merge Envelopes and Labels</li><li>Create a Data Source Using Word</li></ul> <p>Using Macros</p> <ul> <li>Automate Tasks Using Macros</li><li>Create a Macro</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Word Introduction course.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p>80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Word Intermediate - In-company (now with live online classes)

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Introduction - In-company

Gloucester

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 day practical course (taken in professional beauty salon) designed to show You how to carry out manicures. This course is designed for complete beginners, who wish to learn from basic to professional most popular nail art techniques to start Your career as nail technicians. It is also good to refresh knowledge and learn new techniques for those of You that are already in business.</p><h1 fr-original-style="" style="box-sizing: border-box;">This nail technician Level 3course includes:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Organizing your work place</li><li fr-original-style="" style="box-sizing: border-box;">Health and safety at the work place</li><li fr-original-style="" style="box-sizing: border-box;">Customer service</li><li fr-original-style="" style="box-sizing: border-box;">Nail anatomy</li><li fr-original-style="" style="box-sizing: border-box;">Skin anatomy and skin care</li><li fr-original-style="" style="box-sizing: border-box;">Nail health</li><li fr-original-style="" style="box-sizing: border-box;">Tools for nails&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Product description used for nail&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension methods using gel and acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Manicure</li><li fr-original-style="" style="box-sizing: border-box;">Electric manicure</li><li fr-original-style="" style="box-sizing: border-box;">Hybrid manicure</li><li fr-original-style="" style="box-sizing: border-box;">Palm massage</li><li fr-original-style="" style="box-sizing: border-box;">Nail and palm care treatment</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using gel</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using gel &ndash; French</li><li fr-original-style="" style="box-sizing: border-box;">Infill&nbsp;gel tips</li><li fr-original-style="" style="box-sizing: border-box;">Nail decoration setting</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using acrylic templates/forms</li><li fr-original-style="" style="box-sizing: border-box;">Acrylic tips &ndash; French</li><li fr-original-style="" style="box-sizing: border-box;">Infill&nbsp;acrylic nails</li><li fr-original-style="" style="box-sizing: border-box;">Nail decoration setting in acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Gel nail and acrylic nail removal techniques</li><li fr-original-style="" style="box-sizing: border-box;">Natural nail hardening techniques</li></ul>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<h1 fr-original-style="" style="box-sizing: border-box;">Earn your certificate!</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<div data-packed="true" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">After completion of this nail technician course, you will receive a Penelope Academy ABT accredited certificate.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Graduates from this nail training course can begin working as professional nail technicians using their Penelope Academy certificate. Students can develop their skills further by progressing onto our other nail courses.</strong></p></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<div data-appear-animation="fadeInUp" data-appear-animation-delay="300" fr-original-style="" style="box-sizing: border-box;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="https://penelope-academy.co.uk/product/nail-technician-course/#cart" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"></a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</div><div data-vc-full-width="true" data-vc-full-width-init="true" data-vc-parallax="2" data-vc-parallax-image="https://penelope-academy.co.uk/wp-content/uploads/2019/04/penelope-ltd-bg-03..jpg" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><header fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Practical Training!</h2></header><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">90% of the course consists of practical training, as we believe that practice makes perfect!</strong></h2><h1 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h1><h1 fr-original-style="" style="box-sizing: border-box;">Information:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will provide you with all the necessary products and tools for nail training.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Students will receive a manual to keep.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note: all students will be working on models. You will need to bring a model along with you to the training.&nbsp;</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you cannot find anyone to work with, you will need to let us know 1 week before the course so that we can arrange a model.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We provide a friendly, intimate atmosphere for all students to enjoy.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<h1 fr-original-style="" style="box-sizing: border-box;">Requirements:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The minimum age for entry to this course is 18 years.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There are no additional requirements to enter this course</p></section></div>

Penelope Academy

Manicure

Beauty Specialist

Gel Extension

Nail Extension

Acrylic Nail

Nail Technician

Gel Nail Technician

Gel Nail Extension

Beauty Therapy

The ABT Level 3  Diploma in Nail Services is a substantial vocational qualification that will confirm your competence as a nail technician.

Nail Technician Level 3

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Intermediate - In-company

Bury St Edmunds

Thetford

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Sepsis presents a considerable health challenge globally, affecting millions every year, including <a href="https://sepsistrust.org/about/" target="_blank" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">245,000&nbsp;people in the UK alone.</a></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This severe condition stems from an infection that ignites an overwhelming immune response in our bodies. If not addressed quickly, sepsis can cause organ failure and can be fatal.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The elusive nature of sepsis underscores the importance of <a href="https://nrmedical.training/blog/top-5-facts-about-arthritis-on-world-arthritis-day" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">early diagnosis</a> and immediate treatment. Swift and decisive action is key in ensuring people receive the right care without delay.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">To better equip care organisations and their amazing, hardworking staff in this fight, we offer <a href="https://nrmedical.training/blog/the-importance-of-sepsis-training" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">the Essentials</a> of Sepsis Recognition &amp; Escalation For Care &amp; Support Staff course. This face to <a href="https://nrmedical.training/book-a-course/p/level-2-award-in-fire-safety" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">face training course</a> delivered by experienced healthcare professionals arms care and support staff with the necessary knowledge, skills and confidence to identify individuals at risk of sepsis, recognise its early signs, and escalate care effectively when they suspect sepsis. With our CQC compliant course, you&#39;ll be better prepared to help those at risk.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);">Learners will receive an NR Medical Training/UK Sepsis Trust certificate which is valid for 1 year and a summary of elements covered throughout the course. Perhaps most importantly you&rsquo;ll feel ready to identify the signs and symptoms of Sepsis and have the confidence to escalate care should the need arise.</span></p><h3 style="color: var(--headingMediumColor); box-sizing: border-box;" fr-original-style=" color: var(--headingMediumColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);">Sepsis Champions!</span></h3><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We urge all organisations to become sepsis savvy, a key part of which involves nominating &#39;sepsis champions&#39; within your team. Following the completion of our course, you&#39;ll be in a position to designate a team member as a sepsis champion - someone who has either positively used their newfound skills in the workplace or has been instrumental in helping others do the same.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">If you wish to nominate a Sepsis Champion, we can assist by sharing their details with the UK Sepsis Trust. This way, their efforts can be acknowledged and celebrated, serving as an inspiration to others in our shared mission to tackle sepsis.</p>

NR Medical Training

To better equip care organisations and their amazing, hardworking staff in this fight, we offer the Essentials of Sepsis Recognition & Escalation For Care & Support Staff course. This face to face training course delivered by experienced healthcare professionals arms care and support staff with the necessary knowledge, skills and confidence to identify individuals at risk of sepsis, recognise its early signs, and escalate care effectively when they suspect sepsis. With our CQC compliant course, you'll be better prepared to help those at risk. Learners will receive an NR Medical Training/UK Sepsis Trust certificate which is valid for 1 year and a summary of elements covered throughout the course.

Essentials Of Sepsis Recognition & Escalation For Care & Support Staff

Edinburgh

Leicester

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">P600 provides delegates with the necessary skills and knowledge to improve their understanding of Performance Measurements in LEV.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">For many this will act as a starting point in their progression towards a career in LEV. &nbsp;P600 can be taken by newcomers to the field of LEV or by less experienced LEV personnel as part of their progression towards a Level 4 qualification, eg&nbsp;<a href="https://www.oxyl8.com/product/p601-thorough-examination-and-testing-of-local-exhaust-ventilation-lev-systems/" target="_blank" rel="noopener" style="color: rgb(10, 78, 112); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(10, 78, 112);">P601</a>&nbsp;&ndash;&nbsp;<a href="https://www.oxyl8.com/product/p604-performance-evaluation-and-management-of-local-exhaust-ventilation-systems/" target="_blank" rel="noopener" style="color: rgb(10, 78, 112); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(10, 78, 112);">P604</a>&nbsp;series). P600 is a Level 3 course.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">It does not confer &lsquo;competency&rsquo; on the delegate to allow them to undertake stutory examinations and tests under CoSHH Reg 9.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">In general terms &ndash; by attending this P600 delegates will gain knowledge and understanding of the:-</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Basic components of local exhaust ventilation systems.</li><li fr-original-style="" style="box-sizing: border-box;">Methodologies for undertaking the performance testing of LEV equipment</li><li fr-original-style="" style="box-sizing: border-box;">Qualitative visualisation techniques (smoke release/&rsquo;dust lamp&rsquo; etc).</li><li fr-original-style="" style="box-sizing: border-box;">Quantitative measurement techniques (anemometers, Pitot tubes etc).</li></ul>

OXYL8 Ltd

Energy Performance Certificate

Professional Skills Course (PSC)

Local Exhaust Ventilation (LEV)

FA Level 1

P600 is an introductory one-day LEV course

P600 LEV Methods for Testing Performance

P600 LEV 1 Day Course

Bristol

Exeter

Newcastle

Manchester

Liverpool

Birmingham

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live instructor led sessions;&nbsp;</strong></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Why choosing Mindmaps Wellbeing is a good choice for your training.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Instructor led training sessions over two days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Course Manual</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Handy Cue Card</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ MHFAider Certificate upon completion</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Your instructors are <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registered Mental Health Nurses and Healthcare Educators</strong> (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to our online MHFAider peer support groups moderated by the instructor team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">For a little extra:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Organisational MINDWELL Companion tailored for your workplace / organisation.</p>

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

<p style="color: rgb(62, 62, 62); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(62, 62, 62);">Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education&rsquo;s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_self" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;"><span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">here</strong></span></a>).</p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(36, 35, 35);">The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been <span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">fully funded by the DfE for eligible schools</strong></span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">and colleges</strong></span>. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.</p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 35, 35);">Working with an&nbsp;<span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">expert trainer and a highly experienced Senior Mental Health Lead</strong></span>, who has&nbsp;<span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">trained Senior Mental Health Leads in over 1000 schools and colleges nationwide</strong></span>, you will be introduced to the DfE&rsquo;s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.</p><ul style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(62, 62, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs&nbsp;<span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound;520+VAT per delegate.</strong>&nbsp;</span>(For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a&nbsp;<span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">subsidised rate for additional delegates of &pound;390+VAT</strong></span>&nbsp;- please just email us if this is an offer you would like to take up.)</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(62, 62, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(62, 62, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">An overview of the course structure can be found&nbsp;<a href="https://www.brightcoreconsultancy.com/_files/ugd/5bc70a_c7b3efd99188442fa7d20449bb8fd0ec.pdf" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;"><span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">here.</strong></span></a></p></li></ul><p style="color: rgb(62, 62, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><span style="color: rgb(36, 35, 35); box-sizing: border-box;" fr-original-style=" color: rgb(36, 35, 35);">Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE&rsquo;s</span><span style="color: rgb(36, 173, 120); box-sizing: border-box;" fr-original-style=" color: rgb(36, 173, 120);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><a href="https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995681/Learning_outcomes_for_senior_mental_health_leads_in_schools_and_colleges.pdf" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes for Senior Mental Health Leads</strong></a></span><span style="color: rgb(36, 35, 35); box-sizing: border-box;" fr-original-style=" color: rgb(36, 35, 35);">&nbsp;by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.</span></p><p style="text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;" fr-original-class="wysiwyg_bold_link_cls">View all testimonials </a></p><p style="text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials here).
The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.
Working with an expert trainer and a highly experienced Senior Mental Health Lead, who has trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE’s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.
Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs £520+VAT per delegate. (For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a subsidised rate for additional delegates of £390+VAT - please just email us if this is an offer you would like to take up.)
Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.
An overview of the course structure can be found here.
Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE’s Learning Outcomes for Senior Mental Health Leads by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.
View all testimonials



Brightcore Consultancy

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process.

Designated Senior Mental Health Lead Course (Three full days plus 1-2-1 session)

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those who would like to start a business as a Colour Consultant. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed for trainees worldwide and is delivered over five colour modules plus one marketing module, each lasting four hours. Including homework, the complete course will take up approximately 30 hours of your time.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There are no prerequisites for signing up for this course, we will take you through all the theory and practical sessions, building your knowledge and confidence in the subjects.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our virtual approach to training means that you really do have the best seat in the house!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the sessions are conducted &lsquo;live&rsquo; and online by your Colour Me Beautiful trainer. Classes are kept deliberately small to enhance your learning; maximum number 4.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Immediately after your virtual training you will have the flexibility to run your own&nbsp;Colour Me Beautiful&nbsp;business as a colour consultant, meaning you can start to earn money straight away.</p><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">TOPICS</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The History of Colour Me Beautiful</li><li fr-original-style="" style="box-sizing: border-box;">The Colour Me Beautiful System</li><li fr-original-style="" style="box-sizing: border-box;">Dominant Colour Types</li><li fr-original-style="" style="box-sizing: border-box;">Understanding colour terms</li><li fr-original-style="" style="box-sizing: border-box;">Draping techniques for women &amp; men</li><li fr-original-style="" style="box-sizing: border-box;">Practise on volunteers</li><li fr-original-style="" style="box-sizing: border-box;">Cosmetic colour selection and application</li><li fr-original-style="" style="box-sizing: border-box;">Conducting a consultation</li><li fr-original-style="" style="box-sizing: border-box;">Setting up and marketing your business</li><li fr-original-style="" style="box-sizing: border-box;">How to conduct group presentations</li></ul><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">As well as training in colour, we also include business and marketing, sales and presentation skills, along with ongoing training to enhance your skills.</span></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">By the end of this course you will</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Be confident in assessing the dominant colouring using the Colour Me Beautiful system</li><li fr-original-style="" style="box-sizing: border-box;">Be able to conduct a colour analysis using the dominant colours</li><li fr-original-style="" style="box-sizing: border-box;">Be confident in applying a simple make-up routine to your client</li><li fr-original-style="" style="box-sizing: border-box;">Have the required knowledge to market your business</li><li fr-original-style="" style="box-sizing: border-box;">Understand the Colour Me Beautiful back office procedures</li></ul><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will receive</strong></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">20 hours of live online colour tuition with your tutor</li><li fr-original-style="" style="box-sizing: border-box;">4 hours live online business &amp; marketing training</li><li fr-original-style="" style="box-sizing: border-box;">Starter Kit</li><li fr-original-style="" style="box-sizing: border-box;">Comprehensive training manual</li><li fr-original-style="" style="box-sizing: border-box;">Certificate upon completion</li><li fr-original-style="" style="box-sizing: border-box;">Trade account</li><li fr-original-style="" style="box-sizing: border-box;">Access to the consultant support forum</li><li fr-original-style="" style="box-sizing: border-box;">Access to consultant lounge</li><li fr-original-style="" style="box-sizing: border-box;">International directory listing</li><li fr-original-style="" style="box-sizing: border-box;">12 months Colour Me Beautiful licence upon course completion</li></ul></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Colour Me Beautiful

Color Theory

Cosmetics

Beauty & Makeup

Learn the foundation to colour analysis with this 5 day live and online, interactive course

Intermediate Colour Analysis

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This official BRCGS one-day course will provide you with a thorough understanding of vulnerability assessment for food fraud and enable you to use techniques to better identify and mitigate risks associated to raw materials in the supply chain. This is particularly useful when implementing product safety management systems and the requirements of the BRCGS Global Standards on site.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course is part of the<a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">&nbsp;BRCGS Professional recognition programme</a>.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(213, 120, 4); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(213, 120, 4);">Note: An optional 2 hours module about </span><span style="color: rgb(213, 120, 4); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(213, 120, 4);"><a href="https://ask-sonia-limited.cademy.co.uk/accredited-threat-management-taccp-2-3-hours" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Threat Management (TACCP)</strong></a></span><span style="color: rgb(213, 120, 4); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(213, 120, 4);"> is available as a bolt-on to this course. </span></p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course, you will:</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Understand vulnerability assessment requirements for BRCGS</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Understand what is meant by the term &#39;food fraud&#39;</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Be able to identify the difference between vulnerability assessment, threat analysis critical control point and food defence</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Be able to assess the raw materials most vulnerable to food fraud</p></li></ul>

Ask Sonia Limited

Food Safety

HACCP

Official BRCGS Product Safety Management course: Vulnerability Assessment for Food Fraud. 
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Vulnerability Assessment for Food Fraud (1 Day)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accredited seminar provides an introduction for employers, HR managers and supervisors to learn how domestic abuse can impact in the workplace.</p><div style="color: rgb(119, 119, 119); box-sizing: border-box;" fr-original-style=" color: rgb(119, 119, 119);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you know&hellip;. Domestic Abuse costs UK businesses &pound;14 billion per year. (Home Office &ndash; July 2021)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact in the business as well as the next steps to support your staff and protect your business.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By attending this event you will gain an</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of domestic abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of the legal and safety implications for employers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Next steps on how your workplace can become accredited as a &lsquo;Safe Space to Work&rsquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This on-line training workshop will introduce the social, health and legal context, employers&rsquo; responsibilities and awareness of the economic impact of domestic abuse. By the end of the session attendees will feel confident in taking the next steps to ensure their workplace is a Safe Space.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training workshop will provide the first step towards understanding a many layered and complex subject.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">CPD credits are awarded with this workshop.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Attendees will receive handouts and a certificate (if required).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This event is hosted by Julie Johns MBE. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The workshop will be delivered as a 1 hour live Zoom event and is being offered at &pound;30 per person. </p></div>

Safe Space Consultancy

Safeguarding

Domestic Violence

This 1 hour on-line training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact on an employee and the business as well as the next steps to support your staff and protect your business.

An Introduction to Workplace Domestic Abuse Training (CPD Accredited)

Early Bird

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This CPD accredited Threat Management TACCP course is typically completed as a bolt-on to the BRCGS Vulnerability Assessment for Food Fraud (VAFF) course, though it can be attended as a stand alone course. It looks at the various methodologies for risk assessing and managing threats which could be malicious or fraudulent in nature.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">While the BRCGS VAFF course specifically covers fraud, TACCP is not included and so this course is complimentary and gives attendees of both courses a comprehensive qualification.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Attendees will receive an STC certificate of achievement for TACCP on successful completion of the course assignment (which is typically combined with the BRCGS VAFF assignment if attended as a bolt-on course, but can also be completed alone).</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">A number of tools, tips and templates are provided so that attendees can confidently produce meaningful risk assessments and implement sensible and effective control measures.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">By the end of this course you will:</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Understand TACCP &ndash; threat assessment and threat management</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Know and be able to apply the risk assessment methodologies</p></li></ul>

CPD accredited Threat Management TACCP course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited Threat Management TACCP (2-3 hours)

Southend on Sea

Rotherham

Slough

Portsmouth

Bingley

Nottingham

Paisley

Luton

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

<p style="color: rgb(28, 28, 28); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);">This course, worth 30 hours of verifiable CPD, will demonstrate your ability to grade and reflect upon your impression technique and demonstrate competence to take impressions unsupervised under prescription.</p><p style="color: rgb(28, 28, 28); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><img src="https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember.png" alt="CPD member" width="162" height="149" srcset="https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember.png 397w, https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember-300x276.png 300w, https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember-320x294.png 320w" sizes="(max-width: 162px) 100vw, 162px" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn about the Cavity Training Impression Taking Course</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is suited to nurses who aspire to treat patients directly and to take impressions or scan for impressions under the prescription of a registered dentist or clinical dental technician.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To enrol, you must be GDC-registered, work in surgery and hold indemnity insurance. (extended duties) You will need a GDC registered dental professional able and willing to supervise you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You also need to complete an Anaphylaxis Awareness course &ndash; we offer a free CPD course for this.</p><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Frequently Asked Questions</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How long is the course?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course duration is 2 to 6 months.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">When are the classes held?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will attend a live webinar class for two Saturday mornings.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Is there an exam at the end?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There is no exam at the end, you need to successfully complete 24 assessments with your practice mentor and a complete a 500 word dissertation.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What qualifications do I need to start the course?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Preferable English and Maths level 4 and above, you must also be GDC registered.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What opportunities for progression is there?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This qualification allows candidates to further progress onto various post registration qualifications or career opportunities, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The Certificates in Orthodontic Nursing</li><li fr-original-style="" style="box-sizing: border-box;">Extending a career in prosthetics.</li><li fr-original-style="" style="box-sizing: border-box;">Training as a Lab Technician</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><article style="color: rgb(28, 28, 28); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);"><article style="color: rgb(28, 28, 28); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Course Dates</h3><ul style="color: var(--color-body-text); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">13th - 27th April 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">11th - 25th May 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8th - 22nd June 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">13th - 27th July 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3rd - 17th August 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7th - 21st September 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li></ul></article><article style="color: rgb(28, 28, 28); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Costs</h3><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound;180.00 per person (inc. VAT)</strong></p><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);">Please choose from one of the course dates above. Each course is 2 days. The dates above indicate the 2 days of the course.</p></article></article><article style="color: rgb(28, 28, 28); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><br fr-original-style="" style="box-sizing: border-box;"></article>

252 Courses in Coventry

Management of Ear Wax Training

By Guardian Angels Training

MICRONEEDLING COURSE | Dermapen

By Harley Elite Academy (HeLa)

MOT Testing – Classes 4 and 7 (IMI Level 2)

By PFTP Ltd

Microsoft Project Introduction - In-company

By Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Microsoft Word Intermediate - In-company (now with live online classes)

By Microsoft Office Training

Microsoft Excel Introduction - In-company

By Microsoft Office Training

Nail Technician Level 3

By Penelope Academy

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Essentials Of Sepsis Recognition & Escalation For Care & Support Staff

By NR Medical Training

Search By Location