<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Data platform engineers<br />Database administrators<br />Solutions architects<br />IT professionals</p>Overview<p>Apply database concepts, database management, and data modeling techniques<br />Evaluate hosting databases on Amazon EC2 instances<br />Evaluate relational database services (Amazon RDS, Amazon Aurora, and Amazon Redshift) and their features<br />Evaluate nonrelational database services (Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB) and their features<br />Examine how the design criteria apply to each service<br />Apply management principles based on the unique features of each service</p><p>This course will teach you the process of planning and designing both relational and nonrelational database and the planning and design requirements of all 8 of the AWS databases services, their pros and cons, and how to know which AWS databases service is right for your workloads.</p></div><div id="course-pills-2"><h4>Day 1</h4><ul><li>Module 0: Planning and Designing Databases on AWS</li><li>Module 1: Database Concepts and General Guidelines</li><li>Module 2: Database Planning and Design</li><li>Module 3: Databases on Amazon EC2</li><li>Module 4: Purpose-Built Databases</li><li>Module 5: Databases on Amazon RDS</li><li>Databases in Amazon Aurora</li></ul><h4>Day 2</h4><ul><li>Module 6: Databases in Amazon Aurora (continued)</li><li>Module 7: Databases in Amazon DocumentDB (with MongoDB compatibility)</li><li>Module 8: Amazon DynamoDB Tables</li></ul><h4>Day 3</h4><ul><li>Module 9: Databases in Amazon Neptune</li><li>Module 10: Databases in Amazon Quantum Ledger Database (Amazon QLDB)</li><li>Module 11: Databases in Amazon ElastiCache</li><li>Module 12: Data Warehousing in Amazon Redshift</li><li>Module 13: Course Review</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Planning and Designing Databases on AWS 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 Planning and Designing Databases on AWS course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Service Design Courses (SDC)

AWS Certified Developer

AWS Certified Database

AWS Certified Cloud Practitioner

Trainers Course

AWS Certified Solutions Architect

Planning and Designing Databases on AWS

<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 React development course for web developers.</p>Overview<p>Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore:<br />A basic and advanced understanding of React components<br />An advanced, in-depth knowledge of how React works<br />A complete understanding of using Redux<br />How to build, validate, and populate interactive forms<br />How to use inline styles for perfect looking components<br />How to test React components<br />How to build and use components<br />How to get control of your build process</p><p>Introduction to React | React Basics is a three-day hands-on course designed to get students quickly up and running with Core React skills. Geared for more experienced web developers new to React, this course provides students with the core knowledge and hands-on skills they require to build reliable, powerful React apps.Throughought the course students will explore React fundamentals with a progressive, example-driven approach. You?ll create your first apps, learn how to write components, start handling user interaction, and manage rich forms. We end the first part by exploring the inner workings of Create React App (Facebook?s tool for running React apps), and building a multi-page app that uses client-side routing.Every project in this course was built using Create React App. Create React App is based on Webpack, a tool which helps process and bundle our various JavaScript, CSS, HTML, and image files. We explore Create React App in-depth in the module ?Using Webpack with Create React App.?Students will build Single Page Applications (SPA), create robust routing with error handling, and both class and functional reusable components.The lab project will also include the use of form validation.NOTE: This is a foundational course that explores how to build your first React application. Students who want a deeper dive, withmore intermediate level topics such as Redux, REST, Unit Testing and more might consider the TT4195 Mastering React five-daysuperset of this class as an alternative.</p></div><div id="course-pills-2"><h4>ES6 Primer                                               </h4><ul><li>Prefer const and let over var                                </li><li>Arrow functions                                               </li><li>Modules                                                     </li><li>Object.assign()                                               </li><li>Template literals                                                </li><li>The spread operator and Rest parameters                                        </li><li>Enhanced object literals                                           </li><li>Default arguments                                             </li><li>Destructuring assignments</li></ul><h4>Your First React Web Application  </h4><ul><li>Setting up your development environment                              </li><li>JavaScript ES6 /ES7                                                </li><li>What?s a component?                                              </li><li>Building The App                                                 </li><li>Making The App data-driven                                          </li><li>Your app?s first interaction   </li></ul><h4>JSX and the Virtual DOM </h4><ul><li>React Uses a Virtual DOM                                            </li><li>Why Not Modify the Actual DOM?                                       </li><li>What is a Virtual DOM?                                             </li><li>Virtual DOM Pieces                                                </li><li>ReactElement                                                   </li><li>JSX </li></ul></div>

