Name: Sales Management 2 Days Training in Bolton
Price: 1195 GBP
Availability: InStock

Belfast

<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:
Employee engagement is a necessary strategy for companies that want to succeed in the marketplace.  Employee engagement is not an HR initiative that managers are reminded to do once a year.  It is a key strategic driver of employee performance, accomplishment, and continuous improvement all year long. It is the outcome of how your organisation interacts with people to drive business results.
This Employee Engagement training is suitable for anyone that works in a management or leadership role.
Course Contents:
Help improve the engagement of your employees and increase business success
Engagement is a heightened emotional connection that an employee feels for his organisation, which influences them to put in greater effort. Higher engagement levels yield higher productivity and retention rates. This makes employee engagement a powerful factor in business success. Engaged employees are more productive, customer-focused, and profit-oriented and organisations are more likely to retain them.
An essential part of an organisation’s talent management strategy is its focus on employee engagement and retention. Organisations that maintain this focus create an environment where employees have the tools, resources, and professional opportunities to develop skills and fulfil their career goals.
Why is taking this course a good idea?
Well, just imagine if your you were better able to:
Understand the importance of employee engagement and the key part it plays in business success.
Apply tactics that motivate and engage employees, creating advocates for the business.
Achieve a working environment that encourages employees to excel at work activities.
Ensure talent retention by creating positive working relationships.
Develop a strategy for employee engagement success.
Prevent activities that cause disengagement and disgruntled workers.
Ultimately, these training course materials will help managers to engage and enthuse their team, creating a motivated workforce that wants to succeed.
Employee engagement is a key factor in creating the right conditions for all members of an organisation to give their best each day, committed to their organisation’s goals and values, motivated to contribute to organisational success, and with an enhanced sense of their own well-being.
These course materials aim to help highlight the requirements that managers and leaders have to help improve the engagement of employees, while giving them key tools and supporting content to ensure they are prepared  to deliver on employee engagement within the organisation.
Course Topics:
Introduction and Objectives – Setting the scene for the training course, defining what is meant by employee engagement and establishing participants expectations.
The Current Situations – Using a PEST analysis approach to identify the current status of employee engagement within the organisation, whilst establishing the internal and external factors that can have an impact on employee engagement.
Roles and Responsibilities – Establishing the different roles people have in ensuring employee engagement and the responsibilities that we all have for ourselves in ensuring we are motivated and engaged at work. Participants are encouraged to consider their own level of engagement, what this means and how it can improve.
The Four Enablers – Focusing on the Four Steps to Employee Engagement and how organisations and the leaders within it can create the right environment for a positive outlook to be nurtured. Includes a case study to identify key working practices.
Job Design – Understanding how the implementation of a job role can affect how the employee feels about it and the five characteristics that should be considered to help develop a role that employees are motivated to work in. Includes a chance to apply the five characteristics to a job role to help relate the approach to a real scenario.
Creating the Right Work Environment – Reviewing the big picture and the approach that the organisation and managers should take to ensure a culture of engagement and motivating factors. Creating an environment where employee engagement can flourish and applying techniques to personal work experiences.
Engagement and Retention – Establishing the importance of long-term career growth and opportunity to engagement and how this helps develop employees that feel valued and enjoy what they do each day. Includes a case study to identify how the approach can be applied to real-life scenarios.
Engagement Tactics – Developing an understanding of the tactics that can be applied to employee engagement and prioritising the factors that are most influential.
Disengagement and the Six Human Needs – Identifying how employees become disengaged and what action can be taken to turn this around. Developing knowledge of the fundamental needs that people need to have met to make them feel happy and motivated. Includes a case study that helps participants identify the needs of employees in a real example, while helping them to identify issues within their own team.
Critical Success Factors – Focusing on the engagement techniques that can be applied in the workplace and the critical success factors that managers should include in their strategy and how they might overcome barriers or challenges to their approach.
This course is highly interactive and includes activities, discussions and exercises throughout to both engage the learners and help embed the learning.
Course Feature:
At the end of this Employee Engagement training course you will be able to:
Define and recognise employee engagement
Design jobs to motivate and engage
Create an engaging work environment
Retain your talent
Use employee engagement strategies
Prevent disengagement
Certification:
Once after the training you receive course completion certificate from Mangates.
Who can Attend?
Anybody who is interested in learning Employee Engagement Skills.

