Name: Microsoft Project Advanced - In-company (now with trainer led live online classes)
Price: 750 GBP
Availability: InStock

Gloucester

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Forklift refresher training is aimed at those who have been previously trained and their skills need updating or refreshing following an incident or accident whilst operating.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A one day course is for up to 3 candidates per course</p>

Gl Training Services

Forklift Training Gloucestershire
Counter Balance Training
Crane Training
MEWP Training

One Day Forklift Refresher Course On-Site

Harpenden

<p>The IOSH Managing Safelyaward is valid for three years. Award-holders need to undertake this one-day refresher programme every three years in order to maintain their status.</p><p>This very interactive, practical programme covers:</p><p>An interactive case study exercise is used throughout the day to apply refreshed knowledge to the plan-do-check-act model and then link it back to the workplace. For example, participants examine the elements of a safety and health policy, come up with ideas to influence safety culture, and select the best communication methods to engage a workforce.</p>

The In House Training Company

First Aid At Work

Site Management Safety Training Scheme (SMSTS)

Health & Safety Awareness

Safety Manager

IOSH

Fire Safety Instructor

Managing Safely Refresher - IOSH Award (In-House)

Redhill

<h3><b>XSLT training course description</b></h3>
      <p>  This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Transform and style XML documents using XSLT.</li>
                  </ul>
        <h5>
        <b>XSLT training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with XSLT.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>XML primer
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>XSLT training course contents</b></h3>
      <ul>
				<li>Introduction </li><p>
Extensible Stylesheet Language (XSL), transforming and formatting XML.

</p><li>XML refresher </li><p>
The basic rules for building an XML document.

</p><li>An introduction to XSLT </li><p>
The basic concepts of XSLT, xsl:output, xsl:template, xsl:value-of.

</p><li>XML documents as trees </li><p>
How the original XML is transformed into a set of nodes, the general terms for manipulating node trees.

</p><li>Paths (XPath) </li><p>
Use of path matching to select required nodes for transformation.

</p><li>Using templates </li><p>
xsl:apply-templates, xsl:template match, nested templates, xsl:copy , 	&lt;comment&gt; and &lt;element&gt; , default templates, parameters.

</p><li>Control </li><p>
xsl:if, xsl:choose, xsl:for-each, xsl:sort.

</p><li>Constructing the result tree </li><p>
xsl:output, xsl:attribute, xsl:attribute-set, xsl:comment, xsl:processing-instruction, xsl:text, xsl:value-of, xsl:variable.

</p><li>Combining templates </li><p>
xsl:include, xsl:import, xsl:apply-imports.

 </p><li>Transforming to text </li>
			
      </ul>

Systems & Network Training

Network & Security

Network Engineer

XSLT

General Admission

Stoke on Trent

<h2>Course Details</h2><p>Overview of the CITB HSA Course 
The CITB Health and Safety Awareness (HSA) Green Labourer Card CSCS course is for those who have entered, or are about to enter, the construction and civil engineering industry as a member of the workforce to help them understand the potential hazards that they face at work on site.

Assessment
Assessment will be by multiple-choice question paper at the end of the course. Learners are also expected to actively participate during the course. The examination paper consists of 25 multiple-choice questions selected by CITB, 20 questions are worth one mark each and 5 are worth two marks each. The examination pass mark is 83% (25 out of 30). 

Length of Course
This is a one-day course. Delegates are required to complete the full day (7.5 hours) to be eligible for certification. 

The HSA course in Stoke on Trent is the first step towards a CSCS Labourers Card (Green Card) and to the progressive CITB Site Safety Plus courses. Our courses range from operative training, Supervisor, Site Manager and Director Health and Safety courses.

Successful completion of CITB Site Safety Plus (Health and Safety Awareness Level 1) course can be used as a prerequisite for the Construction Industry Training Board (CITB): Operative, health, safety and environment touch screen test, or just as repeat refresher training.</p>

You Can Do It .Training

Citb

CSCS (Construction Skills Certification Scheme)

Health, Safety & Environment (HSE)

Health & Safety

Cscs Card

This CITB HSA course highlights potential hazards when on a construction site.

CITB Health & Safety Awareness (On-Site)

<h2>Course Details</h2><p>Level 3 Emergency First Aid at Work (EFAW)

Suitability 
The Emergency First Aid at Work (EFAW) qualification is ideal for those working in lower hazard environments (e.g. shops, offices), with smaller teams (i.e. less than 50 people), where HSE guidelines specify staff should be EFAW qualified or where they are supporting colleagues who hold a full First Aid at Work qualification. Learners should be a minimum of 16 years to undertake this qualification. 

Description
The informative and enjoyable one-day course will equip learners with the skills and confidence to respond to a range of first aid incidents and emergencies.

