Name: Practical Sales Skills 1 Day Workshop in Newport
Price: 595 GBP
Availability: InStock

Management

Cork

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.
Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.
Conflict may emerge between managers and their staff, between team members or departments.
Conflict may be expressed openly, but it may also be hidden, in the form of irritation, resentment, loss of morale and lack of commitment. Hidden conflict is easy to miss and therefore can be particularly damaging.
Ultimately, this is likely to have an adverse effect on team and company performance, costing time and money.
It is therefore vital to manage conflict constructively.
As a team member and leader, your ability to deal with and resolve conflicts defines your success in the longer term.
Our one day workshop in Conflict Management and Communication Skills immerses you in the most advanced conflict management tools, strategies and practices applicable today. You will gain hands-on practice on proven frameworks, go through simulations and exercises that will train you to be a highly effective professional and leader, starting day one.
Target Audience:
Anybody who is interested in learning Conflict Management Skills

Learning Objectives:
Getting a handle on and gaining insights into your conflict management style through self-assessments (TKI®).
Role playing to practice techniques and new skills in a safe environment.
Proven best practices for approaching conflict management.
Practices for resolving conflict as a third party mediator.
Scientifically validated frameworks on effective communication in stressful situations.
Transferring your learning back to your work environment using job aids, templates and other resources.
How Will You Benefit?
Build trust and credibility with colleagues and team members
Leverage potential conflict situations as opportunities for critical conversations that enhance work relationships.
Gain confidence in holding difficult conversations calmly and assertively.
Manage difficult situations proactively.
Increase your effectiveness in managing conflict.
See growth in your overall performance
Agenda:
Science behind workplace conflicts
Understanding Human Behavior
Different Personality Types
Conflict Management Styles
Conflict Management Strategies
Workplace Conflicts
Conflict Resolution Agreements
Working with difficult people
Relationship and reputation management
Certification:
Once after the training we will provide you with the course completion certificate.

Mangates

Conflict Management

Conflict Management 1 Day Training in Cork

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Aberdeen

Certificate: Course Completion Certificate
Language: English
Duration: 1 Day
Credits: 8
Refreshments: Snacks, Beverages and Lunch included in a classroom session
Course Delivery: Classroom
Course Overview:
Through this course, you will examine financial statements—including the balance sheet, income statement, cash flow statement, and statement of stockholders' equity—as guides to fiscal health. You will also identify what you want to gain from a budget and describe the steps of budgeting to meet these goals. Finance and Budgeting Essentials for Business Professionals grounds you in the functions and tools of finance.
Course Topics:
Lesson 1: Reviewing Financial Basics
Topic A: Identify the Benefits of Finance
Topic B: Describe Financial Statements
Lesson 2: Interpreting Balance Sheets
Topic A: Identify Elements of Balance Sheets
Topic B: Analyze a Balance Sheet
Lesson 3: Interpreting Income Statements
Topic A: Identify Elements of Income Statements
Topic B: Analyze an Income Statement
Lesson 4: Interpreting Other Financial Statements
Topic A: Read Cash Flow Statements
Topic B: Read Statements of Stockholders’ Equity
Topic C: Read Notes to Financial Statements
Topic D: Identify Elements of Financial Statements for Non-Profits
Lesson 5: Planning a Budgeting Approach
Topic A: Describe Budgeting Principles
Topic B: Choose What and How to Budget
Lesson 6: Utilizing Budgets
Topic A: Prepare an Operating Budget
Topic B: Prepare an Activity-Based Budget
Topic C: Monitor a Budget
You Will Learn To:
Describe the importance and major elements of financial statements.
Use balance sheets to determine the assets a company has at its disposal.
Interpret income statements to identify corporate earnings, expenses, and profitability.
Certification:
Once after the training you receive course completion certificate from Mangates.
Who can Attend?
All business professionals who want to learn more about business finance.

Basic

Accounting & Finance

Business Finance Basics 1 Day Training in Aberdeen