React JS

Online Course Creation

Next.js

React Events

React Native

Getting Started with React | Introduction to React Basics (TT4190)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive, and exporting content to other file formats.</p>Overview<p>In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.<br />You will:<br />Navigate and customize the OneNote interface and environment.<br />Add and format text, images, audio, links, and drawing objects to a notebook.<br />Embed Excel spreadsheets and attach other files to a notebook.<br />Categorize, organize, and search notebook content.<br />Check spelling in, print, and password-protect notebooks.<br />Use Outlook and OneDrive to send and share notebook content.<br />Export notebook content and manage notebook history and backups.</p><p>In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. MicrosoftÂ© Office OneNoteÂ© for the Desktop provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office.<br />This courseware is applicable to all users of the current OneNote desktop software. The classroom environment setup is based on the Office 2016 desktop application.<br /></p></div><div id="course-pills-2"><h4>Getting Started with OneNote</h4><ul><li>Topic A: Navigate the OneNote 2016 Environment</li><li>Topic B: Use Templates</li><li>Topic C: Customize the OneNote User Interface</li></ul><h4>Adding and Formatting Notebook Content</h4><ul><li>Topic A: Apply Formatting to Notebook Content<br />Topic B: Insert Images and Audio into a Notebook<br />Topic C: Add Quick Notes and Links<br />Topic D: Use Drawing Tools</li></ul><h4>Embedding and Attaching Files</h4><ul><li>Topic A: Embed Excel Spreadsheets<br />Topic B: Attach Other File Types</li></ul><h4>Organizing and Searching Notebooks</h4><ul><li>Topic A: Use Tags<br />Topic B: Organize and Search Notebooks</li></ul><h4>Finalizing a Notebook</h4><ul><li>Topic A: Proof and Print a Notebook</li><li>Topic B: Configure Password Protection and Notebook Properties</li></ul><h4>Managing Notebook Files</h4><ul><li>Topic A: Export Content from OneNote Notebooks</li><li>Topic B: Back Up and Restore Notebook Content</li></ul><h4>Sending and Sharing OneNote Content</h4><ul><li>Topic A: Send OneNote Content in Other Formats<br />Topic B: Share OneNote Content by Using OneDrive</li></ul></div>

Office Skills & Productivity

Microsoft Onenote

Office Skills

Office Productivity

Microsoft Office

Microsoft Onedrive

Microsoft OneNote for the Desktop

<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 are Application Consultants, Developers, Developer Consultants, and Technology Consultants.</p>Overview<p>Define Data ServicesDefine Source and Target ConnectionsTrace, Validate, and Debug Data Services JobsUse Data Services TransformsImplement Change Data Capture in Data Services</p><p>In this course, students will learn how to define data services, source, and target connections, as well as use data services transforms and implement change in data capture within data services.</p></div><div id="course-pills-2"><h4>Data Services</h4><ul><li>Defining Data Services</li></ul><h4>Source and Target Metadata</h4><ul><li>Defining Datastores in Data Services</li><li>Defining a Data Services Flat File Format</li></ul><h4>Batch Job Creation</h4><ul><li>Creating Batch Jobs</li></ul><h4>Batch Job Troubleshooting</h4><ul><li>Writing Comments with Descriptions and Annotations</li><li>Validating and Tracing Jobs</li><li>Debugging Data Flows</li><li>Auditing Data Flows</li></ul><h4>Functions, Scripts, and Variables</h4><ul><li>Using Built-In Functions</li><li>Using Variables, Parameters, and Scripts</li></ul><h4>Platform Transforms</h4><ul><li>Using Platform Transforms</li><li>Using the Map Operation Transform</li><li>Using the Validation Transform</li><li>Using the Merge Transform</li><li>Using the Case Transform</li><li>Using the SQL Transform</li></ul><h4>Error Handling</h4><ul><li>Setting Up Error Handling</li></ul><h4>Changes in Data</h4><ul><li>Capturing Changes in Data</li><li>Using Source-Based Change Data Capture (CDC)</li><li>Using Target-Based Change Data Capture (CDC)</li></ul><h4>Data Services (Integrator) Platform Transforms</h4><ul><li>Using Data Services (Integrator) Platform Transforms</li><li>Using the Pivot Transform</li><li>Using the Data Transfer Transform</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DS10 SAP Data Services - Platform and Transforms 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 DS10 SAP Data Services - Platform and Transforms 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>

