Name: The Ultimate Guide to Event Planning - 1 Day Workshop in St Asaph
Price: 595 GBP
Availability: InStock

Dundee

<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:
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.

Mangates

Conflict Management

Conflict Management 1 Day Training in Dundee

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Coventry

Conflict Management 1 Day Training in Coventry

Chelmsford

Conflict Management 1 Day Training in Chelmsford

St Asaph

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:
Personal time management skills are essential for professional success in any workplace. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis - stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact to them and their organization.
The Time Management workshop will cover strategies to help participants learn these crucial strategies. You will be given a skill set that includes personal motivation, delegation skills, organization tools, and crisis management. We"ll cover all this and more during this workshop.
Learning Objectives:
After completing this course, the learners will be able to: 
Explore why time management issues arise
Improve ability to plan and prioritize work
The importance of setting clear goals
Minimize wasted time and distractions in the workplace
How to avoid being deflected from your priorities
Self-motivation as a time management tool
Dealing with unexpected events that steal time
Tools and techniques for effective delegation
How to say 'no' to some 'now' requests
Agenda:
Module One: Goal Setting
The Three P"s
S.M.A.R.T. Goals
Prioritizing Your Goals
Visualization
Module Two: Prioritizing Your Time
The 80/20 Rule
The Urgent Versus Important Matrix
Assertiveness
Module Three: Planning Wisely
Creating Your Productivity Journal
Maximizing the Power of Your Productivity Journal
The Glass Jar: Rocks, Pebbles, Sand, and Water
Chunck, Block, and Tackle
Ready, Fire, Aim!
Module Four: Tackling Procrastination
Why We Procrastinate
Nine Ways to Overcome Procrastination
Eat That Frog!
Module Five: Crisis Management
When the Storm Hits
Creating a Plan
Executing the Plan
Lessons Learned
Module Six: Organizing Your Workspace
Declutter
Managing Workflow
Dealing with Email
Using Calendars
Module Seven: Delegating Made Easy
When to Delegate
To Whom Should You Delegate?
How Should You Delegate
Keeping Control
The Importance of Full Acceptance
Module Eight: Setting a Ritual
What is a Ritual?
Ritualizing Sleep, Meals, Exercise
Examples of Rituals
Using Rituals to Maximize Time
Module Nine: Meeting Management
Deciding if a Meeting is Necessary
Using the PAT Approach
Building the Agenda
Keeping Things on Track
Making Sure the Meeting Was Worthwhile
Module Ten: Alternatives to Meetings
Instant Messaging and Chat Rooms
Teleconferencing
Email Lists and Online Groups
Collaborating Applications
Module Eleven: Wrapping Up
Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations
Target Audience:
Anybody who is interested in Learning Time Management Skills

Time Management 1 Day Training in St Asaph

Maidstone

Time Management 1 Day Training in Maidstone

Liverpool

Time Management 1 Day Training in Liverpool

