Name: Microsoft Excel Advanced - In-company
Price: 650 GBP
Availability: InStock

London

<p><strong>Course Objectives</strong></p> <p><strong>At the end of this course you will be able to:</strong></p> <ul> <li>Customise message settings</li><li>Organise and locate Outlook messages</li><li>Set Calendar options</li><li>Manage their Contacts</li><li>Work with activities using the Journal and Tasks</li><li>Share their workspaces</li><li>Manage their Outlook data files</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>Configure Advanced Message Options</strong></p> <ul> <li>Delay delivery</li><li>Insert Advanced Characters and Objects</li><li>Modify Message Settings, Properties, and Options</li><li>Use Automatic Replies</li></ul> <p><strong>Advanced Message Management</strong></p> <ul> <li>Sort Messages</li><li>Filter Messages</li><li>Organise Messages</li><li>Search Messages</li><li>Manage Junk Mail</li><li>Manage Your Mailbox</li></ul> <p><strong>Automate Repetitive Tasks</strong></p> <ul> <li>Quick steps</li><li>Rules</li><li>Auto Archive</li></ul> <p><strong>Advanced Calendar Management</strong></p> <ul> <li>Manage Advanced Calendar Options</li><li>Create Calendar Groups</li><li>Manage Meeting Responses</li></ul> <p><strong>Advanced Contact Management</strong></p> <ul> <li>Edit an Electronic Business Card</li><li>Manage Advanced Contacts Options</li><li>Forward Contacts</li><li>Export Contacts</li></ul> <p><strong>Managing Activities by Using Tasks and Journal Entries</strong></p> <ul> <li>Assign and Manage Tasks</li><li>Record and Modify Journal Entries</li></ul> <p><strong>Sharing Workspaces with Others</strong></p> <ul> <li>Delegate Access to Mail Folders</li><li>Share Your Calendar</li><li>Share Your Contacts</li></ul> <p><strong>Managing Outlook Data Files</strong></p> <ul> <li>Back Up Outlook Items</li><li>Change Data File Settings</li><li>Configuring Email Message Security Settings</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 experienced Outlook users who need to increase their efficiency in the usage and manipulation of emails, tasks and the calendar.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates would have attended the MS Outlook Introduction course.</p> 
                        </div>

Microsoft Office Training

Microsoft Outlook Advanced - In-company (now with trainer led live online classes)

General Admission

Wakefield

<section data-element_type="section" data-id="141278d" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="e6dbe55" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="2d2bccd" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="2aa0345" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="1938d5f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f368761" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="a40907e" fr-original-style="" id="isPasted" style="box-sizing: border-box;"><div data-element_type="column" data-id="80d9f93" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="d499d73" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Overview</h2></div></div></section><section data-element_type="section" data-id="699d259" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="4cfd84c" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="32c6b5e" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This one day&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Building Better Work Habits</strong> training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they&rsquo;re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals.</p></div></div></section><section data-element_type="section" data-id="cf3e46f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="9f8bc76" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="5a51812" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Description</h2></div></div></section><section data-element_type="section" data-id="649d69e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="941a4e4" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="fd58605" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">These training course materials have been designed to help your participants work more effectively for the long term. This isn&rsquo;t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Topics covered:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Productivity: the science bit&nbsp;</strong>&ndash; A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we&rsquo;ve probably already formed. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Procrastination, why put off to tomorrow what we can do today!&nbsp;</strong>&ndash; Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it!</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog&nbsp;</strong>&ndash; An introduction to Brian Tracy&rsquo;s book &ldquo;Eat that frog&rdquo; and how it can help us improve our working habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Thinking on Paper&nbsp;</strong>&ndash; A chance to put into practice some of Brian Tracy&rsquo;s methods and how to use them in our real lives</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Rocks, Pebbles and Sand</strong> &ndash; Taking our goal setting further, we explore Covey&rsquo;s methodology around prioritising our tasks.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: The Pareto Principle</strong>&nbsp;&ndash; The final part of the &ldquo;Eat that Frog&rdquo; section looks at how effective we in terms of how we spend our day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: how do we spend our day?</strong>&nbsp;&ndash; Participants explore how proactive they are, and what the danger might be in letting a situation rule their time</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: The Priority Matrix</strong>&nbsp;&ndash; Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: Company Performance Tensions</strong>&nbsp;&ndash; We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we&rsquo;re successful day to day?</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset?</strong>&nbsp;&ndash; Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck&rsquo;s work, it is a chance to reflect on our own mindsets when we&rsquo;re building new work habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset? Energy Cycles</strong>&nbsp;&ndash; Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be</li></ul></div></div></section><section data-element_type="section" data-id="8b42a41" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="6be2803" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f08ab9c" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Who should attend</h2></div></div></section><section data-element_type="section" data-id="b209fea" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="ce601c1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="e88578c" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Anyone interested in understanding in being more effective at work.</p></div></div></section><section data-element_type="section" data-id="c7c52a5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="68fd8e5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="cae9269" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Requirements for Attendees</h2></div></div></section><section data-element_type="section" data-id="ac22cd1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="28a3b4e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="02734e3" data-widget_type="text-editor.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">None.</p></div><div data-element_type="widget" data-id="0b11949" data-widget_type="button.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><a fr-original-style=" color: rgb(255, 255, 255);" href="mailto:sales@18.132.1.174?subject=%27Building%20Better%20Work%20Habits%27%20Training%20Course" style="color: rgb(255, 255, 255); user-select: auto; box-sizing: border-box; text-decoration: inherit; cursor: pointer;"><br fr-original-style="" style="box-sizing: border-box;">
</a></div></div></section></div></div></section></div></div></section><section data-element_type="section" data-id="f9cb5f1" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="bda27b8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></section>

Inovra Group

Business Development

Professional Development

Building Better Work Habits

Session for up to ten delegates in a single session

Group Session

Building Relationships

