<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for:<br />Solutions Architects who are new to designing and building cloud architectures<br />Data Center Architects who are migrating from on-premises environment to cloud architectures<br />Other IT/cloud roles who want to understand how to design and build cloud architectures</p>Overview<p>Make architectural decisions based on AWS architectural principles and best practices<br />Use AWS services to make your infrastructure scalable, reliable, and highly available<br />Use AWS Managed Services to enable greater flexibility and resiliency in an infrastructure<br />Make an AWS-based infrastructure more efficient to increase performance and reduce costs<br />Use the Well Architected Framework to improve architectures with AWS solutions</p><p>This course combines Architecting on AWS and Advanced Architecting on AWS to offer a comprehensive, immersive course in cloud architecture. It covers all aspects of how to architect for the cloud over 5 days. You will learn how to design cloud architectures, starting small and working to large-scale enterprise level designs?and everything in between. Starting with the Well Architected Framework, you will be immersed in AWS services like compute, storage, database, networking, security, monitoring, automation, optimization, benefits of de-coupling applications and serverless, building for resilience, and understanding costs. Using hands-on labs, you will apply knowledge from lectures to gain skills.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>The Well-Architected Framework</li><li>Networking with AWS</li><li>Core AWS concepts, knowledge, and services, including designing your environment and making your environment highly available</li><li>Event-driven scaling</li><li>Automation</li><li>Decoupling</li><li>Building for resilience</li><li>Optimization</li><li>Serverless designs</li><li>Data security</li><li>Advance networking topics</li><li>Migration</li><li>How to grow your architecture from small to extremely large</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Architecting on AWS Accelerator 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 Architecting on AWS Accelerator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

AWS Amplify

AWS Certified Developer

Cloud Architecture

AWS Certified Cloud Practitioner

Trainers Course

AWS Certified Solutions Architect

Architecting on AWS Accelerator

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>Overview<p>Topics Include:Installation of a multi-node Kubernetes cluster using kubeadm, and how to grow a cluster.Choosing and implementing cluster networking.Various methods of application lifecycle management, including scaling, updates and roll-backs.Configuring security both for the cluster as well as containers.Managing storage available to containers.Learn monitoring, logging and troubleshooting of containers and the cluster.Configure scheduling and affinity of container deployments.Use Helm and Charts to automate application deployment.Understand Federation for fault-tolerance and higher availability.</p><p>In this vendor agnostic course, you'll learn the installation, configuration and administration of a production-grade Kubernetes cluster.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Linux Foundation</li><li>Linux Foundation Training</li><li>Linux Foundation Certifications</li><li>Laboratory Exercises, Solutions and Resources</li><li>Distribution Details</li><li>Labs</li></ul><h4>Basics of Kubernetes</h4><ul><li>Define Kubernetes</li><li>Cluster Structure</li><li>Adoption</li><li>Project Governance and CNCF</li><li>Labs</li></ul><h4>Installation and Configuration</h4><ul><li>Getting Started With Kubernetes</li><li>Minikube</li><li>kubeadm</li><li>More Installation Tools</li><li>Labs</li></ul><h4>Kubernetes Architecture</h4><ul><li>Kubernetes Architecture</li><li>Networking</li><li>Other Cluster Systems</li><li>Labs</li></ul><h4>APIs and Access</h4><ul><li>API Access</li><li>Annotations</li><li>Working with A Simple Pod</li><li>kubectl and API</li><li>Swagger and OpenAPI</li><li>Labs</li></ul><h4>API Objects</h4><ul><li>API Objects</li><li>The v1 Group</li><li>API Resources</li><li>RBAC APIs</li><li>Labs</li></ul><h4>Managing State With Deployments</h4><ul><li>Deployment Overview</li><li>Managing Deployment States</li><li>Deployments and Replica Sets</li><li>DaemonSets</li><li>Labels</li><li>Labs</li></ul><h4>Services</h4><ul><li>Overview</li><li>Accessing Services</li><li>DNS</li><li>Labs</li></ul><h4>Volumes and Data</h4><ul><li>Volumes Overview</li><li>Volumes</li><li>Persistent Volumes</li><li>Passing Data To Pods</li><li>ConfigMaps</li><li>Labs</li></ul><h4>Ingress</h4><ul><li>Overview</li><li>Ingress Controller</li><li>Ingress Rules</li><li>Labs</li></ul><h4>Scheduling</h4><ul><li>Overview</li><li>Scheduler Settings</li><li>Policies</li><li>Affinity Rules</li><li>Taints and Tolerations</li><li>Labs</li></ul><h4>Logging and Troubleshooting</h4><ul><li>Overview</li><li>Troubleshooting Flow</li><li>Basic Start Sequence</li><li>Monitoring</li><li>Logging</li><li>Troubleshooting Resources</li><li>Labs</li></ul><h4>Custom Resource Definition</h4><ul><li>Overview</li><li>Custom Resource Definitions</li><li>Aggregated APIs</li><li>Labs</li></ul><h4>Kubernetes Federation</h4><ul><li>Overview</li><li>Federated Resources</li><li>Labs</li></ul><h4>Helm</h4><ul><li>Overview</li><li>Helm</li><li>Using Helm</li><li>Labs</li></ul><h4>Security</h4><ul><li>Overview</li><li>Accessing the API</li><li>Authentication and Authorization</li><li>Admission Controller</li><li>Pod Policies</li><li>Network Policies</li><li>Labs</li></ul></div>

