Name: Communication Skills 1 Day Training in Arbroath
Price: 595 GBP
Availability: InStock

High Wycombe 

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

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

Course  Overview:
This report writing training is aimed at people who are new to report writing or who need to improve their report writing skills. As you would expect from us, this is not a programme covering theory alone. You are expected to put into practice what they are learning as they go through the day.
This training will help you to develop the report writing skills of your participants and ensure you deliver a successful report writing training course.
Course Topics:
Section One – Introduction to Report Writing
This section covers the key principles of report writing and lays the foundation for the remainder of the day’s activities. Topics covered include:
 Why a report?
Why are some reports ineffective?
Basic Principles of Report Writing
Structure of Business Reports
Section Two – Plan and Prepare
This section looks at a number of techniques to help report writers prepare before                beginning the task of writing. Great emphasis is placed on planning and preparing. We consider this to be the key to effective report writing. Topics Include:
Purpose of the Report
Knowing your Readers
Generating Ideas
Sources of Information
The Extended Pyramid
Report Outline
Section Three – Write the Report
Participants work on an actual report or develop one from a brief provided by us.  This section builds on the principles already covered and we also cover topics such as:
Getting Started
Overcoming Writer's Block
Language
Section Four – Check and Edit
In this final section we consider the importance of checking and editing reports     before submitting. We suggest an approach that gives the best chance of ensuring that  participants present professional reports to their readers.
Participants get the opportunity to practice their checking techniques using the reports they produced earlier.
Course Feature:
By the end of this report writing training you will be able to:
Prepare and plan reports that meet their intended purpose
Produce reports that conform to an established and acceptable structure
Proofread and edit their reports effectively before submitting them to their intended readers
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
Anybody who is interested in learning Report Writing Skills.

Mangates

Financial Reporting

Writing Skills

Report Writing 1 Day Training in High Wycombe

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Chelmsford

Report Writing 1 Day Training in Chelmsford

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

Microsoft Excel

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

General Admission

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



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


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


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


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


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


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


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

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

York

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

In a survey carried out amongst experienced, middle and senior executives, designed to determine the things that they feared most, public speaking came out as number one. Death was eighth on the list! So, most of us would rather die than stand up and present!
This session will provide you with the ideas and techniques to help them feel more confident about presenting, and will help you to become an effective presenter.

Course Topics:

Problems and fears with Presentations – Looking at the past problems delegates have felt and seen with presentations. What their fears are and their likes and dislikes of presenting.

Qualities of an Effective Presenter – Identifying what makes a presenter good and analysing the skills required.

Planning a Presentation – Key considerations when planning a presentation and planning around the audience.

Structuring Your Presentation – Considering the attention span of an audience and structuring the session around this. Using the ‘Communicating to Convince’ model to structure the presentation.

Opening Attention Grabbers – How to start a session with a bang.

Using Visual Aids – The do’s and don’ts regarding visual aids and making them effective.

Presentation Models and Tools – Identifying alternatives to PowerPoint.

Presentation style – Considering their style, including; mannerisms, gestures, eye contact, voice and nerves.

Presentation Practice – A chance to test their presenting skills and provide feedback in a safe environment.

Course Feature:

At the end of this presentation skills training course you will be able to:

Plan a presentation keeping the audience in mind
Develop clear objectives for their presentation
Use ‘attention grabbers’ to enhance their opening
Develop effective visual aids
Use several different methods and tools for presenting
Use positive presentation style behaviours
Practice their skills of presenting

Certification:

Once after the training you receive course completion certificate from Mangates

Who can Attend?

Anybody who is interested in learning Presentation Skills.

Presentation Skills 1 Day Workshop in York

Arbroath

Presentation Skills 1 Day Workshop in Arbroath

Ipswich

Presentation Skills 1 Day Workshop in Ipswich

Dublin

Presentation Skills 1 Day Workshop in Dublin

St Davids

