<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><b data-stringify-type="bold" fr-original-style=" color: rgb(209, 210, 211);" style="color: rgb(209, 210, 211); box-sizing: border-box;" id="isPasted"><span fr-original-style="color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;">Welcome to Travel Writing Workshop: Crafting Engaging Narratives. In this course, you&#39;ll learn:</span></b></p><ol style="color: rgb(249, 249, 249); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(249, 249, 249);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Introduction to Travel Writing:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the rich history and evolution of travel writing.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the distinct characteristics that set travel writing apart.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Analyze exemplary travel narratives to identify key elements.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Building a Strong Foundation:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Develop a strong conceptual framework for your travel writing.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn effective research techniques to enhance the depth of your narratives.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the importance of establishing a unique voice and perspective.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Capturing the Essence of a Place:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Hone observational skills to vividly portray the atmosphere of a destination.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Dive into sensory details to create immersive and evocative descriptions.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Master the art of balancing factual information with poetic expression.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Developing Compelling Characters:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Identify and craft engaging characters within your travel stories.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore techniques to bring people to life on the page.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the role of characters in building a relatable and memorable narrative.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Crafting Engaging Narratives:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn narrative structures that enhance the flow of your travel stories.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Experiment with different storytelling techniques to maintain reader interest.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Develop a compelling arc that keeps readers hooked from start to finish.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Evoking Emotions in Readers:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore methods to connect with readers on an emotional level.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Utilize storytelling techniques that evoke empathy and resonance.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the power of personal reflection in engaging your audience.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Writing for Different Mediums:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Adapt your travel writing for various platforms, including blogs, articles, and social media.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the unique requirements and opportunities presented by each medium.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Develop a versatile writing style to suit diverse audiences and outlets.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Editing and Polishing Your Work:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn essential self-editing techniques to refine your travel narratives.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the importance of constructive feedback and revision.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the final steps in polishing your work for publication.</li></ul></li></ol>

John Academy

Unlock the secrets of captivating travel writing with our workshop! From building a strong foundation to evoking emotions, master the art of narrative crafting. Join now and transform your adventures into engaging stories. 

Travel Writing Workshop: Crafting Engaging Narratives

General Admission

Edinburgh

<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;">Try your hand a transforming a reclaimed china tea cup, saucer or plate into a gorgeous mosaic with Jacky Cox from Mossy Mosaic, and join us for afternoon tea!</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mosaic making fits in perfectly with our vision of a world where recycling, repurposing and upcycling is the norm. In this relaxed and gently paced workshop, Jacky from Mossy Mosaic will show you how to safely cut old china using wheeled nippers and how to grout your mosaic to create a hanging decoration. No previous experience is needed &ndash; but those who have attended the introductory workshop and who are familiar with cutting techniques may have time to produce a second (un-grouted) piece.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During this 3 hour session you will also be treated to afternoon tea when we can sit and chat about mosaic making &ndash; or anything else you fancy!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will be provided with all the materials needed, including a variety of bases such as hearts and flowers, to create your mosaic. If you would like to use a china cup or saucer you already have &ndash; perhaps an heirloom, or a special cup that is now broken - please bring it with you and we&rsquo;ll see what we can do!</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p 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;">More information&nbsp;</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh&rsquo;s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us.&nbsp;</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, caf&eacute;s, and restaurants, plus supermarkets, within a 5-10 minute walk.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">PLEASE NOTE: Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access. The workshop space is in our home which is&nbsp;</em><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">not</em></strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;nut free. Please let us know of any skin or food allergies before booking.</em></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;">Private workshop bookings</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. </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;">Age restrictions</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.</p>

Try your hand a transforming a reclaimed china tea cup, saucer or plate into a gorgeous mosaic with Jacky Cox from Mossy Mosaic, and join us for afternoon tea!
Mosaic making fits in perfectly with our vision of a world where recycling, repurposing and upcycling is the norm. In this relaxed and gently paced workshop, Jacky from Mossy Mosaic will show you how to safely cut old china using wheeled nippers and how to grout your mosaic to create a hanging decoration. No previous experience is needed – but those who have attended the introductory workshop and who are familiar with cutting techniques may have time to produce a second (un-grouted) piece.
During this 3 hour session you will also be treated to afternoon tea when we can sit and chat about mosaic making – or anything else you fancy!
You will be provided with all the materials needed, including a variety of bases such as hearts and flowers, to create your mosaic. If you would like to use a china cup or saucer you already have – perhaps an heirloom, or a special cup that is now broken - please bring it with you and we’ll see what we can do!



