• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4633 Security courses in Whetstone delivered Online

Paramedic Training

By Compete High

🚑 Introducing Paramedic Training: Your Gateway to a Rewarding Career in Healthcare! Are you ready to embark on a journey that not only saves lives but also enriches your own in countless ways? Look no further! Our Paramedic Training course is your passport to a fulfilling career in emergency medical services. 🌟   🔍 Unlocking the Door to Lifesaving Skills: In our comprehensive Paramedic Training course, you'll delve into the essential skills and knowledge needed to respond to medical emergencies with confidence and competence. From mastering advanced life support techniques to effectively managing trauma situations, this course equips you with the tools to make a real difference in critical moments. 💪   📚 What You'll Learn: Throughout this program, you'll explore a wide range of topics including patient assessment, pharmacology, medical procedures, and emergency vehicle operations. Our expert instructors will guide you through hands-on simulations and interactive lectures, ensuring you're prepared to handle any situation that comes your way in the field. 🎓   🌟 Benefits of Our Paramedic Training Course: Career Advancement: With demand for skilled paramedics on the rise, completing our training opens doors to a variety of career opportunities in hospitals, ambulance services, and beyond. Job Security: Healthcare is a recession-resistant industry, offering stability and peace of mind even in uncertain times. Personal Fulfillment: There's no greater feeling than knowing you've made a positive impact on someone's life during their moment of need. As a paramedic, you'll experience this fulfillment every single day. Continuous Learning: The field of emergency medical services is constantly evolving. Our course provides a solid foundation for ongoing professional development and specialization.   💡 Who is this for? Our Paramedic Training course is ideal for individuals who are passionate about helping others and thrive in high-pressure environments. Whether you're a recent high school graduate exploring career options or a seasoned healthcare professional looking to expand your skill set, this course is designed to meet you where you are and propel you toward success.   🚀 Career Path: Upon completion of our Paramedic Training course, you'll be well-prepared to pursue a variety of rewarding career paths, including: Emergency Medical Technician (EMT): Start your journey in emergency medical services as an EMT, providing crucial pre-hospital care to patients in need. Paramedic: With advanced training and certification, you'll be qualified to work as a paramedic, administering life-saving interventions and coordinating care in the field. Flight Paramedic: Take to the skies as a flight paramedic, providing critical care during air medical transport missions. Emergency Room Technician: Bring your skills to the hospital setting as an emergency room technician, assisting with patient triage, treatment, and stabilization. Don't wait any longer to pursue your passion for helping others and making a difference in your community. Enroll in our Paramedic Training course today and take the first step toward a rewarding career in emergency medical services! 🌟   FAQs (Frequently Asked Questions) What is Paramedic Training? Paramedic Training is a comprehensive educational program designed to prepare individuals for careers in emergency medical services. It covers a wide range of topics, including medical assessment, patient care, trauma management, pharmacology, and emergency response procedures. Who can enroll in Paramedic Training? Paramedic Training courses are open to individuals from diverse backgrounds and educational levels. Whether you're a recent high school graduate, a healthcare professional seeking specialized training, or someone looking to transition into a rewarding career in emergency medical services, our program welcomes students with a passion for helping others. What are the prerequisites for Paramedic Training? While specific prerequisites may vary depending on the institution offering the course, most Paramedic Training programs require students to have a high school diploma or equivalent. Some programs may also have additional requirements, such as basic life support (BLS) certification or previous experience in healthcare. How long does Paramedic Training take to complete? The duration of Paramedic Training programs can vary depending on factors such as program format (full-time, part-time, accelerated), curriculum requirements, and clinical training hours. Generally, Paramedic Training programs can range from several months to two years in length. What certification will I receive upon completing Paramedic Training? Upon successful completion of a Paramedic Training program, students are typically eligible to sit for the National Registry of Emergency Medical Technicians (NREMT) certification exam. Certification requirements may vary by state or country, so it's essential to check with your local regulatory authority for specific certification guidelines. What career opportunities are available after completing Paramedic Training? Graduates of Paramedic Training programs have a wide range of career options available to them. Some potential career paths include working as emergency medical technicians (EMTs), paramedics, flight paramedics, emergency department technicians, or pursuing further education in healthcare fields such as nursing or physician assistant studies. Can I work as a paramedic without certification? In most jurisdictions, certification is required to work as a paramedic. Certification ensures that paramedics have met specific educational and competency standards and are capable of providing safe and effective care to patients in emergency situations. Is financial aid available for Paramedic Training programs? Many Paramedic Training programs offer financial aid options, including scholarships, grants, and student loans, to help offset the cost of tuition and other expenses. Additionally, some employers or government agencies may provide tuition reimbursement or assistance programs for individuals pursuing careers in emergency medical services. Be sure to explore all available financial aid opportunities and resources to determine the best options for your situation. Course Curriculum Module 1 - Introduction to Paramedicine Study Module 1 - Introduction to Paramedicine Study 00:00 Module 2 - Basic First Aid Module 2 - Basic First Aid 00:00 Module 3 - Pediatric First Aid Module 3 - Pediatric First Aid 00:00 Module 4 - Common Injuries Module 4 - Common Injuries 00:00 Module 5 - Infection Control Module 5 - Infection Control 00:00 Module 6 - Other Medical Emergency Module 6 - Other Medical Emergency 00:00 Module 7 - Initial Assessment Module 7 - Initial Assessment 00:00 Module 8 - Ambulance Maintenance Module 8 - Ambulance Maintenance 00:00