Course Content 
* What is First Aid?                                                                
* Legislation                                                                            
* Responsibilities of the First Aider.                                  
* Action in an Emergency                                                     
* Primary Survey                                                                    
* Secondary Assessment                                                     
* The Respiratory System                                                    
* Resuscitation &amp; AED                                                         
* Disorders of respiration                                                     
* Disorders of circulation                                                        
* Wounds &amp; Bleeding                                                          
* Seizures                                                                                
* Minor Burns and Scalds
* Foreign objects

How is this course assessed? 
Assessment is ongoing by the instructor, along with a multiple choice question paper, and a three-year qualification will be issued to those who satisfy the criteria. In addition, the HSE strongly recommend that all students undergo an annual refresher programme of three hours.

Price includes all apparatus &amp; Certificates for all delegates </p>

This course will equip learners with the skills and confidence to respond to first aid incidents.

Lvl3 Emergency First Aid at Work On-Site

<h3><b>Network design training course description</b></h3>
        <p>  This course provides you with the knowledge needed to
perform the design of a network infrastructure that
supports desired network solutions to achieve effective
performance, scalability, and availability. We recognise
that the role of design does not normally require hands
on skills but hands on sessions are used to reinforce the
theory not to teach configuration or troubleshooting.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
         <li>Create HA enterprise network designs.</li>
                  <li>Develop optimum Layer 3 designs.</li>
                  <li>Design effective modern WAN and data center
networks.</li>
                  <li>Develop effective migration approaches to IPv6.</li>
                  <li>Create effective network security designs.</li>
               							 </ul>
        <h5>
        <b>Network design training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone involved with network design.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP Foundation for engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Network design training course contents</b></h3>
      
				<h6><b>Part I Reliable, resilient enterprise L2/3 network design</b></h6>
         <b>Optimal Enterprise Campus Design:</b><br />Enterprise campus
				design principles, hierarchy, modularity, flexibility, resiliency.<br />
				<b>EIGRP design:</b> <br />EIGRP Design, Should you use EIGRP?<br />
				<b>OSPF design:</b><br /> OSPF scalability designs, OSPF area design,
OSPF Full-Mesh Design, OSPF Hub-and-Spoke Design, OSPF convergence design and optimization techniques.
				<br /><b>IS-IS Design:</b><br />The protocol, IS-IS hierarchical architecture,
IS-IS vs OSPF, IS-IS Deep Dive, IS-IS Design Considerations.
				<br /><b>BGP design:</b><br />BGP overview, Designing Scalable iBGP
Networks, BGP Route Reflector Design, Enhancing the Design
of BGP Policies with BGP Communities, Case Study:
Designing Enterprise wide BGP Policies Using BGP
Communities, BGP Load-Sharing Design.<br />
<h6><b>Part II Enterprise IPv6 Design Considerations</b></h6>
				<b>IPv6 Design Considerations in the Enterprise:</b><br /> IPv6
Deployment and Design Considerations, Considerations for
Migration to IPv6 Design, IPv6 Transition Mechanisms, Final
Thoughts on IPv6 Transition Mechanisms.
				<br /><b>Challenges of the Transition to IPv6:</b><br /> IPv6 Services, Link
Layer Security Considerations.
		<h6><b>Part III Modern Enterprise Wide-Area Networks Design</b></h6>
		<b>Service Provider-Managed VPNs:</b> <br />Choosing Your WAN
Connection, Layer 3 MPLS VPNs, Case Study: MPLS VPN
Routing Propagation, Layer 2 MPLS VPN Services.
		<br /><b>Enterprise-Managed WANs:</b><br /> Enterprise-Managed VPNs,
GRE, Multipoint GRE, Point-to-Point and Multipoint GRE,
IPsec, IPsec and dynamic VTI, DMVPN, Case Study: EIGRP
DMVPN, DMVPN and Redundancy, Case Study: MPLS/VPN
over GRE/DMVPN, SSL VPN.
		<br /><b>Enterprise WAN Resiliency Design:</b><br /> WAN Remote-Site
Overview, MPLS L3 WAN Design Models, Common L2 WAN
Design Models, Common VPN WAN Design Models, 3G/4G
VPN Design Models, Remote Site Using Local Internet,
Remote-Site LAN, Case Study: Redundancy and Connectivity,
NGWAN, SDWAN, and IWAN Solution Overview, IWAN
Design Overview, Enterprise WAN and Access Management.
		
<h6><b>Part IV Enterprise Data Center Designs</b></h6>
		<b>Multitier Data Center Designs:</b><br /> Case Study: Small Data
Centers (Connecting Servers to an Enterprise LAN), Case
Study: Two-Tier Data Center Network Architecture, Case
Study: Three-Tier Data Center Network Architecture.<br />
		<b>Trends and Techniques to Design Modern Data Centers:</b><br />
The Need for a New Network Architecture, Limitations of
Current Networking Technology, Modern Data Center Design
Techniques and Architectures, Multitenant Data Center.
		<br /><b>SDN:</b> <br />SDN characteristics, How SDN addresses current
