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

Bournemouth

<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
Lunch and Beverages are included in a classroom session
Course Delivery: Classroom | Virtual Live
Course Overview:
Communication Skills are the most highly valued skills in today’s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.
Communication Skills intensive is a cutting edge training program designed to help today’s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.
You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It’s never too late to work on your communication skills and by doing so improve your quality of life.
Learning Objectives:
Script yourself with clear, compelling and well-developed messages that reflect your thinking .
Speak with vision and a logical structure that drives home your points.
Answer questions confidently.
Develop professional relationships and networks.
Communicate with empathy and compassion .
Inspire people by appealing to their emotions.
Move from an informational to an inspirational and action oriented style when creating and delivering presentations.
Integrate effective slides into your presentations.
Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.
Target Audience:
There is no Eligibility Criteria for this training, anyone can attend this training
Agenda:
The Science of Effective Human Communication
Frames of Business and Communication
Principles and Strategies for Effective Business Conversations
Art of Giving and Receiving Feedback
How to Listen Effectively and Accurately
Science of Body Language
How to look confident and charismatic
Business Presentation Skills and Strategies
Powerpoint Best Practices
Principles and Techniques for Effective Written Communication
How to write clear, concise and fast at the same time

Mangates

Communication

Coaching Skills

Communication Skills 1 Day Training in Bournemouth











The sale ends 10 days before the event starts.

Early Bird Fee

The sale ends 5 days before the event starts.

Standard Fee

Teesside

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:
Communication Skills are the most highly valued skills in today’s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.
Communication Skills intensive is a cutting edge training program designed to help today’s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.
You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It’s never too late to work on your communication skills and by doing so improve your quality of life.
Learning Objectives:
Script yourself with clear, compelling and well-developed messages that reflect your thinking .
Speak with vision and a logical structure that drives home your points.
Answer questions confidently.
Develop professional relationships and networks.
Communicate with empathy and compassion .
Inspire people by appealing to their emotions.
Move from an informational to an inspirational and action oriented style when creating and delivering presentations.
Integrate effective slides into your presentations.
Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.
Target Audience:
There is no Eligibility Criteria for this training, anyone can attend this training
Agenda:
The Science of Effective Human Communication
Frames of Business and Communication
Principles and Strategies for Effective Business Conversations
Art of Giving and Receiving Feedback
How to Listen Effectively and Accurately
Science of Body Language
How to look confident and charismatic
Business Presentation Skills and Strategies
Powerpoint Best Practices
Principles and Techniques for Effective Written Communication
How to write clear, concise and fast at the same time

Communication Skills 1 Day Training in Teesside























































































Plymouth

Communication Skills 1 Day Training in Plymouth







































































Paisley

Communication Skills 1 Day Training in Paisley




































































Hinckley

Communication Skills 1 Day Training in Hinckley



















































Coventry

Communication Skills 1 Day Training in Coventry































Swansea

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

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

Oxford

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

Newport

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

Manchester 

Event Planning 1 Day Training in Manchester

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

Stratford

The Temporary Works Supervisor course will provide you with knowledge of the role. You will also gain a good understanding of risk management on a temporary works site.
Course Objectives:
By the end of the course, the delegate will gain knowledge of:
Have gained an understanding of the importance of cooperation and teamwork on a temporary works site
Understand the legal duties of the role
Have a stronger awareness of risk management on-site as well as the roles of a supervisor and their fellow employees on site
Leave the course with an understanding of the “4C’s”, Communication, Cooperation, Coordination and Competency
Course Content:
Different groups and types of Temporary Works
BS5975:2019
CDM Regulations
Legislation and Codes of Practice
Temporary Works Register, Design Brief and Design
Case studies, policy and procedures, Standard solutions and permitted drawings
Risk assessments, method statements
Safe systems of work
The roles and duties of a Temporary Works Supervisor
Assessment:
To successfully complete the course, you will need to get 72% or above in the final exam. The trainer encourages the delegates to be interactive and involved throughout the training.
Certificate:
The certificate for this course is valid for 5 years.
Instructions
Please note all Temporary Works Supervisor 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

Temporary Works Supervisor (TWS)

General Admission

Chelmsford

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.