Edinburgh

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A comprehensive, 1-day training workshop designed for anyone who wants to develop their knowledge and skills related to Employee Assistance Programmes</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Employee Assistance Programmes (EAPs) are a strategic and cost‐effective workplace programme that is designed to assist productivity and attendance issues within the workplace and support employees to identify and resolve personal concerns that may affect job performance. These issues might include health, marital, family, financial, alcohol, drug, legal, emotional, stress, or other personal issues.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This programme allows delegates to critically analyse their understanding of EAPs and learn about the &lsquo;core technology&rsquo; of these programmes. This workshop is suitable for anyone working with EAPs.</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;">Trainer</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The trainer is Tony Buon, the Managing Partner of Buon Consultancy. He is a well known EAP Professional with over 30 years experience in the field. Tony is also a qualified workplace psychologist, speaker, mediator and author. Tony is a Certified Employee Assistance Professional (CEAP).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tony holds Diplomas in Mediation, Conflict Resolution, Counselling and Teaching. Degrees in Psychology and Behavioural Sciences and Post‐Graduate Qualifications in Education and Business Psychology. He is also an Accredited Mediator (MII).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tony has previously owned and run one of the world&rsquo;s largest global EAP businesses and has consulted with EAP Providers and Buyers on a global basis since 1985.</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;">Who is this for?</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This workshop is suited for a wide range of people, but would most benefit:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1. Those new to the field who need a comprehensive overview of the area</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2. EAP Account Managers &amp; Senior Clinical Staff</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">3. EAP Coordinators</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">4. Those EAP Professionals who need a refresher training on the &lsquo;core technology&rsquo; of EAPs</p><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;">How will it be taught?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants to this seminar will receive a thorough training on EAPs with the trainer utilising a variety of proven adult learning teaching and facilitation techniques. Mini‐presentations, group work and exercises will be used to facilitate learning and provide a fun and energising learning environment.</p><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;">Why you should book?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">You will be taught by a world expert in EAPs and gain extensive knowledge of EAPs and how they can deliver real value to any workplace</li><li fr-original-style="" style="box-sizing: border-box;">Gain valuable insights that will inform and greatly improve your work in the EAP field</li><li fr-original-style="" style="box-sizing: border-box;">The workshop will give you valuable knowledge about the potential for EAPs by &lsquo;tapping into&rsquo; the global knowledge base of EAP intelligence</li><li fr-original-style="" style="box-sizing: border-box;">This programme allows you to critically analyse your understanding of EAPs and learn about the &lsquo;core technology&rsquo; of EAPs in a one‐day affordable training workshop</li></ul><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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Comments from previous participants:</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo; ...one of the best value courses I have ever attended!&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;I can&rsquo;t believe how much I learnt. This workshop truly expanded my thinking and knowledge about EAPs&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;...the trainer was excellent and the content was great&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;I loved that the course focused on the practical skills of EAPs and how they can deliver added value to people&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;every EAP professional, consultant and counsellor should be required to do this workshop&rdquo;</p><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;"></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Workshop Aim</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To provide participants with knowledge of employee assistance (EAP) theory, techniques and methods</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;">Course Objectives</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">At the completion of this workshop participants should be able to:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1. Appreciate the history and development of Employee Assistance Programmes (EAPs)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2. Understand EAP Manager and Supervisor Referral Methodology</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">3. Explain the &lsquo;Core Technology&rsquo; of EAPs</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">4. Discuss the appropriate steps in implementing an EAP</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;"></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Workshop Content</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">History of EAPs and why it matters now</li><li fr-original-style="" style="box-sizing: border-box;">The EAP &lsquo;Core Technology&rsquo;</li><li fr-original-style="" style="box-sizing: border-box;">EAP Models</li><li fr-original-style="" style="box-sizing: border-box;">The costing models for EAP assessment and referral models</li><li fr-original-style="" style="box-sizing: border-box;">The importance of Supervisor and Manager Referrals in EAPs</li><li fr-original-style="" style="box-sizing: border-box;">The difference between assessment in traditional counselling and EAPs</li><li fr-original-style="" style="box-sizing: border-box;">Substance Abuse and EAPs</li><li fr-original-style="" style="box-sizing: border-box;">Establishing an EAP</li><li fr-original-style="" style="box-sizing: border-box;">What customers want from an EAP</li><li fr-original-style="" style="box-sizing: border-box;">Promotion of EAPs</li><li fr-original-style="" style="box-sizing: border-box;">Global EAPs</li></ul>

Buon Consultancy

The Essentials of EAP Training Workshop (£750 per course for up to 10 people)

General admission

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Modify the PowerPoint environment</li><li>Using Master View in order to customise a design template</li><li>Add and customize SmartArt graphics</li><li>Add animations and change its effect options</li><li>Add action buttons to control the flow of the presentation</li><li>Use various options to customise slide shows</li><li>Use different PowerPoint file types to distribute presentations</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> <p><strong>Very clearly explained</strong></p> </li><li> <p><strong>Good pace.</strong></p> </li><li>Lucy Tailor - 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><strong>Customising the PowerPoint Environment</strong></p> <ul> <li>Customise the User Interface</li><li>Set PowerPoint Options</li></ul> <p><strong>Customising Design Templates</strong></p> <ul> <li>Modify Slide Masters and Slide Layouts</li><li>Add Headers and Footers</li><li>Modify the Notes Master and the Handout Master</li></ul> <p><strong>Adding SmartArt to a Presentation</strong></p> <ul> <li>Create SmartArt</li><li>Modify SmartArt</li></ul> <p><strong>Working with Media</strong></p> <ul> <li>Add Audio to a Presentation</li><li>Add Video to a Presentation</li></ul> <p><strong>Working with Animations</strong></p> <ul> <li>Entrance, Emphasis and Exit Animations</li><li>Animate Charts by Category and Series</li><li>Customise Animations and Transitions</li></ul> <p><strong>Collaborating on a Presentation</strong></p> <ul> <li>Review a Presentation</li><li>Store and Share Presentations on the Web</li></ul> <p><strong>Customising a Slide Show</strong></p> <ul> <li>Annotate a Presentation</li><li>Set Up a Slide Show</li><li>Create a Custom Slide Show</li><li>Add Hyperlinks</li><li>Add Action Buttons</li><li>Record a Presentation</li></ul> <p><strong>Securing and Distributing a Presentation</strong></p> <ul> <li>Secure a Presentation</li><li>Create a Video or a CD</li><li>Distribute the Presentation in different File Formats</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 delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Powerpoint 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 Powerpoint Advanced - In-company (now with live online classes)

