Name: Emotional intelligence 1 Day Training in Swansea
Price: 595 GBP
Availability: InStock

Management

Teesside

<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 practical sales skills training has been developed for salespeople or people who are required to sell as part of their role. This course is applicable for both people relatively new to sales as well as those who have a lot of experience as the content is flexible enough to adapt to suit the audience.
If you want your team to exceed sales targets and gain instant results, this sales training is for you!
Course Contents:
The core aim of this sales skills training is to provide you with a set of tools that can be practicably used in your role as salesperson
The skills provided are simply a collection of valuable methods of achieving sales. There are many tips and techniques that will be incredibly useful and will help you personally develop a successful sales approach whilst enhancing your performance.
Course Topics:
The skills have been produced from many year’s experience in sales and have been tried and tested in a business environment.
Introduction, the 80:20 Rule – Why 20% of salespeople produce 80% of the business
The Perfect Salesperson –  What makes a perfect salesperson and how do the participants individually compare? An exercise which helps the participants appreciate that they need to develop further
Goal Setting – Why and how to set personal performance goals. Followed by an exercise on setting these goals
Build Trust – Developing trust and rapport with a prospect and understanding why this is crucial to their success.
Ask the Right Questions – Developing questioning skills and realising that it is often questions that will develop sales rather than a just a good pitch. With example questions
Engage the Customer – Understanding the life time value of a customer, serving them better and ensuring they perceive the value of the relationship
Be Specific – Adapting their approach to suit the individual customer with an activity related to identifying the specific benefits to the customer
Make Your Customer Smarter – Realizing that customers are now more willing to be educated on products and services and often have already researched prior to the sales conversation. How to deal with this with regards the participants specific products/service
Maximize Your Efficiency – Learning from missed sales and developing further skills to overcome this
Catch Yourself Doing it Right – You can learn from good stuff too!
Know Your Products – An in-depth look at specific products and how to educate themselves in order to maximize sales through product knowledge
Develop a Competitive Advantage – A series of questions that will put the participants one step ahead of the competition
Handle Objections – Identifying typical objections and preparing responses to them in order to practice until they are welcomed with open arms. Also includes set techniques to overcome objections
Ask for the Business – Ensuring the participants can spot buying signals and know how to respond to them in order to lead the prospect to close. Specific advice on closing questions
Follow Up After the Sale – Ensuring that the complete sales process is seamless and the participants understand their responsibilities with regard to creating an exceptional customer experience
Apply the Skills in Your Role – A session on ensuring the learning from the session is practically applied in the participant's role.
Course Feature:
At the end of this sales skills training course your participants will be able to:
Explain what sets the best salespeople apart
Follow set personal goals to sales success
Use a series of practical sales skills to increase their selling potential
Practically apply these skills to their sales role
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
Anybody who is interested in learning Practical Sales Skills.

Mangates

Practical Sales Skills 1 Day Workshop in Teesside

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Coventry

Practical Sales Skills 1 Day Workshop in Coventry

Hinckley

Practical Sales Skills 1 Day Workshop in Hinckley

