<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers)</p><p>This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution &amp; will be shown a range of resources.</p></div><div id="course-pills-2"><h4>IBM Cognos Analytics</h4><ul><li>Describe IBM Cognos Analytics</li><li>Describe IBM Cognos Analytics components</li><li>Describe IBM Cognos architecture at a high level</li><li>Describe IBM Cognos security at a high level</li></ul><h4>Consume Content in IBM Cognos Analytics</h4><ul><li>Where do consumers access BI content?</li><li>Use published reports</li><li>Drill through to related data</li><li>Specify run report options</li><li>Specify properties of an entry</li><li>Alerts and Watch Items</li></ul><h4>Create Reports in IBM Cognos Analytics</h4><ul><li>Overview of reporting and report authoring</li><li>Identify package types, uploaded files, and data modules available for reporting</li><li>Examine IBM Cognos Analytics - Reporting</li><li>Examine the interface</li><li>Explore different report types</li><li>Create a simple, sorted, and formatted report</li><li>Create a report view</li><li>Create a subscription</li><li>Create an Active Report</li><li>Import and report on personal data</li></ul><h4>Create Dashboards in IBM Cognos Analytics</h4><ul><li>Describe IBM Cognos Dashboarding</li><li>Identify the IBM Cognos Dashboarding user interface</li><li>Add report content and tools to create dashboards</li><li>Widget-to-widget communication</li><li>Filter data in the dashboard</li><li>Sort, group and ungroup, and calculate data</li></ul><h4>Create Metadata Models in IBM Cognos Analytics</h4><ul><li>Define IBM Cognos Framework Manager and its purpose</li><li>Describe the IBM Cognos Framework Manager environment</li><li>Describe IBM Cognos Cube Designer</li><li>Get high-level content from Dynamic Cubes course and/or FM course</li><li>Web-based Modeling</li><li>Create Data Modules</li></ul><h4>Extend IBM Cognos Analytics</h4><ul><li>Introduction to IBM Cognos Mobile</li><li>Key features</li><li>Examine Cognos Mobile architecture</li><li>Identify supported products</li><li>Introduction to IBM Cognos BI for Microsoft Office</li><li>Describe Cognos Analysis for Excel (CAFÂ)</li></ul><h4>Compare IBM Cognos Analytics &amp; IBM Cognos BI</h4><ul><li>New features in IBM Cognos Analytics</li><li>Changes from IBM Cognos BI to IBM Cognos Analytics</li><li>Legacy option</li><li>Examine Event Studio</li><li>Examine the role of Event Studio in Performance Management</li><li>List the benefits of Event Studio</li><li>Examine Metric Studio</li><li>Identify scorecards, metrics, and metric types</li><li>Organize metrics with strategies</li><li>Track initiatives with projects</li></ul></div>

Nexus Human

Cognos

Business Analytics & Intelligence

Oracle Business Intelligence

Excel Analytics

IMS Productivity Analyst

Microsoft BI

B6008 Overview of IBM Cognos Analytics (v11.0)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Data Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context.</p>Overview<p>By the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently.</p><p>In this course you will start with the absolute basics of Python, focusing mainly on data structures.  Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries.  You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables.  To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets.</p></div><div id="course-pills-2"><h4>Introduction to Data Structure using Python</h4><ul><li>Python for Data Wrangling</li><li>Lists, Sets, Strings, Tuples, and Dictionaries</li></ul><h4>Advanced Operations on Built-In Data Structure</h4><ul><li>Advanced Data Structures</li><li>Basic File Operations in Python</li></ul><h4>Introduction to NumPy, Pandas, and Matplotlib</h4><ul><li>NumPy Arrays</li><li>Pandas DataFrames</li><li>Statistics and Visualization with NumPy and Pandas</li><li>Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame</li></ul><h4>Deep Dive into Data Wrangling with Python</h4><ul><li>Subsetting, Filtering, and Grouping</li><li>Detecting Outliers and Handling Missing Values</li><li>Concatenating, Merging, and Joining</li><li>Useful Methods of Pandas</li></ul><h4>Get Comfortable with a Different Kind of Data Sources</h4><ul><li>Reading Data from Different Text-Based (and Non-Text-Based) Sources</li><li>Introduction to BeautifulSoup4 and Web Page Parsing</li></ul><h4>Learning the Hidden Secrets of Data Wrangling</h4><ul><li>Advanced List Comprehension and the zip Function</li><li>Data Formatting</li></ul><h4>Advanced Web Scraping and Data Gathering</h4><ul><li>Basics of Web Scraping and BeautifulSoup libraries</li><li>Reading Data from XML</li></ul><h4>RDBMS and SQL</h4><ul><li>Refresher of RDBMS and SQL</li><li>Using an RDBMS (MySQL/PostgreSQL/SQLite)</li></ul><h4>Application in real life and Conclusion of course</h4><ul><li>Applying Your Knowledge to a Real-life Data Wrangling Task</li><li>An Extension to Data Wrangling</li></ul></div>