Site Supervisor Training Scheme (SSSTS) Refresher

Mental Health First Aid (MHFA&reg;) is an internationally recognised training course, designed to teach people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We offer both Adult and Youth MHFA England accredited courses.The two-day Youth MHFAider&reg; course is tailored for people who teach, work, live with, support and care for young people aged 8 to 18. This mental health first aid course can be attended by anyone from age 16 upwards. A lot of the education settings we work with have now trained a number of Youth MHFAider&reg;&rsquo;s to support their colleagues as part of their whole-school/college approach to mental health and wellbeing.Each and every MHFA course is delivered by a qualified and quality assured instructor and at the end of the course the trainee will be fully qualified as a Youth/Adult MHFAider&reg;.<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a>

We offer both Adult and Youth MHFA England accredited courses. Mental Health First Aid (MHFA®) is an internationally recognised training course, designed to teach people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. 
The two-day Youth MHFAider® course is tailored for people who teach, work, live with, support and care for young people aged 8 to 18. This mental health first aid course can be attended by anyone from age 16 upwards. A lot of the education settings we work with have now trained a number of Youth MHFAider®’s to support their colleagues as part of their whole-school/college approach to mental health and wellbeing.
Each and every MHFA course is delivered by a qualified and quality assured instructor and at the end of the course the trainee will be fully qualified as a Youth/Adult MHFAider®.
View all testimonials

Brightcore Consultancy

Mental Health

Children Mental Health

Accredited Mental Health First Aid

The two-day Youth MHFAider® course is tailored for people who teach, work, live with, support and care for young people aged 8 to 18. This mental health first aid course can be attended by anyone from age 16 upwards.

MHFA® Youth Mental Health First Aid Two-Day Course 

<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">

<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/I-lmMCXyzA8?si=ppw5z8XkrJwaocGt" 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";'> Empower Your Business with Video Editing Fundamentals

In today&#39;s digital landscape, video has become an indispensable tool for businesses of all sizes to reach a wider audience, build brand awareness, and drive sales. Our comprehensive beginner&#39;s video editing workshop has been designed specifically for business owners who want to get started with using video in their marketing.

What You&#39;ll Learn:

<ul fr-original-style="" style="box-sizing: border-box;">
<li value="1" fr-original-style="" style="box-sizing: border-box;">The Basics of Video Editing: Gain a solid understanding of essential video editing concepts, including terminology, editing tools and techniques, and software navigation.</li>
<li value="2" fr-original-style="" style="box-sizing: border-box;">Creating Compelling Video Content:&nbsp;Discover the secrets to producing engaging videos that capture attention, communicate your message effectively, and align with your brand identity.</li>
<li value="3" fr-original-style="" style="box-sizing: border-box;">Mastering Editing Techniques:&nbsp;Learn to use simple techniques that will make editing videos easier.</li>
</ul>

Workshop Benefits:

<ul fr-original-style="" style="box-sizing: border-box;">
<li value="1" fr-original-style="" style="box-sizing: border-box;">Gain the skills to create professional-looking videos without prior editing experience.</li>
<li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to effectively use video editing software to produce high-quality content.</li>
<li value="3" fr-original-style="" style="box-sizing: border-box;">Discover storytelling techniques and editing strategies to create engaging videos that resonate with your target audience.</li>
<li value="4" fr-original-style="" style="box-sizing: border-box;">Enhance your marketing efforts with compelling video content that drives brand awareness and sales.</li>
</ul>

Who Should Take This Workshop:

This workshop is ideal for business owners, entrepreneurs, and marketing professionals who want to incorporate video into their marketing strategies but lack prior editing experience.

Workshop Prerequisites:

<ul fr-original-style="" style="box-sizing: border-box;">
<li value="1" fr-original-style="" style="box-sizing: border-box;">A basic understanding of computers and the internet</li>
<li value="2" fr-original-style="" style="box-sizing: border-box;">A willingness to learn and practice new skills</li>
</ul>

Workshop Format:

This workshop is delivered online on Zoom.

Workshop Duration:

This workshop has been broken down into three sessions and runs over three weeks. Each session is run on a Friday from 12 to 2 PM so there is no information overload.

