1327 Courses in London

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

Peering at LINX training course description A one or two day induction course covering the technical procedures of LINX along with correct interaction with LINX and LINX members. This course focuses on the implementation of the technologies within the LINX network. For those already competent in BGP the one day version of this course is sufficient. What will you learn Explain the role of LINX in the Internet. Correctly connect to LINX. Recognise the correct procedures for peering at LINX. Use the current Best Current Practices. Peering at LINX training course details Who will benefit: Technical staff of new LINX members. Technical staff of companies preparing to join LINX. Non technical staff may also benefit from this course. Prerequisites: None. (For technical staff with BGP knowledge 1 day) Duration 1 to 2 days Peering at LINX training course contents Introduction and review Networks, The Internet, IP, routers, Autonomous systems, the structure of the Internet, the role of Internet Exchanges. BGP and peering. LINX, EuroIX, RIPE. What you get when you join LINX. LINX products: Connexions, Virtual PoPs, Colocation resales, LINX from anywhere. LINX infrastructure The original architecture, The growth of LINX, the current topology. LINX London locations. Dual LAN topology. LON1, LON2. Use of MPLS to connect London sites. Regional peering: LINX NoVa, LINX Manchester, LINX Wales, LINX Scotland, ManxIX, JEDIX. Connecting with LINX nnecting with LINX Locations. 1/10/100/400G. Interface specifications. Link aggregation. The racks and space provided, access to the racks, connecting WAN circuits into LINX. The connection form, How to link your ISP with LINX, switch assignments, limits on traffic, average measured traffic, getting statistics from LINX, Using looking glass. Allowed traffic. Port security Configuration hints LINX IP details, IPv4, IPv6, PTR records, Cisco base configuration, Juniper base configuration. Peering with other LINX members Preparing for peering, the peering template, setting up the peering, RFC 2142, the RIPE database, contacts, peeringdb.net, solving downed BGP sessions, escalation procedures. Peering configuration hints Cisco BGP configuration, Juniper BGP configuration. LINX additional services Private interconnect, LINX time service. NTP, Strata. The LINX route server Bi lateral peering, Multi lateral peering. How the LINX route server is configured. Use of communities on the route server, template for peering with the route server. Summary Getting further information, the LINX website, the LINX mailing lists.

Level 2 NVQ Diploma in Plant Operations - Loading and Securing

The Level 2 Door Supervisor course is an accredited qualification that has been developed to meet the requirements of the Security Industry Authority (SIA). It is based on the relevant SIA Specifications for Learning and Qualifications and provides the necessary skills and knowledge for those who wish to apply for an SIA licence and work as a Door Supervisor in Licensed and other venues.

Level 2 NVQ Diploma in Removal of Hazardous Waste - Hazardous Waste

The 'No Blade Facelift' is the new trend made popular by numerous celebrities recently and it is an excellent and effective non-surgical technique to lift and tighten skin. In the right hands, it has the potential to re-define facial contours and induces collagen production. The treatment forms part of an integrated support structure for the tissue of the face by encouraging natural collagen synthesis with immediate results that peak at 6 months and last between 2-3 years. ​On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic procedures. We will cover all you need to know in order for you to treat your patients confidently and safely; including anatomy, use of local anaesthetic, consultation and assessment, managing complications and aftercare. You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners Course prerequisites This course is suitable for those with or without a medical background. It is designed to provide the student with the ability to seek employment or start their own business upon qualification. At a minimum, students will be required to be qualified for at least one of the following: Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 If your qualification does not appear above, we offer a fast track access course for those completely new to the industry.  Course agenda Background of PDO Threads Health & safety In-depth anatomy and physiology Emergency protocols Product knowledge Sourcing clinical oversight (Prescriber) Complications prevention Client suitability Equipment use Needle stick injury protocol Pain management with the use of injectable anaesthetic Adverse effects Complications management Emergency Protocols Anaphylaxis Aftercare Consent forms Consultation process Client selection Live demonstrations Live model experience Recommended treatment charges Insurance Legalities Advance your training with our complete PDO Threads training package Take your training to the next level by enrolling on our complete PDO Thread training package. Included within this package: PDO COG Threads PDO Mono Threads Fox Eye Thread Lifts Pixie Nose Tip Lifts Check out the package here

Miss Date Doctor’s Emotional Intelligence coaching is designed to help you develop the skills and knowledge needed to understand and manage your emotions effectively. Emotional intelligence is a critical factor in building strong, healthy relationships, and our coaching can provide you with the tools needed to enhance your emotional intelligence and improve your relationships. Our Emotional Intelligence coaching includes a range of techniques and strategies, such as self-awareness, self-regulation, empathy, and social skills. We can help you learn to identify and manage your emotions, as well as to understand and respond effectively to the emotions of others. With our Emotional Intelligence coaching, you can learn to build stronger, more fulfilling relationships by improving your ability to communicate effectively, resolve conflicts, and understand the needs of your partner or potential partner. Whether you’re looking to enhance your personal relationships or to improve your professional performance, our Emotional Intelligence coaching can help you achieve your goals. Have 3 one hour sessions with a certified qualified experienced professional The Miss Date Doctor Emotional Intelligence package includes the following: Relationship Emotional Intelligence, Emotional Intelligence Coaching, Self-Awareness, Self-Regulation, Empathy, Social Skills, Emotion Management, Emotion Understanding, Emotional Intelligence Training, Communication, Conflict Resolution, Relationship Building, Emotional Intelligence Techniques. https://relationshipsmdd.com/product/emotional-intelligence-package/

Empowering healthcare professionals for optimal tracheostomy care.

Level 2 NVQ Certificate in Plant Operations - Sweeping and Cleaning

Course Overview The Level 2 NVQ Diploma in Plant Operations -Extracting Plant qualification has been developed for achievement in a real workplace environment which means you need to be employed to undertake this qualification.  This qualification enables you, the learner, to demonstrate and recognise your skills, knowledge and understanding and to demonstrate your competence in a real workplace environment so you can work as a Plant Operator within the construction industry.  You will be assessed against a set of performance and knowledge statements which have been derived from National Occupational Standards for your occupational area. You will be assessed by an occupationally competent and qualified assessor whose job is to work with you and help you complete your qualification.  This qualification supports the learner to attain enabling, fundamental and transferable practical skills with associated underpinning knowledge.  The learner will learn key practical skills and knowledge in these mandatory units:  Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace. The learner will also learn key practical skills and knowledge in one of the following optional units: Preparing and operating draglines to extract ground and/or loose materials in the workplace Preparing and operating 180 degree excavators to extract and excavate ground and loose materials in the workplace Preparing and operating tracked loading shovels to extract ground and loose materials in the workplace Preparing and operating tracked loading shovels to extract, transport and distribute materials in the workplace Preparing and operating 360 degree excavators to extract ground, face and/or loose materials in the workplace Preparing and operating trenchers to extract ground and/or loose materials in the workplace Preparing and operating crawler tractor dozers to carry out dozer operations in the workplace. Entry Requirements There are no formal entry requirements to take this qualification. This qualification can be undertaken without any previous training or qualifications in this subject area.