1771 Master courses delivered Live Online

This masterclass will help develop your confidence and knowledge in identifying and managing complex safeguarding issues.

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. 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.

Board members face a huge amount of information and review before the board meeting. Here is step-by-step process for mastering your board meeting prep challenge.

Immerse yourself in the ancient practice of yoga, a transformative journey that extends far beyond the mere physical postures. Our comprehensive yoga sessions are meticulously curated and led by seasoned professionals, offering a serene sanctuary tailored for the demands of modern-day professionals yearning for holistic balance and wellness. Delve into innate human abilities such as intuition, telepathy, clairvoyance, lucid dreaming, and energy healing. Uncover these dormant gifts existing within and enjoy awakening them fully.

This Level 4 course encourages individuals in digital and technical roles to enhance their skills by exploring different techniques, formats, and tools to communicate and understand the impact of their communication choices.

This Level 4 practitioner award encourages individuals in or working towards a leadership role (this could be an IT or technical based-role), and you want to demonstrate modern leadership behaviours to nurture a high-performing team, especially during a time of organisational change.

SAP SD Training SAP SD (Sales & Distribution) module is a logistics module part which is a very important component of the SAP Business suite. SAP SD module empowers you to manage customer relationship starting from raising a quotation to sales order and billing of the product or service. This module is highly linked to other SAP modules like SAP Material Management and PP (Production Planning). Powered with an understanding and knowledge of the comprehensive functionality in SAP SD, you can easily manage the entire customer life cycle efficiently and intelligently. SAP SD Introductions and Master Data Document Types for Pre sales and Sales Documents Pricing Process and Determination Sales Cycles - sales processes Free goods Processing Revenue Account Determination SD Basic Functions Special Sales - Special Processes Invoicing Plan Variant Configuration Special Sales- Special Processes Case Study - business case Integration with Other Modules and support

Duration 3 Days 18 CPD hours This course is intended for Ideal candidates are Network Administrators who monitor and troubleshoot wireless networks, and Network and System Administrators responsible for installing and configuring network monitoring systems. Overview This hands-on course prepares you with the knowledge and experience required to install and use the AirWave Wireless Management Suite: AirWave Management Platform (AMP), RAPIDS, Visual RF, network health diagnostics, client troubleshooting, alerts and reporting.  In this course, you learn about AirWave?s capabilities in troubleshooting network health and client status via the various stages of association and authentication, as well as redundancy and master consoles for large networks. Introduction to AWMS Airwave Platform. Features and Benefits of AMP RAPIDS and Visual RF. Airwave products. Basic operations using AWMS Installing AWMS Installing AMP. Hardware requirements. Cent OS and AWMS software. Basic configuration steps. Upgrade AWMS software. Licensing AWMS. AWMS documentation Adding Device to AWMS Folders and Groups. Adding devices general process. Manually adding devices. Device discovery and managing device discovery. Moving a device to a folder. Troubleshooting IAP Organizaion and Groups Overview of IAP.Airwave integration. Golden configuration. IAP Organization options. IAP Whitelist Using Visual RF and Visual RF Plan Navigation. Setup. Heat-maps and location information. Import floorplan graphics. Plan deployments. Provision APs. Manage Visual RF performance Network Health Diagnostics page indicators. Network performance tabs. Source of issues. Network issues Troubleshooting Clients and Wireless Networks Searching for users and Diagnostics tab. Client issues. Network issues. AP issues. Switch/Controller issues. General Issues Rogue Detection and Using RAPIDS Why use RAPIDS. Threat Detection Methods. Rules. Classifications. IDS Events Report. New Rogue Devices Report. Visualization. PCI Compliance.WMS Offload Managing Administrative Access, Alerts, Triggers and Reporting Configure role-based administrative use access to the AMP system. Triggers. Alerts. Define and generate reports Scalability and Redundancy VM Redundancy. Failover for Redundancy. Master Console for large deployments. Multiple AMP Server deployments. Large Deployment example System Administration AMP Maintenance. Device Maintenance Wired Device Management Monitoring wired devices in AWMS. Wired device port and interface information. Wired device bandwith statistics and counters. Managing and configuring wired devices via AWMS templates AirWave Aruba Groups How AWMS configures devices. Using groups to control policies. Creating and controlling groups. Basic Group Design.Configuration Audits IAP Template Configuration Fetching a Template. Template Variables. Templates Configuration IAP GUI Configuration Golden configuration. GUI mode. GUI configuration Additional course details: Nexus Humans Managing Campus Networks with Aruba AirWave, Rev. 19.21 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Managing Campus Networks with Aruba AirWave, Rev. 19.21 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. 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.

SAP CRM Training Online SAP CRM (Customer Relationship Management) module empowers you to manage all of your customer-related data and contacts. In SAP CRM training course you will learn how to leverage functionality for the full spectrum of CRM processes including sales, service, marketing, and operations. Powered with an understanding and knowledge of the comprehensive functionality in SAP CRM, you can easily manage the entire customer life cycle efficiently and intelligently. SAP CRM is one of the significant part of SAP Business Suite to manage customer relationship. It supports all customer-focused business areas such as marketing, sales and service. A component of SAP CRM, CRM Analytics, enables organizations to gather all relevant information about various key factors such as a customer and analyse the knowledge base to incorporate insights into operational processes and helps in strategic decision-making. SAP CRM Basic Functions and Master Data SAP CRM Sales, Marketing, Services and Middleware SAP CRM WORKSHOP/Project orientation Training

Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - Accessing & Preparing data Data Set Power BI Desktop Power BI Desktop ? Accessing Data Power BI Desktop ? Data Preparation 2 - Data Modeling and Exploration Power BI Desktop ? Data Modeling and Exploration Power BI Desktop ? Data Exploration Continued References 3 - Data Visualization Power BI Desktop Power BI Desktop ? Data Visualization References 4 - Publishing & Accessing Reports Power BI Desktop ? Creating Mobile View Power BI Service Power BI Service ? Publishing Report Power BI Mobile ? Accessing Report on Mobile Device Power BI Service ? Collaboration and Distribution References 5 - Dashboard and Collaboration Power BI Service Building Dashboard References Additional course details: Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Power BI: Dashboard in a Day 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. 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.