High Wycombe 

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:
Providing outstanding customer service can make the difference between gaining, keeping, or losing a customer. In this one-day Customer Service Essentials training course, you gain foundational knowledge, leverage proven techniques, and apply best practices that will help develop and maintain mutually beneficial relationships with your customers, while continuing to grow your customer base. Gaining these essential customer service skills can help your company boost their customer retention and acquisition metrics.
Course Topics:
Assessing your attitude to customer service
Practicing verbal and vocal skills
Handling customer complaints and difficult situations
Demonstrating empathy and building rapport
Defining the Golden Rules for Success
Course Feature:
You Will Learn How To:
Adopt a confident, consistent approach that ensures great service
Apply best practice communication techniques to connect with your customers
Choose and apply techniques that create customer loyalty and exceed expectations
Respond positively and constructively to customer problems
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
No formal prerequisites are required to attend this course.

Customer Service Essentials 1 Day Training in High Wycombe

Boost Customer Satisfaction: Join us 1 Day Training in High Wycombe

Darlington

Customer Service Essentials 1 Day Training in Darlington

Boost Customer Satisfaction: Join us 1 Day Training in Darlington

Newport

Customer Service Essentials 1 Day Training in Newport

Boost Customer Satisfaction: Join us 1 Day Training in Newport

Caernarfon

Customer Service Essentials 1 Day Training in Caernarfon

Boost Customer Satisfaction: Join us 1 Day Training in Caernarfon

Customer Service Essentials 1 Day Training in Aberdeen

Boost Customer Satisfaction: Join us 1 Day Training in Aberdeen

Wolverhampton

Customer Service Essentials 1 Day Training in Wolverhampton

Boost Customer Satisfaction: Join us 1 Day Training in Wolverhampton

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.

Practical Sales Skills 1 Day Workshop in Wolverhampton

Practical Sales Skills 1 Day Workshop in Newport

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Start running Paid Ads on social&nbsp;media, and&nbsp;reach more customers than ever before!&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Want to level up your social media channels and skills, and learn how to run smart and effective paid social media campaigns on Facebook and Instagram? Join the course from&nbsp;Let&rsquo;s&nbsp;Do Marketing and follow the&nbsp;whole process&nbsp;with an expert social media coach, where&nbsp;you&rsquo;ll&nbsp;learn how to dive deeper into and create a more targeted marketing strategy, and how to plan and set up sophisticated Paid Ad campaigns from Facebook Ads Manager.&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;📅 Date: Tuesday 5th November🕒&nbsp;Time: 10am - 1pm📌 Location: Online Webinar&nbsp;<span style='background: url("https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg"); display: inline-block; font-family: "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-weight: 400; line-height: 1; box-sizing: border-box; font-size: inherit; height: 1em; margin: -0.1em 0.1em 0.1em; min-height: 20px; min-width: 20px; vertical-align: middle; width: 1em;' fr-original-style="background: url(https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg);" fr-original-class="fr-emoticon fr-deletable fr-emoticon-img">&nbsp;💷&nbsp;Cost: &pound;30PP </div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">During this course,&nbsp;we&rsquo;ll&nbsp;cover:&nbsp;&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Developing your customer personas online &ndash; investigating habits, social media usage, trends and more&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Ways you can use data better &ndash; from installing a Facebook Pixel to using your Mailing Lists to create targeted audiences for your Paid Ads&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Learning about Meta Business Suite &ndash; useful tools included, as well as how to navigate the platform&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Different formats and types of ads&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Creating graphic design content for Paid Ads using Canva&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Walkthrough of creating a Paid Ad Campaign on Facebook Ads Manager &ndash; from creating your campaign and narrowing down your audience, to creating Ad copy and Call to Actions.&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Measuring the results of your Paid Ad campaigns&nbsp;</li></ul></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">As well as a dedicated Q&amp;A session, where you can ask a social media expert any questions you have about running and creating your own paid advertisements on social media.&nbsp;</div>

Start running Paid Ads on social media, and reach more customers than ever before!
Want to level up your social media channels and skills, and learn how to run smart and effective paid social media campaigns on Facebook and Instagram?

