Bradford On Avon

<div style="color: rgb(34, 34, 34); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34);">I am able to travel to you to help you develop your partnership with your horse. I specialise in developing confidence in both horse and rider both on the flat and over fences. As a list 5 BD Dressage judge I can help you with test riding for BD Intro, Prelim and Novice tests. I can help with BE 90, 100 &amp; Novice tests.As I am training for list 4 I can also help you with Elementary BD and Intermediate BEThe times listed are a general guide of my availability. If you would prefer a time that is not listed please select the time that is closest to you preference, the message me via Email, WhatsApp or Facebook to see if we can arrange a better time for you.</div><div style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><h4 style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Instructions</h4>Make sure we have access to an arena, with a poop scoop and poles if you want them.</div>

I am able to travel to you to help you develop your partnership with your horse.
I specialise in developing confidence in both horse and rider both on the flat and over fences.
As a list 5 BD Dressage judge I can help you with test riding for BD Intro, Prelim and Novice tests. I can help with BE 90, 100 & Novice tests.
As I am training for list 4 I can also help you with Elementary BD and Intermediate BE
The times listed are a general guide of my availability. If you would prefer a time that is not listed please select the time that is closest to you preference, the message me via Email, WhatsApp or Facebook to see if we can arrange a better time for you.
Instructions
Make sure we have access to an arena, with a poop scoop and poles if you want them.

Ros D Equine

Equine

Ros Equine Coach - 1 to 1 coaching at your yard

General admission

Peterborough

Welcome to our Emergency First Aid at Work Level 3 (VTQ) qualification (EFAW), the perfect solution for businesses or individuals identifying minimal first aid needs in their workplace.&nbsp;Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.Throughout the day, you&#39;ll delve into a range of topics, from assessing and managing incidents to administering life-saving techniques. Guided by our expert instructors, you&#39;ll learn how to respond promptly to injuries, illnesses, and accidents that may occur in the workplace or everyday life.Interactive demonstrations, practical exercises, and real-life scenarios ensure that you not only understand the theory but also gain hands-on experience in applying first aid techniques. Whether it&#39;s CPR, bandaging wounds, or dealing with burns and fractures, you&#39;ll leave feeling empowered and ready to spring into action when needed.Our course content aligns with the latest guidelines from the Health and Safety Executive (HSE) and meets the requirements of the First Aid at Work regulations. Upon completion, you&#39;ll receive a certification that&#39;s valid for three years, giving you and your employer peace of mind knowing that you&#39;re fully prepared to handle emergencies with confidence.Join us for a day of learning, collaboration, and skill-building that could make all the difference in a critical moment. Together, let&#39;s create safer and more resilient workplaces.For individuals seeking employment in door supervision and security guard roles, rest assured, the SIA accepts our training certificate.Our first aid courses adhere strictly to the UK and European Resuscitation Council Guidelines 2021, fulfilling HSE requirements. Recognized by the HSE as Trade Body Qualifications, our Vocational Training Qualifications (VTQ) are your assurance of quality.This course is suitable for:Our one-day First Aid course is suitable for a wide range of individuals who want to be prepared to handle emergencies effectively in the workplace or in everyday life. Here&#39;s who can benefit from booking this course:<ul style="color: rgb(13, 13, 13); box-sizing: border-box;" fr-original-style="color: rgb(13, 13, 13);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Employees: Any employee in any industry can benefit from gaining first aid skills. From office settings to construction sites, having trained individuals can make a significant difference in emergency situations.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Managers and Supervisors: Managers and supervisors play a crucial role in ensuring workplace safety. By undertaking this course, they can lead by example and be prepared to respond to emergencies promptly.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Small Business Owners: Small business owners often wear many hats, including that of a first aider. Being trained in first aid can help them protect their employees and customers in case of emergencies.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Teachers and Educators: Those working in educational settings can benefit greatly from first aid training. Whether it&#39;s dealing with playground accidents or classroom injuries, having first aid skills can be invaluable.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Parents and Caregivers: First aid is not just for the workplace; it&#39;s essential for everyday life, especially for parents and caregivers. Knowing how to respond to injuries or medical emergencies involving children or family members can be life-saving.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Community Groups and Volunteers: Community groups, sports clubs, and volunteers often find themselves in situations where first aid knowledge is crucial. Whether it&#39;s during events, outings, or community projects, having trained individuals can provide peace of mind.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Health and Fitness Professionals: Trainers, coaches, and fitness instructors can benefit from first aid training to ensure the safety of their clients during workouts or sports activities.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Anyone Interested in Personal Development: Learning first aid is a valuable life skill that can boost confidence and empower individuals to make a difference in their communities.</li></ul>No matter your background or profession, if you want to be prepared to respond effectively to emergencies and potentially save lives, our First Aid course is for you.


