<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is designed for network and software engineers and hold job roles such as:<br />Network administrator<br />Network engineer<br />Network manager<br />System engineer<br />Project manager<br />Network designer</p>Overview<p>After taking this course, you should be able to:<br />Describe mobile network architecture basics<br />List enabling technologies for 5G and describe 5G key use cases<br />Perform basic operations on a Cisco 5G NSA mobile packet core<br />Describe the Cisco 5G Converged SDN Transport Architecture<br />Describe Cisco NFVI and perform basic operations using Cisco ESC and Cisco Virtualized Infrastructure Manager (VIM)<br />Describe Cisco service provider automation and orchestration solutions to deploy and manage 5G network functions<br />Describe the Cisco Ultra Cloud Core architecture and deploy the Cisco SMI<br />Explain the 5G ready distributed Telco DC with Cisco ACI solution<br />Describe the Cisco 5G security architecture</p><p>The Cisco Service Provider 5G Technologies Foundations (SPMBL100) v1.0 course introduces mobile network components, basic 5G concepts, and features of 5G technology including faster data speeds, higher device capacity, and improved user experience. You will examine the mobile packet core solutions, 5G transport architecture, and CiscoÂ© automation and orchestration tools used in 5G networks. You will also learn about the Cisco 5G Non-standalone (NSA) and the Cisco Ultra Cloud Core 5G standalone (SA) platform solutions, the Cisco 5G converged Software-Defined Networking (SDN) transport architecture, and Cisco edge computing solutions. You will study the Cisco Network Function Virtualization (NFVI) architecture, Cisco Network Services Orchestrator (NSO), and Cisco Elastic Services Controller (ESC). You will learn how 5G is distributed with Telco Data Center (DC) with Cisco Application Centric Infrastructure (Cisco ACIÂ©). And finally, Zero-Touch Provisioning (ZTP), Cisco Crosswork?, and the Cisco 5G security architecture will also be presented.</p></div><div id="course-pills-2"><h4>Mobile Network Fundamentals</h4><ul><li>5G Key Use Cases</li><li>Examining Mobile Network Components</li></ul><h4>Enabling Technologies for 5G</h4><ul><li>Introduction to 5G NR Characteristics</li><li>Cloud Radio Access network (RAN)</li></ul><h4>Cisco 5G NSA Solution</h4><ul><li>5G NSA Basics</li><li>5G NSA StarOS Configurations</li></ul><h4>Cisco 5G Converged SDN Transport Architecture</h4><ul><li>Cisco 5G Transport Ready Devices</li><li>Application Awareness and Network Slicing with Segment Routing</li></ul><h4>Cisco NFV Infrastructure, Cisco Virtualized Network Functions (VNFs), Cisco VIM, and Cisco ESC</h4><ul><li>NFVI and SDN Architecture Overview</li><li>Cisco VIM Pod Configurations</li></ul><h4>Cisco Service Provider Automation and Orchestration</h4><ul><li>Telemetry Basics</li><li>ZTP Fundamentals</li></ul><h4>Cisco Ultra Cloud Core</h4><ul><li>Cisco Ultra Cloud Core Basics</li><li>Kubernetes and Docker Fundamentals</li></ul><h4>5G Ready Distributed DC with Cisco ACI</h4><ul><li>Cisco ACI in Telco Data Centers</li><li>5GC Deployment</li></ul><h4>Mitigating Threats in 5G</h4><ul><li>Introduction to 5G Cybersecurity Risks</li><li>Mitigating 5G Cybersecurity Risks</li></ul></div>

Nexus Human

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Certificate in Information Security Management Principles (CISMP)

Certified Cloud Security Professional (CCSP)

Cisco Certified Internetwork Expert (CCIE)

IT Networking Fundamentals