Join the course from Let’s Do Marketing and follow the whole process with an expert social media coach, where you’ll learn how to dive deeper into and create a more targeted marketing strategy, and how to plan and set up sophisticated Paid Ad campaigns from Facebook Ads Manager.
Event details:
Time: 10am - 1pm
Location: Online (ZOOM)
Cost: £35pp
During this course, we’ll cover:  
Developing your customer personas online – investigating habits, social media usage, trends and more
Ways you can use data better – from installing a Facebook Pixel to using your Mailing Lists to create targeted audiences for your Paid Ads
Learning about Meta Business Suite – useful tools included, as well as how to navigate the platform
Different formats and types of ads
Creating graphic design content for Paid Ads using Canva
Walkthrough of creating a Paid Ad Campaign on Facebook Ads Manager – from creating your campaign and narrowing down your audience, to creating Ad copy and Call to Actions.
Measuring the results of your Paid Ad campaigns

As well as a dedicated Q&A session, where you can ask a social media expert any questions you have about running and creating your own paid advertisements on social media. 




Meet the Host:
Kerry Madge | Marketing Executive, Let's Do Marketing


Kerry Madge is a dynamic Marketing Executive at Let's Do Marketing, bringing nearly six years of diverse experience collaborating with businesses of all sizes. Holding a BA in Marketing Management, Kerry excels in social media advertising, graphic design, and copywriting. Her passion lies in crafting creative solutions and developing comprehensive marketing strategies that empower small businesses to visualise and achieve their overarching goals.



Privacy Notice
By registering for this event, you agree to Let’s Do Business Group processing and managing your personal data in accordance with our Privacy Policy. Your data will only be used for the purposes of managing your event registration and any relevant communications.

Let’s Do Business Group

Social Media Strategy

Social Media Marketing

Social Media

Social Media Management

Start running Paid Ads on social media, and reach more customers than ever before!

Social Media Advanced: Paid Ads

General 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 Financial Modelling School (5 days)The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.The school combines three of our courses:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul> All of the courses are interlinked to give you a full understanding of the subject using Excel. 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;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul> Who will benefit from this school?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" 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="2" 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="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul> Course OutlineDay OneReal Estate Analyst IKnow 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 TwoReal Estate Analyst IIKnow 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> Day ThreeReal Estate Investor I<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day FourReal Estate Investor II<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul> Day FiveReal Estate Modelling Masterclass<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;">Advance 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 Financial Modelling School 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 Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
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
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
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
Real Estate Analyst II
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)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance 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 Financial Modelling School 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

Real Estate Finance

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

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

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

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

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context. Pre-requisite:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Completion of the Real Estate Analyst Course</li></ul> On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Revise operational models of real estate assets and stress for core income</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply modelling techniques to an expanded range of real estate sectors and geographies</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider both investment and development cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the sources and use of funds</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about typical debt covenants and how to incorporate them</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn how to optimise debt structures</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate professionals at any level with exposure to real estate financial models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analysts and Modellers who are making the transition from corporate finance to real estate investment and development</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analysts and Investors</li></ul> Course OutlineDay One<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Further senior debt covenants</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day Two<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development appraisals</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Residual models, site and profit calculations</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Development cash flows versus Investment cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to straight line versus S-curve costing</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Phased asset sales in development appraisals</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounting development cash flows</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Complimentary return metrics for development appraisals</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development finance</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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 Investor 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>





The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.
Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.
Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context.


Pre-requisite:
Completion of the Real Estate Analyst Course


On this course you will…
Revise operational models of real estate assets and stress for core income
Apply modelling techniques to an expanded range of real estate sectors and geographies
Consider both investment and development cash flows
Understand the sources and use of funds
Learn about typical debt covenants and how to incorporate them
Learn how to optimise debt structures


Who will benefit from this course?
Real Estate professionals at any 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, debt structures and return metrics
Analysts and Modellers who are making the transition from corporate finance to real estate investment and development
Real Estate Analysts and Investors


Course Outline
Day One
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Two
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


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

Financial Analysis