Presentation Skills 1 Day Workshop in St Davids

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

Communication

Coaching Skills

Communication Skills 1 Day Training in Arbroath



Welcome to Your Course!
Thank you for choosing to develop your skills in dog walking and sitting. By completing this course, you'll gain the essential tools and knowledge to begin your journey toward a profitable and rewarding career. The course is organized into sections and sub-sections, each designed to break down the material into manageable chunks. After each section, you’ll be asked to answer multiple-choice questions, all of which are based on the content you’ve just reviewed. These questions are meant to test your understanding and ensure that you've grasped the material.
There are no trick questions. The goal is simply to check your knowledge and help you assess your learning.
At the end of the course, you’ll have 100 multiple-choice questions that cover all the sections you've completed. These questions will help you review and apply the information you've learned. Additionally, you'll be asked to submit an action plan as part of your course requirements.



Course Information
This course is exclusively available to new users as part of a developmental learning program. It also includes a Level 2 Digital Marketing Course, which we offer on another platform. You are welcome to register your interest by booking a spot in this course. Once you do, we will contact you with further details on how to enroll in our developmental learning program, which is designed to equip you with all the tools you need to successfully run your own business.



Tip for Success:
 To make the most of this course, set aside dedicated time each day to work on it and stick to a regular schedule. Like many of us, it can be challenging to get back into the habit of studying. It requires structure and discipline. In today’s world, distractions are everywhere—from phone calls to constant notifications. Find a quiet, comfortable space where you can focus and minimize interruptions. This will help ensure that you stay on track and complete the course successfully.

Voncap Academy

Dog Walking & Sitting Course

Dog Walking & Sitting Course V2

This isn’t a course. It’s a consecration. 
A sacred spiral for women in midlife who feel the shift — and are ready to rise.

There comes a moment when the roles you've played no longer fit.  
When the masks feel heavy. When the rhythm you’ve lived by begins to falter.

Not because you’ve failed. But because you’re becoming, something powerful, sovereign, and beautifully indefinable.

You’re not losing yourself. You’re rediscovering the fire that never truly went out.

 🔮 What is Hearth of Hera?

Hearth of Hera is a 7-week live, online spiral for women in midlife who know they’re no longer who they were — but aren’t yet sure who they’re becoming.

It’s not about self-improvement.  
It’s not a coaching programme or a checklist.  
It’s a return — to voice, sovereignty, magic, and self-remembrance.

If you’ve felt the call, your place is already waiting.

🌿 This journey is for you if:

*   You’re in midlife or standing at a powerful threshold moment
    
*   You’ve outgrown old identities, rules, or rhythms that no longer serve
    
*   You want sacred space that honours your depth, sensitivity, and magic
    
*   You’re ready to reclaim your voice — spiritually, creatively, unapologetically
    
*   You crave gentle ritual, beautiful structure, and a pace that honours your energy
    
*   You long for sisterhood without pressure or performance
    
*   You’re tired of trying to be “enough” and just want to be true

No application. No performance.  
Just resonance — and your readiness to return to yourself.

🔥 What You Receive

*   🕯 7 live weekly Zoom circles (Mondays at 6pm BST – replays available)
    
*   🌀 A growing 7-card tarot spread — one new card drawn and explored each week
    
*   📝 Creative prompts and voicework exercises
    
*   🔥 Weekly rituals to support your unfolding (simple and flexible — no pressure)
    
*   🌙 Optional journal and embodiment practices you can explore at your own pace
    
*   📱 A private Telegram group for connection, sharing, and gentle sisterhood
    
Whether you attend live or follow the replays, you’ll be fully held.

✨ The Spiral Path: Your 7-Week Journey

Each week brings a new threshold — a deepening into voice, truth, and sovereignty:

1.  Root the Flame — anchor into belonging and inner ground
    
2.  Ignite the Flow — awaken creative, emotional, and energetic movement
    