Data Engineering

Big Data Analytics

Data Science

Data Skills

Data Analyst

Data Processing

Data Wrangling with Python

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is as follows:<br />System engineers<br />Network engineers<br />Technical architects<br />Technical support engineers<br />Cisco integrators and partners</p>Overview<p>Upon successful completion of this course, students will be able to meet these overall objectives:<br />Describe Cisco ISE policies and authentication and authorization process<br />Understand different AAA protocols<br />Understand how Cisco ISE fits into Cisco DNA Center architecture<br />Provide configuration examples of Cisco ISE and TrustSec solutions<br />Describe Cisco ISE integration with Cisco DNA Center and policy enforcement using Security Groups<br />Provide configuration examples for wired, wireless, and VPN network access<br />Understand how inline tagging and SGT Exchange Protocol (SXP) works</p><p>This course shows you how to deploy the CiscoÂ© Identity Services Engine (ISE) to support the Software-Defined Access (SD-Access) solution within your enterprise networks. You will gain an understanding of how Cisco ISE is utilized by the SD-Access solution to provide security policies across the organization. You will learn Cisco ISE fundamentals and get hands-on practice configuring ISE, policies, AAA client configuration, VPN access, integration, wireless guest access, and more.</p></div><div id="course-pills-2"><h4>Cisco ISE Overview</h4><ul><li>Exploring the Cisco Identity Services Engine</li><li>Examining AAA protocols</li><li>Examining Authentication</li><li>Examining Authorization</li></ul><h4>Cisco ISE Guest Access</h4><ul><li>Examining Guest Portal Types</li><li>Examining Guest User Types</li><li>Examining AAA Policies for Guest Access</li></ul><h4>Cisco ISE and SD-Access</h4><ul><li>Exploring Cisco SD-Access</li><li>Examining Cisco ISE for SD-Access</li></ul><h4>Cisco ISE SGT Exchange Protocol</h4><ul><li>SD-Access Fabric and Host Provisioning</li><li>Security Group Exchange Protocol</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Configuring Cisco ISE Essentials for SD- Access v1.0 (ISESDA) 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 Configuring Cisco ISE Essentials for SD- Access v1.0 (ISESDA) 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)

IT Certifications

Certificate in Information Security Management Principles (CISMP)

SIA Training

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

Cisco Configuring Cisco ISE Essentials for SD- Access v1.0 (ISESDA)

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

Microsoft AZ-104

Trainers Course

Microsoft AZ-303

Teaching & Training