More information 
The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative.
Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. 
All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus supermarkets, within a 5-10 minute walk.
PLEASE NOTE: Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access. The workshop space is in our home which is not nut free. Please let us know of any skin or food allergies before booking.
Private workshop bookings
Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. 
Age restrictions
Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

The Arienas Collective

Arts & Crafts

Mosaic

Upcycling

Mosaic making with reclaimed china and afternoon tea with local maker Mossy Mosaic hosted exclusively at The Arienas Collective in Edinburgh City Centre

Mosaic making with reclaimed china run by Mossy Mosaic - including afternoon tea

Colchester

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">A fun creative workshop full of colour for any level and perfect gift!</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">Just bring your keepsake along and discover how you will use Barbola to create your piece of art?&nbsp;</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">Barbola which was a popular technique found in the 1930&#39;s. You may have seen these beautiful vintage pieces? This technique was often found on mirrors, trinket boxes, fire screens and cigarette holders. It was originally made from gesso in the shape of flowers, fruit and leaves.<br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;"><br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">On the day you will learn how to make your own flowers and leaves using moulds and how to make your piece have the charm of the 1930&#39;s!<br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;"><br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">We will need any dietary requirements as a luxury cream tea lunch with a pot of tea or fizz will be served.. whatever you prefer!<br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;"><br data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This one day event includes small items for you to work on and materials to create and paint your Barbola like acrylic paints.</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">You can also choose from the whole range of paint from Sophie James Decor.</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will need to bring</strong></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Optional bring your own keepsake like a shoe, picture frame, hard back book etc</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is included:&nbsp;</strong></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Luxury Cream Tea Lunch</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Where &amp; When:</strong></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">It takes places at our workshop at</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Tom&#39;s Farm Shop &amp; Garden Centre, Maldon Road, Tiptree, Essex, CO5 0QA</li><li fr-original-style="" style="box-sizing: border-box;">10AM to 3PM</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">There is ample parking.</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Terms &amp; Conditions:</strong></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">We have the right to cancel, change venue or date if we do not fill enough spaces. In this event we will give you 7 days notice with the option of rebooking or a full refund.</p>

ReVamp Boutique