Networking Limitations, SDN Architecture Components, SDN
Network Virtualization overlays.
		<br /><b>Data Center Connections:</b><br />Data Center Traffic Flows, The
Need for DCI, IP Address Mobility, Case Study: Dark Fiber
DCI, Pseudowire DCI.
				<h6><b>Part V Design QoS for Optimized User Experience</b></h6>
	<b>QoS Overview:</b><br />QoS Overview, IntServ versus DiffServ,
Classification and Marking, Policers and Shapers, Policing
Tools: Single-Rate Three-Color Marker, Policing Tools: TwoRate Three-Color Marker, Queuing Tools, Dropping Tools.
	<b>QoS design principles and best practices:</b><br /> QoS overview,
classification and marking design principles, policing and
remarking design principles, queuing design principles,
dropping design principles, Per-Hop behavior queue design
principles, RFC 4594 QoS Recommendation, QoS Strategy
Models. Campus QoS, WAN QoS, Data Center QoS.<br />
	<b>MPLS VPN QoS Design:</b><br /> The Need for QoS in MPLS VPN,
Layer 2 Private WAN QoS Administration, Fully Meshed
MPLS VPN QoS Administration, MPLS DiffServ Tunneling
Modes, Sample MPLS VPN QoS Roles.
	<br /><b>IPsec VPN QoS Design:</b><br /> The Need for QoS in IPsec VPN,
VPN Use Cases and Their QoS Models, IPsec Refresher,
Encryption and Classification: Order of Operations, MTU
Considerations, DMVPN QoS Considerations.
	<h6><b>Part VI IP Multicast Design</b></h6>
	<b>Enterprise IP Multicast Design:</b><br /> How Does IP Multicast
Work? Multicast Protocols, Multicast Forwarding and RPF
Check, Multicast Protocol Basics, PIM-SM Overview, Multicast
Routing Table, Basic SSM Concepts, Bidirectional PIM. RP
discovery, Anycast RP Features, MSDP.
	<h6><b>Part VII Designing Optimum Enterprise Network Security</b></h6>
	<b>Designing Security Services and Infrastructure Protection</b><br />
Network Security Zoning, Designing Infrastructure Protection.<br />
	<b>Designing firewall &amp; IPS solutions:</b><br /> Firewall architectures,
virtualized firewalls. Case Study: Application Tier separation,
Case Study: Firewalls in a Data Center, Case Study: Firewall
High Availability, IPS Architectures, Case Study: Secure
Campus Edge Design (Internet and Extranet Connectivity).
<br /><b>IP Multicast Security:</b><br /> Multicast Security Challenges,
Multicast Network Security Considerations.
	<br /><b>Designing Network Access Control Solutions:</b><br />IEEE
802.1X, EAP, 802.1X supplicants, 802.1X phased
deployment, Case Study: Authorization Options.
	<h6><b>Part VIII Design scenarios</b></h6>
	<b>Design Case Studies:</b><br /> 1: Enterprise Connectivity, 2:
Enterprise BGP with Internet Connectivity, 3: IPv6, 4: Data
Center Connectivity, 5: Resilient Enterprise WAN, 6: Secure
Enterprise Network, 7: QoS in the Enterprise Network.

Network design

<p id="isPasted"><span><strong><span>Emergency Response for Care Homes</span></strong></span></p><p id="isPasted"><span><strong>Course Overview:</strong></span></p><p><span>The "Emergency Response Refresher for Care Homes" course is designed to provide care and support workers, healthcare professionals, and staff working in care home settings with updated knowledge and practical skills for effectively responding to medical emergencies. This course focuses on emergency protocols, first aid techniques, communication strategies, and coordination efforts necessary to ensure the safety and well-being of residents in care homes.</span></p><p><span><strong>Course Duration:</strong></span></p><p><span>6 hours</span></p><p><span><strong>Course Content:</strong></span></p><ol><li>Scene safety</li><li>Casualty assessment</li><li>Primary survey</li><li>Recovery position</li><li>Resuscitation</li><li>Hygiene control</li></ol><p><span><strong>Course Objectives:</strong></span></p><ol><li id="isPasted">Review Emergency Protocols: Participants will refresh their understanding of care home emergency medical protocols.</li><li>Enhance Communication Skills: Effective communication is crucial during emergencies. This course will emphasize clear and concise communication techniques to ensure seamless coordination among care home staff, residents, and external responders.</li><li>First Aid: Participants will update their first aid skills and knowledge of basic medical assistance techniques, enabling them to provide immediate care to residents before professional help arrives.</li><li>Special Needs Consideration: Care home residents may have unique needs during emergencies. This course will address how to provide specialised care to individuals with disabilities, cognitive impairments, or medical conditions during crisis situations.</li><li>Crisis Management: Participants will learn effective crisis management techniques, including stress and anxiety management for both residents and staff, to maintain a sense of calm and order during high-stress situations.</li><li>Hazard Recognition: Understanding potential hazards within a care home environment is essential. The course will cover how to identify and mitigate common risks that could lead to emergencies.</li><li>Team Collaboration: Collaborative teamwork is critical during emergencies. Participants will learn how to work efficiently as a team, delegate responsibilities, and make informed decisions under pressure.</li><li>Regulatory Compliance: The course will provide updates on relevant regulations and standards related to emergency preparedness and response in care home settings.</li><li>Scenario-based Training: Practical exercises and simulated scenarios will allow participants to apply their knowledge and skills in realistic emergency situations, enhancing their confidence and readiness.<br /><br /></li></ol><p><span><strong>Course Assessment:</strong></span></p><ul><li><span>Participant proficiency will be assessed through:</span></li><li><span>Quizzes and assessments measuring theoretical understanding.</span></li><li><span>Practical evaluations of first aid techniques and emergency responses.</span></li><li><span>Participation in scenario-based discussions and exercises.</span></li><li><span>A final assessment covering the course's key components.</span></li></ul><p><span><br /></span></p><p><span id="isPasted"><strong><span>Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.</span></strong></span></p>