BizTalk Server 2021 Developer Deep Dive

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Agile professionals, Project Managers and aspiring Project Managers who want to be able to combine PRINCE2 and Agile in the most effective way when using PRINCE2, Agile behaviours, concepts, frameworks, and techniques<br />Other key delivery team staff, including Product Owners, Scrum Masters, and Developers<br />Business professionals with an interest in iterative and incremental project delivery by collaborating working</p>Overview<p>At the end of this course, you will be able to:<br />Understand the key concepts relating to PRINCE2.<br />Understand the key concepts relating to projects and PRINCE2 Agile.<br />Understand how PRINCE2 principles, themes, processes and management products are tailored and applied in an Agile context.<br />Understand the agile ways of working, key terms and techniques.<br />Understand the focus areas in an Agile context.</p><p>PRINCE2 Agile is the world?s most complete project management solution, combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2Â©. As a PRINCE2Â© Accredited Training Organization of PeopleCert, all students attending this training will be provided with the exam voucher as a part of delivery.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Course Introduction and Agile Overview</li><li>PRINCE2 Summary</li><li>Culture </li><li>Blending PRINCE2 and Agile</li><li>Combining PRINCE2 and AgileÃ¿</li><li>Combining PRINCE2 and Agile (Contd.)</li><li>Homework Day 1Ã¿</li><li>PRINCE2 Agile Themes</li><li>PRINCE2 Agile Processes</li><li>Agile frameworks, Concepts, and Techniques</li><li>Agile Focus Areas</li><li>Mock Exam</li></ul><h4>PRINCE2Â© is a registered trademark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.</h4><ul><li> </li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>New Horizons is an Authorised Training Organisation (ATO) for Peoplecert for ITIL4 and PRINCE2</p><p>Nexus Humans PRINCE2 Agile Foundation with Exam 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 PRINCE2 Agile Foundation with Exam 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>

Project Management Qualification (PMQ)

ICP-ACC (ICAgile Certified Agile Coaching)

ACP (Agile Certified Practitioner)

Project Management Professional (PMP)

Professional Agile Leadership (PAL)

PRINCE2

PRINCE2 Agile Foundation with Exam

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for technical professionals who need to know how to deploy and manage a Cisco Firepower NGIPS in their network environment.<br />Security administrators<br />Security consultants<br />Network administrators<br />System engineers<br />Technical support personnel<br />Channel partners and resellers</p>Overview<p>After taking this course, you should be able to:<br />Describe the components of Cisco Firepower Threat Defense and the managed device registration process<br />Detail Next-Generation Firewalls (NGFW) traffic control and configure the Cisco Firepower system for network discovery<br />Implement access control policies and describe access control policy advanced features<br />Configure security intelligences features and the Advanced Malware Protection (AMP) for Networks implementation procedure for file control and advanced malware protection<br />Implement and manage intrusion and network analysis policies for NGIPS inspection<br />Describe and demonstrate the detailed analysis techniques and reporting features provided by the Cisco Firepower Management Center<br />Integrate the Cisco Firepower Management Center with an external logging destination<br />Describe and demonstrate the external alerting options available to Cisco Firepower Management Center and configure a correlation policy<br />Describe key Cisco Firepower Management Center software update and user account management features<br />Identify commonly misconfigured settings within the Cisco Firepower Management Center and use basic commands to troubleshoot a Cisco Firepower Threat Defense device</p><p>This course shows you how to deploy and use Cisco FirepowerÂ© Next-Generation Intrusion Prevention System (NGIPS). This hands-on course gives you the knowledge and skills to use the platform features and includes firewall security concepts, platform architecture and key features; in-depth event analysis including detection of network-based malware and file type, NGIPS tuning and configuration including application control, security intelligence, firewall, and network-based malware and file controls; SnortÂ© rules language; file and malware inspection, security intelligence, and network analysis policy configuration designed to detect traffic patterns; configuration and deployment of correlation policies to take action based on events detected; troubleshooting; system and user administration tasks, and more. This course helps you prepare to take the exam, Securing Networks with Cisco Firepower (300-710 SNCF), which leads to CCNP Security and Cisco Certified Specialist ? Network Security Firepower certifications. The 300-710 SNCF exam has a second preparation course as well, CiscoÂ© Securing Networks with CiscoÂ© Firepower Next Generation Firewall (SSNGFW). You can take these courses in any order.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Cisco Firepower Threat Defense Overview</li><li>Cisco Firepower NGFW Device Configuration    </li><li>Cisco Firepower NGFW Traffic Control     </li><li>Cisco Firepower Discovery</li><li>Implementing Access Control Policies   </li><li>Security Intelligence</li><li>File Control and Advanced Malware Protection     </li><li>Next-Generation Intrusion Prevention Systems    </li><li>Network Analysis Policies</li><li>Detailed Analysis Techniques</li><li>Cisco Firepower Platform Integration</li><li>Alerting and Correlation Policies</li><li>Performing System Administration    </li><li>Troubleshooting Cisco Firepower</li></ul></div>