Solihull

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:
Emotional intelligence describes the ability to understand one’s own feelings. It also provides great insight into how emotion influences motivation and behavior. The concept of Emotional Intelligence has been around since the early 20th century, but the term was first introduced by Wayne Payne in 1985.
With our Emotional Intelligence workshop, you will gain a better understanding of self-management and self-awareness. This in turn will give you better insight and control over your actions and emotions. With a greater understanding of emotions, you will experience a positive impact on your professional and personal lives.
Target Audience:
Anybody who is interested in learning Emotional intelligence Skills
Learning Objectives:
Understand the Emotional Intelligence competency framework.
Assess and understand current Emotional Intelligence level.
Understand techniques for being highly positive and energetic.
Understand how emotions can influence thoughts, goals, relationships, decision-making ability, etc.
Understand the importance of high expectations and pressure and how to go through it.
Understand how to be an emotionally strong person, who can handle emotions.
Understand how to be a responsible person, who does not believe in blame/complaint.
Understand techniques to develop your emotional intelligence on the job.
Agenda:
Module One: What is Emotional Intelligence?
Self-Management
Self Awareness
Self-Regulation
Self-Motivation
Empathy
Module Two: Four Skills in Emotional Intelligence
How to Accurately Perceive Emotions
Use Emotions to Facilitate Thinking
Understand Emotional Meanings
Manage Emotions
Module Three: Verbal Communication Skills
Focused Listening
Asking Questions
Communicating with Flexibility and Authenticity
Module Four: Non-Verbal Communication Skills
Body Language
The Signals You Send to Others
It’s Not What You Say, It’s How You Say It
Module Five: Social Management and Responsibility
Benefits of Emotional Intelligence
Articulate your Emotions Using Language.
Module Six: Tools to Regulate Your Emotions
Seeing the Other Side
Self-Management and Self Awareness
Giving in Without Giving Up
Module Seven: Gaining Control
Using Coping Thoughts
Using Relaxation Techniques
Bringing it All Together
Module Eight: Business Practices (I)
Understand Emotions and How to Manage Them in the Workplace
Role of Emotional Intelligence at Work
Disagreeing Constructively
Module Nine: Business Practices (II)
Optimism
Pessimism
The Balance Between Optimism & Pessimism
Module Ten: Making an Impact
Creating a Powerful First Impression
Assessing a Situation
Being Zealous without Being Offensive
Module Eleven: Wrapping Up
Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Basic

Emotional Intelligence (EQ)

Emotional Intelligence 1 Day Training in Solihull

Emotional intelligence 1 Day Training in Solihull

Preston

Emotional Intelligence 1 Day Training in Preston

Emotional intelligence 1 Day Training in Preston

Plymouth

Emotional Intelligence 1 Day Training in Plymouth

Emotional intelligence 1 Day Training in Plymouth

Newport

Emotional Intelligence 1 Day Training in Newport

Emotional intelligence 1 Day Training in Newport

Wrexham

Emotional Intelligence 1 Day Training in Wrexham

Emotional intelligence 1 Day Training in Wrexham

Windsor Town

Emotional Intelligence 1 Day Training in Windsor Town

Emotional intelligence 1 Day Training in Windsor Town

Swansea

Emotional Intelligence 1 Day Training in Swansea

Emotional intelligence 1 Day Training in Swansea

<div data-css="tve-u-1728a2ec9ea" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><h3 data-css="tve-u-1728a2eca75" style="color: rgb(144, 144, 144) !important; box-sizing: border-box;" fr-original-style=" color: rgb(144, 144, 144) !important;">Food Safety, Social Care and Education Training Courses</h3></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><h1 data-css="tve-u-1728a2eca74" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">What You Need To Know Food Intolerances</h1></div><div data-css="tve-u-176287b056f" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;CPD Accredited, Interactive&nbsp;Short Course<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">2 hr session</li><li fr-original-style="" style="box-sizing: border-box;">Do you serve food, or have people with known food intolerances in your school or on your team?</li><li fr-original-style="" style="box-sizing: border-box;">In this interactive course we will explain what food intolerances are, and why it is vital for you to understandhow food intolerances affect people</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">Course Contents:<ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is a food intolerance</li><li fr-original-style="" style="box-sizing: border-box;">Different types of food intolerances</li><li fr-original-style="" style="box-sizing: border-box;">The Digestive System</li><li fr-original-style="" style="box-sizing: border-box;">Consequences of Food Intolerances</li><li fr-original-style="" style="box-sizing: border-box;">The importance of good food hygiene</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Benefits of this Short Course:</h3><ul id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;">More than <a href="https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2695393/pdf/Dtsch_Arztebl_Int-106-0359.pdf" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">20% of the population</a> in industrialized countries suffer from food intolerance or food allergy</li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;">About <a href="https://www.food.gov.uk/sites/default/files/media/document/fsa170306.pdf" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">two million people</a> live with a diagnosed food allergy in the UK, and <a href="https://www.foodallergy.org/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">32 million in the US</a></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-1728a2eca78" fr-original-style="" style="box-sizing: border-box;">This course will teach you the importance of ensuring food is safe to eat for all, without causing significant pain or even death</div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-1728a2eca78" fr-original-style="" style="box-sizing: border-box;">600,000 people in the UK have coeliac disease </div></li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"> </div>