SAP Project

Data Skills

SAP Sales & Distribution

DS10 SAP Data Services - Platform and Transforms

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Individuals preparing for the Cisco Customer Success ManagerSpecialist certification<br />Individuals who have experience working with customers to determine, measure, and deliver business outcomes through the implementation of technology</p>Overview<p>After taking this course, you should be able to:<br />Describe the role of the Customer Success Manager<br />Describe the tools that the Customer Success Manager uses to ensure customer experience<br />Describe the lifecycle approach to customer experience</p><p>The Cisco Customer Success Manager (DTCSM) v2.2 course gives you the confidence and competence to fulfill the Customer Success Manager (CSM) role successfully, helping your customers realize value from their solutions and achieve their business outcomes. The course offers experiential learning through practical exercises using situations based on real-life use cases and case studies. In this highly interactive course, you can practice and gain confidence in fulfilling core tasks using best-practice tools and methodologies while receiving feedback from the facilitator and your peers.This course is based on understanding the customer lifecycle and how to optimize that journey, increasing the value realized by the customer, and maximizing your likelihood to maintain their loyalty and renew or expand their business opportunities. The course helps you prepare for the 820-605 Cisco Customer Success Manager (CSM) exam. By passing this exam, you earn the Cisco Customer Success Manager Specialist certification.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Transition to Subscription Economy</li><li>Customer and Industry Trends</li><li>Defining Customer Success and the CSM Role</li><li>Engaging the Customer for Success</li><li>Engaging the Customer for Success</li><li>Addressing Barriers</li><li>Customer Success Management Activities</li><li>Success Plan Elements</li><li>Customer Success Management Activities</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Customer Success Manager v2.2 (DTCSM) 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 Customer Success Manager v2.2 (DTCSM) 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>

Certified ScrumMaster (CSM)

Certified Technology Specialist (CTS)

Customer Success (CS)

Commercial & Contract Management Certification Program (CCM)

Microsoft Certified Trainer (MCT)