First Aid at Work 18-Hour Classroom Course
Become a fully trained first aider in your workplace with our First Aid at Work Level 3 (VTQ) qualification. This course is designed for both businesses and individuals who require a fully trained first aider, as identified by their risk assessment or personal need for workplace first aid training. 
Perfect for those looking to meet workplace health and safety requirements, this course provides all the essential first aid skills and more, ensuring you're fully prepared to respond to medical emergencies at work.
We can offer this course as an open course to everyone to book, or on request, we can offer the course for group bookings up to six in a group at the price of £180 per person or up to twelve in a group at the price of £150 per person.
Course Overview
The First Aid at Work (FAW) qualification is recognised by the HSE and meets the requirements of the First Aid at Work Regulations 1981 and subsequent changes. This 18-hour course is delivered over a minimum of 3 days and ensures participants gain the knowledge and practical skills needed to confidently manage a range of medical emergencies in the workplace. Upon successful completion, candidates receive a certificate valid for 3 years.
Learning Outcomes
By the end of the course, participants will be able to:
Assess the scene and manage a first aid emergency.
Administer CPR and use the recovery position.
Provide first aid for choking, bleeding, burns, fractures, and other injuries.
Recognise and treat medical conditions such as heart attacks, strokes, asthma attacks, and more.
Safely manage incidents involving electric shock, poisoning, and anaphylaxis.
Course Features
CPD-accredited certification, valid for 3 years.
18 contact hours of classroom-based training, delivered over a minimum of 3 days.
Meets all the requirements set by the HSE and European Resuscitation Council.
Recognised by the SIA for those in the door supervision and security guard sectors.
Available as a regulated qualification through ProTrainings or as a Vocational Training Qualification (VTQ).
Access to an extensive video library for refreshing your skills and referencing when needed.
Blended Learning Option
If you're looking to save time and reduce costs, you can opt for our blended learning option. Complete the theoretical portion of the course online at your own pace, followed by 2 days of classroom training. This approach provides flexibility without compromising the quality of your training.
Who Should Take This Course?
Employers and employees who need to meet workplace first aid requirements.
Those in the door supervision and security guard sectors seeking SIA certification.
Organisations looking to ensure their staff are trained in workplace first aid.
Certification
Upon successful completion of the course, you will receive:
Certificate valid for 3 years.
CPD-accredited statement.
Course Content
The course is divided into key units:
Role and Responsibilities of the First Aider: 
Understand the first aider’s role and responsibilities in the workplace.
Conduct risk assessments and manage first aid emergencies.
Managing Medical Emergencies: 
Administer CPR, manage choking, and provide first aid for injuries and medical conditions like heart attacks, strokes, asthma, and diabetes.
Injury and Illness Management: 
Recognise and treat burns, bleeding, fractures, and more.
Provide first aid for conditions like anaphylaxis, electric shock, and poisoning.

This course is designed for both businesses and individuals who require a fully trained first aider, as identified by their risk assessment or personal need for workplace first aid training. Whether you’re looking to comply with workplace health and safety regulations or simply want to gain life-saving skills, this course ensures you're equipped to respond confidently in an emergency.

Book your place today and take the first step towards becoming a qualified first aider – your knowledge could make all the difference in an emergency!

PETM

First Aid At Work

Emergency First Aid At Work (EFAW)

Workplace First Aid

First Aid

Vocational Training Charitable Trust (VTCT)

Health & Safety At Work

Emergency First Aid

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

First Aid at Work 18 hours (VTQ) Level 3 - FAW

Nottinghamshire

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Overview</h2>This course is aimed at candidates that require the knowledge and practical skills to prepare, attach, guide and move suspended loads using a range of lifting accessories. It will enable the candidate to carry out their duties while complying with LOLER regulations.<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course Content</h2>Candidates will be able to:<ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a Slinger Signaller</li><li fr-original-style="" style="box-sizing: border-box;">Conform to relevant regulations, legislation and manufacturers requirements as per technical data</li><li fr-original-style="" style="box-sizing: border-box;">Locate, identify and explain different types of lifting equipment and lifting accessories.</li><li fr-original-style="" style="box-sizing: border-box;">Explain their basic construction, uses, applications and their functions</li><li fr-original-style="" style="box-sizing: border-box;">Interpret and extract information on all relevant documentation</li><li fr-original-style="" style="box-sizing: border-box;">Undertake all pre-use checks on non-specialist lifting accessories and identify non-serviceable items</li><li fr-original-style="" style="box-sizing: border-box;">Explain procedures for placing non-serviceable items out-of-service</li><li fr-original-style="" style="box-sizing: border-box;">Identify and explain centres of gravity and calculate estimated weights of loads</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zones explaining actions required for emergency actions and identifying any overhead hazards</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for Slinger Signaller use</li><li fr-original-style="" style="box-sizing: border-box;">Secure various types of loads to a hook using the relevant lifting accessories and procedures ensuring load balance, security and integrity</li><li fr-original-style="" style="box-sizing: border-box;">Direct and guide the movement of loads to different types of location using different methods of communication</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all out-of service and securing procedures</li></ul><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Entry Requirements</h2>NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.Good understanding of spoken and written English.<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Duration</h2>Novice course &ndash; 2 DaysExperienced Worker Tests- 1 Day theory and practical assessment<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Location</h2>Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications

Overview
This course is aimed at candidates that require the knowledge and practical skills to prepare, attach, guide and move suspended loads using a range of lifting accessories. It will enable the candidate to carry out their duties while complying with LOLER regulations.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a Slinger Signaller
Conform to relevant regulations, legislation and manufacturers requirements as per technical data
Locate, identify and explain different types of lifting equipment and lifting accessories.
Explain their basic construction, uses, applications and their functions
Interpret and extract information on all relevant documentation
Undertake all pre-use checks on non-specialist lifting accessories and identify non-serviceable items
Explain procedures for placing non-serviceable items out-of-service
Identify and explain centres of gravity and calculate estimated weights of loads
Set up exclusion zones explaining actions required for emergency actions and identifying any overhead hazards
Identify and maintain PPE appropriate for Slinger Signaller use
Secure various types of loads to a hook using the relevant lifting accessories and procedures ensuring load balance, security and integrity
Direct and guide the movement of loads to different types of location using different methods of communication
Understand environmental considerations
Carry out all out-of service and securing procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 2 Days
Experienced Worker Tests- 1 Day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Slinger / Signaller (N402)

