Harpenden

<p>This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists.</p>This course will help participants:<ul><li>Create and manage the layout of paragraphs</li><li>Create and manage multi-level numbered paragraphs</li><li>Effectively insert, use and manage section breaks</li><li>Create and manage columns</li><li>Find, create and apply styles</li><li>Create and update a table of contents from styles</li><li>Work with styles to manage formatting</li><li>Work with sums in tables and use table headings</li><li>Input and edit text using AutoText</li><li>Work with SmartArt graphics</li><li>Link to other files using paste special</li></ul><section>
                    <h3>1 Managing paragraph layout</h3><ul><li>Controlling paragraph layouts with indents</li><li>Creating and managing paragraph hanging indents</li></ul> <h3>2 Numbering paragraphs</h3><ul><li>Creating a new multi-level numbered paragraph</li><li>Managing existing multi-level numbered paragraphs</li></ul> <h3>3 Inserting columns</h3><ul><li>Creating columns from existing paragraphs</li><li>Setting up columns</li><li>Managing columns</li></ul> <h3>4 Document section breaks</h3><ul><li>Controlling document layout using section breaks</li><li>Managing page orientation using section breaks</li><li>Managing page numbering using section breaks</li></ul> <h3>5 Using styles</h3><ul><li>Applying quick styles</li><li>Finding existing styles</li><li>Creating and saving styles</li><li>Modifying styles</li><li>Creating a table of contents from styles</li><li>Updating a table of contents</li></ul> <h3>6 Using quick parts</h3><ul><li>Saving content to quick parts</li><li>Modifying saved quick parts</li><li>Inserting content using AutoText</li><li>Editing AutoText entries</li><li>Inputting text using AutoCorrect</li></ul> <h3>7 Advanced table features</h3><ul><li>Sorting table columns</li><li>Running sums in tables</li><li>Repeating table headings at top of page</li><li>Importing Excel content in tables</li><li>Using table properties</li></ul> <h3>8 Creating a mail merge</h3><ul><li>Creating letters, labels and emails</li><li>Merging addresses from external files</li><li>Using Outlook's address book to merge</li><li>Merging to email</li></ul> <h3>9 SmartArt graphic</h3><ul><li>Visually communicate content with SmartArt</li><li>Choosing a SmartArt graphic</li><li>Inputting into SmartArt</li><li>Modifying and formatting SmartArt graphics</li></ul> <h3>10 Linking to other files</h3><ul><li>Linking to files using paste special</li><li>Linking an Excel chart to a document</li><li>Managing linked content from Word</li></ul> 


                </section>

The In House Training Company

Office Skills & Productivity

Office Skills

Office Productivity

Computer Skills

Microsoft Office

Microsoft Word

Word - intermediate (In-House)

<p>There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service.</p><p>It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.</p><p>It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.</p><p>The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.</p><section>
                    <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


                </section>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - introduction (2 day) (In-House)

<p>This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks.</p>This course will help participants:<ul><li>Gain confidence using Outlook and its advanced features</li><li>Organise and prioritise email messages</li><li>Archive messages for safe-keeping</li><li>Use rules to process received or sent messages automatically</li><li>Manage scheduled meetings with others</li><li>Give others permission to view and manage their folders and items</li><li>Use contacts and commands to find out more about a person or company</li><li>Prioritise work-flow using tasks and assigning tasks to others</li></ul><section>
                    <h3>1 Email messages</h3><ul><li>Combining multiple clicks with quick steps</li><li>Following up flag options</li><li>Saving multiple attachments</li><li>Attaching a folder of files</li><li>Recalling and replacing a message</li><li>Categorising messages with conditional formatting</li></ul> <h3>2 Message options</h3><ul><li>Adding options to messages</li><li>Marking a message as private</li><li>Receiving quick responses with voting buttons</li><li>Directing replies to specific users</li><li>Delaying sent messages</li><li>Inserting links in messages</li></ul> <h3>3 Stay organised with rules</h3><ul><li>Using rules to automate message flow</li><li>Moving messages with rules</li><li>Using the rules wizard</li><li>Setting up rules with conditions</li><li>Using rules that work whilst you are away</li></ul> <h3>4 Message clean-up</h3><ul><li>Using conversation clean-up</li><li>Using mailbox clean-up</li><li>Moving messages to the archive folder</li><li>Archiving folder properties</li><li>Auto-archiving properties</li></ul> <h3>5 Managing calendars</h3><ul><li>Creating calendar groups</li><li>Sharing calendars with permissions</li><li>Setting up working days and times</li><li>Managing time zones</li><li>Categorise appointments with conditional formatting</li><li>Publishing a calendar</li></ul> <h3>6 Schedule meetings</h3><ul><li>Scheduling a meeting</li><li>Managing meeting responses</li><li>Proposing new meeting times</li><li>Adding attendees to a meeting</li><li>Viewing multiple appointments</li></ul> <h3>7 Using contacts</h3><ul><li>Merging contacts to letters</li><li>Merging contacts to labels</li><li>Mail merging contacts in Word</li><li>Exporting contacts to Excel</li></ul> <h3>8 Managing tasks</h3><ul><li>Organising your workload with tasks</li><li>Categorising tasks</li><li>Assigning tasks to others</li><li>Sending a task status report</li><li>Allocating time for tasks</li><li>Regenerating a new task</li><li>Viewing your tasks in the calendar</li></ul> <h3>9 Adding message items</h3><ul><li>Adding calendars to messages</li><li>Adding business cards to messages</li></ul> <h3>10 Email accounts</h3><ul><li>Adding multiple user accounts</li><li>Adding account permissions</li></ul> 


                </section>