<h2>Project Contract Management Skills: In-House Training</h2>
 <p>Contracts are a critical part of most large or strategic projects/programs. As such, it is imperative that Project and Program Managers be well versed on basic implications of a contract as well as best practices in contract management. While not as critical a need, anyone involved in projects that involve external relationships should have a healthy appreciation for the power of good contract management.</p>
 <p>The overall goal of the course is to provide knowledge to manage complex contracts in a global environment.</p><h3>What You Will Learn</h3>
 <p>After this program, you will be able to:</p>
 <ul>
 <li>Explain overall project procurement process from a buyer and seller perspective</li>
 <li>Recognize the importance of key contractual terms and how they affect projects</li>
 <li>Evaluate and contribute to the pre-contract documents and processes</li>
 <li>Identify and mitigate common pitfalls throughout the procurement process</li>
 <li>Utilize techniques to administer contracts</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Course structure</li> <li>Course goals and objectives</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>The Importance of Contract Management</li> <li>Terms and Definitions</li> <li>Contract Management Process</li> <li>Legal Systems</li> <li>Codes of Conduct</li> </ul> <h3>Planning</h3> <ul> <li>Business Analysis</li> <li>Procurement Management Plan</li> <li>Procurement Statement of Work (SOW)</li> <li>Common Pitfalls</li> </ul> <h3>Solicit Contract</h3> <ul> <li>Market Analysis</li> <li>Bid documents</li> <li>Sellers' Proposals</li> <li>Pitfalls</li> </ul> <h3>Execute Contract</h3> <ul> <li>Evaluate and Award Contract</li> <li>Negotiate Contract</li> <li>Execute Contract</li> <li>Common Pitfalls</li> </ul> <h3>Deliver the Contract</h3> <ul> <li>Preparing to Deliver</li> <li>Project Plan</li> <li>Risk Management</li> <li>Common Pitfalls</li> </ul> <h3>Administer Contract</h3> <ul> <li>Enabling Contract Management</li> <li>Contract Performance Monitoring and Control</li> <li>Change Management</li> <li>Financial Management / Payment</li> <li>Dispute Management &amp; Resolution</li> <li>Contract Completion and Closure</li> </ul>


                </section>

IIL Europe Ltd

Project Contract Management Skills: In-House Training

<h2>Program Management Skills: In-House Training</h2>
 <p>Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected.</p>
 <p>The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness.</p>
 <p>The participant will learn and apply the principles of program management through discussions, activities, and case study exercises.</p><h3>What You Will Learn</h3>
 <p>At the end of this workshop, you will be able to:</p>
 <ul>
 <li>Maximize the transformational impact of a program according to the business needs</li>
 <li>Explain management principles and techniques and apply them within a program context</li>
 <li>Implement program governance and organization that will produce expected benefits</li>
 <li>Plan for and manage benefit realization, risks, issues, and quality</li>
 <li>Manage component projects' interdependencies that are linked to both program and strategic objectives</li>
 <li>Engage program stakeholders effectively.</li>
 <li>Improve communication and action planning effectiveness for programs in organizations</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Course structure</li> <li>Course goals and objectives</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>Fundamental definitions and concepts</li> <li>Program challenges and benefits</li> <li>Program best practices and success criterion</li> <li>Stakeholder management</li> <li>Governance: program management office and program boards</li> <li>Standard for Program Management overview</li> </ul> <h3>Vision, Leadership, and the Business Case</h3> <ul> <li>What is vision, why, and how?</li> <li>Leadership vs. Management</li> <li>Program business case</li> </ul> <h3>Program Organization and Governance</h3> <ul> <li>Program organization</li> <li>Program governance</li> <li>Program board roles and responsibilities</li> </ul> <h3>Benefits Management</h3> <ul> <li>Benefits explored</li> <li>Benefits management</li> <li>Benefits realization</li> </ul> <h3>Program Management Planning</h3> <ul> <li>Program management plan</li> <li>Program blueprint and roadmap</li> <li>Program component dossier</li> <li>Program tranches</li> <li>Program estimating</li> <li>Program scheduling</li> </ul> <h3>Program Monitoring and Controlling</h3> <ul> <li>Program Control - An Overview</li> <li>Program Monitoring and Controlling</li> <li>Monitoring and Controlling Transition</li> </ul> <h3>Program Risk and Issue Management</h3> <ul> <li>Risk and issue management overview</li> <li>Program risk management</li> <li>Program issue management</li> </ul> <h3>Program Quality Management</h3> <ul> <li>Program quality management overview</li> <li>Program quality management principles</li> </ul> <h3>Program Stakeholder Management</h3> <ul> <li>Stakeholder engagement overview</li> <li>Stakeholder engagement planning</li> <li>EI, trust, communication and stakeholder engagement</li> </ul> <h3>Program Closure and Benefits Sustainment</h3> <ul> <li>Program closure overview</li> <li>Closing the program</li> <li>Program benefits sustainment</li> </ul> <h3>Summary</h3> <ul> <li>What did we learn, and how can we implement this in our work environments?</li> </ul>


                </section>

Program Management Skills: In-House Training