Financial Risk Management

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Real Estate Investor (Advanced Development Cash Flow Modelling in Excel)

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">FAA Level 3 Award In Principles Of Safeguarding And Protecting Children, Young People Or Vulnerable Adults (RQF)</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Face to Face Classroom: One day course</li><li fr-original-style="" style="box-sizing: border-box;">Virtual Classroom: 3 session of 2 &frac12; hours</li><li fr-original-style="" style="box-sizing: border-box;">For those who work with children, young people and vulnerable adults</li><li fr-original-style="" style="box-sizing: border-box;">Promotes awareness of safeguarding, enabling learners to identify problems and show where to report these to</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;">Safeguarding and protecting children, young people or vulnerable adults</li><li fr-original-style="" style="box-sizing: border-box;">How to respond to evidence or concerns that a child, young person or vulnerable adult has been abused</li><li fr-original-style="" style="box-sizing: border-box;">Safeguarding legislation and guidance</li><li fr-original-style="" style="box-sizing: border-box;">Indicators of abuse or neglect</li><li fr-original-style="" style="box-sizing: border-box;">Making judgements</li><li fr-original-style="" style="box-sizing: border-box;">Communicating worries and concerns</li><li fr-original-style="" style="box-sizing: border-box;">Roles and responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">Sharing information</li><li fr-original-style="" style="box-sizing: border-box;">Allegations and complaints</li><li fr-original-style="" style="box-sizing: border-box;">Reporting allegations and complaints</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Benefits of this Course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">In 2018/2019, 415,050 concerns of abuse were raised</li><li fr-original-style="" style="box-sizing: border-box;">In 2018/2019, there were nearly 400,000 children in need</li><li fr-original-style="" style="box-sizing: border-box;">52,300 children were subject to a child protection plan</li><li fr-original-style="" style="box-sizing: border-box;">63% of adult safeguarding concerns are for people over 65</li><li fr-original-style="" style="box-sizing: border-box;">1 in every 42 adults aged 85+ have required safeguarding enquires...</li><li fr-original-style="" style="box-sizing: border-box;">Child abuse often goes unreported and unrecorded - till it is picked up on by someone who then does something about it.</li><li fr-original-style="" style="box-sizing: border-box;">This Level 3 Safeguarding course gives people the skills and knowledge to make a real difference to a person&#39;s life!</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;"><h3 fr-original-style="" style="box-sizing: border-box;"> </h3><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;"><h3 id="isPasted" style="color: rgb(65, 65, 65); box-sizing: border-box;" fr-original-style=" color: rgb(65, 65, 65);">Accredited, Ofqual regulated qualification</h3><h2 id="isPasted" style="color: rgb(65, 65, 65); box-sizing: border-box;" fr-original-style=" color: rgb(65, 65, 65);"><img src="https://images.cademy.co.uk/pochat-training/2d5ef945-4535-4948-84e0-6a2585e0428d/original.png" style="display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; max-width: calc(100% - 5px); text-align: left; float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; max-width: calc(100% - 5px); text-align: left; float: left;" fr-original-class="fr-draggable"></h2>Our Safeguarding and Protecting Children, Young People or Vulnerable Adults training course is a nationally recognised, Ofqual regulated qualifications accredited by&nbsp;<a href="http://www.firstaidawards.com/" 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);">First Aid Awards Ltd</a>. This means that you can be rest assured that your Principles of Safeguarding and Protecting Children, Young People or Vulnerable Adults Certificate provides information for best practice to make a real difference to protect the health and wellbeing of our most vulnerable. The&nbsp;Ofqual Register number&nbsp;for this course is&nbsp;601/8471/1<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;">

FAA Level 3 Award In Principles Of Safeguarding And Protecting Children, Young People Or Vulnerable Adults (RQF)
Face to Face Classroom: One day course
Virtual Classroom: 3 session of 2 ½ hours
For those who work with children, young people and vulnerable adults
Promotes awareness of safeguarding, enabling learners to identify problems and show where to report these to