Cisco Service Provider 5G Technologies Foundations v1.0 (SPMBL100)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is ideal for developers, engineers, and others including:<br />Cloud administrators<br />Cloud solution architects<br />Customer sales engineers<br />DevOps engineers<br />Sales engineers<br />Systems engineers<br />Technical solutions architects</p>Overview<p>After you complete this course the learner will be able to meet these overall objectives:<br />Describe the Cisco CloudCenter solution, architecture, and features<br />Discover the enterprise-class security solution for IT organizations and cloud service providers<br />Discover how the CloudCenter Suite adapters can be leveraged to build custom integrations with a variety of enterprise platforms and services<br />Discover the integrations and APIs that can be performed from Action Orchestrator</p><p>CLDAO, Mulitcloud Automation and Orchestration with Cisco CloudCenter Suite is a 3-day course that teaches you how to configure simplified orchestration and workflow automation that provides seamless integration within the CiscoÂ© CloudCenter suite. Through lessons and hands-on experiences, you will learn to use the tools of the CloudCenter Suite to streamline business processes, automate tasks, and increase efficiency in business processes.This course will help you:Acquire the advanced skills and techniques using the primary modules of workload manager, cost optimizer and action orchestrator for consistent experiences across all business environmentsLearn how to design and deploy applications that are delivered consistently and reliably across private and public clouds</p></div><div id="course-pills-2"><h4>Introducing Cisco CloudCenter Suite Action Orchestrator</h4><ul><li>Cisco CloudCenter Suite Architecture</li></ul><h4>Defining Action Orchestrator User Management and Security Considerations</h4><ul><li>Cisco CloudCenter Suite User Management and Security</li></ul><h4>Defining Cisco CloudCenter Suite Action Orchestrator Adapters</h4><ul><li>Action Orchestrator Adapter Creation</li></ul><h4>Examining Action Orchestrator Integrations and Supported APIs</h4><ul><li>Cisco CloudCenter Suite Action Orchestrator APIs</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Multicloud Automation and Orchestration with Cisco CloudCenter Suite (CLDAO) 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 Multicloud Automation and Orchestration with Cisco CloudCenter Suite (CLDAO) 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>

Certificate of Completion (CCL)

Cloud Architecture

AWS Certified Cloud Practitioner

Commercial & Contract Management Certification Program (CCM)

AWS Certified Solutions Architect

Central Law Training (CLT)

Cisco Multicloud Automation and Orchestration with Cisco CloudCenter Suite (CLDAO)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is designed for technical professionals who require the skills to administer IBMÂ© MQ queue managers on distributed operating systems, in the Cloud, or on the IBMÂ© MQ Appliance.</p>Overview<p>After completing this course, you should be able to:Describe the IBMÂ© MQ deployment optionsPlan for the implementation of IBMÂ© MQ on-premises or in the CloudUse IBMÂ© MQ commands and the IBMÂ© MQ Explorer to create and manage queue managers, queues, and channelsUse the IBMÂ© MQ sample programs and utilities to test the IBMÂ© MQ networkEnable a queue manager to exchange messages with another queue managerConfigure client connections to a queue managerUse a trigger message and a trigger monitor to start an application to process messagesImplement basic queue manager restart and recovery proceduresUse IBMÂ© MQ troubleshooting tools to identify the cause of a problem in the IBMÂ© MQ networkPlan for and implement basic IBMÂ© MQ security featuresUse accounting and statistics messages to monitor the activities of an IBMÂ© MQ systemDefine and administer a simple queue manager cluster</p><p>This course provides technical professionals with the skills that are needed to administer IBMÂ© MQ queue managers on distributed operating systems and in the Cloud. In addition to the instructor-led lectures, you participate in hands-on lab exercises that are designed to reinforce lecture content. The lab exercises use IBMÂ© MQ V9.0, giving you practical experience with tasks such as handling queue recovery, implementing security, and problem determination.<br />Note: This course does not cover any of the features of MQ for z/OS or MQ for IBMÂ© i.</p></div><div id="course-pills-2"><h4>Course introduction</h4><h4>IBMÂ© MQ review</h4><h4>IBMÂ© MQ installation and deployment options</h4><h4>Creating a queue manager and queues</h4><h4>Exercise: Using commands to create a queue manager and queues</h4><h4>Introduction to IBMÂ© MQ Explorer</h4><h4>Exercise: Using IBMÂ© MQ Explorer to create queue managers and queues</h4><h4>Testing the IBMÂ© MQ implementation</h4><h4>Exercise: Using IBMÂ© MQ sample programs to test the configuration</h4><h4>Implementing distributed queuing</h4><h4>Exercise: Connecting queue managers</h4><h4>IBMÂ© MQ clients</h4><h4>Exercise: Connecting an IBMÂ© MQ client</h4><h4>Implementing trigger messages and monitors</h4><h4>Exercise: Implementing a trigger monitor</h4><h4>Diagnosing problems</h4><h4>Exercise: Running an IBMÂ© MQ trace</h4><h4>Implementing basic security in IBMÂ© MQ</h4><h4>Exercise: Controlling access to IBMÂ© MQ</h4><h4>Backing up and restoring IBMÂ© MQ messages and object definitions</h4><h4>Exercise: Using a media image to restore a queue</h4><h4>Exercise: Backing up and restoring IBMÂ© MQ object definitions</h4><h4>Introduction to queue manager clusters</h4><h4>Exercise: Implementing a basic cluster</h4><h4>Monitoring and configuring IBMÂ© MQ for performance</h4><h4>Exercise: Monitoring IBMÂ© MQ for performance</h4><h4>Course summary</h4></div>