Cisco Customer Success Manager v2.2 (DTCSM)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is recommended for technical professionals who perform advanced deployment configurations of Check Point products.</p>Overview<p>Provide an overview of the upgrade service and options available.<br />Explain how to perform management upgrade and migration.<br />Articulate the process using CPUSE features.<br />Articulate the purpose and function of Management High Availability.<br />Explain Primary vs Secondary, Active vs Standby and Synchronization.<br />Explain disaster recovery steps in case the primary management server becomes unavailable.<br />Provide overview of Central Deployment in SmartConsole.<br />Articulate an understanding of Security Gateway cluster upgrade methods.<br />Explain about Multi Version Cluster (MVC) upgrades.<br />Discuss Gaia Commands and how they are used.<br />Explain the main processes on s and s.<br />Describe how to work with scripts and SmartTasks to configure automatic actions.<br />Explain the Management Data Plane Separation (MDPS)<br />Explain kernel operations and traffic flow<br />Articulate Dynamic and Updatable Objects in Security Gateways<br />Explain the policy installation flow and files used.<br />Describe the use of policy installation history.<br />Explain concurrent and accelerated install policy.<br />Describe an overview of APIs and ways to use and authenticate.<br />Explain how to make changes in GAIA and management configuration.<br />Explain how to install policy using API.<br />Explain how the SecureXL acceleration technology enhances and optimizes Security Gateway performance.<br />Describe how the CoreXL acceleration technology enhances and improves Security Gateway performance.<br />Articulate how utilizing multiple traffic queues can make traffic handling more efficient.<br />Discuss Site-to-Site VPN basics, deployment and communities.<br />Describe how to analyze and interpret VPN tunnel traffic.<br />Explain Link Selection and ISP Redundancy options.<br />Explain tunnel management features.<br />Discuss Check Point Remote Access solutions and how they differ from each other.<br />Describe how client security can be provided by Remote Access .<br />Explain authentication methods including machine authentication.<br />Explain Multiple Entry Point (MEP).<br />Discuss the Mobile Access Software Blade and how it secures communication and data exchange during remote connections.</p><p>Learn basic concepts and develop skills necessary to administer IT security fundamental tasks.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Prepare for a Security Management Server Upgrade</li><li>Upgrade the Security Management Server</li><li>Deploy a Secondary Security Management Server</li><li>Configure a Distributed Log Server</li><li>Upgrade a Security Gateway from SmartConsole</li><li>Work with the Command Line</li><li>Use Scripts and SmartTasks</li><li>Configure Dynamic Objects</li><li>Monitor Traffic</li><li>Verify Policy Installation and Status</li><li>Work with Gaia and Management APIs</li><li>Work with Acceleration Features</li><li>Configure a Locally Managed Site to Site VPN</li><li>Configure a Site to Site VPN with an Interoperable Device</li><li>Configure Remote Access VPN</li><li>Configure Mobile Access VPN</li><li>Configure a High Availability Cluster</li><li>Work with ClusterXL</li><li>Configure Policy Compliance</li><li>Deploy SmartEvent</li></ul></div>

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Certified Cloud Security Professional (CCSP)

Security Management

Certified Cyber Professional (CCP)

CompTIA Security+

CCSE Check Point Certified Security Expert

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This class is ideal for admins with at least 6 months of experience administering Salesforce, and is a great foundational course for anyone looking to earn their Salesforce Advanced Administrator credential.</p>Overview<p>Determine and implement appropriate data access and visibility settings.<br />Manage configuration changes in a sandbox environment and move metadata between environments using change sets.<br />Extend the functionality of your implementation with custom objects and apps.<br />Extend your reporting to provide up-to-date views of your business.<br />Customize the Salesforce mobile app and create quick actions to increase efficiency.<br />Improve data quality so that the ongoing task of data maintenance is not so overwhelming.<br />Implement complex business processes using workflow rules, Process Builder, approval processes, and flows.</p><p>Take your Salesforce Administrator skills to the next level and supercharge your knowledge to solve pressing business needs. In this 4-day class, discover how to extend Salesforce with custom objects and Lightning apps, generate complex reports and dashboards, and automate complex business requirements to work more efficiently. Our Salesforce experts will share tips and best practices to take your admin skills to the next level and arm you with the skills to get more out of Salesforce.</p></div><div id="course-pills-2"><h4>Record Access and Field Visibility</h4><ul><li>Troubleshoot Record Access</li><li>Understand the Impact of Territory Management on the Sharing Model </li><li>Manage Field Visibility</li></ul><h4>Change Management</h4><ul><li>Manage Changes in a Sandbox</li><li>Deploy Changes Using Change Sets</li></ul><h4>Custom Objects and Apps</h4><ul><li>Build Custom Objects, Tabs, and Apps </li><li>Create Relationships Between Objects</li><li>Use Delegated Administration</li></ul><h4>Advanced Reporting</h4><ul><li>Create Custom Report Types</li><li>Build Exception Reports with Cross Filters</li><li>Categorize Report Data with Bucketing</li><li>Extend Summaries in Reports and Dashboards</li><li>Display Multiple Views of Data Using Joined Reports</li><li>Analyze Data Over Time with Historical Trending and Reporting Snapshots</li></ul><h4>Salesforce Mobile App and Quick Actions</h4><ul><li>Customize the Salesforce Mobile App</li><li>Create Object-Specific Quick Actions</li><li>Create Global Quick Actions</li></ul><h4>Data Quality</h4><ul><li>Assess, Cleanse, and Maintain Data </li><li>Prevent Duplicate Records Using Duplicate Management</li></ul><h4>Automated Business Processes </h4><ul><li>Use Validation Rules, Formula Fields, Workflow Rules, and Process Builder to Enforce and Automate Business Processes </li></ul><h4>Approval Processes</h4><ul><li>Manage Approval Processes</li><li>Troubleshoot Approval Processes</li></ul><h4>Visual Workflow</h4><ul><li>Understand Use Cases for Visual Workflow</li><li>Build and Deploy a Flow</li></ul><h4>Advanced Business Process Automation</h4><ul><li>Understand When to Use Apex and Visualforce for Extending Business Process Automation </li><li>Understand the Order of Execution for Automated Processes </li><li>Use Debug Logs to Troubleshoot Business Process Issues</li></ul></div>

