7128 Systems courses delivered Online

Overview of Heating, Ventilation & Air Conditioning (HVAC) Technician Whether it's the middle of a heatwave or the depths of winter, we rely on our heating and cooling systems to keep us comfortable. As an HVAC technician, you'll be at the frontline, maintaining homes and businesses running smoothly. According to the Office for National Statistics, over 170,000 HVAC engineers are in the UK, with demand growing as climate change leads to more extreme temperatures. This comprehensive Heating, Ventilation & Air Conditioning (HVAC) Technician course covers everything you need - from the fundamentals of thermodynamics to safety procedures.  Empower your future with the knowledge and skills to keep the world comfortable and relaxed. Enrol today and unlock the potential within you! Get a Quick Look at The Course Content: This Heating, Ventilation & Air Conditioning (HVAC) Technician Course will help you to learn: Explain the principles of heating, ventilation and air conditioning systems. Identify and select appropriate HVAC equipment and tools. Installed, maintained, and repaired HVAC systems and components. Follow safety procedures for working with electrical, gas and refrigeration systems. Troubleshoot faults in HVAC systems and carry out diagnostic tests. Communicate effectively with clients to diagnose issues. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Heating, Ventilation & Air Conditioning (HVAC) Technician. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Heating, Ventilation & Air Conditioning (HVAC) Technician course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals looking to start a career as an HVAC technician or engineer. Technicians want to expand their skills and knowledge in the field. Experienced HVAC professionals are seeking a refresher or certification. Builders, electricians and plumbers are looking to diversify their services. Facilities managers are responsible for maintaining HVAC systems. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Heating, Ventilation & Air Conditioning (HVAC) Technician course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Heating, Ventilation & Air Conditioning (HVAC) Technician Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. HVAC Engineer - £30k to £48k per year. Service Technician - £21k to £31k per year. Installation Technician - £22k to £45k per year. Facilities Manager - £30k to £60k per year. HVAC Inspector - £35k to £55k per year. Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Heating, Ventilation & Air Conditioning (HVAC) Technician Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) 00:16:00 Module 02: Heating Fundamentals and Psychrometrics 00:36:00 Module 03: HVAC Systems 00:18:00 Module 04: Heating and Ventilation 00:25:00 Module 05: Air Conditioning Systems for HVAC Technicians 00:26:00 Module 06: Compressors, Water Chillers, and Fans 00:28:00 Module 07: Piping for HVAC Technician 00:23:00 Module 08: Duct System in HVAC 00:31:00 Module 09: Refrigeration and Refrigerants 00:24:00 Module 10: Special Applications 00:27:00 Module 11: HVAC System Selection 00:21:00 Module 12: Safety in the HVAC Industry 00:30:00

[vc_row][vc_column][vc_column_text] Description: It is not always necessary to follow advanced accounting software such as Quickbook and Zero, especially if you're a small business owner. The Diploma in Bookkeeping course provides expert traditional manual bookkeeping training, as well as an overview of the computerised bookkeeping system. Are you an entry-level trainee who wishes to kickstart your career in bookkeeping and accounting ? This course will help you to earn your accounting qualification in no time. Bookkeeping is the recording of accounting and financial transactions. This course introduces the many aspects of bookkeeping, such as ledgers, journals, financial statements, income tax and records. To begin with, this training course will focus on manual bookkeeping and common accounting terminology. Next, you will learn the functionality of bookkeeping covering topics such as trial balance and coding, final figures and online bookkeeping. Finally, you will learn the differences between a manual system and a computerised system, and the benefits of both. The purpose of this bookkeeping course is to help you to apply the bookkeeping system to your business. On successful completion, this diploma in accounting and bookkeeping can be used to advance your professional development and fast-track your way to earning your AAT qualification. Who is the course for? Business owners, students of accountancy/ finance/bookkeeping, budding finance directors and management accountants Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Introduction to the course Introduction 00:02:00 Bookkeeping systems Manual System 00:08:00 Computerised Systems 00:10:00 How it Fits Together 00:08:00 The functionality of bookkeeping Ledgers 00:10:00 Trial Balance and Coding 00:10:00 PNL Account and Balance Sheet 00:04:00 On a personal note AILE Personal 00:05:00 Mock Exam Mock Exam - Diploma in Bookkeeping 00:20:00 Final Exam Final Exam - Diploma in Bookkeeping 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Description Get instant knowledge from this bite-sized Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 course. This course is very short and you can complete it within a very short time. In this Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 course you will get fundamental ideas of heating, ventilation and air conditioning, the key understanding of heating fundamentals, psychrometrics and so on. Enrol in this course today and start your instant first step towards learning about heating, ventilation and air conditioning (HVAC). Learn faster for instant implementation. Learning Outcome Familiarise with heating, ventilation and air conditioning (HVAC) Understand heating fundamentals and psychrometrics Gain in-depth knowledge of the HVAC Systems Deepen your understanding of heating and ventilation How Much Do HVAC Technicians Earn? Senior - £60,000 (Apprx.) Average - £39,000 (Apprx.) Starting - £25,000 (Apprx.) Requirement Our Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) 00:13:00 Module 02: Heating Fundamentals and Psychrometrics 00:33:00 Module 03: HVAC Systems 00:15:00 Module 04: Heating and Ventilation 00:22:00 Assignment Assignment - Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 00:00:00

