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

537 Courses in Liverpool

CCNP core

5.0(3)

By Systems & Network Training

CCNP training course description The Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.2 course provides the knowledge and skills needed to configure, troubleshoot, and manage enterprise wired and wireless networks. You'll learn to implement security principles within an enterprise network and how to overlay network design using solutions such as SDAccess and SD-WAN. Course content includes 3 days of self-study material. This course helps you prepare for the 350-401 Implementing Cisco Enterprise Network Core Technologies (ENCOR) exam What will you learn Configure, troubleshoot, and manage enterprise wired and wireless networks Implement security principles within an enterprise network Prepare you prepare to take the 350-401 Implementing Cisco Enterprise Network Core Technologies (ENCOR) exam CCNP training course details Who will benefit: Mid-level network engineers, Network administrators, Network support technicians, Help desk technicians. Prerequisites: Implementation of Enterprise LAN networks. Basic understanding of Enterprise routing and wireless connectivity, and Python scripting Duration 5 days CCNP training course content Cisco Enterprise Network Architecture: Access, distribution, core in the hierarchical network. Cisco Switching Paths: Switching mechanisms, TCAM, CAM, process switching, fast switching, and CEF. Implementing Campus LAN Connectivity: Troubleshoot L2 connectivity using VLANs and trunkingBuilding Redundant Switched Topology: STP Implementing Layer 2 Port Aggregation Troubleshoot link aggregation using Etherchannel EIGRP Implement and optimize OSPFv2/v3, including adjacencies, packet types, and areas, summarization, and route filtering for IPv4/v6 Implement EBGP interdomain routing, path selection, and single and dual-homed networkingImplementing Network Redundancy: HSRP and VRRP Implement static and dynamic NAT Virtualization Protocols and TechniquesVPNs and Interfaces: Overlay technologies such as VRF, GRE, VPN, and LISP Wireless Principles: RF, antenna characteristics, and wireless standards.Wireless Deployment: Models available, autonomous AP deployments and cloud-based designs within the centralized Cisco WLC architecture Wireless Roaming and Location ServicesWireless AP Operation: How APs communicate with WLCs to obtain software, configurations, and centralized managementWireless Client Authentication: EAP, WebAuth, and PSK wireless client authentication on a WLC. Troubleshoot wireless client connectivity issues using various available tools Troubleshoot networks using services such as NTP, SNMP, Cisco IP SLAs, NetFlow, and Cisco IOS EEM Explain network analysis and troubleshooting tools, which include show and debug commands, as well as best practices in troubleshootingMulticast Protocols: IGMP v2/v3, PIM DM/SM and RPs Introducing QoS: Concepts and features. Implementing Network Services: Secure administrative access for Cisco IOS devices using CLI access, RBAC, ACL, and SSH, and device hardening concepts to secure devices from less secure applications Using Network Analysis ToolsInfrastructure Security: Scalable administration using AAA and the local database, features and benefits Enterprise Network Security Architecture: VPNs, content security, logging, endpoint security, personal firewalls, and other security features. Automation and Assurance with Cisco DNA Center: Purpose, function, features, and workflow. Intent-Based Networking, for network visibility, proactive monitoring, and application experienceCisco SD-Access Solution: Nodes, fabric control plane, and data plane, VXLAN gatewaysCisco SD-WAN Solution: Components and features of Cisco SD-WAN solutions, including the orchestration, management, control, and data planesBasics of Python Programming: Python components and conditionals with script writing and analysis Network Programmability: NETCONF and RESTCONF APIs in Cisco DNA Center and vManage Labs: Investigate the CAM. Analyze CEF. Troubleshoot VLAN and Trunk Issues. Tuning STP and Configuring RSTP. Configure MSTP. Troubleshoot EtherChannel. Implement Multi-area OSPF. Implement OSPF Tuning. Apply OSPF Optimization. Implement OSPFv3. Configure and Verify Single-Homed EBGP. Implementing HSRP. Configure VRRP. Implement NAT. Configure and Verify VRF. Configure and Verify a GRE Tunnel. Configure Static VTI Point-to-Point Tunnels. Configure Wireless Client Authentication in a Centralized Deployment. Troubleshoot Wireless Client Connectivity Issues. Configure Syslog. Configure and Verify Flexible NetFlow. Configuring Cisco IOS EEM. Troubleshoot Connectivity and Analyze Traffic with Ping, Traceroute, and Debug. Configure and Verify Cisco IP SLAs. Configure Standard and Extended ACLs. Configure Control Plane Policing. Implement Local and Server-Based AAA. Writing and Troubleshooting Python Scripts. Explore JSON Objects and Scripts in Python. Use NETCONF Via SSH. Use RESTCONF with Cisco IOS XE.

