Name: Communication Strategies 1 Day Workshop in Bracknell
Price: 595 GBP
Availability: InStock

Bracknell

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

Anyone in a position of managing or leading others will benefit from the message delivered by these managing performance training. 

This training set out to help you to manage the performance of your workforce through common sense techniques that focus on the effective use of communication and goal setting to improve productivity and increase morale and motivation. 

The session will steer away from the procedural, form-filling approach to performance management/appraisals and instead focus on the skills required to effectively cooperate with team members, develop their skills and ensure they feel incentivised to succeed. With the techniques outlined in this training course you will feel empowered to enhance the performance of your team and begin to collaborate with them to improve their behaviors and ability in their role. 
Course Contents:
Managing Performance to Increase Productivity with our Quality Training

Management is ultimately about getting things done through others. Without a structured and clear approach to managing performance, where employees know what is expected of them and how they should approach their role, a manager is unable to effectively meet the level of productivity that is required. This will reflect badly on them and can impact on their own development. 

Therefore, managing performance can be one of the single most important things for a manager to get right. This requires a goal-focused, common-sense approach to working with employees that ensures they are motivated and focused on success.

These ‘Managing Performance’ training course materials will provide you with everything you need to develop the skills and build the confidence of your management audience.
 
Ultimately, the aim of these managing performance training course materials is to ensure you have the knowledge and skills to help you develop a team of high performing employees that are focused on success.
Course Topics:
The Importance of Managing Performance – Establishing the key elements to a managing performance approach, why this is important and the benefits it can have for a manager. 

Making Performance Management Work – Changing current perceptions to performance management and highlighting the key factors that will help make it a success for managers. 

Setting Goals – Identifying what makes goal setting work and how it underpins the entire managing performance process. Linking goal setting to record keeping to ensure effective processes.

Reasons for Poor Performance – Highlighting the underlying factors behind poor performance and individual mindsets. 

Helping Poor Performers – Focusing on behaviour and results – translating ‘attitude’ to observed behaviours and looking to create improvement opportunities. Activities that review specific workplace scenarios. 

Developing Average Performers – Knowing values and motivators, what drives performers and how to get the best out of their performance whilst still encouraging them. 

Guiding High Performers – Establishing boundaries, creating opportunities, giving feedback and knowing when to praise. 

Managing Conflict and Discipline – Resolving conflict issues and embracing the opportunity disagreement can provide. Looking at the key components of discipline and following a set structure for implementation. 

The ‘DESC’ Model – Provision of a communication model that assists participants with structuring conversations around performance issues.

Performance Conversations – A practical activity following theoretical set-up that allows participants to practice and review the skills of effective performance communication. 
Who can attend?
Anybody who is interested in learning Managing Skills can attend this training.
Course Feature:
At the end of this managing performance, you will be able to
Manage performance by setting clearly aligned goals that are documented 
Identify causes of poor performance whilst working with employees to improve and develop 
Recognise and communicate success, focusing on behaviour and result
Cooperate with employees in order to increase productivity, morale and motivation.
Certification:
Once after the training you receive course completion certificate.

Mangates

Managing Performance 1 Day Workshop in Bracknell

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Reading

Managing Performance 1 Day Workshop in Reading

Fleet 

Managing Performance 1 Day Workshop in Fleet

Windsor Town

Managing Performance 1 Day Workshop in Windsor Town

Slough

Managing Performance 1 Day Workshop in Slough

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

Basic

Emotional Intelligence (EQ)

Emotional Intelligence 1 Day Training in Slough

Emotional intelligence 1 Day Training in Slough

Emotional Intelligence 1 Day Training in Bracknell

Emotional intelligence 1 Day Training in Bracknell

