Name: Negotiation Skills - Professional 1 Day Workshop in St Andrews
Price: 595 GBP
Availability: InStock

Wrexham

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

This course focuses on effective negotiation techniques to be successful in different situations and with people holding different levels of power. The course evaluates how negotiations impact the organizations and ourselves. Reflect on the different outcomes that can be achieved through negotiation and understand which outcomes are acceptable for the intended objectives. Finally participants reflect on the influencing process and how one can achieve things without having the authority or power. 

Each module has been carefully selected based on the intake and skills gaps of the specific audience. After a brief introduction, participants are given 1 to 2 minutes to introduce themselves, practicing their presentation and communication skills (if the intake has included the requested video, this introduction will only be 1 minute). 

Learning Objectives:

At the end of this course, you will be able to:
Define negotiation and influencing stages and how to do so effectively. 
Understand different aspects of negotiating: persuasion, manipulation, assertiveness, rationalization, and active listening. 
Understand individuals and organizations (attitude, behavior and culture). What each party expects, dealing with emotions, and resistance. 
Power play: who is in control and how to change it – tactics and coordination of power. The importance of knowledge.
Understand communication strategies, effectiveness in communicating, verbal and nonverbal 
Orchestrating a plan: positioning, anticipating problems, managing conflicts, and  approaching others for help. 
Understand interpersonal skills: importance of self-awareness, adapting expectations, and resilience. 
Understand results: risk assessment, damage control, keeping good relationships, win-win outcomes. 
Understand how to use BAPNA, ZOPA, negotiation canvas and other tools and strategies.
Understand how communication and presentation skills empower your negotiation abilities. 

Agenda:

Before We Begin
Welcome/Introductions
Purpose/Inspiration
Course Dynamics
Self Evaluation on Basic Negotiation Skills Knowledge - Class Discussion

Negotiation Canvas
Understanding the Methodology
Think, Feel, See, Hear, Say and Do
Giving and Taking
Points of Interest
Plan B (Key Arguments and Drawbacks)

BATNA and ZOPA
BATNA - Best Alternative to a Negotiated Agreement Intro
Example/Role play: Selling a Car
ZOPA - Zone of Possible Agreement or "bargaining range” Intro
Example/Role Play: Overcoming a Negative Bargaining Zone

Evaluating Success
Defining Negotiation Success
Criteria to Evaluate/Measure Success and Effectiveness
Exercise/Role Play: Hand Shaking
Maintaining a Continued Positive Relationship

Influence and persuasion 
Definitions
General Overview
Positive and Negative Ways to Influence
Open Discussion: Sun vs Wind Tale 
Video: Perception and Persuasion
Video: The Science of Persuasion

Introduction to Communication and Presentation skills
Communication Skills
Exercise/Role Play: Connecting Strangers
Presentation Skills
Exercise/Role Play: Words Clearly Spoken and Silence
Video TED: How to Sound Smart - View and Discuss

Conclusions
Wrap Up
Self Assessment GAP
Feedback Form
Closing Remarks

Mangates

Negotiation Skills - Professional 1 Day Workshop in Wrexham

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Stirling

Negotiation Skills - Professional 1 Day Workshop in Stirling

Stoke-on-Trent

Negotiation Skills - Professional 1 Day Workshop in Stoke-on-Trent

Portree

Negotiation Skills - Professional 1 Day Workshop in Portree

Portsmouth

Negotiation Skills - Professional 1 Day Workshop in Portsmouth

Preston

Negotiation Skills - Professional 1 Day Workshop in Preston

Reading

Negotiation Skills - Professional 1 Day Workshop in Reading

Slough

Negotiation Skills - Professional 1 Day Workshop in Slough

Solihull

Negotiation Skills - Professional 1 Day Workshop in Solihull

St Andrews

Negotiation Skills - Professional 1 Day Workshop in St Andrews 

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. In this course, you will learn the required curriculum for security officers prescribed by the Maryland Police and Corrections Training Commission. 

MDSPOSA & USTASC TRAINING PORTAL

Maryland Security Officer Initial & Renewal Course

General Admission

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)

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

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)

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 

Ninety minute webinar on Rally Navigation covering maps and plotting route instructions on to the map. Ideal for competitors on events such as HRCR Clubmans Championship, 12 Cars or Rally of the Tests

Ninety minute webinar on Rally Navigation covering maps and plotting route instructions on to the map. Ideal for competitors on events such as HRCR Clubmans Championship, 12 Cars or Rally of the Tests

Rally Navigation Training Services

Sports & Fitness

Rally Navigation Training Webinar on Maps and Route Plotting, cover common techniques and lots of hints and tips.

Rally Navigation - Maps and Route Plotting

Free Webinar: Master Your Smartphone Settings for Video CreationAre you a small business owner looking to enhance your visibility with professional videos?Join our free webinar to learn how to master the generic settings on any smartphone to create high-quality content.What You&#39;ll Learn:Camera Settings: Optimise resolution, frame rate, and focus.General Tips: Maximize your smartphone&#39;s built-in features for video creation.Why Attend?Practical, step-by-step guidance tailored for beginners.Expert insights from video production professionals.Interactive Q&amp;A to address your specific questions.Who Should Attend?Small business owners who want to improve their online presence and increase their visibility and sales.Entrepreneurs interested in video marketing.Register now &amp; unlock the full potential of your smartphone for video marketing and elevate your business visibility!

Free Webinar: Understand Your Smartphone Video Settings
Are you a small business owner looking to enhance your visibility with professional videos?
Join our free webinar to learn how to master the generic settings on any smartphone to create high-quality content.
What You'll Learn:
Camera Settings: Optimise resolution, frame rate, and focus.
General Tips: Maximize your smartphone's built-in features for video creation.
Why Attend?
Practical, step-by-step guidance tailored for beginners.
Expert insights from video production professionals.
Interactive Q&A to address your specific questions.
Who Should Attend?
Small business owners who want to improve their online presence and increase their visibility and sales.
Entrepreneurs interested in video marketing.
Register now & unlock the full potential of your smartphone for video marketing and elevate your business visibility!

Clockwork Eye Video

Photography & Video

Video

Video Marketing

Video Creation

Mobile Video Production

Film & Video

Video Production

Join our free webinar to learn how to optimise the generic settings on any smartphone to create high-quality videos. Perfect for small business owners and entrepreneurs looking to boost their online presence with professional video content.

Smartphone Video Settings Explained (FREE Webinar)

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

Video Design

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:






63382 Courses

Negotiation Skills - Professional 1 Day Workshop in Wrexham

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Stirling

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Stoke-on-Trent

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Portree

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Portsmouth

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Preston

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Reading

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Slough

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Solihull

By Mangates

Negotiation Skills - Professional 1 Day Workshop in St Andrews

By Mangates

Search By Location