CCNP core
Delivered in Internationally or OnlineFlexible Dates
£3,697

Agile Business Consortium Scrum Master Course: In-House Training

By IIL Europe Ltd

Agile Business Consortium Scrum Master® Course: In-House Training This two-day course covers the principles and theory of the Scrum framework and the role of the Scrum Master. IIL is an accredited training organization (ATO) and the course is delivered by accredited trainers. APMG's accreditation processes are respected globally and accredited by UKAS. A Scrum Master is responsible for promoting and supporting Scrum as defined in The Scrum Guide, and also is the leader who serves the Product Owner, the Development Team, and the Organization. Why APMG - Agile Business Consortium Scrum Master® Course and Certification? The course, syllabus, and learning objectives are based on The Scrum Guide - The Definitive Guide to Scrum: The Rules of the Game - created and maintained by Scrum's creators Ken Schwaber and Jeff Sutherland Increased business (non-IT) focus of course and exercises Developed in partnership with Agile Business Consortium - leaders in promoting and enabling business agility Course is highly interactive to encourage collaboration and reinforce learning objectives Candidates can sit the examination at the end of the training course No recertification requirements. APMG Scrum Master certification does not expire. Successful candidates are entitled to free 1-year membership with the Agile Business Consortium Successful candidates can claim a digital badge and share their success online What You Will Learn At the end of this program, you will be able to: Gain a deep understanding of the Scrum Framework - the theory, practices, roles, rules, and values - as defined in The Scrum Guide Understand, in detail, the role of Scrum Master, and how the role interacts with different members of the Scrum Team and other stakeholders Master the Scrum principles to better understand their application when returning to the workplace Understand how to construct an effective development team with an appropriate mix of skills and experience Know how to act as a servant-leader for the Scrum Team, promoting and enabling self-organization to create high-value products. Learn how to facilitate Scrum Events and remove impediments to the Scrum Team's progress Help Scrum Product Owners shape and refine product backlogs to guide early and incremental delivery of valuable products Drive adoption of the Scrum framework for more effective product and solution development, working with stakeholders and other Scrum Masters to improve its effectiveness Day One Scrum Overview Self-Organization Agile Principles Empirical Product Development Scrum Events The Development Team Scrum Roles Day Two The Product Backlog Sprint Planning and Done Sprint Progress Scrum Simulation Growing as a Scrum Master

Agile Business Consortium Scrum Master Course: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,795

Directional, Horizontal and Multilateral Drilling – Simulator Assisted

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your drilling skills with our Directional, Horizontal, and Multilateral Drilling Simulator Assisted course. Join EnergyEdge for comprehensive training.