Project Management Qualification (PMQ)

Microsoft Virtual Academy (MVA)

Certified Manager of Quality

PQMS

IBM MQ

WM153 IBM MQ V9 System Administration (using Windows for labs)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Individuals taking this course are business professionals seeking to develop or increase their emotional intelligence.</p>Overview<p>In this course, you will explore the concept of emotional intelligence. You will:<br />Identify the components of emotional intelligence and recognize how emotional intelligence benefits organizations.<br />Assess and develop your personal emotional intelligence competencies.<br />Assess and develop your social emotional intelligence competencies.<br />Practice emotional intelligence in common workplace scenarios.</p><p>It was once believed that intelligence was the metric that would determine a person's success in the workplace. Intelligence matters because it contributes to your ability to do your job. But intelligence is not the best indicator of whether or not you'll succeed. Your ability to understand and manage your own emotions, and get along well with others, has at least as much impact on your performance and effectiveness as intelligence. In this course, you'll explore strategies to increase your awareness of your emotions, develop your ability to manage your emotions, and improve your social skills.</p></div><div id="course-pills-2"><h4>Recognizing the Benefits of Emotional Intelligence</h4><ul><li>Define Emotional Intelligence</li><li>Recognize EQ's Impact on Work Experience</li></ul><h4>Increasing Your Personal Emotional Intelligence in the Workplace</h4><ul><li>Develop Your Level of Self-Awareness</li><li>Develop Your Self-Regulation Skills</li><li>Develop Your Motivation</li></ul><h4>Increasing Your Social Emotional Intelligence in the Workplace</h4><ul><li>Develop Your Empathy</li><li>Develop Your Social Skills</li></ul><h4>Practicing Emotional Intelligence in the Workplace</h4><ul><li>Practice Emotionally Intelligent Leadership</li><li>Build an Emotionally Intelligent Team</li><li>Manage Change</li><li>Manage Conflict</li><li>Coach for Performance</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Emotional Intelligence for Business Professionals (Second Edition) 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 Emotional Intelligence for Business Professionals (Second Edition) 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>

Emotional Wellbeing

Emotional Intelligence (EQ)

Emotional Resilience

Master Your Emotions

Emotional Literacy

Trainers Course

Emotional Intelligence for Business Professionals (Second Edition)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>The primary audience for this course is system installers, system integrators, system administrators, network administrators, and solutions designers.</p>Overview<p>At the end of this course, you will be able to:<br />Describe the NSO's transactional application framework and mapping model options<br />Describe the Reactive Fastmap design pattern and the NSO Configuration Database (CDB) subscriber in the NSO Transaction model<br />Simplify packages to remove the need for subscriber applications, scale orchestration solutions, and integrate NSO with external systems (east-west integration)Describe the Cisco ESC architecture and integration with NSO, and how the NSO VNF Orchestration (VNFO) Release 2 bundle interacts with ESC for orchestration</p><p>This course explores how to create advanced services using the NSO application framework and Python scripting with both new and existing Layer 3 Multiprotocol Label Switching (MPLS) VPN services. Students will also learn how to manage and scale these services, and how to use NSO Network Functions Virtualization (NFV) orchestration features and Cisco Elastic Services Controller (ESC) to manage Virtualized Network Functions (VNFs).</p></div><div id="course-pills-2"><h4>Cisco NSO Programmability</h4><ul><li>NSO Application Framework</li><li>NSO Python Scripting</li><li>NSO Python and Template-Based Services</li><li>Resources</li></ul><h4>Augmenting Cisco NSO Service </h4><ul><li>Service Lifecycle and Integration Options Overview</li><li>Greenfield Layer 3 MPLS VPN Service</li><li>Brownfield Layer 3 MPLS VPN Service</li></ul><h4>Managed Services </h4><ul><li>Managed Services Overview</li><li>Stacked Service Design Overview</li><li>Design-Managed Network Services</li><li>Scaling Service Orchestration</li></ul><h4>Cisco NSO Network Functions Virtualization (NFV) Orchestration </h4><ul><li>ETSI MANO</li><li>Cisco ESC</li><li>Cisco NSO Orchestration</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Network Services Orchestrator Advanced Design (NSO300) 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 Network Services Orchestrator Advanced Design (NSO300) 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>