Salesforce Associate

Certified SAFe Agilist

Salesforce Certified JavaScript Developer

Sales Management

Salesforce

Salesforce Certified Marketing Cloud Email Specialist

Salesforce Administer, Extend, and Automate Salesforce (ADX211)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This intermediate course is for Business and Technical Specialist working with the Matching, Linking, and Search services of InfoSphere MDM Virtual module.</p>Overview<p> Understand how Matching and Linking work for both the Virtual Implementations of InfoSphere MDM<br />Understand the MDM configuration project and database tables used by the PME<br />Understand the PME Algorithms (Standardization, Bucketing and Comparison steps) and how to create and customize the algorithms using the workbench<br />Understand how to analyze the Bucketing steps in an algorithm<br />Understand how to generate weights for a given algorithm and how those weights are generated based on a sample database set<br />Understand how to analyze the weights that are generated using the workbench<br />Understand how to deploy the PME configuration for the Virtual implementations of InfoSphere MDM</p><p>The InfoSphere MDM Virtual Module Algorithms V.11 course prepares students to work with and customize the algorithm configurations deployed to the InfoSphere MDM Probabilistic Matching Engine (PME) for Virtual MDM implementations.</p></div><div id="course-pills-2"><h4>PME and Virtual Overview</h4><ul><li>Virtual MDM Overview<br />Terminology (Source, Entity, Member, Attributes)<br />PME and Virtual MDM ( Algorithms, Weights, Comparison Scores, Thresholds)<br />Virtual MDM Linkages and Tasks </li></ul><h4>Virtual MDM Algorithms</h4><ul><li>Standardization<br />Bucketing<br />Comparison Functions</li></ul><h4>Virtual PME Data Model</h4><ul><li>Algorithm configuration tables<br />Member Derived Data<br />Bucketing Data</li></ul><h4>Bucket Analysis</h4><ul><li>Analysis Overview<br />Attribute Completeness<br />Bucket Analysis</li></ul><h4>Weights</h4><ul><li>Weights Overview (Frequency-based weights, Edit Distance weights and Parameterize weights)<br />The weight formula<br />Running weight generation<br />Analyzing weights<br />Bulk Cross Match process<br />Pair Manager<br />Threshold calculations</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11 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 ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11 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>

Microsoft Virtual Academy (MVA)

IMS Productivity Analyst

IBM MQ

Oracle 1Z0-819

ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11