Course Overview:According to a 1973 survey by the Sunday Times of London, 41% of people list public speaking as their biggest fear. Forget small spaces, darkness, and spiders, standing up in front of a crowd and talking is far more terrifying for most people. Through this workshop you will become more confident and relaxed in front of an audience which will translate into a successful speaking event.However, mastering this fear and getting comfortable speaking in public can be a great ego booster, not to mention a huge benefit to your career. The Public Speaking workshop will give participants some public speaking skills, including in-depth information on developing an engaging program and delivering their presentation with power.Learning Objectives:Inside This Training, You&#39;ll Learn<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Completely remove your stage fear and become a dynamic speaker</li><li fr-original-style="" style="box-sizing: border-box;">Raise your confidence up to a level you never thought to be possible!</li><li fr-original-style="" style="box-sizing: border-box;">Deeper insights into group dynamics</li><li fr-original-style="" style="box-sizing: border-box;">Presentation design, skills &amp; styles</li><li fr-original-style="" style="box-sizing: border-box;">Tools to get your audience to say yes to you</li><li fr-original-style="" style="box-sizing: border-box;">Advanced new behavior patterns required for public speaking</li><li fr-original-style="" style="box-sizing: border-box;">Control time for effective training</li><li fr-original-style="" style="box-sizing: border-box;">Secrets of mind control techniques</li><li fr-original-style="" style="box-sizing: border-box;">Develop your personal winning style</li></ul>Prerequisites:NoneCourse Materials:Attendees will receive a course manual with presentation slides and reference materials.Agenda:Module One: Identifying Your Audience<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Performing a Needs Analysis</li><li fr-original-style="" style="box-sizing: border-box;">Creating an Audience Profile</li><li fr-original-style="" style="box-sizing: border-box;">Identifying Key Questions and Concerns</li></ul>Module Two: Creating a Basic Outline<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Outlining the Situation</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Task That Had to Be Performed</li><li fr-original-style="" style="box-sizing: border-box;">Listing the Actions You Took</li><li fr-original-style="" style="box-sizing: border-box;">Revealing the Results</li></ul>Module Three: Organizing the Program<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Making Organization Easy</li><li fr-original-style="" style="box-sizing: border-box;">Organizational Methods</li><li fr-original-style="" style="box-sizing: border-box;">Classifying and Categorizing</li></ul>Module Four: Fleshing It Out<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Identifying Appropriate Sources</li><li fr-original-style="" style="box-sizing: border-box;">Establishing Credibility</li><li fr-original-style="" style="box-sizing: border-box;">The Importance of Citations</li></ul>Module Five: Putting It All Together<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Writing Your Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Adding a Plan B</li><li fr-original-style="" style="box-sizing: border-box;">Reviewing, Editing, and Rewriting</li></ul>Module Six: Being Prepared<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Checking Out the Venue</li><li fr-original-style="" style="box-sizing: border-box;">Gathering Materials</li><li fr-original-style="" style="box-sizing: border-box;">A 24 Hour Checklist</li></ul>Module Seven: Overcoming Nervousness<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">A Visit from the Boss</li><li fr-original-style="" style="box-sizing: border-box;">Preparing Mentally</li><li fr-original-style="" style="box-sizing: border-box;">Physical Relaxation Techniques</li><li fr-original-style="" style="box-sizing: border-box;">Appearing Confident in Front of the Crowd (Even If You Don&acirc;&euro;&trade;t Feel That Way)</li></ul>Module Eight: Delivering Your Speech (I)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Starting Off on the Right Foot</li><li fr-original-style="" style="box-sizing: border-box;">Using Visual Aids</li><li fr-original-style="" style="box-sizing: border-box;">Checking the Volume of Your Voice</li></ul>Module Nine: Delivering Your Speech (II)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adjusting on the Fly</li><li fr-original-style="" style="box-sizing: border-box;">Gauging Whether Breaks Are Required</li><li fr-original-style="" style="box-sizing: border-box;">Wrapping Up and Winding Down</li></ul>Module Ten: Questions and Answers<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ground Rules</li><li fr-original-style="" style="box-sizing: border-box;">Answering Questions That Sound Like an Attack</li><li fr-original-style="" style="box-sizing: border-box;">Dealing with Complex Questions</li></ul>Module Eleven: Wrapping Up<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Words from the Wise</li><li fr-original-style="" style="box-sizing: border-box;">Review of Parking Lot</li><li fr-original-style="" style="box-sizing: border-box;">Lessons Learned</li><li fr-original-style="" style="box-sizing: border-box;">Completion of Action Plans and Evaluations</li></ul>Target Audience:Anybody who is interested in Public Speaking Skills.Technical Requirements:For eBooks:Internet for downloading the eBookLaptop, tablet, Smartphone, eReader (No Kindle)Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)eBook download and activation instructions

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
This networking skills training will help you to build a professional reputation and develop a network of connections through the two key methods available to you; face-to-face and online.
You will discover how to effectively combine these two approaches and create a strategy for networking success that will generate your own community and actively grow your personal network. This will result in an improved performance in your approach to networking and consequently provide opportunities and prospects that will increase your business success.
The training provides you with the tools and techniques to both plan a successful, strategic approach to networking and develop your personal communication skills, which will ensure you build effective business relationships.
Course Contents:
Effective Networking Strategies and Techniques – Business Networking Training
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We provide you with a comprehensive networking skills training course to make your life easy.
This business networking training is aimed at helping you develop your business or career. You will help ensure you have the skills, knowledge and techniques to develop a joined-up networking strategy that gets you the outcomes you want.
You will also be encouraged to develop the correct behaviours and attitudes to help build your visibility and credibility through networking so that you develop strong working relationships that last.
Course Topics:
Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off as well as some personal revelations about networking
Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital.
Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development.
Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each.
Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums.
Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages.
Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills.
Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room.
Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional.
Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness.
The Follow Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow up email and a chance to develop their own.
Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target.
This training is highly interactive and includes lots of activities and exercises to stimulate discussion and develop learning opportunities.
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We will provide you with a comprehensive networking skills training course to make your life easy.
Course Feature:
At the end of this business networking skills training, you will be able to:
Develop a successful networking strategy
Maximise their effectiveness with face-to-face and online networking opportunities
Improve their approach, attitude and behaviours when networking
Create a plan for networking that will help them meet their goals
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
Anybody who is interested in learning Business Networking Skills.