Certified in Cybersecurity (CC)

Cisco Certified Network Professional certification (CCNP)

Cyber Security Foundation

Cissp

CompTIA Security+

Cisco Securing Networks with Cisco Firepower Next-Generation IPS v4.0 (SSFIPS)

<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 />Network administrators<br />Network engineers with little or no programming or Python experience<br />Network managers<br />Systems engineers</p>Overview<p>After taking this course, you should be able to:<br />Create a Python script<br />Describe data types commonly used in Python coding<br />Describe Python strings and their use cases<br />Describe Python loops, conditionals, operators, and their purposes and use cases<br />Describe Python classes, methods, functions, namespaces, and scopes<br />Describe the options for Python data manipulation and storage<br />Describe Python modules and packages, their uses, and their benefits<br />Explain how to manipulate user input in Python<br />Describe error and exception management in Python<br />Describe Python code debugging methods</p><p>The Programming for Network Engineers (PRNE) v2.0 course is designed to equip you with fundamental skills in Python programming. Through a combination of lectures and lab experience in simulated network environments, you will learn to use Python basics to create useful and practical scripts with Netmiko to retrieve data and configure network devices. Upon completion of this course, you should have a basic understanding of Python, including the knowledge to create, apply, and troubleshoot simple network automation scripts.</p></div><div id="course-pills-2"><h4>Course outline</h4><ul><li>Introducing Programmability and Python for Network Engineers</li><li>Scripting with Python</li><li>Examining Python Data Types</li><li>Manipulating Strings</li><li>Describing Conditionals, Loops, and Operators</li><li>Exploring Classes, Methods, Functions, Namespaces, and Scopes</li><li>Exploring Data Storage Options</li><li>Exploring Python Modules and Packages</li><li>Gathering and Validating User Input</li><li>Analyzing Exceptions and Error Management</li><li>Examining Debugging Methods</li><li>Course Summary</li></ul><h4>Lab outline</h4><ul><li>Execute Your First Python Program</li><li>Use the Python Interactive Shell</li><li>Explore Foundation Python Data Types</li><li>Explore Complex Python Data Types</li><li>Use Standard String Operations</li><li>Use Basic Pattern Matching</li><li>Reformat MAC Addresses</li><li>Use the if-else Construct</li><li>Use for Loops</li><li>Use while Loops</li><li>Create and Use Functions</li><li>Create and Use Classes</li><li>Use the Python main() Construct</li><li>Traverse the File Structure</li><li>Read Data in Comma-Separated Values (CSV) Format</li><li>Read, Store, and Retrieve Data in XML Format</li><li>Read, Store, and Retrieve Date in JavaScript Object Notation (JSON) Format</li><li>Read, Store, and Retrieve Data in a Raw or Unstructured Format</li><li>Import Modules from the Python Standard Library</li><li>Import External Libraries</li><li>Create a Python Module</li><li>Prompt the User for Input</li><li>Use Command-Line Arguments</li><li>Manage Exceptions with the try-except Structure</li><li>Manage Exceptions with the try-except-finally Structure</li><li>Use Assertions</li><li>Use Simple Debugging Methods</li><li>Use the Python Debugger</li><li>Code a Practical Debugging Script</li></ul></div>

CompTIA Network+

NLP Practitioner

Network Engineer

Professional Skills Course (PSC)

IT Networking Fundamentals