Service Design Courses (SDC)

Network Engineer

Cisco Certified Entry Networking Technician (CCENT)

Professional Skills Course (PSC)

Cisco Network Services Orchestrator Advanced Design (NSO300)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This is an introductory-level course designed to teach experienced systems administrators how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Previous Hadoop experience is not required.</p>Overview<p>Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will learn to:<br />Understand the benefits of distributed computing<br />Understand the Hadoop architecture (including HDFS and MapReduce)<br />Define administrator participation in Big Data projects<br />Plan, implement, and maintain Hadoop clusters<br />Deploy and maintain additional Big Data tools (Pig, Hive, Flume, etc.)<br />Plan, deploy and maintain HBase on a Hadoop cluster<br />Monitor and maintain hundreds of servers<br />Pinpoint performance bottlenecks and fix them</p><p>Apache Hadoop is an open source framework for creating reliable and distributable compute clusters. Hadoop provides an excellent platform (with other related frameworks) to process large unstructured or semi-structured data sets from multiple sources to dissect, classify, learn from and make suggestions for business analytics, decision support, and other advanced forms of machine intelligence.<br />This is an introductory-level, hands-on lab-intensive course geared for the administrator (new to Hadoop) who is charged with maintaining a Hadoop cluster and its related components. You will learn how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Hadoop history and concepts</li><li>Ecosystem</li><li>Distributions</li><li>High level architecture</li><li>Hadoop myths</li><li>Hadoop challenges (hardware / software)</li></ul><h4>Planning and installation</h4><ul><li>Selecting software and Hadoop distributions</li><li>Sizing the cluster and planning for growth</li><li>Selecting hardware and network</li><li>Rack topology</li><li>Installation</li><li>Multi-tenancy</li><li>Directory structure and logs</li><li>Benchmarking</li></ul><h4>HDFS operations</h4><ul><li>Concepts (horizontal scaling, replication, data locality, rack awareness)</li><li>Nodes and daemons (NameNode, Secondary NameNode, HA Standby NameNode, DataNode)</li><li>Health monitoring</li><li>Command-line and browser-based administration</li><li>Adding storage and replacing defective drives</li></ul><h4>MapReduce operations</h4><ul><li>Parallel computing before MapReduce: compare HPC versus Hadoop administration</li><li>MapReduce cluster loads</li><li>Nodes and Daemons (JobTracker, TaskTracker)</li><li>MapReduce UI walk through</li><li>MapReduce configuration</li><li>Job config</li><li>Job schedulers</li><li>Administrator view of MapReduce best practices</li><li>Optimizing MapReduce</li><li>Fool proofing MR: what to tell your programmers</li><li>YARN: architecture and use</li></ul><h4>Advanced topics</h4><ul><li>Hardware monitoring</li><li>System software monitoring</li><li>Hadoop cluster monitoring</li><li>Adding and removing servers and upgrading Hadoop</li><li>Backup, recovery, and business continuity planning</li><li>Cluster configuration tweaks</li><li>Hardware maintenance schedule</li><li>Oozie scheduling for administrators</li><li>Securing your cluster with Kerberos</li><li>The future of Hadoop</li></ul></div>