Networking Skills

Business & Marketing

Business Networking 1 Day Training in Slough

Master Business Networking in Just 1 Day - Join our Workshop in Slough

Wokingham

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:

For the better part of everyday, we are communicating to and with others. Whether it's the speech you deliver in the boardroom, the level of attention you give your spouse when they are talking to you, or the look you give the cat, it all means something. 

The Communication Strategies workshop will help participants understand the different methods of communication and how to make the most of each of them. These strategies will provide a great benefit for any organization and its employees. They will trickle down throughout the organization and positively impact everyone involved.

Learning Objectives:

This workshop will help teach participants how to: 
Identify common communication problems that may be holding them back
Develop skills in asking questions
Identify what their non-verbal messages are telling others
Develop skills in listening actively and empathetically
Enhance their ability to handle difficult situations
Deal with situations assertively

Agenda:

Module One: The Big Picture
What is Communication?
How Do We Communicate?
Other Factors in Communication

Module Two: Understanding Communication Barriers
An Overview of Common Barriers
Language Barriers
Cultural Barriers
Differences in Time and Place

Module Three: Paraverbal Communication Skills
The Power of Pitch
The Truth about Tone
The Strength of Speed

Module Four: Non-Verbal Communication
Understanding the Mehrabian Study
All About Body Language
Interpreting Gestures

Module Five: Speaking Like a STAR
S = Situation
T = Task
A = Action
R = Result
Summary

Module Six: Listening Skills
Seven Ways to Listen Better Today
Understanding Active Listening
Sending Good Signals to Others

Module Seven: Asking Good Questions
Open Questions
Closed Questions
Probing Questions