Course Objectives: <ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a competent person carrying out inspections of lifting equipment, accessories and attachments.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to conform to manufacturers requirements as per technical date and conform to relevant regulations and legislation.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate, identify and explain different types of lifting equipment, accessories and attachments. Examine their basic construction, explain their uses, applications and functions.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to interpret and extract information from all relevant documentation.</li><li fr-original-style="" style="box-sizing: border-box;">Explain and demonstrate a comprehensive thorough inspection.</li><li fr-original-style="" style="box-sizing: border-box;">Identify and demonstrate how to complete a thorough examination inspection report.</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations.</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all storage and securing procedures.</li></ul>

Course Objectives:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a competent person carrying out inspections of lifting equipment, accessories and attachments.
Be able to conform to manufacturers requirements as per technical date and conform to relevant regulations and legislation.
Be able to locate, identify and explain different types of lifting equipment, accessories and attachments. Examine their basic construction, explain their uses, applications and functions.
Be able to interpret and extract information from all relevant documentation.
Explain and demonstrate a comprehensive thorough inspection.
Identify and demonstrate how to complete a thorough examination inspection report.
Environmental considerations.
Carry out all storage and securing procedures.

NPORS Report of Thorough Examination (N019)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Overview</h2>This course is aimed at candidates that require the knowledge and practical skills to operate mobile elevating work platforms (scissor lifts) safely and efficiently while carrying out work at heights.<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course Content</h2>Candidates will be able to:<ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understanding the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used, and be familiar with other types of information sources and relevant legislation</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Check all emergency lowering functions</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely on level ground and inclines in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area, including overhead and underground hazards</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out accessing tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out accessing tasks, at various points up to full operating height</li><li fr-original-style="" style="box-sizing: border-box;">Travel with platform raised (where applicable)</li><li fr-original-style="" style="box-sizing: border-box;">Use platform extension section</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2></div>NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.Good understanding of spoken and written English.<div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;">Duration</h2></div>Novice course- 5 days depending on experienceExperienced worker tests- 1 day theory and practical assessment<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Location</h2>Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate mobile elevating work platforms (scissor lifts) safely and efficiently while carrying out work at heights.
Course Content
Candidates will be able to:
Understanding the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used, and be familiar with other types of information sources and relevant legislation
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Check all emergency lowering functions
Safely mount and dismount the machine
Configure the machine for travel
Configure the machine for travel and manoeuvre it safely on level ground and inclines in open and confined areas
Conduct all necessary safety checks at the work area, including overhead and underground hazards
Manoeuvre the machine to the work area and correctly configure in readiness to carry out accessing tasks
Carry out accessing tasks, at various points up to full operating height
Travel with platform raised (where applicable)
Use platform extension section
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS MEWP Scissor Lift (N109)

<h1 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Overview&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;</td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">This course is aimed at candidates that require the knowledge and practical skills to&nbsp;ensure a safe system of work in accordance with the method statement.&nbsp;It will enable the candidate to carry out their duties while complying&nbsp;with the relevant legislation and standards, including LOLER 1998 and BS 7121.</td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Who Should Attend?</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;</td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">This course is designed for&nbsp;personnel who supervise the lift and follow lift plans for routine and non-routine lifts.Requirements:Experienced operators should have&nbsp;sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.&nbsp;Good understanding of spoken and written English.</td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Agenda</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;</td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a crane / lift supervisor</li><li fr-original-style="" style="box-sizing: border-box;">Explain the importance of locating and identifying different types of lifting equipment and lifting accessories.&nbsp;Explain their basic construction, uses, applications and functions</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate how to interpret and extract information on all relevant documentation</li><li fr-original-style="" style="box-sizing: border-box;">Explain and demonstrate diverse types of communication methods used for lifting purposes</li><li fr-original-style="" style="box-sizing: border-box;">Explain procedures for placing non-serviceable items out-of-service</li><li fr-original-style="" style="box-sizing: border-box;">Explain the function and use of the RCIs and anti-collision systems and use the information provided</li><li fr-original-style="" style="box-sizing: border-box;">Explain setting up, erection, levelling and dismantling requirements for diverse types of lifting equipment and lifts</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone explaining actions required for emergency actions and identify overhead hazards</li><li fr-original-style="" style="box-sizing: border-box;">Identify potential hazards and unsafe lifting practices using different lifting scenarios</li><li fr-original-style="" style="box-sizing: border-box;">Explain the importance of checking the security of various types of loads and lifting accessories, explain the procedures ensuring load balance and integrity</li><li fr-original-style="" style="box-sizing: border-box;">Supervise the movement of loads to different types of locations using different methods of communication</li><li fr-original-style="" style="box-sizing: border-box;">Explain all Environmental considerations and explain how factors such as the external area to the lift zone can affect the planning of the lifting operation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all out-of-service and securing procedures</li></ul>&nbsp;</td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Assessment</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;</td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">Novice course &ndash; 3 DaysExperienced Worker Tests- 1 Day&nbsp;</td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Certification</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">&nbsp;</td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);">Traditional NPORS Card &ndash; Refresher training is advised every 3 years</td></tr></tbody></table>

Overview 
 	This course is aimed at candidates that require the knowledge and practical skills to ensure a safe system of work in accordance with the method statement. It will enable the candidate to carry out their duties while complying with the relevant legislation and standards, including LOLER 1998 and BS 7121.