Directional, Horizontal and Multilateral Drilling – Simulator Assisted
Delivered in Internationally or OnlineFlexible Dates
£3,599 to £3,799

Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course Oil & Gas professionals increasingly need to translate complex findings, analysis and recommendations for effective decision-making. If you face challenges in getting your findings into paper, you will benefit from this training course. The Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals course focuses on the unique needs of technical professionals who write for both technical and non-technical readers. This separately bookable training course will demonstrate how technical professionals can use their technical knowledge and logical edge to write in a reader-friendly style, produce grammatically accurate reports and persuasively communicate for buy-in purposes. An ILM Recognised programme. Training Objectives LEARNING OUTCOMES FOR TECHNICAL REPORT WRITING SKILLS By the end of this course, participants will be able to: Write and turn-around accurate technical documents quickly to meet deadlines and productivity goals Understand how technical reports should be structured by applying a systematic approach to the writing task, involving planning, drafting, revision and production Use clear & powerful language to target and persuade readers for positive results Use tried and tested proof reading techniques to check and review documents more effectively Identify and avoid common pitfalls in technical report writing LEARNING OUTCOMES FOR TECHNICAL PRESENTATION SKILLS By the end of this course, participants will be able to: Present and sell your technical presentation more effectively both internally and externally Plan and structure your meetings and presentations for maximum effect Capture your technical and non-technical audience by delivering your presentation with power and authority Handle questions, interruptions and objections with confidence Target Audience This programme has been researched and developed for all Oil & Gas Engineers and Technical Professionals Course Level Basic or Foundation Trainer Your course leader managed the Business Skills Unit of the British Council programmes as well as oversee all training-related matters from 1997. The trainer considers himself a trainer first and specialises predominantly in high-level writing and technical report writing programmes. In addition to conducting training in Technical Writing, the trainer has also been the chief editor for many large writing projects. These include a year-long project editing the entire Start-Up Manual (including the Black Start Manual) for Nippon Oil's Helang Integrated Platform, a 4-month project rewriting the manuals for the Puteri Dulang FSO off Terengganu, and editing the current revision of the PETRONAS Procedures and Guidelines for Upstream Activities (PPGUA). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals
Delivered in Internationally or OnlineFlexible Dates
£1,719 to £1,999

M.D.D VIP DIAMOND BESPOKE PACKAGE (V.I.P)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

This package is suitable for high profile clients that require a more specific intensive date coach experience and require a package to be created for them based on the information they provide us with and would like the dating coach to be available to speak to them between 9 am to 12 pm every single day of the week.The client must specify all the required needs and our assessment team will create the clients desired package, Price on application (Please call the office) https://relationshipsmdd.com/product/m-d-d-vip-diamond-bespoke-package/

M.D.D VIP DIAMOND BESPOKE PACKAGE (V.I.P)
Delivered in London or UK Wide or OnlineFlexible Dates
£950

Wind Power Generation: Advantages, Design, Site Selection, Equipment Selection, Operation and Maintenance, On-Shore and Off-Shore Wind Farms, Economics, Rate of Return, and Cost of Electricity from Wind Power Plants

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course Wind has surpassed hydro-power generation in many countries recently. Wind energy offers many advantages, which explains why it's one of the fastest-growing energy sources in the world. The following are the advantages of wind power: Wind power is cost effective: Land-based utility-scale wind is one of the lowest-priced energy sources available today The fuel for wind power is free. This reduces the operation and maintenance cost of wind power plants significantly Wind is a clean source of power generation that does not pollute the air like power plants which rely on combustion of fossil fuel Wind power plants create jobs. Wind turbine technician is the fastest growing career in many countries Wind enables industry growth and competitiveness due to its low cost Wind power is a domestic source of energy. The wind supply is abundant and inexhaustible. The wind power generation capacity has become the largest source of renewable power in many countries Wind turbines can be built on existing farms and ranches. This greatly benefits the economy in rural areas, where most of the best wind sites are found. Wind power plant owners make rent payments to the farmers or ranchers for the use of their land, providing landowners with additional income This 5 half-day course covers all aspects of wind power plants including evaluation of a potential location for a wind power plant using wind data and using statistical distributions to approximate available wind energy at a wind power plant site. It provides also an in-depth understanding of all wind power plant equipment including wind turbines, generators, instrumentation and control systems, drive trains, gearboxes, doubly fed induction generators, synchronous generators, nacelles, towers, transformers, etc. The economics of a wind power plant including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, economic decision making, rate of return from a wind power plant, economic life and replacement of a wind power plant as well as the cost of electricity from wind power plants are covered in detail in this course. A thorough explanation of the design, operation and maintenance of on-shore and off-shore wind farms is presented in detail in this course as well as all the significant improvements that have been made to wind power generating plants during the last two decades. Training Objectives Evaluation of a Potential Location for a Wind Power Plant Using Wind Data: Learn how to evaluate the potential location for a wind turbine power plant using wind data. Using Statistical 'Rayleigh' Distribution to Approximate Available Power Generation from a Wind Turbine at a Specific Site: Learn how to use statistical 'Rayleigh' distribution to approximate available power generation from a wind turbine at a specific site. Calculate the Wind Energy Available at a Site: Gain an understanding on how to calculate the wind energy available at a site. Rated Capacity of a Wind Facility and Capacity Factor: Understand how to determine the rated capacity of a wind facility and its capacity factor. Designing a Wind Power Generating Plant: Learn how to design a wind power generating plant. Wind Power Plant Equipment Operation and Maintenance: Understand the operation and maintenance requirements for all wind power plant equipment including wind turbines, generators, nacelles, towers, transformers, etc. Wind Power Plant Instrumentation and Control Systems: Gain a thorough understanding about the latest instrumentation and control systems of wind power plants. Economics of Wind Power Plants: Gain a thorough understanding of the economics of wind power plants including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, comparison of alternatives, rate of return from a wind power plant, financial statements for a wind power plant, cost of electricity from a wind power plant, and levelized cost of wind energy.   Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a soft copy of the following materials written by the instructor: POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 (800 pages) Wind Power Generating Plant Manual (500 pages) POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Wind Power Generation: Advantages, Design, Site Selection, Equipment Selection, Operation and Maintenance, On-Shore and Off-Shore Wind Farms, Economics, Rate of Return, and Cost of Electricity from Wind Power Plants
Delivered in Internationally or OnlineFlexible Dates
£1,431 to £2,700

