Name: Emotional Intelligence: In-House Training
Price: 1295 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The information protection administrator translates an organization?s risk and compliance requirements into technical implementation. They are responsible for implementing and managing solutions for content classification, data loss prevention (DLP), information protection, data lifecycle management, records management, privacy, risk, and compliance. They also work with other roles that are responsible for governance, data, and security to evaluate and develop policies to address an organization's risk reduction and compliance goals. This role assists workload administrators, business application owners, human resources departments, and legal stakeholders to implement technology solutions that support the necessary policies and controls.</p><p></p><p></p><p>Learn how to protect information in your Microsoft 365 deployment.  This course focuses on data lifecycle management and information protection and compliance within your organization.  The course covers implementation of data loss prevention policies, sensitive information types, sensitivity labels, data retention policies, Microsoft Purview Message Encryption, audit, eDiscovery, and insider risk among other related topics. The course helps learners prepare for the Microsoft Information Protection Administrator exam (SC-400).</p><p></p>Prerequisites<p></p><p></p><ul> <li>Foundational knowledge of Microsoft security and compliance technologies.</li>   <li>Basic knowledge of information protection concepts.</li>   <li>Understanding of cloud computing concepts.</li>   <li>Understanding of Microsoft 365 products and services.</li></ul><p></p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to information protection and data lifecycle management in Microsoft Purview</h3> <ul> <li>Know your data</li> <li>Protect your data</li> <li>Prevent data loss</li> <li>Govern your data</li> </ul> <h3>2 - Classify data for protection and governance</h3> <ul> <li>Data classification overview</li> <li>Classify data using sensitive information types</li> <li>Classify data using trainable classifiers</li> <li>Review sensitive information and label usage</li> <li>Explore labeled and sensitive content</li> <li>Understand activities related to your data</li> </ul> <h3>3 - Create and manage sensitive information types</h3> <ul> <li>Compare built-in versus custom sensitive information types</li> <li>Create and manage custom sensitive information types</li> <li>Describe custom sensitive information types with exact data match</li> <li>Implement document fingerprinting</li> <li>Create keyword dictionary</li> </ul> <h3>4 - Understand Microsoft 365 encryption</h3> <ul> <li>Learn how Microsoft 365 data is encrypted at rest</li> <li>Understand service encryption in Microsoft Purview</li> <li>Explore customer key management using Customer Key</li> <li>Learn how data is encrypted in-transit</li> </ul> <h3>5 - Deploy Microsoft Purview Message Encryption</h3> <ul> <li>Implement Microsoft Purview Message Encryption</li> <li>Implement Microsoft Purview Advanced Message Encryption</li> <li>Use Microsoft Purview Message Encryption templates in mail flow rules</li> </ul> <h3>6 - Protect information in Microsoft Purview</h3> <ul> <li>Information protection overview</li> <li>Configure sensitivity labels</li> <li>Configure sensitivity label policies</li> <li>Configure auto-labeling policies</li> <li>Manage, monitor, and remediate information protection</li> </ul> <h3>7 - Apply and manage sensitivity labels</h3> <ul> <li>Apply sensitivity labels to Microsoft Teams, Microsoft 365 groups, and SharePoint sites</li> <li>Plan on-premises labeling</li> <li>Configure on-premises labeling for the Unified Labeling Scanner</li> <li>Apply protections and restrictions to email and files</li> <li>Monitor label performance using label analytics</li> </ul> <h3>8 - Prevent data loss in Microsoft Purview</h3> <ul> <li>Data loss prevention overview</li> <li>Identify content to protect</li> <li>Define policy settings for your DLP policy</li> <li>Test and create your DLP policy</li> <li>Prepare Endpoint DLP</li> <li>Manage DLP alerts in the Microsoft Purview compliance portal</li> <li>View data loss prevention reports</li> <li>Implement the Microsoft Purview Extension</li> </ul> <h3>9 - Configure DLP policies for Microsoft Defender for Cloud Apps and Power Platform</h3> <ul> <li>Configure data loss prevention policies for Power Platform</li> <li>Integrate data loss prevention in Microsoft Defender for Cloud Apps</li> <li>Configure policies in Microsoft Defender for Cloud Apps</li> <li>Manage data loss prevention violations in Microsoft Defender for Cloud Apps</li> </ul> <h3>10 - Manage data loss prevention policies and reports in Microsoft 365</h3> <ul> <li>Configure data loss prevention for policy precedence</li> <li>Implement data loss prevention policies in test mode</li> <li>Explain data loss prevention reporting capabilities</li> <li>Manage permissions for data loss prevention reports</li> <li>Manage and respond to data loss prevention policy violations</li> </ul> <h3>11 - Manage the data lifecycle in Microsoft Purview</h3> <ul> <li>Data Lifecycle Management overview</li> <li>Configure retention policies</li> <li>Configure retention labels</li> <li>Configure manual retention label policies</li> <li>Configure auto-apply retention label policies</li> <li>Import data for Data Lifecycle Management</li> <li>Manage, monitor, and remediate Data Lifecycle Management</li> </ul> <h3>12 - Manage data retention in Microsoft 365 workloads</h3> <ul> <li>Explain retention in Exchange Online</li> <li>Explain retention in SharePoint Online and OneDrive</li> <li>Explain retention in Microsoft Yammer</li> <li>Activate archive mailboxes in Microsoft Exchange</li> <li>Apply mailbox holds in Microsoft Exchange</li> <li>Recover content in Microsoft Exchange</li> </ul> <h3>13 - Manage records in Microsoft Purview</h3> <ul> <li>Records management overview</li> <li>Import a file plan</li> <li>Configure retention labels</li> <li>Configure event driven retention</li> <li>Manage, monitor, and remediate records</li> </ul> <h3>14 - Explore compliance in Microsoft 365</h3> <ul> <li>Plan for security and compliance in Microsoft 365</li> <li>Plan your beginning compliance tasks in Microsoft Purview</li> <li>Manage your compliance requirements with Compliance Manager</li> <li>Examine the Compliance Manager dashboard</li> <li>Analyze the Microsoft Compliance score</li> </ul> <h3>15 - Search for content in the Microsoft Purview compliance portal</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>16 - Manage Microsoft Purview eDiscovery (Standard)</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Implement Microsoft Purview eDiscovery (Standard)</li> <li>Create eDiscovery holds</li> <li>Search for content in a case</li> <li>Export content from a case</li> <li>Close, reopen, and delete a case</li> </ul> <h3>17 - Manage Microsoft Purview eDiscovery (Premium)</h3> <ul> <li>Explore Microsoft Purview eDiscovery (Premium)</li> <li>Implement Microsoft Purview eDiscovery (Premium)</li> <li>Create and manage an eDiscovery (Premium) case</li> <li>Manage custodians and non-custodial data sources</li> <li>Analyze case content</li> </ul> <h3>18 - Manage Microsoft Purview Audit (Standard)</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Search the audit log</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>19 - Prepare Microsoft Purview Communication Compliance</h3> <ul> <li>Plan for communication compliance</li> <li>Identify and resolve communication compliance workflow</li> <li>Case study--Configure an offensive language policy</li> <li>Investigate and remediate communication compliance alerts</li> </ul> <h3>20 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>21 - Implement Microsoft Purview Information Barriers</h3> <ul> <li>Explore Microsoft Purview Information Barriers</li> <li>Configure information barriers in Microsoft Purview</li> <li>Examine information barriers in Microsoft Teams</li> <li>Examine information barriers in OneDrive</li> <li>Examine information barriers in SharePoint</li> </ul> <h3>22 - Manage regulatory and privacy requirements with Microsoft Priva</h3> <ul> <li>Create and manage risk management policies</li> <li>Investigate and remediate risk management alerts</li> <li>Create rights requests</li> <li>Manage data estimate and retrieval for rights requests</li> <li>Review data from rights requests</li> <li>Get reports from rights requests</li> </ul> <h3>23 - Implement privileged access management</h3> <ul> <li>Case study--Implementing privileged access management</li> </ul> <h3>24 - Manage Customer Lockbox</h3> <ul> <li>Manage Customer Lockbox requests</li> </ul></div>