AWS Certification

Kubernetes

Linux Administration

Kubernetes Administration

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>If you have worked in C++ but want to learn how to make the most of this language, especially for large projects, this course is for you.</p>Overview<p>By the end of this course, you'll have developed programming skills that will set you apart from other C++ programmers. After completing this course, you will be able to:<br />Delve into the anatomy and workflow of C++<br />Study the pros and cons of different approaches to coding in C++<br />Test, run, and debug your programs<br />Link object files as a dynamic library<br />Use templates, SFINAE, constexpr if expressions and variadic templates<br />Apply best practice to resource management</p><p>This course begins with advanced C++ concepts by helping you decipher the sophisticated C++ type system and understand how various stages of compilation convert source code to object code. You'll then learn how to recognize the tools that need to be used in order to control the flow of execution, capture data, and pass data around. By creating small models, you'll even discover how to use advanced lambdas and captures and express common API design patterns in C++. As you cover later lessons, you'll explore ways to optimize your code by learning about memory alignment, cache access, and the time a program takes to run. The concluding lesson will help you to maximize performance by understanding modern CPU branch prediction and how to make your code cache-friendly.</p></div><div id="course-pills-2"><h4>Anatomy of Portable C++ Software</h4><ul><li>Managing C++ Projects</li><li>Writing Readable Code</li></ul><h4>No Ducks Allowed ? Types and Deduction</h4><ul><li>C++ Types</li><li>Creating User Types</li><li>Structuring our Code</li></ul><h4>No Ducks Allowed ? Templates and Deduction</h4><ul><li>Inheritance, Polymorphism, and Interfaces</li><li>Templates ? Generic Programming</li><li>Type Aliases ? typedef and using</li><li>Class Templates</li></ul><h4>No Leaks Allowed ? Exceptions and Resources</h4><ul><li>Exceptions in C++</li><li>RAII and the STL</li><li>Move Semantics</li><li>Name Lookup</li><li>Caveat Emptor</li></ul><h4>Separation of Concerns ? Software Architecture, Functions, and Variadic Templates </h4><ul><li>Function Objects and Lambda Expressions</li><li>Variadic Templates</li></ul><h4>The Philosophers' Dinner ? Threads and Concurrency </h4><ul><li>Synchronous, Asynchronous, and Threaded Execution</li><li>Review Synchronization, Data Hazards, and Race Conditions</li><li>Future, Promises, and Async</li></ul><h4>Streams and I/O</h4><ul><li>File I/O Implementation Classes</li><li>String I/O Implementation</li><li>I/O Manipulators</li><li>Making Additional Streams</li><li>Using Macros</li></ul><h4>Everybody Falls, It's How You Get Back Up ? Testing and Debugging </h4><ul><li>Assertions</li><li>Unit Testing and Mock Testing</li><li>Understanding Exception Handling</li><li>Breakpoints, Watchpoints, and Data Visualization</li></ul><h4>Need for Speed ? Performance and Optimization</h4><ul><li>Performance Measurement</li><li>Runtime Profiling</li><li>Optimization Strategies</li><li>Cache Friendly Code</li></ul></div>

Computing Skills

Programming Fundamentals

Computer Programming

C (programming language)