Course Description Get instant knowledge from this bite-sized Residential Property Sales Part - 2 course. This course is very short and you can complete it within a very short time. In this Residential Property Sales Part - 2 course you will get fundamental ideas of residential property sales, the key understanding of property appraisal, basic building construction and defects and so on. Enrol in this course today and start your instant first step towards learning about the finances involved in buying and selling property. Learn faster for instant implementation. Learning Outcome Familiarise with finances involved in buying and selling property Understand property appraisal and basic building construction and defects Gain in-depth knowledge of the records and systems Deepen your understanding of the UK tax on property How Much Do Property Managers Earn? Senior - £45,000 (Apprx.) Average - £31,000 (Apprx.) Starting - £21,000 (Apprx.) Requirement Our Residential Property Sales Part - 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Residential Property Sales Part - 2 Module 01: Finances Involved in Buying and Selling Property 00:15:00 Module 02: Property Appraisal and Basic Building Construction and Defects 00:28:00 Module 03: Records and Systems 00:21:00 Module 04: UK Tax on Property 00:35:00 Assignment Assignment - Residential Property Sales Part - 2 00:00:00

Navigate the complexities of Global Economics with our expertly designed course. Explore international trade, finance, globalization, and the intricacies of economic development. Prepare for the future with insights into geoeconomics, geopolitics, and global governance.

Journey into the intricate world of automotive engineering with our enlightening course, 'Basic Automotive Engineering: Onboard Diagnostics'. Delve deep into the heart of modern vehicles and discover the significance of onboard diagnostics. Beginning with an enlightening introduction, the course progressively unveils the multifaceted aspects of diagnostics and the multitude of systems they govern. Prepare to navigate the circuits and sensors that keep vehicles running seamlessly and efficiently in our tech-driven world. Learning Outcomes Understand the foundational principles of automotive engineering. Gain insights into the role and importance of onboard diagnostics in vehicles. Explore the diverse aspects related to onboard diagnostics. Become proficient in recognising and interpreting different automotive systems. Develop a comprehensive understanding of the latest diagnostic techniques and applications. Why choose this Basic Automotive Engineering: Onboard Diagnostics course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Basic Automotive Engineering: Onboard Diagnostics Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Basic Automotive Engineering: Onboard Diagnostics course for? Individuals curious about automotive engineering and diagnostics. Professionals in the automotive industry seeking foundational knowledge. Students pursuing a career in automotive technology. Vehicle enthusiasts eager to understand their vehicles better. Technical experts aiming to expand their skillset. Career path Automotive Engineer - £28,000 - £50,000 Diagnostics Technician - £20,000 - £35,000 Automotive Systems Analyst - £30,000 - £48,000 Vehicle Inspector - £21,000 - £38,000 Service Advisor - £19,000 - £32,000 Auto Parts Manager - £24,000 - £40,000 Prerequisites This Basic Automotive Engineering: Onboard Diagnostics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Basic Automotive Engineering: Onboard Diagnostics 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction Introduction 00:01:00 Brief history & Basic working of OBD 00:08:00 Unit 02: Various Aspects of Onboard diagnostics Onboard diagnostic apps 00:07:00 Exhaust gas-Diagnostics 00:07:00 APPS on Onboard diagnostics 00:07:00 Unit 03: Various systems Engine-Diagnostics 00:05:00 Diagnostics-spark plug 00:06:00 Diagnostics- Fuel injection 00:06:00 Diagnosis -Lubrication 00:07:00 Assignment Assignment - Basic Automotive Engineering: Onboard Diagnostics 00:00:00

Earn your Level 3 Certificate in Clinical Coding and master ICD-10, OPCS-4, and SNOMED CT systems. Perfect for healthcare professionals, medical records technicians, and data analysts. Gain comprehensive coding skills and advance your career in clinical documentation and health information management.

