2410 Courses in Sheffield delivered Online

Our new and improved pipe and pump sizing calculator tool. This one hour session will provide an introduction into the following: Justifying the default values (maximum & minimum velocities, pressure loss etc) Preparing a schematic as a reference. Labelling sections and identifying circuits. Picking rooms or radiators for total mass flow rate (kg/s) Selecting flow temperatures and delta temperatures. Selecting pipe sizes for each section. Reviewing the automated velocity checks (m/s) Reviewing the automated maximum pressure drop allowance (Pa/m) Creating circuits Reviewing the index circuit Final results to size your circulation pump. Q & A session after the above is explained and demonstrated.

Starting with the basics, such as variables and operators, to advanced concepts, such as inheritance and encapsulation, this course covers the entire spectrum to help you gain the skills needed to start developing applications in TypeScript.

The Computer Vision course with C++ and OpenCV with GPU support provides an introduction to computer vision and its applications using C++ and OpenCV with GPU acceleration. Students will learn about setting up the necessary environments, basic examples, background segmentation, object detection with OpenCV's ML module using C++ and CUDA, and optical flow. Learning Outcomes: Set up the required environments for C++ and OpenCV with GPU support. Understand the fundamentals of computer vision and its applications. Implement background segmentation techniques to extract relevant objects from the environment. Use OpenCV's ML module with C++ and CUDA to perform object detection efficiently. Apply optical flow algorithms to track object movements and analyze motion patterns. Why buy this Computer Vision: C++ and OpenCV with GPU support? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Computer Vision: C++ and OpenCV with GPU support there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Computer Vision: C++ and OpenCV with GPU support course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Computer Vision: C++ and OpenCV with GPU support does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Computer Vision: C++ and OpenCV with GPU support was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Computer Vision: C++ and OpenCV with GPU support is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Set up Necesssary Environments Module 01: Driver installation 00:06:00 Module 02: Cuda toolkit installation 00:01:00 Module 03: Compile OpenCV from source with CUDA support part-1 00:06:00 Module 04: Compile OpenCV from source with CUDA support part-2 00:05:00 Module 05: Python environment for flownet2-pytorch 00:09:00 Unit 02: Introduction with a few basic examples! Module 01: Read camera & files in a folder (C++) 00:11:00 Module 02: Edge detection (C++) 00:08:00 Module 03: Color transformations (C++) 00:07:00 Module 04: Using a trackbar (C++) 00:06:00 Module 05: Image filtering with CUDA (Introduction to using OpenCV GPU methods on C++) 00:13:00 Unit 03: Background segmentation Module 01: Background segmentation with MOG (C++) 00:04:00 Module 02: MOG and MOG2 cuda implementation (C++ - CUDA) 00:03:00 Module 03: Special app: Track class 00:06:00 Module 04: Special app: Track bgseg Foreground objects 00:08:00 Unit 04: Object detection with openCV ML module (C++ CUDA) Module 01: A simple application to prepare dataset for object detection (C++) 00:08:00 Module 02: Train model with openCV ML module (C++ and CUDA) 00:13:00 Module 03: Object detection with openCV ML module (C++ CUDA) 00:06:00 Unit 05: Optical Flow Module 01: Optical flow with Farneback (C++) 00:08:00 Module 02: Optical flow with Farneback (C++ CUDA) 00:06:00 Module 03: Optical flow with Nvidia optical flow SDK (C++ CUDA) 00:05:00 Module 04: Optical flow with Nvidia Flownet2 (Python) 00:05:00 Module 05: Performance Comparison 00:07:00 Additional Resource Resources - Computer Vision: C++ and OpenCV with GPU support 00:00:00 Assignment Assignment - Computer Vision: C++ and OpenCV with GPU support 00:00:00