Don&#39;t miss out on this opportunity to empower your business with the power of video editing. Enrol in our beginner&#39;s video editing workshop today and start creating captivating videos that drive engagement, boost conversions, and elevate your business to new heights of success.
</div></div></div></div>

Explainer Video:


What You'll Learn:
The Basics of Video Editing: Gain a solid understanding of essential video editing concepts, including terminology, editing tools and techniques, and software navigation.
Creating Compelling Video Content: Discover the secrets to producing engaging videos that capture attention, communicate your message effectively, and align with your brand identity.
Mastering Editing Techniques: Learn to use simple techniques that will make editing videos easier.
Workshop Benefits:
Gain the skills to create professional-looking videos without prior editing experience.
Learn how to effectively use video editing software to produce high-quality content.
Discover storytelling techniques and editing strategies to create engaging videos that resonate with your target audience.
Enhance your marketing efforts with compelling video content that drives brand awareness and sales.
Who Should Take This Workshop:
This workshop is ideal for business owners, entrepreneurs, and marketing professionals who want to incorporate video into their marketing strategies but lack prior editing experience.
Workshop Prerequisites:
A basic understanding of computers and the internet
A willingness to learn and practice new skills
Workshop Format:
This workshop is delivered online on Zoom.
Workshop Duration:
This workshop has been broken down into three sessions and runs over three weeks. Each session is run on a Friday from 12 to 2 PM so there is no information overload.
Don't miss out on this opportunity to empower your business with the power of video editing. Enrol in our beginner's video editing workshop today and start creating captivating videos that drive engagement, boost conversions, and elevate your business to new heights of success.

Clockwork Eye Video

Video

Video Marketing

Video Creation

Mobile Video Production

Video Design

Video Production

Video Editing

Video & Mobile Marketing

This video editing workshop equips you with the essential skills to create professional-looking videos for your business, even if you've never edited before.

Beginner's Guide to Video Editing (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

Personal development groups for practitioners with B&aacute;rbara GodoyA playground for therapists to expand our perception to metaphor, as a way to connect directly with the experience of the other, guided by folklore and fairytales. "Supportive, thought-provoking, emancipating, grounding"<table style="width: 100%; border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;" fr-original-style="width: 100%;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td style="width: 50%; min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);" fr-original-style="width: 50.0000%;">Tuesday Evenings Group&nbsp;6 pm to 7.15 pm&nbsp;(UK Time)</td><td style="width: 50%; min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);" fr-original-style="width: 50.0000%;">Friday Lunchtime Group 12.30 pm to 1.45 pm(UK time)</td></tr><tr fr-original-style="" style="box-sizing: border-box;"><td style="width: 50%; min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);" fr-original-style="width: 50.0000%;">Term One: 21 and 28 January 4, 11, 18 and 25 February 4, 11, 18 and 25 MarchTerm Two: 6, 13, 20 and 27 May 3, 10, 17 and 24 June 1 and 8 JulyTerm Three: 23 and 30 September 7, 14, 21 and 28 October 4, 11, 18 and 25 November</td><td style="width: 50%; min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);" fr-original-style="width: 50.0000%;">Term One: 24 and 31 January 7, 14, 21, 28 February 7, 14, 21 and 28 MarchTerm Two: 2, 9, 16, 23 and 30 May 6, 13, 20 and 27 June 4 JulyTerm Three: 26 September 3, 10, 17, 24 and 31 October 7, 14, 21 and 28 November</td></tr></tbody></table> Venue: Online (Zoom) Fee:&nbsp;&pound;350&nbsp;per term or&nbsp;&pound;900&nbsp;the whole yearB&aacute;rbara Godoy&nbsp;M.A., Adv. Dip. Exi. Psy. Existential Psychotherapist Group Leader, Counsellour, Lecturer and Supervisor, MBACP &amp; UKCP accredited, SEA Professional Member, Director of Therapy Harley StreetB&aacute;rbara&rsquo;s academic contributions in London since 2008 include lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent&rsquo;s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. B&aacute;rbara has facilitated and designed therapeutic Group Work since 1997. She brought her earliest workshop: &ldquo;Experiences&rdquo; to large groups in The Netherlands, Italy, France, UK and Argentina. These awareness-intensive processes are a legacy of the human potential movement (HPM) of the 1960s, with techniques such as AUM Meditation Marathons, Psychodrama, Bioenergetics and Primal Feelings work. <img src="https://images.cademy.co.uk/d34b3e28-5501-46b2-9009-97ed10d2e273/f0370d38-60f2-46d6-bd42-11b15afedfae/original.jpeg" style="width: 446px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 446px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"> Organized by: <img src="https://images.cademy.co.uk/d34b3e28-5501-46b2-9009-97ed10d2e273/376c7e35-cd6e-46a0-9b64-dee8373e64c4/original.png" style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">