Who Should Attend?
 	This course is designed for personnel who supervise the lift and follow lift plans for routine and non-routine lifts.
Requirements:
Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes. 
Good understanding of spoken and written English.
Agenda
 	 
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a crane / lift supervisorExplain the importance of locating and identifying different types of lifting equipment and lifting accessories. Explain their basic construction, uses, applications and functionsDemonstrate how to interpret and extract information on all relevant documentationExplain and demonstrate diverse types of communication methods used for lifting purposesExplain procedures for placing non-serviceable items out-of-serviceExplain the function and use of the RCIs and anti-collision systems and use the information providedExplain setting up, erection, levelling and dismantling requirements for diverse types of lifting equipment and liftsSet up exclusion zone explaining actions required for emergency actions and identify overhead hazardsIdentify potential hazards and unsafe lifting practices using different lifting scenariosExplain the importance of checking the security of various types of loads and lifting accessories, explain the procedures ensuring load balance and integritySupervise the movement of loads to different types of locations using different methods of communicationExplain all Environmental considerations and explain how factors such as the external area to the lift zone can affect the planning of the lifting operationCarry out all out-of-service and securing procedures
 
Assessment
 	Novice course – 3 Days
Experienced Worker Tests- 1 Day 
Certification
 	Traditional NPORS Card – Refresher training is advised every 3 years

NPORS Crane / Lift Supervisor (N405)

Course Description: This 1 day course is aimed at supervisors/team leaders/managers to provide an understanding of the correct plant operating procedures that should be adopted by plant operators in the workplace.<ul style="color: rgb(32, 42, 68); box-sizing: border-box;" fr-original-style=" color: rgb(32, 42, 68);"><li fr-original-style="" style="box-sizing: border-box;">Identify the roles and responsibilities&rsquo; of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management</li><li fr-original-style="" style="box-sizing: border-box;">Check test certification of equipment and accessories to be used</li><li fr-original-style="" style="box-sizing: border-box;">Safely supervise various tasks and different environments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out a toolbox talk/ safety briefing allocating roles to team</li><li fr-original-style="" style="box-sizing: border-box;">Liaise with both management and operator&rsquo;s</li><li fr-original-style="" style="box-sizing: border-box;">Produce a safe system of work giving a safe step by step guide for team to follow</li><li fr-original-style="" style="box-sizing: border-box;">Produce risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Hold a debrief with team and discuss any lessons learned</li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div>

Course Description:


This 1 day course is aimed at supervisors/team leaders/managers to provide an understanding of the correct plant operating procedures that should be adopted by plant operators in the workplace.
Identify the roles and responsibilities’ of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management
Check test certification of equipment and accessories to be used
Safely supervise various tasks and different environments
Carry out a toolbox talk/ safety briefing allocating roles to team
Liaise with both management and operator’s
Produce a safe system of work giving a safe step by step guide for team to follow
Produce risk assessment
Hold a debrief with team and discuss any lessons learned



NPORS Plant Supervisor Awareness (N034)

Course Information&nbsp;By the end of this course, delegates will be able to:<ul style="color: rgb(32, 42, 68); box-sizing: border-box;" fr-original-style=" color: rgb(32, 42, 68);"><li fr-original-style="" style="box-sizing: border-box;">Identify the roles and responsibilities&rsquo; of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management</li><li fr-original-style="" style="box-sizing: border-box;">Check test certification of equipment and accessories to be used</li><li fr-original-style="" style="box-sizing: border-box;">Safely supervise various tasks and different environments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out a toolbox talk/ safety briefing allocating roles to team</li><li fr-original-style="" style="box-sizing: border-box;">Liaise with both management and operator&rsquo;s</li><li fr-original-style="" style="box-sizing: border-box;">Produce a safe system of work giving a safe step by step guide for team to follow</li><li fr-original-style="" style="box-sizing: border-box;">Produce risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Hold a debrief with team and discuss any lessons learned</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2></div>NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.Good understanding of spoken and written English.

Course Information 
By the end of this course, delegates will be able to:
Identify the roles and responsibilities’ of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management
Check test certification of equipment and accessories to be used
Safely supervise various tasks and different environments
Carry out a toolbox talk/ safety briefing allocating roles to team
Liaise with both management and operator’s
Produce a safe system of work giving a safe step by step guide for team to follow
Produce risk assessment
Hold a debrief with team and discuss any lessons learned
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.

NPORS Lift Truck Supervisor Awareness (N036)

Who should attend&nbsp;Our NPORS Abrasive Wheels course is intended for those who operate, supervise or manage the use of abrasive wheels.&nbsp; Course information&nbsp;The aim of this course is to provide staff with sufficient knowledge to use and maintain abrasive wheel equipment safely, covering:&nbsp;&bull; Health and safety legislation overview&nbsp;&bull; Hazards and risk control measures associated with Abrasive Wheels&nbsp;&bull; PPE&nbsp;&bull; Types of abrasive wheel machines and their safe use&nbsp;&bull; Resin &amp; vitrified bonded abrasive wheel selection, marking, identification and inspection&nbsp;&bull; Correct use, setting, adjustment and inspection of flanges, guards and accessories&nbsp;&bull; Pre-use machine safety checks&nbsp;&bull; How to mount of abrasive wheels on various equipment including hand angle grinder, saws and bench grinders&nbsp;&bull; Set up and safe working of applying an Abrasive Wheel to a grinder&nbsp;&bull; Practical safe set up (no live cutting or grinding)&nbsp;Entry Requirements&nbsp;For learners that require the &#39;HS&amp;E TESTED Logo&#39; displayed on their card they must have passed the CITB Operatives Health, Safety and Environment Test within the last 2 years. Good understanding of spoken and written English.