PRINCE2 Agile® Foundation: In-House Training PRINCE2 Agile® provides structure, governance, and control when working with agile concepts, methods, and techniques. It 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® Foundation certificate is designed to help professionals deliver agile projects by tailoring PRINCE2® management controls with a broad toolset of agile delivery techniques and frameworks. 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 key aspects of PRINCE2® Understand basic concepts behind common agile ways of working Demonstrate the purpose of combining PRINCE2® with agile Be 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 Incorporate the areas that can support a PRINCE2 Agile® implementation To prepare Participants for the PRINCE2 Agile® Foundation 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. Introduction - Getting Started Part 1 An overview of PRINCE2 Agile Overview Blending PRINCE2 and Agile What to fix and what to flex Part 2 Agile behaviors ad the PRINCE2 Principles Agile and the PRINCE2 Themes Part 3 Focus areas Agile and the PRINCE2 Processes Examination preparation Examination. Summary - What did we learn, and how can we implement this in our work environment?

About this Training Course Identifying and correcting the root cause of failures in boilers and steam power plant equipment is essential to help reduce the chance of future problems. A comprehensive assessment is the most effective method of determining the root cause of a failure. For example, a tube failure in a boiler is usually a symptom of other problems. To fully understand the root cause of the failure, one must investigate all aspects of boiler operation leading to the failure in addition to evaluating the failure itself. When a boiler tube failure occurs, the root cause of the failure must be identified and eliminated. This 5 full-day course starts by providing an in-depth understanding of root cause analysis methodology. This includes how to identify the problem, contain and analyze the problem, define the root cause of the problem, define and implement the actions required to eliminate the root cause, and validate that the corrective actions prevented recurrence of the problem. Many practical examples on how to apply root cause analysis for various industrial problems are discussed in detail. The course then provides an in-depth explanation of all failure mechanisms that occur in steam power plants including corrosion, erosion, creep, cavitation, under-deposit attacks, stress corrosion cracking, hydrogen embrittlement, flow accelerated corrosion, etc. This course also provides a thorough explanation of all the failure mechanisms that occur in boilers and steam power plant equipment including steam turbines, condensers, feedwater heaters, etc. The symptoms of the failures, possible causes, components typically affected and solutions are also provided in this course. This includes boiler waterside, fireside and general boiler failure mechanisms as well as all the causes and prevention of all steam turbine failures, condensers, and feedwater heaters. The course also includes detailed study of many case histories of failures in boilers, steam turbines, condensers and feedwater heaters. Training Objectives Electrical Equipment Testing and Maintenance: Gain a thorough understanding of all the testing and maintenance required for all key electrical equipment including transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Root Cause Analysis Methodology: Understand root cause analysis methodology including: identification of the problem, defining the problem, understanding the problem, identification of the root cause of the problem, providing corrective action, and monitoring the system. Applying the Root Cause Analysis Method to Industrial Problems: Learn by studying many practical examples how to apply the root cause analysis method to various industrial problems. Damage Mechanisms in Boilers and Steam Power Plant Equipment: Gain a thorough understanding of all the damage mechanisms that occur in boilers and all steam power plant equipment including turbines, condensers and feedwater heaters. These mechanisms include corrosion, erosion, flow accelerated corrosion, stress corrosion cracking, creep, under-deposit attack, cavitation, hydrogen embrittlement, etc. Symptoms of Failures in Boilers and Steam Power Plant Equipment, Possible Causes, Components Typically Affected, and Solutions: Learn about all the symptoms of failures in boilers and steam power plant equipment including steam turbines, condensers, and feedwater heaters, their possible causes, components typically affected and proven solutions. Case Histories of Failures in Boilers, Steam Turbines, Condensers, and Feedwater Heaters: Learn by studying many case histories how failures occur in boilers, steam turbines, condensers, and feedwater heaters and the corrective actions taken to deal with them     Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals (this seminar is suitable for individuals who do not have an electrical background) Course Level Basic or Foundation 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 copy of the following materials written by the instructor: Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2011 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) ROOT CAUSE ANALYSIS FOR BOILERS AND STEAM CYCLE FAILURES MANUAL (includes practical information and case histories - 500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

About this Training Course This 5 full-day course provides detailed description of all combustion equipment and systems used in pulverized coal boilers and circulating fluidized bed (CFB) boilers including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans. This course provides also a comprehensive explanation of all boiler combustion control systems including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system as well as their tuning methods. All boiler control systems are covered as well in this course including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, boiler-turbine coordinated control, etc. The course provides also detailed explanation of Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code). The burner management systems (BMS) and examples of boiler permissive starting logic and protective tripping logic will be explained thoroughly. The various methods used to calculate the boiler efficiency are covered in detail in this course including the direct and indirect methods. All the factors which affect the efficiency and emissions of pulverized coal boiler and CFB boiler will be explained thoroughly. The course covers also all the methods used to improve the efficiency of pulverized coal boilers and CFB boilers including improvement to their combustion efficiency and control systems performance. Training Objectives Boiler Combustion Equipment and Systems: Gain an in-depth understanding of all boiler combustion equipment and systems including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans Boiler Combustion Control Systems: Gain a thorough understanding of all boiler combustion control systems for pulverized coal boilers, and CFB boilers including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system Boiler Conventional Control Systems: Gain an in-depth understanding of all boiler conventional control systems including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, and boiler-turbine coordinated control Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code): Learn about NFPA 85 code and ANSI/ISA-77-44-01-2007 code Burner Management System and Boiler Permissive Starting Logic and Protective Tripping Logic: Gain an in-depth understanding of burner management system and boiler permissive starting logic and protective tripping logic Boiler Efficiency Calculations: Learn how to calculate the boiler efficiency using the direct and indirect methods Factors Affecting the Efficiency and Emissions of Boilers: Understand all the factors which affect the boiler efficiency and emissions Methods Used to Improve the Efficiency of Boilers: Learn about all the methods used to improve the efficiency of pulverized coal boilers, and CFB boilers including improvement to their combustion efficiency and control systems performance Boiler Instrument and Piping Diagrams: Gain an in-depth understanding of all boiler instrument and piping diagrams CFB and Pulverized Coal Boilers Equipment and Systems: Learn about various types of equipment and systems used in CFB and pulverized coal boilers including economizers, steam drum, superheaters, air preheaters, ammonia injection systems, etc. Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation 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 copy of the following materials written by the instructor: Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) COMBUSTION ENGINEERING FOR COAL FIRED POWER PLANTS MANUAL (includes practical information about combustion engineering for coal fired power plants - 550 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

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

Imagine yourself at a bustling construction site, surrounded by roaring machinery and a sea of vehicles. The chaos seems overwhelming, but amidst it all stands a confident figure, a Traffic Marshal. With a wave of their hand and a calm presence, they bring order to the frenzy, ensuring safety and efficient traffic flow. Have you ever wondered how you could be that hero, the one who keeps everything moving smoothly? Look no further than our captivating course, Traffic Marshal, where you'll learn the skills needed to become a master of traffic control in real-life scenarios. Learning Outcome: The Traffic Marshal course empowers individuals with the expertise to manage traffic effectively and ensure safety. By the end of the course, you will: Develop expertise in traffic management and control techniques, becoming a confident Traffic Marshal. Understand the principles of temporary traffic control in various scenarios, optimising the flow of vehicles. Acquire skills in vehicle signalling and managing reversing vehicles, ensuring smooth and efficient traffic flow. Perform effective traffic risk assessments to identify and address potential hazards, prioritising safety. Apply health and safety practices in traffic management situations, maintaining a secure environment for all. The Traffic Marshal course offers a comprehensive curriculum that equips individuals with the skills and knowledge to become masters of traffic control. In Module 01, you'll be introduced to the fundamentals of traffic marshalling, learning the core principles of this critical role. Module 02 delves deeper into traffic management techniques, equipping you with strategies to optimise traffic flow. Module 03 focuses on temporary traffic control, providing insights into handling diverse situations like roadworks and events. Vehicle signalling and managing reversing vehicles are covered in Module 05 and Module 06, respectively. Throughout the Traffic Marshal course, emphasis is placed on performing traffic risk assessments and applying health and safety practices in traffic management scenarios. Embark on the Traffic Marshal course to unlock exciting career opportunities and become a skilled professional in traffic management and control. Enrol now and join the ranks of confident Traffic Marshals who ensure the safe and smooth flow of vehicles on the roads. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Traffic Marshal course is intended for - Individuals seeking a rewarding career in traffic management and control. Construction workers and site supervisors responsible for ensuring traffic safety. Anyone interested in enhancing their knowledge of Traffic Marshal practices. Career path This Traffic Marshal course can assist you in various career paths. Such as - Traffic Marshal: £18,000 - £25,000 per year Traffic Supervisor: £25,000 - £35,000 per year Traffic Control Manager: £30,000 - £45,000 per year Health and Safety Officer: £25,000 - £40,000 per year Construction Site Traffic Marshal: £35,000 - £55,000 per year

14 in 1 "Debt Financing" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Debt Financing course you are looking for? Can't find the complete Debt Financing package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive Debt Financing bundle that has everything you need to succeed in Debt Financing and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Debt Financing course that will enhance your skills and prepare you for the competitive job market. Furthermore, to help you showcase your expertise in Debt Financing, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These Debt Financing certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Debt Management - Online Course Course 02: Improve your Financial Intelligence Course 03: Financial Wellness: Managing Personal Cash Flow Course 04: Financial Analysis : Finance Reports Course 05: Banking and Finance Accounting Statements Financial Analysis Course 06: Financial Modeling Course for a Non-Finance Background Course 07: Capital Budgeting & Investment Decision Rules Course 08: Budgeting and Forecasting Course 09: Financial Analysis Course 10: Investment Banking & Valuation Course 11: Finance Assets Course 12: Level 3 Tax Accounting Course 13: Essentials of UK VAT Course 14: Fraud Management & Anti Money Laundering Awareness Complete Diploma Enrol now to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this Course: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum Course 01: Debt Management - Online Course Introduction to Debt Management Long Term and Short Term Debt Identifying Your Debt Debt Management Plan Debt Assessment Building Budget Debt Counselling When Is Debt Good? Avoiding Debt Problems How to Handle Debt Collectors How to Get Out of Debt Dealing with Bankruptcy and Insolvency Laws and Regulations Course 02: Improve your Financial Intelligence Introduction The Three Key Financial Statements Ratio Analysis Profit vs Cash Managing Working Capital Return on Investments A broader Perspective How much have you learned Course 03: Financial Wellness: Managing Personal Cash Flow Introduction to Personal Cash Flow Understanding the Importance of Personal Finance Accounting and Personal Finances Cash Flow Planning Understanding Personal Money Management Borrowing, Credit and Debt Managing Personal Insurance Understanding Tax and Financial Strategies Designing a Personal Budget Money and Mental Health Course 04: Financial Analysis : Finance Reports Welcome to the Course! Get the Overview of What You'll Learn What is a 10-K? Evaluating Profitability by Analyzing the Income Statement Evaluating Operations: Tying Operating Metrics to Financial Results Evaluating Financial Strength: Balance Sheet Analysis Evaluating Cash Flow Generation Performing Investment Analysis Course 05: Banking and Finance Accounting Statements Financial Analysis Introduction and Welcome to the Course Introduction to Accounting Introduction to Financial Statements Understanding Working Capital Introduction to Financial Analysis Financial Analysis - Case Study and Assignment Financial Ratio Analysis in Corporate Finance Financial Modelling for Mergers and Acquisitions Course Summary and Wrap Up Course 06: Financial Modeling Course for a Non-Finance Background Introduction Project Cost Depreciation Schedule of Term Loan Profit and Loss Account Preparation of Balance sheet Course 07: Capital Budgeting & Investment Decision Rules Introduction NPV Method Payback Period Method Internal Rate of Return (IRR) Evaluating Projects in Different Lives Conclusion Course 08: Budgeting and Forecasting Introduction Detail Budget Requirement Process of Making Budget Course 09: Financial Analysis Introduction Profitability Return Ratio Liqudity Ratio Operational Analysis Detecting Manipulation Course 10: Investment Banking & Valuation Introduction to Investment Banking Structure and Side of Investment Banking Valuation Methods in Investment Banking Leveraged Buyout (LBO) Initial Public Offering (IPO) Merger and Acquisition Ethics in Investment Banking Course 11: Finance Assets Finance and Free Market Economies Corporate Finance Company Stock Valuation & Derivatives Option Valuation: Fundamentals vs. Technical Analysis Financial Forecasting Course 12: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Advanced Income Tax Payee, Payroll and Wages Capital Gain Tax Value Added Tax Import and Export Corporation Tax Inheritance Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 13: Essentials of UK VAT Understanding VAT VAT Terminology and Calculation VAT Taxable Persons VAT Registration VAT Rates Invoicing and Records VAT Application in Goods, Services and Vehicles Supply The VAT Return Tips on VAT Compliance VAT Exemptions and Zero-Rated VAT Miscellaneous VAT Issues and Penalties Making Tax Digital Course 14: Fraud Management & Anti Money Laundering Awareness Complete Diploma Introduction to Money Laundering Proceeds of Crime Act 2002 Development of Anti-Money Laundering Regulation Responsibility of the Money Laundering Reporting Office Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle including- Students Graduates Job Seekers Job Holders Requirements Our Debt Financing is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Debt Management - Online Course) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Debt Management - Online Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Ever wondered how businesses tick? What makes them thrive or tumble? The Level 5 Diploma in Accountancy is your key to deciphering the fascinating world of numbers and unlocking a rewarding career in the heart of financial operations. You will learn how to analyse financial data and make informed decisions that can improve business performance. This accountancy course will also develop your logical thinking and problem-solving abilities, which are essential for any accounting professional. Explore the core of accounting, figuring out its complexities and revealing the financial management mysteries. Discover the essence of Accountancy in every module, from the fundamental principles to the advanced techniques. With a comprehensive exploration of key concepts like double-entry bookkeeping, balance sheets, and cash flow statements, this course will empower you to navigate the complexities of finance with confidence. Elevate your understanding of financial statements, unravel the mysteries of auditing, and delve into the realms of financial budgeting and planning. So, embark on an intellectual adventure that transcends mere calculations. This Level 5 Diploma in Accountancy is your key to unlocking a rewarding career in the dynamic world of finance. Are you ready to decipher the code and become a financial maestro? Level 5 Diploma in Accountancy Course Learning Outcomes: Master the fundamental principles and practices of accountancy. Confidently navigate double-entry bookkeeping systems. Analyse and interpret financial statements with expert precision. Understand the role of accountants in various organizational settings. Develop critical thinking skills to interpret cash flow and budgeting strategies. Gain a solid theoretical foundation for further advancement in accountancy. Level 5 Diploma in Accountancy Module 01: Introduction to Accounting Module 02: The Role of an Accountant Module 03: Accounting Concepts and Standards Module 04: Double-Entry Bookkeeping Module 05: Balance Sheet Module 06: Income statement Module 07: Financial statements Module 08: Cash Flow Statements Module 09: Understanding Profit and Loss Statement Module 10: Financial Budgeting and Planning Module 11: Auditing Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Who is this course for? Level 5 Diploma in Accountancy The Level 5 Diploma in Accountancy is designed for individuals seeking to enhance their skills and knowledge in the dynamic field of Accountancy, like - Assistant Accountant Accounts Payable/Receivable Clerk Cost Accountant Financial Analyst Bookkeeper Internal Auditor Tax Accountant Requirements Level 5 Diploma in Accountancy To enrol in this Level 5 Diploma in Accountancy, Purchasing & Procurement course, all you need is a basic understanding of the English Language and an internet connection. Career path Level 5 Diploma in Accountancy Accounts Assistant: £20,000 to £25,000 per year Payroll Administrator: £22,000 to £28,000 per year Bookkeeper: £22,000 to £30,000 per year Tax Assistant: £25,000 to £35,000 per year Management Accountant: £30,000 to £40,000 per year Financial Analyst: £35,000 to £45,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each