Nexus Human

Microsoft Certification

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

SC-400T00 Administering Information Protection and Compliance in Microsoft 365

General Admission

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Microsoft Teams or in passing the Microsoft Teams Administrator Associate certification exam. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. A Microsoft Teams administrator must be able to plan, deploy, and manage teams, chat, apps, channels, meetings, audio/video conferencing, live events, calling, and Teams certified devices. A Microsoft Teams administrator has experience integrating Microsoft Teams with SharePoint, OneDrive, Exchange, Microsoft 365 Groups, and other Microsoft, third-party, and custom apps. A Microsoft Teams administrator understands and collaborates with other workloads and roles, such as Network, Voice, Identity, Access, Devices, Licensing, Security, Compliance, Information management, and User Adoption.</p><p></p>Overview<p>What is Microsoft Teams and how the components work together How to implement Governance, Security and Compliance for Microsoft Teams How to prepare an organizations environment for a Microsoft Teams deployment How to deploy and manage teams How to manage collaboration and communication experiences in Microsoft Teams Techniques to manage and troubleshoot communication in Microsoft Teams</p><p></p><p>The Managing Microsoft Teams course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. In this course, you will learn about various Teams management tools, security and compliance feature for Teams, network requirement for Teams deployment as well as different Teams settings and policies for managing collaboration and communication experience in Teams.</p><p></p>Prerequisites<p></p><li>A proficient understanding of basic functional experience with Microsoft 365 services.</li>  <li>A proficient understanding of general IT practices, including using PowerShell.</li><p></p></div><div id="course-pills-2"><h3>1 - Explore Microsoft Teams</h3> <ul> <li>Explore capabilities in Microsoft Teams</li> <li>Explore Microsoft Teams integration with Microsoft 365</li> <li>Explore Microsoft Teams integration with Microsoft Power Platform</li> <li>Illustrate Microsoft Teams architecture</li> <li>Describe Microsoft Teams with Microsoft 365 Groups</li> <li>Describe Microsoft Teams with SharePoint and OneDrive</li> <li>Describe Microsoft Teams with Exchange</li> <li>Understand Microsoft Teams certified solutions</li> </ul> <h3>2 - Plan and deploy Microsoft Teams</h3> <ul> <li>Designate Teams admin roles</li> <li>Understand Teams management tools</li> <li>Plan for Teams rollout</li> <li>Plan for Teams adoption</li> <li>Plan for Teams licensing</li> <li>Deploy Microsoft Teams clients</li> </ul> <h3>3 - Implement lifecycle management and governance for Microsoft Teams</h3> <ul> <li>Plan for lifecycle management</li> <li>Plan for Teams governance</li> <li>Manage Microsoft 365 Groups creation</li> <li>Configure Microsoft 365 Groups expiration policy</li> <li>Configure Microsoft 365 Groups naming policy</li> <li>Plan policy assignment for users and groups</li> <li>Create and manage policy packages</li> <li>Manage Teams preview features using Teams update policies</li> <li>Create and manage teams templates and template policies</li> </ul> <h3>4 - Monitor your Microsoft Teams environment</h3> <ul> <li>Monitor Microsoft Teams usage reports</li> <li>Monitor Microsoft 365 usage reports</li> <li>Interpret Microsoft Adoption Score</li> <li>Manage user access with Azure Active Directory access reviews</li> <li>Monitor the Microsoft 365 network connectivity dashboard</li> <li>Manage Teams notifications and alerts</li> <li>Manage feedback policies</li> </ul> <h3>5 - Manage access for external users</h3> <ul> <li>Understand features in Azure Active Directory</li> <li>Work with external users in Microsoft Teams</li> <li>Manage access for external users</li> <li>Manage external collaboration in Azure AD</li> <li>Manage external collaboration in Microsoft 365</li> <li>Manage external access in Microsoft Teams</li> <li>Manage guest access in Microsoft Teams</li> <li>Manage file sharing in SharePoint and OneDrive</li> </ul> <h3>6 - Implement security for Microsoft Teams</h3> <ul> <li>Configure conditional access and multifactor authentication for Microsoft Teams</li> <li>Configure Safe Attachments for Microsoft Teams</li> <li>Configure Safe Links for Microsoft Teams</li> <li>Examine the Defender for Cloud Apps</li> <li>Monitor security reports for Microsoft Teams</li> <li>Plan and configure enhanced encryption policies</li> </ul> <h3>7 - Implement compliance for Microsoft Teams</h3> <ul> <li>Create and manage sensitivity labels</li> <li>Create and manage retention policies</li> <li>Create and manage Data Loss Prevention policies</li> <li>Deploy communication compliance</li> <li>Enable scoped directory search</li> <li>Create information barrier policy</li> <li>Create security and compliance alerts for Microsoft Teams</li> </ul> <h3>8 - Plan and configure network settings for Microsoft Teams</h3> <ul> <li>Examine network requirements for Microsoft Teams</li> <li>Plan for network deployment using Network Planner</li> <li>Configure network ports and protocols for Microsoft Teams</li> <li>Implement Quality of Service</li> <li>Configure reporting labels for location-enhanced Call Analytics reports</li> <li>Configure tenant data for Call Quality Dashboard reports</li> <li>Assess network readiness</li> <li>Manage network topology</li> </ul> <h3>9 - Create and manage teams</h3> <ul> <li>Create teams</li> <li>Create a team from existing resources</li> <li>Plan and create org-wide teams</li> <li>Manage teams</li> <li>Manage users in a team</li> <li>Configure dynamic membership</li> <li>Archive restore and delete a team</li> </ul> <h3>10 - Manage collaboration experiences for chat and channels</h3> <ul> <li>Create and manage channels in a team</li> <li>Create and manage Teams policies for channels</li> <li>Configure teams settings</li> <li>Create and manage messaging policies</li> <li>Manage channel moderation</li> <li>Manage access to channels</li> </ul> <h3>11 - Manage apps for Microsoft Teams</h3> <ul> <li>Explore apps in Microsoft Teams</li> <li>Describe admin settings for Teams apps</li> <li>Manage access to Teams apps at the organization level</li> <li>Create and manage app permission policies</li> <li>Create and manage app setup policies</li> <li>Manage permissions and consent for Teams apps</li> <li>Plan and configure connectors</li> <li>Manage custom apps uploads</li> <li>Publish custom apps to Microsoft Teams</li> <li>Manage purchasing of apps in the Microsoft Teams app store</li> <li>Customize the organization's app store</li> <li>Customize the branded experience of an app</li> </ul> <h3>12 - Introduction to Teams meetings and calling</h3> <ul> <li>Overview of Teams meetings and events</li> <li>Overview of Teams Phone</li> <li>Overview of auto attendants and call queues</li> <li>Overview of Teams devices</li> </ul> <h3>13 - Manage meetings and events experiences</h3> <ul> <li>Explore meetings and events in Microsoft Teams</li> <li>Configure meeting settings</li> <li>Create and manage meeting policies</li> <li>Configure audio conferencing</li> <li>Create and manage meeting templates and template policies</li> <li>Create and manage meetings customization policies</li> <li>Configure live events settings</li> <li>Create and manage live events policies</li> <li>Examine live events across Microsoft 365</li> </ul> <h3>14 - Plan for Microsoft Teams Rooms and Surface Hub</h3> <ul> <li>Determine license requirements for Microsoft Teams Rooms and shared devices</li> <li>Understand differences between Microsoft Teams Rooms on Android and Windows</li> <li>Understand Microsoft Teams Rooms on Surface Hub 2S</li> <li>Understand and plan Teams Room accessories, components, and peripherals</li> <li>Understand Teams Rooms management options</li> </ul> <h3>15 - Configure, deploy, and manage Teams devices</h3> <ul> <li>Manage Microsoft Teams Phones</li> <li>Manage Microsoft Teams Room Systems</li> <li>Microsoft Teams Rooms management options</li> <li>Manage Surface Hub 2S devices</li> <li>Configure Microsoft Teams SIP gateway</li> <li>Manage Microsoft Teams displays</li> <li>Remote provisioning and sign in for Teams Phones</li> <li>Update Microsoft Teams devices remotely</li> <li>Manage Microsoft Teams device tags</li> </ul> <h3>16 - Plan for Teams Phone</h3> <ul> <li>Plan to deploy Teams Phone</li> <li>Plan for Teams Phone PSTN connectivity</li> <li>Determine license requirements</li> <li>Plan for Teams Phone devices</li> <li>Plan and design Teams Phone features</li> <li>Plan for voicemail</li> </ul> <h3>17 - Configure and deploy Teams Phone</h3> <ul> <li>Configure emergency calling for Teams Calling Plans</li> <li>Manage and configure Microsoft PSTN numbers</li> <li>Configure Operator Connect and Teams Phone Mobile</li> <li>Configure Teams Phone policies</li> <li>Create and manage Teams policies</li> <li>Configure Audio Conferencing</li> </ul> <h3>18 - Configure and manage voice users</h3> <ul> <li>Enable users for Teams Phone</li> <li>Enable users for Direct Routing with Teams Phone</li> <li>Enable additional calling features for Teams Phone</li> <li>Enable users for Teams Phone Mobile</li> </ul> <h3>19 - Configure auto attendants and call queues</h3> <ul> <li>Design call flows for auto attendants and call queues</li> <li>Configure auto attendants and call queues</li> <li>Deploy a channel-based call queue</li> <li>Configure resource accounts</li> <li>Configure Microsoft 365 groups for voicemail</li> <li>Interpret call queue conference modes</li> <li>Interpret call queue routing methods</li> <li>Configure holidays for auto attendants and call queues</li> <li>Configure custom music on hold</li> </ul> <h3>20 - Troubleshoot audio, video, and client issues</h3> <ul> <li>Troubleshoot Teams</li> <li>Collect and identify logs</li> <li>Clear Microsoft Teams client cache</li> <li>Identify issues with call analytics</li> <li>Identify issues with Call Quality Dashboard</li> <li>Use Power BI to analyze Call Quality Dashboard data</li> <li>Identify issues with the Direct Routing Health Dashboard</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MS-700T00 Managing Microsoft Teams training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the MS-700T00 Managing Microsoft Teams course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft MS-700