Barbola Art Workshop

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class is intended for network engineers and network admins that are either using Google Cloud Platform or are planning to do so. The class is also for individuals that want to be exposed to software-defined networking solutions in the cloud.</p>Overview<p>Configure Google VPC networks, subnets, and routers<br />Control administrative access to VPC objects<br />Control network access to endpoints in VPCsInterconnect networks among GCP projects<br />Interconnect networks among GCP VPC networks and on-premises or other-cloud networks<br />Choose among GCP load balancer and proxy options and configure them<br />Use Cloud CDN to reduce latency and save money<br />Optimize network spend using Network TiersConfigure Cloud NAT or Private Google Access to provide instances without public IP addresses access to other services<br />Deploy networks declaratively using Cloud Deployment Manager or Terraform<br />Design networks to meet common customer requirements<br />Configure monitoring and logging to troubleshoot networks problems</p><p>Learn about the broad variety of networking options on Google Cloud. This course uses lectures, demos, and hands-on labs to help you explore and deploy Google Cloud networking technologies, including Virtual Private Cloud (VPC) networks, subnets, and firewalls; interconnection among networks; load balancing; Cloud DNS; Cloud CDN; and Cloud NAT. You'll also learn about common network design patterns and automated deployment using Cloud Deployment Manager or Terraform.</p></div><div id="course-pills-2"><h4>Google Cloud VPC Networking Fundamentals</h4><ul><li>Recall that networks belong to projects.</li><li>Explain the differences among default, auto, and custom networks.</li><li>Create networks and subnets.</li><li>Explain how IPv4 addresses are assigned to Compute Engine instances.</li><li>Publish domain names using Google Cloud DNS.</li><li>Create Compute Engine instances with IP aliases.</li><li>Create Compute Engine instances with multiple virtual network.</li></ul><h4>Controlling Access to VPC Networks</h4><ul><li>Outline how IAM policies affect VPC networks.</li><li>Control access to network resources using service accounts.</li><li>Control access to Compute Engine instances with tag-based firewall rules.</li></ul><h4>Sharing Networks across Projects</h4><ul><li>Outline the overall workflow for configuring Shared VPC.</li><li>Differentiate between the IAM roles that allow network resources to be managed.</li><li>Configure peering between unrelated VPC Networks.</li><li>Recall when to use Shared VPC and when to use VPC Network Peering.</li></ul><h4>Load Balancing</h4><ul><li>Recall the various load balancing services.</li><li>Configure Layer 7 HTTP(S) load balancing.</li><li>Whitelist and blacklist IP traffic with Cloud Armor.</li><li>Cache content with Cloud CDN.</li><li>Explain Layer 4 TCP or SSL proxy load balancing.</li><li>Explain regional network load balancing.</li><li>Configure internal load balancing.</li><li>Recall the choices for enabling IPv6 Internet connectivity for Google Cloud load balancers.</li><li>Determine which Google Cloud load balancer to use when.</li></ul><h4>Hybrid Connectivity</h4><ul><li>Recall the Google Cloud interconnect and peering services available to connect your infrastructure to Google Cloud.</li><li>Explain Dedicated Interconnect and Partner Interconnect.</li><li>Describe the workflow for configuring a Dedicated Interconnect.</li><li>Build a connection over a VPN with Cloud Router.</li><li>Determine which Google Cloud interconnect service to use when.</li><li>Explain Direct Peering and Partner Peering.</li><li>Determine which Google Cloud peering service to use when.</li></ul><h4>Networking Pricing and Billing</h4><ul><li>Recognize how networking features are charged for.</li><li>Use Network Service Tiers to optimize spend.</li><li>Determine which Network Service Tier to use when.</li><li>Recall that labels can be used to understand networking spend.</li></ul><h4>Network Design and Deployment</h4><ul><li>Explain common network design patterns.</li><li>Configure Private Google Access to allow access to certain Google Cloud services from VM instances with only internal IP addresses.</li><li>Configure Cloud NAT to provide your instances without public IP addresses access to the internet.</li><li>Automate the deployment of networks using Deployment Manager or Terraform.</li><li>Launch networking solutions using Cloud Marketplace.</li></ul><h4>Network Monitoring and Troubleshooting</h4><ul><li>Configure uptime checks, alerting policies and charts for your network services.</li><li>Use VPC Flow Logs to log and analyze network traffic behavior.</li></ul></div>

Nexus Human

Networking Skills

Network & Security

AWS Certified Cloud Practitioner

Google Cloud

IT Networking Fundamentals

Computer Networking

Networking in Google Cloud

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience.</p>Overview<p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to:<br />Advanced Query Techniques<br />Manipulating Table Data Using SQL's Data Manipulation Language (DML)<br />User-Defined Functions<br />Stored Procedures<br />Triggers</p><p>A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.</p></div><div id="course-pills-2"><h4>Advanced Query Techniques </h4><ul><li>Join inner outer (Left, Right, Full) </li><li>Subqueries </li><li>Simple </li><li>Correlated </li><li>Using the Exists Operator </li><li>Tips for Developing Complex Queries </li><li>Performing Set Operations </li><li>Aggregating Results Using Group by </li><li>Creating Temporary Tables</li></ul><h4>Manipulating Table Data Using SQL's Data Manipulation Language (DML)</h4><ul><li>Inserting Data into Tables </li><li>Updating Existing Data </li><li>Deleting Records </li><li>Truncating Tables </li><li>Implementing Data Integrity with Transactions </li><li>Beginning Explicit Transactions </li><li>Committing Transactions </li><li>Rolling Back Transactions</li></ul><h4>User-Defined Functions</h4><ul><li>Definition and Benefits of Use </li><li>CREATE FUNCTION</li><li>Syntax </li><li>RETURN Clause and the RETURNS Statement </li><li>Scalar vs. Table Functions </li><li>Comparison with Stored Procedures </li><li>Returning Scalar Values and Tables ALTER and DROP FUNCTION</li></ul><h4>Stored Procedures</h4><ul><li>Definition and Benefits of Use </li><li>CREATE PROCEDURE</li><li>Syntax </li><li>Variables and Parameters </li><li>Control of Program Flow </li><li>ALTER and DROP PROCEDURE</li><li>Implementation Differences </li></ul><h4>Triggers </h4><ul><li>Definition and Benefits of Use </li><li>Alternatives (e.g., Constraints) </li><li>CREATE TRIGGER</li><li>Syntax </li><li>Trigger Types </li><li>'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables </li><li>Event Handling and Trigger Execution </li><li>ALTER and DROP TRIGGER</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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>

AWS Certified Database