<h2>Microsoft Project Orange Belt® 2016: In-House Training</h2>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users.</p>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Understand what's new in Project 2016</li> 
 <li>Explain where Project 2016 fits in the Microsoft® EPM solution</li> 
 <li>Initialize Project 2016 to start project planning</li> 
 <li>Create a well-formed project schedule</li> 
 <li>Understand task types and the schedule formula</li> 
 <li>Assign resources and costs to tasks</li> 
 <li>Analyze resource utilization and optimize the schedule</li> 
 <li>Set a baseline and track progress</li> 
 <li>Create and manage project reports</li> 
 <li>Customize views and fields</li> 
 <li>Apply Earned Value Management</li> 
 <li>Understand the basics of managing multiple projects</li> 
 </ul><section>
                    <h3>Getting Started</h3> <ul>  <li>Introductions</li>  <li>Course structure</li>  <li>Course goals and objectives</li>  </ul>  <h3>Concepts of Project Management</h3> <h3>Getting Started with Project 2016</h3> <ul>  <li>Project 2016: What's New and General Overview</li>  <li>Setting Up a New Project Schedule (templates, options, save, etc.)</li>  <li>Setting the Project Calendar</li>  </ul>  <h3>Entering Tasks</h3> <ul>  <li>The planning processes</li>  <li>Importing tasks (Word, Excel, SharePoint)</li>  <li>Synchronizing with SharePoint Tasks List</li>  <li>Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding)</li>  </ul>  <h3>Entering Estimates</h3> <ul>  <li>Tendencies in estimating</li>  <li>The rolling wave approach</li>  <li>Entering duration and work estimates</li>  <li>Types of tasks</li>  </ul>  <h3>Entering Dependencies</h3> <ul>  <li>The principle of dynamic scheduling</li>  <li>Choosing the right Type of dependency</li>  <li>Entering dependencies in Project 2016</li>  <li>Different applications of dependencies</li>  </ul>  <h3>Entering Deadlines, Constraints, and Task Calendars</h3> <ul>  <li>Use of deadlines and constraints</li>  <li>Entering deadlines and constraints in Project 2016</li>  </ul>  <h3>Entering Resources and Costs</h3> <ul>  <li>Types of resources</li>  <li>Entering resources in Project 2016</li>  <li>Calendars and resources</li>  <li>Entering costs in Project 2016</li>  </ul>  <h3>Entering Assignments</h3> <ul>  <li>Assignments in a schedule</li>  <li>Assignments and task types</li>  <li>Entering assignments in Project 2016</li>  <li>Assignments, budgets, and costs</li>  </ul>  <h3>Optimizing the Schedule</h3> <ul>  <li>The critical path method (CPM) and the resource critical path (RCP)</li>  <li>Resource leveling</li>  <li>Optimizing time, cost, and resources in Project 2016</li>  </ul>  <h3>Updating the Schedule</h3> <ul>  <li>The baseline</li>  <li>Updating strategies and situations</li>  <li>Prepare the status and forecast report in Project 2016</li>  </ul>  <h3>Reporting</h3> <ul>  <li>Using reports</li>  <li>Using Visual Reports</li>  <li>Formatting and printing in Project 2016</li>  <li>Customizing fields in Project 2016</li>  </ul>  <h3>Earned Value Management (EVM)</h3> <ul>  <li>Overview of EVM</li>  <li>Applying EVM with Project 2016</li>  </ul>  <h3>Evaluating the Project</h3> <ul>  <li>Evaluating the project performance</li>  <li>Project benefits and results</li>  <li>Templates for future projects</li>  </ul>  <h3>Summary and Next steps</h3> <ul>  <li>Tools and checklist</li>  <li>Best practices checklist</li>  <li>Certification options</li>  </ul>


                </section>

Microsoft Project Orange Belt 2016: In-House Training

<h2>Microsoft Project Orange Belt® 2013: In-House Training</h2>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users.</p>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Understand what's new in Project 2013</li> 
 <li>Explain where Project 2013 fits in the Microsoft® EPM solution</li> 
 <li>Initialize Project 2013 to start project planning</li> 
 <li>Create a well-formed project schedule</li> 
 <li>Understand task types and the schedule formula</li> 
 <li>Assign resources and costs to tasks</li> 
 <li>Analyze resource utilization and optimize the schedule</li> 
 <li>Set a baseline and track progress</li> 
 <li>Create and manage project reports</li> 
 <li>Customize views and fields</li> 
 <li>Apply Earned Value Management</li> 
 <li>Understand the basics of managing multiple projects</li> 
 </ul><section>
                    <h3>Getting Started</h3> <ul>  <li>Introductions</li>  <li>Course structure</li>  <li>Course goals and objectives</li>  </ul>  <h3>Enterprise Project Management Concepts and Framework</h3> <h3>Getting Started with Project 2013</h3> <ul>  <li>Project 2013: What's New and General Overview</li>  <li>Setting Up a New Project Schedule (templates, options, save, etc.)</li>  <li>Setting the Project Calendar</li>  </ul>  <h3>Entering Tasks</h3> <ul>  <li>The Planning Processes</li>  <li>Importing Tasks (Word, Excel, SharePoint)</li>  <li>Synchronizing with SharePoint Tasks List</li>  <li>Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks and milestones, as well as custom WBS coding)</li>  </ul>  <h3>Entering Estimates</h3> <ul>  <li>Tendencies in Estimating</li>  <li>The Rolling Wave Approach</li>  <li>Entering Duration and Work Estimates</li>  <li>Types of Tasks</li>  </ul>  <h3>Entering Dependencies</h3> <ul>  <li>The Principle of Dynamic Scheduling</li>  <li>Choosing the Right Type of Dependency</li>  <li>Entering Dependencies in Project 2013</li>  <li>Different Applications of Dependencies</li>  </ul>  <h3>Entering Deadlines, Constraints, and Task Calendars</h3> <ul>  <li>Use of Deadlines and Constraints</li>  <li>Entering Deadlines and Constraints in Project 2013</li>  </ul>  <h3>Entering Resources and Costs</h3> <ul>  <li>Types of Resources</li>  <li>Entering Resources in Project 2013</li>  <li>Calendars and Resources</li>  <li>Entering Costs in Project 2013</li>  </ul>  <h3>Entering Assignments</h3> <ul>  <li>Assignments in a Schedule</li>  <li>Assignments and Task Types</li>  <li>Entering Assignments in Project 2013</li>  <li>Assignments, Budgets, and Costs</li>  </ul>  <h3>Optimizing the Schedule</h3> <ul>  <li>The Critical Path Method and the Resource Critical Path</li>  <li>Resource Leveling</li>  <li>Optimizing Time, Cost, and Resources in Project 2013</li>  </ul>  <h3>Updating the Schedule</h3> <ul>  <li>The Baseline</li>  <li>Updating Strategies and Situations</li>  <li>Prepare the Status and Forecast Report in Project 2013</li>  </ul>  <h3>Reporting</h3> <ul>  <li>Using Reports</li>  <li>Using Visual Reports</li>  <li>Formatting and Printing in Project 2013</li>  <li>Customizing Fields in Project 2013</li>  </ul>  <h3>Earned Value Management (EVM)</h3> <ul>  <li>Overview of EVM</li>  <li>Applying EVM with Project 2013</li>  </ul>  <h3>Evaluating the Project</h3> <ul>  <li>Evaluating the Project Performance</li>  <li>Project Benefits and Results</li>  <li>Templates for Future Projects</li>  </ul>  <h3>Summary</h3> <ul>  <li>Tools and Checklist</li>  <li>Best Practices Checklist</li>  </ul>  <h3>Consolidated Schedules</h3> <ul>  <li>Creating Consolidated Schedules</li>  <li>Using a Resource Pool</li>  <li>Links across Projects</li>  <li>Solving common problems</li>  <li>Analyzing the Critical Path across Projects</li>  </ul>


                </section>

