Name: SAFe for Government: Virtual In-House Training
Price: 1650 GBP
Availability: InStock

Redhill

<h3><b>LTE optimization training course description</b></h3>
      <p>  This course gives delegates an understanding of the
Key Performance Indicators used within the 3G LTE
(4G) network environment. We investigate the 3GPP
standards for KPIs (including TR 32.814, TS 32.410 &amp;
TS 32.455) these cover GERAN, UMTS &amp; LTE
environments. The course details the optimisation
procedures and the use of Self optimisation, Selforganising
&amp; Self-healing equipment now being
deployed across all releases of mobile networks.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			
                 <li>Explain the RF optimisation flowchart.</li>
																				<li>Describe the importance of Reference Signal
Received Power (RSRP).</li>
                    <li>List many of the 3GPP recommended KPIs.</li>
                    <li>Describe the concept of APN AMBR and UE AMBR
within LTE.</li> 
                    
                    <li>Describe the use of planning and optimisation
computer tools.</li>
                  </ul>
        <h5>
        <b>LTE optimization training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with LTE.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Essential LTE
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LTE optimization training course contents</b></h3>
      <ul>
				<li>Introduction to the cellular environment </li><p>
The architecture, 2G (GSM), GPRS/EDGE, The NGMN (Next Generation Mobile Network), media gateway controller, 3GPP Rel99 the 3G introduction, HSPA deployments, 3G LTE (4G).

</p><li>Cellular network procedures </li><p>
GSM/GPRS call setup, GPRS data call setup, 3G UMTS data call setup, Data call (Voice over LTE) in LTE (using IMS), Circuit Switched Fall Back (CSFB) in LTE, IP packet session in LTE.

</p><li>Introduction to the standards </li><p>
The 3GPP specifications body, The numbering structure for KPIs, 2G KPIs, 3G/UMTS KPIs, 3G LTE KPIs, IMS KPIs.

</p><li>Introduction to the KPI definitions </li><p>
KPI definitions, accessibility KPIs, retainability KPIs, mobility KPIs, utilisation KPIs.

</p><li>In-depth overview of the air Interfaces </li><p>
GSM/GPRS FDMA &amp; TDMA solution, 3G UMTS WCDMA solution, HSPA+ sharing spare power (Codes), The 3G LTE uplink &amp; downlink interface explained, Initial attach procedures explained.

</p><li>Problem analysis </li><p>
Reference Signal Received Power (RSRP), Signal to Interference Noise Ratio (SINR), handover success rates, power adjustments, classification of coverage problems, weak coverage &amp; coverage holes, lack of dominant cells, cross coverage, improper tilt settings, uplink/downlink imbalance, signal quality, Azimuths &amp; tilts to reduce interference, Handover failure due to interference, Service drop causes.

</p><li>Mobile RF performance in 2G/3G </li><p>
Performance counters, KPIs, testing &amp; measurement, Drive testing and survey, Data collection and post processing of data, LTE service optimization, bandwidth, poor coverage, Quality, optimization process, KPI optimization, Root Cause Analysis (RCA) applied to RF issues, optimization tools and software.

</p><li>Advanced LTE network planning &amp; optimization </li><p>
LTE UE measurements (RSRP/RSRQ), LTE capacity planning, RF configuration parameters, LTE cell selection/reselection planning, LTE radio network KPIs, LTE user-centric KPIs, LTE network performance KPIs, LTE system utilization KPIs, LTE RF channel performance predictions, LTE channel information processing, LTE channel multiplexing, Physical layer and structure, MIMO in LTE, LTE resource plan LTE and Self-Organizing Networks (SON).

</p><li>Radio network optimization work flow </li><p>
Work flow, the existing network, Optimization team establishment and cluster division, Single site verification, Alarm check, Cell state check, Radio parameters check, Site verification, Statistics analysis, Coverage problem analysis.

</p><li>Mobile internet and QoS issues </li><p>
Cellular QoS reference models. How QoS impact on KPIs and measurements, Introduction to mobile internet, The concept of shared access technologies, Support for QoS in the WCDMA environment, The PDP context model, Supporting end-to-end QoS, EPS bearer concepts, Default EPS bearer, Dedicated EPS bearer, APN-AMBR, UE-AMBR.</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