Who should attend
 Our NPORS Abrasive Wheels course is intended for those who operate, supervise or manage the use of abrasive wheels. 


Course information 
The aim of this course is to provide staff with sufficient knowledge to use and maintain abrasive wheel equipment safely, covering:
 • Health and safety legislation overview
 • Hazards and risk control measures associated with Abrasive Wheels
 • PPE 
• Types of abrasive wheel machines and their safe use 
• Resin & vitrified bonded abrasive wheel selection, marking, identification and inspection 
• Correct use, setting, adjustment and inspection of flanges, guards and accessories 
• Pre-use machine safety checks 
• How to mount of abrasive wheels on various equipment including hand angle grinder, saws and bench grinders
 • Set up and safe working of applying an Abrasive Wheel to a grinder
 • Practical safe set up (no live cutting or grinding)
 Entry Requirements 
For learners that require the 'HS&E TESTED Logo' displayed on their card they must have passed the CITB Operatives Health, Safety and Environment Test within the last 2 years. Good understanding of spoken and written English.

NPORS Abrasive Wheels Awareness (N301A)

COURSE INFORMATIONThe novice course is split into 4 days of training and one day of testing.&nbsp;By the end of the course delegates will have the knowledge to be able to design safe lifting plans that are compliant with the law, and take into account all health and safety requirements on site.Days 1-4:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Explanation of qualifications</li><li fr-original-style="" style="box-sizing: border-box;">Legislation controlling crane operations</li><li fr-original-style="" style="box-sizing: border-box;">BS 7121 Explanation</li><li fr-original-style="" style="box-sizing: border-box;">LOLER regulations in detail</li><li fr-original-style="" style="box-sizing: border-box;">Crane appreciation</li><li fr-original-style="" style="box-sizing: border-box;">Crane stability</li><li fr-original-style="" style="box-sizing: border-box;">Accessories</li><li fr-original-style="" style="box-sizing: border-box;">Safe slinging</li><li fr-original-style="" style="box-sizing: border-box;">Mobile crane selection</li><li fr-original-style="" style="box-sizing: border-box;">Risk assessment and method statement</li><li fr-original-style="" style="box-sizing: border-box;">Supervise a lift scenario</li><li fr-original-style="" style="box-sizing: border-box;">Practical induction</li><li fr-original-style="" style="box-sizing: border-box;">Case studies lift plan exercise</li><li fr-original-style="" style="box-sizing: border-box;">Procedures for planning lifts</li></ul>Day 5:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">NPORS Theory Test</li><li fr-original-style="" style="box-sizing: border-box;">NPORS Practical Assessment</li><li fr-original-style="" style="box-sizing: border-box;">RAMS and Lift Plan Exercise</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2>Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.Good understanding of spoken and written English.

COURSE INFORMATION
The novice course is split into 4 days of training and one day of testing. 
By the end of the course delegates will have the knowledge to be able to design safe lifting plans that are compliant with the law, and take into account all health and safety requirements on site.
Days 1-4:
Introduction
Explanation of qualifications
Legislation controlling crane operations
BS 7121 Explanation
LOLER regulations in detail
Crane appreciation
Crane stability
Accessories
Safe slinging
Mobile crane selection
Risk assessment and method statement
Supervise a lift scenario
Practical induction
Case studies lift plan exercise
Procedures for planning lifts
Day 5:
NPORS Theory Test
NPORS Practical Assessment
RAMS and Lift Plan Exercise
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.
Good understanding of spoken and written English.

NPORS Appointed Person (N401)

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

