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

537 Courses in Coventry

NVQ Level 3 Diploma in Construction Contracting Operations

5.0(29)

By Site Competence

Gold CSCS Card NVQ Level 3 Diploma in Construction Contracting Operations This qualification is designed for those in a technical job role, This qualification is appropriate for employees in the construction and built environment sector working at a technical level in disciplines such as estimating, buying, planning, surveying, site technical support and design co-ordination. You could be site-based and have responsibility for functions such as dimensional control, surveys, physical testing, and work planning. You may work across one or more of the following pathways: Estimating Buying Planning Surveying Site Technical Support Design Co-Ordinator General Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

NVQ Level 3 Diploma in Construction Contracting Operations
Delivered In-Person in Market Rasen or UK WideFlexible Dates
£1,200

Assessing and Managing Cyber Security Risks for Essential Services Operators

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT) This 3 half-day Virtual Instructor Led Training (VILT) course will help participants grasp the idea of real-world risk management and how this relates to the cyber world. The VILT course will cover topics surrounding identifying cyber risks and vulnerabilities, guidance on applying administrative actions, and comprehensive solutions to ensure your organization is adequately secure and protected. The VILT course will guide participants on how to conduct a security risk assessment for their organization, and equip them with the skills to develop a risk compliance assessment plan as well as methods to develop risk management strategies which can improve their organization's security posture. The VILT course has at least a 30% hands-on approach through the use of Table Top Exercises. The VILT course will cover the following modules: Introduction to Risk Assessments (RA) Threat Actors and Their Motivations Threat and Risk Assessment Critical Controls Identification Maturity Assessment Treated Cyber Risk Profile Target Cyber Risk Profile and Strategy Target Audience The VILT course is intended for professionals responsible for organizational information and security system and those involved in operating and maintenance of critical information and IT network & sotware systems. Professionals who are designated as the Single Point of Accountability (SPoA) as well as system auditors will find this course useful. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 3 half-day sessions, 4 hours per session (12 hours in total). This VILT course is delivered in partnership with ENGIE Laborelec. Trainer Your expert course leader is a is specialized in cybersecurity risk management. Before joining ENGIE, she worked for The National Cybersecurity Agency of France (ANSSI) based in Paris (France) and for Deloitte Belgium located in Zaventem (Belgium). She has been involved in cybersecurity projects focusing on the principle of protecting critical infrastructures. Her different experiences in Cyber Security, Anti-Money Laundering and Global Trade Compliance (including Export Control and Customs) gave her the opportunity to use methodologies tackling strategic, operational and financial control issues at all levels of an organization: people, business processes, IT applications and infrastructure, legal and regulatory compliance. She was an EBIOS Risk Manager (RM) trainer while she worked for the French government; EBIOS RM is the French method for assessing and treating digital risks. She also had the opportunity to represent France towards European institutions and other relevant stakeholders for topics related to cybersecurity risk management. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Assessing and Managing Cyber Security Risks for Essential Services Operators
Delivered in Internationally or OnlineFlexible Dates
£1,324 to £2,499

IV Sedation Full Course Dentists and Nurses

By UKSedation