Microsoft Teams

MS-700T00 Managing Microsoft Teams

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.</p>

<p>Objectives</p>

<ul>
	<li>
	<p>Harness Excel's tools within a best practice framework</p>
	</li>
	<li>
	<p>Add flexibility to their models through the use of switches and flexible lookups</p>
	</li>
	<li>
	<p>Work efficiently with large data volumes</p>
	</li>
	<li>
	<p>Model debt effectively</p>
	</li>
	<li>
	<p>Approach modelling for tax, debt, pensions and disposals with confidence</p>
	</li>
	<li>
	<p>Build flexible charts and sensitivity analysis to aid the presentation of results</p>
	</li>
	<li>
	<p>Learn and apply Excel tools useful in financial forecasting</p>
	</li>
	<li>
	<p>Understand and design the layout of a flexible model</p>
	</li>
	<li>
	<p>Forecast financial statements of a public or private company</p>
	</li>
	<li>
	<p>Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation</p>
	</li>
</ul>
<p>
							
							</p><div>
						
					</div>

GBA Corporate

Financial Modelling for Budgeting and Forecasting in Excel

Online

On Site

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is looking to familiarize themselves with the fundamentals of security, compliance, and identity (SCI) across cloud-based and related Microsoft services. The content for this course aligns to the SC-900 exam objective domain. Candidates should be familiar with Microsoft Azure and Microsoft 365 and understand how Microsoft security, compliance, and identity solutions can span across these solution areas to provide a holistic and end-to-end solution.</p> <p>Before attending this course, students must have:</p> <ul> <li><p>General understanding of networking and cloud computing concepts.</p> </li> <li><p>General IT knowledge or any general experience working in an IT environment.</p> </li> <li><p>General understanding of Microsoft Azure and Microsoft 365.</p> </li> </ul><p></p><p></p><p>This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.</p><p></p>Prerequisites<p></p><p></p><ul> <li>General understanding of networking and cloud computing concepts.</li> <li>General IT knowledge or any general experience working in an IT environment.</li> <li>General understanding of Microsoft Azure and Microsoft 365.</li></ul><p></p><p></p></div><div id="course-pills-2"><h3>1 - Describe security and compliance concepts</h3> <ul> <li>Describe the shared responsibility model</li> <li>Describe defense in depth</li> <li>Describe the Zero Trust model</li> <li>Describe governance, risk, and compliance (GRC) concepts</li> </ul> <h3>2 - Describe identity concepts</h3> <ul> <li>Define authentication and authorization</li> <li>Define identity as the primary security perimeter</li> <li>Describe the role of the identity provider</li> <li>Describe the concept of directory services and Active Directory</li> <li>Describe the concept of federation</li> </ul> <h3>3 - Describe the function and identity types of Microsoft Entra ID</h3> <ul> <li>Describe Microsoft Entra ID</li> <li>Describe types of identities</li> <li>Describe hybrid identity</li> <li>Describe external identities</li> </ul> <h3>4 - Describe the authentication capabilities of Microsoft Entra ID</h3> <ul> <li>Describe authentication methods</li> <li>Describe multifactor authentication</li> <li>Describe self-service password reset</li> <li>Describe password protection and management capabilities</li> </ul> <h3>5 - Describe access management capabilities of Microsoft Entra ID</h3> <ul> <li>Describe Conditional Access</li> <li>Describe Microsoft Entra roles and role-based access control (RBAC)</li> </ul> <h3>6 - Describe the identity protection and governance capabilities of Azure AD</h3> <ul> <li>Describe Microsoft Entra ID Governance</li> <li>Describe access reviews</li> <li>Describe entitlement management</li> <li>Describe the capabilities of Privileged identity Management</li> <li>Describe Microsoft Entra ID Protection</li> <li>Describe Microsoft Entra Permissions Management</li> <li>Describe Microsoft Entra Verified ID</li> </ul> <h3>7 - Describe core infrastructure security services in Azure</h3> <ul> <li>Describe Azure DDoS protection</li> <li>Describe Azure Firewall</li> <li>Describe Web Application Firewall</li> <li>Describe network segmentation in Azure</li> <li>Describe Azure Network Security Groups</li> <li>Describe Azure Bastion</li> <li>Describe Azure Key Vault</li> </ul> <h3>8 - Describe the security management capabilities in Azure</h3> <ul> <li>Describe Microsoft Defender for Cloud</li> <li>Describe how security policies and initiatives improve cloud security posture</li> <li>Describe Cloud security posture management</li> <li>Describe the enhanced security of Microsoft Defender for Cloud</li> <li>Describe DevOps security management</li> </ul> <h3>9 - Describe security capabilities of Microsoft Sentinel</h3> <ul> <li>Describe threat detection and mitigation capabilities in Microsoft Sentinel</li> <li>Describe Microsoft Security Copilot</li> </ul> <h3>10 - Describe threat protection with Microsoft Defender XDR</h3> <ul> <li>Describe Microsoft Defender XDR services</li> <li>Describe Microsoft Defender for Office 365</li> <li>Describe Microsoft Defender for Endpoint</li> <li>Describe Microsoft Defender for Cloud Apps</li> <li>Describe Microsoft Defender for Identity</li> <li>Describe Microsoft Defender Vulnerability Management</li> <li>Describe Microsoft Defender Threat Intelligence</li> <li>Describe the Microsoft Defender portal</li> </ul> <h3>11 - Describe Microsoft?s Service Trust portal and privacy capabilities</h3> <ul> <li>Describe the offerings of the Service Trust portal</li> <li>Describe Microsoft's privacy principles</li> <li>Describe Microsoft Priva</li> </ul> <h3>12 - Describe the compliance management capabilities in Microsoft Purview</h3> <ul> <li>Describe the Microsoft Purview compliance portal</li> <li>Describe Compliance Manager</li> <li>Describe use and benefits of compliance score</li> </ul> <h3>13 - Describe information protection, data lifecycle management, and data governance capabilities in Microsoft Purview</h3> <ul> <li>Know your data, protect your data, and govern your data</li> <li>Describe the data classification capabilities of the compliance portal</li> <li>Describe sensitivity labels and policies</li> <li>Describe data loss prevention</li> <li>Describe retention policies and retention labels</li> <li>Describe records management</li> <li>Describe the Microsoft Purview unified data governance solution</li> </ul> <h3>14 - Describe the insider risk capabilities in Microsoft Purview</h3> <ul> <li>Describe insider risk management</li> <li>Describe communication compliance</li> </ul> <h3>15 - Describe the eDiscovery and Audit capabilities in Microsoft Purview</h3> <ul> <li>Describe the eDiscovery solutions in Microsoft Purview</li> <li>Describe the audit solutions in Microsoft Purview</li> </ul></div>