Manager Training

Trainers Course

Train the Trainer (TTT)

Teaching & Training

Advanced SQL Programming (TTSQL005)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Security architects<br />System designers<br />Network administrators<br />Operations engineers<br />Network managers, network or security technicians, and security engineers and managers responsible for web security<br />Cisco integrators and partners</p>Overview<p>After taking this course, you should be able to:<br />Describe Cisco WSA<br />Deploy proxy services<br />Utilize authentication<br />Describe decryption policies to control HTTPS traffic<br />Understand differentiated traffic access policies and identification profiles<br />Enforce acceptable use control settings<br />Defend against malware<br />Describe data security and data loss prevention<br />Perform administration and troubleshooting</p><p>This course shows you how to implement, use, and maintain CiscoÂ© Web Security Appliance (WSA), powered by Cisco Talos, to provide advanced protection for business email and control against web security threats. Through a combination of expert instruction and hands-on practice, you?ll learn how to deploy proxy services, use authentication, implement policies to control HTTPS traffic and access, implement use control settings and policies, use the solution?s anti-malware features, implement data security and data loss prevention, perform administration of Cisco WSA solution, and more.This course helps you prepare to take the exam, Securing the Web with Cisco Web Security Appliance (300-725 SWSA).</p></div><div id="course-pills-2"><h4>Describing Cisco WSA</h4><ul><li>Technology Use Case</li><li>Cisco WSA Solution</li><li>Cisco WSA Features</li><li>Cisco WSA Architecture</li><li>Proxy Service</li><li>Integrated Layer 4 Traffic Monitor</li><li>Data Loss Prevention</li><li>Cisco Cognitive Intelligence</li><li>Management Tools</li><li>Cisco Advanced Web Security Reporting (AWSR) and Third-Party Integration</li><li>Cisco Content Security Management Appliance (SMA)</li></ul><h4>Deploying Proxy Services</h4><ul><li>Explicit Forward Mode vs. Transparent Mode</li><li>Transparent Mode Traffic Redirection</li><li>Web Cache Control Protocol</li><li>Web Cache Communication Protocol (WCCP) Upstream and Downstream Flow</li><li>Proxy Bypass</li><li>Proxy Caching</li><li>Proxy Auto-Config (PAC) Files</li><li>FTP Proxy</li><li>Socket Secure (SOCKS) Proxy</li><li>Proxy Access Log and HTTP Headers</li><li>Customizing Error Notifications with End User Notification (EUN) Pages</li></ul><h4>Utilizing Authentication</h4><ul><li>Authentication Protocols</li><li>Authentication Realms</li><li>Tracking User Credentials</li><li>Explicit (Forward) and Transparent Proxy Mode</li><li>Bypassing Authentication with Problematic Agents</li><li>Reporting and Authentication</li><li>Re-Authentication</li><li>FTP Proxy Authentication</li><li>Troubleshooting Joining Domains and Test Authentication</li><li>Integration with Cisco Identity Services Engine (ISE)</li></ul><h4>Creating Decryption Policies to Control HTTPS Traffic</h4><ul><li>Transport Layer Security (TLS)/Secure Sockets Layer (SSL) Inspection Overview</li><li>Certificate Overview</li><li>Overview of HTTPS Decryption Policies</li><li>Activating HTTPS Proxy Function</li><li>Access Control List (ACL) Tags for HTTPS Inspection</li><li>Access Log Examples</li></ul><h4>Understanding Differentiated Traffic Access Policies and Identification Profiles</h4><ul><li>Overview of Access Policies</li><li>Access Policy Groups</li><li>Overview of Identification Profiles</li><li>Identification Profiles and Authentication</li><li>Access Policy and Identification Profiles Processing Order</li><li>Other Policy Types</li><li>Access Log Examples</li><li>ACL Decision Tags and Policy Groups</li><li>Enforcing Time-Based and Traffic Volume Acceptable Use Policies, and End User Notifications</li></ul><h4>Defending Against Malware</h4><ul><li>Web Reputation Filters</li><li>Anti-Malware Scanning</li><li>Scanning Outbound Traffic</li><li>Anti-Malware and Reputation in Policies</li><li>File Reputation Filtering and File Analysis</li><li>Cisco Advanced Malware Protection</li><li>File Reputation and Analysis Features</li><li>Integration with Cisco Cognitive Intelligence</li></ul><h4>Enforcing Acceptable Use Control Settings</h4><ul><li>Controlling Web Usage</li><li>URL Filtering</li><li>URL Category Solutions</li><li>Dynamic Content Analysis Engine</li><li>Web Application Visibility and Control</li><li>Enforcing Media Bandwidth Limits</li><li>Software as a Service (SaaS) Access Control</li><li>Filtering Adult Content</li></ul><h4>Data Security and Data Loss Prevention</h4><ul><li>Data Security</li><li>Cisco Data Security Solution</li><li>Data Security Policy Definitions</li><li>Data Security Logs</li></ul><h4>Performing Administration and Troubleshooting</h4><ul><li>Monitor the Cisco Web Security Appliance</li><li>Cisco WSA Reports</li><li>Monitoring System Activity Through Logs</li><li>System Administration Tasks</li><li>Troubleshooting</li><li>Command Line Interface</li></ul></div>