Introduction to Hadoop Administration (TTDS6503)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is designed for those who have little or no experience with Linux and whoare seeking a fundamental understanding of the SUSE Linux Enterprise 15 operatingsystem. It is also ideal for those who want to begin preparing for the SUSE CertifiedAdministrator in Enterprise Linux 15 certification exam.</p>Overview<p>Attendees will be taught the following concepts and skills that are fundamental inadministering the SLES Operating System:Install SLES 15 and perform basic Linux configurationBecome familiar with the command line interface &amp; commonly usedcommandsConfigure and use Remote AdministrationManage the boot process and understand systemsManage processes and jobsManage users and permissionsManage softwareConfigure basic networkingManage storageMonitor SUSE Linux Enterprise</p><p>This course is designed for those who are seeking a fundamental understanding of the SUSE Linux Enterprise Server (SLES) operating system.Students will be able to install and configure a SLES 15 server and integrate it into an existing network. They will be able to perform the most important system administration tasks.</p></div><div id="course-pills-2"><h4>Overview of SUSE Linux Enterprise </h4><ul><li>Flavors of SUSE Linux</li><li>SLE Maintenance Model</li><li>YaST</li><li></li></ul><h4>The Linux Filesystem </h4><ul><li>Understand the Filesystem Hierarchy Standard (FHS)</li><li>Understand the Linux File Types</li><li></li></ul><h4>Work with the Command Line</h4><ul><li>Getting Help at the Command Line</li><li>Understand the Shell Environment</li><li></li></ul><h4>The Vim Editor</h4><h4>Remote Administration</h4><ul><li>Understand Remote Administration with OpenSSH</li><li>Understand Remote Administration with VNC</li><li></li></ul><h4>System Initialization</h4><ul><li>Understand the Boot Process</li><li>Understand the GRUB2 Boot Loader</li><li>Define and Describe systems</li><li></li></ul><h4>Process Management</h4><ul><li>Understand Process Administration</li><li>Understand Background Processes</li><li>Understand Process Scheduling</li><li>Understand xinet</li></ul><h4>Identify and Security</h4><ul><li>Understand User Management</li><li>Understand Filesystem Permissions</li><li>Understand Privilege Delegation</li></ul><h4>Software Management</h4><ul><li>Understand Compiling Software from Source</li><li>Understand Management of RPM Packages</li><li>Understand Software Management with Libzypp</li></ul><h4>Network Management</h4><ul><li>Understand Network Management in SLE</li><li>Understand Network Management with Wicked</li><li>Understand firewall</li><li></li></ul><h4>Storage Management</h4><ul><li>Understand the Linux I/O Stack</li><li>Recognize Traditional Linux File Systems</li><li>Configure Logical Volume Management (LVM)</li><li>Configure Software RAID</li><li>Define and Describe BtrFS</li><li>Understand NFSv4</li></ul><h4>Administration and Monitoring</h4><ul><li>Understand Time Sync with chrony</li><li>Configure System Logging</li><li>Understand Supportconfig</li></ul><h4>Installing SUSE Linux Enterprise</h4><ul><li>Understand the Unified Installer</li><li>Understand Extensions and Modules</li><li>Understand AutoYaST</li></ul></div>

Linux Administration

LPIC-1:Linux Administrator

Operating Systems & Services

SUSE Linux Enterprise Server 15 Administration

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Operators, administrators, and architects for VMware Horizon should enroll in this course. These individuals are responsible for the creation, maintenance, and or delivery of remote and virtual desktop services.</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Recognize the features and benefits of Horizon<br />Use VMware vSphere to create VMs to be used as desktops for Horizon<br />Create and optimize Windows VMs to create Horizon desktops<br />Install and configure Horizon Agent on Horizon desktop<br />Configure and manage the VMware Horizon Clientâ¢ systems and connect the client to a VMware Horizon desktop<br />Configure, manage, and entitle desktop pools of full VMs<br />Configure, manage, and entitle pools of instant-clone desktops<br />Create and use Remote Desktop Services (RDS) desktops and application pools<br />Monitor the Horizon environment using Horizon Console Dashboard and Horizon Help Desk Tool</p><p>This three-day, hands-on course gives you the skills to deliver virtual desktops and applications through a single virtual desktop infrastructure platform. This course builds your skills in configuring and managing VMware HorizonÂ© 8 through a combination of lecture and hands-on labs. You learn how to configure and deploy pools of virtual machines and how to provide a customized desktop environment to end-users.</p></div><div id="course-pills-2">This three-day, hands-on course gives you the skills to deliver virtual desktops and applications through a single virtual desktop infrastructure platform. This course builds your skills in configuring and managing VMware Horizon 8 through a combination of lecture and hands-on labs. You learn how to configure and deploy pools of virtual machines and how to provide a customized desktop environment to end-users.</div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC)</p><p>Nexus Humans VMware Horizon 8: Skills for Virtual Desktop Management 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 VMware Horizon 8: Skills for Virtual Desktop Management 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>

VMware Vsphere

vSphere