Worcester

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:
Events do not just happen, they take time to plan, develop, and create. This workshop is designed to give your participants the tools needed to host a great event. They will touch on planning and administrative techniques that will give them the confidence to run an engaging event that will leave a positive and lasting impression on each attendee.
With our Event Planning workshop y,our participants will explore ways to work with vendors, security, technicians, and wait staff. They will touch on different event types such as awards ceremonies, charity events, and business conferences. By utilizing the correct skill set you will be provided the details to pull off a successful event.
Target Audience:
Anybody who is interested in learning Event Planning Skills
Learning Objectives:
By the end of the course, participants will be able to understand:
Types of Events
Brainstorming
Types of Entertainment
Support Staff
Technical Staff
Vendors
Finalize the Plan
Administrative Tasks
Get Organized
Post Event Activities
Wrapping Up
Agenda:
Module One: Types of Events
Awards
Charity
Conferences and Seminar
Holiday
Case Study
Module One: Review Questions
Module Two: Brainstorming
Determine the Event’s Purpose
Determine a Theme
Write Down & Review Ideas
Determine a Date
Case Study
Module Two: Review Questions
Module Three: Types of Entertainment
Games
Activities
Speakers
Performers
Case Study
Module Three: Review Questions
Module Four: Support Staff
Security
Valet
Wait Staff
Clean up Crew
Case Study
Module Four: Review Questions
Module Five: Technical Staff
Visual Technician (lighting)
Media Technician (website, Facebook, etc.)
Audio Technician (Sound)
Specialized Electrical Equipment Technician (for performers)
Case Study
Module Five: Review Questions
Module Six: Vendors
Food
Equipment
Decorations and Furnishing
Photography/ Video
Case Study
Module Six: Review Questions
Module Seven: Finalize the Plan
Venue
Registration
Entertainment
Cuisine and Decor
Case Study
Module Seven: Review Questions
Module Eight: Administrative Tasks
Create a Budget
Branding and Marketing
Insurance and Permits
Contracts (for event staff, entertainment, rentals, and vendors)
Case Study
Module Eight: Review Questions
Module Nine: Get Organized
Form a Team
Timeline
Checklists
Backup Plans
Case Study
Module Nine: Review Questions
Module Ten: Post Event Activities
Survey
Share Media (photos and video)
Send Thank you Notes
Start planning the Next Event!
Case Study
Module Ten: Review Questions
Module Eleven: Wrapping Up
Words From The Wise
Review Of The Parking Lot
Lessons Learned
Recommended Reading
Completion Of Action Plans And Evaluations

Event Planning 1 Day Training in Worcester

The Ultimate Guide to Event Planning - 1 Day Workshop in Worcester

Watford

The Ultimate Guide to Event Planning - 1 Day Workshop in Watford

Tonbridge

Event Planning 1 Day Training in Tonbridge

The Ultimate Guide to Event Planning - 1 Day Workshop in Tonbridge

Event Planning 1 Day Training in St Asaph

The Ultimate Guide to Event Planning - 1 Day Workshop in St Asaph

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

General Admission

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

Peterborough

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.


Advanced Phlebotomy - Skills & Techniques (GPT005)

This two-day course is a must for anyone who is considering or already working in a role with supervisory responsibilities. This course provides an understanding of health, safety, welfare, and environmental issues. It highlights legal responsibilities and the need to promote health and safety to supervise effectively.
It is endorsed by Build UK as the standard training for all supervisors working on Build UK sites.
Aims
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your supervisory role. To help you fulfil your responsibilities regarding health, safety, welfare, and the environment. To help you implement new guidance and industry best practice affected by changes.
Course Content
• Health and safety law and how it will apply to supervisors.
• Your supervisory responsibilities in controlling site safety.
• Risk assessments and the need for method statements.
• Effective site inductions, toolbox talks and method statement briefings.
• Monitoring site activities effectively.
• Timely intervention when bad practice is identified.
Prerequisites
This course is for you if you are considering, or already have, supervisory responsibilities.
Assessment
At the end of this course, all delegates will have a clear understanding of controlling health and safety on site from a supervisor’s role.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all supervisors.
To remain certified in this area, you will need to take a refresher course before the expiry date on your certificate, otherwise the full course will need to be retaken.
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

Site Supervisor Training Scheme (SSSTS) - 2 Day Course

Bournemouth

Our Virtual (via Zoom) course provide the same high-quality tuition as our classroom-based sessions. Quarterly meetings will take place at the Academy



Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices.

Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse.


Discover the exciting world of dental nursing and be a part of a growing field that offers endless opportunities for growth and development.
How will you learn?
In addition to our traditional class-based tuition, we also offer Virtual (via Zoom) Learning courses to cater to different learning preferences. Our Virtual Learning courses provide the same high-quality tuition as our classroom-based sessions. To participate, you will need a laptop, PC, smart phone or tablet with a built-in or external camera and microphone. From the comfort of your own home, you will have the opportunity to communicate with your tutor and classmates through video chat, using your phone or computer camera. This allows for seamless interaction, discussions, and collaborative learning.

