1232 Model courses delivered Live Online

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

Develop Big Data Pipelines with R, Sparklyr & Power BI Course Overview: This course offers a comprehensive exploration of building and managing big data pipelines using R, Sparklyr, and Power BI. Learners will gain valuable insight into the entire process, from setting up and installing the necessary tools to creating effective ETL pipelines, implementing machine learning techniques, and visualising data with Power BI. The course is designed to provide a strong foundation in data engineering, enabling learners to handle large datasets, optimise data workflows, and communicate insights clearly using visual tools. By the end of this course, learners will have the expertise to work with big data, manage ETL pipelines, and use Sparklyr and Power BI to drive data-driven decisions in various professional settings. Course Description: This course delves into the core concepts and techniques for managing big data using R, Sparklyr, and Power BI. It covers a range of topics including the setup and installation of necessary tools, building ETL pipelines with Sparklyr, applying machine learning models to big data, and using Power BI for creating powerful visualisations. Learners will explore how to extract, transform, and load large datasets, and will develop a strong understanding of big data architecture. They will also gain proficiency in visualising complex data and presenting findings effectively. The course is structured to enhance learners' problem-solving abilities and their competence in big data environments, equipping them with the skills needed to manage and interpret vast amounts of information. Develop Big Data Pipelines with R, Sparklyr & Power BI Curriculum: Module 01: Introduction Module 02: Setup and Installations Module 03: Building the Big Data ETL Pipeline with Sparklyr Module 04: Big Data Machine Learning with Sparklyr Module 05: Data Visualisation with Power BI (See full curriculum) Who is this course for? Individuals seeking to understand big data pipelines. Professionals aiming to expand their data engineering skills. Beginners with an interest in data analytics and big data tools. Anyone looking to enhance their ability to analyse and visualise data. Career Path: Data Engineer Data Analyst Data Scientist Business Intelligence Analyst Machine Learning Engineer Big Data Consultant

Counselling and Psychotherapy Course Overview This Counselling and Psychotherapy course offers an in-depth exploration of the theories, practices, and approaches within the field of therapy. Learners will gain an understanding of different therapeutic models, including cognitive-behavioural therapy and psychodynamic therapy, and learn how to apply these approaches effectively. The course provides valuable insights into the psychology of human behaviour and offers practical tools for addressing a wide range of client needs. Upon completion, learners will have a well-rounded understanding of psychotherapy techniques, the therapist-client dynamic, and the ethics surrounding the profession. This course is designed to equip learners with the essential knowledge and skills to pursue a career in psychotherapy or to enhance their current practice in a supportive capacity. Course Description This comprehensive course covers key therapeutic frameworks and explores the role of the psychotherapist in various contexts. Topics include the different types of psychotherapy, the foundations of the therapeutic relationship, and the challenges and rewards of providing therapy in diverse settings. Learners will also explore internet-based therapy and its growing role in modern mental health care. Throughout the course, participants will deepen their understanding of client needs and how to tailor approaches to suit individual cases. By the end of the course, learners will have gained essential skills for understanding and supporting clients in a professional capacity, as well as an appreciation for the ethical responsibilities and reflective practices required in the field of psychotherapy. Counselling and Psychotherapy Curriculum Module 01: Introduction to the course Module 02: Understanding Psychotherapy Module 03: Starting Psychotherapy Practice Module 04: Your Potential Clients in Therapy Module 05: Different Types of Psychotherapy Module 06: Internet Based Therapy (See full curriculum) Who is this course for? Individuals seeking to pursue a career in counselling and psychotherapy. Professionals aiming to expand their therapeutic skills in the mental health sector. Beginners with an interest in understanding psychological support methods. Anyone seeking personal development through a deeper understanding of human behaviour. Career Path Psychotherapist Counsellor Mental Health Practitioner Online Therapy Specialist Private Practice Owner Employee Assistance Programme (EAP) Therapist Social Worker Clinical Psychologist