Office Management

Gmail Productivity

Outlook

Microsoft Outlook

Outlook - advanced (In-House)

<p>R&amp;D work is often carried out in entrepreneurial companies with the aim of developing solutions to scientific or technological problems for a wide range of customers. Projects can include longer term 'frontiers of science' research, medium term product development/manufacturing or more immediate troubleshooting or contract research assignments.</p><p>In all these contexts, the ability to create innovative solutions in a timely and cost-effective manner is the essence of successful R&amp;D. Whilst R&amp;D groups typically excel in technical expertise, those involved often recognise that there is scope for improving the way that projects are managed. The aim of this training programme is to address this need whilst ensuring that the creative, entrepreneurial spirit that is fundamental to good R&amp;D continues to flourish.</p><section>
                    MODULE 1: Creating the foundations for success <ul><li>Off-line video tutorials and exercises</li><li>Total time ~ 1 - 1.5 hours</li></ul> 	<i></i><h3>Video 1: Making the most of project management in R&amp;D</h3><ul><li>Characterising R&amp;D projects</li><li>Applying project management to R&amp;D work</li><li>Exploiting the potential of project management in R&amp;D</li></ul> 	<i></i><h3>Video 2: Promoting success in R&amp;D project management</h3><ul><li>Modelling successful project management</li><li>Evaluating performance and promoting success</li><li>The role and skills of the project manager/leader</li></ul> MODULE 2: Initiating and defining R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Selecting and initiating projects</h3><ul><li>Recognising worthwhile opportunities; initiating projects</li><li>Identifying stakeholders and their goals</li><li>Characterising and engaging stakeholders</li></ul> <h3>Session 2: Defining goals and agreeing deliverables</h3><ul><li>Establishing the full scope of the project</li><li>Clarifying and prioritising project deliverables</li><li>Defining and agreeing deliverable specifications</li></ul> MODULE 3: Planning R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Identifying and organising activities</h3><ul><li>Creating effective plans; avoiding planning pitfalls</li><li>Identifying tasks and assigning responsibilities</li><li>Sequencing tasks and estimating durations</li></ul> <h3>Session 2: Developing the timeline and resource plan</h3><ul><li>Identifying the 'critical path'; creating a resource plan</li><li>Dealing with estimating uncertainty</li><li>Accelerating the programme</li></ul> MODULE 4: Leadership and teamwork in R&amp;D projects <ul><li><strong>Off-line </strong>video tutorials and exercises</li><li>Total time ~ 1 - 1.5 hours</li></ul> 	<i></i><h3>Video 1: Working effectively in project teams</h3><ul><li>Building teamwork in contemporary organisations</li><li>Recognising each other's skills; building synergy</li><li>Building good working relationships; handling conflict</li></ul> 	<i></i><h3>Video 2: The role of the R&amp;D project team leader</h3><ul><li>Building teamwork: the role of leadership</li><li>Creating an effective team culture</li><li>Delegating work and motivating team members</li></ul> MODULE 5: Managing uncertainty in R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Characterising uncertainty; identifying risks</h3><ul><li>Exploring uncertainty; applying risk management</li><li>Focusing the risk management process</li><li>Identifying and defining risk events</li></ul> <h3>Session 2: Managing and controlling risks to the project</h3><ul><li>Evaluating risk events</li><li>Selecting between risk strategies; setting contingencies</li><li>Updating and controlling exposure to risk</li></ul> MODULE 6: Implementing and controlling R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Initiating assignments and managing changes</h3><ul><li>Creating a pro-active implementation and control culture</li><li>Establishing effective implementation and control procedures</li><li>Assigning work and managing changes</li></ul> <h3>Session 2: Monitoring, managing and developing performance</h3><ul><li>Adopting meaningful monitoring techniques</li><li>Responding to problems; building performance</li><li>Managing and controlling multiple project assignments</li></ul> 


                </section>