Course Contents:
Safeguarding and protecting children, young people or vulnerable adults
How to respond to evidence or concerns that a child, young person or vulnerable adult has been abused
Safeguarding legislation and guidance
Indicators of abuse or neglect
Making judgements
Communicating worries and concerns
Roles and responsibilities
Sharing information
Allegations and complaints
Reporting allegations and complaints
Benefits of this Course:
In 2018/2019, 415,050 concerns of abuse were raised
In 2018/2019, there were nearly 400,000 children in need
52,300 children were subject to a child protection plan
63% of adult safeguarding concerns are for people over 65
1 in every 42 adults aged 85+ have required safeguarding enquires...
Child abuse often goes unreported and unrecorded - till it is picked up on by someone who then does something about it.
This Level 3 Safeguarding course gives people the skills and knowledge to make a real difference to a person's life!








Accredited, Ofqual regulated qualification

Our Safeguarding and Protecting Children, Young People or Vulnerable Adults training course is a nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd.

This means that you can be rest assured that your Principles of Safeguarding and Protecting Children, Young People or Vulnerable Adults Certificate provides information for best practice to make a real difference to protect the health and wellbeing of our most vulnerable.

The Ofqual Register number for this course is 601/8471/1






Pochat Training

Social Work

General Nursing

Adult Nurse

Child Care

Early Childhood

Nursery

Child Safeguarding

Safeguarding

Nursery Teacher

Nursery Nurse

Accredited Safeguarding

Social Worker

Child Protection

Health & Social Care

Early Years Foundation Stage (EYFS)

Online Safeguarding

Early Years

Social Care

Level 3 Safeguarding

<h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Reflective Practice is the cornerstone of professionalism in healthcare.&nbsp;It develops clinical skills, improves decision-making, enhances work satisfaction, and reduces burnout.</h2><div fr-original-style="" style="box-sizing: border-box;">Ongoing Reflective Practice sessions are designed for members of staff to reflect together on their day-to-day practice, to process difficult situations and to consider personal and professional issues affecting their work.&nbsp;</div>Skilled Reflective Practice facilitators are a valuable asset to many public and private organisations.<h5 style="color: rgb(67, 153, 250) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(67, 153, 250) !important;">Reflective Practice: Train to become a facilitator</h5>Online One-Day Workshop, 10:00-16:00 For counsellors, nurses, managers and healthcare practitioners. Attending this training will provide you with the skills, knowledge and expertise to set up and facilitate Reflective Practice sessions in your organisation or as a private service, either online or in person. Outline of the day:10:00 Introduction 10:30 The Process of Reflection and its benefits 11:00 Practice: the work that we do and its impact on us 11:30 Coffee break 11:45 Models for Reflecting on Practice 12:45 Lunch break 13:30 The Competent Facilitator 14:00 Setting up Reflective Practice groups 14:45 Coffee break 15:00 Facilitating Reflective Practice: Skills Practice and Experiential Learning 15:45 Overview of the day

Reflective Practice is the cornerstone of professionalism in healthcare. It develops clinical skills, improves decision-making, enhances work satisfaction, and reduces burnout.
Ongoing Reflective Practice sessions are designed for members of staff to reflect together on their day-to-day practice, to process difficult situations and to consider personal and professional issues affecting their work.
Skilled Reflective Practice facilitators are a valuable asset to many public and private organisations.
Reflective Practice: Train to become a facilitator
Online One-Day Workshop, 10:00-16:00

For counsellors, nurses, managers and healthcare practitioners. Attending this training will provide you with the skills, knowledge and expertise to set up and facilitate Reflective Practice sessions in your organisation or as a private service, either online or in person.

Outline of the day:
10:00 Introduction
10:30 The Process of Reflection and its benefits
11:00 Practice: the work that we do and its impact on us

11:30 Coffee break

11:45 Models for Reflecting on Practice

12:45 Lunch break

13:30 The Competent Facilitator
14:00 Setting up Reflective Practice groups

14:45 Coffee break

15:00 Facilitating Reflective Practice: Skills Practice and Experiential Learning
15:45 Overview of the day

Psychotherapy For Healthcare Ltd

A one-day training for counsellors, nurses, managers and healthcare practitioners who want to learn how to set up and facilitate Reflective Practice groups.
Reflective Practice is the cornerstone of professionalism in healthcare. It develops clinical skills, improves decision-making, enhances work satisfaction, and reduces burnout.