Microsoft Project Orange Belt 2013: In-House Training

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</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>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>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</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 intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate 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 Advanced - In-company

Brighton

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Nottingham

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (Foundation Degree Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - 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.


Attend a classroom location to complete your practical training.


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.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


Advanced Phlebotomy - Skills & Techniques (GPT005)

Key Facts:


COURSE 1: PERIPHERAL I.V. CANNULATION COURSE (GPT008)



ONLINE STUDY - In your own time (approx. 5-6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.

 
Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)
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:


COURSE 2: VACCINATION / INJECTION COURSE (GPT601)



ONLINE STUDY - In your own time (approx. 5-6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)


Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (FDSc Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)



SUITABLE FOR:
- MEDICAL / HEALTHCARE (trainees and professionals)
- AESTHETIC THERAPISTS (all levels)

 
This Vaccination / Injection Course is a nurse or paramedic-led half-day session covering all essential theory and practical skill-sets required to deliver effective Intramuscular, Intradermal and Subcutaneous injections / vaccinations.
 
PART 1 - THEORY (online)
Delegates will fully understand the theory and will be able to demonstrate they can identify the correct patient, gain consent and safely administer a vaccine or injection, conforming to WHO and Skills for Health recommended standards.
 
Itinerary:
M01 Course Overview and brief history
M02 Infection Protection Control
M03 Professionalism and Effective Communication
M04 Understanding injection procedures
M05 Why do we vaccinate?
M06 The immune system and how vaccines work. Vaccine types and composition.
M07 The National Vaccine Policy & Schedule
M08 Vaccine preventable diseases
M08A – Covid-19 Update
M09 Vaccines - understanding the reconstitution process
M10 Storage and Handling – understanding correct procedures and protocols
M11 Equipment – Syringes and Syringe Types, Needles and Needle Types, SDV (Single-Dose Vials), MDV (Multi-Dose Vials), Pre-Filled Syringes, Gloves and PPE.
M12 Vaccination sites, techniques and anatomical site selection
i) Intramuscular (IM) Injection
ii) Subcutaneous (SubCut) Injection
iii) Intradermal (ID) Injection
M13 Legal requirements, Consent and Standard Operating Procedures
M14 Adverse Reactions and Basic Life Support Guidance
M15 Record keeping & Documentation
 
PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING
PART 2 - CLASSROOM (am, pm or evening sessions)
3 - 4 hours skill-set development with practical demonstrations and hands-on experience performing Intramuscular, Intradermal and Subcutaneous Injections.
 


How do I attend?

EITHER -
CLASSROOM OPTION - Complete your theory training online at home or work, then attend one of our scheduled classroom locations, completing your Peripheral IV Cannulation Course and your Injection Course on the same day.
Our Peripheral IV Cannulation Course and Injection Course 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 for you to add at time of booking. Training kits mirror the same equipment and supplies used in the classroom and both include detailed video instructions, 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 your one full day to complete your cannulation and injection course training.

Our Virtual Classroom option includes two very comprehensive training kits - one for your cannulation course and one for your injection course. Kits are included at no charge (normally £79.95 and £39.95 respectively) 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.

Additional Courses suitable for Aesthetic Therapists:
Our popular Introduction to Phlebotomy Course also trains you to perform venepuncture at Advanced Level. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Advanced Level.
If you already have phlebotomy skills (or decide to enroll on our phlebotomy training course) then you will be able to offer your clients Platelet-Rich Plasma (PRP) Treatments, also known as Vampire Facials. Our PRP (Vampire Facials) Course trains you in the harvesting, preparation and treatment of PRP for application to your clients as required. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Foundation Degree Level.

If you would like to "mix and match" your training dates and/or locations or would like to build your own package of courses 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 dually accredited and are Skills for Health & WHO compliant.

Medical Aesthetics

Platelet-rich plasma (PRP)

Intravenous Cannulation

Aesthetic Practitioner

Facial Aesthetics

THIS COURSE PACKAGE INCLUDES:
1: PERIPHERAL I.V. CANNULATION - IV THERAPIES COURSE (GPT008)
2: VACCINATION / INJECTION COURSE (GPT601)

Learn how to administer injectables and intravenous therapies ...

FAST-TRACK YOUR AESTHETICS TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% Multi-Course Discount

    Cover all stages from Level 1 through to Level 4 (FDSc)

    Cover your theory training online

    Complete your advanced practical training in 1 day

    Practical training in Classroom or Virtual Classroom

    Comprehensive Practise@Home training kits for VC

    Awards 2 accredited qualifications

    Dual Accreditations for all courses

    Covers all steps required to safely perform injectables

    Covers all steps required to safely perform IV therapies

    Practise IV on artificial arm with fake blood

    Practise injection techniques on realistic injection pads

    Learn beginner to advanced skills and techniques

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Aesthetic Therapy Training - Beginner to Advanced PACKAGE

