Name: Conflict Management 1 Day Training in Nottingham
Price: 595 GBP
Availability: InStock

Belfast

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
We all know an angry face when we see one. Anger is such a universal and powerful emotion that can make you physically and emotionally ill, sap your energy, and poison your relationships or it can motivate you to make needed changes and add vitality to your life. This training program aims to help you adopt a more constructive attitude towards your anger and to more effectively manage anger in others as well. Practical activities and tools will empower those who act out their anger in negative ways to gain better control of their anger and their lives and use it as a tool to motivate and empower them to affirm their integrity or boundaries. The program will encourage participants to look deep inside to explore the roots of their anger and present alternatives to the old ways of thinking and dealing with anger.
Learning Objectives:
By the end of this training course participants will be able to:
Understand both the “Right” skill set and mindset needed to properly manage their anger.
Learn to communicate angry feelings assertively and in ways that will take into account the needs of others.
Adopt a more constructive attitude towards anger and understand the difference between constructive and destructive anger.
Use practical techniques to properly handle anger in others.
Agenda:
Module 1: Anger Anatomy:
Is anger good or bad?
Five famous myths about anger
Having the “Right Mindset” for managing anger
Physical effects of anger
Module 2: The Anger Management Skill Set:
Having the “Right Skill Set” for managing anger.
The 4 deep sources of anger.
The assertive statement to communicate anger.
Rules of assertive behavior.
Module 3: The Anger Management Process:
My personal anger assessment – Self-assessment.
A four-step process to effectively express your anger.
Module 4: Handling Anger in Others:
The importance of listening.
Summarizing and reflecting back on what was said.
Reflecting emotions and reframing statements.
Three-step technique for handling anger in others.
Target Audience:
Anybody who is interested in learning Anger Management Skills.
Prerequisites:
None

Mangates

Anger Management

Anger Management 1 Day Training in Belfast







The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Belfast

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Arbroath

Anger Management 1 Day Training in Arbroath



The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Arbroath

Bath

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.
Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.
Conflict may emerge between managers and their staff, between team members or departments.
Conflict may be expressed openly, but it may also be hidden, in the form of irritation, resentment, loss of morale and lack of commitment. Hidden conflict is easy to miss and therefore can be particularly damaging.
Ultimately, this is likely to have an adverse effect on team and company performance, costing time and money.
It is therefore vital to manage conflict constructively.
As a team member and leader, your ability to deal with and resolve conflicts defines your success in the longer term.
Our one day workshop in Conflict Management and Communication Skills immerses you in the most advanced conflict management tools, strategies and practices applicable today. You will gain hands-on practice on proven frameworks, go through simulations and exercises that will train you to be a highly effective professional and leader, starting day one.
Target Audience:
Anybody who is interested in learning Conflict Management Skills

Learning Objectives:
Getting a handle on and gaining insights into your conflict management style through self-assessments (TKI®).
Role playing to practice techniques and new skills in a safe environment.
Proven best practices for approaching conflict management.
Practices for resolving conflict as a third party mediator.
Scientifically validated frameworks on effective communication in stressful situations.
Transferring your learning back to your work environment using job aids, templates and other resources.
How Will You Benefit?
Build trust and credibility with colleagues and team members
Leverage potential conflict situations as opportunities for critical conversations that enhance work relationships.
Gain confidence in holding difficult conversations calmly and assertively.
Manage difficult situations proactively.
Increase your effectiveness in managing conflict.
See growth in your overall performance
Agenda:
Science behind workplace conflicts
Understanding Human Behavior
Different Personality Types
Conflict Management Styles
Conflict Management Strategies
Workplace Conflicts
Conflict Resolution Agreements
Working with difficult people
Relationship and reputation management
Certification:
Once after the training we will provide you with the course completion certificate.

Conflict Management

Conflict Management 1 Day Training in Bath

High Wycombe 

Conflict Management 1 Day Training in High Wycombe

Exeter

