Name: Microsoft Excel - Getting Started
Price: 99 GBP
Availability: InStock

Management

Within the basic four&nbsp;colour&nbsp;energies are contained two sets of opposites.Underlying each pair of opposites there is a TENSION.This tension acts like a force, just like gravity. &nbsp; You cannot see&nbsp;it,&nbsp;you cannot hear it or touch it with your hands. &nbsp; You will, however, experience the impact of the tension.We each make a choice in how we perceive this tension. &nbsp;We can choose to be proactive and use this tension to create win/win outcomes. &nbsp;We can choose to be reactive and disconnect from the energy viewing it as a negative.The choice we make determines our results.It is important to remember, we make our own choice. &nbsp; The person who represents your opposite energy is not responsible for your choice.When you&rsquo;re proactive in engaging with this tension you achieve successful dynamics. &nbsp;Become reactive with this tension and you will experience dysfunctional dynamics.<img src="https://images.cademy.co.uk/24bd9347-eb1e-4a9c-87b0-bc006b591fe3/af498831-25fb-4d00-8dd0-b9467a6a4096/original.jpeg" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right;" fr-original-class="fr-draggable"> The Opposite Colour EnergiesBlue &amp; Yellow are Opposite&nbsp;ColoursThe tension between Blue energy &amp; Yellow energy is based around&nbsp;IDEAS&nbsp;and&nbsp;PROCESSES.Red &amp; Green are Opposite&nbsp;ColoursThe tension between Red energy &amp; Green energy is based around&nbsp;TASKS&nbsp;and&nbsp;PEOPLE.

Within the basic four colour energies are contained multiple sources of tension.
Each adjacent colour can work in harmony or result in conflict.  Mastering your ability to work with all the colour energies is a powerful way to transform your performance.
This tension acts like a force, just like gravity. You cannot see it, you cannot hear it or touch it with your hands. You will, however, experience the impact of the tension.
We each make a choice in how we perceive this tension. We can choose to be proactive and use this tension to create win/win outcomes. We can choose to be reactive and disconnect from the energy viewing it as a negative.
The choice we make determines our results.
It is important to remember, we make our own choice. The person who represents your adjacent or opposite energy is not responsible for your choice.
When you’re proactive in engaging with this tension you achieve successful dynamics. Become reactive with this tension and you will experience dysfunctional dynamics.

/
The Opposite Colour Energies
Blue & Yellow are Opposite Colours
The tension between Blue energy & Yellow energy is based around IDEAS and PROCESSES.
Red & Green are Opposite Colours
The tension between Red energy & Green energy is based around TASKS and PEOPLE.

colour-energies.com

Team Building

Insights

Insights Discovery

Gain insights into how to master the dynamics of the opposite colour energies and see the dynamics within your team shift towards healthy relationships.  Watch as your bottom line improves as suddenly more is getting done in a smarter way.

Mastering the Dynamics of the Colour Energies

General Admission

Early Bird Discount

Microsoft PowerPoint is a global standard for the presentation of ideas through visuals and text. In this class, you will gain a hands-on introduction to some of the core functionality of PowerPoint:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Learn the terminology of Microsoft PowerPoint</li><li fr-original-style="" style="box-sizing: border-box;">Develop the skills to create and work with basic presentations</li><li fr-original-style="" style="box-sizing: border-box;">Explore the PowerPoint Window</li><li fr-original-style="" style="box-sizing: border-box;">Add Content to a Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Work with PowerPoint Views</li><li fr-original-style="" style="box-sizing: border-box;">Moving from Slide to Slide</li><li fr-original-style="" style="box-sizing: border-box;">Modify a Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Apply a Theme to a Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Create a Presentation from a Template&nbsp;</li></ul>This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

AXIOM Learning Solutions

Office Skills & Productivity

Computer Skills

Microsoft Office

Microsoft Powerpoint

Presentation Skills

Microsoft PowerPoint- Getting Started

Learn to enhance PowerPoint presentations by formatting text and text placeholders. You will learn to: <ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Apply bullet or number formats</li><li fr-original-style="" style="box-sizing: border-box;">Format placeholder fills and lines</li><li fr-original-style="" style="box-sizing: border-box;">Copy formatting with the Format Painter</li><li fr-original-style="" style="box-sizing: border-box;">Insert and format pictures</li><li fr-original-style="" style="box-sizing: border-box;">Format the slide background</li><li fr-original-style="" style="box-sizing: border-box;">Apply and manipulate themes</li><li fr-original-style="" style="box-sizing: border-box;">To use the&nbsp;slide master to change the default formatting for all slides in a presentation</li><li fr-original-style="" style="box-sizing: border-box;">save your formatting choices as a custom theme for use in future presentations&nbsp;</li></ul>This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Certified Trainer (MCT)

Microsoft PowerPoint - Formatting Presentations

Learn to organize your worksheets effectively by adding, deleting, moving, copying, and renaming them in workbooks. In addition, learn how to move and copy worksheets to other workbooks, group worksheets for data entry, editing and formatting, create a formula with a 3-D reference, hide and unhide worksheets and formulas, and printing options. Learn to save workbooks and worksheets as templates, work with workbook protection, and set workbooks up for sharing.&nbsp;<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Office Skills

Excel Analytics

Microsoft Excel

Spreadsheet

Microsoft Excel - Working with Workbooks