CompTIA Security+

SC-900T00 Microsoft Security Compliance and Identity Fundamentals

Redhill

<h3><b>Fibre Optic cabling training course description</b></h3>
        <p>A hands on course covering installation, splicing and
          testing of fibre optic cabling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe different types of fibre cable and where to use them</li>
        <li>Install fibre optic cable.</li>
        <li>Splice fibre optic cable.</li>
        <li>Test fibre optic cable.</li>
        </ul>
        <h5>
        <b>Fibre Optic cabling training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Cable installation professionals.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Fibre Optic cabling training course contents</b></h3>
      <ul>
        <li>Fibre optic transmission</li>
        <p> Physics of light, optical modes, light propagation,
          light guiding, dispersion, light spectrum, fibre
          versus copper comparison, fibre cable types and
          their uses, WDM and DWDM. </p>
        <li>Fibre optic cable</li>
        <p>Single mode, Multi mode, diameters, step-index
fibre, graded index fibre, loose tube, tight buffered,
cable jackets, distance limitations, indoor versus
outdoors.</p>
        <li>Fibre optic network components</li>
        <p>ST, SC, FC and other connectors, termination
methods, joint enclosures, transmitters, light
sources, laser, LED, receivers, detectors.</p>
        <li>Installation</li>
        <p>BS.7718. Safe working practices, site surveys,