LTE optimisation and capability

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>The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure.</p><p></p><p></p><p>In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.</p><p></p>Prerequisites<p></p><p>Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions.</p>  <li>AZ-900T00 Microsoft Azure Fundamentals</li>  <li>DP-900T00 Microsoft Azure Data Fundamentals</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to data engineering on Azure</h3> <ul> <li>What is data engineering</li> <li>Important data engineering concepts</li> <li>Data engineering in Microsoft Azure</li> </ul> <h3>2 - Introduction to Azure Data Lake Storage Gen2</h3> <ul> <li>Understand Azure Data Lake Storage Gen2</li> <li>Enable Azure Data Lake Storage Gen2 in Azure Storage</li> <li>Compare Azure Data Lake Store to Azure Blob storage</li> <li>Understand the stages for processing big data</li> <li>Use Azure Data Lake Storage Gen2 in data analytics workloads</li> </ul> <h3>3 - Introduction to Azure Synapse Analytics</h3> <ul> <li>What is Azure Synapse Analytics</li> <li>How Azure Synapse Analytics works</li> <li>When to use Azure Synapse Analytics</li> </ul> <h3>4 - Use Azure Synapse serverless SQL pool to query files in a data lake</h3> <ul> <li>Understand Azure Synapse serverless SQL pool capabilities and use cases</li> <li>Query files using a serverless SQL pool</li> <li>Create external database objects</li> </ul> <h3>5 - Use Azure Synapse serverless SQL pools to transform data in a data lake</h3> <ul> <li>Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement</li> <li>Encapsulate data transformations in a stored procedure</li> <li>Include a data transformation stored procedure in a pipeline</li> </ul> <h3>6 - Create a lake database in Azure Synapse Analytics</h3> <ul> <li>Understand lake database concepts</li> <li>Explore database templates</li> <li>Create a lake database</li> <li>Use a lake database</li> </ul> <h3>7 - Analyze data with Apache Spark in Azure Synapse Analytics</h3> <ul> <li>Get to know Apache Spark</li> <li>Use Spark in Azure Synapse Analytics</li> <li>Analyze data with Spark</li> <li>Visualize data with Spark</li> </ul> <h3>8 - Transform data with Spark in Azure Synapse Analytics</h3> <ul> <li>Modify and save dataframes</li> <li>Partition data files</li> <li>Transform data with SQL</li> </ul> <h3>9 - Use Delta Lake in Azure Synapse Analytics</h3> <ul> <li>Understand Delta Lake</li> <li>Create Delta Lake tables</li> <li>Create catalog tables</li> <li>Use Delta Lake with streaming data</li> <li>Use Delta Lake in a SQL pool</li> </ul> <h3>10 - Analyze data in a relational data warehouse</h3> <ul> <li>Design a data warehouse schema</li> <li>Create data warehouse tables</li> <li>Load data warehouse tables</li> <li>Query a data warehouse</li> </ul> <h3>11 - Load data into a relational data warehouse</h3> <ul> <li>Load staging tables</li> <li>Load dimension tables</li> <li>Load time dimension tables</li> <li>Load slowly changing dimensions</li> <li>Load fact tables</li> <li>Perform post load optimization</li> </ul> <h3>12 - Build a data pipeline in Azure Synapse Analytics</h3> <ul> <li>Understand pipelines in Azure Synapse Analytics</li> <li>Create a pipeline in Azure Synapse Studio</li> <li>Define data flows</li> <li>Run a pipeline</li> </ul> <h3>13 - Use Spark Notebooks in an Azure Synapse Pipeline</h3> <ul> <li>Understand Synapse Notebooks and Pipelines</li> <li>Use a Synapse notebook activity in a pipeline</li> <li>Use parameters in a notebook</li> </ul> <h3>14 - Plan hybrid transactional and analytical processing using Azure Synapse Analytics</h3> <ul> <li>Understand hybrid transactional and analytical processing patterns</li> <li>Describe Azure Synapse Link</li> </ul> <h3>15 - Implement Azure Synapse Link with Azure Cosmos DB</h3> <ul> <li>Enable Cosmos DB account to use Azure Synapse Link</li> <li>Create an analytical store enabled container</li> <li>Create a linked service for Cosmos DB</li> <li>Query Cosmos DB data with Spark</li> <li>Query Cosmos DB with Synapse SQL</li> </ul> <h3>16 - Implement Azure Synapse Link for SQL</h3> <ul> <li>What is Azure Synapse Link for SQL?</li> <li>Configure Azure Synapse Link for Azure SQL Database</li> <li>Configure Azure Synapse Link for SQL Server 2022</li> </ul> <h3>17 - Get started with Azure Stream Analytics</h3> <ul> <li>Understand data streams</li> <li>Understand event processing</li> <li>Understand window functions</li> </ul> <h3>18 - Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics</h3> <ul> <li>Stream ingestion scenarios</li> <li>Configure inputs and outputs</li> <li>Define a query to select, filter, and aggregate data</li> <li>Run a job to ingest data</li> </ul> <h3>19 - Visualize real-time data with Azure Stream Analytics and Power BI</h3> <ul> <li>Use a Power BI output in Azure Stream Analytics</li> <li>Create a query for real-time visualization</li> <li>Create real-time data visualizations in Power BI</li> </ul> <h3>20 - Introduction to Microsoft Purview</h3> <ul> <li>What is Microsoft Purview?</li> <li>How Microsoft Purview works</li> <li>When to use Microsoft Purview</li> </ul> <h3>21 - Integrate Microsoft Purview and Azure Synapse Analytics</h3> <ul> <li>Catalog Azure Synapse Analytics data assets in Microsoft Purview</li> <li>Connect Microsoft Purview to an Azure Synapse Analytics workspace</li> <li>Search a Purview catalog in Synapse Studio</li> <li>Track data lineage in pipelines</li> </ul> <h3>22 - Explore Azure Databricks</h3> <ul> <li>Get started with Azure Databricks</li> <li>Identify Azure Databricks workloads</li> <li>Understand key concepts</li> </ul> <h3>23 - Use Apache Spark in Azure Databricks</h3> <ul> <li>Get to know Spark</li> <li>Create a Spark cluster</li> <li>Use Spark in notebooks</li> <li>Use Spark to work with data files</li> <li>Visualize data</li> </ul> <h3>24 - Run Azure Databricks Notebooks with Azure Data Factory</h3> <ul> <li>Understand Azure Databricks notebooks and pipelines</li> <li>Create a linked service for Azure Databricks</li> <li>Use a Notebook activity in a pipeline</li> <li>Use parameters in a notebook</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-203T00 Data Engineering on Microsoft Azure 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 DP-203T00 Data Engineering on Microsoft Azure course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Data Engineering

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

DP-203T00 Data Engineering on Microsoft Azure

<h3><b>Signalling training course description</b></h3>
      <p>An intensive course that defines and explores the signalling methods that are to be found in today's telecommunications services.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
     <li>Describe the Functionality and Features of Signalling.</li>
					<li>Describe the Functionality of Analogue &amp; Digital Subscriber Signalling.</li>
                    
                    <li>Describe the various types of signalling used on different network types.</li>
                    <li>Describe the Functionality of Private Network Signalling.</li>
                    <li>Describe the Functionality of Public Network Signalling.</li>
                  </ul>
        <h5>
        <b>Signalling training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Personnel involved with systems design, implementation and support.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Telecommunications Introduction</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Signalling training course contents</b></h3>
      <ul>
				<li>Introduction 	</li><p>