Guardian Angels Training

The "Emergency Response for Care Homes" course is designed to provide care home staff with essential knowledge and skills to effectively respond to a wide range of emergency situations. This course aims to reinforce and update the participants' understanding of emergency protocols, procedures, and best practices, ensuring a safe and coordinated response in times of crisis.

Emergency Response for Care Homes

Loughborough

<div>
		

		<div>
			
			<p>Our suite of modules are based around helping the customer to buy and enabling salespeople to maximise their conversations with their customers.</p>
			<div><i></i> 3.5 Days</div>
			<div><i></i>  £1,557.50 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><h3>How effective are your salespeople in engaging with your customers?</h3>
<p>MPI have gained vast experience over many years working with our clients in numerous markets and countries. Our programmes help even the most experienced sales people to be more effective and successful with a wider range of customers and markets.</p>
<p><span>We use the behavioural science of communication as the core to customer engagement at all levels Our InSales suite of modules are based around helping the customer to buy and enabling salespeople to maximise their conversations with their customers.</span></p>
<h3>Participant Outcomes:</h3>
<ul>
<li>Understand the importance of planning and preparation for success in sales.</li>
<li>Create your own 'Story' to sell the benefits of a meeting.</li>
<li>Know what to say, how to say it, and why?</li>
<li>Understand how your communication is a critical ingredient in successful sales conversations with customers.</li>
<li>Learn the skills required for successful customer calls.</li>
<li>Demonstrate your questioning skills to uncover the customers 'real' values based reasons to buy using our '4C's' framework.</li>
<li>Develop level 4 listening skills, listen and understand, and help the customer to buy.</li>
<li>Develop your skill in the benefit of selling the 'sizzle' which is compelling to your customer.</li>
<li>Be skilled in asking the right questions to overcome potential objections and doubts.</li>
<li>Revise and perfect your closing style to win more sales.</li>
<li>Participate in a 'Sales Challenge' and receive professional personal feedback and coaching.</li>
</ul>
<h3>Aimed at supporting the company outcome of:</h3>
<ul>
<li>Your sales team delivering the results you expect of them.</li>
<li>Your sales team demonstrating their newly acquired professional sales skills.</li>
<li>Your sales team developing the competencies you need them to demonstrate.</li>
<li>A programme tailored to your organisational sales culture.</li>
<li>Creating and delivering the businesses desired sales journey and a customer buying experience.</li>
</ul>
<p>Our approach is aimed at ensuring that the programme delivers what you need it to. The Professional Sales Programme is based upon a framework of subjects that are tailored to meet your business need and the outcome you want to achieve.</p>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £6,107.50 Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Get Them Ready</h3>
<p>We have created pre course activities which ensure your people are ready to gain the most from this programme:</p>
<ul>
<li>Information to use in case studies and skills practice - templates provided</li>
<li>Preparing their KASH/B (Knowledge, Attitude, Skills, Habits/Behaviours) for their role</li>
<li>A day in their life as a sales professional</li>
</ul>
<h3>The Sales Professional Master-class: A 3-day event</h3>
<p>This programme ensures that every one of the team walks away with lessons that they can use in their sales environment.</p>
<ul>
<li>Our InSales framework provides the core content.</li>
<li>The way we deliver the content varies based upon the sales teams experience and the outcome you want to achieve.</li>
<li>We ensure that the sales professional is involved from the start</li>
<li>The Professional Sales framework provides an 'experiential learning event', which provides the focus and insight for the salesperson on what they do well, what they need to improve (with the how) where they need reinforcement new or refresher skills.</li>
<li>The programme format will depend upon the experience of the salespeople and the business outcome you want to achieve</li>
<li>We use a Sales Challenge framework built upon your business and your customers' needs and wants. This provides MPI with the insight into the skills and behaviours that need to be further enhanced.</li>
<li>We use 'Team Coaching' to support individual and team skills and behaviour development in the areas that will make the difference.</li>
</ul>
<h3>The Sales Managers Toolbox</h3>
<p>Experience tells us that unless there is follow up by the company then the impact of the training is weakened. This toolbox is therefore a vital ingredient for success. It provides the support enabling the sales manager to embed the skills and behaviours learned on the programme.</p>
<p>It contains all of the models that the sales professional experiences and learns on the sales programme and is in soft copy format. A digital version of the toolbox can be built with a voice over coach to provide guidance.</p>
<h3>WebEx Skills Surgery 'Embeds the learning and ongoing development'</h3>
<p>A series of follow up sessions with the Sales Team to identify and measure progress, highlighting their 'Magic Moments and Successes' and where they need additional support.</p>
<p>Delivered as simple open sessions which can be provided for all sales people in one session, or as individual sessions.</p>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Our suite of modules are based around helping the customer to buy and enabling salespeople to maximise their conversations with their customers.