IT Security

Cyber Security

Security Awareness

AWS Certified Solutions Architect

CompTIA Security+

Information Security Awareness

Cisco Securing the Web with Cisco Web Security Applicance v3.0 (SWSA)

<div id="course-pills-1">Duration<p>4.5 Days</p><p>27 CPD hours</p>This course is intended for<p>This course is intended for individuals who have basic knowledge on cloud computing; on-premise system administrators; IT specialists, interested in AWS and Cloud Technologies.</p>Overview<p>Upon successful completion of this course, students will know how to design and deploy scalable, highly accessible and fault-tolerant systems in AWS.</p><p>In this course, students will learn the main 'Managed Service' offered by AWS; How to design and deploy scalable, highly accessible and fault-tolerant systems in AWS; How to choose the most appropriate AWS service.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Course overview</li><li>Exam Blue Print</li><li>Public clouds &amp; cloud economics</li><li>AWS Overview &amp; Whitepapers</li><li>Setting up AWS Account</li></ul><h4>Identity and Access Management (IAM)</h4><ul><li>Local users, groups &amp; roles</li><li>SAML providers</li><li>Policies</li><li>Cross Account Access</li><li>Best practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Simple Storage Service (S3) &amp; Glacier</h4><ul><li>Buckets</li><li>Objects</li><li>Lifecycle</li><li>Configurations and permissions</li><li>Custom bucket policies</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Virtual Private Cloud (VPC)</h4><ul><li>VPC</li><li>Internet gateway vs NAT Gateway</li><li>Elastic IPs</li><li>Subnets &amp; Routing tables</li><li>Security Groups &amp; Network Access Lists</li><li>VPC Peering &amp; Endpoints</li><li>Managed VPN Connections</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Elastic Compute Cloud (EC2)</h4><ul><li>Instances</li><li>Amazon Machine Images(AMIs)</li><li>Elastic Block Store (EBS)</li><li>Network &amp; Security</li><li>Load Balancers (ELB)</li><li>Auto Scaling Groups (ASG)</li><li>Instance Management</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Route 53</h4><ul><li>Hosted Zones</li><li>Health checks</li><li>Traffic flow</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Relational Database Service (RDS)</h4><ul><li>Engine types</li><li>Performance &amp; Resilience</li><li>Subnet groups</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>CloudWatch</h4><ul><li>Dashboard and Metrics</li><li>CloudWatch logs</li><li>CloudWatch rules</li><li>Best Practices &amp; Examples</li><li>Lab</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Other AWS Services Simple Overview</h4><ul><li>CloudFront</li><li>DynamoDB</li><li>Elasticache</li><li>Redshift</li><li>SQS</li><li>SWF</li><li>SNS</li><li>Elastic Transcoder</li><li>API Gateway</li><li>Kenesis</li><li>CloudFormation</li><li>Exam highlights</li><li>Sample questions</li></ul><h4>Multiple AWS Services exercise</h4><ul><li>Lab 1 - Architecting multi-tier environment</li><li>Lab 2 - Configure backup and monitoring</li></ul><h4>Practice Exam</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AWS Certified Solutions Architect - Associate 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 AWS Certified Solutions Architect - Associate 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>

AWS Certification

AWS Certified Developer

