6980 Systems courses delivered Online

Autocad face to face training customised and bespoke.

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

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

This course is designed to enable the learner to analyse and appraise investment options using different investment appraisal techniques. The learner will also be able to understand the costing system involved in investment decisions and generally prevalent in the business environment. After the successful completion of this lecture, you will be able to understand the following: The concept of investment. The motives of investment. The meaning of the money market and its various functions. Understand the various instrument of the money market. The concept of the Costing System. The various types of costing systems. The different classification of cost. Various cost control of systems. Calculation of cumulative cost variance. The various strategies of pricing policy. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding the Investment Appraisal Techniques Self-paced pre-recorded learning content on this topic. Quiz: Understanding The Investment Appraisal Techniques Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Learning and Development Manager Finance Manager Investment Manager/specialist Market behaviour Specialist Operations Manager Team Lead Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Overview From the skin to the deepest of our bones, the human body is full of amazing mechanisms. If you are fascinated by these mechanisms and want to learn more about them, then this Human Anatomy & Physiology Diploma is what you need.  This course will introduce you to the ins and outs of human anatomy. From the highly informative modules, you will learn about the process of cell division. The course will educate you on skin, tissue and muscles.  Further in the study, you will get to enhance your knowledge of different systems of human anatomy, such as the skeletal system, reproductive system, urinary system and more. Moreover, the course will help you understand how our brain works.  Enrol now and explore the human body! Course Preview Learning Outcomes Enhance our understanding of the chemistry of cells and cell division Gain in-depth knowledge of the process of metabolism Deepen your knowledge of the human skeletal system Understand how the muscular system works in the human body Learn about the nervous system and sensory system Explore the vital areas of the immune system, digestive system, reproductive system and much more. Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email Who Should Take this Human Anatomy & Physiology Diploma Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Human Anatomy & Physiology Diploma is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Human Anatomy & Physiology Diploma will equip you with effective skills and abilities and help you explore career paths such as Biology Teacher Teaching Assistant Health Care Worker Public Health officer Module 01: The Chemistry of Cells The Chemistry of Cells 00:27:00 Module 02: Cells Cells 00:16:00 Module 03: Cell Division Cell Division 00:19:00 Module 04: Replication and Metabolism Replication and Metabolism 00:20:00 Module 05: Human Tissues Human Tissues 00:25:00 Module 06: Skin Skin 00:16:00 Module 07:Human Skeletal System Human Skeletal System 00:21:00 Module 08: The Muscular System The Muscular System 00:17:00 Module 09: Skeletal Muscle Fibre Skeletal Muscle Fibre 00:23:00 Module 10: Nervous System Nervous System 00:31:00 Module 11: The Brain The Brain 00:25:00 Module 12: Nervous System-Spinal Cord and Spinal Nerves Nervous System-Spinal Cord and Spinal Nerves 00:15:00 Module 13: Nervous System - Autonomic Nervous System and Cranial Nerves Nervous System - Autonomic Nervous System and Cranial Nerves 00:21:00 Module 14: Nervous System-The Eyes Nervous System-The Eyes 00:15:00 Module 15: Nervous System-The Ears, Hearing, and Equilibrium Nervous System-The Ears, Hearing, and Equilibrium 00:14:00 Module 16: Nervous System-Memory Nervous System-Memory 00:19:00 Module 17: Sensory Systems Sensory Systems 00:23:00 Module 18: Cardiovascular System Cardiovascular System 00:25:00 Module 19: Blood Blood 00:27:00 Module 20: Lymphatics Lymphatics 00:20:00 Module 21: Immune System Immune System 00:26:00 Module 22: Digestive System Digestive System 00:22:00 Module 23: Respiratory System Respiratory System1 00:16:00 Module 24: Urinary System Urinary System 00:16:00 Module 25: Male Reproductive System Male Reproductive System 00:31:00 Module 26: Female Reproductive System Female Reproductive System 00:31:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 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.