Programming for Network Engineers (PRNE) v2.0

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is as follows:<br />Network Video Engineer<br />Voice/UC/Collaboration/Communications Engineer<br />Collaboration Tools Engineer<br />Collaboration Sales/Systems Engineer</p><p>In this 3 Day Cisco Course, students will learn how to deploy Voice Gateways/CUBE and setup Cisco Unified Communication Manager (CUCM) to deploy SIP Trunking. The course starts out with an overview of Cisco gateways and their uses. Next, students learn about MGCP and SIP and how to implement each protocol. Students will then learn how to use Cisco CUBE to connect CUCM, Gateways and Service Providers together. This course details how to connect a Cisco environment to a Service Provider using a Cisco CUBE.</p></div><div id="course-pills-2"><h4>Introduction to Voice Gateways</h4><ul><li>Cisco UC Networks and the Role of Gateways<br />Gateway Call Routing and Call Legs<br />Configuring Gateway Voice Ports<br />DSP Functionality, Codecs, and Codec Complexity<br />Router Requirements for CUBE<br />SIP Protocol Overview</li></ul><h4>Gateway Dial Plans</h4><ul><li>VoIP Call Legs<br />Dial Plan Implementation</li></ul><h4>Configuring (CUCM) Cisco Unified Communication Manager 12.5</h4><ul><li>Cisco UCM Audio Codec Preference  List<br />Cisco UCM Region Configuration<br />Device Pool Configuration<br />Annunciator Configuration<br />Conference Bridge Configuration<br />Media Termination Point Configuration<br />Music on Hold Server Configuration<br />Music on Hold Service (IP Voice Media Streaming App) Parameter Settings<br />Music on Hold Service (Duplex Streaming) Parameter Settings<br />Media Resource Group Configuration<br />Media Resource Group List Configuration<br />UC Service Configuration<br />Service Profile Configuration<br />End User Configuration<br />SIP Trunk Security Profile Configuration used by SIP trunk to Cisco UBE<br />SIP Profile Configuration used by SIP trunk to Cisco UBE<br />SIP Trunk to Cisco UBE Configuration<br />Route Pattern Configuration</li></ul><h4>Configuring Cisco Unified Border Element (CUBE)</h4><ul><li>Deploying Cisco VCUBE<br />CUCM to CUBE Integration Configuration<br />Steps to connecting to a SIP Trunk Provider<br />Interworking<br />Security and Call Admission Control<br />Media Manipulation, Enhancement &amp; Optimization<br />SIP UA<br />Translation Rules<br />VoIP Dial Peer<br />SIP Registration<br />SIP attributes of CUBE<br />Transcoding services<br />Creating and configuring Sip Trunks<br />CUBE Configuration<br />CUBE Call Flow<br />CUBE Dial-Peers Call Routing<br />CUBE Advanced Call Routing<br />Media Manipulation<br />External/PSTN Call Recording<br />Call Admission Control<br />Multiple Non-Authenticated SIP Trunks on a CUBE<br />Multiple Authenticated/Registered SIP Trunks on a CUBE</li></ul><h4>Configuring High Availability</h4><ul><li>High availability on ISR G2<br />High availability on ISR 4k<br />High availability on ASR</li></ul><h4>Cisco Unified Border Element (CUBE) Security</h4><ul><li>Five Layers of Security in CUBE<br />SIP TLS Support with SRTP</li></ul><h4>Monitoring and Troubleshooting Cisco CUBE</h4><ul><li>Dialed Number Analyzer (DNA) for CUBE<br />SIP Profile Test Tool<br />Troubleshooting<br />Serviceability</li></ul></div>

Cisco Certified Network Associate (CCNA)

Cabin Crew Initial Training & Attestation (CCA)

Cisco

ICCC-CT-Installing and Configuring Cisco Cube/Gateways

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is the first in a series of two courses designed for programmers who are new to RPG IV. Basic programming experience is required. The student should have attended at least an introductory course to programming such as one of those available at technical colleges. The student is not taught the concepts of programming. Experienced programmers who are new to the Power System with IBM i should also attend this course. Examples of other programming languages are BASIC, COBOL, or RPG II. This course focuses entirely on the features of the RPG IV Version 7 compiler and the techniques that this compiler provides. Features of V7 are discussed. Previous techniques and the maintenance of programs that are written using legacy techniques, such as fixed format calculations, are not covered in the classroom. Some additional material and the bibliography will assist the new RPG IV programmer in the maintenance of legacy applications.</p>Overview<p>Write RPG IV version 7.1 programs to produce reportsWrite simple RPG IV version 7.1 inquiry programs that interact with displaysReview compilation listing, find and correct compilation errorsMaintain existing applications written in the RPG IV Version 7.1 languageUse many popular RPG IV built-in functions</p><p>This course is a comprehensive exposure to the basic features and functions of RPG IV for Version 7.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>RPG IV introduction</li><li>Coding specifications for RPG IV</li><li>Data representation and definition</li><li>Manipulating data in calculations</li><li>Using printer and display files in an RPG IV program</li><li>Structured programming, error handling, subprocedures, and subroutines</li><li>Using arrays, data structures, and data areas</li><li>Accessing the DB2 database using RPG IV</li><li>What's next?</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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 AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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>