What is Signalling?, Standards, ITU-T Recommendations, Signalling Categories - Supervisory Addressing, E.164, Call Information, Network Management, Network Components, Inband/Outband Switch Signalling, Analogue Vs Digital Signalling.

</p><li>Analogue Subscriber Signalling </li><p>
Analogue Local Loops/Switches/Trunks, Digital Switches/Local Loops, Telephone Handset, Accessing the Local Exchange, Pulse/Tone Dialling.

</p><li>Digital Subscriber Signalling </li><p>
Integrated Digital Access, DASS2 &amp; DPNSS, DASS2 - Call, IMUX, Euro ISDN, Q.931 Call Control, Message Identification, Message Types, Call Establishment Messages, Call Clearing.

</p><li>Network Types </li><p>
Service Types, Circuit Switched, Packet Switched, Signalling Terminology, In-Channel Signalling, G.704, Performance and Quality, Digital Signalling, CAS, CAS Applications, Foreign Exchange, CCS, Break-In/Out

</p><li>Private Network Signalling Types </li><p>
Networking PABXs, Inter PABX Analogue Signalling Methods, E &amp; M, Tone-On-Idle, Inter PABX Digital Signalling Methods, DPNSS, DPNSS Deployment, PABX Support for DPNSS, DPNSS Call, Q.Sig, Q.Sig support/functionality/protocol, Message Overview, Call Establishment.

</p><li>Public Network Signalling </li><p>
SS7, SS7 Operations, SS7 Topology, SSP, STP, SCP, Database Types - CMSDB NP LIDB HLR VLR, Signalling Modes, Link Types, Further Redundancy, Linksets, SS7 addressing, Point Codes, Sub-System, Global Title Addressing and Translation, ANSI PCs, ITU-T PCs, SS7 Protocol Stack, MTP Level 1, MTP Level 2, Flow Control, FISU, LSSU, MSU, MSU SIF, MTP Level 3, SCCP, TCAP, TUP, Facility Format, Main Facilities, Flow Control Negotiation, Closed User Groups, Reverse Charging, Fast Select Facility, Throughput Class Negotiation, Call Barring, On-Line Facility Registration. BTUP, ISDN ISUP, Supplementary Services, ISUP Call - IAM, Progress/Answer/Suspend/ Resume/Release Messages,

</p><li>Intelligent Network (IN) </li><p>
Introduction, IN Evolution, IN Conceptual Model, IN Target Services &amp; Service Features, Service Independent Building Blocks
</p>
      </ul>

Signalling systems for engineers

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 5 full-day course is aimed at engineers and supervisors who already have a basic understanding of well construction methods but who would benefit from a more detailed knowledge of completion design. The course will concentrate on the important aspects of completion design and what makes a safe and efficient well.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A common thread of practical examples will be used throughout the course in the form of a case study or &ldquo;red-thread&rdquo; exercise. The case study is based around data all taken from a single field where those attending will work through all the basic issues of a completion design. The exercises associated with the case study is performed in the student&rsquo;s own time after each of the formal sessions. However, at the start of the next day, the case study is reviewed and discussed. The whole case study will continue through all sessions, with each element being reviewed at the start of the next session. There is no &lsquo;right&rsquo; answer to the exercise &ndash; producing interesting discussions!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The purpose of the course is not to go over specific equipment in detail. Teaching methods include presentations, videos, and animations and the case study.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course will cover:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Types and configurations of completions</li><li fr-original-style="" style="box-sizing: border-box;">The completion design process</li><li fr-original-style="" style="box-sizing: border-box;">Inflow performance, skin and formation damage</li><li fr-original-style="" style="box-sizing: border-box;">Perforating; selection, deployment and interface with rest of completion</li><li fr-original-style="" style="box-sizing: border-box;">Stimulation and impact on completion and flow performance with coverage of modern horizontal multifrac tools</li><li fr-original-style="" style="box-sizing: border-box;">Open hole, non-sand control completions including open hole packers and horizontal well clean up</li><li fr-original-style="" style="box-sizing: border-box;">Sand control; when do you need it, basic types and selection guidelines. Includes standalone screens, ICDs, various gravel packing techniques, frac packs and expandable screens</li><li fr-original-style="" style="box-sizing: border-box;">Tubing sizing, flow estimation and liquid loading</li><li fr-original-style="" style="box-sizing: border-box;">Artificial lift; types and selection criteria, interface with drilling, reservoir and facilities. Design of gas lift and ESPs included</li><li fr-original-style="" style="box-sizing: border-box;">Production chemistry impacts on completion, prevention and removal (scales, wax, asphaltene, hydrates, and souring)</li><li fr-original-style="" style="box-sizing: border-box;">Metallurgy, corrosion, and erosion; metal types and selection of</li><li fr-original-style="" style="box-sizing: border-box;">Elastomers and plastics; types and selection of</li><li fr-original-style="" style="box-sizing: border-box;">Tubing stress analysis; picking the grade and weight of tubing, plus selection criteria for packers and expansion devices. Interface between tubing stress analysis and casing design</li><li fr-original-style="" style="box-sizing: border-box;">Completion equipment; basic types of equipment, reliability and selection criteria for each (tree, safety valve, mandrel, packers, expansion devices etc)</li><li fr-original-style="" style="box-sizing: border-box;">Completion installation; importance of wellbore clean-out, function and types of brines, pointers for efficient completion installation</li><li fr-original-style="" style="box-sizing: border-box;">Non-conventional wells; types and when / where to use them (multilaterals, smart (intelligent) wells and also SAGD, CO2 sequestration, CBM, etc)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p></section><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/completion-design-classroom-training/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Completion Design" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">Training Objectives</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this course, the participants should be able to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a good understanding of the completion design process and what makes a good completion design</li><li fr-original-style="" style="box-sizing: border-box;">Understand the importance of the installation process (completion running) in the design process</li><li fr-original-style="" style="box-sizing: border-box;">Have an appreciation of new and developing completion techniques (intelligent wells)</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">Target Audience</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will benefit&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">engineers and field-based personnel such as completion supervisors and production engineers</strong>. It is also suitable for&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">completion vendors, specialists such as chemists and subsurface personnel including geologists, reservoir engineers and petrophysicists</strong>.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">Course Level</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">Trainer</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has 30 years of oil and gas industry experience. A first class degree in geophysics and a master degree in Petroleum Engineering was a prelude to seven years with BP as a petroleum engineer. He left BP and following a short spell in Camco, jointly founded ICE Energy. After six years of completions and petroleum engineering consultancy and training, ICE Energy merged with TRACS International, where he continued with petroleum and completion engineering studies, leading integrated teams, and developing / delivering training courses for a variety of different clients in diverse world-wide locations. In the last five years, he is independent again &ndash; focusing on technical consulting and course delivery.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"></a></section><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/completion-design-classroom-training/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Completion Design" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/completion-design-classroom-training/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information post training support</a>&nbsp;and fees applicable</p></div></section>