Paramedic Training
Delivered Online On Demand8 hours
£4.99

Red Hat Virtualization (RH318)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Linux system administrators, virtualization administrators, and hybrid infrastructure engineers interested in deploying large-scale virtualization solutions and managing virtual servers in their datacenters, based on the Red Hat Virtualization open virtualization management platform. Overview Configure Red Hat Virtualization Configure networking and storage for use with Red Hat Virtualization Manage user accounts and access to the Red Hat Virtualization environment Install and manage virtual machines in Red Hat Virtualization Use templates for rapid virtual machine deployment Manage virtual machine snapshots and images Migrate virtual machines and explore high-availability options Deploy, configure, manage, and migrate virtual environments Red Hat Virtualization (RH318) teaches you the skills needed to deploy, administer, and operate virtual machines in your organization using Red Hat© Virtualization. Through numerous hands-on exercises, you will demonstrate the ability to deploy and configure the Red Hat Virtualization infrastructure and use it to provision and manage virtual machines. This offering also prepares you for the Red Hat Certified Specialist in Virtualization exam. This course is based on Red Hat Enterprise Virtualization 4.3 and Red Hat Enterprise Linux© 7.6 and 8, as well as Red Hat Hyperconverged Infrastructure for Virtualization 1.6. 1 - Red Hat Virtualization overview Explain the purpose and architecture of Red Hat Virtualization. 2 - Install and configure Red Hat Virtualization Install a minimal Red Hat Virtualization environment and use it to create a virtual machine. 3 - Create and manage datacenters and clusters Organize hypervisors into groups using datacenters and clusters. 4 - Manage user accounts and roles Configure user accounts using a central directory service, then use roles to assign access to resources based on job responsibilities. 5 - Adding physical hosts Add additional Red Hat Virtualization hosts automatically, and move and remove hosts from datacenters as needed. 6 - Scale Red Hat Virtualization infrastructure Add Red Hat Virtualization hosts automatically, configure Red Hat Enterprise Linux hosts when appropriate, and move and remove hosts from data centers as needed. 7 - Manage Red Hat Virtualization networks Separate network traffic into multiple networks on one or more interfaces to improve the performance and security of Red Hat Virtualization. 8 - Manage Red Hat Virtualization storage Create and manage data and ISO storage domains. 9 - Deploy and manage virtual machines Operate virtual machines in the Red Hat Virtualization environment. 10 - Migrate virtual machines Migrate and control automatic migration of virtual machines. 11 - Manage virtual machine images Manage virtual machine snapshots and disk images. 12 - Automating virtual machine deployment Automate deployment of virtual machines by using templates and cloud-init. 13 - Back up and upgrade Red Hat Virtualization Back up, restore, and upgrade the software in a Red Hat Virtualization environment. 14 - Explore high-availability practices Explain procedures to improve the resilience and reliability of Red Hat Virtualization by removing single points of failure and implementing high-availability features. 15 - Perform comprehensive review Demonstrate skills learned in this course by installing and configuring Red Hat Virtualization; using the platform to create and manage virtual machines; and backing up and updating components of Red Hat Virtualization. Additional course details: Nexus Humans Red Hat Virtualization (RH318) 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 Red Hat Virtualization (RH318) 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.