Food Safety, Social Care and Education Training Courses
Introduction to Food Intolerances
 CPD Accredited, Interactive Short Course



2 hr session
Do you serve food, or have people with known food intolerances in your school or on your team?
In this interactive course we will explain what food intolerances are, and why it is vital for you to understand how food intolerances affect people



Course Contents:
What is a food intolerance
Different types of food intolerances
The Digestive System
Consequences of Food Intolerances
The importance of good food hygiene
Benefits of this Short Course:
More than 20% of the population in industrialized countries suffer from food intolerance or food allergy
About two million people live with a diagnosed food allergy in the UK, and 32 million in the US
This course will teach you the importance of ensuring food is safe to eat for all, without causing significant pain or even death
600,000 people in the UK have coeliac disease






Pochat Training

Food Safety

Food Allergy

Accredited Food Hygiene

Food Allergen

Accredited Food Safety

Introduction to Food Intolerances

General Admission

Transform Your Stress into Strength and Thrive in Any Situation!

When your role involves working with clients and service users who have experienced trauma or have special needs, you are expected to be resilient despite the relentless emotional and psychological impact on your well-being. This course focuses on your personal development in navigating the emotional challenges associated with your work.

Together, we will explore a range of emotion skills, practical tools, and resources that extend beyond mindfulness, gratitude, and positive thinking. We will delve into trauma-responsive processing and communication techniques that are vital for supporting your clients while also nurturing your own emotional well-being. 

Prepared for the Emotional Impact of Your Role
Research from the University of Central Lancashire in 2020 revealed that approximately 60% of emergency services personnel felt unprepared for the psychological impact of their job duties, especially when handling traumatic incidents. Additionally, a 2021 study by the Law Society found that many solicitors experience high levels of stress and burnout, with 70% of respondents reporting that the pressures of their profession significantly affect their mental health.

Based on the evidence-based method of Emotional Logic, this course will introduce you to a healthy adjustment process that avoids unhelpful coping strategies. Instead, it offers practical methods that align with your emotions and personality. You will learn to use an activity pack filled with tools and resources that will help you understand your emotional triggers and patterns, as well as discover the healthy reasons behind them. You will also learn how to prepare yourself for traumatic incidents to lessen their psychological impact. These tools are also effective for processing secondary trauma.





Course details:
Course Duration: 4 weeks
Session Length: 4 x 2-hour sessions via Zoom
Dates: June 3rd - 24th, 2025
Times: Tuesdays, 7pm-9pm, London time




Learning Outcomes
Participants will:
Develop practical skills for effectively managing stress.
Learn techniques to build and nurture emotional resilience.
Gain tools to enhance their communication skills and boost their confidence.
Create personalised strategies for maintaining resilience over time.




Course Structure
Week 1: Emotions and their Purpose
Introduction to a healthy adjustment process.
Discovering and understanding emotional patterns.
Exploring the useful purpose of grief emotions.
Identifying emotionally safe spaces and people.
Week 2: Emotions lead your values
Techniques to discover the values behind negative emotions.
Strategies to turn traumatic stories into value-filled narratives.
Experience the power of small steps with a big impact.
Tools to uncover unhelpful communication patterns.
Week 3: Resilience Strategies and Skills
Techniques to communicate boundaries and needs assertively and confidently.
Developing a personalised action plan for ongoing resilience.
Practice the power of peer support (discover how you can help each other)
Week 4: Nurturing personal resilience and social resilience
Practice all you've learned in peer groups.
Build your resilience network.




Who is this course for
This course is designed for professionals who must be resilient under relentless stress. This includes:
First responders
Health professionals
Legal professionals
Victim Services employees
Specialist care providers
HR professionals