Professional Sales Programme

Nottinghamshire

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge to enable them to comply with working at height regulations, and go in depth into industry dangers and respectability when working at height.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">&nbsp;This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 1/2 day</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1/2 day.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N404 Safe Working At Height</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br 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 when working at height<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to define height work and identify the hazards of work above ground level and outline the general requirements necessary to control them<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to identify accident causation in work at height<br fr-original-style="" style="box-sizing: border-box;">➢ Have an appreciation of planning and organisation of work at height<br fr-original-style="" style="box-sizing: border-box;">➢ Set up exclusion zone explaining actions required for emergency actions, identifying any overhead hazards<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for safe working at height use<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate working at height and explain all safety issues that could arise</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test.</p>

Dynamic Training and Assessments Ltd

NVQ Assessor

NPORS

Working At Heights

NEBOSH

NPORS Safe Working at Height (N404)

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Manage project costs</li><li>Consolidate and reuse project plan information</li><li>Exchange project plan data with other applications</li><li>Update a project plan</li><li>Customise Project to meet specific requirements</li></ul><p>' 1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further</strong></li><li>Jenny Price - Acer</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Exchanging Project Plan Data with Other Applications</p><ul><li>Import a list of tasks from Outlook</li><li>Import a Task List from an Excel File</li><li>Create a Custom Import Map</li><li>Export Project Plan Cost Data into Excel</li><li>Save Project Plan Information as a Web Page</li></ul><p>Updating a Project Plan</p><ul><li>Enter Task Progress Information</li><li>View Task Progress</li><li>Split a Task</li><li>Reschedule a Task</li></ul><p>Creating Custom Fields</p><ul><li>Text fields</li><li>Lookup fields</li><li>Calculated fields with the use of formulas and functions</li><li>Inserting Graphical Indicators</li></ul><p>Customizing how you look at data</p><ul><li>Filter Tasks in a Project Plan</li><li>Create a Custom Table</li><li>Create a Custom View</li><li>Copy custom Views and Tables between projects</li></ul><p>Earned value analysis</p><ul><li>Understanding Earned Value Fields</li><li>View Multiple Baselines in a Single Project</li><li>Tracking progress between interim plans</li></ul><p>Creating Custom Reports</p><ul><li>Create a Custom Report</li><li>Modify a Custom Report's Header and Footer</li><li>Add a Picture to a Report</li><li>Modify a Custom Report's Margins</li><li>Print a Custom Report</li></ul><p>Re-using Project Plan Information</p><ul><li>Create a Project Plan Template</li><li>Create a Custom Combination View</li><li>Make Custom Views Available to Other Project Plans</li><li>Share Resources between Projects,</li><li>Create a Master Project Plan with sub projects</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the MS Project Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div>

Microsoft Office Training

Microsoft Project Advanced - In-company (now with trainer led live online classes)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Mental Health First Aid Refresher 4-hour training sessions</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can you remember ALGEE?&nbsp;</strong>Mental Health Action Plan.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). &nbsp;If it&#39;s time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Revisit the key areas from the full course. Keep up to date with the latest statistics and information.</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. &nbsp;Mental Health First Aid training can be kept up to date through this four hour MHFA Refresher course, which will empower you to: &nbsp;Update your knowledge of mental health and what influences it Update your awareness of current mental health supports available Practise applying the Mental Health First Aid Action Plan. Learning takes place through a mix of presentations, group discussions and workshop activities. We limit numbers to 20 people per course so that the instructor can keep people safe and supported, to get the most from their learning experience with us.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those that have completed the MHFA England Mental Health First Aid or Champion course.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/faq-s/" 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;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">FAQs</span></a></u></p>