Unlock the secrets of ancient and modern healing with our comprehensive massage therapy training. Imagine being able to provide unparalleled relaxation and rejuvenation, using time-honoured techniques blended with contemporary practices. Our meticulously crafted programme delves into the intricacies of the human body, from the complex interplay of tissues and organs to the vital neuromuscular systems. With our expert guidance, you will master the art of creating a tranquil, restorative experience, tailored to the unique needs of each individual. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Equip yourself with the knowledge and tools to transform lives. Our training covers everything from the essential equipment to the most effective massage techniques. You'll learn how to execute a full body massage with precision and grace, incorporating elements of Swedish and LomiLomi methods. This journey will empower you to bring harmony and well-being to those you touch, making a profound impact on their health and happiness. Join us and become a conduit for peace and wellness, skillfully blending tradition and innovation in every session. Course Curriculum Module 01: Introduction To Massage Therapy Module 02: Tissues, Organs, & Neuromuscular Systems Module 03: Equipment Module 04: Techniques Module 05: Full Body Massage Module 06: Swedish Massage Module 07: LomiLomi Massage Learning Outcomes: Identify tissues, organs, and neuromuscular systems relevant to massage therapy. Demonstrate proficiency in using massage therapy equipment effectively. Apply various massage techniques to address specific client needs. Perform a full body massage with skill and precision. Execute Swedish massage techniques to promote relaxation and wellness. Master the art of LomiLomi massage for holistic healing experiences. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking comprehensive training in massage therapy techniques. Spa and wellness enthusiasts looking to enhance their skillset. Healthcare professionals interested in expanding their holistic therapy repertoire. Fitness trainers aiming to incorporate massage therapy into client sessions. Those passionate about promoting relaxation and holistic well-being. Career path Massage Therapist Spa Therapist Wellness Centre Masseuse Sports Massage Therapist Beauty Salon Masseur Self-Employed Massage Practitioner Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Mechanical Engineering & HVAC 15 in 1 Complete Bundle | Fundamentals of Centrifugal Pump | Plate Heat Exchanger | HVAC Technician | Internal Combustion Engine | Engine Lubricant System Training | Energy Saving in Electric Motors | Portable Appliance Testing (PAT)| Electrical and Fire Safety and much more Mechanical engineering- without it, we would not have engines to run cars, generators for power, elevators or even air conditioning. So, while you might not even realise it, you most likely use something that has been mechanically engineered every day. Statistics have predicted that the Mechanical Engineering employment rate will go up by 9% by 2026. About 20,200 openings for mechanical engineers are projected each year, on average, over the decade. The average salary of a Mechanical Engineer is around £66,442 in the UK; furthermore, an expert in the field can make £85,000 or even higher. After surveying thousands of learners just like you and considering their valuable feedback, this all in one Mechanical Engineering & HVAC bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Mechanical Engineering & HVAC course that will enhance your skills and prepare you for the competitive job market. Also, our Mechanical Engineering & HVAC experts are available to answer your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Learning Outcomes of Mechanical Engineering & HVAC Understand the basic principles of engineering mechanics, including statics and dynamics. Demonstrate knowledge of thermodynamics and heat transfer. Analyze and design mechanical systems and devices using knowledge of mechanics and materials science. Develop proficiency in fluid mechanics and its application to real-world problems. Understand the principles of structural analysis and design. Demonstrate proficiency in machine design and dynamics. This Mechanical Engineering & HVAC Bundle Consists of the following Premium courses: Course 01: Mechanical Engineering Course 01: Engineering Mechanics Course for Beginners Course 02: Crack Your Mechanical Engineer Interview Course 03: HVAC Basics and Load Calculation Masterclass Course 04: Mechanical Engineering Course 05: Basic Automotive Engineering: Onboard Diagnostics Course 06: Engine Lubricant System Training - Level 4 Course 07: A complete course on Turbocharging Course 08: Supercharger Automobile Engineering Course 09: Electric Vehicle Battery Management System Course 10: Hybrid Vehicle Expert Training Course 11: Energy Saving in Electric Motors Course 12: Rotating Machines Course 13: Large Goods Vehicle (LGV) Course 14: Workshop Technology: Machine Shop Theory Curriculum of Mechanical Engineering & HVAC Bundle Course 01: Engineering Mechanics Course for Beginners Module 01: Introduction Module 02: Engineering Mechanics - I Module 03: Engineering Mechanics - II Module 04: Heat and Thermodynamics Module 05: Work, Force and Energy Module 06: Fluid Mechanics Module 07: Structural Mechanics Module 08: Machines - I Module 09: Machines - II Module 10: Machine Dynamics Module 11: Mechanical Design Module 12: Hydraulic Machines Module 13: Strain Hardening Processes Module 14: Application of Solidification Module 15: Welding Module 16: Engineering Drawing The detailed curriculum of the Mechanical Engineering & HVAC bundle is given in the resources section. How will I get my Certificate? After successfully completing the Mechanical Engineering & HVAC 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) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Mechanical Engineering course is designed for individuals who are interested in pursuing a career in the field of engineering. This course is particularly suited for those who enjoy problem-solving, critical thinking, and designing mechanical systems and devices. There are many potential job titles for individuals with a degree in Mechanical Engineering. Here are some examples: Mechanical Engineer Manufacturing Engineer Structural Engineer Quality Control Engineer Research and Development Engineer HVAC Engineer Robotics Engineer Materials Engineer Industrial Engineer Product Development Engineer Energy Engineer Project Engineer Design Engineer Requirements Mechanical Engineering & HVAC Training Career path Mechanical Engineering & HVAC Training After completing the Mechanical Engineering course, you will be well-equipped to pursue a career in various industries such as: Mechanical Engineer - £35,000 to £70,000 Manufacturing Engineer - £30,000 to £60,000 Aerospace Engineer - £40,000 to £80,000 Automotive Engineer - £35,000 to £75,000 Structural Engineer - £35,000 to £60,000 Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Engineering Mechanics Course for Beginners) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Engineering Mechanics Course for Beginners) 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.

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included