EnergyEdge - Training for a Sustainable Energy Future

Engineering Construction Industry Training (ECITB)

Petroleum Engineering

Professional Skills Course (PSC)

Enhance your expertise in completion design with EnergyEdge's comprehensive classroom training. Join now and gain valuable insights!

Completion Design

Team of 10, pp

Normal Fee, pp

London

<h2>SAFe® for Government: In-House Training</h2>
<p>Transitioning to Lean-Agile practices for building technology-based capabilities is especially challenging in the government context.</p>
<p>But issues of legacy governance, contracting, and organizational barriers can be overcome with the right information and strategies. During this course, attendees will learn the principles and practices of the Scaled Agile Framework® (SAFe®), how to execute and release value through Agile Release Trains, and what it means to lead a Lean-Agile transformation of a program inside a government agency. Attendees gain an understanding of the Lean-Agile mindset and why it's an essential foundation for transformation. They'll also get practical advice on building high-performing, multi-vendor Agile teams and programs, managing technology investments in Lean flow, acquiring solutions with Agile contracting, launching the program, and planning and delivering value using SAFe®. Attendees also learn how specific leadership behaviors can drive successful organizational change in government.</p><h3>What you will Learn</h3>
<p>To perform the role of a SAFe® for Government leader, you should be able to:</p>
<ul>
<li>Transition government programs from traditional software and systems development models to Lean-Agile and DevOps mindsets, principles, and practices using SAFe®</li>
<li>Adapt technology strategy, budgeting and forecasting, acquisition, compliance, and governance processes to flow-based practices using emerging government guidelines</li>
<li>Organize government programs into one or more Agile Release Trains (ARTs) and execute in Program Increments (PIs)</li>
<li>Explore Large Solution coordination in a government and multi-vendor environment</li>
<li>Identify and internalize the mindset and leader behaviors essential to successful Lean-Agile transformation</li>
<li>Follow success patterns for SAFe® implementations adapted to the government context</li>
<li>Build a preliminary outline of next steps to begin and / or accelerate the SAFe® implementation in your program or agency</li>
</ul><section>
                    <ul><li>Advancing Lean-Agile in government</li><li>Embracing a Lean-Agile mindset</li><li>Understanding SAFe® Principles</li><li>Creating high-performing Agile teams and programs</li><li>Planning with cadence and synchronization</li><li>Delivering value in Program Increments</li><li>Mapping the path to agency and program agility</li><li>Leading successful change</li></ul>


                </section>

IIL Europe Ltd

SAFe for Government: In-House Training

<h2>SAFe® for Government</h2>
<p>Transitioning to Lean-Agile practices for building technology-based capabilities is especially challenging in the government context.</p>
<p>But issues of legacy governance, contracting, and organizational barriers can be overcome with the right information and strategies. During this course, attendees will learn the principles and practices of the Scaled Agile Framework® (SAFe®), how to execute and release value through Agile Release Trains, and what it means to lead a Lean-Agile transformation of a program inside a government agency. Attendees gain an understanding of the Lean-Agile mindset and why it's an essential foundation for transformation. They'll also get practical advice on building high-performing, multi-vendor Agile teams and programs, managing technology investments in Lean flow, acquiring solutions with Agile contracting, launching the program, and planning and delivering value using SAFe®. Attendees also learn how specific leadership behaviors can drive successful organizational change in government.</p><h3>What you will Learn</h3>
<p>To perform the role of a SAFe® for Government leader, you should be able to:</p>
<ul>
<li>Transition government programs from traditional software and systems development models to Lean-Agile and DevOps mindsets, principles, and practices using SAFe®</li>
<li>Adapt technology strategy, budgeting and forecasting, acquisition, compliance, and governance processes to flow-based practices using emerging government guidelines</li>
<li>Organize government programs into one or more Agile Release Trains (ARTs) and execute in Program Increments (PIs)</li>
<li>Explore Large Solution coordination in a government and multi-vendor environment</li>
<li>Identify and internalize the mindset and leader behaviors essential to successful Lean-Agile transformation</li>
<li>Follow success patterns for SAFe® implementations adapted to the government context</li>
<li>Build a preliminary outline of next steps to begin and / or accelerate the SAFe® implementation in your program or agency</li>
</ul><section>
                    <ul><li>Advancing Lean-Agile in government</li><li>Embracing a Lean-Agile mindset</li><li>Understanding SAFe® Principles</li><li>Creating high-performing Agile teams and programs</li><li>Planning with cadence and synchronization</li><li>Delivering value in Program Increments</li><li>Mapping the path to agency and program agility</li><li>Leading successful change</li></ul>


                </section>