Cardiff

Milton Keynes 

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">ONLINE STUDY - In your own time (approx. 6 hours study time) +</span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span 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;"></span></strong></span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Awarding Body:</strong>&nbsp;Open College Network (OCN) Credit for Learning</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Award Level:</strong>&nbsp;Level 3 (Advanced Level) - Ireland Level 5</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Certified:</strong>&nbsp;Yes (CPD Accreditation)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Minimum Age:&nbsp;</strong>18 (16 with parental consent)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements:&nbsp;</strong>None. (English Level 2 desirable)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Locations:</strong>&nbsp;Study online + Classroom</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">OCN Accredited at UK Level 3 (Ireland Level 5)</span><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - Theory:</strong>&nbsp;Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.<br fr-original-style="" style="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;">PART 2 - Skills and Practical Development:</strong><br fr-original-style="" style="box-sizing: border-box;">Safely and competently set up and maintain a Peripheral IV Infusion.<br fr-original-style="" style="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></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attend a classroom location to complete your practical training.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">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.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Itinerary:</strong></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - THEORY (ONLINE)</strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M1 - Peripheral IV Cannulation - Introduction:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Definitions - understanding terminology relating to PIVC.<br fr-original-style="" style="box-sizing: border-box;">IV Therapy and NMC guidelines.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Legal Obligations and Accountability. Criminal, Civil and<br fr-original-style="" style="box-sizing: border-box;">Contractual law in Healthcare. Vicarious Liability and your<br fr-original-style="" style="box-sizing: border-box;">Duty of Care.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M3 - Anatomy &amp; Physiology:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Sites appropriate to IV cannulation. Hand vs. arm.<br fr-original-style="" style="box-sizing: border-box;">Advantages and disadvantages of relevant veins.<br fr-original-style="" style="box-sizing: border-box;">An overview of Homeostasis and Fluid Balance.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M4 - Hygiene and Infection Prevention &amp; Control (IPC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Reducing healthcare-associated infections. Keeping Safe.<br fr-original-style="" style="box-sizing: border-box;">Bloodborne Pathogens and Work Practice Controls.<br fr-original-style="" style="box-sizing: border-box;">Standard Precautions. Waste Disposal. Needle-stick injuries.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M5 - Indications and Advantages:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When to cannulate, infusion types and benefits over<br fr-original-style="" style="box-sizing: border-box;">alternative infusion routes. Continuous and intermittent infusion.<br fr-original-style="" style="box-sizing: border-box;">Prophylactic use before procedures and in unstable patients.<br fr-original-style="" style="box-sizing: border-box;">Contraindications.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M6 - Equipment:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Cannula types, sizes and colour coding. How to select<br fr-original-style="" style="box-sizing: border-box;">appropriate size. Equipment overview for total procedure.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M7 - Vein Choice for Cannulation:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Correct vein selection. Which veins to avoid.<br fr-original-style="" style="box-sizing: border-box;">How to manage an unsuccessful cannulation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8 - Procedures:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Full procedure for cannulation including correct documentation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Guide to Cannulation - revision</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Video - Recap with full procedure</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M9 - Contraindications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When inappropriate to cannulate including patients with specific health conditions.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M10 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at potential complications during and after<br fr-original-style="" style="box-sizing: border-box;">cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.<br fr-original-style="" style="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;">PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED</strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">BEFORE JOINING US FOR YOUR PRACTICAL TRAINING</strong><br fr-original-style="" style="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;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART 2 (CLASSROOM:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 - Welcome, introductions and overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Classroom - registration and introductions.<br fr-original-style="" style="box-sizing: border-box;">Virtual Classroom - audio/visual checks and registration.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Overview and discussion.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 - Anatomy - key points (appropriate to PIVC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Arteries and veins. Selecting an approprate site. Sites to avoid and &ldquo;first choice&rdquo; sites.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4 - Cannulae - selection and types:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Complications of pVAD insertion including examples of<br fr-original-style="" style="box-sizing: border-box;">infiltration, haematoma, extravasation and transfixation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 - VIP Score:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Understanding and using the Visual Infusion Phlebitis score.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7 - Equipment - overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">We take a look at all essential equipment required for PIVC.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 - PRACTICAL SESSIONS:</strong><br fr-original-style="" style="box-sizing: border-box;">Multiple practical sessions throughout the session.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 - Fluids:</strong></span><br fr-original-style="" style="box-sizing: border-box;">The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann&rsquo;s solution, Colloids (and risks), blood products.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 - Infusion Rates:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Calculating infusion rates and drops per minute.<br fr-original-style="" style="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;"><em fr-original-style="" style="box-sizing: border-box;">This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.</em></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)</strong></em></p></div></div><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>

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.


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.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Aesthetics

Medicine & Nursing

Venepuncture & Cannulation