Conflict Management 1 Day Training in Exeter

Dundee

Conflict Management 1 Day Training in Dundee

Coventry

Conflict Management 1 Day Training in Coventry

Chelmsford

Conflict Management 1 Day Training in Chelmsford

Peterborough

Conflict Management 1 Day Training in Peterborough

Nottingham

Conflict Management 1 Day Training in Nottingham

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.Pilates help you build up your core strength, improves posture and breath as well as helping you become more aware of how your body react to movement.If you work from home or are just wanting to move more, then look no furtherA pre-course registration form should be filled out prior to attending a class.Form can be found here: <a href="https://forms.gle/CrDwjPxLk8xgo7eP9" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://forms.gle/CrDwjPxLk8xgo7eP9</a>

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.
Pilates help you build up your core strength, improves posture and breath as well as helping you become more aware of how your body react to movement.
If you work from home or are just wanting to move more, then look no further
A pre-course registration form should be filled out prior to attending a class.
Form can be found here: https://forms.gle/CrDwjPxLk8xgo7eP9

For A Better You - Pilates & Pelvic Floor Health 

Pilates

Health & Fitness

Pelvic Floor

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.

If you work from home or are just wanted to improve yourself then look no further

Pilates - Mixed Ability - ONLINE

General Admission

Chesterfield

Diabetes and Nutrition: Science-Based Strategies for Blood Sugar Control


This course provides in-depth guidance on how nutrition influences diabetes management. Learn practical strategies to regulate blood sugar and improve overall health.

½ day course (face to face classroom)
2 x 2 hr sessions (virtual classroom)
Learn about diabetes
Learn how food affects blood sugar levels
Learn how many calories you actually need
Understand nutrition and how it relates to diabetes
Learn about food labeling and how to use this information to improve your blood sugar levels
Session Contents
Introduction to Diabetes and Relevant Statistics.
What is Diabetes, Different Types of Diabetes, Risk Factors for Diabetes
Affects of uncontrolled Diabetes on the Body
Diabetes Blood Sugar Control
Type 2 Remission
Basal Metabolic Rate (BMR) and Energy Expenditure
How sugars break down
Food Labelling
Essential Nutrients
Balanced Diet
How to Apply this Knowledge in Daily Life
Who Is This Course For?
People newly diagnosed with diabetes
Individuals managing diabetes
Health-conscious individuals focused on prevention
Healthcare professionals and nutritionists
Benefits of this Course:
Expert-led, research-backed information
Practical, real-life meal planning tips
Science-based strategies to improve health
Run with a fully qualified Nutritionist

This Diabetes and Nutrition Course is a CPD Accredited course. We are a CPD accredited Centre via the CPD Accreditation Office.

Pochat Training

Food & Nutrition

Obesity & Diabetes

Health & Nutrition

Nutritional

Diabetes

Obesity

Nutrition

Endocrinology, Diabetes & Metabolism

Nutrition & Diet

Did you know your diet plays a huge role in managing diabetes? 🍏 Learn how in our expert-led course!

Diabetes and Nutrition

Clay Cross

The Emergency Lighting BS 5266 one day course is based upon BS5266:1 (including latest amendments), BS5266:7 and BS5266:8. Emergency lighting is essential for the safety of building occupants. It is vital that the emergency lighting automatically operates in the event of normal lighting failure. The illumination levels and period of time the illumination can be sustained should be sufficient to allow the building occupants to evacuate safely and locate both fire alarm, fire fighting and first aid equipment. The Emergency Lighting BS 5266 course provides the necessary information to designate emergency escape routes and design and commission an emergency lighting scheme to BS 5266. The morning of the Emergency Lighting BS 5266 course is spent reading through and interpreting the relevant parts of BS 5266. The afternoon takes the form of a practical workshop where a system is designed and the participant is then introduced to the practical issues of commissioning, inspection and testing, certification and reporting.

Technique Learning Solutions

Emergency Lighting

Stratford