UK Sedation & Mellow Dental Presents: The New Starter Sedation Course for Dentists and Dental Nurses With Dr Roy Bennett and Dr Robert Endicott Are you a dentist or Dental Nurse looking to expand your skills and provide a more comfortable experience for your patients? If so, we’ve got the perfect opportunity for you. Introducing our brand-new, comprehensive New Starter Sedation Course. This innovative course is brought to you by two leading names in dental education – UK Sedation and Mellow Dental. Our commitment is to empower you with the skills and confidence to provide effective sedation in your practice. The Starter Sedation Course spans two days, offering a blend of online and face-to-face learning for the best educational experience: 🌐 Day 1 – Online Learning: Dive into the theory of dental sedation from the comfort of your own home. Our expert instructors will guide you through comprehensive video tutorials, live webinars, and interactive quizzes, making learning both easy and engaging! 👥 Day 2 – Face-to-Face Workshop: Put your newfound knowledge into action with a hands-on, practical workshop held at one of our state-of-the-art training facilities. Here, you’ll learn directly from experienced professionals in a safe, supportive environment. Once those two parts are complete, you have all the theory training required to enter the mentoring phase of your training. 🌐 Post course – Exclusive access to our online mentoring and logging programme. You need to carry out at least 20 mentored cases in practice after the course and our programme helps you accomplish this once you have sourced a mentor. We can help you find a mentor with our extensive list, including some of the team at UKSedation.  Once at least 20 cases are completed mentored, you are then free to carry out IV Sedation independently. THE FEES WILL BE £1100 FOR DENTISTS AND £550 FOR DENTAL NURSES, INCLUDING ALL RESOURCE MATERIALS. IF BOOKING DENTIST AND NURSE TOGETHER USE PRODUCT CODE “UKSEDATION250” TO GET A £250 DISCOUNT ON THE NURSES TICKET. New course also delegates get access to exclusive offers from dental sedation equipment providers Once mentoring is completed, there is an additional fee of £150 for final certification. Key features of the course: Comprehensive Curriculum: Covering everything from patient assessment, sedation techniques, monitoring, and emergency protocols, our course gives you all the tools you need to safely administer dental sedation. Expert Instruction: Our instructors are experienced sedation practitioners who are passionate about sharing their knowledge. CPD Certified: The course is fully accredited for Continuing Professional Development, providing 14 verifiable sedation CPD hours upon completion. Post-course Support: We’re committed to your ongoing development, offering post-course support and resources to help you apply your new skills confidently in your practice. Mentoring – at UkSedation we can provide the mentors to visit your practice to help you with your required 20 cases (charged separately). We will train you in how to find the patients who would benefit from sedation and to have that discussion with them. Whether you’re a newly qualified dentist or nurse or a seasoned practitioner looking to expand your services, our New Starter Sedation Course is the perfect stepping stone to elevate your practice and help many more patients visit the dentist. Don’t miss out on this fantastic opportunity to enhance your professional skills, deliver better patient care, and grow your practice. Limited spaces are available, so sign up today and take the next step in your dental career with the UK Sedation & Mellow Dental’s New Starter Sedation Course. Course Includes 24 Lessons 14 Quizzes Course Certificate About Instructor Rob Endicott Roy Bennett Dr Roy Bennett is the director of Mellow Dental Training, IACSD accredited trainer and mentor and former director of Portmans Dental Care. Dr Rob Endicott is an IACSD accredited trainer and mentor and is the ViceChair of the ADAS (Association of Dental Anaesthetists and Sedationists)

IV Sedation Full Course Dentists and Nurses
Delivered Online & In-PersonFlexible Dates
£550 to £1,350

Neurodiversity in the Workplace Champion Workshop

5.0(2)

By Changing Minds Training

This half-day workshop delivered face-to-face or online is designed for anyone in your organisation that wants to become a Neurodiversity Champion - someone who wants to educate and change the way that Neurodiversity is viewed in the workplace.

Neurodiversity in the Workplace Champion Workshop
Delivered in London or UK Wide or OnlineFlexible Dates
£1,995

ITIL 4 Specialist: High Velocity IT: In-House Training

By IIL Europe Ltd

ITIL® 4 Specialist: High Velocity IT: In-House Training The ITIL® 4 Specialist: High-Velocity IT module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This module addresses the specifics of digital transformation and helps organizations to evolve towards a convergence of business and technology, or to establish a new digital organization. It was designed to enable practitioners to explore the ways in which digital organizations and digital operating models function in high-velocity environments. Working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing are included. What You Will Learn At the end of this course, participants will be able to: Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT. Understand the digital product lifecycle in terms of the ITIL operating model. Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT. Know how to contribute to achieving value with digital products. Course Introduction Let's Get to Know Each Other Course Learning Objectives Target Audience Characteristics ITIL® 4 Certification Scheme Course Components Course Agenda Module-End Exercises Exam Details Introduction to High-Velocity IT High-Velocity IT Digital Technology Digital Organizations Digital Transformation High-Velocity IT Approaches Relevance of High-Velocity IT Approaches High-Velocity IT Approaches in Detail High-Velocity IT Operating Models Introduction ITIL® Perspective High-Velocity IT Aspects High-Velocity IT Applications ITIL® Building Blocks for High-Velocity IT Digital Product Lifecycle Service Value Streams Four Dimensions of Service Management ITIL® Management Practices High-Velocity IT Culture Key Behavior Patterns ITIL® Guiding Principles Supporting Models and Concepts for Purpose Ethics Design Thinking Supporting Models and Concepts for People Reconstructing for Service Agility Safety Culture Stress Prevention Supporting Models and Concepts for Progress Working in Complex Environments Lean Culture ITIL® Continual Improvement Model High-Velocity IT Objectives and Techniques High-Velocity IT Objectives High-Velocity IT Techniques Techniques for Valuable Investments Prioritization Techniques Minimum Viable Products and Services Product / Service Ownership A/B Testing Techniques for Fast Developments Basic Concepts Related to Fast Development Infrastructure as Code Reviews Continual Business Analysis Continuous Integration / Continuous Delivery (CI/CD) Continuous Testing Kanban Techniques for Resilient Operations Introduction to Resilient Operations Technical Debt Chaos Engineering Definition of Done Version Control Algorithmic IT Operations ChatOps Site Reliability Engineering (SRE) Techniques for Co-created Value Basic Concepts of Co-created Value Service Experience Techniques for Assured Conformance DevOps Audit Defense Toolkit DevSecOpsPeer Review