Learn how to cannulate ...

    Nationally Recognised Qualification

    OCN Accredited - Level 3 (advanced) - Ireland Level 5

    CPD Accredited - The CPD Certification Service

    Classroom or Virtual Classroom options

    Covers all steps for cannulating in arm or hand

    Practise on artificial arms and fake blood!

    Essential qualification for all IV therapies

    Phlebotomy training desirable but not essential

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Peripheral I.V. Cannulation Course (GPT008)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Retreat in Daily Life</strong> is a way to find something of what you might experience on a residential retreat, with the difference being that you are at home, and the prayer experience is woven into the rhythm of your ordinary life.&nbsp;</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The&nbsp;Contemplative at Home Retreat in Daily Life</strong> involves two components:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Six days per week : Thirty to Forty-five minutes of <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">daily personal prayer</strong>, with suggested meditations and reflection questions.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">One day per week : A&nbsp;two-hour Zoom call, to share with other pilgrims who are on retreat with you. Lissy hosts these sessions in a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">group spiritual direction</strong> format.&nbsp;</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this for?</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This retreat is suitable for anyone who has (or has had) some kind of practice of Christian prayer, and is ready to explore a bit more of their faith, their prayer life or their relationship with God.&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This might be for you if you</div><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would like to explore the contemplative prayer traditions of the Christian faith</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Are ready for something deeper in your relationship with God</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Hope to find God in new ways</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like some structure and support to help you reinstate a habit of daily prayer</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like to go away on retreat, but are unable to at the moment</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enjoy&nbsp;</span>Contemplative at Home meditations and want to connect&nbsp;with others who do as well</div></li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="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;">Prayer Material</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Meditations from the Contemplative at Home archives are suggested for five days of the week, with an Examen or review practice on the sixth day of the week. Each week follows a slightly different theme.</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p id="isPasted" style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week One: Introduction to Contemplative Prayer / Establishing your Routine</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Two: Lectio Divina / Listening to Scripture</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Three: Imaginative Contemplation / Encoutering Jesus&nbsp;</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Four: Praying with the Psalms / My Life in God</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Prompts for reflection are also provided. Most of the meditations are around twenty minutes in length, with a suggested 15 minutes after the audio&nbsp;meditation for journalling or reflecting on your prayer experience.&nbsp;</span></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Details and Commitment</strong></p><p 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;">The times listed on the sign up link above reflect the time for the group calls. Please be aware of your local time zone. I work in the UK and times may be listed for GMT.&nbsp;&nbsp;</span></p><p 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;">There will be one call before the retreat begins, and one at the end of each week, for a total of 5 calls.&nbsp;</span></p><p 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;">There will be a maximum of six participants in the group.<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;">Please check that you are able to attend all of the group sessions before you apply.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The daily prayer can be done at any time that suits you but, if you don&#39;t already have a 30-45 minute window of time devoted to prayer each day, do take some time to think about when you might fit it in, for example: will you wake up earlier? Will you do it at lunch time? in the evening? How realistic is this? &nbsp;Is there a place in your house where you could sit to pray? Will&nbsp;those you share space with will be able to respect your commitment to the retreat?</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;">This won&#39;t be for everyone, but for those who are drawn to take part in this prayer experience, I have no doubt that it will be a positive and enriching time. I am really looking forward to sharing this space with you.</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;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Contemplative at Home

Contemplative at Home Retreat in Daily Life

Reading

Dickson Training Ltd

ILM Level 5 Qualifications in Business Coaching and Mentoring

Diploma (Zoom)

Certificate (Zoom)

Diploma

Certificate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on rally regularity timing for jogularity and regularity in styles where a full average speed time schedule is provided. The competitive component of on the public highway historic road rallying, focusing on jogularity style timing. Ideal for competitors on events such as HERO Challenge, Rally the Globe events or Three Castles.
</p>

Join our exclusive 60-minute webinar on rally regularity timing, designed to give an introduction to regularities in the jogularity or cumulative speed table styles. Learn how to navigate a full average speed time schedule and master the competitive aspects of historic road rallying on public highways. This session focuses on the processes required to understand and use the supplied time schedules, perfect for those competing in events like the HERO Challenge, Rally the Globe, and Three Castles. Whether you're a seasoned competitor or looking to sharpen your skills, this webinar will equip you with the strategies you need to succeed.


Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on the Jogularity and Cumulative Speed Table styles.

Rally Navigation - Introduction to Regularity Timing

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">FAA Level 1 Award In Awareness Of First Aid For Mental Health (RQF)</h2><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;"><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Classroom (4.5 hour course), Virtual (2 x 2 &frac12; hour sessions)&nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners a good awareness of Mental Health First Aid</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners the skills to start that difficult conversation</strong></li></ul><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;"><h3 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Contents:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is Mental Health?</li><li fr-original-style="" style="box-sizing: border-box;">Why people develop mental health conditions</li><li fr-original-style="" style="box-sizing: border-box;">What the role of a mental health first aider is</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to provide advice and practical support</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to recognise and manage stress</li><li fr-original-style="" style="box-sizing: border-box;">Recognising a range of mental health conditions:</li><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Depression</li><li fr-original-style="" style="box-sizing: border-box;">Anxiety</li><li fr-original-style="" style="box-sizing: border-box;">Psychosis</li><li fr-original-style="" style="box-sizing: border-box;">Eating disorders</li><li fr-original-style="" style="box-sizing: border-box;">Suicide</li><li fr-original-style="" style="box-sizing: border-box;">Self-harm</li></ul></ul><h3 fr-original-style="" style="box-sizing: border-box;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">37% of all work-related ill-health is due to mental health problems</li><li fr-original-style="" style="box-sizing: border-box;">Problems with mental health cover 45% of all working days lost</li><li fr-original-style="" style="box-sizing: border-box;">A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">602,000 workers suffered from work-related stress, depression or anxiety in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">One in four people will have a mental health problem at some point during their lives</li><li fr-original-style="" style="box-sizing: border-box;">Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees</li><li fr-original-style="" style="box-sizing: border-box;">Work-related mental health issues must to be assessed to measure the levels of risk to staff</li><li fr-original-style="" style="box-sizing: border-box;">Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable</li><li fr-original-style="" style="box-sizing: border-box;">This half day course gives people a good awareness of mental health in the workplace</li><li fr-original-style="" style="box-sizing: border-box;">For a more complete introduction, see our full day First Aid for Mental Health or two day Supervising First Aid for Mental Health courses</li></ul><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;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/6c550a94-5c16-4ff3-b27f-7407b1a35e22/original.jpeg" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This Awareness of Mental Health First Aid Course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="http://www.firstaidawards.com/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">First Aid Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This means that you can be rest assured that your Mental Health First Aid Certificates fulfil the upcoming <img src="https://images.cademy.co.uk/pochat-training/93996411-85e2-4821-bf00-5875b510df81/original.png" style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff&#39;s mental health conditions.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/3768/0</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;"><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;"><br fr-original-style="" style="box-sizing: border-box;"></p><img src="https://images.cademy.co.uk/pochat-training/7cbdb7f4-2060-482c-aab7-6d4ad4183309/original.png" style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">

Pochat Training

Mental Health Awareness

Mental Health First Aid

Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Mental Health

Emotional Resilience

Accredited Mental Health First Aid

Mental Resilience

Mental Health At Work