Network design

5.0(3)

By Systems & Network Training

Network design training course description This course provides you with the knowledge needed to perform the design of a network infrastructure that supports desired network solutions to achieve effective performance, scalability, and availability. We recognise that the role of design does not normally require hands on skills but hands on sessions are used to reinforce the theory not to teach configuration or troubleshooting. What will you learn Create HA enterprise network designs. Develop optimum Layer 3 designs. Design effective modern WAN and data center networks. Develop effective migration approaches to IPv6. Create effective network security designs. Network design training course details Who will benefit: Anyone involved with network design. Prerequisites: TCP/IP Foundation for engineers Duration 5 days Network design training course contents Part I Reliable, resilient enterprise L2/3 network designOptimal Enterprise Campus Design:Enterprise campus design principles, hierarchy, modularity, flexibility, resiliency.EIGRP design:EIGRP Design, Should you use EIGRP?OSPF design: OSPF scalability designs, OSPF area design, OSPF Full-Mesh Design, OSPF Hub-and-Spoke Design, OSPF convergence design and optimization techniques. IS-IS Design:The protocol, IS-IS hierarchical architecture, IS-IS vs OSPF, IS-IS Deep Dive, IS-IS Design Considerations. BGP design:BGP overview, Designing Scalable iBGP Networks, BGP Route Reflector Design, Enhancing the Design of BGP Policies with BGP Communities, Case Study: Designing Enterprise wide BGP Policies Using BGP Communities, BGP Load-Sharing Design.Part II Enterprise IPv6 Design ConsiderationsIPv6 Design Considerations in the Enterprise: IPv6 Deployment and Design Considerations, Considerations for Migration to IPv6 Design, IPv6 Transition Mechanisms, Final Thoughts on IPv6 Transition Mechanisms. Challenges of the Transition to IPv6: IPv6 Services, Link Layer Security Considerations. Part III Modern Enterprise Wide-Area Networks DesignService Provider-Managed VPNs:Choosing Your WAN Connection, Layer 3 MPLS VPNs, Case Study: MPLS VPN Routing Propagation, Layer 2 MPLS VPN Services. Enterprise-Managed WANs: Enterprise-Managed VPNs, GRE, Multipoint GRE, Point-to-Point and Multipoint GRE, IPsec, IPsec and dynamic VTI, DMVPN, Case Study: EIGRP DMVPN, DMVPN and Redundancy, Case Study: MPLS/VPN over GRE/DMVPN, SSL VPN. Enterprise WAN Resiliency Design: WAN Remote-Site Overview, MPLS L3 WAN Design Models, Common L2 WAN Design Models, Common VPN WAN Design Models, 3G/4G VPN Design Models, Remote Site Using Local Internet, Remote-Site LAN, Case Study: Redundancy and Connectivity, NGWAN, SDWAN, and IWAN Solution Overview, IWAN Design Overview, Enterprise WAN and Access Management. Part IV Enterprise Data Center DesignsMultitier Data Center Designs: Case Study: Small Data Centers (Connecting Servers to an Enterprise LAN), Case Study: Two-Tier Data Center Network Architecture, Case Study: Three-Tier Data Center Network Architecture.Trends and Techniques to Design Modern Data Centers: The Need for a New Network Architecture, Limitations of Current Networking Technology, Modern Data Center Design Techniques and Architectures, Multitenant Data Center. SDN:SDN characteristics, How SDN addresses current Networking Limitations, SDN Architecture Components, SDN Network Virtualization overlays. Data Center Connections:Data Center Traffic Flows, The Need for DCI, IP Address Mobility, Case Study: Dark Fiber DCI, Pseudowire DCI. Part V Design QoS for Optimized User ExperienceQoS Overview:QoS Overview, IntServ versus DiffServ, Classification and Marking, Policers and Shapers, Policing Tools: Single-Rate Three-Color Marker, Policing Tools: TwoRate Three-Color Marker, Queuing Tools, Dropping Tools. QoS design principles and best practices: QoS overview, classification and marking design principles, policing and remarking design principles, queuing design principles, dropping design principles, Per-Hop behavior queue design principles, RFC 4594 QoS Recommendation, QoS Strategy Models. Campus QoS, WAN QoS, Data Center QoS.MPLS VPN QoS Design: The Need for QoS in MPLS VPN, Layer 2 Private WAN QoS Administration, Fully Meshed MPLS VPN QoS Administration, MPLS DiffServ Tunneling Modes, Sample MPLS VPN QoS Roles. IPsec VPN QoS Design: The Need for QoS in IPsec VPN, VPN Use Cases and Their QoS Models, IPsec Refresher, Encryption and Classification: Order of Operations, MTU Considerations, DMVPN QoS Considerations. Part VI IP Multicast DesignEnterprise IP Multicast Design: How Does IP Multicast Work? Multicast Protocols, Multicast Forwarding and RPF Check, Multicast Protocol Basics, PIM-SM Overview, Multicast Routing Table, Basic SSM Concepts, Bidirectional PIM. RP discovery, Anycast RP Features, MSDP. Part VII Designing Optimum Enterprise Network SecurityDesigning Security Services and Infrastructure Protection Network Security Zoning, Designing Infrastructure Protection.Designing firewall & IPS solutions: Firewall architectures, virtualized firewalls. Case Study: Application Tier separation, Case Study: Firewalls in a Data Center, Case Study: Firewall High Availability, IPS Architectures, Case Study: Secure Campus Edge Design (Internet and Extranet Connectivity). IP Multicast Security: Multicast Security Challenges, Multicast Network Security Considerations. Designing Network Access Control Solutions:IEEE 802.1X, EAP, 802.1X supplicants, 802.1X phased deployment, Case Study: Authorization Options. Part VIII Design scenariosDesign Case Studies: 1: Enterprise Connectivity, 2: Enterprise BGP with Internet Connectivity, 3: IPv6, 4: Data Center Connectivity, 5: Resilient Enterprise WAN, 6: Secure Enterprise Network, 7: QoS in the Enterprise Network.