Reflective Practice: Train to become a facilitator

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

Communication is the essence of Leadership. This programme is the premiere of our leadership courses focusing on creating a culture of positive interaction, clear and respectful exchanges, all the while keeping high-performance productivity, ownership, and innovation in the forefront.Before the start of the learning session, delegates complete&nbsp;the&nbsp;TruTalent&trade; Learning &amp; Productivity (TTL &amp; P), a 20-minute online survey of an individual&rsquo;s productivity preferences and learning styles.&nbsp;The assessment identifies the individual&rsquo;s work and learning preferences for 4 styles and 12 environmental and mindset preferences. These elements affect, positively or negatively, how each individual achieves and performs in work-based learning environments. They also affect the way in which individuals concentrate, make decisions, solve problems, process information, approach and complete tasks, retain new and complex information, develop new skills, and interact with others.<h5 style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">DELEGATES WILL BE ABLE TO:</h5><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li fr-original-style="" style="box-sizing: border-box;">Use the TruTalent&trade; Learning &amp; Productivity assessment&nbsp;to increase productivity and&nbsp;maximise performance;</li><li fr-original-style="" style="box-sizing: border-box;">Set meaningful professional goals and celebrate success for incremental progress toward achievement;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li fr-original-style="" style="box-sizing: border-box;">Inspire innovation with teams to increase ownership and accountability;</li><li fr-original-style="" style="box-sizing: border-box;">Empower employees and increase engagement with effective, positive&nbsp;feedback;</li><li fr-original-style="" style="box-sizing: border-box;">Focus on positivity, setting an example for others that we are an organisation of &ldquo;yes&rdquo; and solutions; and</li><li fr-original-style="" style="box-sizing: border-box;">Improve spoken and written communications, creating an authoritative image of expertise.</li></ul>&nbsp;Online Format&mdash;Leadership &amp; Management Development is a 4-hour interactive virtual class.<h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"> </div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;">After a two-day seminar, our attendees remained in their seats wanting more from Dr Atkins. His direct, yet challenging approach to presenting topics seemed to mesmerize the participants. Many very lively discussions were part of our workshop&rsquo;s context. Personally, I am very interested in re-booking this type of experience every year for new leaders to undergo!Michael J. Whitlock, Director of Fay Corey Union &amp; Conferences |&nbsp;SUNY Cortland

Communication is the essence of leadership. This programme is the flagship of our leadership courses, focusing on creating a culture of positive interaction and clear, respectful exchanges whilst maintaining high-performance productivity, ownership, and innovation.

Prior to the learning session, delegates complete the TruTalent™ Learning & Productivity (TTL & P), a 20-minute online survey assessing individual productivity preferences and learning styles. This assessment identifies work and learning preferences across 4 styles and 12 environmental and mindset preferences. These elements significantly influence how individuals achieve and perform in work-based learning environments. They also affect how people concentrate, make decisions, solve problems, process information, approach and complete tasks, retain new and complex information, develop new skills, and interact with others.

Throughout the course, delegates will learn how to:
Utilise the TruTalent™ Learning & Productivity assessment to increase productivity and maximise performance 
Set meaningful professional goals and celebrate success for incremental progress towards achievement 
Inspire innovation within teams to increase ownership and accountability 
Empower employees and increase engagement through effective, positive feedback 
Focus on positivity, setting an example for others that the organisation embraces a "yes" and solutions-oriented approach 
Improve spoken and written communications, creating an authoritative image of expertise 

This Leadership Skills course is a 4-hour interactive virtual class. 

Upon registration, delegates will receive online login instructions prior to the class date. This format allows for a collaborative learning experience from the comfort of one's own home or office, enabling leaders to enhance their skills and drive organisational success.

Improving Communications Uk

LEADERSHIP & MANAGEMENT DEVELOPMENT