Personal development groups for practitioners with Bárbara Godoy
A playground for therapists to expand our perception to metaphor, as a way to connect directly with the experience of the other, guided by folklore and fairytales. "Supportive, thought-provoking, emancipating, grounding"
Tuesday Evenings Group 6 pm to 7.15 pm 
(UK Time)	Friday Lunchtime Group 12.30 pm to 1.45 pm
(UK time)
Spring Term Phase One - 2025
22 and 29 April
6, 13, 20 and 27 May
3, 10, 17 and 24 June
Autumn Term Phase Two - 2025
23 and 30 September
7, 14, 21 and 28 October
4, 11, 18 and 25 November
Winter Term Phase Three - 2026
20 and 27 January
3, 10, 17 and 24 February
3, 10, 17 and 24 March	Winter Term Phase One - 2025
24 and 31 January
7, 14, 21, 28 February
7, 14, 21 and 28 March
Spring Term Phase Two - 2025
25 April
2, 9, 16, 23 and 30 May
6, 13, 20 and 27 June
Autumn Term Phase Three - 2025
26 September
3, 10, 17, 24 and 31 October
7, 14, 21 and 28 November


Venue: Online (Zoom)
Fee: £350 per term or £900 the whole year
Bárbara Godoy M.A., Adv. Dip. Exi. Psy. Existential Psychotherapist Group Leader, Counsellour, Lecturer and Supervisor, MBACP & UKCP accredited, SEA Professional Member, Director of Therapy Harley StreetBárbara’s academic contributions in London since 2008 include lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent’s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. Bárbara has facilitated and designed therapeutic Group Work since 1997. She brought her earliest workshop: “Experiences” to large groups in The Netherlands, Italy, France, UK and Argentina. These awareness-intensive processes are a legacy of the human potential movement (HPM) of the 1960s, with techniques such as AUM Meditation Marathons, Psychodrama, Bioenergetics and Primal Feelings work.





Organized by:






Therapy Harley Street

Unlocking Our-Selves 2025: "Away With the Fairies"

Full year

One Term

Sixty minute webinar on Rally Regularity Timing covering equipment required, how to keep to time, working out penalties and speed changes, this webinar focuses on styles of regularity that require the use of standard average speed tables. The competitive component of on the public highway historic road rallying, focusing on regularity using average speed tables. Ideal for competitors on events such as HRCR Clubmans Championship or Rally of the Tests

Mastering Regularity Rallying: A 60-Minute Webinar
Elevate your rallying skills with this focused, one-hour webinar designed to boost your confidence in regularity time keeping, essential for competitive historic road rallying on public highways. Dive into the essentials of average speed tables, timing strategies, and control procedures, and gain insider tips for recovering from common mistakes to stay on course. Perfect for competitors aiming to excel in top-tier events like the HERO Rally of the Tests or HRCR Championship rallies, this webinar offers practical insights to enhance your performance. Join us to refine your skills and gain a competitive edge!

Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers

Our Site Management Safety Training Scheme (SMSTS) refresher training courses, available both online and in-person, are designed for managers and individuals in positions of authority who completed their original SMSTS training program less than three years ago.

Aims
Participants will undertake a concise yet equally engaging training program covering all essential aspects of enforcing health and safety codes of practice at construction sites. Topics include in-depth discussions on risk assessments and effective methods for monitoring and managing industry-specific hazards.
Instructions
For online courses labeled “Remote Learning,” a tutor will deliver the training via video call.
All SMSTS courses are delivered and assessed in English. Participants must have a good command of the language to successfully complete the program.
Additional attendee information will be provided via email. Please ensure you check your inbox.