SAFe for Government

<h3><b>Microsoft Exchange training course description</b></h3>
      <p>    
             A hands on course focusing on the day to day running
of Microsoft Exchange. The course is designed for
those with a sound understanding of how Exchange
forwards emails and concentrates on important issues
such as monitoring, backups and restores. This course
can be delivered on any version of Microsoft exchange
and tailored as required.  </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	   <li>Install MS Exchange</li>
					<li>Create, configure and manage user mailboxes.</li>
                    <li>Configure and administer MS Exchange.</li>
                    <li>Backup and restore MS Exchange. </li>
                  </ul>
                
        <h5><b>Microsoft Exchange training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with MS Exchange.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Total SMTP and email for engineers
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Microsoft Exchange training course contents</b></h3>
      <ul>
				<li>Review of mail basics </li><p>
Basic routing &amp; Client/Server, 
Mail flow &amp; protocols, 
Mail server technology.

</p><li>Exchange features </li><p>
MAPI, 
Database, 
The Exchange organisation, 
Active Directory consideration.

</p><li>Installing </li><p>
Understanding server roles, 
Planning for Exchange, 
Preparing Active Directory, 
Preparing the host server, 
Installing Exchange.

</p><li>Introduction to Exchange management tools </li><p>
Exchange Management shell, 
Exchange Management console.

</p><li>Administration </li><p>
Configuring SMTP domains, 
Send connectors, 
Receive connectors, 
Setting up &amp; managing user mailboxes, 
Setting up resource mailboxes, 
Mail enabled groups, 
Address lists.

</p><li>Troubleshooting </li><p>
Security &amp; troubleshooting wizards, 
Windows platform tools, 
External/Internet tools.
</p>
      </ul>

Supporting Microsoft Exchange

<h2>Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop</h2>
 <p>The Disciplined Agile Value Stream Consultant workshop teaches you how to use value stream management to create a tailored approach for any organization to accelerate delivery of value to their customers. It provides a combination of Lean, Flow, Theory of Constraints and Organizational Development theories and practices. The workshop integrates with the Disciplined Agile tool kit to provide those practices that will be most effective for where it is applied, whether it be a new Agile transition or continuing a stagnated SAFe® or Spotify one.</p><h3>What You Will Learn</h3>
 <p>After the completion of this course, you will be able to:</p>
 <ul>
 <li>Learn to determine the best place for an organization to start - portfolio management, product management or development area</li>
 <li>Be equipped to tailor an organization's improvement plan based on their unique needs, while also attending to the culture of the organization to evolve at their proper pace</li>
 <li>Be able to train an organization to continue to improve on their own</li>
 <li>Know how to accelerate value delivery at scale</li>
 <li>Be prepared to take the Disciplined Agile Value Stream Consultant (DAVSC) exam and earn valuable, credible certification. Your exam fee is included in tuition.</li>
 </ul><section>
                    <p>The course is comprised of an introduction and 14 lessons and supplemental materials provided electronically:</p>
 <ul>
 <li>Introduction: The Disciplined Agile Mindset</li>
 <li>Lesson 1: Value Stream Consultant: Role and Work</li>
 <li>Lesson 2: The Idealized Value Stream</li>
 <li>Lesson 3: Removing Delays in the Workflow</li>
 <li>Lesson 4: The Minimum Business Increment</li>
 <li>Lesson 5: The Discovery Workflow and the Development Intake Process</li>
 <li>Lesson 6: Value Flow Planning and Coordination</li>
 <li>Lesson 7: Working with a Common Cadence and Synchronization</li>
 <li>Lesson 8: End of Increment Activities and Reducing, Not Accommodating Dependencies</li>
 <li>Lesson 9: Factors for Effective Value Streams</li>
 <li>Lesson 10: Value Creation Structure</li>
 <li>Lesson 11: Agile Budgeting and Lean Funding</li>
 <li>Lesson 12: Creating Visibility Across the Organization</li>
 <li>Lesson 13: Key Roles</li>
 <li>Lesson 14: The Disciplined Agile Playbook</li>
 </ul>


                </section>

Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop

<p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><b fr-original-style="" style="box-sizing: border-box;">Are you ready for an extraordinary upgrade?&nbsp;</b><b fr-original-style="" style="box-sizing: border-box;">My team of guides steps forward to share with you all the new teachings, and much more advanced frequencies so you can align your lifestream with the New Earth.&nbsp;</b></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Anchor the next level of Cosmic Christ Consciousness and connect directly with your own Stargate to the Galactic Centre and beyond.&nbsp;<b fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></b></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">For you, on the forefront of humanity&#39;s conscious evolution, you receive the latest tools, codes and insights to manifest and create in this ever-expanding New Earth realm.</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">It is designed to support your energetic advancements together with your personal environment - your home, family and workplace. Creating a harmonious field for all to flourish and expand together with joy.</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><b fr-original-style="" style="box-sizing: border-box;">In this series, you receive Cosmic Christ Conscious Initiations directly from various Ascension Masters, Archangels and the Divine Director.</b></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">This includes the awakening of your Godseed which enhances your kundalini flow, clears ancient blockages of the Old Earth and setting you free to explore your highest potential in the New Earth.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Each series is overlighted by a dedicated Ascension Guide - such as Ashtar Command, Lord Melchizedek and the Divine Director together with various twin flame couples to provide you with the highest Divine Templates available at this time on Earth both for the Divine Feminine and the Divine Masculine.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Teachings and topics for this series</strong></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Part 1 - Accessing your&nbsp;Multidimensional&nbsp;Soul Akash</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Part 2 - Anchoring Oneness&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Part 3 - Opening the Stargate of your Heart&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">As Jeshua and Mary Magdalene anchored the pathway from Above - so below now is the time to bring forth the within so without. A new way of heart resonance in harmony with all that is connected to the Galactic Core and beyond.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Discover the origins of your soul from interplanetary, earth based or angelic soul codes and receive your unique soul codes to expand your consciousness in a whole new way.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">In the teachings you learn new ways to protect and enhance the vibration in your home with sacred geometry, candles and new invocations that support you with your increasing frequency.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">Your light body will receive&nbsp;the&nbsp;upgrade from&nbsp;your Merkabah&nbsp;structure&nbsp;into a star tetrahedron, which is not only anchored in your auric field yet also deeply embedded into your cellular&nbsp;structure throughout the series.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);">The four directions - different streams from the wisdom teachings of Avalon to the buddhistic interconnectedness of all life, with the sacred understanding of the Natives to honour all life and care for Gaia as well as the Essene in their deep awareness of the Christ Consciousness and Oneness: in this series all pathways will be brought together to align you with the sacred wheel of the New Earth.&nbsp;</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will experience</strong></p><ul style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Access your multidimensional Soul Akash</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Grail Initiations with various twin flames from different realms providing you with ever-expanding codes</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clearing ancient blockages of the &#39;Old Earth&#39;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Activate your multidimensional Ascension Stargate of the Heart</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Anchor your New Ascension Light Body directly in your cellular structure&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Weaving all your timelines into a singular one&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Direct Transmissions from various Twin flame couples&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Godseed Awakening &amp; Kundalini flow giving you access to Divine Source Energy</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Soul Signature Encodements from your Monad&nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Crystalline codes rewrite your DNA for your wellbeing</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You will learn to harness your energy in a whole new way</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Align your life, home and family with the New Earth for all to flourish</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Strengthen your energetic presence to maintain your frequency whilst interacting with the &#39;Old Earth&#39;&nbsp;</li></ul><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><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></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">In this process, the team of guides support you over these three months and deepen your connection with Spirit. You discover and connect with your Ascension guide and various Masters, collective Consciousness such as the Venusians and Golden Solar Light Beings together with your own galactic &#39;home&#39;.&nbsp;</span></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><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></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><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></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">For all participants </b></span></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><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></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You can either join live or enjoy the replay at a convenient time for you. The audio and video files will be sent out after the live event so you can dive into the activations anytime. The duration is approximately two to three hours for each date.</span></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(58, 63, 69); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><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;">Find your time zone&nbsp;</strong></span></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">08.00 AM &ndash; HI &nbsp;| 12.00 PM &ndash; MST &nbsp;| &nbsp;02.00 PM &ndash; EST &nbsp;| &nbsp;06.00 PM &ndash; BST &nbsp;| &nbsp;07.00 PM &ndash; CEST</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dates</strong></span></p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(58, 63, 69);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Part 1</strong>&nbsp; &nbsp; March 24th, Sunday 2024 &ndash; ZOOM</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Part 2&nbsp;</strong>&nbsp; &nbsp;April 28th, Sunday 2024 &ndash; ZOOM</p><p style="color: rgb(58, 63, 69); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(58, 63, 69);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Part 3</strong>&nbsp; &nbsp; May 26th, Sunday 2024 &ndash; ZOOM</p></div>

Are you ready for an extraordinary upgrade? My team of guides steps forward to share with you all the new teachings, and much more advanced frequencies so you can align your lifestream with the New Earth. 
Anchor the next level of Cosmic Christ Consciousness and connect directly with your own Stargate to the Galactic Centre and beyond. 

For you, on the forefront of humanity's conscious evolution, you receive the latest tools, codes and insights to manifest and create in this ever-expanding New Earth realm.
It is designed to support your energetic advancements together with your personal environment - your home, family and workplace. Creating a harmonious field for all to flourish and expand together with joy.


In this series, you receive Cosmic Christ Conscious Initiations directly from various Ascension Masters, Archangels and the Divine Director.
This includes the awakening of your Godseed which enhances your kundalini flow, clears ancient blockages of the Old Earth and setting you free to explore your highest potential in the New Earth. 
Each series is overlighted by a dedicated Ascension Guide - such as Ashtar Command, Lord Melchizedek and the Divine Director together with various twin flame couples to provide you with the highest Divine Templates available at this time on Earth both for the Divine Feminine and the Divine Masculine. 


Teachings and topics for this series
Part 1 - Accessing your Multidimensional Soul Akash
Part 2 - Anchoring Oneness 
Part 3 - Opening the Stargate of your Heart 
As Jeshua and Mary Magdalene anchored the pathway from Above - so below now is the time to bring forth the within so without. A new way of heart resonance in harmony with all that is connected to the Galactic Core and beyond. 
Discover the origins of your soul from interplanetary, earth based or angelic soul codes and receive your unique soul codes to expand your consciousness in a whole new way. 
In the teachings you learn new ways to protect and enhance the vibration in your home with sacred geometry, candles and new invocations that support you with your increasing frequency. 
Your light body will receive the upgrade from your Merkabah structure into a star tetrahedron, which is not only anchored in your auric field yet also deeply embedded into your cellular structure throughout the series. 
The four directions - different streams from the wisdom teachings of Avalon to the buddhistic interconnectedness of all life, with the sacred understanding of the Natives to honour all life and care for Gaia as well as the Essene in their deep awareness of the Christ Consciousness and Oneness: in this series all pathways will be brought together to align you with the sacred wheel of the New Earth. 