Network design
Delivered in Internationally or OnlineFlexible Dates
£3,697

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Subsea Production Engineering - Incorporating Subsea Tie-backs - Virtual Instructor Led Training

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual instructor Led Training (VILT)  The Subsea Production Engineering Virtual instructor Led Training (VILT) course provides an overview of all of the functionalities and key interfaces of subsea equipment. The VILT course will refer to relevant industry engineering standards for subsea equipment, subsea tie-backs and critical operational requirements. The sessions will cover challenges associated with equipment design and installability, as well as a new module on subsea tie-backs. The primary learning objectives for this VILT course are met through a combination of interactive presentations, discussion and exercises. Training Objectives By the end of this VILT course, participants will be able to: Apply the requirements of related industry standards (API 6A/ 17D, API 17A etc.) engineering standards Understand the barrier and qualification requirements Identify the barriers in place given a specific mode of operation Evaluate and select which tree alternatives are valid based on the key design drivers Identify and describe the key design drivers Explain the importance of well kill rate Describe which tree alternatives are valid for certain scenarios based on an evaluation of the key tree design requirements Examine what effects subsurface requirements may have on tree design Understand the challenges associated with designing equipment for manufacturability and installability Recognise the implications of design changes to specific components and the effects on transportation and installation (such as what type of vessels, lifting equipment, and tools to use and the logistical requirements) Recognise the implication of design changes on manufacturability of subsea equipment Target Audience This VILT course provides a comprehensive understanding of the equipment used in subsea production systems. It is designed for petroleum engineers, production engineers, subsea project engineers and is also highly suitable for cost, planning, offshore installation and offshore operations engineers. Anyone directly or indirectly involved with subsea equipment will benefit from attending this VILT course - from engineers installing the equipment to procurement staff looking to understand more. Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Subsea Production Engineering - Incorporating Subsea Tie-backs - Virtual Instructor Led Training
Delivered in Internationally or OnlineFlexible Dates
£1,165 to £2,199