This class will teach you how to create compelling data visualizations using Microsoft Excel. You will learn to create several types of professional-looking charts in Excel, identify chart elements, set up the source data, select the data to include on a Chart, learn ways to create Charts, work with Chart Layouts and Quick Layouts, learn to modify, add, and format charts to enhance the presentation of your data, change the data source, save a Chart as a Chart Template, and print Charts.<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Creating Charts

Learn the basics of using the Visual Basic for Applications (VBA) programming language to create macros in Excel. Learn the limitations of the macro recorder, work with the Excel Object model and the Visual Basic Editor. &nbsp;You will write some basic code, edit code, learn about basic logic and looping, step through code and work with a custom function.&nbsp;<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Automating Tasks by Programming in VBA

Pivot Tables and Pivot Charts are one of Microsoft Excel&#39;s most popular and powerful features.In this class, you will learn how to analyze and summarize worksheet data using pivot tables and pivot charts using the Recommended Pivot Table feature and the Blank Pivot Table command. &nbsp;In addition, you will learn to format, sort, filter, filter with Slicers and Timelines, refresh data, change the data source, group dates, drill down your data and create a Pivot Chart.This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Pivot Table

Data Visualization

Microsoft Excel - Pivot Tables

Learn additional functions and formulas to become a more expert Excel user.This class will give you hands-on instruction as you work with the IF, nested IF and IF/AND logical functions, the TRIM, PROPER, CONCATENATE, TEXT, LEFT, RIGHT, and MID text functions, VLOOKUP with an approximate and exact match, separating text into columns, and the SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS conditional functions to process worksheet data more efficiently.&nbsp;This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - More Functions and Formulas

In Microsoft Excel, related data can be organized using a range of cells. This class provides an overview of list and table design techniques. You will learn:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Procedures to sort, filter and validate data</li><li fr-original-style="" style="box-sizing: border-box;">How to use formulas in lists and tables</li><li fr-original-style="" style="box-sizing: border-box;">How to identify and remove duplicate records</li><li fr-original-style="" style="box-sizing: border-box;">How to use the subtotal and outline features</li></ul>This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Lists and Tables

In this introduction to Microsoft Excel, you will learn the terminology and capabilities of Excel. This class covers an introduction to the Excel application and interface. You will learn:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">How to create and work with Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">How to navigate in a Worksheet</li><li fr-original-style="" style="box-sizing: border-box;">How to enter, delete and select data</li><li fr-original-style="" style="box-sizing: border-box;">How to undo/redo actions</li><li fr-original-style="" style="box-sizing: border-box;">How to control your view, including zoom in/out</li><li fr-original-style="" style="box-sizing: border-box;">How to create simple calculations</li><li fr-original-style="" style="box-sizing: border-box;">How to do basic sorting, moving and copying data</li><li fr-original-style="" style="box-sizing: border-box;">How to set print settings and explore print preview</li></ul>This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Getting Started

Plymouth

Transform Your Stress into Strength and Thrive in Any Situation!

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

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

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

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





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




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




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




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




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




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

Eyes Up Training Limited

Stress Management

Emotional Resilience

Mental Resilience

Mental Health At Work

Resilience

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

Thrive Under Pressure: Resilience Skills for Stressful Work Environments

20% discount if you book before 29th April

Early Bird

Standard Admission

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

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



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



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






Pochat Training

Food Safety

Food Allergy

Accredited Food Hygiene

Food Allergen

Accredited Food Safety

Introduction to Food Intolerances

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Oldham

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

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

Export Unlocked Limited

International Trade

British Chambers of Commerce (BCC)

Export Management

Customs

European Code for Navigation on Inland Waterwaysevni (CEVNI)

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

INWARDS & OUTWARD PROCESSING AND RETURNED GOODS RELIEF

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



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


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


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


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


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


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


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

Real Estate Finance

Financial Risk Management

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

Real Estate Developer (Development Cash Flow Modelling in Excel)

Mental Health and Wellbeing Training Courses
Building resilience
CPD Accredited, Interactive Workshops

Enquire about this course
2-5 hour workshops
Suitable for anyone who'd like to improve their mental wellbeing and resilience
Giving them the chance to cope with life's challenges


Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Physical Wellbeing

Wellbeing

Building Resilience

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



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


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


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


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


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


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

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

Chesterfield

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

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

Mental Health Awareness

Mental Health First Aid

Mental Health

Accredited Mental Health First Aid

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

Mental Health First Aid Annual Refresher

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

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

Trade

Import/Export

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

IMPORT/EXPORT DIAGNOSTICS CREATING A PROCEDURE MANUAL

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

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

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

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

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

12:30 Lunch break 

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

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

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

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

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

  

Psychotherapy For Healthcare Ltd

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

1313 Management courses in Cardiff delivered Live Online

Mastering the Dynamics of the Colour Energies

By colour-energies.com

Microsoft PowerPoint- Getting Started

By AXIOM Learning Solutions

Microsoft PowerPoint - Formatting Presentations

By AXIOM Learning Solutions

Microsoft Excel - Working with Workbooks

By AXIOM Learning Solutions

Microsoft Excel - Creating Charts

By AXIOM Learning Solutions

Microsoft Excel - Automating Tasks by Programming in VBA

By AXIOM Learning Solutions

Microsoft Excel - Pivot Tables

By AXIOM Learning Solutions

Microsoft Excel - More Functions and Formulas

By AXIOM Learning Solutions

Microsoft Excel - Lists and Tables

By AXIOM Learning Solutions

Microsoft Excel - Getting Started

By AXIOM Learning Solutions