Mental Health First Aid Refresher 4-hour training sessions
Can you remember ALGEE? Mental Health Action Plan.
Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.
Revisit the key areas from the full course. Keep up to date with the latest statistics and information.
If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. Mental Health First Aid training can be kept up to date through this four hour MHFA Refresher course, which will empower you to: Update your knowledge of mental health and what influences it Update your awareness of current mental health supports available Practise applying the Mental Health First Aid Action Plan. Learning takes place through a mix of presentations, group discussions and workshop activities. We limit numbers to 20 people per course so that the instructor can keep people safe and supported, to get the most from their learning experience with us.
This course is for those that have completed the MHFA England Mental Health First Aid or Champion course. 
FAQs

Mindmaps Wellbeing

Mental Health Awareness

Mental Health First Aid

Approved Training Organisation (ATO)

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Wellbeing

Mental Resilience

Mental Health At Work

Mental Health Nurse

Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years).  If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.

MHFA England Refresher 

Active Lancashire

MECC 90mins Online Familiarisation / Refresher 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(62, 62, 62); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(62, 62, 62);">The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style="color: rgb(62, 62, 62);"><span style="color: rgb(36, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(36, 35, 35);">All too often DSLs and Deputy DSLs come to us fed up with the dull &#39;death by powerpoint&#39; statutory training they have attended through their LA, or the &#39;watch, click and multiple-choice&#39; DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!</span><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><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></p>

The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.
All too often DSLs and Deputy DSLs come to us fed up with the dull 'death by powerpoint' statutory training they have attended through their LA, or the 'watch, click and multiple-choice' DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!

View all testimonials

Brightcore Consultancy

Designated safeguarding lead (DSL)

The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.

Designated Safeguarding Lead Refresher Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">his 2 hour session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The course will cover:<img src="https://images.cademy.co.uk/cd74539b-d6a2-46d2-9df6-1144792fca8b/ccf32df0-3acf-4386-9008-ca93939f3bb8/original.png" style="width: 188px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 188px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right;" fr-original-class="fr-draggable"></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The purpose of the role (reminder)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How the role has evolved</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What lessons can be gained so far</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How do you create a culture of compliance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What good systems, policies and procedures look like</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Easy tips on what, where and how you should be looking</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="22" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="22:0" fr-original-style="" style="box-sizing: border-box;">Target Audience</span></span></h2><p data-key="23" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlRhcmdldCUyMEF1ZGllbmNlJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhlJTIwb25saW5lJTIwY291cnNlJTIwaXMlMjBzdWl0YWJsZSUyMGZvciUyMHN0YWZmJTIwb2YlMjBhbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwc3VwcG9ydCUyMHN0YWZmJTIwdG8lMjBzZW5pb3IlMjBwYXJ0bmVycy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities.</p><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference.</p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/sarah-charlton/" 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Sarah Charlton, Consultant, DG Legal</span></strong></a></h3><p data-key="39" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><img src="https://images.cademy.co.uk/cd74539b-d6a2-46d2-9df6-1144792fca8b/be6c499f-96da-4f30-ab0b-c93b88a4fb82/original.png" style="width: 194px; display: inline-block; vertical-align: bottom; margin: 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 194px; 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">Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

This 2 hour session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on. 
The course will cover:

The purpose of the role (reminder)
How the role has evolved
What lessons can be gained so far
How do you create a culture of compliance
What good systems, policies and procedures look like
Easy tips on what, where and how you should be looking
Target Audience
This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities.
Resources
An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference.
Please note a recording of the course will not be made available.
Speaker
Sarah Charlton, Consultant, DG Legal

Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.





DG Legal

Compliance Officer For Finance and Administration (COFA) Masterclass Course

General Delegate

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

Retainer Delegate

<p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 35, 35);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PLEASE NOTE - This course is Day 1 of a 2 day process - All new DSLs/DDSLs should also attend the first day of Training (New to DSL DAY 1) to complete their training</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">. </strong></span></p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 35, 35);">The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL. It is an extensive, authoritative and highly rated, full-day training course that ensures DSLs &amp; DDSLs have the most comprehensive, effective and up-to-date understanding of and knowledge of how to lead the safeguarding provision in their setting.</p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(36, 35, 35);">All too often DSLs and Deputy DSLs come to us fed up with the dull &#39;death by powerpoint&#39; statutory training they have attended through their LA, or the &#39;watch, click and multiple-choice&#39; DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!</p><p style="text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><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></p>

PLEASE NOTE - This course is Day 1 of a 2 day process - All new DSLs/DDSLs should also attend the first day of Training (New to DSL DAY 1) to complete their training. 
The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL. It is an extensive, authoritative and highly rated, full-day training course that ensures DSLs & DDSLs have the most comprehensive, effective and up-to-date understanding of and knowledge of how to lead the safeguarding provision in their setting.
All too often DSLs and Deputy DSLs come to us fed up with the dull 'death by powerpoint' statutory training they have attended through their LA, or the 'watch, click and multiple-choice' DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!
View all testimonials

The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL.