Advanced C Plus Plus

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Server administrators<br />Network engineers<br />Systems engineers<br />Consulting systems engineers<br />Technical solutions architects<br />Network administrators<br />Storage administrators<br />Network managers<br />Sales engineers<br />Cisco integrators and partners</p>Overview<p>After taking this course, you should be able to:<br />Describe Cisco UCS server hardware<br />Describe Cisco UCS connectivity<br />Describe the Cisco HyperFlex Data Platform, its data writing and reading processes, and data optimization<br />Describe and configure Cisco UCS service profiles<br />Describe and configure Cisco UCS service profile templates<br />Describe and implement iSCSI on Cisco UCS<br />Describe and implement Cisco UCS firmware updates<br />Describe and implement Cisco UCS backups</p><p>This introductory course shows you how to deploy, secure, operate and maintain the Cisco Unified Computing system (Cisco UCS) B-Series blade server, Cisco UCS C-Series and S-Series rack servers, and Cisco HyperFlex product family, for use in data centers.</p></div><div id="course-pills-2"><h4>Describing Cisco UCS Server Hardware</h4><ul><li>Cisco UCS B-Series Blade Servers</li><li>Cisco UCS C-Series Rack Servers </li><li>Cisco UCS S-Series Rack Servers </li><li>Cisco Virtual Interface Cards </li><li>Hyperconvergence Overview  </li><li>Cisco HyperFlex HX-Series Servers </li></ul><h4>Describing Cisco UCS Connectivity</h4><ul><li>Cisco UCS Fabric Interconnect</li><li>Cisco UCS B-Series Connectivity</li><li>Cisco UCS C-Series Connectivity</li><li>Cisco UCS S-Series Connectivity</li><li>Cisco HyperFlex Connectivity Architecture</li><li>Cisco HyperFlex Edge Connectivity</li><li>Ethernet End-Host Mode Compared to Switching Mode</li><li>Cisco UCS Fabric Interconnect Uplink Pinning</li><li>Cisco UCS C-Series Integration</li></ul><h4>Describing the Cisco HyperFlex HX Data Platform</h4><ul><li>Cisco HyperFlex HX Data Platform Software</li><li>Writing Data to Cisco HyperFlex HX Data Platform</li><li>Reading Data from Cisco HyperFlex HX Data Platform </li><li>Data Optimization in Cisco HyperFlex HX Data Platform</li></ul><h4>Configuring Cisco UCS Service Profiles</h4><ul><li>Portability Issue with Nonabstracted Identities</li><li>Cisco UCS Service Profile</li><li>Identity Pools</li><li>Server Pools</li><li>IP Pools</li></ul><h4>Configuring Cisco UCS Service Profile Templates</h4><ul><li>Service Profile Templates</li></ul><h4>Implementing iSCSI on Cisco UCS</h4><ul><li>iSCSI Addressing</li><li>Evolution of SCSI from DAS to SAN</li><li>iSCSI Multipathing</li></ul><h4>Implementing Cisco UCS Firmware Updates</h4><ul><li>Update Cisco UCS C-Series Server Firmware</li><li>Download Tasks for the Infrastructure Image</li><li>Download Tasks for Cisco UCS B-Series Firmware Packages</li><li>Best Practices for Updating Firmware in Cisco UCS Manager</li><li>Firmware Upgrades Using Auto Install</li><li>Capability Catalog Updates</li><li>Host Firmware Packages</li><li>Driver Updates for Operating Systems and Hypervisors</li></ul><h4>Implementing Cisco UCS Backups</h4><ul><li>Compare Backup Options in Cisco UCS Manager</li><li>Compare Two Import Types</li><li>Policy Backup</li></ul></div>

Computer Systems

Service Design Courses (SDC)

IT Certifications

Cisco Certified Internetwork Expert (CCIE)

IT Networking Fundamentals

Computer Networking

Cisco Introducing Cisco Unified Computing System v1.0 (DCIUCS)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for existing Microsoft SharePoint site owners who will create and manage sites, add advanced features, implement and manage records management, and create and administer workflows.</p>Overview<p>Upon successful completion of this course, existing SharePoint site owners will be able to take on administrative responsibility for implementing and managing advanced features based on business requirements. Students will:?Configure site settings.?Integrate external applications and data.?Configure site metadata.?Manage archiving and compliance.?Implement workflows.</p><p>In this course, students will learn how to create, configure, and manage a SharePoint site so that your team or organization can collaborate effectively, manage the flow of digital information, automate business processes, and meet records management needs.<br /></p></div><div id="course-pills-2"><h4>Configuring Site Settings</h4><ul><li>Configure Site Settings to Meet Team Requirements</li><li>Configure Site Search</li><li>Organize the Site and Configure Navigation</li><li>Configure Site Auditing</li></ul><h4>Integrating External Applications and Data</h4><ul><li>Add an RSS Feed to Your Site</li><li>Enable Email Connectivity for a Library</li></ul><h4>Configuring Site Metadata</h4><ul><li>Create a Custom Content Type</li><li>Add Site Columns to Content Types</li><li>Create and Configure Document Sets</li></ul><h4>Managing Archiving and Compliance</h4><ul><li>Manage Site Closure and Deletion</li><li>Configure In-place Records Management</li><li>Manage Records Using the Records Center</li><li>Manage Content with the Content Organizer</li><li>Configure Information Management Policies</li></ul><h4>Implementing Workflows</h4><ul><li>Plan a Workflow</li><li>Create and Publish a Workflow</li><li>Test Workflows</li><li>Design and Implement Advanced Workflows</li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration 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 Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration 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>