Quarterly meetings at the Academy
To ensure a well-rounded learning experience, you will be required to attend face-to-face lessons at the Academy on a quarterly basis, which means every three months. These sessions serve several important purposes:

Practical Units: Some aspects of the course require hands-on practical training. The face-to-face lessons will cover these practical units, allowing you to gain valuable experience and apply the knowledge you have acquired during the virtual learning sessions.

Tests and Mock Exams: These assessments are important for evaluating your progress, identifying areas for improvement, and preparing you for the final exams. The Academy will provide a controlled and supervised environment to ensure the integrity and fairness of these assessments.
Attending quarterly face-to-face lessons provides a balanced approach to your learning journey. It combines the convenience and flexibility of virtual learning with the benefits of in-person interactions, practical training, and assessments. By participating in these sessions, you will have the opportunity to reinforce your knowledge, receive personalized feedback, and build a stronger connection with your tutor and classmates.
The Academy is dedicated to supporting your growth and success in dental nursing field, and the face-to-face lessons are an integral part of that commitment.



Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others.


The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry.
Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied.

Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care.

Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field.
No previous experience required – we will teach you from A to Z.
Do you need a job?
Yes, you will have 3 months’ time from the start of your course to find a placement.
The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employee in case you need it.
The course is ideal for you if:
You are looking for a qualification that leads to employment
You intend to participate within dentistry and make a positive contribution to the dental health
You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety
You enjoy interacting with multidisciplinary team and different people


The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations!
Free services– workshops, mock exams, eRoE marking and internal moderation.


Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 14 years and looking to recruit more Trainee Dental Nurses.
Working together – At our Dental Department, we prioritise working together with our learners every step of the way. We firmly believe in providing unwavering support, equipping you with the necessary tools, skills, and assistance to ensure your success. We take immense pride in the achievements of our students, with a long list of graduates boasting remarkable success stories. Our commitment to your success serves as the foundation for our own accomplishments
What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work. Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a.
When are the exams?
There are two exams:
1. Multiple choice theory exam. November and March.
2. Practical exam. January and June. 
Record of Experience (eROE)
To be eligible to sit your first exam, you have to complete your electronic Record of Experience (eROE). The eROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. 
London Waterloo Academy supports Mouth Cancer Research Foundation and encouraging learners to raise the awareness and participate in annual 10k walk.



Study mode – virtual (via Zoom) live stream lessons combined with a quarterly meetings Saturday/Sunday at the Academy
Duration – 1 year (part time)
Virtual (via Zoom) classes – once a week
Quarterly meetings at the Academy – date are discussed with the group in advance
Next Intake/start dates (please choose one for your course to start):
21 September 2024, Saturday classes from 9am to 11am
Registration fee – £300 (includes: administration, workshops, mock exams, RoE marking, internal moderation of RoE)
Tuition Fees – £1,400 (we offer payment plan, and accept instalments)
Exam fee – £510 will be charged at the point of candidate registration with NEBDN
One day introduction course – for those who are considering/not sure whether to step up into the Dental Industry £50.00
Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
Office location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk))

8625 Courses

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

Time Management 1 Day Training in St Asaph

By Mangates

Time Management 1 Day Training in Maidstone

By Mangates

Time Management 1 Day Training in Liverpool

By Mangates

The Ultimate Guide to Event Planning - 1 Day Workshop in Worcester

By Mangates

The Ultimate Guide to Event Planning - 1 Day Workshop in Watford

By Mangates

The Ultimate Guide to Event Planning - 1 Day Workshop in Tonbridge

By Mangates

The Ultimate Guide to Event Planning - 1 Day Workshop in St Asaph

By Mangates

Search By Location