recommended installation procedures, cable
handling issues, bending radius, techniques and
tools, documentation.</p>
        <li>Splicing</li>
        <p>Joining fibres, splicers, fusion splicing, mechanical
splicing, splicing procedure, cleaving, splicing
parameters, splicing vs. connectors.</p>
        <li>Measurement parameters and applications</li>
        <p>Power measurement, loss measurement, return
loss measurement, receiver sensitivity
measurement, budget calculations.
 </p>
        <li>Testing
</li>
        <p>Optical power meter, optical light source, optical
attenuator, return loss meter, continuity testing,
insertion loss testing, OTDR features and
principles, OTDR capabilities and limitations, 
using an OTDR, troubleshooting.</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Fibre optic cabling for engineers

London

<h2>Better Business Cases™ Foundation and Practitioner: In-House Training</h2>
<p>Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
<p>The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project.</p>
<p>The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5.</p><h3>What you will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Develop the lifecycle of a business case and establish the relationships between the five cases</li>
<li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario.</li>
</ul><section>
                    <h3>Overview of Better Business Cases</h3><ul><li>Alignment with the strategic planning process</li><li>Importance of the Business Case using the Five Case Model</li><li>Overview of the Five Case Model</li><li>Purpose of the key stages in the development of a spending proposal</li><li>Purpose of a Business Justification Case</li><li>Business Case Development Process</li><li>Purpose of project / programme assurance and assurance reviews</li><li>Responsibility for producing the Business Case</li></ul><h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3><ul><li>Scoping the Scheme and Preparing the Strategic Outline Case</li><li>Planning the Scheme and Preparing the Outline Business Case</li><li>Procuring the Solution and Preparing the Full Business Case</li><li>Implementation and monitoring</li><li>Evaluation and feedback</li></ul><h3>Making the Case for Change</h3><ul><li>Agree on the strategic context</li><li>Determine spending objectives, existing arrangements, and business needs</li><li>Determine potential business scope and key service requirements</li><li>Determine benefits, risks, constraints, and dependencies</li></ul><h3>Exploring the Preferred Way Forward</h3><ul><li>Agree on critical success factors</li><li>Determine long list options and SWOT analysis</li><li>Recommend a preferred way forward</li></ul><h3>Determining Potential Value for Money</h3><ul><li>Revisit the short list</li><li>Prepare the economic appraisal for short-listed options</li><li>Undertake benefits appraisal</li><li>Undertake risk appraisal</li><li>Select preferred option and undertake sensitivity analysis</li></ul><h3>Preparing for the Potential Deal</h3><ul><li>Determine the procurement strategy</li><li>Determine service streams and required outputs</li><li>Outline potential risk apportionment</li><li>Outline potential payment mechanisms</li><li>Ascertain contractual issues and accountancy treatment</li></ul><h3>Ascertaining Affordability and Funding Requirement</h3><ul><li>Prepare the financial model</li><li>Prepare the financial appraisals</li></ul><h3>Planning for Successful Delivery</h3><ul><li>Plan programme / project management</li><li>Plan change and contract management</li><li>Plan benefits realization</li><li>Plan risk management</li><li>Plan programme / project assurance and post-project evaluation</li></ul><h3>Procuring the Value for Money Solution</h3><ul><li>Revisit the case for change</li><li>Revisit the OBC options</li><li>Detail procurement process and evaluation of best and final offers (BAFOs)</li></ul><h3>Contracting for the Deal</h3><ul><li>Set out the negotiated deal and contractual arrangements</li><li>Set out the financial implications of the deal</li></ul><h3>Ensuring Successful Delivery</h3><ul><li>Finalize project management arrangements and plans</li><li>Finalize change management arrangements and plans</li><li>Finalize benefits realization arrangements and plans</li><li>Finalize risk management arrangements and plans</li><li>Finalize contract management arrangements and plans</li><li>Finalize post-project evaluation arrangements and plans</li></ul>


                </section>

IIL Europe Ltd

Better Business Cases Foundation & Practitioner: In-House