<h3 data-css="tve-u-171a6cf07b2" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34) !important;">Highfield Level 1 Award in an Introduction to Mental Health and Wellbeing (RQF)</h3><h3 data-css="tve-u-171a6cf07b2" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34) !important;">Course Contents</h3><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;">What is Mental Health?</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;">What is Mental Ill Health</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;">The difference between normal mental responses, and when a person needs help</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;">Signs that mental health and wellbeing is deteriorating</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;">Lifestyle choices that can affect mental health and mental wellbeing</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;">How to take care of your own mental health and mental wellbeing</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;">Coping strategies</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;">How to support other people with their mental health and wellbeing</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;">Knowing how to take care of one&#39;s own mental health and mental wellbeing, while helping other people with theirs</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;">Sources of mental health and wellbeing support&nbsp;</li></ul><h3 data-css="tve-u-171a68117d4" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34) !important;">Benefits of this course</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">37% of all work-related ill-health is due to mental health problems</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;">Problems with mental health cover 45% of all working days lost</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;">A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19</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;">602,000 workers suffered from work-related stress, depression or anxiety in 2018/19</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;">One in four people will have a mental health problem at some point during their lives</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;">Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees</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;">Work-related mental health issues must to be assessed to measure the levels of risk to staff</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;">Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable</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;">This one day course gives people a good awareness of mental health and mental wellbeing, how to take care of yours and how to help others take care of their mental health and wellbeing </li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div>AccreditationThis Introduction to Mental Health and Wellbeing Course is a nationally recognised, Ofqual regulated qualification accredited by <a href="https://www.highfieldqualifications.com/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;">Highfield Qualifications</a>. This means that you can be rest assured that your Mental Health and Wellbeing Certificate is a very good way to make sure you and your employees have a supporting workplace to deal with staff&#39;s mental health and mental wellbeing. The&nbsp;Ofqual Register number&nbsp;for this course is&nbsp;603/6330/7

Highfield Level 1 Award in an Introduction to Mental Health and Wellbeing (RQF)
Course Contents
What is Mental Health?
What is Mental Ill Health
The difference between normal mental responses, and when a person needs help
Signs that mental health and wellbeing is deteriorating
Lifestyle choices that can affect mental health and mental wellbeing
How to take care of your own mental health and mental wellbeing
Coping strategies
How to support other people with their mental health and wellbeing
Knowing how to take care of one's own mental health and mental wellbeing, while helping other people with theirs
Sources of mental health and wellbeing support
Benefits of this course
37% of all work-related ill-health is due to mental health problems
Problems with mental health cover 45% of all working days lost
A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19
602,000 workers suffered from work-related stress, depression or anxiety in 2018/19
One in four people will have a mental health problem at some point during their lives
Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees
Work-related mental health issues must to be assessed to measure the levels of risk to staff
Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable
This one day course gives people a good awareness of mental health and mental wellbeing, how to take care of yours and how to help others take care of their mental health and wellbeing





Accreditation
This Introduction to Mental Health and Wellbeing Course is a nationally recognised, Ofqual regulated qualification accredited by Highfield Qualifications.

This means that you can be rest assured that your Mental Health and Wellbeing Certificate is a very good way to make sure you and your employees have a supporting workplace to deal with staff's mental health and mental wellbeing.

The Ofqual Register number for this course is 603/6330/7


Health & Wellbeing

Emotions

Occupational Health & Wellbeing

Personal Development

Emotional Wellbeing

Emotional Intelligence (EQ)

Psychological Wellbeing

Mental Health

Emotional Resilience

Accredited Mental Health First Aid

Emotional Literacy

Wellbeing

Mental Resilience

Resilience

Life Skills

This accredited course gives you an introduction to mental health and wellbeing - what it is, how to take care of yourself and support others

11809 Management courses

Conflict Management 1 Day Training in Cork

By Mangates

Business Finance Basics 1 Day Training in Aberdeen

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in High Wycombe

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in Darlington

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in Newport

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in Caernarfon

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in Aberdeen

By Mangates

Boost Customer Satisfaction: Join us 1 Day Training in Wolverhampton

By Mangates

Practical Sales Skills 1 Day Workshop in Wolverhampton

By Mangates

Practical Sales Skills 1 Day Workshop in Newport

By Mangates

Search By Location