Red Hat Virtualization (RH318)
Delivered OnlineFlexible Dates
Price on Enquiry

VMware SD-WAN: Deploy and Manage [V4.x] - On Demand

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Experienced system administrators, network administrators, and system integrators responsible for designing and implementing networking solutions Network and security professionals who work with enterprise and data center networks Overview By the end of the course, you should be able to meet the following objectives: Discuss the SD-WAN architecture and platform deployment model options Identify and describe the SD-WAN solution components Explain the interaction between the SD-WAN Edge, Orchestrator, and Gateway components Describe the SD-WAN Software-Defined Networking (SDN) approach, traffic, and network flows Explore SD-WAN core features and evaluate how these dramatically improve operational automation Use SD-WAN features to perform simple, agile, and secure SD-WAN operations Simplify branch infrastructure by inserting network services on the branch edge, in the cloud, or in the regional and enterprise data centers This course provides you with the knowledge, skills, and tools to achieve competency in deploying and managing the VMware SD-WAN by VeloCloud environment. In this course, you are introduced to workflows of various software-defined WAN constructs along with several operational tools that help you deploy and manage VMware SD-WAN by VeloCloud. Course Introduction Introductions and course logistics Course objectives Introduction to VMware SD-WAN Solution Revisit the traditional WAN technology, WAN topologies and downsides Explain the challenges solved by Secure Access Service Edge (SASE) and use cases List the components of the VMware SASE? solution Describe the VMware SD-WAN solution and list its capabilities VMware SD-WAN Components and Architecture Understand the architecture of the VMware SD-WAN solution and list all its components Explain the function of VMware SD-WAN Edges, Hub, Gateways, controllers, and Orchestrator Explain how the components of the VMware SD-WAN solution interact with each other Using VMware SD-WAN Orchestrator Describe key attributes of the VMware SD-WAN Orchestrator List primary features of the VMware SD-WAN Orchestrator Navigate the main menus of the VMware SD-WAN Orchestrator portal Deploy and Configure VMware SD-WAN Understand the deployment process of VMware SD-WAN components like VMware SD-WAN Edges, Hubs, Gateways, and more Understand the workflow of the VMware SD-WAN configuration List the optional network services that are supported by VMware and the steps to configure the same Understand the profiles and their application in the VMware SD-WAN infrastructure Describe the VMware SD-WAN Edge activation process Path and Traffic Management List the routing options supported by VMware SD-WAN: Static, BGP, OSPF Understand the Dynamic Multipath Optimization (DMPO) feature and its advantages Explain the Quality of Service and its configuration to manage traffic Securing VMware SD-WAN Environment Explain various options available to secure VMware SD-WAN environments. Understand the firewall capabilities and configuration Monitoring, Maintenance, and Troubleshooting List and understand the various features available to monitor the VMware SD-WAN infrastructure List and understand the various options available to troubleshoot and investigate issues in VMware SD-WAN Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware SD-WAN: Deploy and Manage [V4.x] - On Demand 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 VMware SD-WAN: Deploy and Manage [V4.x] - On Demand 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.