AWS Certified Solutions Architect - Associate

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is as follows:<br />Channel Partner<br />System Engineers<br />System Administrators<br />Architects<br />Security Professionals</p>Overview<p>Upon successful completion of this course, the student will gain the following knowledge:How to describe and position Cisco UmbrellaDiscuss Secure Internet Gateway and Ransomware ProtectionLearn about DNS &amp; IP layer enforcement &amp; Intelligent ProxyDescribe Command and control callback blockingDiscuss Threat IntelligenceCompare Umbrella PackagesUnderstand Roaming SecurityBasic understanding of Cisco Roaming ClientUnderstand how to use Cisco Umbrella Virtual ApplianceExplain the ease of Integrating Cisco Umbrella into Active DirectoryDiscuss Umbrella ReportingUnderstand Utilize Multi-Organization Tools</p><p>Cisco Umbrella? is a cloud security platform that provides the first line of defense against threats on the Internet. Being able to understand and position how Cisco Umbrella? works and what are the features is the key focus of this 2-day CiscoÂ© online IT class. Students who enter the course with a basic understanding of CiscoÂ© products and IT solutions will be able to describe the Cisco Umbrella?, understand Secure Internet Gateway and Ransomware Protection, discuss Threat Intelligence, use CiscoÂ© Roaming Client.</p></div><div id="course-pills-2"><h4>Cisco Umbrella- Security Solution</h4><ul><li>Discuss Security Internet Gateway</li><li>Explain Ransomware Protection</li><li>DNS &amp; IP layer enforcement</li><li>Intelligent Proxy</li><li>Command &amp; control callback blocking</li><li>Threat Intelligence</li><li>Umbrella Packages</li></ul><h4>Implementing Cisco Umbrella</h4><ul><li>Overview of Cisco Umbrella</li><li>How do you Protect your network</li><li>Review how to Point your DNS to Cisco Umbrella</li><li>What are the custom policies?</li><li>Discuss Intelligent Proxy</li><li>Umbrella Policy Tester</li><li>Policy Precedence</li></ul><h4>Roaming Client</h4><ul><li>Introduction to Umbrella Roaming Client</li><li>Prerequisites</li><li>Downloading and Installing</li><li>Adding IP Layer Enforcement</li><li>Status, States, and Functionality</li><li>Virtual Appliances</li><li>Internal Domains</li></ul><h4>Umbrella Roaming Security</h4><ul><li>AnyConnect: Cisco Umbrella Roaming Security Client Administrator Guide</li><li>Cisco Umbrella Dashboard at a glance</li><li>Cisco Certificate Import</li></ul><h4>Virtual Appliance Setup Guide</h4><ul><li>Discuss Deployment Guidelines</li><li>How to Deploy the VAs</li><li>Review via VMware</li><li>Review via Hyper-V</li><li>Understand Your VAs</li><li>Local DNS Forwarding</li><li>Overview of DNS</li><li>Explain Sites and Internal Networks</li><li>Sizing</li></ul><h4>Active Directory</h4><ul><li>Overview of Active Directory</li><li>Discuss Up DNS Forwarding with your VAs</li><li>Active Directory Environment</li><li>Route DNS Traffic</li><li>Communication Flow</li><li>Multiple Active Directory and Umbrella Sites</li></ul><h4>Reporting Overview</h4><ul><li>Reporting Basics</li><li>Understanding Security Categories</li><li>Scheduled Reports: Overview</li><li>Security Overview Report</li><li>Activity Search Report</li><li>Security Activity Report</li><li>Destinations Report</li><li>Identities Report</li><li>Cloud Services Report</li><li>Admin Audit Log Report</li></ul><h4>Umbrella Multi-Org Overview</h4><ul><li>Cisco Umbrella Multi-Org Overview</li><li>Centralized Settings</li><li>Centralized Reports: Service Status</li><li>Centralized Reports: Cloud Services</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Administering and Positioning Cisco Umbrella Operations (ADMUMB) 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 Cisco Administering and Positioning Cisco Umbrella Operations (ADMUMB) 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>

Cisco Certified Network Associate (CCNA)

Cisco Certified Network Professional certification (CCNP)

IT Certifications

Cisco Certified Internetwork Expert (CCIE)