Testimonials
The technique has made me more aware of my own emotions, the patterns and how to talk about them more effectively. – Jo  
He gave us a whole new language with which to communicate. – Marleen  
Even now, his session really helped me overcome the shame of feeling more ‘negative’ emotions, and I have been able to work on looking inward and identifying why I’m feeling a certain way rather than blaming others. – Georgia
Sessions with Sven have been refreshing, challenging and reassuring. As it turns out, there are very good reasons why I react the way I do, and instead of wondering what I can do to change, I see the answers have been there all along. – Michael




Format and Delivery
4 weekly live Zoom sessions.
A format that mixes workshop, lecturing and facilitating. 
Participants can ask questions at any time. 
You will receive a hard copy of the Activity Pack (designed for various learning styles.)
There will be no recordings to keep everyone emotionally and psychologically safe. (However, we can schedule a short recap session if you cannot attend a meeting because you are unwell.)
Weekly follow-up email with additional resources not yet included in the Activity Pack.

Eyes Up Training Limited

Stress Management

Emotional Resilience

Mental Resilience

Mental Health At Work

Resilience

Transform stress into strength with this 4-week course, enhancing resilience, emotional skills, and effective communication for professionals.

Thrive Under Pressure: Resilience Skills for Stressful Work Environments

20% discount if you book before 29th April

Early Bird

Standard Admission

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

Real Estate AnalystThe Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Oldham

<div data-id="707b00e3" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(9, 13, 24);"><div data-id="1c97cfcc" data-element_type="widget" data-widget_type="woocommerce-product-content.default" style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">The course will cover special procedures and the benefits of using IP and OP in your compliance.We will look at the impact of the EU Union Customs Code (UCC) on the application, the requirement for duty guarantees and administrative processes involved in managing IP.As well as reviewing the IP application form and the C99/ C&amp;E812 suspension returns, we will also look at what internal processes are required.Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select a date labelled &ldquo;BCC&rdquo; to ensure you are enrolled on the correct course.</div></div><div data-id="60285c8" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" fr-original-style=" color: rgb(9, 13, 24);"> </div>

The course will cover special procedures and the benefits of using IP and OP in your compliance.
We will look at the impact of the EU Union Customs Code (UCC) on the application, the requirement for duty guarantees and administrative processes involved in managing IP.
As well as reviewing the IP application form and the C99/ C&E812 suspension returns, we will also look at what internal processes are required.
Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select a date labelled “BCC” to ensure you are enrolled on the correct course.

Export Unlocked Limited

International Trade

British Chambers of Commerce (BCC)

Export Management

Customs

European Code for Navigation on Inland Waterwaysevni (CEVNI)

The course will cover special procedures and the benefits of using IP and OP in your compliance.

INWARDS & OUTWARD PROCESSING AND RETURNED GOODS RELIEF

Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course. On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</li></ul> Course OutlineDay OneLearn how to build a discounted cash flow, analyse returns and understand the components of development models<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</li></ul> Day TwoLearn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Real Estate Finance

Financial Risk Management

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Real Estate Developer (Development Cash Flow Modelling in Excel)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"> </h2>This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models. On this course you will...<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul> Course Outline:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

Chesterfield

Refresh your skills from when you last did your mental health first aid course! How much do you still remember? How comfortable are you approaching someone? Is there more to learn?&nbsp;

Refresh your skills from when you last did your mental health first aid course! How much do you still remember? How comfortable are you approaching someone? Is there more to learn? 

Mental Health Awareness

Mental Health First Aid

Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Mental Health

Accredited Mental Health First Aid

Wellbeing

Refresh your skills from when you last did your mental health first aid course! How much do you still remember? How comfortable are you approaching someone? Is there more to learn? 

Mental Health First Aid Annual Refresher