Online Course Creation

Microsoft Sharepoint

Site Management Safety Training Scheme (SMSTS)

Microsoft AZ-104

SharePoint

Microsoft AZ-303

Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration

<div id="course-pills-1">Duration<p>0.5 Days</p><p>3 CPD hours</p>This course is intended for<p>This course is designed for business leaders and decision makers, including C-level executives, project managers, HR leaders, Marketing and Sales leaders, and technical sales consultants, who want to increase their knowledge of and familiarity with concepts surrounding data science. Other individuals who want to know more about basic data science concepts are also candidates for this course.<br />This course is also designed to assist learners in preparing for the CertNexus DSBIZâ¢ (Exam DSZ-110) credential.</p>Overview<p>In this course, you will identify how data science supports business decisions. You will:<br />Explain the fundamentals of data science<br />Describe common implementations of data science.<br />Identify the impact data science can have on a business</p><p>The ability to identify and respond to changing trends is a hallmark of a successful business. Whether those trends are related to customers and sales or to regulatory and industry standards, businesses are wise to keep track of the variables that can affect the bottom line. In today's business landscape, data comes from numerous sources and in diverse forms. By leveraging data science concepts and technologies, businesses can mold all of that raw data into information that facilitates decisions to improve and expand the success of the business.</p></div><div id="course-pills-2"><h4>Data Science Fundamentals</h4><ul><li>What is Data Science?</li><li>Types of Data</li><li>Data Science Roles</li></ul><h4>Data Science Implementation</h4><ul><li>The Data Science Lifecycle</li><li>Data Acquisition and Preparation</li><li>Data Modeling and Visualization</li></ul><h4>The Impact of Data Science</h4><ul><li>Benefits of Data Science</li><li>Challenges of Data Science</li><li>Business Use Cases for Data Science</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CertNexus Data Science for Business Professionals (DSBIZ) 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 CertNexus Data Science for Business Professionals (DSBIZ) 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>

Data Science

Diploma for School Business Leaders (DSBM)

Diploma in Management Studies (DMS)

Data Skills

CertNexus Data Science for Business Professionals (DSBIZ)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is most valuable for individuals who have been given responsibilities to create or maintain a website. It will also be valuable for new web designers, web developers, and graphic artists who want to extend their skills in creating complete websites. Learning how to use Dreamweaver CC will enable the practitioner to create web pages and sites in the most efficient manner. This course can also be used to help prepare students to take the Adobe Certified Associate (ACA) exam.</p>Overview<p>Upon successful completion of this course, you will be able to develop interactive and engaging websites that are compatible with multiple display devices. You will: ?Identify website requirements.?Create layouts.?Format web pages.?Create forms.?Integrate media files with Dreamweaver.?Manage website files.</p><p>In this course, you will use Adobe Dreamweaver CC to create fluid CSS layouts, implement mobile integration techniques, and share files over a server to work in a collaborative manner.</p></div><div id="course-pills-2"><h4>Identifying Website Requirements</h4><ul><li>Examine Website Design Considerations</li><li>Examine Website Performance Parameters </li></ul><h4>Creating Layouts</h4><ul><li>Create a Fluid Layout</li><li>Manage a Layout by Using CSS</li></ul><h4>Formatting Web Pages</h4><ul><li>Format Content in Code View</li><li>Apply Advanced CSS Tools</li><li>Add Behaviors</li><li>Manage Links and Files </li></ul><h4>Creating Forms</h4><ul><li>Add a Form Container and Elements</li><li>Validate a Form </li><li></li></ul><h4>Integrating Media Files with Dreamweaver</h4><ul><li>Integrate Photoshop Files in Dreamweaver</li><li>Insert Video, Audio, and Mobile Files</li><li>Implement PhoneGap Integration</li><li></li></ul><h4>Managing Website Files</h4><ul><li>Preview and Test a Website</li><li>Share Website Files with Other Users</li><li>Synchronize Website Files </li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Adobe Dreamweaver CC - Part 2 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 Adobe Dreamweaver CC - Part 2 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>

Adobe InDesign