<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;">TEA &#39;N CHAT - &nbsp;Introducing AI in Textiles Education&nbsp;A FUN AND FASCINATING ONLINE LIVE SESSION WITH ROY BALLAM<div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">19 MARCH 2024TIME: &nbsp;7-8pm&nbsp;&nbsp;&nbsp;FREE EVENT<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;">Artificial Intelligence is already here and being used in businesses and in schools. Become an AI expert and transform the way you and your colleagues can change the way you work.&nbsp;Get ahead of the curve, keep up to date and join us for this TEA &#39;N CHAT with our very own techie geek ROY BALLAM, who will introduce the potential use of AI in textiles education.&nbsp;You will see AI in action, demonstrating how different tools could save you time, support your planning and teaching, enhance pupil experience, and further your creativity. The pros and cons of AI will also be highlighted. Transform your teaching with AI tools, save time, and get creative!The session will show how AI could help you:&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; font-style: italic; box-sizing: border-box;" fr-original-style="font-size: 16px; font-style: italic;">create teaching schemes and lesson plans&nbsp;</li><li style="font-size: 16px; font-style: italic; box-sizing: border-box;" fr-original-style="font-size: 16px; font-style: italic;">explore subject specific knowledge&nbsp;</li><li style="font-size: 16px; font-style: italic; box-sizing: border-box;" fr-original-style="font-size: 16px; font-style: italic;">generate and explore ideas, concepts, themes and designers&nbsp;</li><li style="font-size: 16px; font-style: italic; box-sizing: border-box;" fr-original-style="font-size: 16px; font-style: italic;">write questions and assessment frameworks&nbsp;</li><li style="font-size: 16px; font-style: italic; box-sizing: border-box;" fr-original-style="font-size: 16px; font-style: italic;">unleash creativity in textile design, colour, styles and fashion. &nbsp;</li></ul>This is a &lsquo;must-attend&rsquo;&nbsp;session for all those interested in AI (or just starting to discover its potential) and wishing to discover how it could be used in school. It is a stepping stone for the more in-depth&nbsp;Integrating AI in textiles education&nbsp;event being held on the 11 May 2024.</div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;"> COURSE LEADER: &nbsp; ROY BALLAM &nbsp;BA (Hons), MA, School Education Consultant<img src="https://images.cademy.co.uk/textiles-skills-centre/9b61b89b-c982-4dd2-b44b-0b22e86d67db/original.jpeg" style="width: 200px; display: inline-block; vertical-align: bottom; margin: 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left; padding: 0px 1px; -webkit-user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 200px; display: inline-block; vertical-align: bottom; margin: 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable wysiwyg_padded_img_cls">Roy works as a school education consultant, after leaving a leading charity as Managing Director and Head of Education.&nbsp;He has been involved in numerous teaching and education programme, initiatives and publications, including those in the UK and internationally.&nbsp; He is an experienced educational leader specialising in education management, training, resource development and research, and policy development and implementation. Throughout his career, he has used ICT to help bring subject-specific learning to life and support teachers through innovative, but pragmatic approaches. Roy originally trained as a food and textiles teacher and has been a GCSE moderator and A-level principal examiner.  &nbsp;<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;">The&nbsp;Textiles Skills Centre Associates&nbsp;are a team of volunteers that manage the social media platforms and website, and offer support, mentorship and advice to textile teachers and trainees. We organise free resource networking events each month (Tea &#39;N Chat) and are always on hand to help and encourage when needed. We are always looking for new Associate members, so if you would like to join this small team then do contact us at:&nbsp;info@textileskillscentre.comAt the moment all costs are met by our team and time is given freely. If you are able to support us with a donation, however small, this will help to enhance the work we are doing.You can donate using the DONATION button below which will take you to the Paypal donations page, or select an amount when you book the event. All donations gratefully received.<a href="https://www.paypal.com/donate/?hosted_button_id=P3GCCAAFZBJWC" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; -webkit-user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">DONATION</a>




TEA 'N CHAT - MARK MAKING FOR TEXTILES + NICKY SIMPSON
(Mini Workshop & Demo)

17 JUNE 2025
TIME: 7-8pm  
 FREE EVENT
This event is held on ZOOM, so please register to get the Zoom details.



Join us for a FREE Tea 'N Chat with NICKY SIMPSON who will demo and lead a mini workshop on mark making for textiles and she will talk about her online courses.

Nicky's aim is to show how easily accessible mark making can be for every level of student and how it can be delivered in a fun and engaging way.
She will also introduce you to her online and face-2-face courses with an opportunity to ask questions.




JOIN IN:
'Drawing florals for textiles'
Mark making is great way of introducing drawing if you have little to no prior experience. Especially good for students who think they can't draw!
Drawing florals can feel overwhelming, especially without a background in art.
A beginner friendly workshop to produce floral artwork for textile projects.

If you want to join in you will need:
Paper
A dried flower or leaf
Pencil
Ink, or acrylic paint, or powder dyes/transfer dyes - Any medium to work with.
Selection of paint brushes
( also useful is a straw and a water spray)




The Textiles Skills Centre Associates are a team of volunteers that manage the social media platforms and website, and offer support, mentorship and advice to textile teachers and trainees. We organise free resource networking events each month (Tea 'N Chat) and are always on hand to help and encourage when needed.
We are always looking for new Associate members, so if you would like to join this small team then do contact us at: info@textileskillscentre.com
At the moment all costs are met by our team and time is given freely. If you are able to support us with a donation, however small, this will help to enhance the work we are doing.
You can donate at checkout, or using the ‘BUY THE TEAM A COFFEE’ button below. All donations gratefully received.
(Especially ☕ and 🍰 😋)

BUY THE TEAM A COFFEE

Textiles Skills Centre

Art Teacher

Arts & Crafts

Fashion Crafts

Tea 'N Chat free event - Talk with Textile Artist Nicky Simpson

Tea 'N Chat - Mark Making for Textiles + Nicky Simpson

General Admission

DONATION

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Live instructor led sessions;&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div>Why choosing Mindmaps Wellbeing is a good choice for your training.The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:✅ Instructor led training sessions over two days✅ Course Manual✅ Workbook✅ Handy Cue Card✅ MHFAider Certificate upon completionPlus, exclusively when you choose Mindmaps Wellbeing, it also includes:✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).✅ Access to our online MHFAider peer support groups moderated by the instructor team.✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.&nbsp;For a little extra:&nbsp;✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

MHFA England Adult Mental Health First Aid Course. 
This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider.
 
As an MHFAider you will
Gain the knowledge and confidence to provide appropriate support to those around you. At work, home and in the community. 
Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention 
Encourage a person to identify and access sources of appropriate help, Practise active listening and empathy
Have a conversation with improved mental health literacy around language and stigma
Discuss the MHFAider role in depth, including boundaries and confidentiality Practise self-care
Access to use the MHFA England, MHFAider Support App®
Know how to access a dedicated text service provided by Shout
Join a growing community of MHFAiders with Mindmaps Wellbeing's MHFAider Online Community Peer Group moderated by Registered Mental Health Nurses  