Module Eight: Appreciative Inquiry
The Purpose of AI
The Four Stages
Examples and Case Studies

Module Nine: Mastering the Art of Conversation
Level One: Discussing General Topics
Level Two: Sharing Ideas and Perspectives
Level Three: Sharing Personal Experiences
Our Top Networking Tips

Module Ten: Advanced Communication Skills
Understanding Precipitating Factors
Establishing Common Ground
Using "I" Messages

Module Eleven: Wrapping Up
Words from the Wise

Target Audience:

Anybody who is interested in learning Communication Strategies Skills.

Communication Strategies 1 Day Workshop in Wokingham


Communication Strategies 1 Day Workshop in Bracknell

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

Chelmsford

Stratford

Our Site Management Safety Training Scheme (SMSTS) refresher training courses, available both online and in-person, are designed for managers and individuals in positions of authority who completed their original SMSTS training program less than three years ago.

Aims
Participants will undertake a concise yet equally engaging training program covering all essential aspects of enforcing health and safety codes of practice at construction sites. Topics include in-depth discussions on risk assessments and effective methods for monitoring and managing industry-specific hazards.
Instructions
For online courses labeled “Remote Learning,” a tutor will deliver the training via video call.
All SMSTS courses are delivered and assessed in English. Participants must have a good command of the language to successfully complete the program.
Additional attendee information will be provided via email. Please ensure you check your inbox.


SMC Safety Solutions

Site Management Safety Training Scheme (SMSTS) Refresher

General Admission

This one-day course is a must for anyone considering or already working within a construction or civil engineering environment. This course provides Health and Safety awareness and is endorsed by Build UK as a standard training for all operatives on site.
Aims
To give a clear understanding of Regulations & Legislation that applies to construction work and is an ideal refresher for any operative that has previously completed training in Health & Safety.
Course Content
• Accident prevention
• Health & Safety law
• Control and management of the site and your how your role fits in with this
• Risk assessments and method statements
• Performing safely on site
• Reporting unsafe acts to prevent an accident
• Individual & employee responsibilities
• What to do if you think anyone’s Health and Safety is being put at risk
Assessment
At the end of this course, all delegates will have a clear understanding of the requirements of Health and Safety Legislation and their responsibilities to comply with them.
Candidates will need to complete a multiple-choice exam at the end of the CITB course. They will also need to engage and interact with others throughout the day.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all operatives. The certificate is part of CSCS Green Card requirements.
To remain certified in this area, you will need to retake the course before the expiry date or have completed an NVQ2 or higher in your skills set.
Instructions
Please note all Health & Safety Awareness courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Health & Safety Awareness (for Green CSCS)

The professional working world has changed more rapidly than could have been envisaged at the time of the introduction of GDPR and the Data Protection Act 2018. With more people working from home post-Covid and the ever increasing risk of cyber-attacks, this short course is aimed at taking stock of current practice and risk, as well as considering ICO enforcement action and the implications of hybrid working. &nbsp;It is also a great recap on the rules as they stand and what you need to know to comply. &nbsp;The course will cover:<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">UK GDPR - A timely reminder of the rules</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">ICO enforcement action and what we can learn</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Data Protection Impact Assessments - when and how to do them</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Hybrid working and UK GDPR</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing cyber attacks from a UK GDPR perspective</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Target Audience</h2><p data-key="23" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlRhcmdldCUyMEF1ZGllbmNlJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhlJTIwb25saW5lJTIwY291cnNlJTIwaXMlMjBzdWl0YWJsZSUyMGZvciUyMHN0YWZmJTIwb2YlMjBhbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwc3VwcG9ydCUyMHN0YWZmJTIwdG8lMjBzZW5pb3IlMjBwYXJ0bmVycy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The online course is suitable for staff of all levels, from support staff to senior partners.<h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 data-key="37" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="http://dglegal.co.uk/the-team/matthew-howgate/" style="color: rgb(0, 140, 165); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 140, 165);">Matthew Howgate, Consultant, DG Legal</a></h3>Matt is a non-practising solicitor who has considerable experience in regulatory issues and advising on complex issues of compliance and ethics. He is also an expert in data protection, UK GDPR and on the civil legal aid scheme.Matthew is a lead trainer on and co-developed the LAPG Certificate in Practice Management (a training programme for legal managers and law firm owners) as well as regularly providing training on legal aid Supervision, costs maximisation, data protection and security and on general SRA compliance. &nbsp;