VMware SD-WAN: Deploy and Manage [V4.x] - On Demand
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco Troubleshooting Cisco Data Center Infrastructure v7.0 (DCIT)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Network Administrator Network Engineer Systems Engineer Consulting Systems Engineer Cisco Integrators/Partners Overview Upon completion of this course, you will be able to: Outline the troubleshooting process, and highlight which questions to ask Describe the troubleshooting tools and methodologies that are available from the CLI and are used to identify and resolve issues in a Cisco Data Center network architecture Identify and resolve issues related to VLANs and PVLANs Identify and resolve issues related to port channels and virtual port channels Identify and resolve issues related to Cisco FabricPath Identify and resolve issues related to OTV Identify and resolve issues related to VXLAN Identify and resolve issues related to LISP Describe troubleshooting of routing protocols, such as OSPF, ISIS, and PIM. Describe troubleshooting of the AAA and RBAC Identify and resolve issues related to a single device Identify and resolve issues related to Fibre Channel interface operation Identify and resolve issues related to Fibre Channel switching when the Cisco NX-OS software switch is used in switched mode (vs. NPV mode) Identify and resolve issues related to Fibre Channel switching when the NX-OS switch is used in N Port Virtualization (NPV) mode Identify and resolve issues related to FIP and FCoE, including FCoE performance Describe Cisco UCS architecture, initial setup, tools and service aids that are available for Cisco UCS troubleshooting and interpretation of the output Describe Cisco UCS configuration and troubleshoot related issues Describe Cisco UCS B-Series operation and troubleshoot related issues Describe LAN, SAN and Fibre Channel operations, including in depth troubleshooting procedures Describe Cisco IMC utilities to validate performance and facilitate data-gathering activities for Cisco UCS C-Series troubleshooting, as well troubleshooting approach to hardware and firmware failures Define proper procedures to configure LAN and SAN connectivity and avoid issues with the P81E virtual interface card (VIC) Troubleshoot integration of Cisco UCS C-Series servers with Cisco UCS Manager Identify tools, protocols and methods to effectively troubleshoot Cisco ACI The focus of this skills-building course is troubleshooting of LANs, SANs, Cisco Unified Fabric, Cisco Unified Computing System (UCS), and Cisco Application Centric Infrastructure (ACI). The course provides rich hands-on experience in resolving problems on Cisco MDS switches, Cisco Nexus switches, Cisco fabric extenders (FEXs), Cisco UCS, and Cisco ACI. Troubleshooting the Data Center LAN Network Overview of the Troubleshooting Process Understanding CLI Troubleshooting Tools Troubleshooting VLANs and Private VLANs Troubleshooting Port Channels and Virtual Port Channels Troubleshooting Cisco FabricPath Troubleshooting Cisco OTV Troubleshooting VXLAN Troubleshooting LISP Troubleshooting Routing Protocols Troubleshooting Data Center LAN Security Troubleshooting Platform-Specific Issues Troubleshooting Data Center SAN Troubleshooting Fibre Channel Interfaces Troubleshooting Fibre Channel Fabric Service Troubleshooting NPV Mode Troubleshooting FCoE Troubleshooting Data Center Unified Computing Troubleshooting Cisco UCS Architecture and Initialization Troubleshooting Cisco UCS Configuration Troubleshooting Cisco UCS B-Series Servers Troubleshooting Cisco UCS B-Series LAN and SAN Connectivity Troubleshooting Cisco UCS C-Series Servers Troubleshooting Cisco UCS C-Series LAN and SAN Connectivity Troubleshooting Cisco UCS C-Series and Cisco UCS Manager Integration Troubleshooting Data Center ACI Exploring the Tools and Methodology of Troubleshooting Cisco ACI Additional course details: Nexus Humans Cisco Troubleshooting Cisco Data Center Infrastructure v7.0 (DCIT) 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 Cisco Troubleshooting Cisco Data Center Infrastructure v7.0 (DCIT) 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.

Cisco Troubleshooting Cisco Data Center Infrastructure v7.0 (DCIT)
Delivered OnlineFlexible Dates
Price on Enquiry

AWS Serverless Microservices with Patterns and Best Practices

By Packt

You will learn how to develop reliable and scalable serverless applications, following the microservices architecture. We will develop event-driven microservices with AWS serverless services that come with the power of the cloud, high availability and high scalability by nature following serverless design patterns and best practices.

AWS Serverless Microservices with Patterns and Best Practices
Delivered Online On Demand30 hours 20 minutes
£74.99

How to stay safe at university and college

By Streetwise Defence (Self Defence Training)

Learn the secrets of self defence and take back your power! Become confident, empowered and prepared for a safe and fun university experience

How to stay safe at university and college
Delivered Online On Demand
£49