Agile techniques and management frameworks are changing the way organisations operate. Evolving to realise that organisations are no longer static and structured entities is the key to unlocking new ways to achieve better results. Agile can be utilised at an organisation, team, and project level. Transforming to an Agile way of working requires knowledge, commitment, and frameworks to lead change. The Applying Professional Scrum training teaches key implementation techniques and Scrum frameworks. Course Description Applying Professional Scrum Training ONLINE Getting results with the Scrum framework Scrum is the most used Agile framework for complex product development and project management. It is a proven system, in use for over 25 years by companies large and small. Scrum training introduces an iterative and incremental approach to product or project development – aiming to reduce complexity and achieve results faster. A Scrum team works simultaneously rather than sequentially, with more flexibility. Scrum teams learn to work better together, delivering more value for project stakeholders. Applying professional scrum training The Applying professional Scrum (APS) course introduces the Scrum framework and demonstrates its power over traditional approaches to project or product development. It is an interactive course that aims to familiarise participants with its iterative and 'Sprint' based methodology. The Scrum framework is commonly used in software development but is relevant in any industry or to any complex project. Course contents and key objectives The course will teach participants how to apply Professional Scrum and the Scrum framework. It is appropriate for anyone, whether or not they have previous exposure to Scrum. Contents of the two-day course include: Understanding more about Agile development and the value that an Agile mindset can bring. Explain how Scrum differs from traditional work models and the advantages this offers. Explain the details of the Scrum methodology and its practical application. Understand how to apply Scrum to projects and teamwork. This includes the concepts of the Scrum team, Sprints, Sprint reviews, and the Daily Scrum. Course attendees will work in Scrum teams to simulate a Scrum project. This will involve a series of 'sprints' to solve complex problems and demonstrate the Scrum approach's power. Such Sprints are key to the Scrum framework. They bring in the iterative way of working, giving teams the chance to review success and quickly adapt to meet business requirements. As part of this practical approach, participants will learn to recognize and understand common missteps and misunderstandings when using Scrum. Expected Outcomes from Applying professional scrum training Applying professional scrum training will teach attendees what Scrum is, the value it can deliver, and how to implement it. The practical and example-based nature of the course will help develop a thorough understanding of the Scrum framework. Experience is the key to implementing it in practice. As such, the course is designed to mimic this and teach the problems to look out for and their solution. Participants will emerge as proficient Scrum practitioners – ready to transform the development of their projects. Who Should Attend This Course? Scrum is beneficial for any company, or individual, with complex projects or products. This course provides an introduction and solid grounding in Scrum, enabling participants to work effectively within the Scrum team and to go on to further training if desired. It is ideal for anyone: Working in or joining a team that uses Scrum. Considering the use of Scrum or investigating its benefits. Working alongside or managing Scrum teams – even if not using the methodology directly. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Course Overview Build your expertise in plumbing sitting right at your home through the Online Plumbing Course. This course will introduce you to the fundamentals of plumbing. Within a few steps, you will learn the skills to solve plumbing problems and start a career in this field. The Online Plumbing Course will first introduce you to the UK standards of plumbing. Then you will learn about the plumbing tools and their functions. The easy-to-follow modules will help you understand the principles of the home plumbing system. You will become competent in plumbing installation and repairing plumbing systems. This course will also educate you on plumbing fixtures and provide you with valuable plumbing tips. This comprehensive Online Plumbing Course is the best place to start your training. Along with valuable skills, you will also receive a certificate of achievement. This certificate will help you boost your career. Enrol now and start learning! What You Will Learn Familiarise yourself with the UK standards of plumbing Get introduced to the basic plumbing tools Enrich your knowledge of the home plumbing system Learn the steps of plumbing installation Develop the skills to repair the plumbing system Deepen our knowledge and understanding of plumbing fixtures Why Should You Choose this Online Plumbing Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The Online Plumbing Course is designed for anyone interested to learn the principles of plumbing. It will be highly beneficial for people interested in a career as a plumber. Requirements Our Online Plumbing Course is fully compatible with any kind of device. So whether you are using Windows computers, 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 sort of limitation. Career Path This Online Plumbing Course will assist you in pursuing a career in the relevant fields. Plumber (Salary Range £28,000-£36,000) Online Plumbing Course Module 01: Basic Components of Plumbing 00:15:00 Module 02: Principles of Effective Plumbing Systems 00:15:00 Module 03: The Plumbing Tools 00:15:00 Module 04: The Plumbing Process 00:15:00 Module 05: Central Heating Systems 00:15:00 Module 06: Domestic Cold Water System 00:15:00 Module 07: Domestic Hot Water System - Part 1 00:15:00 Module 08: Domestic Hot Water System Part 2 00:15:00 Module 09: The Sanitation System and Repairs 00:15:00 Module 10: Domestic Rainwater System Installation 00:15:00 Module 11: Plumbing Projects: Case Study 00:15:00 Module 12: UK Standards for Plumbing 00:15:00

Once upon a time, in a world where energy consumption seemed like a dark mystery, a shining solution emerged-the Smart Meter. This innovative course, aptly titled Smart Meter, invites you to embark on a fascinating journey into the realm of energy monitoring and management. Prepare to unlock the secrets of this cutting-edge technology and gain the power to control your energy usage like never before. Learning Outcome: Develop a solid understanding of smart meter technology and its functionalities. Gain the knowledge to design and install smart metering systems effectively. Learn about meter installation guidelines and ensure compliance with industry standards. Conduct a comprehensive cost and benefit analysis of smart meters for informed decision-making. Familiarise yourself with smart metering policy guidelines, including the Smart Meters Act in the UK. The Smart Meter course takes you on a captivating journey through the modules, equipping you with the knowledge and skills to embrace energy efficiency in the digital age. Module 01 introduces you to the world of smart meters, providing a foundation for further exploration. Module 02 delves into the intricacies of designing smart metering systems, ensuring efficient energy monitoring. Essential skills take centre stage in Module 03, where you'll learn to install smart meters with precision. As you progress, modules cover essential topics such as meter installation guidelines, cost and benefit analysis, and policy guidelines. By the end of the Smart Meter course, you'll be empowered to make informed energy management decisions with the help of smart meter technology. 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? Individuals interested in understanding and implementing smart meter technology in their homes or businesses. Energy professionals seeking to expand their knowledge of smart metering systems and policies. Anyone passionate about sustainability and looking to optimize energy consumption through advanced technology. Career path Smart Meter Installer: £20,000 - £30,000 per year Energy Efficiency Consultant: £25,000 - £40,000 per year Sustainability Analyst: £30,000 - £45,000 per year Energy Manager: £35,000 - £55,000 per year Smart Grid Engineer: £40,000 - £60,000 per year

In this course, we'll learn about runtime semantics and build an interpreter for a programming language from scratch. In the process, we'll build and understand a full programming language semantics.