You will experience
Access your multidimensional Soul Akash
Grail Initiations with various twin flames from different realms providing you with ever-expanding codes
Clearing ancient blockages of the 'Old Earth'
Activate your multidimensional Ascension Stargate of the Heart
Anchor your New Ascension Light Body directly in your cellular structure
Weaving all your timelines into a singular one
Direct Transmissions from various Twin flame couples
Godseed Awakening & Kundalini flow giving you access to Divine Source Energy
Soul Signature Encodements from your Monad
Crystalline codes rewrite your DNA for your wellbeing
You will learn to harness your energy in a whole new way
Align your life, home and family with the New Earth for all to flourish
Strengthen your energetic presence to maintain your frequency whilst interacting with the 'Old Earth'
In this process, the team of guides support you over these three months and deepen your connection with Spirit. You discover and connect with your Ascension guide and various Masters, collective Consciousness such as the Venusians and Golden Solar Light Beings together with your own galactic 'home'. For all participants You can either join live or enjoy the replay at a convenient time for you. The audio and video files will be sent out after the live event so you can dive into the activations anytime. The duration is approximately two to three hours for each date.
Find your time zone 
08.00 AM – HI | 12.00 PM – MST | 02.00 PM – EST | 06.00 PM – BST | 07.00 PM – CEST


Dates
Part 1 March 24th, Sunday 2024 – ZOOM
Part 2  April 28th, Sunday 2024 – ZOOM
Part 3 May 26th, Sunday 2024 – ZOOM

Katarina Heuser

Health & Wellbeing

Meditation

Discover your special powers, receive insights and deep healing together with an abundance of light codes taking your life to the next level!

Cosmic Christ Series

<h2>SAFe® for Government: Virtual In-House Training</h2>
<p>Transitioning to Lean-Agile practices for building technology-based capabilities is especially challenging in the government context.</p>
<p>But issues of legacy governance, contracting, and organizational barriers can be overcome with the right information and strategies. During this course, attendees will learn the principles and practices of the Scaled Agile Framework® (SAFe®), how to execute and release value through Agile Release Trains, and what it means to lead a Lean-Agile transformation of a program inside a government agency. Attendees gain an understanding of the Lean-Agile mindset and why it's an essential foundation for transformation. They'll also get practical advice on building high-performing, multi-vendor Agile teams and programs, managing technology investments in Lean flow, acquiring solutions with Agile contracting, launching the program, and planning and delivering value using SAFe®. Attendees also learn how specific leadership behaviors can drive successful organizational change in government.</p><h3>What you will Learn</h3>
<p>To perform the role of a SAFe® for Government leader, you should be able to:</p>
<ul>
<li>Transition government programs from traditional software and systems development models to Lean-Agile and DevOps mindsets, principles, and practices using SAFe®</li>
<li>Adapt technology strategy, budgeting and forecasting, acquisition, compliance, and governance processes to flow-based practices using emerging government guidelines</li>
<li>Organize government programs into one or more Agile Release Trains (ARTs) and execute in Program Increments (PIs)</li>
<li>Explore Large Solution coordination in a government and multi-vendor environment</li>
<li>Identify and internalize the mindset and leader behaviors essential to successful Lean-Agile transformation</li>
<li>Follow success patterns for SAFe® implementations adapted to the government context</li>
<li>Build a preliminary outline of next steps to begin and / or accelerate the SAFe® implementation in your program or agency</li>
</ul><section>
                    <ul><li>Advancing Lean-Agile in government</li><li>Embracing a Lean-Agile mindset</li><li>Understanding SAFe® Principles</li><li>Creating high-performing Agile teams and programs</li><li>Planning with cadence and synchronization</li><li>Delivering value in Program Increments</li><li>Mapping the path to agency and program agility</li><li>Leading successful change</li></ul>


                </section>

SAFe for Government: Virtual 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

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online.</p>Overview<p>#NAME?</p><p>This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - An Introduction to SharePoint Online</h3> <ul> <li>Introducing Office 365 and SharePoint</li> <li>Getting started with Office 365</li> <li>The cloud revolution</li> <li>Login to Office 365</li> <li>What is Office 365</li> <li>Using the app launcher</li> <li>What is SharePoint</li> <li>Office 365 settings</li> <li>Introducing Office 365 Groups</li> <li>Delve</li> <li>Ownership and Access</li> <li>OneDrive</li> </ul> <h3>2 - Creating Sites</h3> <ul> <li>Planning your sites</li> <li>Create new subsites</li> <li>The Office 365 tenant</li> <li>Site templates</li> <li>Web addresses</li> <li>Apply a them</li> <li>Site collections</li> <li>Building your navigation</li> <li>Create a new site</li> <li>Delete subsites</li> <li>Team site navigation</li> <li>User interface: classic vs modern</li> <li>Site contents: classic vs modern</li> <li>Where does classic come from?</li> </ul> <h3>3 - Creating and Managing Web Pages</h3> <ul> <li>The types of pages found in SharePoint</li> <li>Classic SharePoint pages</li> <li>Modern SharePoint pages</li> <li>How to use classic team site pages</li> <li>Create news and site pages</li> <li>Review features of publishing sites</li> <li>Web parts</li> <li>Save, publish, share and delete pages</li> <li>Communication sites</li> </ul> <h3>4 - Working with Apps</h3> <ul> <li>An introduction to apps</li> <li>Co-authoring</li> <li>Marketplace apps</li> <li>Check In ? Out</li> <li>Adding apps to a site</li> <li>Edit and view file properties</li> <li>Create and manage columns</li> <li>Quick edit view</li> <li>Public and personal views</li> <li>File commands</li> <li>Managing app settings</li> <li>Copy link and Share</li> <li>Content approval</li> <li>Folders</li> <li>Major and minor versioning</li> <li>The recycle bin</li> <li>Document sets</li> <li>Alerts</li> <li>Working with files in a library</li> <li>OneDrive sync</li> <li>Create, Upload and edit files</li> <li>Working with classic lists</li> </ul> <h3>5 - Building processes with Flow and PowerApps</h3> <ul> <li>What are business processes?</li> <li>Design and publish a Flow</li> <li>Classic tools for designing processes</li> <li>Getting started with PowerApps in SharePoint</li> <li>Design and test a classic workflow</li> <li>Enhance data capture with PowerApps</li> <li>Getting started with Flow in SharePoint</li> <li>Test a Flow and PowerApps enriched list</li> </ul> <h3>6 - Customizing Security</h3> <ul> <li>Office 365 Group access</li> <li>Share a file</li> <li>Updating Office 365 Group Security</li> <li>Remove a user</li> <li>Managing access to SharePoint</li> <li>Customizing SharePoint security</li> <li>New sites private vs public</li> <li>Create permission levels and groups</li> <li>Setup access requests</li> <li>Security inheritance</li> <li>Share a site</li> <li>Security best practices</li> </ul> <h3>7 - Working with Search</h3> <ul> <li>Delve</li> <li>Search tips</li> <li>An introduction to SharePoint search</li> <li>Accessing classic search</li> <li>Search in folders, libraries and sites</li> <li>Promoted results</li> <li>Search results</li> </ul> <h3>8 - Enterprise Content Management</h3> <ul> <li>Managed metadata service</li> <li>Information management policies</li> <li>An introduction to content types</li> <li>The records center</li> <li>Create and manage content type</li> <li>In-place records management</li> <li>Deploy content types</li> <li>The content organizer</li> <li>Using content types in apps</li> <li>Durable links</li> <li>The content type hub</li> </ul></div>