L 3: Teacher Training (PTLLS) Course - Online Course / Distance Learning

5.0(6)

By Learn More Academy Ltd

PTLLS is a teacher training qualification for those new to teaching / training industry or wanting to start out as associate teachers, or currently teaching. Learn More Academy has been delivering the Level 3 Preparing to Teach in the Lifelong Learning Sector (PTLLS) or newly branded AET course. Level 3 Award in Education and Training (AET) course is designed to contribute towards the knowledge and understanding for Further Education National Training Organisation (FENTO) or the Employment National Training Organisation (EMPNTO) occupational standards in the United Kingdom. This course is designed for anyone wishing to enter in the adult training and teaching industry in this country and even some other country too.

L 3: Teacher Training (PTLLS) Course - Online Course / Distance Learning
Delivered Online On Demand
£100 to £190

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Streaming telemetry for engineers

5.0(3)

By Systems & Network Training

Streaming telemetry training course description An introduction to streaming telemetry. The course progresses from a brief look at the weaknesses of SNMP onto what streaming telemetry is, how it differs from the xflow technologies, the data formats available and how to configure it. What will you learn Describe streaming telemetry. Explain how streaming telemetry works. Describe the data presentation formats available. Configure streaming telemetry. Streaming telemetry training course details Who will benefit: Network engineers. Prerequisites: TCP/IP foundation for engineers. Duration 1 day Streaming telemetry training course content What is streaming telemetry? SNMP weaknesses, Netflow, sflow, polling and the old models, push vs pull, What is streaming telemetry? Telemetry streaming architecture Model driven versus event driven telemetry, subscriptions, publications. Periodic versus on change, model selection and scalability. Telemetry streaming protocols TCP, UDP, SSH, HTTP, HTTP2, NETCONF, RESTCONF, gRPC, gNMI. Models and Encoding The role of YANG. YANG models and tools. XML/ NETCONF, JSON/RESTCONF, JSON over UDP. Protocol buffers/gRPC. Google Protocol Buffers Decoder ring, protocol definition file. GPB-KV, GPB-Compact. Keys. Streaming telemetry configuration Router: Destination, Sensor, subscription. Collector: YANG models, .proto file. Pipeline. ELK: Consume, store, visualise streaming data. Collection tools APIs, YANG development Kit, Downstream consumers, influxdata, Grafana, Kafka, Prometheus, others.

Streaming telemetry for engineers
Delivered in Internationally or OnlineFlexible Dates
£1,397

NETCONF and YANG for engineers

5.0(3)

By Systems & Network Training

NETCONF and YANG training course description An introduction to NETCONF and YANG. The course progresses from what they are, why they are needed, and how to configure them onto a more detailed analysis of how NETCONF works and how to read YANG models. What will you learn Recognise the limits and problems of SNMP and the CLI. Describe the relationship between NETCONF and YANG. Configure NETCONF on network devices. Use NETCONF to configure devices. Read YANG models. NETCONF and YANG training course details Who will benefit: Network engineers. Prerequisites: Network management technologies Duration 1 day NETCONF and YANG training course content What are NETCONF and YANG? Network management and configuration issues. What is NETCONF? What is YANG? Protocols, data models, architecture. Hands on Configuring NETCONF on network devices, using NETCONF. NETCONF NETCONF layers, Secure transport: SSH, Messages: rpc, Operations, Content. Base operations: <get>, <get-config>, <edit-config>, <copy-config>, <delete-config>, <lock>,<unlock>, <close-session>, <kill-session> NETCONF datastores: :candidate, :startup, running. Hands on Retrieving a configuration with NETCONF, Editing a configuration with NETCONF. NETCONF more details NETCONF traffic flows, NETCONF capabilities, hello, capabilities exchange., Filtering data, atomic transactions, validating configurations. Hands on Using NETCONF. YANG YANG models, IETF standard YANG models, tree diagrams, an example: YANG interface management, Module header, Imports and includes, Containers, Lists, leaves, Data types, typedef, Instance data, XML. Hands on Reading YANG data models, creating a configuration instance.

NETCONF and YANG for engineers
Delivered in Internationally or OnlineFlexible Dates
£1,397