Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.
PRINCE2 Agile® Practitioner: Virtual In-House Training PRINCE2 Agile® Practitioner is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2®. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Practitioner certification teaches you to blend structure, governance, and control with agile methods, techniques, and approaches. The strength of PRINCE2® lies in the areas of project direction and project management, whereas Agile has a very strong focus on product delivery. When PRINCE2® and agile are combined, project direction, project management, and project delivery are optimized to create a complete project management solution. PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation. What you will Learn Understand the basic concepts of common agile ways of working Understand the purpose and context for combining PRINCE2® and the agile way of working Able to apply and evaluate the focus areas to a project in an agile context Able to fix and flex the aspects of a project in an agile context Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context To learn through the use of theory and practical exercises Prepare for the PRINCE2 Agile® Practitioner exam Benefits Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved Improved communication through the use of common terminology across PRINCE2® and agile disciplines Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge® just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism. The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications Agile Overview & Blending PRINCE2 and Agile Agile overview Blending PRINCE2 and Agile Fix and Flex, Agile and PRINCE2 Processes & Starting a Project Fix and Flex Agile and the PRINCE2 Processes; Starting up a project and Initiating a project Business case theme Change and Organization Themes& Principles Change theme Organization theme Agile and PRINCE2 Principles and the Agilometer Managing Product Delivery and Scrum & Plans and Progress Themes Managing product delivery and Scrum Plans Theme and Progress Theme Quality, Controlling & Managing a Stage and Directing Projects and Contracts Quality Theme Controlling a stage and Frequent Releases Managing a stage boundary Directing a project and contracts Closing a project Tailoring PRINCE2 Productsand Other Practices Tailoring PRINCE2 products and other practices
Why Choose Fundamentals of Revit Training? Revit, the pinnacle of Building Information Modelling (BIM) software, is integral for architects, engineers, designers, and contractors. Mastering it is essential for various construction, design, and planning phases. Click here for more info: Website How to Enrol? Our training sessions are tailored exclusively for you, offering personalized 1-on-1 instruction. Choose a convenient hour between 9 a.m. and 7 p.m., Monday to Saturday. For booking, call 02077202581 or pre-book online. I. Introduction to Revit: Understanding Revit and its applications Exploring Revit interface and basic tools Navigating through viewport controls Creating and saving projects II. Project Setup: Creating a new project and utilizing templates Configuring project settings and scales Adding levels, grids, and columns III. Building Elements: Creating and modifying walls, doors, and windows Designing floors, ceilings, roofs, stairs, and railings IV. Views and Documentation: Managing views and sheets Adding schedules, tags, and annotations Generating construction documents V. Advanced Modeling and Components: Working with complex walls, curtain walls, and grids Using visibility and graphics controls and cutaway views VI. Rooms and Details: Adding and numbering rooms Incorporating annotations, dimensions, symbols, and legend views Creating detail callouts and using detail components VII. Families and Customization: Understanding families and their components Using reference planes, parameters, and constraints Building custom families with solid and void geometry VIII. Sheets, Plotting, and Exporting: Organizing sheets and exporting to AutoCAD and JPG formats Note: This course outline is flexible and can be tailored to meet learners' needs and proficiency levels. After completing the Revit Basic to Fundamentals Course, participants will: Understand the foundational concepts and principles of Autodesk Revit. Navigate and utilize the essential tools and features of Revit effectively. Create and modify basic building elements, such as walls, doors, windows, and roofs. Develop 3D building models and understand the concept of BIM (Building Information Modeling). Produce basic construction documentation, including floor plans, elevations, and sections. Implement annotation and dimensioning techniques to enhance documentation clarity. Gain proficiency in organizing and managing views for efficient project visualization. Collaborate on simple design changes and modifications using Revit's collaboration features. Acquire practical skills for applying Revit in real-world architectural and construction projects. Revit Essentials Training: Learn Revit fundamentals for architecture and structural design, supporting efficient building construction with BIM workflows. Delivery Options: In-class at our center Live online sessions Who Should Attend? Ideal for architects, building designers, structural engineers, and general users. Course Highlights: Hands-on and practical training with expert instructors. Detailed training guide for reference and post-course review. E-certificate upon successful completion. Practical skills for real-world application, no exams. Prerequisites: No prior Revit knowledge required. Basic construction principles recommended. CAD experience beneficial but not essential. Version and Support: Based on Latest Revit. Lifetime email support provided. Guarantees: Best value for money and assurance of learning essential concepts and skills. Individualized One-on-One Training: Experience personalized attention and tailored guidance. Flexible Timing: Schedule sessions at your convenience, choosing your preferred time and day. Post-Course Assistance: Access complimentary online support after course completion. Comprehensive Learning Materials: Receive effective learning resources, including PDF notes and handouts. Certification of Completion: Earn a recognition certificate upon successfully finishing the course. Affordable Rates: Enjoy budget-friendly training fees for valuable learning experiences. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and receive discounts on upcoming courses. Group Training Discounts: Avail special discounts for group training sessions. Convenient Availability: Attend sessions from Monday to Sunday, with extended operational hours. Customized Training: Get tailored and personalized courses designed to meet your specific requirements. Download Revit
Project Risk Management: In-House Training Have you been surprised by unplanned events during your projects? Are you and your project team frequently fighting fires? Well, you are not alone. Uncertainty exists in any project environment. While it's impossible to predict project outcomes with 100% certainty, you can influence the outcome, avoid potential risks, and be ready to respond to challenges that arise. In this course, you'll gain the proper knowledge needed to identify, assess, plan for, and monitor risk in your projects. You'll learn how to set up and implement risk management processes, helping you to minimize uncertainty and achieve more consistent, predictable outcomes as a result. What You Will Learn You'll learn how to: Demonstrate to others how the risk management processes in A Guide to the Project Management Body of Knowledge (PMBOK® Guide) apply to your project's environment, especially for high-risk projects Adapt these processes for a particular high-risk project team's operating principles Explain the importance of using risk management best practices at single and enterprise project levels Lead an initiative to implement risk management best practices in your project environment Foundation Concepts Risk-related definitions The risk management process High-risk projects and project failures Classical failures in implementing risk management Plan Risk Management Project risk management and governance Risk management planning for high-risk projects High-risk variations on a risk management plan Identify Risk Adapting the risk identification process for high-risk projects Recognizing risks spontaneously Confirming and structuring risk events for treatment Wrapping up risk identification for high-risk projects Perform Qualitative Risk Analysis Adapting qualitative risk analysis for high-risk projects Accelerating risk analysis Clearing risk action Wrapping up qualitative risk analysis for the next level Perform Quantitative Risk Analysis Adapting quantitative risk analysis for high-risk projects Ensuring effective risk analyses with data quality assessments Building a foundation for quantitative risk analysis Using discrete quantitative tools Using continuous quantitative tools Wrapping up quantitative risk analysis for high-risk projects Plan Risk Responses Adapting risk response planning for high-risk projects Optimizing active risk response strategies Leveraging contingencies for high project performance Wrapping up risk response planning for high-risk projects Implement Risk Responses Implementing Risk Responses Process Executing Risk Response Plans Tools and Techniques Best Practices Continuous Risk Management Monitor Risks Adapting risk monitoring for high-risk projects Optimizing risk plan maintenance Weaving risk reassessment into the project's progress Maintaining a continuous 'vigil' in high-risk project environments
Level 7 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 180 CPD Points | Lifetime Access
Scrum Master Workshop: In-House Training: Virtual In-House Training A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. What you will Learn You'll learn how to: Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum Guide the Scrum team in their responsibilities Write requirements in the form of user stories Define Ready and Done Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional Teams Building Effective Teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content
SAFe® Product Owner / Product Manager: Virtual In-House Training Develop the skillsets needed to guide the delivery of value in a Lean Enterprise by becoming a SAFe® 5.0 Product Owner / Product Manager (POPM). During this course, attendees gain an in-depth understanding of how to effectively perform their role in the Agile Release Train (ART) as it delivers value through Program Increments. Attendees explore how to apply Lean thinking to decompose Epics into Features and Stories, refine Features and Stories, manage Program and Team backlogs, and plan and execute Iterations and Program Increments. Attendees also discover how the Continuous Delivery Pipeline and DevOps culture contribute to the relentless improvement of the ART. What you will Learn To perform the role of a SAFe® Product Owner / Product Manager, attendees should be able to: Articulate the Product Owner and Product Manager roles Connect SAFe® Lean-Agile principles and values to the PO / PM roles Decompose Epics into Features and decompose Features into Stories Manage Program and Team backlogs Collaborate with Agile teams in estimating and forecasting work Represent customer needs in Program Increment Planning Execute the Program Increment and deliver continuous value Becoming a Product Owner / Product Manager in the SAFe® enterprise Preparing for PI Planning Leading PI Planning Executing Iterations Executing the Program Increment Becoming a Certified SAFe® Product Owner / Product Manager
WAN training course description A hands on Introduction to Wide Area Networks for engineers. This course covers all current major WAN technologies from a perspective of design, evaluating technologies available as well as hands on to consolidate the theory What will you learn Describe the seven-layer model and realise how it applies to the real world. Evaluate and describe WAN technologies. Describe the architecture of WANs in the core. Use WANS to interconnect LANS. WAN training course details Who will benefit: Technical staff wishing to find out more about how their WAN works. Prerequisites: Intro to data communications & networking Duration 5 days WAN training course contents Introduction LANs, MANS and WANS, protocols, the OSI seven layer model, ITU-T, ETSI, DTE, DCE, and the overall picture. WAN architectures Service providers, core, access, DTE, DCE, CPE, dialup, circuit switched, packet switched, how to choose a WAN, common bandwidths, site to site, remote access. Topologies: Star, Full mesh, partial mesh. History of WANs Before IP was ubiquitous, The PSTN, Dial up networks, modems, ISDN, Stat mux, TDM, 64k, N*64, E1, X25, Frame Relay The role of IP and routers The growth of IP, the role of routers, routing tables, routing protocols. Hands on: IP and routing. Layer 1 Physical Copper, Fibre, Wireless, Microwave, Phone lines, FTTC, FTTH, mobile networks. Service provider technologies The transport plane, SDH, SONET, DWDM. WAN access Phone lines, leased lines, xDSL, WiMax, satellite, the role of PPP. Broadband adband xDSL, ADSL, SDSL, local loops, DSLAM, DSL architecture. ATM Cell switching principles, ATM switching, Virtual paths, QOS, CBR, VBR, ABR, UBR, AAL1 to AAL5, MPOA, LANE, Voice over ATM. The Internet VPNs, IPSEC, QOS. What is MPLS? Core MPLS, MPLS and the 7 layer model, MPLS protocol, MPLS standard, MPLS runs on routers, MPLS history, Why MPLS? MPLS architecture LSRs, PE and P router roles, FEC, swapping labels, MPLS packet format, Loops, TTL control. Ethernet What is Ethernet? LANs, MANs, WANs, Ethernet and switches in the LAN. Traditional LAN/WAN integration, routers. The Ethernet interface for the WAN. Standards: Transporting carrier Ethernet.
Advanced C++ training course description The course will give a broad overview of the C++ Programming language, focusing on modern C++, up to C++17. This course will cover the use of the Standard Library, including containers, iterator, function objects and algorithms. From the perspective of application development, a number of design patterns will be considered. What will you learn Write C++ programs using the more esoteric language features. Utilise OO techniques to design C++ programs. Use the standard C++ library. Exploit advanced C++ techniques Advanced C++ training course details Who will benefit: Programmers needing to write C++ code. Programmers needing to maintain C++ code. Prerequisites: C++ programming foundation. Duration 5 days Advanced C++ training course contents Study of a string class Create a string class as a means to investigate many issues, involving the use of operator overloading and including overloading new and delete. Creation of the class will also require consideration of 'const correctness'. Exception handling Consider the issues involved in exception handling including the concept of exception safety. Templates Review definition of template functions, including template parameter type deduction. Introduction to template metaprogramming. Newer features including template template parameters and variadic templates. Creation of template classes. Design patterns Introduction to Design Patterns and consideration of a number of patterns, such as, factory method, builder, singleton and adapter. The standard C++ library (STL) Standard Library features, such as, Containers, Iterator, Function Objects and Algorithms. Introduction to Lambda expressions. C++ and performance The writing of code throughout the course will be oriented towards performant code, including use of R Value references and 'move' semantics. Pointers The use of pointers will be considered throughout the course. Smart pointers will be considered to improve program safety and help avoid the use of 'raw' pointers. Threading This section will consider the creation of threads and synchronisation issues. A number of synchronisation primitives will be considered. Async and the use of Atomic will also be considered. New ANSI C++ features Summarising some of the newer features to be considered are: Auto, Lambdas expression, smart pointers, variadic templates and folds, R Value references and tuple together with structured binding.
About this Training Course Managing process hazards in the hydrocarbon and chemical processing industries is a critical function that requires relevant knowledge and skills due to the risks involved. The Advanced Process Safety Engineering course will discuss the interrelation of the various techniques of process safety for analysing, with a particular emphasis on engineering design aspects, as well as how to manage process hazards in a safe and effective way and how they can potentially be avoided. In this 3 full-day advanced level course, the expert course leader will provide participants with insights and examples from his career and experience to show how their learning should be applied in real-life situations. Feedback and questioning is highly encouraged. Reference material and reports can be provided to give more information on any particular topic of interest. Individual and group exercises, tutored exercises and video case studies will be provided throughout the course to underpin the key learning points. Training Objectives Upon completion of this course, participants will acquire in-depth knowledge of: Risk management and 'As Low as Reasonably Practicable' (ALARP) principles. Different aspects of process design that influence process safety. Approach to 'inherently safer' design. Defence in depth using 'layers of protection'. Process for ensuring the technical integrity of safety-critical equipment. Hazards associated with process materials. Range of hazard identification and consequence modelling techniques. Causes and mitigation of human error. Reliability and availability of safety-critical protection equipment. Role of engineered safety-critical equipment and systems. Target Audience This course is suitable for industry professionals who need to acquire a comprehensive understanding of process safety. This includes those who are required to make managerial decisions where process safety is a key consideration, those who are moving into process safety positions or those who wish to broaden their process safety knowledge within their existing discipline. It is particularly suited for anyone involved in the design, operation, modification or maintenance of a major hazard installation, and will demonstrate a substantial understanding of process safety for those engaged in Continuous Professional Development or aiming for Chartered Engineer status. This course will benefit professionals such as: Operations and maintenance supervisors Process, mechanical and chemical engineers and technicians Design engineers, project engineers and HSE managers Control, automation and instrumentation engineers Course Level Advanced Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. 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