Our CITB Online - Site Supervisors’ Safety Training Scheme (SSSTS) Refresher course is designed to give attendees a broad reminder of their responsibilities for health and safety on construction sites. Approved and endorsed by the United Kingdom Contractors Group, the SSSTS refresher course is a must for anyone who occupies a supervisory role on UKCG sites and wants to brush up on their knowledge of their legal responsibilities and the latest construction industry regulations.
The SSSTS Refresher course has been created to provide existing supervisors, or those who are just entering into a supervisory role, with in-depth knowledge of health and safety legislation and procedures. If a candidate completed a full SSSTS training course up to 5 years ago, they will be required to attend a refresher programme.
Prerequisites
SSSTS certificates are of course valid for up to 5 years, but due to the ever-changing nature of the industry, it is recommended that staff stay up to date by enrolling on a refresher course long before the qualification expires.
Instructions
Please note all Site Supervisor Training courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

SMC Safety Solutions

Site Supervisor Training Scheme (SSSTS) Refresher

This one-day course is a must for anyone considering or already working within a construction or civil engineering environment. This course provides Health and Safety awareness and is endorsed by Build UK as a standard training for all operatives on site.
Aims
To give a clear understanding of Regulations & Legislation that applies to construction work and is an ideal refresher for any operative that has previously completed training in Health & Safety.
Course Content
• Accident prevention
• Health & Safety law
• Control and management of the site and your how your role fits in with this
• Risk assessments and method statements
• Performing safely on site
• Reporting unsafe acts to prevent an accident
• Individual & employee responsibilities
• What to do if you think anyone’s Health and Safety is being put at risk
Assessment
At the end of this course, all delegates will have a clear understanding of the requirements of Health and Safety Legislation and their responsibilities to comply with them.
Candidates will need to complete a multiple-choice exam at the end of the CITB course. They will also need to engage and interact with others throughout the day.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all operatives. The certificate is part of CSCS Green Card requirements.
To remain certified in this area, you will need to retake the course before the expiry date or have completed an NVQ2 or higher in your skills set.
Instructions
Please note all Health & Safety Awareness courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Health & Safety Awareness (for Green CSCS)

IT Cyber Security Engineer – Job Ready Programme
Enrol in Our IT Cyber Security Engineer – Job Ready Programme with Career Support!
Gain access to 3,000+ online courses and earn Free Certificates to showcase your skills and boost your career potential.
Step into the high-demand world of cyber security with a comprehensive programme designed for the UK job market. Master critical areas like penetration testing, secure cloud architecture, AI-powered threat detection, and GDPR compliance—skills that can lead to roles earning up to £95,000 a year.
As UK businesses face £27 billion in cybercrime losses annually, the demand for skilled IT Cyber Security Engineers has never been greater. Whether you're changing careers or upskilling, this course equips you with in-demand expertise in threat intelligence, cryptography, and secure coding.
Become the digital defence every company needs. Start your journey toward a resilient and rewarding career in cyber security today.