Module 9This module aims to develop knowledge and practical skills in Import/Export Customs Diagnostic enabling the learner to create a procedural manual to complete international trade operations.Agenda<ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">WTO</li><li fr-original-style="" style="box-sizing: border-box;">Customs</li><li fr-original-style="" style="box-sizing: border-box;">CDS Portal</li><li fr-original-style="" style="box-sizing: border-box;">Import Procedures</li><li fr-original-style="" style="box-sizing: border-box;">Responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">Importance Purchase Order</li><li fr-original-style="" style="box-sizing: border-box;">MRN</li><li fr-original-style="" style="box-sizing: border-box;">REX</li><li fr-original-style="" style="box-sizing: border-box;">PVA</li><li fr-original-style="" style="box-sizing: border-box;">Export Procedures</li><li fr-original-style="" style="box-sizing: border-box;">Responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">SAD /C88</li><li fr-original-style="" style="box-sizing: border-box;">Commodity Codes</li><li fr-original-style="" style="box-sizing: border-box;">Incoterms 2020</li><li fr-original-style="" style="box-sizing: border-box;">Rules of Origin</li><li fr-original-style="" style="box-sizing: border-box;">Special procedures</li><li fr-original-style="" style="box-sizing: border-box;">ATA Carnet</li><li fr-original-style="" style="box-sizing: border-box;">GSP</li><li fr-original-style="" style="box-sizing: border-box;">Compliance</li><li fr-original-style="" style="box-sizing: border-box;">Creating your Manual</li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div>Examination: Certificate on completion and Pass on Multiple Choice Multiple choice questionnaire Credits: 1

Module 9
This module aims to develop knowledge and practical skills in Import/Export Customs Diagnostic enabling the learner to create a procedural manual to complete international trade operations.
Agenda
WTO
Customs
CDS Portal
Import Procedures
Responsibilities
Importance Purchase Order
MRN
REX
PVA
Export Procedures
Responsibilities
SAD /C88
Commodity Codes
Incoterms 2020
Rules of Origin
Special procedures
ATA Carnet
GSP
Compliance
Creating your Manual
Examination:
Certificate on completion and Pass on Multiple Choice
Multiple choice questionnaire
Credits: 1

Trade

Import/Export

This module aims to develop knowledge and practical skills in Import/Export Customs Diagnostic enabling the learner to create a procedural manual to complete international trade operations.

IMPORT/EXPORT DIAGNOSTICS CREATING A PROCEDURE MANUAL

The psychological impact of critical incidents includes anxiety, depression, sleep disturbance and agitation. It can also lead to reduced motivation or morale at work, unsafe practices, and burnout.Health and social care professionals in hospitals, residential care, and support services, who are looking after vulnerable people in challenging environments, are often exposed to distressing events. Critical Incident Stress Debriefings (CISDs) are brief and effective interventions. They mitigate the impact of incidents and help promote resilience and well-being. &nbsp;CISD is a facilitated, time-limited group session intended to support participants with the emotional/psychological impact of an adverse event. The debrief is a structured group conversation about the facts, feelings, and thoughts related to the incident.&nbsp;A trained and competent facilitator helps the group support each other and process their reactions.&nbsp;This training is for managers, nurses, key workers, mental health professionals, counsellors/psychotherapists, or any person in charge of staff well-being in their organization.&nbsp;This excellent 2-day online training will cover theory and practice, including lectures, videos, and small-group work. When you complete the training you will be able to facilitate CISDs. Here is an outline of the training:Day 1: Critical Incidents and the Process of Debriefing&nbsp;09:00 - 10:30&nbsp; Introducing the facilitator and the group; outline of the day, expectations and outcomes. The Process of Debriefing: the practice of &lsquo;talking through&rsquo; and the therapeutic benefits of debriefing. Understanding Critical Incidents: defining Critical Incidents, what makes an incident &lsquo;critical&rsquo;? The psychological impact of a critical incident. 10:30 - 12:00&nbsp; Trauma and Post-Trauma Unpacking these important concepts and understanding their implications and relevance to CID Debriefing Critical Incidents Introducing existing models of CISDs, comparing and understanding the components of a CID 12:30 Lunch break&nbsp; 13:00 - 14:00&nbsp; Skills Practice and Experiential Learning Practice session, trying out models of debriefing using scenarios from experience Day 2: Facilitating Critical Incident Stress Debriefings &ndash; theory and practice 09:00 - 10:30&nbsp; The Competent Facilitator:&nbsp;qualities and skills of the competent facilitator Containment The role of the facilitator and the challenges of facilitating emotional conversations&nbsp; 10:30 - 12:00&nbsp; Facilitating critical incident debriefings: prompt cards - a tool for the facilitator. Ground rules, time-frames, and keeping &lsquo;on task&rsquo;. 12:30 Lunch break &nbsp; 13:00 - 14:00&nbsp; Skills Practice and Experiential Learning Working with scenarios and prompt cards: practice session - facilitating CISDs &lsquo;Debriefing&rsquo; the day &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