Duration 3 Days 18 CPD hours This course is intended for Business application consultant Data Consultant / Manager Database Administrator Application developer BI specialist Overview This course will prepare you to: Understand and put into practice the main advanced modeling capabilities of SAP HANA 2.0 SPS04 in the areas of text search and analysis, graph modeling, spatial analysis and predictive modeling. Promote these advanced modeling capabilities to extend the core SAP HANA Modeling features. Broaden your experience with the modern SAP HANA tooling in XS Advanced (SAP Web IDE for SAP HANA) This course provides advanced knowledge and practical experience on several topics that are included in, or connected to, the scope of the modeler role. Its purpose is to take a step further, beyond the core modeling knowledge from HA300, and to demonstrate how applications powered by SAP HANA can benefit from innovations such as Spatial Data Storage and Processing, Text Search and Analysis, Predictive Analysis and Graph Modeling.The course is supported by many demos and exercise, which demonstrate the advanced modeling capabilities in several scenarios. For example, working with classical schemas or HDI containers in XS Advanced, using the SQL console, developing graphical models. Some of the proposed case studies blend together several modeling capabilities, such as text with spatial, or text with graph.An introduction to SAP HANA Series Data is also provided. Introduction to Advanced ModelingSAP HANA Predictive Analysis Library (PAL) Describing SAP HANA PAL Using PAL in Flowgraphs Calling PAL Functions in Calculation Views Calling PAL Procedures in SQL Scripts Exploring the PAL Library SAP HANA Spatial Introducing SAP HANA Spatial Working with Spatial Data Types Importing and Exporting Spatial Data Accessing and Manipulating Spatial Data Using Spatial Clustering SAP HANA Graph Defining SAP HANA Graph Workspace Describing the Different Graph Algorithms Using the Graph Node in Calculation Views Using GraphScript Procedures SAP HANA Text Understanding Full Text Search Understanding Text Analysis Understanding Text Mining SAP HANA Series Data Getting Started with SAP HANA Series Data

Build- to- rent involves the construction of purpose- built residential buildings with the intention of renting out the units for the long term, rather than selling the individually. On this webinar, we will introduce the concept of Build-to-rent (BtR) and explore the key features, including design considerations, financial models and management strategies. We will also discuss the benefits of BTR investors, tenants, and communities as well as potential challenges and risk associated with this type of investment.

One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including: - How you can communicate your education and modules studied effectively with employers - Tips to make your CV stand out - The industry apprenticeships available - Relevant internships on offer - The university sandwich year placements there are - Courses you can take to get a better understanding of the sector

Duration 5 Days 30 CPD hours This course is intended for This course is designed for EDI End Users, Connect: End Users, Web Developers, as well as System Administrators. Overview After completing this course, students should be able to: Run a business process. Create a business process using the Graphical Process Modeler. Explain how to create a service configuration. Explain how to track an executable business process. Discuss the basics of Sterling B2B Integrator. This course provides students with a detailed examination of Sterling B2B Integrator, which provides end-to-end enterprise integration server for dynamic real-time and near-real time business collaboration and commerce automation.This course teaches students techniques, tools and recommended practices that can be used to run a business process, create a business process using the Graphical Process Modeler, explain how to create a service configuration, explain how to track an executable business process, and discuss the basics of Sterling B2B Integrator through a combination of lecture and hands-on labs. About IBM Sterling B2B Integrator Exercise. About Sterling B2B Integrator Basic BPML Concepts Exercise. Basic BPML Concepts XPath Basics Exercise. XPath Basics Graphical Process Modeler (GPM) Exercise. Graphical Process Modeler (GPM) Using the GPM Exercise. Using the GPM Troubleshooting a Business Process Exercise. Troubleshooting a Business Process Introduction to Service Management Exercise. Introduction to Service Management Case Study Sterling B2B Integrator Mapping Exercise. Sterling B2B Integrator Mapping Typing Map Exercise. Typing Map Tracking System Health Exercise. Tracking System Health Best Practices Exercise. Best Practices Case Study Course Wrap Up

Overview 2 day applied course with comprehensive case studies covering both Standardized Approach (SA) and Internal Models Approach (IMA). This course is for anyone interested in understanding practical examples of how the sensitivities-based method is applied and how internal models for SES and DRC are built. Who the course is for Traders and heads of trading desks Market risk management and quant staff Regulators Capital management staff within ALM function Internal audit and finance staff Bank investors – shareholders and creditors Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 1 day course on IFRS 9 expected credit loss modelling, both for financial statement and capital stress testing purposes Who the course is for Credit risk management Quants ALM staff Finance Internal audit External auditors Bank investors – equity and credit investors Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview This is a 2 day applied course on XVA for anyone interested in going beyond merely a conceptual understanding of XVA and wants practical examples of Monte Carlo simulation of market risk factors to create exposure distributions and profiles for derivatives used for XVA pricing Learn how to do Monte Carlo simulation of key market risk factors across major asset classes to create exposure distributions and profiles (with and without collateral) for derivatives used for XVA pricing. Learn how to calculate each XVA. Learn sensitivities of each XVA and how XVA desks manage these. Learn regulatory capital treatment of counterparty credit risk (both for CCR and CVA volatility) and how to stress test this within ICAAP or system-wide external, supervisor-led capital stress test. Who the course is for Anyone involved in OTC derivatives XVA traders XVA quants Derivatives traders and salespeople Risk management Treasury staff Internal audit and finance Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now