Programming Fundamentals

AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i

<div id="course-pills-1">Duration<p>4.125 Days</p><p>24.75 CPD hours</p>This course is intended for<p>Managers or consultants seeking to prepare and support an organization in planning, implementing, and maintaining a compliance program based on the GDPR<br />DPOs and individuals responsible for maintaining conformance with the GDPR requirements<br />Members of information security, incident management, and/or business continuity teams<br />Technical and compliance experts seeking to prepare for a data protection officer role<br />Expert advisors involved in the security of personal data</p>Overview<p>Understand the concepts of the GDPR and interpret its requirements<br />Understand the content and the correlation between the General Data Protection Regulation and other regulatory frameworks and applicable standards, such as ISO/IEC 27701 and ISO/IEC 29134<br />Develop the ability to inform, advise, and monitor compliance with the GDPR and cooperate with the supervisory authority<br />Acquire the competence to perform the role and daily tasks of the data protection officer in an organizationit</p><p>Considering that data breaches have become highly sophisticated in the recent years, the need for data protection has increased as well.Information Security is crucial to the success of any organization since it deals with the protection of sensitive data from unauthorized access, use, replication and destruction. As such, organizations should put in place measures and controls to manage and diminish Information Security risks and comply with GDPR requirements. In case organizations fail to comply with the GDPR requirements, the penalties can reach up to 2% of an organization?s annual turnover. Also, in case of more serious infringements, the penalties can amount to 4% of an organization?s annual revenue. The implementation of a Privacy Framework, on the other hand, will allow professionals to develop and implement reliable controls that are generally accepted.Becoming a Certified Data Protection Officer will enable you to acquire the necessary expertise to understand the risks that could have a negative impact on your organization and implement the required strategic responses based on the GDPR best practices, requirements and principles.</p></div><div id="course-pills-2"><h4>Introduction to the GDPR concepts and principles</h4><ul><li>Training course objectives and structure</li><li>General Data Protection Regulation (GDPR)</li><li>Core considerations for the GDPR</li></ul><h4>Designation of the DPO and analysis of the GDPR compliance program</h4><ul><li>Designation of the DPO</li><li>Analysis of the GDPR compliance program</li><li>Relationship with the top management</li><li>Data protection policy</li><li>Register of processing activities</li><li>Risk management process</li></ul><h4>DPO operations</h4><ul><li>Data protection impact assessment</li><li>Documentation management</li><li>Evaluation of the data protection controls</li><li>Data protection and technology</li><li>Awareness, training, and communication</li></ul><h4>Monitoring and continual improvement of GDPR compliance</h4><ul><li>Incident management and personal data breaches</li><li>Monitoring and measuring compliance</li><li>Data protection internal audit</li><li>Treatment of nonconformities</li><li>Continual improvement</li><li>Closing the training course</li></ul></div>

Data Protection

GDPR

Close Protection Officer Training (CPO)

Data Protection Officer

Data Protection Officer (DPO)

Certified in Data Protection (CDP)

GDPR Data Protection Officer

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

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

B6008 Overview of IBM Cognos Analytics (v11.0)

By Nexus Human

Data Wrangling with Python

By Nexus Human

Cisco Configuring Cisco ISE Essentials for SD- Access v1.0 (ISESDA)

By Nexus Human

BizTalk Server 2021 Developer Deep Dive

By Nexus Human

PRINCE2 Agile Foundation with Exam

By Nexus Human

Cisco Securing Networks with Cisco Firepower Next-Generation IPS v4.0 (SSFIPS)

By Nexus Human

Programming for Network Engineers (PRNE) v2.0

By Nexus Human

ICCC-CT-Installing and Configuring Cisco Cube/Gateways

By Nexus Human

AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i

By Nexus Human

GDPR Data Protection Officer

By Nexus Human