3.  Sing the Soul — speak your truth and reclaim the myth you live
    
4.  Name the Boundaries — honour your yes, your no, your sacred edge
    
5.  Clarify the Vision — attune to desire, direction, and knowing
    
6.  Burn the Falsehoods — release what no longer fits or serves
    
7.  Rise to Be Seen — stand whole, witnessed, and unshaken
    
This is not a linear curriculum.  
It is a spiral of becoming — rooted in rhythm, ritual, and resonance.

We begin 7/7.
Come.  
Sit by the hearth.  
Your fire is waiting.

Neptune's Daughter Ltd

Hearth of Hera: A 7-Week Sacred Spiral for Women in Midlife

Bournemouth

Our Virtual (via Zoom) course provide the same high-quality tuition as our classroom-based sessions. Quarterly meetings will take place at the Academy



Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices.

Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse.


Discover the exciting world of dental nursing and be a part of a growing field that offers endless opportunities for growth and development.
How will you learn?
In addition to our traditional class-based tuition, we also offer Virtual (via Zoom) Learning courses to cater to different learning preferences. Our Virtual Learning courses provide the same high-quality tuition as our classroom-based sessions. To participate, you will need a laptop, PC, smart phone or tablet with a built-in or external camera and microphone. From the comfort of your own home, you will have the opportunity to communicate with your tutor and classmates through video chat, using your phone or computer camera. This allows for seamless interaction, discussions, and collaborative learning.

Quarterly meetings at the Academy
To ensure a well-rounded learning experience, you will be required to attend face-to-face lessons at the Academy on a quarterly basis, which means every three months. These sessions serve several important purposes:

Practical Units: Some aspects of the course require hands-on practical training. The face-to-face lessons will cover these practical units, allowing you to gain valuable experience and apply the knowledge you have acquired during the virtual learning sessions.

Tests and Mock Exams: These assessments are important for evaluating your progress, identifying areas for improvement, and preparing you for the final exams. The Academy will provide a controlled and supervised environment to ensure the integrity and fairness of these assessments.
Attending quarterly face-to-face lessons provides a balanced approach to your learning journey. It combines the convenience and flexibility of virtual learning with the benefits of in-person interactions, practical training, and assessments. By participating in these sessions, you will have the opportunity to reinforce your knowledge, receive personalized feedback, and build a stronger connection with your tutor and classmates.
The Academy is dedicated to supporting your growth and success in dental nursing field, and the face-to-face lessons are an integral part of that commitment.



Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others.


The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry.
Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied.

Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care.

Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field.
No previous experience required – we will teach you from A to Z.
Do you need a job?
Yes, you will have 3 months’ time from the start of your course to find a placement.
The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employee in case you need it.
The course is ideal for you if:
You are looking for a qualification that leads to employment
You intend to participate within dentistry and make a positive contribution to the dental health
You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety
You enjoy interacting with multidisciplinary team and different people


The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations!
Free services– workshops, mock exams, eRoE marking and internal moderation.


Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 14 years and looking to recruit more Trainee Dental Nurses.
Working together – At our Dental Department, we prioritise working together with our learners every step of the way. We firmly believe in providing unwavering support, equipping you with the necessary tools, skills, and assistance to ensure your success. We take immense pride in the achievements of our students, with a long list of graduates boasting remarkable success stories. Our commitment to your success serves as the foundation for our own accomplishments
What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work. Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a.
When are the exams?
There are two exams:
1. Multiple choice theory exam. November and March.
2. Practical exam. January and June. 
Record of Experience (eROE)
To be eligible to sit your first exam, you have to complete your electronic Record of Experience (eROE). The eROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. 
London Waterloo Academy supports Mouth Cancer Research Foundation and encouraging learners to raise the awareness and participate in annual 10k walk.