Learning & Development

Online Course Marketing

Online Course Creation

Project Leadership

Project Management

Manager Training

R&D project management (In-House)

Bury St Edmunds

Thetford

<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;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Embark on a transformative journey with our Level 4 Certificate in First Response Emergency Care (FREC 4). This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.</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);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">This course is tailor-made for those seeking to expand their expertise in the NHS, private ambulance services, or specialised roles in the military, police, and fire services. It&#39;s a stepping stone for those dedicated to saving lives and providing care when it matters most.</span><br fr-original-style="" style="box-sizing: border-box;"></span></p><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dynamic Course Structure</strong></span></h4><ul data-rte-list="default" 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;"><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;">Rich Learning Experience:</strong>&nbsp;Delve into 180 hours of <a href="https://nrmedical.training/pre-hospital-training/rtacc" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">immersive learning</a>, including at least 39 hours of interactive, guided instruction.</p></li><li fr-original-style="" style="box-sizing: border-box;"><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;">Engaging Content:</strong> The course comprises a singular, robust unit segmented into three captivating components.</p></li><li fr-original-style="" style="box-sizing: border-box;"><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;">Flexible Completion:</strong> Complete this enriching journey within 12 months, including any necessary referrals.</p></li></ul><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Your Pathway to the Course</strong></span></h4><ul data-rte-list="default" 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;"><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;">Age Requirement:</strong> You should be 18 or older to start this life-changing course.</p></li><li fr-original-style="" style="box-sizing: border-box;"><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;">Prerequisites:</strong> A valid Qualsafe Level 3 Award in First Response Emergency Care (RQF) or equivalent is your gateway to this advanced level.</p></li><li fr-original-style="" style="box-sizing: border-box;"><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;">Literacy Proficiency:</strong> We recommend a minimum of Level 2 in literacy or equivalent to fully benefit from the course content.</p></li></ul><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Beyond the Course</strong></span></h4><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This qualification doesn&rsquo;t just end with a certificate. It paves the way for further educational endeavours and career growth in related fields. Keep the learning alive with ongoing CPD and annual refresher training.</p><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dual-Instructor Advantage on Our FREC 4 Courses!</strong></span></h4><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">At NR Medical Training, we distinguish ourselves from other training centres by consistently conducting our FREC 3 and FREC 4 courses with a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">minimum of two expert instructors</strong>, comprised of experienced Paramedics and EMTs. This approach sets us apart in the field of emergency care training, as many other centres often provide only the minimum requirement of one instructor per course. Our commitment to having at least two highly qualified professionals allows us to offer a far more immersive and dynamic learning environment. This dual-instructor model not only enhances the depth and breadth of the training scenarios, making them more realistic and engaging, but also gives our learners the unique advantage of drawing upon a wider pool of real-world experience and expertise. This enriched learning atmosphere ensures that our trainees receive the most comprehensive and practical education, preparing them to excel in high-pressure emergency situations.</p>

NR Medical Training

This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.

FREC 4

Sheffield

<h3 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 34px; box-sizing: border-box;" fr-original-style="font-size: 34px;">Empower your team to reduce stress levels in the workplace.</span>
<br fr-original-style="" style="box-sizing: border-box;">
</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Our popular Stress Management Training Course is designed to provide your employees with highly practical techniques to effectively manage stress in the workplace &amp; in their daily life.</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;">This course is designed to improve your mental health and well-being with a practical toolkit to help your people excel under pressure.</span></p><ul fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">