Resilience

Awareness of First Aid for Mental Health

 This price includes an Ofqual regulated certificate

 With Ofqual regulated certificate 

This price includes a CPD certificate instead of an Ofqual regulated certificate (it's exactly the same course)

 With CPD certificate

<h2 id="isPasted" style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);">About this event</h2><div style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">COURSE INTRODUCTION</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">AIMS AND OBJECTIVES</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Be able to provide accurate and up to date information about BCG and TB vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Update staff on current issues</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Provide a safe, effective and high standard of care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">COURSE CONTENTS</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The aims of TB immunisation: national policy and schedules</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; History of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; How common is TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Epidemiology and current statistics</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Screening and testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Latent TB infection</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Active TB disease</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Signs and symptoms of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Diagnosis</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; IGRA Testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Treatment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Management</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; TB Vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Practical workshop</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Technique-intradermal</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; BCG Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Mantoux / Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Scar identification</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The legal aspects of vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Prescribing vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Storage and handling of vaccines - cold chain</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Correct administration of vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Record-keeping and reporting</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Competence Assessment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">WHO SHOULD ATTEND?</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Nurses - Primary Care, Secondary Care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Occupational Health Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Doctors - Occupational Health</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Military Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Midwives</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Neonatal Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; School Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Includes All course materials and certificate of attendance</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">AB Health Group awards CPD points / certificate of attendance for each course. &nbsp;If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. &nbsp;The charge for the certificate including postage is &pound;30.00.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr AB Health Group</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Organiser Description</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.</p></div>

About this event
COURSE INTRODUCTION
This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.
AIMS AND OBJECTIVES
• Be able to provide accurate and up to date information about BCG and TB vaccines
• Update staff on current issues
• Provide a safe, effective and high standard of care


COURSE CONTENTS
• The aims of TB immunisation: national policy and schedules
• History of TB
• How common is TB
• Epidemiology and current statistics
• Screening and testing
• Latent TB infection
• Active TB disease
• Signs and symptoms of TB
• Diagnosis
• IGRA Testing
• Treatment
• Management
• TB Vaccination
• Practical workshop
• Technique-intradermal
• BCG Technique
• Mantoux / Technique
• Scar identification
• The legal aspects of vaccination
• Prescribing vaccines
• Storage and handling of vaccines - cold chain
• Correct administration of vaccines
• Record-keeping and reporting
• Competence Assessment
Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases
WHO SHOULD ATTEND?
• Nurses - Primary Care, Secondary Care
• Occupational Health Staff
• Doctors - Occupational Health
• Military Staff
• Midwives
• Neonatal Nurses
• School Nurses
Includes All course materials and certificate of attendance
AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00.


Annie Barr AB Health Group
Organiser Description
Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.

AB Health Group

General Health

Medical Training

Public Health

BCG/Mantoux and TB - Webinar

TB / BCG Training WEBINAR

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p><p>Earning your SHRM Certified Professional (SHRM-CP) or SHRM Senior Certified Professional (SHRM-SCP) credential makes you a recognized expert and leader in the HR field and a valuable asset to your organization, keeping  you and your organization more competitive in today's economy. This professional distinction sets you apart from your colleagues, proving your high level of knowledge and skills. Students will be able to identify areas of strength and build on them. They will also see where they will need further concentrated study in preparation for their exam.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION</h3> <ul> <li>The SHRM Body of Competency and Knowledge? (BoCK)</li> <li>The SHRM-CP and SHRM-SCP Certifications</li> <li>The SHRM Learning SystemÂ© for SHRM-CP/SHRM-SCP</li> </ul> <h3>2 - HR COMPETENCIES</h3> <ul> <li>Behavioral Competencies</li> </ul> <h3>3 - DOMAIN 1: PEOPLE</h3> <ul> <li>Functional Area #1: HR Strategic Planning</li> <li>Functional Area #2: Talent Acquisition </li> <li>Functional Area #3: Employee Engagement and Retention </li> <li>Functional Area #4: Learning and Development</li> <li>Functional Area #5: Total Rewards</li> </ul> <h3>4 - DOMAIN 2: ORGANIZATION</h3> <ul> <li>Functional Area #6: Structure of the HR Function</li> <li>Functional Area #7: Organizational Effectiveness and Development</li> <li>Functional Area #8: Workforce Management</li> <li>Functional Area #9: Employee and Labor Relations</li> <li>Functional Area #10: Technology Management</li> </ul> <h3>5 - DOMAIN 3: WORKPLACE</h3> <ul> <li>Functional Area #11: HR in the Global Context</li> <li>Functional Area #12: Diversity and Inclusion</li> <li>Functional Area #13: Risk Management</li> <li>Functional Area #14: Corporate Social Responsibly</li> <li>Functional Area #15: U.S. Employment Law and Regulations</li> </ul> <h3>6 - FINAL EXAM/REVIEW/DISCUSSION</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SHRM-CP/SHRM-SCP Certification Preparation training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the SHRM-CP/SHRM-SCP Certification Preparation course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Clifton Practice Hypnotherapy Training (CPHT)

Chartered Institute of Personnel Development (CIPD)

Certified Payroll Professional (CPP)

Professional Skills Course (PSC)

Certified Supply Chain Professional (CSCP)

Scrum Master Professional Certificate (SMPC)

SHRM-CP/SHRM-SCP Certification Preparation

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

491 Courses in Nottingham

Microsoft Outlook Advanced - In-company (now with trainer led live online classes)

By Microsoft Office Training

Building Better Work Habits

By Inovra Group

Building Relationships

By Inovra Group

The Essentials of EAP Training Workshop (£750 per course for up to 10 people)

By Buon Consultancy

Microsoft Powerpoint Advanced - In-company (now with live online classes)

By Microsoft Office Training

Project Contract Management Skills: In-House Training

By IIL Europe Ltd

Program Management Skills: In-House Training

By IIL Europe Ltd

Microsoft Project Orange Belt 2016: In-House Training

By IIL Europe Ltd

Microsoft Project Orange Belt 2013: In-House Training

By IIL Europe Ltd

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Search By Location