ITIL 4 Specialist: High Velocity IT: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£2,295

Flow Assurance for Offshore Production

By EnergyEdge - Training for a Sustainable Energy Future

About this training course This 5-days comprehensive training not only an introduction into the issue associated with the development of oil and gas fields but also provides an in depth understanding of the issues to be considered in the development of these fields. The theme throughout this training course is Flow Assurance and Innovative Technologies. Each day consists of lectures in the morning and a hands-on workshop in the afternoon. The workshop allows the participants to appreciate the design process associated with field developments. Various software will be available during the workshop to predict Multiphase flows through wells, pipelines and risers, as well as evaluating reservoir production profiles using alternative technologies to develop reservoirs. Further software to assess Surge and environmental safety will also be available. The field design approach will consider an integrated solution through modelling the reservoir decline, wells, flowlines, risers and the host facility. The participants will have a total appreciation of the methodology required to develop offshore oil and gas fields and have an understanding of all of the Flow Assurance issues and technology requirements. Training Objectives After the completion of this training course, participants will be able to: Understand the process required and identify data to analyse Flow Assurance for oil and gas fields. Examine and Identify the Flow Assurance issues required to be evaluated for oil and gas fields design. These include; Wax, Hydrates, Slugging, Corrosion, Sand Erosion, Scaling and Surge. Establish the studies to be undertaken for each area of Flow Assurance including 'Rules of Thumb' and software to be used. Prioritize the need for innovative methods and the technologies to solve Flow Assurance issues and the need for economics considerations. Appreciate the need for an integrated analysis of the oil and fields from the reservoir to the host processing facility. Gain an appreciation of the emerging and enabling technologies for offshore fields application. Dive deeper into the operational strategies requirements to mitigate Flow Assurance issues. Target Audience This training course is suitable and will greatly benefit the following specific groups: Reservoir Engineers Flow Assurance Engineers Thermodynamics Engineers Process and Chemical Engineers Pipeline Engineers Facilities Engineers Control and Subsea Engineers working in the Oil and Gas industries Engineers in other disciplines may attend that require an appreciation of Flow Assurance Course Level Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the 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 in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training Course delivery: This course is limited to a maximum of 20 participants only. A basic understanding of thermo-hydraulics would be advantageous. Morning Lectures and afternoon hands-on practical workshop. Special features: PC-based simulation software demonstration Workshop for hands-on training Course References & Additional resources: 'Flow Assurance for Oil and Gas Fields Production Transport', 1st Edition Handouts Pre & Post Assessment Trainer Your expert course leader is a renowned specialist in flow assurance management for the oil & gas field developments. His expertise enables him to support the operating and contracting companies as well as financial institutions regarding due diligence on offshore development investment decisions and associated operational system risks. Technical assessment of fields for acquisition and production enhancement opportunity. He possesses specialist expertise in evaluating difficult pipeline fluids transport such as Ethylene, Carbon Dioxide and Hydrogen through feasibility studies and technical reviews for clients. He has an exceptional academic background and natural leadership abilities are supported by practical experience of diverse projects worldwide, along with numerous publications at key conferences and publication of four books. Particular interests in developing novel and innovative technologies for subsea applications to solve difficult flow assurance problem areas and improve field development economics. He has worked on major industry projects including; Concorde aircraft fuelling system, the Channel Tunnel aerodynamics and the first deep water oil field development (Foinaven) in the West of Shetland. He is also currently developing a renewable energy solar farm and carbon neutral energy crop (Miscanthus) for domestic and commercial power generation application. He has developed in-house resources including specialist oil & gas field development evaluation software for subsea and onshore field infrastructure development options including; costing and financial analysis, reservoir viability, flow assurance assessment, subsea processing and boosting technologies, flow induced vibrations, surge analysis, heat transfer and chemical injection systems.

Flow Assurance for Offshore Production
Delivered in Internationally or OnlineFlexible Dates
£3,255 to £3,785

NVQ Level 3 Certificate in Occupational Health and Safety

5.0(29)

By Site Competence

NVQ Level 3 Certificate in Occupational Health and Safety This qualification is aimed at candidates working as a health and safety practitioner, in a position of responsibility for the health, safety and welfare of a team or organisation. The qualification is generic and appropriate for individuals working in a range of sectors. Furthermore, once you have completed this NVQ you will be able to apply for IOSH status. Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you'll get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

NVQ Level 3 Certificate in Occupational Health and Safety
Delivered In-Person in Market Rasen or UK WideFlexible Dates
£1,080

Light Vehicle Inspection Technician Accreditation

By PFTP Ltd