Dreamweaver

Web Designer

Web Development

Web Design

Adobe Dreamweaver CC - Part 2

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This class is designed for experienced BizTalk Server Developers who have at least one year of hands-on experience developing BizTalk Server applications.</p>Overview<p>In this 5-day course, you will learn how to apply best practices and design patterns to build smarter BizTalk Server applications. Furthermore, this course provides extensive coverage of BizTalk Server's extensibility, including such topics as: custom functoids, custom pipeline components, and invoking external .NET methods.</p><p>This course is designed specifically for experienced BizTalk Server developers and focuses on best practices &amp; pattern-based design while pulling back the curtain on some of BizTalk Server's eccentricities.</p></div><div id="course-pills-2"><h4>Review of BizTalk Server Fundamentals</h4><ul><li>The BizTalk Server Architecture</li></ul><h4>Inner Workings of the Messaging Engine</h4><ul><li>Messaging Engine Deep Dive</li><li>Two-way Messaging Without Orchestrations</li><li></li></ul><h4>Designing and Testing Schemas</h4><ul><li>Schema Design</li><li>Enabling Unit Testing for BizTalk Projects</li><li></li></ul><h4>Data Translation and Transformation</h4><ul><li>Custom Data Transformation</li><li>Creating Custom Pipeline Components</li><li></li></ul><h4>Working with Message Interchanges</h4><ul><li>Debatching Message Interchanges</li><li></li></ul><h4>Advanced Concepts of WCF Adapters</h4><ul><li>Connecting to External Systems</li><li>Using WCF LOB Adapters in BizTalk Server</li><li></li></ul><h4>Publishing and Consuming WCF and RESTful Services</h4><ul><li>Overview of Service Integration Using WCF</li><li>Implementing WCF Services</li><li>Preprocessing Messages with IIS Modules</li><li>Consuming Services</li><li></li></ul><h4>Advanced Orchestration Communication Patterns</h4><ul><li>Orchestration Engine Deep Dive</li><li>Splitting and Aggregating Messages using Orchestrations</li><li>Orchestration Communication</li><li></li></ul><h4>Bridging the Synchronous/Asynchronous Gap Across Multiple Channels</h4><ul><li>Correlating Messages in Orchestration Instances</li><li>Building Convoy Orchestrations</li><li></li></ul><h4>Handling Orchestration Faults and Exceptions</h4><ul><li>Exception Handling in Orchestrations</li><li></li></ul><h4>Implementing Transactions and Compensation</h4><ul><li>Creating Transactional Processes</li><li></li></ul><h4>Designing Custom Tracking Models for BizTalk Applications</h4><ul><li>Introduction to Business Activity Monitoring</li><li>Enabling Business Activity Monitoring</li><li>Extending BAM Beyond BizTalk</li><li></li></ul><h4>Building Declarative Logic Using the Business Rules Engine</h4><ul><li>Concepts of Declarative Logic</li><li>Fundamentals of BizTalk BRE</li><li>Integrating Policies with BizTalk</li><li></li></ul><h4>Advanced Concepts of the Business Rules Engine</h4><ul><li>Advanced Business Rule Concepts</li><li>Working with Advanced Facts</li><li></li></ul><h4>Integrating Across Business Boundaries Using Parties, Roles, and EDI</h4><ul><li>Port Binding Option Review</li><li>Role-Based Integration</li><li>What is EDI?</li><li>Enabling EDI-Based Messaging</li><li></li></ul></div>

Learning & Development

Design & Technology Courses (DT)

Teaching & Training