<h2>Better Business Cases™ Foundation and Practitioner: Virtual In-House Training</h2>
<p>Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
<p>The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project.</p>
<p>The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5.</p><h3>What you will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Develop the lifecycle of a business case and establish the relationships between the five cases</li>
<li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario.</li>
</ul><section>
                    <h3>Overview of Better Business Cases</h3><ul><li>Alignment with the strategic planning process</li><li>Importance of the Business Case using the Five Case Model</li><li>Overview of the Five Case Model</li><li>Purpose of the key stages in the development of a spending proposal</li><li>Purpose of a Business Justification Case</li><li>Business Case Development Process</li><li>Purpose of project / programme assurance and assurance reviews</li><li>Responsibility for producing the Business Case</li></ul><h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3><ul><li>Scoping the Scheme and Preparing the Strategic Outline Case</li><li>Planning the Scheme and Preparing the Outline Business Case</li><li>Procuring the Solution and Preparing the Full Business Case</li><li>Implementation and monitoring</li><li>Evaluation and feedback</li></ul><h3>Making the Case for Change</h3><ul><li>Agree on the strategic context</li><li>Determine spending objectives, existing arrangements, and business needs</li><li>Determine potential business scope and key service requirements</li><li>Determine benefits, risks, constraints, and dependencies</li></ul><h3>Exploring the Preferred Way Forward</h3><ul><li>Agree on critical success factors</li><li>Determine long list options and SWOT analysis</li><li>Recommend a preferred way forward</li></ul><h3>Determining Potential Value for Money</h3><ul><li>Revisit the short list</li><li>Prepare the economic appraisal for short-listed options</li><li>Undertake benefits appraisal</li><li>Undertake risk appraisal</li><li>Select preferred option and undertake sensitivity analysis</li></ul><h3>Preparing for the Potential Deal</h3><ul><li>Determine the procurement strategy</li><li>Determine service streams and required outputs</li><li>Outline potential risk apportionment</li><li>Outline potential payment mechanisms</li><li>Ascertain contractual issues and accountancy treatment</li></ul><h3>Ascertaining Affordability and Funding Requirement</h3><ul><li>Prepare the financial model</li><li>Prepare the financial appraisals</li></ul><h3>Planning for Successful Delivery</h3><ul><li>Plan programme / project management</li><li>Plan change and contract management</li><li>Plan benefits realization</li><li>Plan risk management</li><li>Plan programme / project assurance and post-project evaluation</li></ul><h3>Procuring the Value for Money Solution</h3><ul><li>Revisit the case for change</li><li>Revisit the OBC options</li><li>Detail procurement process and evaluation of best and final offers (BAFOs)</li></ul><h3>Contracting for the Deal</h3><ul><li>Set out the negotiated deal and contractual arrangements</li><li>Set out the financial implications of the deal</li></ul><h3>Ensuring Successful Delivery</h3><ul><li>Finalize project management arrangements and plans</li><li>Finalize change management arrangements and plans</li><li>Finalize benefits realization arrangements and plans</li><li>Finalize risk management arrangements and plans</li><li>Finalize contract management arrangements and plans</li><li>Finalize post-project evaluation arrangements and plans</li></ul>


                </section>

Better Business Cases Foundation & Practitioner: Virtual In-House Training

Loughborough

<div>
		

		<div>
			
			<p>In this workshop, you will gain a better understanding of the benefits and challenges of working with neurodiverse people. Make your Organisation a more inclusive place for neurodiverse individuals.</p>
			<div><i></i> 4 Hours: Live Online</div>
			<div><i></i>  £534.00 incl. VAT</div>
			
			
		</div>
	</div>

	

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

	

    <div>

		
		 
		

		<div></div>

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

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

	
		<h3>Description</h3>
		<p></p><h3>In this 4-hour interactive virtual workshop, you will:</h3>
<ul>
<li>Appreciate the different strengths of talented neurodiverse candidates</li>
<li>Reduce interpersonal friction</li>
<li>Ensure equality in employment opportunities</li>
<li>Comply Equalities Act 2010</li>
</ul>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £1,745 Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Different not deficient</h3>
<ul>
<li>Shifting perceptions</li>
<li>New business models need new thinking</li>
</ul>
<h3>Strengths</h3>
<ul>
<li>The gifts of neurodiversity</li>
<li>Successful neurodivergent hall of fame</li>
</ul>
<h3>Signs (diagnostic criteria and labels)</h3>
<ul>
<li>Biology</li>
<li>Brain differences (cognition)</li>
<li>Behaviours</li>
</ul>
<h3>Struggles</h3>
<ul>
<li>Sensory sensitivity</li>
<li>Social interactions</li>
<li>Anxiety and stress response</li>
</ul>
<h3>Inclusive Workplace Cultures</h3>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>Open to everyone</p>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Neurodiversity

Autism Spectrum Counselling & Training (ASPECT)

Equality & Diversity

Mental Health At Work

Disability Awareness

Diversity & Inclusion

In this workshop, you will gain a better understanding of the benefits and challenges of working with neurodiverse people. Make your Organisation a more inclusive place for neurodiverse individuals.

Neurodiversity Workshop Awareness: Signs, Strengths, Struggles

<h3><b>MySQL foundation training course description</b></h3>
        <p> The MySQL foundation course covers the basics of the
SQL language as implemented by MySQL. The course
is designed to give delegates practical experience in
writing SQL statements using the MySQL client
program and MySQL Workbench. The basic SQL
statements, including the use of SQL functions and the
basic table and view handling statements are
introduced.    </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Create, alter and drop a MySQL database.</li>
						<li>Write SQL statements.</li>
						<li>Use SQL expressions and functions.</li>
                        <li>Create and alter tables, indexes and views.</li>
                        <li>Use transactions.</li>
                        <li>Grant and revoke access privileges.</li>
                        <li>Export and import data.</li>
                  </ul>
        <h5>
        <b>MySQL foundation training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to access and work with a MySQL Database.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>An understanding of databases and exposure to
information technology in general would be useful.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL foundation training course contents</b></h3>
      <ul>
        <li>Database concepts </li><p>
What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases.
<br /><span>Hands on</span> using a database.

</p><li>Using the MySQL client </li><p>
What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts.
<br /><span>Hands on</span> Using the MySQL client.

</p><li>Basic SELECT </li><p>
The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators.
<br /><span>Hands on</span> querying the sample database.

</p><li>LIMIT, UNION and AGGREGATE functions </li><p>
The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.
<br /><span>Hands on</span> using limit, union and aggregate functions.

</p><li>Subqueries and joins </li><p>
Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. <br /><span>Hands on</span> using subqueries and joins.

</p><li>Numeric and character functions </li><p>
Function types, testing functions, numeric functions character functions.
<br /><span>Hands on</span> using numeric and character functions.

</p><li>Data, time and other functions </li><p>
Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions.
<br /><span>Hands on</span> using date, time and other functions.

</p><li>Databases and tables </li><p>
Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables.
<br /><span>Hands on</span> maintaining databases and tables.

</p><li>Indexes and views </li><p>
What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.
<br /><span>Hands on</span> maintaining indexes and views.

</p><li>Managing data </li><p>
Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.
<br /><span>Hands on</span> managing data.

</p><li>Access control </li><p>
Creating users, renaming users, dropping users, granting privileges, revoking privileges. <br /><span>Hands on</span> creating users, granting and revoking.

</p><li>Import and export </li><p>
Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.
<br /><span>Hands on</span> export and import data.
</p>
      </ul>

MySQL foundation