</span>
<li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Reduce stress</strong> levels at work.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Avoid <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">mental exhaustion</strong> and tiredness.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recognise your <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">triggers</strong> and manage them better.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Become <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">more productive</strong> &amp; start thriving under pressure.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Gain proven <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">stress management skills</strong> to cope with stress at work.</li></ul><div fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
</div><div fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
</div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><a href="mailto:Info@LiveAndLearnConsultancy.co.uk?Subject=Re: Stress Management Training for Staff" style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(33, 146, 210); border-width: 14px 16px 14px 18px; border-style: solid; border-color: rgb(33, 146, 210); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" fr-original-style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #2192d2; border-top: 14px solid #2192d2; border-bottom: 14px solid #2192d2; border-right: 16px solid #2192d2; border-left: 18px solid #2192d2; display: inline-block;">Email Us Now &nbsp;&gt;</a>&nbsp; <a href="https://www.liveandlearnconsultancy.co.uk/wellbeing-programs-for-employees/" style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(1, 176, 119); border-width: 14px 16px 14px 18px; border-style: solid; border-color: rgb(1, 176, 119); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" fr-original-style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #01b077; border-top: 14px solid #01b077; border-bottom: 14px solid #01b077; border-right: 16px solid #01b077; border-left: 18px solid #01b077; display: inline-block;">View All Courses &nbsp;&gt;</a></div><ul fr-original-style="" style="box-sizing: border-box;">
</ul><div fr-original-style="" style="box-sizing: border-box;">

<br fr-original-style="" style="box-sizing: border-box;">
</div><div fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
</div><div fr-original-style="" style="box-sizing: border-box;">
<img src="https://images.cademy.co.uk/4a9a442f-3a06-46ed-8163-31463c8c7aa8/0964cd30-f0f9-4ae2-a93f-2f789aa5fdbd/original.png" id="isPasted" style="width: 439px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 439px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;">
</div><ul fr-original-style="" style="box-sizing: border-box;">
</ul><ul fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">
</span></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><h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Suitability</span></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Designed by expert trainers, Stress Management Training Course is perfect for</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">All Employees</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">Supervisors</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">Team Leaders</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">Managers</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">Anyone seeking to reduce their stress levels.</span></li></ul><div fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
</div><section id="isPasted" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Overview</span></h2>

<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 Day - 9:30am to 4:30pm.</strong></li>
<li fr-original-style="" style="box-sizing: border-box;">Delivered in-person or virtually.</li>
<li fr-original-style="" style="box-sizing: border-box;">Suitable for individuals or groups.</li>
<li fr-original-style="" style="box-sizing: border-box;">Choose a date that best suits your team&#39;s availability.</li>
<li fr-original-style="" style="box-sizing: border-box;">Includes certification.</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>
<section id="isPasted" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Looking to Train Your Team?</span></strong></h2>Good news, we charge a &#39;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">fixed day rate</strong>&#39; price.
<br fr-original-style="" style="box-sizing: border-box;">Whether you add x1 person or x15 people to your session, the cost remains the same.
<br fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;"><a href="mailto:Info@LiveAndLearnConsultancy.co.uk?Subject=Re: Stress Management Training Courses for Staff" style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(1, 176, 119); border-width: 14px 16px 14px 18px; border-style: solid; border-color: rgb(1, 176, 119); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" id="isPasted" fr-original-style="font-size: 16px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #01b077; border-top: 14px solid #01b077; border-bottom: 14px solid #01b077; border-right: 16px solid #01b077; border-left: 18px solid #01b077; display: inline-block;">Request Course Brochure &nbsp;&gt;</a>
<br fr-original-style="" style="box-sizing: border-box;">
</section></section><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>

Live And Learn Consultancy

Stress Management

Health & Wellbeing

Personal Development

Emotional Wellbeing

Wellbeing

Our Stress Management Training Course is designed to provide your employees with highly practical techniques to effectively manage stress in the workplace & in their daily life.

Stress Management Training at Work

Birmingham

Erdington

Queensway

Tableau Training Uk

Visual Analytics Best Practice

Tableau Desktop Training - Analyst