Day one
Mental Health First Aid and the action plan 
The MHFAider® role and self-care 
Helpful and unhelpful language 
Useful models to support the role 
What influences mental health? 
What is anxiety? 
Crisis first aid 
Active listening and empathy 
Day two
What are eating disorders? 
What is self-harm? 
What is substance misuse? 
Applying the Mental Health First Aid action plan 
What is depression? 
What is suicide? 
Crisis first aid continued 
What is psychosis? 
Recovery and lived experience 
Boundaries in the MHFAider® role 
Moving forward in the MHFAider® role 
My MHFA action plan 


Our full workshop collection

Certificate provided by MHFA England on completion of this course.

Also, available for groups of 10 to 16 learners. 
For more information, contact us

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Mental Health First Aid (MHFA) England Training with Mindmaps Wellbeing

Enhance workplace wellbeing and mental health awareness with MHFA England-certified training by Mindmaps Wellbeing. Our expert-led courses, delivered by Registered Mental Health Nurses and Healthcare Educators, equip you with the skills to recognize, support, and respond to mental health challenges. Whether online or in-person, our training ensures flexible learning options without compromising quality.

Join us to gain certification as a Mental Health First Aider and access exclusive benefits like ongoing peer support, expert forums, and resources for self-care. Book now with Mindmaps Wellbeing and take the first step toward a healthier, more supportive environment for all.


MHFA England Mental Health First Aid 2-day course
With Mindmaps Wellbeing, your instructor will be a Registered Mental Health Nurse. 

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)

Who should attend? DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors. Overview Join us for an insightful masterclass that delves into the profound effects of neglect on a child&#39;s life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children. Learning Objectives This Masterclass will enable you to:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child&#39;s development.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child&#39;s life.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child&#39;s wellbeing.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.</li></ul><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a>

Who should attend?
DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors.

Overview

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Learning Objectives

This Masterclass will enable you to:
Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child's development.
Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.
Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child's life.
Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child's wellbeing.
Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.
Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.
Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.
View all testimonials

Brightcore Consultancy

Child Safeguarding

Safeguarding

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Neglect: Recognising and Responding to the Impact on Children

Wellbeing Champions is a CPD accredited course created to train employees to become health and wellbeing advocates in the workplace. Champions have the knowledge, passion and practical tools to promote physical, mental, social and financial wellbeing while driving engagement for greater participation. Champions are encouraged to be pro-active in their role to underpin a preventative measure for employee wellbeing.

Course includes
2 x Half Day Training Sessions On-Line
Champions Lanyard
Champions Badge
Access To Champions Digital Toolbox
Champions CPD Certificate - PDF

We Are Wellbeing LTD

Wellbeing Champions Training 🏅 

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">LOOKING FOR: ADULT FICTION, NON-FICTIONDiana joined the prestigious DHH Literary Agency in June 2024. She started agenting with Rupert Heath Literary Agency in 2011 before moving to UTA and Marjacq in 2017. Before that she was senior commissioning editor at Transworld. Diana was chosen as one of The Bookseller&rsquo;s Rising Stars of 2012, was a nominee for RNA Agent of the Year 2019, and was shortlisted for Literary Agent of the Year 2022 at the British Book Awards.&nbsp;Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally.Diana represents adult fiction and non-fiction. For fiction, she is looking for upmarket women&#39;s commercial, with depth and heart, including reading group, historical, saga, uplit and contemporary stories that are irreverent and make her laugh; accessible literary fiction, high-concept crime fiction and thrillers. She has a thing for spy novels and would love to find a great vampire story.&nbsp;On the non-fiction side: memoir, smart, funny feminists, lifestyle, cookery and social justice, and open to anything with a strong, original voice. She also encourages submissions from writers who have been traditionally under-represented.Diana would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (a maximum of 5,000 words) of your manuscript in a single word document.&nbsp;<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(In addition to the paid sessions, Diana is kindly offering one free session for low income/underrepresented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the discretion of I Am In Print).&nbsp;By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">The submission deadline is: Wednesday 4 September 2024

LOOKING FOR: ADULT FICTION, NON-FICTION

Diana joined the prestigious DHH Literary Agency in June 2024. She started agenting with Rupert Heath Literary Agency in 2011 before moving to UTA and Marjacq in 2017. Before that she was senior commissioning editor at Transworld. Diana was chosen as one of The Bookseller’s Rising Stars of 2012, was a nominee for RNA Agent of the Year 2019, and was shortlisted for Literary Agent of the Year 2022 at the British Book Awards. Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally.

Diana represents adult fiction and non-fiction. For fiction, she is looking for upmarket women's commercial, with depth and heart, including reading group, historical, saga, uplit and contemporary stories that are irreverent and make her laugh; accessible literary fiction, high-concept crime fiction and thrillers. She has a thing for spy novels and would love to find a great vampire story. 

On the non-fiction side: memoir, smart, funny feminists, lifestyle, cookery and social justice, and open to anything with a strong, original voice. She also encourages submissions from writers who have been traditionally under-represented.

Diana would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (a maximum of 5,000 words) of your manuscript in a single word document. 