Online Course Creation

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

Reading

Nottingham

Dickson Training Ltd

ILM Level 3 Award in Leadership and Management

Online Course

Classroom Course

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



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)

Everything is energy. This is a simple scientific fact. When our energy is flowing and we are in harmony with ourselves, our world reflects this same harmony. Yet so few of us work in harmony with our energies. We question why we suffer the same problems over and over again. We wonder why we work on ourselves yet still don't seem to see the progress we would like. 
The answer could well lie within your energy.
There are seven main energy centres, or chakras, within our personal energy field that govern different areas of your life. In cleansing and healing each chakra, you open yourself up to cleansing and healing the associated aspect of your life. You clear physical and emotional blocks to free your energies to flow and bring in success, joy, and love. 
As you progress through this 9-week energy healing journey, you will learn about each chakra. You will discover where each one is located in your energetic body as well as what each is associated with so you can connect with that chakra more effectively. You'll discover how your chakras are affecting your health, your relationships, your career, and all other areas of your life. 
Each workshop will start by reflecting on your experience so far and thinking about what you would like to achieve over the next seven days.
We will cover various exercises and activities in the session for you to do throughout the week to continue to work with your energies. You can choose what  you would like to do moving forward to support each chakra. In addition, there are daily journal prompts for you to do first thing in the morning and last thing at night. This is your opportunity to note down your experiences and insights and explore the energy of each chakra in more depth. 
You can do the same activities all week or you can switch things up and do something different every day. This is YOUR journey, so choose what feels right to you. 
If you’re still unsure which ones to do, Thea is available via email for guidance throughout the week. 
In the first week, we will assess your current state of being to establish the baseline you’re working from. This is where you see where you are in this moment so you can compare your progress at the end of the course.  This week is also a useful introduction to establishing the routine you’re going to follow throughout the course. It will help you develop the habit of journaling morning and night and deciding when is good for you to do your chosen activities. You may like to do these first thing in the morning before or after journaling; at some point during the day when you have some time to yourself; or in the evening before you reflect on your day in the journal. 
The second week of the course is when we progress to working with the chakras, starting with the root chakra. We will spend a week connecting with the root chakra and working to free up any blocked or stagnant energy so it’s clear and the energy flowing before you move on to the sacral. After a week with the sacral chakra, we’ll then move up to the solar plexus and so on and so on. 
In the ninth and final week of the course you’ll reflect on your progress and look at the changes you’ve experienced over the past few weeks. You’ll check in with each chakra and notice how it feels now compared to when you started. You’ll be given exercises you can do moving forward to keep you connected to your personal flow of energy so you can identify and clear any blocks before they can cause any problems. 
When you’ve finished, you may feel there’s more work you need to do. Replays will be available to all attendees, so you can go back and focus on the chakra(s) you think need extra support or simply go back to the beginning and start the process all over again!
Everyone who signs up for the course will receive a free copy of the accompanying workbook so they have a personal record of their experience of the course. 

Neptune's Daughter Ltd

Holistic Therapy

Spiritual Healing

Energy Healing

Online Education

Join author Thea Faye in this nine week energy healing course. Clear your chakras, raise your vibration and enjoy holistic harmony and wellbeing! Each attendee will receive a FREE accompanying workbook. 

My Nine Week Energy Healing Journey - An online series of workshops

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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>

3000 Courses

LTE optimisation and capability

By Systems & Network Training

DP-203T00 Data Engineering on Microsoft Azure

By Nexus Human

Signalling systems for engineers

By Systems & Network Training

Completion Design

By EnergyEdge - Training for a Sustainable Energy Future

SAFe for Government: In-House Training

By IIL Europe Ltd

SAFe for Government

By IIL Europe Ltd

Supporting Microsoft Exchange

By Systems & Network Training

Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop

By IIL Europe Ltd

Cosmic Christ Series

By Katarina Heuser

SAFe for Government: Virtual In-House Training

By IIL Europe Ltd

Search By Location