Managing people and teams is consistently the biggest challenge raised by new managers (and even many experienced managers). This 3 hour course is aimed at introducing new and existing supervisors and managers to key supervisory skills, allowing them to develop their competence as supervisors. The course covers:

Understanding your role as a supervisor
SRA obligations and competence expectations
Setting expectations and effective delegation
Monitoring progress and quality
Managing performance in difficult situations
Top tips for impactful feedback

By the end of this course participants will have had an opportunity to consider their current skills; develop new skills; and think about further development needs.
Target Audience
This online course is aimed at managers, team leaders and other supervisors.  

Please note that this course does NOT meet the LAA requirements as a Supervisor Course. If you need a Legal Aid Supervisor course, then please check out our Supervision & Managing Performance Course. 
Resources
Course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.

Please note a recording of the course will not be made available.
Speaker
Matthew Howgate, Consultant, DG Legal
Matt is a non-practising solicitor who has considerable experience in regulatory issues and advising on complex issues of compliance and ethics. He is also an expert in data protection, UK GDPR and on the civil legal aid scheme.

Matthew is a lead trainer on and co-developed the LAPG Certificate in Practice Management (a training programme for legal managers and law firm owners) as well as regularly providing training on legal aid Supervision, costs maximisation, data protection and security and on general SRA compliance. 

DG Legal

Team Leader

Supervising Your Team Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

Facilitated by: Teresa Nightingale, HIGN trustee and Income Generation &amp; Marketing Director, Wirral Hospice St John&rsquo;s.Sharing and networking session.<div fr-original-style="" style="box-sizing: border-box;"> </div><div fr-original-style="" style="box-sizing: border-box;">Q2 Reporting THIS SESSION WON&#39;T BE RECORDED. <div fr-original-style="" style="box-sizing: border-box;"> Session aimed at fundraising leaders: Directors | Heads of | Leads | Managers</div></div>

Training & Networking - Getting ready for the NEW Code of Fundraising Practice

This session highlights the main changes in the NEW Code of Fundraising Practice that comes into effect on 1 Nov 2025.

It will also give tips about what hospices need to be doing to be compliant.





John Brady

John is a highly experienced fundraising manager and leader with over 25 years of experience, the last 20 being at the most senior level in the organisation worked in. 

Working as a Senior Leader, Executive Director or Chief Executive he has a wide range of experience of managing and leading teams, strategic development, financial analysis, fundraising compliance and management of a broad range of fundraising specialisms such as Events, Trusts and Foundations, Corporate, Charity Retail, Individual Giving and Legacies, with specialist experience within Individual Giving. That has included introducing or developing regular giving programmes, managing gaming products such as society weekly lotteries and raffles, developing or creating direct mail programmes and telephone campaigns.

John’s first professional fundraising role was as Divisional Manager at the British Lung Foundation (now Asthma and Lung UK) and has worked for a number of other charities including, Alcohol Focus Scotland, Sense Scotland, Erskine, and as Chief Executive of OneKind. John’s last role was at St Andrew’s Hospice where he led income growth in Individual Giving by leading the introduction of an Appeals programme and the tripling of the Lottery to £1.1 million per year.

John joined the sector in 1998 following the death of his younger brother at a young age due to stomach cancer. This instilled in John a passionate belief about the difference charities can make to making the world a better place somehow.