Mangates

Employee Engagement 1 Day Training in Belfast

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Bath

Employee Engagement 1 Day Training in Bath

Airdrie

Employee Engagement 1 Day Training in Airdrie

Aberdeen

York

Employee Engagement 1 Day Training in Aberdeen

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

Burton Upon Trent

Certificate: Course Completion Certificate | Language: English

Duration: 2 Days | Credits: 16 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Overview:

A successful sales manager's job is to provide clear direction and support to his/her team  enabling them to excel and develop to reach their full potential.  Sales managers often rise to this position from a successful career in sales. But the skills required of a successful sales manager are quite different from the skills of a sales person which is one of the key points that this program will be focusing on. 

This two day program will enable delegates to have a clear understanding of the successful sales manager's responsibilities and how to become more effective in their roles in this challenging competitive business environment of today. Over the period of the course delegates will explore key leadership skills as well as the essential sales managerial skills needed for them to effectively forecast and implement effective sales plans, motivate, monitor and evaluate the performance of their people and provide the required direction and support ensuring measurable sales results from their sales teams.

This course also includes several bonus forms that were designed to help you prepare your sales forecast and complete sales plan. (Forecast data form, Sales plan support form)

Learning Objectives:

After completing this course, delegates will be able to: 

Understand the roles and responsibilities of a sales manager
Learn skills to achieve better results through their teams using sales plans and targeting techniques
Clearly understand how to prepare a sales forecast and a sales plan for their sales operation
Properly observe, evaluate and give feedback to team members and set performance development objectives using assessment tools supplied and provided within the training program
Explore ways to motivate their sales teams and create a more motivating environment.
Run more effective sales meetings and morning huddles to inspire and motivate and provide clear direction to their sales team members.

Agenda:

Introduction - A sales management primer

What is your job?
Sales Manager Versus Salesman.
The perfect salesperson- Activity

Module 1 : A Strategic look at sales management:
Sales management - is it strategic or tactical?
What are my CSF's? - Critical success factors.
SWOT and PESTLE analysis.

Module 2 : Sales Forecasting:
What is forecasting and how it can help sales performance?
Identify different forecasting methods.
Follow a simple 4 step process to create a sales forecast.
Avoid common forecasting pitfalls.

Module 3 : Sales Planning:
Setting up your sales strategy.
Put together the main components of your sales plan.
Specify sales tactics to achieve strategy.
Sales planning best practice examples.
Practical skill practice activity - Create a sales plan for your sales operation.

Module 4 : Sales performance management:
Setting sales objectives.
The 3 step sales performance control plan.
Guidelines for proper sales performance evaluation.
Handling the underperforming sales team member.

Module 5 : Motivating your sales team:
What motivates us?
Knowing your team inside out.
Creating a motivating environment for your team.
Understand the factors that combine and drive personal motivation.

Module 6 : Running effective sales meetings:
Effective versus badly run sales meetings
Planning your sales meeting sequence.
Successful sales meeting checklist.
Team huddle versus team meeting.

Certification:

Once after the training you receive course completion certificate from Mangates.

Target Audience:

Sales Managers

Sales Management 2 Days Training in Burton Upon Trent

Bournemouth

Sales Management 2 Days Training in Bournemouth

Bracknell

Sales Management 2 Days Training in Bracknell

Bromley

Sales Management 2 Days Training in Bromley

Bolton

Sales Management 2 Days Training in Bolton

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

Microsoft Excel

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)

General Admission

London