<h2>Emotional Intelligence: In-House Training</h2>
 <p>Emotional Intelligence is a set of emotional and social skills that collectively establish how well we:</p>
 <ul>
 <li>Perceive and express ourselves</li>
 <li>Develop and maintain social relationships</li>
 <li>Cope with challenges</li>
 <li>Use emotional information in an effective and meaningful way</li>
 </ul>
 <p>It is a skill set that transfers across all categories of relationships. It is also a predictor of success - both in life and at work. This highly-interactive course delivers a practical approach to developing, improving, and sustaining effective and mutually beneficial relationships. The design of the course involves individual reflection and paired activities, interwoven with small and large group interactions.</p>
 <p>The EQ-i 2.0® assessment reports will be debriefed over the course of the two days. In addition, participants will delve into their personal strengths and blind spots, and will explore topics including: the neuroscience of emotion, the connection between empathy and performance, and how communication styles impact our perceptions of self and other. Role-play activities give participants the opportunity to try out new behaviors and techniques.</p>
 <p>The program includes:</p>
 <ul>
 <li>A personal behavioral profile, the results of which you will bring to your training</li>
 <li>2-day highly interactive workshop and experiential learning</li>
 <li>Optional professional coaching activities initiated in class that can continue over the four months after class ends</li>
 </ul><h3>What you will Learn</h3> <ul> <li>Recognize your interpersonal strengths and potential blind spots regarding Emotional Intelligence</li> <li>Identify the five domains within the EQ-i 2.0 assessment model</li> <li>Summarize what neuroscience research has discovered about emotions and actions</li> <li>Recognize ways that human beings are physiologically impacted by stress</li> <li>Articulate ways to develop and maintain strong working relationships</li> <li>Describe how emotional intelligence translates into high performance</li> <li>Make use of the EI model and associated competencies</li> <li>Employ strategies for enhancing leadership through Emotional Intelligence</li> </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The biology of emotion</li> <li>Why Emotional Intelligence matters</li> <li>The impact of EI on performance</li> </ul> <h3>The EQ-I 2.0 Model</h3> <ul> <li>Overview of the EQ-i 2.0 framework</li> <li>Exploring your report</li> <li>Balancing your EI domains</li> </ul> <h3>Self: Awareness and Sensitivity</h3> <ul> <li>Self-awareness and empathy</li> <li>Perception vs. reality</li> <li>Acting by choice, not impulse</li> </ul> <h3>Other: Communication and Relationship-Building</h3> <ul> <li>Elements of effective communication</li> <li>Communication styles</li> <li>Communication techniques</li> </ul> <h3>Neuroscience and Behavioral Change</h3> <ul> <li>Insights from social neuroscience</li> <li>Making a change</li> </ul>


                </section>

Emotional Intelligence: In-House Training



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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Property Investment

Financial Analysis

Microsoft Excel

Professional Development

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)

<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

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<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)

<p id="isPasted" 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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.</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;">On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).</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 will provide you with a solid foundation for understanding and analysing real estate cash flows.</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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="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;">On this course you will...</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul><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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="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;">Who will benefit from this course?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul><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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="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;">Course Outline</strong>:</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></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;">Real Estate Financial Mathematics</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul><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;">Price, Value and Worth</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul><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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Afternoon</strong></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;">Discounted Cash Flow Models</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul><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;">Model Interpretation and Analysis</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul><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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="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;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><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;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Understanding Key Principles of Real Estate Financial Modelling 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>



Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).
This course will provide you with a solid foundation for understanding and analysing real estate cash flows.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted 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)


Quizzes | Q&A


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


For more information about the Understanding Key Principles of Real Estate Financial Modelling 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

Risk Management

Investment

Financial Risk Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">AS YOU DELIVER THIS INFORMATION, YOU ARE COACHED TO IMPROVE YOUR PUBLIC-SPEAKING STYLE IN THESE (AND A FEW OTHER) AREAS: BODY LANGUAGE, POSTURE, WORD CHOICE, CONFIDENCE, EYE CONTACT, VERBAL TICS/FILLER WORDS, AND VOLUME.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will be coached to overhaul your content and visual aids (frequently PowerPoint)</strong>&nbsp;used during the presentation by: stating your purpose clearly, reducing the amount of text on slides, making messages more user-friendly, and choosing best graphics to support message.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attendees Will Be Able To:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Increase ability to motivate the audience by delivering organized and engaging presentations;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gain more efficiency by crafting carefully-worded, streamlined messages, free of verbal tics and filler words;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Increase enthusiasm through focus on body language and stage presence; and</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Convince listeners with strong evidence presented in speech and visual aids.</strong></li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Format&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Presentation Skills</strong>&nbsp;is a 4-hour interactive virtual class for up to six people.</i></p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">The&nbsp;<em fr-original-style="" style="box-sizing: border-box;">Diversity Sensitivity &amp; Awareness</em>&nbsp;workshop was excellent. It provided a unique approach to addressing the topic. The session was interactive, interesting and very informative, leaving participants with a greater understanding of the merits of diversity and an inspiration to continue to broaden that knowledge base.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Sandra Hess Moll, Director of Employment Services / Affirmative Action Coordinator</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">McHenry County College</span>

AS YOU DELIVER THIS INFORMATION, YOU ARE COACHED TO IMPROVE YOUR PUBLIC-SPEAKING STYLE IN THESE (AND A FEW OTHER) AREAS: BODY LANGUAGE, POSTURE, WORD CHOICE, CONFIDENCE, EYE CONTACT, VERBAL TICS/FILLER WORDS, AND VOLUME.
You will be coached to overhaul your content and visual aids (frequently PowerPoint) used during the presentation by: stating your purpose clearly, reducing the amount of text on slides, making messages more user-friendly, and choosing best graphics to support message.
Attendees Will Be Able To:
Increase ability to motivate the audience by delivering organized and engaging presentations;
Gain more efficiency by crafting carefully-worded, streamlined messages, free of verbal tics and filler words;
Increase enthusiasm through focus on body language and stage presence; and
Convince listeners with strong evidence presented in speech and visual aids.
Online Format—Advanced Presentation Skills is a 4-hour interactive virtual class for up to six people.
Register for this class and you will be sent ONLINE login instructions prior to the class date.



The Diversity Sensitivity & Awareness workshop was excellent. It provided a unique approach to addressing the topic. The session was interactive, interesting and very informative, leaving participants with a greater understanding of the merits of diversity and an inspiration to continue to broaden that knowledge base.
Sandra Hess Moll, Director of Employment Services / Affirmative Action CoordinatorMcHenry County College