Study mode – virtual (via Zoom) live stream lessons combined with a quarterly meetings Saturday/Sunday at the Academy
Duration – 1 year (part time)
Virtual (via Zoom) classes – once a week
Quarterly meetings at the Academy – date are discussed with the group in advance
Next Intake/start dates (please choose one for your course to start):
21 September 2024, Saturday classes from 9am to 11am
Registration fee – £300 (includes: administration, workshops, mock exams, RoE marking, internal moderation of RoE)
Tuition Fees – £1,400 (we offer payment plan, and accept instalments)
Exam fee – £510 will be charged at the point of candidate registration with NEBDN
One day introduction course – for those who are considering/not sure whether to step up into the Dental Industry £50.00
Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
Office location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk))

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

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

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

General admission

Milton Keynes 

Northampton

Bedford

Liverpool 

NATIONALLY RECOGNISED AND ACCREDITED
LEVEL FOUR CERTIFICATE



This course comprises two parts:
 
Part 1 - online (eLearning)

AND

Part 2 - classroom

Part 2 consolidates on Parts 1 and delivers one full day of practical sessions (skill-set development) - PRP Harvesting and Treatment


Award:
Open College Network (OCN Credit4Learning) - Collegen Induction Therapy - PRP Treatment
LEVEL 4 (FDSc)



A modular "hybrid" course - eLearning (online) theory and one full day classroom based course.
 
PART 1 - THEORY ONLINE

Complete this part of your course online (eLearning Course) in the comfort of your own home or workplace.
Please allow 1-2 full days (approx. 12-16 hours in total) to complete this part of your course.
You do not need to complete this part of the course in one "sitting". Do as little or as much as you wish. Each time you log again exactly where you can start where you left off!
 
You must complete Part 1 before attending Part 2 below.
 
PART 2 - CLASSROOM
Attend in the classroom at the training location that you have selected.
Your classroom tutor will recap on the essential parts of your online course after which you will begin your practical sessions learning and developing the skills required to harvest and use Platelet-Rich Plasma in your treatment plan.
Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary


A hybrid modular course awarding:
OCN Accredited Level Three Certificate (Advanced Level) 3 credits AND

GEOPACE Certificate (Collagen Induction Therapy - PRP Treatment)



Parts 1 (A & B) - online (eLearning) +

Part 2 - PRP Harvesting, Preparation & Treatment (one day)


Theory Sessions:


M01 – Course Overview
Learning outcomes, Understanding recommended guidelines (CPSA, HEE, NICE & WHO), Core Competencies (Domains 1, 2 & 3). National Occupational Standards


M02 – Qualifications – Levels & Thresholds
Understanding the range and applications of treatments at Levels 1 to 8. Equivalencies. Looking at each level and specific treatment types. Competencies at Level 4.


M03 – Culture & Diversity
Understanding culture and diversity within the context of a salon, including opportunities and challenges for aesthetic therapists. Diversity and inclusion. Principles of diversity.


M04 – History, Definitions and Roles
The origins of microneedling and development of PRP, evolution of treatments, types of equipment and range of applications. Historical perspective and modern day examples of PRP therapies.


M05 – Health & Safety & IPC
H&S legislation, Standard Precautions (for blood borne pathogens), Pathogen types, Personal Protective Equipment (PPE), Handwashing and Hygiene, Hazardous Waste Disposal (non-specific), Preventing Needlestick Injuries. A detailed look at viruses, bacteria and fungi. Handling clients with infectious conditions and infestations. Transmission modes. Sterilisation processes in the workplace, including autoclaves.


M06 – Regulatory Obligations
Pathways – employed, contracted and self-employed, Management of H&S at work, Local and national government laws and bylaws, DBS types, Record Keeping, Hazardous Waste Disposal (specific), Insurance and insurance types, Accident reporting, The Keogh Review, HEE guidelines, Professional bodies.


M07 – Professionalism & Effective Communication
Presenting a professional image, guidelines and recommendations. How to effectively communicate with your clients and colleagues, communication methods, communicating efficiently in consultation.