VMware Horizon 8: Skills for Virtual Desktop Management

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Reporting Fundamentals in Lightning Experience is ideal for Sales Rep/Managers, Service Rep/Managers, Beginning Admin, and Business Analyst/Solution Architects.</p>Overview<p>When you complete this course, you will be able to:Work with standard reports.Establish a report building process.Build custom reports using different reporting formats in Lightning.Group and summarize reports in Lightning.Use field filters and filter logic.Add charts and conditional highlighting.Create dashboards in Lightning</p><p>This course will teach you how to customize existing reports as well as use the Salesforce reporting toolset to create your own reports.</p></div><div id="course-pills-2"><h4>Introducing the Course</h4><h4>Reports Tab, Folders, and Formats</h4><ul><li>Navigate the Reports Tab to Find Suitable Reports</li><li>Create Custom Folders in Classic to be Used in Lightning</li><li>Describe the Different Formats of Reports</li><li>Run and Modify Existing Reports</li></ul><h4>Using the Report Builder</h4><ul><li>Establish a Report Building Process</li><li>Navigate the Report Builder</li><li>Create Custom Reports Using a Standard Report Type</li><li>Use Filters and Filter Logic</li><li>Export Your Report</li></ul><h4>Summarizing Your Data</h4><ul><li>Understand the Difference Between a Summary and Matrix Report</li><li>Use Bucket Fields to Segment Your Data</li><li>Use Custom Summary Formulas to Perform Calculations on Your Report Data</li></ul><h4>Getting More Insight from Your Data</h4><ul><li>Add Conditional Highlighting to a Report</li><li>Create Charts to Display Summary Data</li><li>Schedule and Email a Report to Run</li></ul><h4>Dashboards</h4><ul><li>Articulate What a Dashboard Is</li><li>Understand the Benefits of Creating Dashboards in Lightning</li><li>Create a Dashboard Using the Dashboard Builder</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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 Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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>

Salesforce Associate

Salesforce Certified JavaScript Developer

Salesforce

Salesforce Certified Marketing Cloud Email Specialist

Salesforce Reporting Fundamentals in Lightning Experience (RPX101)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is designed for network administrators, system administrators, network architects, systems engineers, and technical support engineers who are involved with advanced installation, configuration, maintenance, and basic troubleshooting of Ruckus ICX products.</p>Overview<p>Upon successful completion of this course, the student will be able to:<br />Describe Ruckus ICX hardware<br />Configure and implement management protocols on Ruckus equipment<br />Configure and implement monitoring and reporting features on Ruckus equipment including syslogs and sFlow<br />Perform hardware troubleshooting and support functions<br />Perform firmware upgrades<br />Configure, implement, and maintain Layer 2 STP protocols (RSTP, MSTP, PVST)<br />Configure and manage VLANs, Virtual Ethernet routed interfaces, topology groups, and Q-in-Q Configure, deploy and maintain Link Aggregation Groups (LAGS)<br />Describe, configure, and maintain Multi-Chassis Trunking (MCT)<br />Integrate MCT with VRRPe for redundancy<br />Identify PoE-capable products<br />Configure and manage Ruckus ICX switches in a PoE environment<br />Configure, implement, and maintain the OSPF routing protocol<br />Configure, implement, and maintain QoS</p><p>This course provides an in-depth study of the Ruckus ICX family of products and how they are utilized in an enterprise network. The course covers core competencies of configuration, operations and maintenance of Ruckus ICX products. This course also covers core L2/L3 protocol configurations including STP family, OSPF, QoS, and Ruckus proprietary protocols and technology including MCT, VRRPe and FDP.</p></div><div id="course-pills-2">This course provides an in-depth study of the Ruckus ICX family of products and how they are utilized in an enterprise network. The course covers core competencies of configuration, operations and maintenance of Ruckus ICX products. This course also covers core L2/L3 protocol configurations including STP family, OSPF, QoS, and Ruckus proprietary protocols and technology including MCT, VRRPe and FDP.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Ruckus ICX 200 Administrator Training Course 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 Ruckus ICX 200 Administrator Training Course 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>

Ruckus ICX 200 Administrator Training Course

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>

Online Course Creation

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

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

Cisco Service Provider 5G Technologies Foundations v1.0 (SPMBL100)

By Nexus Human

Cisco Multicloud Automation and Orchestration with Cisco CloudCenter Suite (CLDAO)

By Nexus Human

WM153 IBM MQ V9 System Administration (using Windows for labs)

By Nexus Human

Emotional Intelligence for Business Professionals (Second Edition)

By Nexus Human

Cisco Network Services Orchestrator Advanced Design (NSO300)

By Nexus Human

Introduction to Hadoop Administration (TTDS6503)

By Nexus Human

SUSE Linux Enterprise Server 15 Administration

By Nexus Human

VMware Horizon 8: Skills for Virtual Desktop Management

By Nexus Human

Salesforce Reporting Fundamentals in Lightning Experience (RPX101)

By Nexus Human

Ruckus ICX 200 Administrator Training Course

By Nexus Human