John champions ethical fundraising and so joined the Chartered Institute of Fundraising becoming chair of the Institute of Fundraising in Scotland and was made a Fellow in 2016. He was a member of several committees and working groups focussing on reviewing and enhancing fundraising regulation and compliance. He has been a Board member of the Hospice Income Generation Network and Enable Scotland and is currently Chair of Enable Trustee Services.

Hospice Income Generation Network

Wed 16 July: Getting ready for the NEW Code of Fundraising Practice

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)

Chesterfield

<h2 data-css="tve-u-1724b1fded6" id="isPasted" fr-original-style="" style="box-sizing: border-box;">QA Level 1 Award In Health And Safety In The Workplace (RQF)</h2><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-1724b1fde88" fr-original-style="" style="box-sizing: border-box;">Face to Face: Half-day course</li><li data-css="tve-u-1724b1fde88" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1756ab31da2" fr-original-style="" style="box-sizing: border-box;"></div>Virtual Classroom: Spread over 2 sessions of 2&frac12; hr duration</li><li data-css="tve-u-1724b1fde88" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1724b1fde85" fr-original-style="" style="box-sizing: border-box;"></div>A basic course to train your workers in basic health and safety</li><li data-css="tve-u-1724b1fde88" fr-original-style="" style="box-sizing: border-box;">Teaches workers how to keep themselves and others safe at work</li></ul><h3 data-css="tve-u-1724b1fdeca" id="isPasted" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Course Contents:</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;">Roles and responsibilities of employers and employees</li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>The importance of health and safety in the workplace</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>Workplace hazards and Risks, including:<ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>Slips, Trips and Falls</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;">Manual Handling</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;">Fire</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;">Working from Height</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;">Electricity</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;">Hazardous Substances</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;">Machinery and Vehicles</li></ul></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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>Workplace conditions that can affect health and safety</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>Health and Safety Signage</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-1724b279d92" fr-original-style="" style="box-sizing: border-box;"></div>Personal Protective Equipment and its uses</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-1724b279e6b" fr-original-style="" style="box-sizing: border-box;"></div>Importance of Personal hygiene</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-1724b279f22" fr-original-style="" style="box-sizing: border-box;"></div>The Purpose of First Aid Provision</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-1724b279fce" fr-original-style="" style="box-sizing: border-box;"></div>The need for Reporting Incidents and ill Health</li></ul><h3 data-css="tve-u-1724b1fde93" id="isPasted" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Benefits of this 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;">In 2018/19, 1.4 million people suffered from a work-related illness</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>581,000 sustained an injury</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>147 People lost their lives</li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>The estimated cost of injuries and ill health last year was &pound;15 billion</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>It is an employer&#39;s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk</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-1724b1fded9" fr-original-style="" style="box-sizing: border-box;"></div>Our QA Level 1 Award in Health and Safety in the Workplace (RQF) course helps employs gain a bit more understanding of health and safety issues and their own role within that</li></ul><h3 data-css="tve-u-1724b1fde81" id="isPasted" style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);">Accredited, Ofqual regulated qualification:</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/d4bd1328-0561-4a59-aef0-01af2e9666f7/original.png" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; 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 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">Our Health and Safety Training Course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;<a href="https://qualsafeawards.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);">Qualsafe Awards</a>. This means that you can be rest assured that your Health and Safety Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in Health and Safety. The&nbsp;Ofqual Register number&nbsp;for this course is&nbsp;603/0774/2</div><div fr-original-style="" style="box-sizing: border-box;"> </div>