<p>This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database.</p>This workshop will help participants:<ul><li>Ensure the integrity of their databases</li><li>Manage field properties</li><li>Use the query functions effectively</li><li>Save time with the query expression builder</li><li>Create different types of query more quickly</li><li>Design better forms</li><li>Link expressions in forms</li><li>Create better and more useful reports</li><li>Import and export tables more easily</li></ul><section>
                    <h3>1 Table relationship integrity</h3><ul><li>Identifying relationships</li><li>Identifying criteria for data integrity</li><li>Applying referential integrity</li><li>Managing relationship join types</li></ul> <h3>2 Table field properties</h3><ul><li>Field properties overview</li><li>Using input mask field</li><li>Using default value fields</li><li>Using field validation rules</li></ul> <h3>3 Query functions</h3><ul><li>Running aggregate function calculations</li><li>Running sum, average, count, max and min functions</li><li>Grouping calculated data</li></ul> <h3>4 Query calculations</h3><ul><li>Using query operators and expressions</li><li>Adding calculated fields to a query</li><li>Using the query expression builder</li></ul> <h3>5 Action queries</h3><ul><li>Creating make table queries</li><li>Creating append queries</li><li>Creating update queries</li><li>Creating delete queries</li></ul> <h3>6 Designing forms</h3><ul><li>Adding form controls</li><li>Aligning and arranging form controls</li><li>Adding pictures and labels to forms</li><li>Adding new fields to a form</li><li>Controlling tab order</li><li>Adding command buttons</li><li>Adding a combo box control</li><li>Formatting data using conditional formatting</li></ul> <h3>7 Form expressions (calculations)</h3><ul><li>Using the form expression builder</li><li>Working with a property sheet within a form</li><li>Linking expressions within a form</li></ul> <h3>8 Working with reports</h3><ul><li>Creating reports with the report wizard</li><li>Inserting report fields</li><li>Formatting fields</li><li>Inserting report headers and footers</li><li>Working with a property sheet within a report</li></ul> <h3>9 Grouped reports</h3><ul><li>Creating groups with the report wizard</li><li>Sorting grouped data</li><li>Grouping alphabetically</li><li>Grouping on date intervals</li><li>Creating sub reports</li><li>Adding calculations to groups</li></ul> <h3>10 Importing and exporting tables</h3><ul><li>Importing tables into Access</li><li>Exporting tables from Access</li><li>Importing and linking data in Access</li></ul> 


                </section>

Microsoft Forms

Access VBA

Microsoft Access

Access - intermediate (In-House)

<p>This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code.</p><p>This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references.</p>This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables.<section>
                    <h3>1 The query editor</h3><ul><li>Split by row delimiter</li><li>AddDays to determine deadlines</li><li>Advanced query editor</li></ul> <h3>2 Fuzzy matching joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 Logical column functions</h3><ul><li>Logical functions IF, AND, OR</li><li>Using multiple conditions</li><li>Including FIND in functions</li></ul> <h3>4 Editing DAX measures</h3><ul><li>Make DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>5 The anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE context filters</li><li>Adding context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>6 The ALL measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentage</li></ul> <h3>7 DAX iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED in SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>8 Date and time functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>9 Time intelligent measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>10 Visualisations in-depth</h3><ul><li>Utilising report themes</li><li>Create a heatmap</li><li>Comparing proportions</li><li>View trends with sparklines</li><li>Group numbers using bins</li><li>Setting up a histogram</li></ul> <h3>11 Comparing variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> <h3>12 User level security</h3><ul><li>Setting up row level security</li><li>Testing user security</li></ul> 


                </section>

Power BI - advanced (1 day) (In-House)

<p id="isPasted" 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;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" 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 Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</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;">On this course, you will&hellip;</strong></strong></p><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><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;">Who will benefit from this course?</strong></strong></p><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><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;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><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><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;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><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><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;">Included in the Course</strong></strong></p><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><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;">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:</p><p id="isPasted" 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>



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 

General Admission

Virtual

Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Kent.</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://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Health & Safety

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card. 

ECS Card Health & Safety Course Kent

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly.</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://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Dover.</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://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Dover

ECS Card Health & Safety Course Liverpool

ECS Card Health & Safety Course Newcastle

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Visual Basic Analysis

Microsoft Excel

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


Who will benefit from this School?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


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


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


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


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns


Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates


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

Property Investment

Financial Analysis

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</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;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><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;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><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;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><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;">Included in the Course</strong></strong></p><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><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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</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>



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

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

51 Courses in Manchester

Word - intermediate (In-House)

By The In House Training Company

Power BI - introduction (2 day) (In-House)

By The In House Training Company

Outlook - advanced (In-House)

By The In House Training Company

R&D project management (In-House)

By The In House Training Company

FREC 4

By NR Medical Training

Stress Management Training at Work

By Live And Learn Consultancy

Visual Analytics Best Practice

By Tableau Training Uk

Tableau Desktop Training - Analyst

By Tableau Training Uk

Access - intermediate (In-House)

By The In House Training Company

Power BI - advanced (1 day) (In-House)

By The In House Training Company

Search By Location