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

Elgin

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

Mangates

Time Management 1 Day Training in Elgin

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Dumfries

Time Management 1 Day Training in Dumfries

Darlington

Time Management 1 Day Training in Darlington

Chorley

Time Management 1 Day Training in Chorley

Perth, UK

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 Perth, UK

The Ultimate Guide to Event Planning - 1 Day Workshop in Perth, UK

Norwich

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

Luton

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

Gloucester

Event Planning 1 Day Training in Gloucester

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

Cork

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

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

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

Chelmsford

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

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.


59132 Courses

Time Management 1 Day Training in Elgin

By Mangates

Time Management 1 Day Training in Dumfries

By Mangates

Time Management 1 Day Training in Darlington

By Mangates

Time Management 1 Day Training in Chorley

By Mangates

The Ultimate Guide to Event Planning - 1 Day Workshop in Perth, UK

By Mangates

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

By Mangates

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

By Mangates

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

By Mangates

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

By Mangates

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

By Mangates

Search By Location