Cisco Administering and Positioning Cisco Umbrella Operations (ADMUMB)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is geared for attendees with Intermediate IT skills who wish to learn Computer Vision with tensor flow 2</p>Overview<p>This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course. Working in a hands-on learning environment, led by our Computer Vision expert instructor, students will learn about and explore how to<br />Build, train, and serve your own deep neural networks with TensorFlow 2 and Keras<br />Apply modern solutions to a wide range of applications such as object detection and video analysis<br />Run your models on mobile devices and web pages and improve their performance.<br />Create your own neural networks from scratch<br />Classify images with modern architectures including Inception and ResNet<br />Detect and segment objects in images with YOLO, Mask R-CNN, and U-Net<br />Tackle problems faced when developing self-driving cars and facial emotion recognition systems<br />Boost your application's performance with transfer learning, GANs, and domain adaptation<br />Use recurrent neural networks (RNNs) for video analysis<br />Optimize and deploy your networks on mobile devices and in the browser</p><p>Computer vision solutions are becoming increasingly common, making their way into fields such as health, automobile, social media, and robotics. Hands-On Computervision with TensorFlow 2 is a hands-on course that thoroughly explores TensorFlow 2, the brandnew version of Google's open source framework for machine learning. You will understand how to benefit from using convolutional neural networks (CNNs) for visual tasks. This course begins with the fundamentals of computer vision and deep learning, teaching you how to build a neural network from scratch. You will discover the features that have made TensorFlow the most widely used AI library, along with its intuitive Keras interface. You'll then move on to building, training, and deploying CNNs efficiently. Complete with concrete code examples, the course demonstrates how to classify images with modern solutions, such as Inception and ResNet, and extract specific content using You Only Look Once (YOLO), Mask R-CNN, and U-Net. You will also build generative dversarial networks (GANs) and variational autoencoders (VAEs) to create and edit images, and long short-term memory networks (LSTMs) to analyze videos. In the process, you will acquire advanced insights into transfer learning, data augmentation, domain adaptation, and mobile and web deployment, among other key concepts</p></div><div id="course-pills-2"><h4>Computer Vision and Neural Networks</h4><ul><li>Computer Vision and Neural Networks </li><li>Technical requirements </li><li>Computer vision in the wild </li><li>A brief history of computer vision </li><li>Getting started with neural networks </li></ul><h4>TensorFlow Basics and Training a Model</h4><ul><li>TensorFlow Basics and Training a Model </li><li>Technical requirements </li><li>Getting started with TensorFlow 2 and Keras </li><li>TensorFlow 2 and Keras in detail </li><li>The TensorFlow ecosystem</li></ul><h4>Modern Neural Networks</h4><ul><li>Modern Neural Networks </li><li>Technical requirements </li><li>Discovering convolutional neural networks </li><li>Refining the training process </li></ul><h4>Influential Classification Tools</h4><ul><li>Influential Classification Tools </li><li>Technical requirements </li><li>Understanding advanced CNN architectures </li><li>Leveraging transfer learning </li></ul><h4>Object Detection Models</h4><ul><li>Object Detection Models </li><li>Technical requirements </li><li>Introducing object detection </li><li>A fast object detection algorithm YOLO </li><li>Faster R-CNN ? a powerful object detection model</li></ul><h4>Enhancing and Segmenting Images</h4><ul><li>Enhancing and Segmenting Images </li><li>Technical requirements </li><li>Transforming images with encoders-decoders </li><li>Understanding semantic segmentation </li></ul><h4>Training on Complex and Scarce Datasets</h4><ul><li>Training on Complex and Scarce Datasets </li><li>Technical requirements </li><li>Efficient data serving </li><li>How to deal with data scarcity</li></ul><h4>Video and Recurrent Neural Networks</h4><ul><li>Video and Recurrent Neural Networks </li><li>Technical requirements </li><li>Introducing RNNs </li><li>Classifying videos Optimizing Models and Deploying on Mobile Devices </li><li>Optimizing Models and Deploying on Mobile Devices Technical requirements </li><li>Optimizing computational and disk footprints </li><li>On-device machine learning </li><li>Example app ? recognizing facial expressions</li></ul></div>

Computer Vision

Learning To Learn

TensorFlow

Deep Learning