Professional Diploma in IT Cyber Security Engineer – 25 Core Courses
– Course 01: Cyber Security Online Course: DOSS and DDOS
– Course 02: Cyber Security Training: Incident Handling & Response
– Course 03: Security Threat Management
– Course 04: Certified Information Security Manager (CISM)
– Course 05: Certified Information Systems Security Professional (CISSP)
– Course 06: CompTIA Advanced Security Practitioner (CASP)
– Course 07: Computer Network Security Complete Training
– Course 08: CyberSec First Responder: Threat Detection and Response [QLS Level 7]
– Course 09: Bash Scripting and Shell Programming for Beginners
– Course 10: Ethical Hacking Masterclass
– Course 11: CompTIA PenTest+ Ethical Hacking Course
– Course 12: BlackArch Linux: Ethical Hacking and Penetration Testing
– Course 13: Ultimate Linux Security and Hardening Training
– Course 14: The Complete Python Hacking Course: Beginner to Advanced!
– Course 15: SQL Database Basics
– Course 16: CompTIA Network+ Certification (N10-008)
– Course 17: CompTIA A+ Core 1 (220-1101) Course
– Course 18: CompTIA A+ Core 2 (220-1102) Course
– Course 19: CompTIA Security+ (SY0-601)
– Course 20: CompTIA Cloud+ CV0-002 Course
– Course 21: Cisco CCENT/CCNA Interconnecting Cisco Networking Devices Part 1
– Course 22: Cisco CCNA Interconnecting Cisco Networking Devices Part 2 (ICND2) Training
– Course 23: Cisco ASA Firewall Training with Step-by-Step Lab Workbook
– Course 24: FortiGate Firewall Training Step-by-Step Lab Workbook
– Course 25: Palo Alto Firewall Training with Step-by-Step Lab Workbook
Job Readiness & Career Development Training (Complementary)
– Course 01: Career Development Training
– Course 02: Effective CV Writing
– Course 03: CV Writing and Interview Tricks
– Course 04: Ace the Interview – Interview Prep That Makes a Difference
– Course 05: Job Search Skills
– Course 06: Effective Communication Skills for Professionals
– Course 07: Boost Your Confidence, Assertiveness
– Course 08: Body Language Secrets
– Course 09: Coaching and Mentoring
– Course 10: Presentation Skills – Present like a Pro
– Course 11: Public Speaking Course
– Course 12: Project Management Training
– Course 13: Leadership & Management
– Course 14: Negotiation and Agreement Training
– Course 15: Workplace Equality & Diversity
– Course 16: Professional Development and Personal Well-being
– Course 17: Emotional Intelligence and Human Behaviour
– Course 18: Time Management: Step By Step Training
– Course 19: Cross-Cultural Awareness
– Course 20: Productivity Boosting
– Course 21: Critical Thinking & Problem Solving
– Course 22: Perfect LinkedIn Profile Creation
– Course 23: Resume Writing Skills & Job Search With LinkedIn
– Course 24: Email Writing
– Course 25: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!

Skill Up

IT Cyber Security Engineer – Job Ready Programme

Programme With Certification

Programme Without Certification

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'>Explainer Video:

<iframe width="560" height="315" src="https://www.youtube.com/embed/VQoRbCSm_0s?si=pTTAJBNdO9vq1joy" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;"></iframe>

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'> If you&#39;re familiar with OBS Studio, you&#39;re already aware of its incredible capabilities for effortless video creation.

For those who haven&#39;t yet discovered it, it&#39;s worth exploring.

OBS Studio, a completely FREE software, empowers you to craft and record videos in a matter of minutes.

Benefits of attending this workshop:

By the end of this workshop, you will be able to effortlessly capture your video while seamlessly integrating animated text and images with just a click. Capture your screen, zoom in on specific elements, and even play videos while recording your content.

Say goodbye to the hassle of editing and filming separate segments. Simply set it up, hit the record button, and deliver your video.

We&#39;re hosting exclusive, interactive training sessions on this fantastic product throughout the year. This unique format allows you to ask questions as we progress through the course material.



Start creating videos for your business using OBS Studio, it&#39;s easier than you think.

Explainer Video:


If you're familiar with OBS Studio, you're already aware of its incredible capabilities for effortless video creation.
For those who haven't yet discovered it, it's worth exploring.
OBS Studio, a completely FREE software, empowers you to craft and record videos in a matter of minutes.
Benefits of attending this workshop:
By the end of this workshop, you will be able to effortlessly capture your video while seamlessly integrating animated text and images with just a click. Capture your screen, zoom in on specific elements, and even play videos while recording your content.
Say goodbye to the hassle of editing and filming separate segments. Simply set it up, hit the record button, and deliver your video.
We're hosting exclusive, interactive training sessions on this fantastic product throughout the year. This unique format allows you to ask questions as we progress through the course material.
Start creating videos for your business using OBS Studio, it's easier than you think.