BizTalk Server 2021 Developer Deep Dive

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Built for IT Professionals with extensive networking and Citrix ADC experience. This course is built for IT Professionals who are responsible for defining the overall structure or architecture of a Citrix networking environment. This course encompasses advanced Citrix networking configurations and leading Citrix design principles.</p>Overview<p>How to identify and prioritize business drivers, constraints, and requirements using the Citrix<br />Consulting methodology<br />Assess environment requirements and learn to apply leading design principles to address them in a multi-site Citrix ADC deployment<br />Apply advanced authentication and load balancing principles</p><p>In this expert level 5-day training course you will be exposed to advanced networking and Citrix ADC concepts and configurations. Through lecture, lab exercises, and real-world case studies, you will learn to look critically at environment requirements, constraints, and business drivers to create a complex Citrix networking solution. Topics to be covered in this course include multi-site and multitenant deployments, advanced authentication and load balancing, and automation and orchestration and advanced troubleshooting. This training will also prepare you for the Citrix Certified Expert in Networking (CCE-N) exam.</p></div><div id="course-pills-2"><h4>Module 1: Networking Methodology and Assessment</h4><ul><li>Understanding the Citrix methodology<br />Business Drivers and Requirementrs<br />User Segmentation<br />Application Assessment<br />Capabilities Assessment</li></ul><h4>Module 2: Citrix Networking Deployment</h4><ul><li>Architecture and Topology</li><li>Multi-Site Deployments</li><li>Multi Tennant Infrastructure</li><li>Cloud Deployments</li><li>High Availability</li><li>Citrix ADC Double-Hop Scenarios</li><li>Secure Web Gateway</li></ul><h4>Module 3: Advanced Authentication and Authorization</h4><ul><li>Authorization Policies</li><li>Access Policies</li><li>Advanced Authentication Options</li><li>Multi-Factor Authentication</li><li>nFactor Authentication</li><li>AAA Session Management</li></ul><h4>Module 4: Citrix ADC Security</h4><ul><li>Authorization</li><li>Pre-authentication and Endpoint Analysis Scans</li><li>Protection against Layer 4-7 Attacks</li><li>Web App Firewall</li></ul><h4>Module 5: Citrix Gateway Configuration</h4><ul><li>Considerations</li><li>ICA Proxy Configuration</li><li>VPN Access</li><li>Clientless Access</li><li>Split Tunneling</li><li>RDP Proxy Deployment and Configuration</li></ul><h4>Module 6: Advanced Load Distribution and Link</h4><ul><li>Load balancing</li><li>Advanced Load Balancing</li><li>Advanced Load Balancing</li><li>Link Load Balancing</li><li>Firewall Load Balancing</li><li>Microsoft Exchange Load Balancing</li><li>Advanced Global Server Load Balancing</li><li>Global Server Load Balancing Persistence</li><li>DNS, Policies, Expressions, Actions, and Views</li><li>GSLB Monitoring and Considerations</li></ul><h4>Module 7: Application Delivery Management</h4><ul><li>Automation and Orchestration</li><li>Application Delivery Management Outbound</li><li>Traffic Dashboard</li><li>Automation</li><li>Orchestration</li><li>Configuration Jobs</li><li>Configuration Audit</li><li>NITRO API</li><li>StyleBooks (Net-new)</li></ul></div>

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

Citrix

CNS-420 Citrix (NetScaler) Networking Assessment, Design, and Advanced Configuration

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for network engineers, support personnel, reseller support, and others responsible for implementing ScreenOS products.</p>Overview<p>After successfully completing this course, you should be able to:<br />Configure attack prevention features, including: ?SCREEN options; <br />Deep Inspection (DI); and <br />Antivirus (AV) scanning. <br />Configure URL filtering. <br />Configure antispam filters.</p><p>This course meets the business needs of customers who are deploying the attack prevention features of ScreenOS software. The course focuses specifically on the attack-related features and assumes familiarity with ScreenOS software. Upon completing this course, you should be able to return to work and successfully configure and verify the desired attack prevention features.</p></div><div id="course-pills-2"><h4>Chapter 1: Course Introduction </h4><h4>Chapter 2: ScreenOS Basics Review </h4><ul><li>Concepts Review </li><li>Configuration Review </li><li>Lab: ScreenOS Basics Review </li></ul><h4>Chapter 3: SCREEN Options </h4><ul><li>Multilayer Network Protection </li><li>Types of Attacks </li><li>SCREEN Options Configuration </li><li>SCREEN Best Practices </li><li>Lab: SCREEN Options Configuration </li></ul><h4>Chapter 4: Deep Inspection</h4><ul><li>Deep Inspection Overview </li><li>Attack Database Configuration </li><li>Policy Configuration </li><li>Logging and Monitoring </li><li>Lab: Deep Inspection Configuration </li></ul><h4>Chapter 5: Antivirus </h4><ul><li>Antivirus Operations </li><li>Antivirus Configuration?Kaspersky </li><li>Antivirus Configuration?ICAP </li><li>Verifying Operations </li><li>Lab: Antivirus Configuration </li></ul><h4>Chapter 6: Web Filtering </h4><ul><li>Web-Filtering Options </li><li>Web-Filtering Configuration </li><li>Verifying Operations </li><li>Lab: Configuring Web Filtering </li></ul><h4>Chapter 7: Antispam </h4><ul><li>Antispam Concepts </li><li>Antispam Configuration </li><li>Verifying Operations </li><li>Lab: Antispam Configuration </li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Attack Prevention with Juniper Networks Firewalls 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 Attack Prevention with Juniper Networks Firewalls 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>

Juniper