M08 – Consent
Understanding consent types and your client’s capacity to consent. The importance of valid consent. Consent frequency. Risk assessment. Storing consent documentation – looking at paper and digital/cloud. Consent and the law. Determining if consent is robust.


M09 – Environmental and Sustainable Work Practices
Sustainability in the workplace. Running an efficient salon (water efficiency, waste reduction, interior fittings). Advancements including digital options (clients and suppliers).


M10 – Anatomy & Physiology
A&P for collagen induction therapy. Veins, arteries and capillaries (phlebotomy overview). The integumentary system – structure and function. Microneedling – depths and penetration. The lymphatic system. The circulatory system. Skin as a defence barrier. Skin – functions and layers. Merkel cells, Langerhans Cells, Keratinocytes and Melanocytes. The epidermal-melanin unit. Fibroblasts and connective tissue. The effects of ageing. Skin changes over time. Skin rejuvenation including optimising cell function and increasing natural collagen. Inducing regenerative healing. The Fitzpatrick Scale. A detailed look at cell function, specifically melanocytes, keratinocytes and fibroblasts. Microneedling the skin, effects and collagen response. Wound healing – stages (haemostasis, inflammatory, proliferative and maturation). Collagen Induction Therapy (CIT). Topical applications to improve keratinocyte function. Topical applications to improve collagen synthesis.


M11 – Patient Management – Consultation & Examination
Pre-treatment and treatment consultations. Client Motives. Educating your client. Developing a consultation plan. Medical Records. Contraindications & Precautions – Relative and Absolute Contraindications in microneedling. Microneedling and anticoagulants. Side effects and treatment failure. Photo-documentation. Looking at and recording a detailed medical history. Client reviews. Health risks. Legalities.


M12 – Record Keeping
Key points and importance. Understanding how to retain records. Claims - Date of Discovery and Date of Knowledge.


M13 – Platelet Rich Plasma (PRP) – Understanding the basics
Whole blood – composition. Platelets and growth factors (types and functions). What are platelets? Understanding platelet modes of action. Platelet Rich Plasma – preparation. PPP and PRP. PRP Activation and collagen response in vivo. Fibrin network formation. Dermal needle puncture - repair pathway. Examples of microneedling applications. Needle depths and facial skin thickness. Types of treatments – a case by case examination.


M14 – Platelet Rich Plasma (PRP) – Harvesting and Preparation
Phlebotomy. Using correct needle size and anticoagulant. Understanding autologous treatment types with PRP. The treatment agent pathway. Whole blood processing. Harvesting good quality PRP - step by step procedure. Using a centrifuge. Centrifuge operation and management. Steps to minimise platelet trauma. First and second centrifuge processes. Understanding how a centrifuge works? Managing breakage and spillage.


M15 – PRP Treatment – putting it all together!
Client arrival, management, documentation, photography, examination, consultation, consent, treatment plan. Patient ID, where necessary. Referrals and when to refer. Seeking expert advice. Employment types – employed (PAYE), contracted, self-employed (freelance) - detailed look at each. Managing equipment and consumables. Compliancy. Pre-treatment guidance. Medications and drug conflicts. Preparing a treatment area. Preparing your client. Disinfecting the face. Applying numbing cream. Phlebotomy procedures.
Blood handling. Dermapen types and accessories. Treatment modes and actions. Selecting the correct needle depth. Applying PRP and microneedling. Managing pen depth and skin areas. Working within facial zones. Post treatment management. Waste management and correct waste disposal. Post treatment client management. Aftercare. Managing adverse effects. Managing post treatment client expectations. Treatment intervals. Post treatment checklists and patient aftercare guidelines.


Classroom Practical Sessions:
Practical Session 1: Equipment familiarisation - hands-on approach
Practical Session 2: Completing medical forms and consent forms
Practical Session 3: Preparing a treatment area
Practical Session 4: Using a centrifuge
Practical Session 5: Performing a microneedling facial treatment with PRP - model 1
Practical Session 6: Performing a microneedling facial treatment with PRP - model 2