<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 />IT Staff and Managers<br />Network and systems personnel and engineers<br />Small to mid-sized organizations that require fundamental knowledge on networking terms/concepts and configuration guidance for Meraki equipment.<br />This also includes organizations looking to implement remote sites, provide a guest wireless solution, and collect user analytics.</p>Overview<p>Following completion of this course, students will understand, Install, Configure, Monitor, and Troubleshoot the following:<br />Navigate and Configure the dashboard<br />Add MX/MR/MS/MV devices to the Dashboard<br />Understand and Configure Configuration Templates<br />Understand and Configure Group Policies<br />Manage/Configure/Integrate Users and Radius Policies<br />Configure, Monitor, and Troubleshoot MR Access Points<br />Monitor Meraki Network Health<br />Troubleshoot devices and Connectivity</p><p>This 3-day Cisco course provide students with the skills to configure, optimize, and troubleshoot a Cisco Meraki solution. Students will learn how to install and optimize Meraki MR Access Points. Students will also learn how to configure the Meraki Dashboard, troubleshoot and configure the Meraki environment and learn how to diagnose and resolve user and Network issues that may arise.</p></div><div id="course-pills-2"><h4>Introduction to Meraki</h4><ul><li>The Meraki Mission<br />Cisco Meraki: Bringing the Cloud to Enterprise Networks<br />Cloud-Managed Networking Architecture<br />Benefits of a Cloud-Based Solution<br />The Meraki Full Stack: New and Unique Value Proposition<br />Meraki Deployment ? How it works<br />Why Customers Choose Meraki<br />Meraki MS Switches Overview<br />Meraki MX Security Appliances Overview<br />Meraki SD-WAN Overview<br />Meraki MR Wireless Access Points Overview<br />Cisco Meraki Systems Manager Overview<br />Cisco Meraki MV Vision Security Cameras Overview<br />Meraki API Overview<br />Meraki Licensing<br />Enterprise Support<br />Cisco Meraki Documentation</li></ul><h4>Cloud Management with the Meraki Dashboard</h4><ul><li>The Meraki Dashboard<br />Dashboard: Organizational Structure<br />Out-of-band Cloud Management<br />Loss of Connectivity to the Cisco Meraki Cloud<br />Meraki Dashboard Logins<br />Create Dashboard Accounts and Organization<br />MSP Logins - Manage Multiple Organizations<br />Modify an Organization<br />View Organizations Health<br />Meraki Dashboard Best Practices<br />Dashboard Search<br />Meraki Help<br />Organizational Wide Settings<br />Configure<br />Monitor<br />Create and Manage Configuration Templates<br />Network-Wide Settings<br />Configure</li></ul><h4>Meraki MR Wireless</h4><ul><li>Meraki MR Wireless Overview<br />Meraki 2.5G Multigigabit (MGig) Wireless<br />Meraki Mesh Routing<br />Meraki?s solution for RF Environments<br />Securing Guest Wireless<br />Bluetooth Integrated Analytics<br />Meraki Location Heatmap<br />High Density Wireless <br />Zero-Touch Provisioning for Wireless<br />Dedicated Scanning Radio for Rouges and Interference<br />Mounting indoor and Outdoor Antennas<br />Meraki MR Licensing<br />IEEE 802.11 Wireless LAN Standards<br />Site Survey &amp; Design for ensuring connectivity and user experience<br />Meraki AP Models Overview<br />Configuring Meraki APs<br />Configuring SSIDs<br />Firewall &amp; Traffic Shaping Configuration for Wireless<br />Monitoring Meraki APs<br />Trouble Shooting</li></ul></div>

Microsoft Certification

Cisco Certified Network Associate (CCNA)

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

ICM-WA-CT-Installing and Configuring Meraki MR Wireless Aps