Certified in Cybersecurity (CC)

Network & Security

Cyber Security

Cyber Security Foundation

Attack Prevention with Juniper Networks Firewalls

Cambridge

Research Quality Association

Quality Assurance for Good Laboratory Practice

RQA Member

Non Member

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

General Admission

Virtual



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


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


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


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


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


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


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


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


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


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


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


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


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

Property Investment

Financial Analysis

Microsoft Excel

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)

This immunisation update is aimed at health professionals working in an Occupational Health capacity.
AIMS AND OBJECTIVES 
• To understand the role and importance of Immunisation and vaccination 
• To be able to explain the aims of immunisation, describe national policy and schedules and deal with variations to the schedule 
• To understand the legal framework of Immunisation 
• To understand the legal aspects of supply and administration of vaccines 

COURSE CONTENTS 
This course provides a comprehensive update in the following immunisations / vaccinations: 
• Dip / Tet / Pertusis / Polio 
• MMR 
• Hepatitis A 
• Hepatitis B 
• TB 
• BCG (screening and testing) Mantoux 
• Influenza update 
• Anaphylaxis 
Plus: 
• The legal frameworks of immunisation update and vaccinations 
• PGD’s and PSD’s 
• Technique / practical if needed 
• Administration 
• Capacity and Consent 
• Record-keeping and reporting 
• Strategies: improving immunisation rates 
• Cold chain 
• Documentation 
• Contraindications 
• Current Issues in Immunisation 

WHO SHOULD ATTEND? 
• Occupational Health Staff, including Technicians and Nurses 
Includes All course materials and certificate of attendance
Accreditation 6 CPD points awarded on completion. Accredited by Aim Qualifications (*Certificate £30) and CPD Standards (*Certificate free)



AB Health Group

Anaphylaxis

Immunisation & Vaccination

Immunisation

Health & Wellbeing

General Health

Medical Training

Vaccination

Public Health

Occupational Health Immunisation Update - Webinar

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

Microsoft Power Apps

Power Apps

Microsoft Power Platform

55215 SharePoint Online Power User

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" style="color: rgb(34, 177, 77); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(34, 177, 77);">CPD Accredited, Interactive Short Course</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">1&frac12; hr session</li><li fr-original-style="" style="box-sizing: border-box;">We will look at what manual handling is, and why it is so important</li><li fr-original-style="" style="box-sizing: border-box;">And how we can apply proper manual handling techniques in our daily lives</li></ul><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong><ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is Manual Handling</li><li fr-original-style="" style="box-sizing: border-box;">Illnesses and Injures arising from incorrect manual handling</li><li fr-original-style="" style="box-sizing: border-box;">Manual techniques</li><li fr-original-style="" style="box-sizing: border-box;">How to adapt those to our daily lives</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Benefits of this Short Course:</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Boys are around 4 x as likely to have ADHD</li><li fr-original-style="" style="box-sizing: border-box;">Manual Handling is one of the main causes of work-related musculoskeletal disorders</li><li fr-original-style="" style="box-sizing: border-box;">But manual handling illnesses and injuries do not happen in the workplace alone</li><li fr-original-style="" style="box-sizing: border-box;">This means that every single classroom in the UK will have at least one child or young people with Attention Deficit Hyperactive Disorder</li><li fr-original-style="" style="box-sizing: border-box;">Learn more about the condition and how you can help them cope and take part in &#39;normal&#39; life.</li></ul><h2 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/69e4a6e8-14e6-455c-8a26-5e523217d35f/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center;" fr-original-class="fr-draggable"></div><h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2>

Pochat Training

Manual Handling

The Basics of Manual Handling

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Nottingham

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

Caerphilly