<div>
	 <h5>Excel Macros and VBA Course summary</h5>
	 </div>
	 <div></div>
	 
				 
				 For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	 

				 
				 
				 
	 <div>
	 <div>
	 <h5>Excel Macros and VBA Course Description</h5>
	 </div>
	 <div></div>
	 
	 
					 
					 
					 
	 

	 		 Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

						 Setting Excel Macro Options
						 Record and Run Simple Macros
						 Assign Macros to the Quick Access Toolbar

					 Introduction to the Excel VBA Editor

					 Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						 Starting the Visual Basic Editor
						 Using the Project Explorer
						 Using the Properties Window
 

					 Creating Procedures and Functions

					 Create simple macro procedures in code that use variable to store data and communicate with the user

						 Creating Sub and Function Procedures
						 Declare and Use Variables
						 Displaying Message to the User
						 Getting Input from the User

					 Controlling Program Flow

					 Using decision making and looping structures to control the way your program works

						 Using the IF Statement
						 Using the Select Case Statement
						 Using For Next Loops
						 Using Do Loops
						 Using For Next Loops
			 

					 Interacting with the spreadsheet :

						 Referencing Cells and Ranges
						 Gathering Cell and Range Information
						 Using the Offset Method
						 Using With Blocks
						 Referencing Workbooks and Worksheets
						 Updating values in the spreadsheet 

					 Functions

						 Using standard Excel functions in VBA
						 Creating new custom functions
						 Calling functions and sub procedures

					 User Forms

						 Basic design and display
						 Getting information via forms and update cells
					

					 Practical project and examples
					 
					
			 
			<h4>Other Excel Courses</h4>
			 
 
 
 
 
	 </div>
	 <div id="cincluded">
	 <div>
	 <h5>What is included in the Excel VBA Courses:</h5>
	 </div>
	 <div>
	 <ul>
	 <li>Excel VBA Course Certificate on completion </li>
	 <li>Excel VBA Course notes</li>
	 <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	 
	 <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	 <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	 </ul>
	 </div>
	 </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

PCWorkshops

Visual Basic

Access VBA

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

Excel Macros and VBA Course, 1-Hour Taster

General admission

Sixty minute webinar on Rally Regularity Timing covering equipment required, how to keep to time, working out penalties and speed changes, this webinar focuses on styles of regularity that require the use of standard average speed tables. The competitive component of on the public highway historic road rallying, focusing on regularity using average speed tables. Ideal for competitors on events such as HRCR Clubmans Championship or Rally of the Tests

Mastering Regularity Rallying: A 60-Minute Webinar
Elevate your rallying skills with this focused, one-hour webinar designed to boost your confidence in regularity time keeping, essential for competitive historic road rallying on public highways. Dive into the essentials of average speed tables, timing strategies, and control procedures, and gain insider tips for recovering from common mistakes to stay on course. Perfect for competitors aiming to excel in top-tier events like the HERO Rally of the Tests or HRCR Championship rallies, this webinar offers practical insights to enhance your performance. Join us to refine your skills and gain a competitive edge!

Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers

Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. &nbsp;This course will teach you a methodology for working with Excel that exposes how the Excel application works.&nbsp;The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.&nbsp;This instructor-led course includes:&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;&bull; &nbsp; &nbsp;4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;&bull; Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page.We look forward to seeing you in Class!!!

Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. This course will teach you a methodology for working with Excel that exposes how the Excel application works. 
The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.
 This instructor-led course includes: 
• 2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin 
• 4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break. 
• Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session. 
• 1 Capstone Project 
• Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos. 
• Access to our community of life-long learners. 
• Downloadable Certificate you can link to your LinkedIn page.
We look forward to seeing you in Class!!!

dbrownconsulting

Excel Analytics

Master Excel to catapult your productivity skills with this online course. Go from Beginner to Pro in Excel