New to the role DSL Training - DAY 2

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This CPD accredited HACCP Refresher &amp; Update course is for those who already hold a Level 3 or Level 4 HACCP qualification and are looking to refresh their knowledge of the subject. This course will also include updates to the subject so that attendees can feel confident that they are aware of changes and industry thinking and challenges relating to HACCP.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical &amp; Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage &amp; distribution.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The qualification is also relevant to those owning/managing smaller food businesses to refresh underpinning knowledge to develop and maintain a &nbsp;Food Safety Management System.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">HACCP training is regarded by the Foods Standards Agency &amp; Codex Alimentarius International Food Standards as being essential to maintain good practice in the production of safe food.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p>

This CPD accredited HACCP Refresher & Update course is for those who already hold a Level 3 or Level 4 HACCP qualification and are looking to refresh their knowledge of the subject. This course will also include updates to the subject so that attendees can feel confident that they are aware of changes and industry thinking and challenges relating to HACCP.
Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical & Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage & distribution.
The qualification is also relevant to those owning/managing smaller food businesses to refresh underpinning knowledge to develop and maintain a Food Safety Management System.
HACCP training is regarded by the Foods Standards Agency & Codex Alimentarius International Food Standards as being essential to maintain good practice in the production of safe food.
This course has been accredited by the CPD Accreditation Office for delivery, structure and content.

Ask Sonia Limited

Food Safety

HACCP

CPD accredited HACCP Refresher & Update course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited HACCP & Refresher & Update (1 day)

Grantham

CILT PCV Transport Manager Refresher / OLAT 2 Day Course Online
Our OLAT & Transport Manager Courses are CILT (Chartered Institute of Logistics and Transport) accredited and so they are one of the courses recommended by the Traffic Commissioner, and they are also FORS Approved Manager Training.
If you are in contact with the Traffic Commissioner for any reason, especially if you have applied to be transport manager for an organisation, you are strongly advised to attend a 2-day course, which is often recommended by the Traffic Commissioner as the most appropriate.
This course will cover the following areas:
•Background to the Operator’s Licence
•Compliance enforcement
•Working time & driver’s hours
•Vehicle roadworthiness and defect reporting
•Construction and use requirements
•Driver licences/driver CPC
•Speed limits
•Environmental considerations
On completion of this course, you will be able to:
•Recount the requirement to obtain and maintain an operator licence.
•Demonstrate how and why driver hours legislation are crucial to safety and compliance to the undertaking.
•State the responsibilities of management and drivers have regarding vehicle roadworthiness and defect reporting.
•Identify the requirements of driver licence/DQC checks.
•Demonstrate an awareness of sector legislative awareness, safe fleet operation and environmental requirements.
Our courses offer both in-person and online learning options.
Completion of the remote learning course will gain you the same accreditation as completion of the face-to-face training course.
Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312 and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Once registered, your booking will be complete, and a member of the team will contact you.
Login details will be given 48 hours prior to the course starting.
This is a two-day course, the start time is 8am each day.
Course cost includes 2-day training £411 (£280 course fee, CILT certification fee £75) plus VAT. 

Total Compliance 

Driving & Vehicles

Compliance & Safety

CILT PCV Transport Manager Refresher / OLAT 2 Day Course Online & In-person

CILT HGV Transport Manager Refresher / OLAT 2 Day Course Online
Our OLAT & Transport Manager Courses are CILT (Chartered Institute of Logistics and Transport) accredited and so they are one of the courses recommended by the Traffic Commissioner, and they are also FORS Approved Manager Training.
If you are in contact with the Traffic Commissioner for any reason, especially if you have applied to be transport manager for an organisation, you are strongly advised to attend a 2-day course, which is often recommended by the Traffic Commissioner as the most appropriate.
This course will cover the following areas:
•Background to the Operator’s Licence
•Compliance enforcement
•Working time & driver’s hours
•Vehicle roadworthiness and defect reporting
•Construction and use requirements
•Driver licences/driver CPC
•Speed limits
•Environmental considerations
On completion of this course, you will be able to:
•Recount the requirement to obtain and maintain an operator licence.
•Demonstrate how and why driver hours legislation are crucial to safety and compliance to the undertaking.
•State the responsibilities of management and drivers have regarding vehicle roadworthiness and defect reporting.
•Identify the requirements of driver licence/DQC checks.
•Demonstrate an awareness of sector legislative awareness, safe fleet operation and environmental requirements.
Our online courses work in the same way that our classroom courses do, but they are completed via the online platform called Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone.
Completion of the remote learning course will gain you the same accreditation as completion of the face-to-face training course.
Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312 and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Once registered, your booking will be complete, and a member of the team will contact you.
Login details will be given 48 hours prior to the course starting.
This is a two-day course, the start time is 8am each day.
Course cost includes 2-day training £411 (£280 course fee, CILT certification fee £75) plus VAT. 