<p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(75, 79, 88);">This workshop will builds the skills and confidence of tutors, trainers and assessors, to enable them to have conversations about mental health and wellbeing with their learners.</p><p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);">The course focuses on knowing how to better support your learners through effective communication will create an environment of trust and understanding. This course will enable you to:</p><div style="color: rgb(75, 79, 88); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Build positive relationships and rapport with your learners</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Use a range of questioning techniques with your learners to have discussions about wellbeing</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Being able to use effective questioning techniques</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Develops active listening skills</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Maintain confidentiality and know how to make referrals</div></li></ul></div><div style="color: rgb(75, 79, 88); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);"><br fr-original-style="" style="box-sizing: border-box;"></div></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div style="color: rgb(75, 79, 88); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);"><h2 style="color: var(--ast-global-color-2); box-sizing: border-box;" fr-original-style=" color: var(--ast-global-color-2);">Further Information</h2><p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(75, 79, 88);">&bull; Please ensure you have read our Terms and Conditions which include privacy, cancellation and course duration</p><p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);">&bull; This course can be completed bilingually. Workshops are in English. Support and mentoring for assignments and practical units can be in Welsh.</p><p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);">&bull; This course can take between 3 months and a year to complete. We work at a pace to suit you, and will encourage you to complete in a timely manner.</p><p style="color: rgb(75, 79, 88); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);">&bull; You may be eligible for funding for this course. Please ask about this on application. (Funding is limited and eligibility criteria apply)</p></div><div style="color: var(--ast-global-color-5); box-sizing: border-box;" fr-original-style=" color: var(--ast-global-color-5);"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: var(--ast-global-color-2); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--ast-global-color-2);">Benefits</h2><div style="color: rgb(75, 79, 88); box-sizing: border-box;" fr-original-style=" color: rgb(75, 79, 88);"><div style="color: rgb(75, 79, 88); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(75, 79, 88);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Develops confidence in having conversations about wellbeing</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Demonstrates commitment to learners, their learning, safety and wellbeing (Professional Standards)</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Can be used towards CPD hours</div></li><li fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style=" color: rgb(58, 58, 58);">Network with colleagues to build positive and collaborative relationships</div></li></ul></div></div>

This workshop will builds the skills and confidence of tutors, trainers and assessors, to enable them to have conversations about mental health and wellbeing with their learners.
The course focuses on knowing how to better support your learners through effective communication will create an environment of trust and understanding. This course will enable you to:
Build positive relationships and rapport with your learners
Use a range of questioning techniques with your learners to have discussions about wellbeing
Being able to use effective questioning techniques
Develops active listening skills
Maintain confidentiality and know how to make referrals



Further Information
• Please ensure you have read our Terms and Conditions which include privacy, cancellation and course duration
• This course can be completed bilingually. Workshops are in English. Support and mentoring for assignments and practical units can be in Welsh.
• This course can take between 3 months and a year to complete. We work at a pace to suit you, and will encourage you to complete in a timely manner.
• You may be eligible for funding for this course. Please ask about this on application. (Funding is limited and eligibility criteria apply)



Benefits
Develops confidence in having conversations about wellbeing
Demonstrates commitment to learners, their learning, safety and wellbeing (Professional Standards)
Can be used towards CPD hours
Network with colleagues to build positive and collaborative relationships

Panda Education and Training Ltd

Mental Health Awareness

Using a range a communication techniques, be able to support your learner's mental health and wellbeing. 

Supporting your learners’ wellbeing: A communication toolkit

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

Office Skills & Productivity

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<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 anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.</p>Overview<p>By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.</p><p>ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4.  This course will earn you 21 PDUs. <br /><br /> <b>This class includes an exam voucher. </b></p></div><div id="course-pills-2"><h3>1 - ITIL 4 OVERVIEW</h3> <ul> <li>Introduction to ITIL</li> <li>Key Concepts of ITIL</li> </ul> <h3>2 - The ITIL Framework</h3> <ul> <li>The Four Dimensions of Service Management</li> <li>The ITIL Service Value System</li> </ul> <h3>3 - The ITIL Guiding Principles</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimize and Automate</li> </ul> <h3>4 - THE ITIL SERVICE VALUE SYSTEM (SVS)</h3> <ul> <li>Governance</li> <li>The Service Value Chain</li> <li>Continual Improvement</li> </ul> <h3>5 - Key ITIL Practices</h3> <ul> <li>Continual Improvement</li> <li>Service Level Management</li> <li>Change Control</li> <li>Incident Management</li> <li>Service Request Management</li> <li>Service Desk</li> <li>Problem Management</li> </ul> <h3>6 - Other ITIL Practices</h3> <ul> <li>General Management Practices</li> <li>Service Management Practices</li> <li>Technical Management Practices</li> </ul></div>

39003 Courses delivered Online

Architecting on AWS Accelerator

By Nexus Human

Kubernetes Administration

By Nexus Human

Advanced C Plus Plus

By Nexus Human

Cisco Introducing Cisco Unified Computing System v1.0 (DCIUCS)

By Nexus Human

Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration

By Nexus Human

CertNexus Data Science for Business Professionals (DSBIZ)

By Nexus Human

Adobe Dreamweaver CC - Part 2

By Nexus Human

BizTalk Server 2021 Developer Deep Dive

By Nexus Human

CNS-420 Citrix (NetScaler) Networking Assessment, Design, and Advanced Configuration

By Nexus Human

Attack Prevention with Juniper Networks Firewalls

By Nexus Human