Deep Learning with Vision Systems (TTAI3040)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is geared for attendees with Intermediate IT skills who wish to learn Computer Vision with tensor flow 2</p>Overview<p>This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course.  Working in a hands-on learning environment, led by our Computer Vision expert instructor, students will learn about and explore how to<br />Build, train, and serve your own deep neural networks with TensorFlow 2 and Keras<br />Apply modern solutions to a wide range of applications such as object detection and video analysis<br />Run your models on mobile devices and web pages and improve their performance.<br />Create your own neural networks from scratch<br />Classify images with modern architectures including Inception and ResNet<br />Detect and segment objects in images with YOLO, Mask R-CNN, and U-Net<br />Tackle problems faced when developing self-driving cars and facial emotion recognition systems<br />Boost your application's performance with transfer learning, GANs, and domain adaptation<br />Use recurrent neural networks (RNNs) for video analysis<br />Optimize and deploy your networks on mobile devices and in the browser</p><p>Computer vision solutions are becoming increasingly common, making their way into fields such as health, automobile, social media, and robotics. Hands-On Computervision with TensorFlow 2 is a hands-on course that thoroughly explores TensorFlow 2, the brand-new version of Google's open source framework for machine learning. You will understand how to benefit from using convolutional neural networks (CNNs) for visual tasks.<br />This course begins with the fundamentals of computer vision and deep learning, teaching you how to build a neural network from scratch. You will discover the features that have made TensorFlow the most widely used AI library, along with its intuitive Keras interface. You'll then move on to building, training, and deploying CNNs efficiently. Complete with concrete code examples, the course demonstrates how to classify images with modern solutions, such as Inception and ResNet, and extract specific content using You Only Look Once (YOLO), Mask R-CNN, and U-Net. You will also build generative adversarial networks (GANs) and variational autoencoders (VAEs) to create and edit images, and long short-term memory networks (LSTMs) to analyze videos. In the process, you will acquire advanced insights into transfer learning, data augmentation, domain adaptation, and mobile and web deployment, among other key concepts.</p></div><div id="course-pills-2"><h4>Computer Vision and Neural Networks </h4><ul><li>Computer Vision and Neural Networks </li><li>Technical requirements </li><li>Computer vision in the wild </li><li>A brief history of computer vision </li><li>Getting started with neural networks </li></ul><h4>TensorFlow Basics and Training a Model </h4><ul><li>TensorFlow Basics and Training a Model </li><li>Technical requirements </li><li>Getting started with TensorFlow 2 and Keras </li><li>TensorFlow 2 and Keras in detail </li><li>The TensorFlow ecosystem </li></ul><h4>Modern Neural Networks </h4><ul><li>Modern Neural Networks </li><li>Technical requirements </li><li>Discovering convolutional neural networks </li><li>Refining the training process </li></ul><h4>Influential Classification Tools </h4><ul><li>Influential Classification Tools </li><li>Technical requirements </li><li>Understanding advanced CNN architectures </li><li>Leveraging transfer learning </li></ul><h4>Object Detection Models </h4><ul><li>Object Detection Models </li><li>Technical requirements </li><li>Introducing object detection </li><li>A fast object detection algorithm ? YOLO </li><li>Faster R-CNN ? a powerful object detection model </li></ul><h4>Enhancing and Segmenting Images </h4><ul><li>Enhancing and Segmenting Images </li><li>Technical requirements </li><li>Transforming images with encoders-decoders </li><li>Understanding semantic segmentation </li></ul><h4>Training on Complex and Scarce Datasets </h4><ul><li>Training on Complex and Scarce Datasets </li><li>Technical requirements </li><li>Efficient data serving </li><li>How to deal with data scarcity </li></ul><h4>Video and Recurrent Neural Networks </h4><ul><li>Video and Recurrent Neural Networks </li><li>Technical requirements </li><li>Introducing RNNs </li><li>Classifying videos </li></ul><h4>Optimizing Models and Deploying on Mobile Devices </h4><ul><li>Optimizing Models and Deploying on Mobile Devices </li><li>Technical requirements </li><li>Optimizing computational and disk footprints </li><li>On-device machine learning </li><li>Example app ? recognizing facial expressions </li></ul></div>

Computing Skills

Hands-On Computervision with TensorFlow 2 (TTML6900)



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

Reading

Nottingham

Dickson Training Ltd

ILM Level 3 Award in Leadership and Management

Online Course

Classroom Course

<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

<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

Travel Writing Workshop: Crafting Engaging Narratives

By John Academy

Mosaic making with reclaimed china run by Mossy Mosaic - including afternoon tea

By The Arienas Collective

Barbola Art Workshop

By ReVamp Boutique

Networking in Google Cloud

By Nexus Human

Advanced SQL Programming (TTSQL005)

By Nexus Human

Cisco Securing the Web with Cisco Web Security Applicance v3.0 (SWSA)

By Nexus Human

AWS Certified Solutions Architect - Associate

By Nexus Human

Cisco Administering and Positioning Cisco Umbrella Operations (ADMUMB)

By Nexus Human

Deep Learning with Vision Systems (TTAI3040)

By Nexus Human

Hands-On Computervision with TensorFlow 2 (TTML6900)

By Nexus Human

Search By Location