Improving Communications Uk

ADVANCED PRESENTATION SKILLS



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><b fr-original-style="" style="box-sizing: border-box;">Uncover and discard beliefs and attitudes that foster or block progress</b>. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART I &ndash; BROADENING THE VIEW</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART II &ndash; FAIR STANDARDS</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART III &ndash; ORGANIZATIONAL UNITY</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATTENDEES&nbsp;WILL BE ABLE TO:</strong></h3>&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover new ways to &ldquo;see things differently;&rdquo;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Define Diversity and uncover ways in which it is significantly useful in an organization;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Manage conflict through unity, using the organization&rsquo;s mission, vision, values, and goals; and</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Understand and communicate value to staff.</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Class&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Diversity &ndash; Building a Thriving Business Environment</strong>&nbsp;is a 4-hour interactive virtual class.&nbsp;</i></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Improving Communications brought our organization to realize how important our employees&mdash;our people&mdash;are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Dr. Kevin Coughlin, DMD, FAGD, MBA</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Baystate Dental</span>

LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.
You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.
Uncover and discard beliefs and attitudes that foster or block progress. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.
PART I – BROADENING THE VIEW
Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.
PART II – FAIR STANDARDS
Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.
PART III – ORGANIZATIONAL UNITY
Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.
ATTENDEES WILL BE ABLE TO:
Discover new ways to “see things differently;”
Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;
Define Diversity and uncover ways in which it is significantly useful in an organization;
Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);
Manage conflict through unity, using the organization’s mission, vision, values, and goals; and
Understand and communicate value to staff.
Online Class—Diversity – Building a Thriving Business Environment is a 4-hour interactive virtual class. 
 
Register for this class and you will be sent ONLINE login instructions prior to the class date.



Improving Communications brought our organization to realize how important our employees—our people—are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.
Dr. Kevin Coughlin, DMD, FAGD, MBABaystate Dental

DIVERSITY – BUILDING A THRIVING BUSINESS ENVIRONMENT

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">Attention: This course is delivered over 2 half-days (3pm to 6:30pm London time, consecutive half-days excluding weekend). If you&#39;re interested in the same course but delivered over 1 full day, please click&nbsp;</span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><a href="https://www.ask-sonia.com/training/other-brcgs-courses/gluten-free-auditor" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">here</u></a></span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">. Thank you.</span></p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);">This training course has been designed for auditors to help gain an appreciation of celiac disease and non-celiac gluten sensitivity, understand the Gluten-Free Certification Program Global Standard requirements and to provide guidance on auditing a Gluten-Free Management System. Training for Issue 4 is now available and is a mandatory requirement for all Gluten-Free Certification Program certified auditors.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Auditors should have a minimum of 5 years&rsquo; experience in auditing food safety/ quality systems. This may include internal, 2nd party and 3rd party auditing. Must have valid lead auditor training certificate for any FSMS standard.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Assessment: 50 question exam (pass mark 75%)</p><h4 style="color: rgb(234, 118, 0); box-sizing: border-box;" fr-original-style=" color: rgb(234, 118, 0);">At the end of this course, you will be able to:</h4><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify key objective evidence required to determine compliance with the Gluten-Free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Correctly complete auditor documentation.</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Be able to effectively communicate a clear &ldquo;snap-shot&rdquo; regarding the operation and the levels of conformity.</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Recall GMPs relating to gluten management</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">List the individual components that make up the Gluten-free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify different gluten controls that must be implemented as part of a gluten-free management system</li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(243, 121, 52);">Note: This course is proposed as either 1 full day, or 2x half-days. Please carefully review the date &amp; time options before confirming your booking.</span></div>

Ask Sonia Limited

Food Safety

Auditor

Official BRCGS Gluten-Free Issue 4 for Auditors course.
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Gluten-Free Issue 4 for Auditors (2 Half-Day Sessions)

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">Attention: This course is delivered over 2 half-days (3pm to 6:30pm London time, consecutive half-days excluding weekend). If you&#39;re interested in the same course but delivered over 1 full day, please click&nbsp;</span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><a href="https://www.ask-sonia.com/training/other-brcgs-courses/gluten-free-sites" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">here</u></a></span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">. Thank you.</span></p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);">This training course has been designed for new or existing Gluten-Free Certification Program customers to help gain an appreciation of celiac disease and non-celiac gluten sensitivity, understand the Gluten-Free Certification Program Global Standard requirements and to provide guidance on implementing a preventative, risk-based Gluten-Free Management System.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">This training will also explain the process that a business will need to follow in order to become a certified Gluten-Free site.</p><h4 style="color: rgb(234, 118, 0); box-sizing: border-box;" fr-original-style=" color: rgb(234, 118, 0);">Key learning objectives:</h4><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify the impact that celiac disease has on individuals and demonstrate an understanding of why the food industry is required to manage gluten</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Explain the concept of cross contact and the potential for cross contact in a food production process</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Outline key legal requirements relating to gluten-free labelling</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify different gluten controls that must be implemented as part of a gluten-free management system</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Outline the importance of prerequisite programs in safeguarding a gluten-free site</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Describe the process for obtaining certification to the Gluten-free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Understand the protocol for audits to the Standard</li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(243, 121, 52);">Note: This course is proposed as either 1x full day, or 2x half-days. Please carefully review the date &amp; time options before confirming your booking.</span></div>

Official BRCGS Gluten-Free Issue 4 for Sites course.
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

249 Courses delivered Online

SC-400T00 Administering Information Protection and Compliance in Microsoft 365

By Nexus Human

MS-700T00 Managing Microsoft Teams

By Nexus Human

Financial Modelling for Budgeting and Forecasting in Excel

By GBA Corporate

SC-900T00 Microsoft Security Compliance and Identity Fundamentals

By Nexus Human

Fibre optic cabling for engineers

By Systems & Network Training

Better Business Cases Foundation & Practitioner: In-House

By IIL Europe Ltd

Better Business Cases Foundation & Practitioner: Virtual In-House Training

By IIL Europe Ltd

Neurodiversity Workshop Awareness: Signs, Strengths, Struggles

By Mpi Learning - Professional Learning And Development Provider

MySQL foundation

By Systems & Network Training

Emotional Intelligence: In-House Training

By IIL Europe Ltd