Power Excel 1 (the essentials)

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.OverviewUpon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.
Overview
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.
This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.
Getting Started with Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter and Edit Cell Data
Fill Cells with Series of Data (AutoFill and Flash Fill)
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions and use Autocomplete
Reuse Formulas and Functions
Create an Absolute Reference
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Move and Copy Data between Cells
Search for and Replace Data
Use Spellcheck and Proofing
Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply and Copy Cell Styles
Apply Basic Conditional Formatting
Printing Workbooks
Preview and Print a Workbook
Controlling Page Layout
Adding Headers and Footers
Set Print Titles and Print Ranges
Managing Workbooks
Manage Worksheets
Insert and Delete Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Nexus Human

Office Skills & Productivity

Office Skills

Microsoft Office

Spreadsheet

Excel - Excel Essentials and Formulas

This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What&#39;s not to like? No more Google searching for the correct shortcut!<ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul> 2 weeks - 2 sessions a week (2hrs live online)<ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">25 June , 27 June , 2 July and 4 July</li></ul>Tuesdays &amp; Thursdays 09:30 - 11:30&pound;275+VAT per person<h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</h2>

This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What's not to like? No more Google searching for the correct shortcut!
Entering text, numbers and Autofill
Navigating Excel
Selecting and editing
Using the Sum function
Basic formulae
Rows, columns and borders
Freezing panes
Printing from Excel
Custom use


2 weeks - 2 sessions a week (2hrs live online)
25 June , 27 June , 2 July and 4 July
Tuesdays & Thursdays 09:30 - 11:30
£275+VAT per person
This course is also available as in-house training at a fixed cost for up to 8 delegates. Email us for more information. admin@sterlingtraining.org.uk

Sterling Training

Performance and efficiency-enhancing Excel skills for everyday users.

Mastering Excel

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forThis course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.OverviewIdentify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.PrerequisitesTo ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.</div><div id="course-pills-2"><h3>1. Using VBA to Solve Business Problems</h3><ul> <li>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul> <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul> <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul> <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul> <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul> <h3>6. Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.
Overview
Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.
Prerequisites
To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.
1. Using VBA to Solve Business Problems
Use Macros to Automate Tasks in Excel
Identify Components of Macro-Enabled Workbooks
Configure the Excel VBA Environment
2. Recording a Macro
Use the Macro Recorder to Create a VBA Macro
Record a Macro with Relative Addressing
Delete Macros and Modules
Identify Strategies for Using the Macro Recorder
3. Writing VBA Code Directly
Write VBA Code
Discover Objects You Can Use
Create a Custom Function
4. Solving Problems through Code
Make Decisions in Code
Work with Variables
Perform Repetitive Tasks
5. Improving Your VBA Code
Debug VBA Errors
Deal with Errors
Improve Macro Performance
6. Controlling How and When Macros Run
Prompt the User for Information
Configure Macros to Run Automatically
Additional course details:
Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Visual Basic Analysis

Microsoft Virtual Academy (MVA)

Trainers Course

VBA with Microsoft Excel

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

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

<h2>Microsoft Excel® in Depth (Virtual)</h2>
 This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.<h3>What you will Learn</h3>
 You'll learn how to:
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul>

Microsoft Excel® in Depth (Virtual)
This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
What you will Learn
You'll learn how to:
Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more
Create meaningful charts
Use pivot tables
Use Conditional Formatting, Data Validation
Take advantage of using Named ranges, do sorting, filtering, tables

458 Courses

Employee Engagement 1 Day Training in Belfast

By Mangates

Employee Engagement 1 Day Training in Bath

By Mangates

Employee Engagement 1 Day Training in Airdrie

By Mangates

Employee Engagement 1 Day Training in Aberdeen

By Mangates

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

By Bayfield Training

Sales Management 2 Days Training in Burton Upon Trent

By Mangates

Sales Management 2 Days Training in Bournemouth

By Mangates

Sales Management 2 Days Training in Bracknell

By Mangates

Sales Management 2 Days Training in Bromley

By Mangates

Sales Management 2 Days Training in Bolton

By Mangates

Search By Location