Site Management Safety Training Scheme (SMSTS) Refresher

The Temporary Works Coordinator course will provide you with knowledge of the role. You will also gain a good understanding of risk management on a temporary works site.
Course Objectives:
By the end of the course, the delegate will gain knowledge of:
The need for a temporary works co-ordinator
The day-to-day roles of others involved in the temporary works procedures
Risk assessments and method statements
Best procedures as stated in BS 5975:2019
Course Content:
The content covered by the CITB course includes:
Various groups and types of Temporary Works
Case studies, procedures and policies of Temporary Works
BS5975:2019
CDM Regulations
Legislation and relevant Codes of Practice
Register for Temporary Works, design requirements and checks
Standard solutions and guidance design documents
Temporary works Co-ordinator – job role and responsibilities
Assessment:
To successfully complete the course, you will need to get 72% or above in the final exam. The trainer encourages the delegates to be interactive and involved throughout the training.
Certificate:
The certificate for this course is valid for 5 years.
Instructions
Please note all Temporary Works Coordinator 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.

Temporary Works Coordinator (TWC) - 2 Day Course

Broxburn

C30M01 - Evacuation Alert SystemsCourse content Learners will be introduced to EAS as part of the fire safety solution for tall residential properties. This CPD course provides learners with an understanding of the requirements of BS 5839-1 in relation to, the design, installation, commissioning, and maintenance of EAS.Who should attend?Anyone involved in the management of existing tall residential properties and those specifying or installing EAS e.g., leaseholders, FM providers, service managers, building/property managers, consultants, fire risk assessors, EAS contractors, EAS designers, F&amp;RS. Those attending would benefit from a basic knowledge of FD&amp;FA systems.Content﻿<ul style="color: rgb(63, 77, 90); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Scope and Need for an EAS</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consultation &amp; responsibilities</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System components</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Evacuation alert zones</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">EAD &ndash; sounders &amp; audibility</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Arrangements for disabled people and Siting of EADs</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">EACIE and Power supplies</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Installation and commissioning</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Documentation, certification, and acceptance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Maintenance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Users&rsquo; responsibilities and Logbook</li><li fr-original-style="" style="box-sizing: border-box;">Assessment
</li></ul><img src="https://images.cademy.co.uk/88d338d8-7dc4-4054-bf9e-401495774eee/5293624b-3258-4be0-b61f-1d0469f76c49/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">

C30M01 - Evacuation Alert Systems

Course content
Learners will be introduced to EAS as part of the fire safety solution for tall residential properties. This CPD course provides learners with an understanding of the requirements of BS 5839-1 in relation to, the design, installation, commissioning, and maintenance of EAS.

Who should attend?
Anyone involved in the management of existing tall residential properties and those specifying or installing EAS e.g., leaseholders, FM providers, service managers, building/property managers, consultants, fire risk assessors, EAS contractors, EAS designers, F&RS. Those attending would benefit from a basic knowledge of FD&FA systems.

Content﻿
Scope and Need for an EAS
Consultation & responsibilities
System components
Evacuation alert zones
EAD – sounders & audibility
Arrangements for disabled people and Siting of EADs
EACIE and Power supplies
Installation and commissioning
Documentation, certification, and acceptance
Maintenance
Users’ responsibilities and Logbook
Assessment



Ember Compliance

Fire Evacuation

Professional Development

Engineer

Continuous Professional Development (CPD)

Learners will be introduced to EAS as part of the fire safety solution for tall residential properties. This CPD course provides learners with an understanding of the requirements of BS 5839-1 in relation to, design, installation, commissioning, and maintenance of EAS.

3737 Design courses

Communication Skills 1 Day Training in Bournemouth

By Mangates

Communication Skills 1 Day Training in Teesside

By Mangates

Communication Skills 1 Day Training in Plymouth

By Mangates

Communication Skills 1 Day Training in Paisley

By Mangates

Communication Skills 1 Day Training in Hinckley

By Mangates

Communication Skills 1 Day Training in Coventry

By Mangates

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

By Mangates

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

By Mangates

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

By Mangates

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

By Mangates

Search By Location