Classroom Support Material:
Support material to complement Modules 1 – 15


Online Support Material:
Downloadable pdf files - support material to complement Modules 1 - 15
Demonstration Video



Geopace Training

Medical Aesthetics

Allied Health

Platelet-rich plasma (PRP)

Aesthetics

Aesthetic Practitioner

Facial Aesthetics

Platelet-rich Plasma (PRP) treatments

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    Open College Network Accreditation

    Level 4 (as required for minimally invasive procedures)

    Covers standards set by HEE

    Employed (salon) or Self-Employed opportunities

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


PRP - Collagen Induction Therapy Course (GPT701)

Register on the Data Structure today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.
The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.
Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion.
The Data Structure course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.
The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!
What You Get With The Data Structure Course
Receive a e-certificate upon successful completion of the course
Get taught by experienced, professional instructors
Study at a time and pace that suits your learning style
24/7 help and advice via email or live chat
Get full tutor support on weekdays (Monday to Friday)
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
Video lessons
Online study materials
Certification
After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.
Who Is This Course For:
The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.
Requirements:
The online training is open to all students and has no formal entry requirements. To study the Data Structure course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.
Course Content
Unit 01: Introduction			
	Module 01: Promo Video		00:02:00
	Module 02: Data Structure Introduction		00:05:00
	Module 03: Computational Complexity Analysis		00:13:00
Unit 02: Arrays			
	Module 01: Static and Dynamic Arrays		00:12:00
	Module 02: Dynamic Arrays Source Code		00:07:00
Unit 03: Liked List			
	Module 01: Singly and Doubly Linked Lists		00:15:00
	Module 02: Doubly Linked Lists Source Code		00:10:00
Unit 04: Stack			
	Module 01: Stack		00:12:00
	Module 02: Stack Implementation		00:04:00
	Module 03: Stack Source Code		00:04:00
Unit 05: Queues			
	Module 01: Queues (Part-1)		00:06:00
	Module 02: Queues (Part-2)		00:06:00
	Module 03: Queue Source Code		00:04:00
Unit 06: Priority Queues (PQs)			
	Module 01: Priority Queues (PQs) with an interlude on heaps		00:13:00
	Module 02: Turning Min PQ into Max PQ		00:06:00
	Module 03: Adding Elements to Binary Heap		00:10:00
	Module 04: Removing Elements from Binary Heap		00:14:00
	Module 05: Priority Queue Binary Heap Source Code		00:16:00
Unit 07: Union Find			
	Module 01: Disjoint Set		00:06:00
	Module 02: Kruskal's Algorithm		00:06:00
	Module 03: Union and Find Operations		00:11:00
	Module 04: Path Compression Union Find		00:07:00
	Module 05: Union Find Source Code		00:08:00
Unit 08: Binary Search Trees			
	Module 01: Binary Trees and Binary Search Trees (BST)		00:13:00
	Module 02: Inserting Element into a Binary Search Tree (BST)		00:06:00
	Module 03: Removing Element from a Binary Search Tree (BST)		00:14:00
	Module 04: Tree Traversals		00:12:00
	Module 05: Binary Search Source Code		00:13:00
Unit 09: Fenwick Tree			
	Module 01: Fenwick Tree Construction		00:06:00
	Module 02: Point Updates		00:06:00
	Module 03: Binary Indexed Tree		00:14:00
	Module 04: Fenwick Tree Source Code		00:06:00
Unit 10: Hash Tables			
	Module 01: Hash Table		00:17:00
	Module 02: Separate Chaining		00:08:00
	Module 03: Separate Chaining Source Code		00:12:00
	Module 04: Open Addressing		00:11:00
	Module 05: Linear Probing		00:14:00
	Module 06: Quadratic Probing		00:09:00
	Module 07: Double Hashing		00:15:00
	Module 08: Removing Element Open Addressing		00:08:00
	Module 09: Open Addressing Code		00:15:00