(In addition to the paid sessions, Diana is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Tuesday 10th June 2025

I Am In Print

Fiction Writing

SOLD OUT! 19th June Diana Beaumont #Agent121. Looking for: ADULT FICTION, NON-FICTION

<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" id="isPasted" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">LOOKING FOR:&nbsp; MIDDLE GRADE, CHILDREN&#39;S NON-FICTION, YA FICTION, YA NON-FICTIONPrior to joining Diamond Kahn and Woods in 2023, Camille Burns worked at David Higham Associates as Agent&rsquo;s Assistant to Jane Gregory and Assistant to the Children&rsquo;s Rights team for just over three and a half years. Over her career to date, she has also worked in editorial for an academic publisher, in rights and marketing for an audiobook publisher and as an intern at Felicity Bryan Literary Agency. Camille has an MSc in Publishing from Edinburgh Napier University and an MA in English Literature from the University of Edinburgh. She currently serves as the Secretary of the Association of Authors&rsquo; Agents, as well as Co-Chair for the AAA&rsquo;s Bridge Committee for early career agents and assistants. She previously volunteered at the Story Museum in Oxford.Camille loves engaging with narratives on a structural level in order to draw out their best qualities. She has varied taste with a particular interest in children&rsquo;s and YA fiction and non-fiction, as well as adult non-fiction. In MG, she would love to see stories with heart and with a classic, lyrical tone, in the vein of Katya Balen, or with the inventiveness of Frances Hardinge or the action-packed sequences and acerbic wit of Jonathan Stroud. In YA she is looking for all genres whether they be on the more literary or commercial sides, but with an emphasis on romance. She would also be interested in seeing crossover romance, be that contemporary or fantasy, and stories featuring characters in their very early twenties.Camille would love to see proposals for smart and accessible non-fiction (children&rsquo;s or adult) which teach us about the world we live in, which shine a light on a culture (encompassing everything including workplace culture), which are empowering or which encourage deep thinking and fundamental shifts in perspective. She is not currently looking for memoir unless it is also doing one of these things. Some favourite non-fiction books are:&nbsp;Entangled Life,&nbsp;Quiet: The Power of Introverts in a World that Can&rsquo;t Stop Talking,&nbsp;Braiding Sweetgrass,&nbsp;The Gendered Brain, Why We Sleep, Invisible Women&nbsp;and&nbsp;A World Without Email.Camille would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(In addition to the paid sessions, Camille is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;discretion of&nbsp;I Am In Print).&nbsp;By booking you understand you need to conduct an internet connection test with&nbsp;I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">The submission deadline is: Wednesday 25 October 2023

LOOKING FOR:  MIDDLE GRADE, CHILDREN'S NON-FICTION, YA FICTION, YA NON-FICTION

Prior to joining DKW in 2023, Camille worked at David Higham Associates as Agent’s Assistant to Jane Gregory and in the Children’s Translation Rights team. She has also worked in editorial for an academic publisher, in rights and marketing for an audiobook publisher and as an intern at Felicity Bryan Literary Agency. Camille loves engaging with narratives on a structural level in order to draw out their best qualities. Camille has an MSc in Publishing from Edinburgh Napier University and an MA in English Literature from the University of Edinburgh. She was Secretary of the Association of Authors’ Agents, as well as Co-Chair for the AAA’s Bridge Committee for early career agents and assistants, from late 2021 to early 2024. She also previously volunteered at the Story Museum in Oxford.

Camille is looking to grow her list with a particular focus on middle grade, young adult and adult/crossover fiction, as well as non-fiction for all ages. Books that she has loved and that speak to her taste include Lockwood and Co by Jonathan Stroud (MG), I’ll Give You The Sun by Jandy Nelson (YA), Fourth Wing by Rebecca Yarros (crossover) and Every Summer After by Carley Fortune (adult). For more information, please visit Camille's page on the Diamond Kahn Woods Literary Agency website.

Camille would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document.

(In addition to the paid sessions, Camille is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Friday 13th June 2025

BOOKINGS CLOSE SOON! 19th June Camille Burns #Agent121. Looking for: MG, YA FICTION inc YA/CROSSOVER ROMANCE, AND CHILDREN'S & ADULT NON-FICTION

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses. On this course delegates will... &bull; Learn how to build senior debt models with geared net cash flow. &bull; Explore and assess the influence of complex debt structures on returns. &bull; Develop advanced mezzanine debt models affecting project cash flows. &bull; Model joint venture structures for optimised partnerships. &bull; Calculate promote and profit share structures in Real Estate transactions. &bull; Construct sophisticated project cash flow models with mezzanine debts. Who will benefit from this course? &bull; Real Estate Professionals who have had exposure to Real Estate financial models &bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis &bull; Real Estate Developers &bull; Financial Analysts &bull; Investment Managers &bull; Banking and Finance Professionals in Real Estate Course Outline &bull; Mathematics of amortisation and debt finance. &bull; Basic senior debt models and geared net cash flow. &bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics. &bull; Mezzanine debt modelling. &bull; Joint Venture structures between developers and lender/equity partners. &bull; Promote and profit share structure calculations. &bull; Advanced project cash flows with mezzanine debt. Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Financial Analysis

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

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.

320 Courses in Leicester

Ros Equine Coach - 1 to 1 coaching at your yard

By Ros D Equine

First Aid at Work 18 hours (VTQ) Level 3 - FAW

By PETM

NPORS Slinger / Signaller (N402)

By Dynamic Training and Assessments Ltd

NPORS Report of Thorough Examination (N019)

By Dynamic Training and Assessments Ltd

NPORS MEWP Scissor Lift (N109)

By Dynamic Training and Assessments Ltd

NPORS Crane / Lift Supervisor (N405)

By Dynamic Training and Assessments Ltd

NPORS Plant Supervisor Awareness (N034)

By Dynamic Training and Assessments Ltd

NPORS Lift Truck Supervisor Awareness (N036)

By Dynamic Training and Assessments Ltd

NPORS Abrasive Wheels Awareness (N301A)

By Dynamic Training and Assessments Ltd

NPORS Appointed Person (N401)

By Dynamic Training and Assessments Ltd

Search By Location