<div id="course-pills-1">Duration<p>3.5 Days</p><p>21 CPD hours</p>This course is intended for<p>This course is aimed at students new to the language who may or may not have experience with other programming languages.</p>Overview<p>Learn how Python works and what it's good for.<br />Understand Python's place in the world of programming languages<br />Learn to work with and manipulate strings in Python.<br />Learn to perform math operations with Python.<br />Learn to work with Python sequences: lists, arrays, dictionaries, and sets.<br />Learn to collect user input and output results.<br />Learn flow control processing in Python.<br />Learn to write to and read from files using Python.<br />Learn to write functions in Python.<br />Learn to handle exceptions in Python.<br />Learn to work with dates and times in Python.</p><p>In this Python training course by Webucator, Inc, students learn to program in Python.</p></div><div id="course-pills-2"><h4>Python Basics</h4><ul><li>Running Python</li><li>Hello, World!</li><li>Literals</li><li>Python Comments</li><li>Data Types</li><li>Variables</li><li>Writing a Python Module</li><li>print() Function</li><li>Named Arguments</li><li>Collecting User Input</li><li>Getting Help</li></ul><h4>Functions and Modules</h4><ul><li>Defining Functions</li><li>Variable Scope</li><li>Global Variables</li><li>Function Parameters</li><li>Returning Values</li><li>Importing Modules</li></ul><h4>Math</h4><ul><li>Arithmetic Operators</li><li>Modulus and Floor Division</li><li>Assignment Operators</li><li>Built-in Math Functions</li><li>The math Module</li><li>The random Module</li><li>Seeding</li></ul><h4>Python Strings</h4><ul><li>Quotation Marks and Special Characters</li><li>String Indexing</li><li>Slicing Strings</li><li>Concatenation and Repetition</li><li>Common String Methods</li><li>String Formatting</li><li>Built-in String Functions</li><li></li></ul><h4>Iterables: Sequences, Dictionaries, and Sets</h4><ul><li>Definitions</li><li>Sequences</li><li>Unpacking Sequences</li><li>Dictionaries</li><li>The len() Function</li><li>Sets</li><li>*args and **kwargs</li></ul><h4>Flow Control</h4><ul><li>Conditional Statements</li><li>The is and is not Operators</li><li>Python's Ternary Operator</li><li>Loops in Python</li><li>The enumerate() Function</li><li>Generators</li><li>List Comprehensions</li></ul><h4>File Processing</h4><ul><li>Opening Files</li><li>The os and os.path Modules</li></ul><h4>Exception Handling</h4><ul><li>Wildcard except Clauses</li><li>Getting Information on Exceptions</li><li>The else Clause</li><li>The finally Clause</li><li>Using Exceptions for Flow Control</li><li>Exception Hierarchy</li><li></li></ul><h4>Dates and Times</h4><ul><li>Understanding Time</li><li>The time Module</li><li>The datetime Module</li></ul><h4>Running Python Scripts from the Command Line</h4><ul><li>The sys Module</li><li>sys.argv</li></ul></div>

Programming Fundamentals

Computer Programming

Python

Python Scripting

Python Introduction

Cambridge

Research Quality Association

Quality Assurance for Good Laboratory Practice

RQA Member

Non Member

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

General Admission

Virtual



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


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


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


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


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


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


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


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


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


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


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


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


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

Property Investment

Financial Analysis

Microsoft Excel

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

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

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

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



AB Health Group

Anaphylaxis

Immunisation & Vaccination

Immunisation

Health & Wellbeing

General Health

Medical Training

Vaccination

Public Health

Occupational Health Immunisation Update - Webinar

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

Microsoft Power Apps

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>

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

Planning and Designing Databases on AWS

By Nexus Human

Getting Started with React | Introduction to React Basics (TT4190)

By Nexus Human

Microsoft OneNote for the Desktop

By Nexus Human

DS10 SAP Data Services - Platform and Transforms

By Nexus Human

Cisco Customer Success Manager v2.2 (DTCSM)

By Nexus Human

CCSE Check Point Certified Security Expert

By Nexus Human

Salesforce Administer, Extend, and Automate Salesforce (ADX211)

By Nexus Human

ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11

By Nexus Human

ICM-WA-CT-Installing and Configuring Meraki MR Wireless Aps

By Nexus Human

Python Introduction

By Nexus Human