Clockwork Eye Video

Video

Video Marketing

Video Creation

Mobile Video Production

Video Design

Video Production

Video Editing

Video & Mobile Marketing

Learn how to create video content easily using this FREE to use software. Create videos for your business and start improving your marketing. This interactive workshop allows you to ask questions as we progress through the course material.

Creating Videos With OBS Studio (Interactive Workshop)

London

<div>
	 <h5>Excel Macros and VBA Course summary</h5>
	 </div>
	 <div></div>
	 
				 
				 For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	 

				 
				 
				 
	 <div>
	 <div>
	 <h5>Excel Macros and VBA Course Description</h5>
	 </div>
	 <div></div>
	 
	 
					 
					 
					 
	 

	 		 Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

						 Setting Excel Macro Options
						 Record and Run Simple Macros
						 Assign Macros to the Quick Access Toolbar

					 Introduction to the Excel VBA Editor

					 Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						 Starting the Visual Basic Editor
						 Using the Project Explorer
						 Using the Properties Window
 

					 Creating Procedures and Functions

					 Create simple macro procedures in code that use variable to store data and communicate with the user

						 Creating Sub and Function Procedures
						 Declare and Use Variables
						 Displaying Message to the User
						 Getting Input from the User

					 Controlling Program Flow

					 Using decision making and looping structures to control the way your program works

						 Using the IF Statement
						 Using the Select Case Statement
						 Using For Next Loops
						 Using Do Loops
						 Using For Next Loops
			 

					 Interacting with the spreadsheet :

						 Referencing Cells and Ranges
						 Gathering Cell and Range Information
						 Using the Offset Method
						 Using With Blocks
						 Referencing Workbooks and Worksheets
						 Updating values in the spreadsheet 

					 Functions

						 Using standard Excel functions in VBA
						 Creating new custom functions
						 Calling functions and sub procedures

					 User Forms

						 Basic design and display
						 Getting information via forms and update cells
					

					 Practical project and examples
					 
					
			 
			<h4>Other Excel Courses</h4>
			 
 
 
 
 
	 </div>
	 <div id="cincluded">
	 <div>
	 <h5>What is included in the Excel VBA Courses:</h5>
	 </div>
	 <div>
	 <ul>
	 <li>Excel VBA Course Certificate on completion </li>
	 <li>Excel VBA Course notes</li>
	 <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	 
	 <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	 <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	 </ul>
	 </div>
	 </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

PCWorkshops

Visual Basic

Access VBA

Microsoft Excel

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

General admission

This course meets and exceeds the Maryland requirement for the security officer course of 12 hours. The course is taught over 2 days, 6 hours per day for the day course or 3 days, 4 hours per day for the night course. In this course, you will learn the required curriculum for security officers prescribed by the Maryland Police and Corrections Training Commission. Once you purchase this course, it may not be canceled.  You can request another later scheduled date if a conflict arises.

MDSPOSA & USTASC TRAINING PORTAL

Maryland Security Officer Initial & Renewal Course

Droitwich Spa

Southampton

Portsmouth

Rotherham

Manchester

Leeds

Newport

Milton Keynes 

Dartford

Paisley

Derby

Birmingham

Luton

Hull

Northampton

Berkshire

Bedford

Liverpool 

Swansea

Essex

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.


8625 Courses

The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Belfast

By Mangates

The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Arbroath

By Mangates

Conflict Management 1 Day Training in Bath

By Mangates

Conflict Management 1 Day Training in High Wycombe

By Mangates

Conflict Management 1 Day Training in Exeter

By Mangates

Conflict Management 1 Day Training in Dundee

By Mangates

Conflict Management 1 Day Training in Coventry

By Mangates

Conflict Management 1 Day Training in Chelmsford

By Mangates

Conflict Management 1 Day Training in Peterborough

By Mangates

Conflict Management 1 Day Training in Nottingham

By Mangates

Search By Location