Operations, Maintenance and Testing of Power Transformer & Electric Motors

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT)  Electrical machines, mainly power transformers and electric motors are critical equipment that run production, and it must operate without any abnormalities. A wide variety of tests and standards have been developed to assist manufacturers and users of motors and transformer winding, assess the condition of the electrical insulation. The objective of this training course is to provide an understanding of power transformers and electric motors, their materials, components, and how they operate. It will also emphasize the importance of transformer life management, especially for those transformers and electric motors which have been in operation for than 10 years. The course will address in detail all aspects related to transformer principles, calculations, operation, testing and maintenance. Training Objectives This course aims to provide participants with the understanding of the fundamentals and constructional features of power transformers and electric motors, with particular reference to the design, testing, operation and maintenance of transformers in power systems. Delegates will gain a detailed appreciation of the following: Practical solutions for specifying, operating and maintaining power transformers and electric motors in a utility or plant environment Comprehensive understanding of principles, protection, maintenance and troubleshooting of power transformers and electric motors The necessary safe procedures relating to transformer operation and related circuitry Understand the principles of operation of the transformer and electric motors Identify the different features of power transformers and electric motors Appreciate the principles of transformer design, ratings, winding, core structure and materials, insulation and cooling methods, insulation and lifetime Utilize thermal limits and loading guides of transformers Analyze transformer and electric motors failure modes Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, with 1 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Our key expert is actively involved in electrical inspections, energy audits, energy efficiency and technical consultation for M&E activities for industrial and commercial sectors. He is involved in testing and commissioning works of factory substations of up to 132kV system. He previously worked for Jimah coal-fired power plant in Port Dickson for 9 years with his last position being Electrical Maintenance Section Head. He was involved in the commissioning of coal-fired power plant mainly with 500kV generator transformer, 934 MVA generator, and up to 33kV MV motors and switchgear panels. Our key expert has managed the maintenance team to perform routine maintenance activities (together with supporting tools such as motor lube oil analysis, infrared thermography analysis, transformer oil analysis) & electrical troubleshooting and plant outages for critical and non-critical equipment. Besides that, our key expert has published several IEEE conference papers and journals such as: (2009). Effectiveness of auxiliary system monitoring & continuous hydrogen scavenging operation on hydrogen-cooled generator at power plant. In Energy and Environment, 2009. ICEE 2009. 3rd International Conference on (pp. 151-160). IEEE. (2010). Study on electric motor mass unbalance based on vibration monitoring analysis technique. In Mechanical and Electrical Technology (ICMET), 2010 2nd International Conference on (pp. 539-542). IEEE. (2012). Re-Design of AC Excitation Busduct based on Infrared (IR) Thermography: Condition-Based Monitoring (CBM) data analysis. eMaintenance, 101. (2016). Energy Saving Studies for a University Campus: An Educational-Based Approach, 3rd International Conference on Language, Education, Humanities and Innovation 2016. 'Grid-tied photovoltaic and battery storage systems with Malaysian electrcity tariff - A review on maximum demand shaving.' Energies 10.11 (2017): 1884 'Techno-Economic Optimization of Grid-Connected Photovoltaic (PV) and Battery Systems Based on Maximum Demand Reduction (MDRed) Modelling in Malaysia.' Energies 12.18 (2019): 3531 POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Operations, Maintenance and Testing of Power Transformer & Electric Motors
Delivered in Internationally or OnlineFlexible Dates
£1,238 to £2,336