CILT HGV Transport Manager Refresher / OLAT 2 Day Course Online & In-person

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p><p>Writing is a key method of communication for most people, and it?s one that many people struggle with. This workshop will give participants a refresher on basic writing concepts (such as spelling, grammar, and punctuation), and an overview of the most common business documents (such as proposals, reports, and agendas), giving you that extra edge in the workplace.</p></div><div id="course-pills-2"><h3>1 - Getting Started</h3> <ul> <li>Workshop Objectives</li> <li>Pre-Assignment Review</li> </ul> <h3>2 - Working with Words</h3> <ul> <li>Spelling</li> <li>Grammar</li> <li>Creating a Cheat Sheet</li> </ul> <h3>3 - Constructing Sentences</h3> <ul> <li>Parts of a Sentence</li> <li>Punctuation</li> <li>Types of Sentences</li> </ul> <h3>4 - Creating Paragraphs</h3> <ul> <li>The Basic Parts</li> <li>Organization Methods</li> </ul> <h3>5 - Writing Meeting Agendas</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Agenda</li> </ul> <h3>6 - Writing E-mails</h3> <ul> <li>Addressing Your Message</li> <li>Grammar and Acronyms</li> </ul> <h3>7 - Writing Business Letters</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Letter</li> </ul> <h3>8 - Writing Proposals</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Proposal</li> </ul> <h3>9 - Writing Reports</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Report</li> </ul> <h3>10 - Other Types of Documents</h3> <ul> <li>Requests for Proposals</li> <li>Projections</li> <li>Executive Summaries</li> <li>Business Cases</li> </ul> <h3>11 - Proofreading and Finishing</h3> <ul> <li>A Proofreading Primer</li> <li>How Peer Review Can Help</li> <li>Printing and Publishing</li> </ul> <h3>12 - Wrapping Up</h3> <ul> <li>Words from the Wise</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Business Writing training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Business Writing course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Content Writing

Writing Skills

Book Writing

Trainers Course

Business English

Business Writing

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This is an excellent starter/refresher course, whether you&rsquo;re a recent graduate or a mid/senior professional.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn spreadsheet modelling best practice</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Look over excel tips for general day to day use in MS Excel</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognise spreadsheet navigation and presentation tricks</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand financial mathematics &amp; conventional valuations</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Identify real estate cash flow model single-let common functions and formulas</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Graduate Real Estate professionals</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">APC candidates</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Mid-Senior professionals looking for a refresher on core model building skills and best practice</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Any professionals looking to learn how to build a real estate focused model from scratch.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One:</strong></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conventional Valuations</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Layer Method</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Over Rented</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Cash Flow Models (Single-Let)</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Annual Discounted Cash Flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;What If&rdquo;&nbsp;</em></em>Analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Quarterly Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flows with Rent Review</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Multiple Rent Reviews</li><li value="6" fr-original-style="" style="box-sizing: border-box;">NPV, IRR, Equity Multiple, Cash on Cash</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional topics:</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">IF, SUMIF &amp; Switches&rsquo;</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Sensitivity Analysis: Data Table &amp; Changing Calculation Options</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Other Excel tips and tricks, including navigation and presentation:</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A Bayfield Training Certification &amp; 7.5 CPD Hours</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" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Course Files</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the An Introduction to Real Estate in Excel such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.
This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.
This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.


On this course, you will…
Learn spreadsheet modelling best practice
Look over excel tips for general day to day use in MS Excel
Recognise spreadsheet navigation and presentation tricks
Understand financial mathematics & conventional valuations
Identify real estate cash flow model single-let common functions and formulas


Who will benefit from this course?
Graduate Real Estate professionals
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
APC candidates
Mid-Senior professionals looking for a refresher on core model building skills and best practice
Any professionals looking to learn how to build a real estate focused model from scratch.


Day One:


Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield


Real Estate Cash Flow Models (Single-Let)
Annual Discounted Cash Flows
“What If” Analysis
Quarterly Discounted Cash Flow
Cash Flows with Rent Review
Multiple Rent Reviews
NPV, IRR, Equity Multiple, Cash on Cash


Additional topics:
IF, SUMIF & Switches’
Sensitivity Analysis: Data Table & Changing Calculation Options


Other Excel tips and tricks, including navigation and presentation:
Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC
Included in the Course
A Bayfield Training Certification & 7.5 CPD Hours
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 An Introduction to Real Estate in Excel 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

Financial Analysis

Financial Management

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

53 Courses in Belfast

One Day Forklift Refresher Course On-Site

By Gl Training Services

Managing Safely Refresher - IOSH Award (In-House)

By The In House Training Company

XSLT

By Systems & Network Training

CITB Health & Safety Awareness (On-Site)

By You Can Do It .Training

Lvl3 Emergency First Aid at Work On-Site

By You Can Do It .Training

Network design

By Systems & Network Training

Emergency Response for Care Homes

By Guardian Angels Training

Professional Sales Programme

By Mpi Learning - Professional Learning And Development Provider

NPORS Safe Working at Height (N404)

By Dynamic Training and Assessments Ltd

Microsoft Project Advanced - In-company (now with trainer led live online classes)

By Microsoft Office Training

Search By Location