The IMI Light Vehicle Inspection Technician Accreditation is for experienced mechanics who would like to gain recognition for their skills and knowledge. It is also accepted by the Driver and Vehicle Standards Agency (DVSA) as the stage 1 entry qualification for mechanics and technicians who wish to train to become an MOT Tester for class 4 and 7 vehicles (cars and vans) It is normally valid for 3 years and successful candidates, as well as receiving a certifcate, photo card and pin badge, will also be entered on to the IMI Professional Register. This is a public-facing register to showcase individuals working in the motor industry, who have been recognised for their experience, professionalism and commitment to ethical working practices. However, there will be no requirement for you to re-accredit if you go on to complete your IMI Level 2 Award in MOT testing (classes 4 & 7) within the 3 year period. As an Inspection Technician you must be able to work unsupervised – ideally, you should be in full time employment with at least 3 years experience (4 years if you wish to become an MOT tester) to ensure you are familiar with the techniques for vehicle servicing, inspection and system(s) diagnosis. There are 5 practical assessments for this route and two online exams, one containing 30 questions and a second containing 10 questions. Please click on the links below to get an overview of the contents of each assessment. AOM – 071 – Emissions System – Inspection AOM – 072 – Electrical System – Inspection AOM – 073 – Braking Systems – Inspection AOM – 074 – Steering and Suspension Systems – Inspection AOM – 075 – Vehicle Structure – Inspection AOM – 076 – Vehicle Appraisal – Inspection   5 Day Training and Assessment. This training is aimed at experienced technicians who might need some training input prior to assessment. The assessments will take place over a 5 day period with the online assessment taking place mid week to allow for any re-sits that may be necessary. You will receive a copy of Tom Denton’s 4th edition Advanced Automotive Fault Diagnosis book which you can use in the intervening period to study and practice your knowledge and skills prior to attending the course. PLEASE NOTE THESE ASSESSMENTS ARE TO A LEVEL 3 STANDARD AND ARE DESIGNED TO BE TOUGH. THEY CONCENTRATE ON FAULT FINDING WITHIN A GIVEN TIMESCALE. SUCCESSFUL CANDIDATES WILL FIND ALL OF THE FAULTS WITHIN 1 HOUR. The next step If this accreditation is of interest to you, particularly if you wish to become an MOT tester, have a go at our initial assessment test. Our administrator will be in touch with you once we receive your result so that we can best advise you on the way forward.

Light Vehicle Inspection Technician Accreditation
Delivered In-Person in NuneatonFlexible Dates
£995

Portfolio, Programs, and Project Offices Foundation: In-House

By IIL Europe Ltd

Portfolio, Programme, and Project Offices (P3O®) Foundation: In-House Training P3O® is the AXELOS standard for the design of decision-making processes regarding changes in organizations. P3O provides a guideline for the design of portfolio, programme, and project offices in organizations. The P3O Foundation course is an interactive learning experience. The P3O Foundation-level content provides you with sufficient knowledge and understanding of the P3O guidance to interact effectively with, or act as an informed member of, an office within a P3O model. It enables you to successfully complete the associated P30 Foundation exam and achieve the qualification. In this course, you will be prepared to successfully attempt the P3O Foundation exam and learn how to implement or re-energize a P3O model in their own organization. What you will Learn Individuals certified at the P3O Foundation level will be able to: Define a high-level P3O model and its component offices List the component offices in a P3O model Differentiate between Portfolio, Programme, and Project Management List the key functions and services of a P3O List the reasons for establishing a P3O model Compare different types of P3O models List the factors that influence selection of the most appropriate P3O model for an organization Define the processes to implement or re-energize a P3O Benefits: Fast-track programme for those who want to achieve P3O Foundation qualification Practical case study and scenarios Attractive slides and course book Introduction to P3O What is the purpose of P3O? Definitions What are P3Os? Portfolio, programme, and project lifecycles Governance and the P3O Designing a P3O Model Factors that affect the design Design considerations What functions and services should the P3O offer? Roles and responsibilities Sizing and tailoring of the P3O model Introduction to P3O What is the purpose of P3O? Definitions What are P3Os? Portfolio, programme, and project lifecycles Governance and the P3O Designing a P3O Model Factors that affect the design Design considerations What functions and services should the P3O offer? Roles and responsibilities Sizing and tailoring of the P3O model Why Have a P3O? How a P3O adds value Maximizing that value Getting investment for the P3O Overcoming common barriers Timescales How to Implement or Re-Energize a P3O Implementation lifecycle for a permanent P3O Identify Define Deliver Close Implementation lifecycle for a temporary programme or project office Organizational context Definition and implementation Running Closing Recycling How to Operate a P3O Overview of tools and techniques Benefits of using standard tools and techniques Critical success factors P3O tools P3O techniques

Portfolio, Programs, and Project Offices Foundation: In-House
Delivered in London or UK Wide or OnlineFlexible Dates
£1,995

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

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

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