QA Level 1 Award In Health And Safety In The Workplace (RQF)
Face to Face: Half-day course
Virtual Classroom: Spread over 2 sessions of 2½ hr duration
A basic course to train your workers in basic health and safety
Teaches workers how to keep themselves and others safe at work
Course Contents:
Roles and responsibilities of employers and employees
The importance of health and safety in the workplace
Workplace hazards and Risks, including:Slips, Trips and FallsManual HandlingFireWorking from HeightElectricityHazardous SubstancesMachinery and Vehicles
Workplace conditions that can affect health and safety
Health and Safety Signage
Personal Protective Equipment and its uses
Importance of Personal hygiene
The Purpose of First Aid Provision
The need for Reporting Incidents and ill Health
Benefits of this course:
In 2023/24, 1.7 million people suffered from a work-related illness
600,000 sustained a non-fatal injury
138 People lost their lives
776,000 Workers suffered from work-related stress, depression or anxiety
The estimated cost of injuries and ill health last year was £21.6 billion
33.7 million working days, or 140,417 working years, were lost due to work-related illnesses and injuries
It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk
Our QA Level 1 Award in Health and Safety in the Workplace (RQF) course helps employs gain a bit more understanding of health and safety issues and their own role within that.
Accredited, Ofqual regulated qualification:

Our Health and Safety Training Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.

This means that you can be rest assured that your Health and Safety Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in Health and Safety.

The Ofqual Register number for this course is 603/0774/2

Pochat Training

Occupational Health & Safety

Health & Wellbeing

Compliance & Safety

Occupational Health & Wellbeing

Corporate Safety

Functional Safety

Health & Safety Awareness

Workplace Health & Safety

Health & Safety

Health & Safety At Work

Occupational Health

Health And Safety In The Workplace, Level 1

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

This five-day course is a must for anyone who is considering or already working in a role with site manager responsibilities. This course covers all relevant legislation affecting safe working in the building, construction, and civil engineering industries.
It is endorsed by Build UK as the standard training for all construction managers.
Aims
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
• Health, safety, welfare and environmental legislation affecting your daily work
• New guidance and industry best practice
• Duties and responsibilities with regards to health, safety, welfare, and the environment
• Safe working
Prerequisites
This course is for you if you’re considering, or already have management responsibilities for planning, organising, monitoring, controlling and administering groups of staff e.g. site manager.
Assessment
At the end of this course, all delegates will have a clear understanding of controlling health and safety on site from a manager’s role.
Certificate
The certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all site managers.
To remain certified in this area, you will need to take a refresher course before the expiry date on your certificate, otherwise the full course will need to be retaken.
Instructions
Please note all online Site Management Safety Training Scheme courses with the venue “Online” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Site Management Safety Training Scheme (SMSTS) 5 day course

Presentation on&nbsp;Palliative Care Management of Parkinson&#39;s Disease by Emma Sugrue

'Interventional Pain Medicine applied to Palliative Care Patients' by Dr Andrew Jones, Consultant Anaesthetist. 

This presentation will cover a brief background of the Hospice movement, the mechanisms of pain in the brain and spinal cord will be discussed. The limitations of pain medication will be presented. Thus, interventional pain techniques may have value for patients whose pain is not controlled. The interventional techniques available will be shown.

Dr Jones, qualified in 1982 from Barts Hospital in London and after a wide range of junior roles in different specialties he started training in Anaesthesia in Merseyside. He had always been interested in the treatment of pain and was able to pursue further training in Pain Medicine. Andy became a consultant anaesthetist in 1994 and in addition a consultant in Pain Medicine in 1996. The rest is history.

1320 Management courses in Wokingham

Managing Performance 1 Day Workshop in Bracknell

By Mangates

Managing Performance 1 Day Workshop in Reading

By Mangates

Managing Performance 1 Day Workshop in Fleet

By Mangates

Managing Performance 1 Day Workshop in Windsor Town

By Mangates

Managing Performance 1 Day Workshop in Slough

By Mangates

Emotional intelligence 1 Day Training in Slough

By Mangates

Emotional intelligence 1 Day Training in Bracknell

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Slough

By Mangates

Communication Strategies 1 Day Workshop in Wokingham

By Mangates

Communication Strategies 1 Day Workshop in Bracknell

By Mangates

Search By Location