The psychological impact of critical incidents includes anxiety, depression, sleep disturbance and agitation. It can also lead to reduced motivation or morale at work, unsafe practices, and burnout.
Health and social care professionals in hospitals, residential care, and support services, who are looking after vulnerable people in challenging environments, are often exposed to distressing events. 

Critical Incident Stress Debriefings (CISDs) are brief and effective interventions. They mitigate the impact of incidents and help promote resilience and well-being. 
CISD is a facilitated, time-limited group session intended to support participants with the emotional/psychological impact of an adverse event.
The debrief is a structured group conversation about the facts, feelings, and thoughts related to the incident. A trained and competent facilitator helps the group support each other and process their reactions. 
This training is for managers, nurses, key workers, mental health professionals, counsellors/psychotherapists, or any person in charge of staff well-being in their organization. 
This excellent 2-day online training will cover theory and practice, including lectures, videos, and small-group work. When you complete the training you will be able to facilitate CISDs.

Here is an outline of the training:
Day 1: Critical Incidents and the Process of Debriefing 
09:00 - 10:30 
Introducing the facilitator and the group; outline of the day, expectations and outcomes.
The Process of Debriefing: the practice of ‘talking through’ and the therapeutic benefits of debriefing.
Understanding Critical Incidents: defining Critical Incidents, what makes an incident ‘critical’? The psychological impact of a critical incident.

10:30 - 12:00 
Trauma and Post-Trauma
Unpacking these important concepts and understanding their implications and relevance to CID
Debriefing Critical Incidents
Introducing existing models of CISDs, comparing and understanding the components of a CID

12:30 Lunch break 

13:00 - 14:00 
Skills Practice and Experiential Learning
Practice session, trying out models of debriefing using scenarios from experience

Day 2: Facilitating Critical Incident Stress Debriefings – theory and practice

09:00 - 10:30 
The Competent Facilitator: qualities and skills of the competent facilitator
Containment
The role of the facilitator and the challenges of facilitating emotional conversations 

10:30 - 12:00 
Facilitating critical incident debriefings: prompt cards - a tool for the facilitator.
Ground rules, time-frames, and keeping ‘on task’.

12:30 Lunch break
 
13:00 - 14:00 
Skills Practice and Experiential Learning
Working with scenarios and prompt cards: practice session - facilitating CISDs
‘Debriefing’ the day

  

Psychotherapy For Healthcare Ltd

Train with us to facilitate Critical Incident Stress Debriefings. CISD are effective interventions that help care professionals to process stressful events in the workplace.  A CISD helps restore well-being and protect from prolonged reactions. This excellent 2-day training will cover theory and practice, including lectures, videos, and small-group work. By the end you will be able to facilitate CISDs.

11708 Management courses

Practical Sales Skills 1 Day Workshop in Teesside

By Mangates

Practical Sales Skills 1 Day Workshop in Coventry

By Mangates

Practical Sales Skills 1 Day Workshop in Hinckley

By Mangates

Emotional intelligence 1 Day Training in Solihull

By Mangates

Emotional intelligence 1 Day Training in Preston

By Mangates

Emotional intelligence 1 Day Training in Plymouth

By Mangates

Emotional intelligence 1 Day Training in Newport

By Mangates

Emotional intelligence 1 Day Training in Wrexham

By Mangates

Emotional intelligence 1 Day Training in Windsor Town

By Mangates

Emotional intelligence 1 Day Training in Swansea

By Mangates

Search By Location