Unit 11: Suffix Array			
	Module 01: Introduction		00:03:00
	Module 02: The Longest Common Prefix (LCP) Array		00:03:00
	Module 03: Using SA/LCP Array to Find Unique Substrings		00:05:00
	Module 04: Longest Common Substring (LCS)		00:11:00
	Module 05: Longest Common Substring (LCS) Full Example		00:07:00
	Module 06: Longest Repeated Substring (LRS)		00:05:00
Unit 12: AVL Trees			
	Module 01: Balanced Binary Search Trees (BBSTs)		00:09:00
	Module 02: Inserting Elements into an AVL Tree		00:10:00
	Module 03: Removing an AVL Tree		00:09:00
	Module 04: AVL Tree Source Code		00:17:00
Unit 13: Indexed Priority Queue			
	Module 01: Indexed Priority Queue (Part-1)		00:25:00
	Module 02: Indexed Priority Queue Source Code		00:09:00
Unit 14: Sparse Tables			
	Module 01: Sparse Table		00:26:00
	Module 02: Sparse Table Source Code		00:07:00
Frequently Asked Questions
Are there any prerequisites for taking the course?
 There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. 
Can I access the course at any time, or is there a set schedule?
 You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. 
How long will I have access to the course?
 For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. 
Is there a certificate of completion provided after completing the course?
 Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. 
Can I switch courses or get a refund if I'm not satisfied with the course?
 We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. 
How do I track my progress in the course?
 Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. 
What if I have technical issues or difficulties with the course?
 If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution. 

Janets

Online Course Marketing

Online Course Creation

Design & Technology Courses (DT)

Data Structure

Data Structures & Algorithms (DSA)

Trainers Course

Clay Cross

Our intensive 10, 15 or 20 day Total Air Conditioning and Refrigeration training courses have been structured to meet the ever increasing demands on industry to meet safety, environmental and legal requirements regarding installation, commissioning, service and maintenance of both refrigeration and air conditioning systems including the electrical aspects of installation dependent upon course selection. The first 10 days of the Total Air Conditioning and Refrigeration training course are mechanical only, the following 5 or 10 days are the electrical aspects, depending on which route you need to go down. The Total Air Conditioning and Refrigeration training courses are accredited with the City &amp; Guilds 2079, BESA Pipework and Brazing – (commercial), along with an EAL Unit* – Maintenance of Refrigeration Systems from the EAL Certificate in Engineering Technology (QCF) qualification. (*Practical elements will be covered during the course with a Project booklet to be completed by the student with an element of self-study after the course completion for us to claim the Unit certification from EAL). Our Total Air Conditioning and Refrigeration training courses are designed to be as practical as they possibly can be, with workshop time taking more than 70% of the course. During the Total Air Conditioning and Refrigeration training course, you will, install, repair, fault find, adapt and commission on a variety of different equipment, because we believe the way to learn is to do it!! With ALL our courses we offer unbiased technical support and access to a wealth of knowledge and information upon completion. Once you’ve completed your course with Technique, you can be assured that our service doesn’t end there…

10315 Courses

Report Writing 1 Day Training in High Wycombe

By Mangates

Report Writing 1 Day Training in Chelmsford

By Mangates

Real Estate Financial Modelling School

By Bayfield Training

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

By Bayfield Training

Presentation Skills 1 Day Workshop in York

By Mangates

Presentation Skills 1 Day Workshop in Arbroath

By Mangates

Presentation Skills 1 Day Workshop in Ipswich

By Mangates

Presentation Skills 1 Day Workshop in Dublin

By Mangates

Presentation Skills 1 Day Workshop in St Davids

By Mangates

Communication Skills 1 Day Training in Arbroath

By Mangates

Search By Location