2556 Courses in London

Sketchup face to face training customised and bespoke.

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

Get ready to learn how to make your own tote bag. A fun and easy project for beginners. Book your spot today Learn to make a tote bag - a reusable & eco-friendly bag Join us for a fun and interactive in-person event where you can learn to make your own stylish tote bag! Whether you're a beginner or have some sewing experience, this event is perfect for anyone looking to unleash their creativity and learn a new skill. During this event, our experienced instructors will guide you step-by-step through the process of creating a beautiful tote bag. You'll learn essential sewing techniques, such as measuring, cutting, stitching, and finishing. Relax and enjoy the process of creating something beautiful with your own hands You will also get: - Fabric to make your bag and all other necessary materials and equipment - Expert guidance and tips from your workshop host - Email support for the next 3 months What you need to bring: - Your own sewing machine with its power cable Please make sure the machine works and has been recently serviced. Please bring along the manual and all the accessories that came with it including spare bobbins and the bobbin case if applicable. Don't worry if you don't have a sewing machine, as we have machines you can borrow. - Threads and a sewing kit (you can buy one from us if you want) - Notepad and pen The workshop is limited to 6 people per session. If you want a private group session, please message us with your booking. Note: You need to know how to thread and use your machine. We offer an introduction to sewing machine workshop too, if you wanted to get to grips with your machine. You will receive a confirmation email after booking from our website. Please provide your phone number so we can message you in case of emergencies. Whether you want to make a personalized gift for a loved one or simply want to expand your crafting skills, this event is a fantastic opportunity to have fun and meet like-minded individuals. So, grab your friends and join us for a creative and enjoyable day of sewing! Spaces are limited, so reserve your spot now and get ready to embark on a sewing adventure! Note: If less than 3 participants have booked on this workshop, we will reschedule the workshop for a more convenient date or a different location. Priority will be given to existing paid participants first who have the option to confirm or cancel within 7 days. Frequently asked questions What is the age range for the workshop? This workshop is suitable for adults and kids. What should I bring with me to the workshop? Bring your own sewing machine with it’s power cable if you are not borrowing from us. The manual and all the accessories the machine came with Bobbin, bobbin case if applicable Threads and a full sewing kit. You can purchase one from us Notepad and pen How many participants will attend this workshop? There will be a maximum of 6 participants at this workshop. Small groups work best as everyone gets a chance to learn and ask questions. Please note: The workshop would be rescheduled if there are less than 3 participants booked for the date. Is the venue wheelchair accessible? Unfortunately, this venue isn't wheelchair accessible. There are 2 short sets of stairs to get to the room. Please don't hesitate to reach out if you want further info or any specific needs or concerns. I will do my best to accommodate you. What is the cancellation and refund policy for the workshop series? Cancellation notice period: Refunds: 28 days or more before the course start date - Full refund minus the fees15-27 days before the course start date - 50% refund minus the fees 14 days or less before the course start date We will try & fill the space. If we fill it, full refund minus fees.

BGP training course description A study of BGP for non engineers working in the Internet. The course starts with a review of the basics of routers and routing tables and then moves on to a simple overview of how BPG works with a focus on BGP metrics influencing the route traffic takes through the Internet. Hands on with routers follow the major sessions to reinforce the theory. Note these hands on sessions are more demonstrations by the trainer but some can be followed along and done by delegates (e.g. looking at Internet routing tables.) What will you learn Explain how routing tables influence Internet traffic. Describe how BGP works. Explain the methods BGP can use to influence Internet traffic. Use traceroute, peeringdb, route collectors and looking glasses to analyse traffic flows. Explain the difference between bi lateral and multilateral peering using a route server. BGP training course details Who will benefit: Non technical staff wishing to know more about BGP. Prerequisites: None. Duration 1 day BGP training course contents Networks, routers and routing tables What is a network, what is a router, routing tables, static routes, routing protocols. When an ISP uses static routes and when they use BGP. IP addresses, subnet masks, groups of IP addresses. IPv6. Hands on: Showing a full routing table. Seeing traceroute being used. Basic BGP What's BGP? BGP versus other routing protocols, ASs, AS numbers. RIPE database, peeringdb. Hands on: Finding AS numbers. Showing simple BGP configuration and routing tables in an EVENG example. How BGP works Simple walk through of BGP incremental updates and how routes change when links go down. Hands on: Showing packets and route changes when a link goes down/comes up. BGP path selection Transit, peering, routing policy and route filtering. Longest matching rule in routing tables, route selection order, Local preference, AS prepend, MEDs. Hands on: Seeing BGP influencing traffic. Looking at peering policies in RIPE and peeringdb. Route servers What are route servers? LINX route servers, route server policy control and communities, What are route collectors, Looking glasses. Hands on: Seeing the LINX route server details in peeringdb, using a looking glass.

Course Introduction for VTCT upgrade The VTCT qualification is recognised around the world and will allow you to be employed in a clinic, salon or allow you to set up your own business. The Federation of Holistic Therapists and the Association of Reflexology, two of the biggest Holistic Therapy organisations which both accept members with this qualification. Description Reflexology uses many techniques to manipulate reflex zones found in the feet, of which correspond to a specific body part. The zones have been mapped and this enables the Reflexologist to treat the whole body via these reflex zones on the feet. The treatment is primarily used for the stimulation of all bodily systems and aiding relaxation. Reflexology is performed frequently within the Health Service personnel and has a role in comforting and supporting terminally ill patients. This 5 day VTCT Course leads to practitioner status, focusing on providing you with knowledge of the principles of reflexology, competence in dealing with clients, correct use of consultation techniques and good use of planning treatments. You will also learn the benefits and techniques of reflexology and how to target certain key areas such as: Pregnancy or Hand Massage. Duration 5 days, 10.00am – 5.30pm. Practical elements are covered over 5 days attendance at our Academy. Theory elements are covered by homestudy. Qualification Structure T/501/9101 - Knowledge of Anatomy, Physiology and Pathology for Complementary Therapies F/501/9117 - Provide Reflexology A/501/9116 - Reflective Practice for Reflexology Y/501/9253 - Principles and Practice of Complementary Therapies K/501/9256 - Health, Safety and Hygiene for Complementary Therapies H/501/9255 - Business Practice for Complementary Therapies D/501/9111 - Knowledge of Less Common Pathology for Complementary Therapies Course Contents Health, safety, hygiene and security with regard to the complementary therapy industry. Principles and practice of the complementary therapy industry. Knowledge and understanding of anatomy, physiology and common pathology of the human body. How to prepare for and provide an effective reflexology treatment and adapt to client requirements. Contra-indications and contra-actions, advice to be given to the client, record-keeping, evaluation of treatments and reflection on professional practice. Recognising Body Language Stress and Illness Analysis of Posture Legal Aspects, Code of Conduct and Ethics Advanced Techniques including the use of Meridian lines and Chakra's Home Study You can register your place and receive your lifetime membership. You can then make a start on some of the theory work sent to you by us here at the Academy. This includes your Anatomy and Physiology assignments that you can work on in the privacy of your own home. This allows you to have more time to focus on the practical when the class meets together. Approx. 5-10 hours per week need to total your home study time spent. The home work will need to meet the quality of National Standards. You will also be expected to complete 100 reflexology treatments from the start to the end of the course. You will also need to complete some assignments that will be required for your portfolio and a work-book will need to be completed. There are also 2 small exams that will be taken at the Academy in order to assess your understanding of Health and Safety and Anatomy and Physiology. These are multiple choice assessments and are nothing to worry about! Included in the Course Comprehensive course materials, handouts and work-book Online Resources: Virtual Learning Environment packed with extensive support materials, resources, help and advice Post-training support by phone, instant messaging or email (if desired) Assessment of practical/written work included (Must be sent Recorded Delivery) VTCT QCF Diploma in Reflexology Lots of fun and knowledge from Tutors with a whole wealth of skills and experience Light refreshments including tea, herbal tea, coffee and water Cost Training - £999

A pioneering provider of independent mentoring services  For adults who are training to be teachers and Early Career Teachers (ECTs), our mission is to support and empower aspiring educators as they navigate their journey towards becoming skilled and confident professionals in the teaching profession. As a mentorship program tailored specifically for adults pursuing a teaching career, we understand the unique challenges and expectations placed upon trainees in the profession. We are committed to providing comprehensive and personalised support to help trainees meet the teaching standards set by the Department for Education in England. The teaching standards and expectations in England Our experienced mentors are well-versed in the teaching standards and expectations in England. We provide guidance and practical assistance to trainees in areas such as lesson planning, classroom management, assessment strategies, and creating inclusive learning environments. Our aim is to help trainees develop a deep understanding of the curriculum, pedagogical approaches, and effective teaching techniques. Planning Planning is a crucial aspect of a teacher's role, and we offer specialised support to trainees in this area. Our mentors work closely with trainees to develop effective lesson plans that align with curriculum requirements and engage students in meaningful learning experiences. We provide guidance on designing differentiated instruction to meet the diverse needs of students, fostering a supportive and inclusive classroom environment. Confidence Confidence is essential for success in the teaching profession, and we are dedicated to helping trainees build their self-assurance. Our mentors provide individualised coaching and feedback, helping trainees develop their teaching skills, classroom presence, communication abilities, and interpersonal skills with other staff. We create a safe and supportive environment where trainees can explore their strengths, identify areas for growth, and gain the confidence needed to deliver impactful lessons and engage with students and the wider school community effectively. High quality resources In addition to planning and confidence-building, GLA Tutorsoffers a range of other support services to trainees. We provide resources and guidance on effective behavior management strategies, assessment and feedback techniques, and effective use of technology in the classroom. Our mentors also offer guidance on professional development opportunities, helping trainees stay updated with the latest educational research and best practices in teaching. A collaborative and ongoing process At GLA Tutors, we believe that mentorship is a collaborative and ongoing process. Our mentors build strong relationships with trainees, offering ongoing support, guidance, and encouragement throughout their training and early career stages. We understand the challenges and triumphs that trainees may encounter, and we are dedicated to helping them navigate their journey towards becoming successful and impactful teachers. ChooseGLA Tutorsas your trusted partner in your teaching journey. With our experienced mentors, personalised support, and comprehensive resources, we are committed to helping you meet the teaching standards, develop as a confident educator, and make a positive impact in the lives of your students.  Invest in your future as a teacher and join us at GLA Tutors today.

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

High-intensity electromagnetic Technology (HIEMT)/ EMS What is High-intensity electromagnetic Technology (HIEMT)/ EMS? High-intensity electromagnetic technology (HIEMT) is an acronym for high-intensity electromagnetic technology. HIEMT contracts muscles in a specific location with a powerful but safe form of electromagnetic stimulation. These magnetic fields generate electrical currents, which are then transferred to the muscles, where they contract often enough to develop muscle and burn fat. Results, which can be as dramatic as looking to be equal to six months of dieting and workouts, COURSE CONTENT: * Health and safety * Sterilisation and disinfection * Appearance of the therapist * Ergonomics * Handwashing * Cellulite * Anatomy and physiology * Hiemt vs EMS * The consultation process * Machines explained * Treatment protocols * Aftercare TRAINING KIT: Please get in touch if you wish to purchase a machine HOW DOES THE COURSE WORKS? The course is divided into 2 parts, the first part is theoretical which you have to complete before you come for your practical training, and the second one is a practical assignment. The practical assignment is done on the day which will be agreed upon course purchase. You will spend around 2 hours practising on a model in our venue in London E106RA. We will call you to arrange a date once you sign up for the course. WILL I REQUIRE MODEL? Yes, usually 1 model is required ARE THERE ANY PREREQUISITES? We’re pleased to offer courses to people with lots of different experiences. However, previous experience nor qualifications are not necessary if you would like to enrol on our Course. CERTIFICATE: You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public PAYMENT By paying for the course you agree to our Terms and Conditions

IPv6 demystified training course description IPv6 is the next generation Internet Protocol. This course looks at the benefits and features of the new protocol along with an assessment of the likely impact of the protocol and migration strategies. What will you learn Explain the benefits and disadvantages of IPv6 Recognise the impact of IPv6 on existing networks. Plan migration strategies for IPv6 Integrate IPv6 and IPv4 networks IPv6 demystified training course details Who will benefit: Sales staff, managers and other non technical staff. Prerequisites: None. Duration 1 day IPv6 demystified training course contents What's wrong with IPv4 IPv4 works, NAT, carrier grade NAT, addresses running out. Current state of IPv4 addressing. Why IPv6 Reasons for IPv6, what is IPv6? the origins of IPv6. IPv6 addressing IPv6 address allocation, address format, prefixes, address categories, scope zones, global unicast, link local. Plug and play. Migration techniques A migration plan, Dual stack, DNS, tunnelling, tunnel establishment, tunnel brokers, Tunnel types. IPv6 steps How IPv6 can affect the following: Firewalls, routers, switches!, DNS, Web services, Email. Current state of IPv6 IPv6 release 1996, 3G, World IPv6 day 2011, World IPv6 launch 2012.

Network automation training course description This course concentrates on the technical side of tools and languages for network DevOps rather than the soft skills. These tools include Python, Ansible, Git and NAPALM By the end of the course delegates should be able to recognise the tools that they can use to automate their networks and be able to use the knowledge gained to feel confident approaching network automation. What will you learn Describe network DevOps. Choose network automation tools. Explain the role of various network automation technologies including: Python Ansible Git NAPALM Network automation training course details Who will benefit: Those wishing to learn about the tools of network automation. Prerequisites: Introduction to data communications. Duration 1 day Network automation training course contents What is DevOps and network automation Programming and automating networks, networks and clouds, AWS, OpenStack, SDN, DevOps for network operations. Unit testing. Hype vs reality. Benefits and features. Network monitoring and troubleshooting Traditional methods, SNMP. Netflow and xflow. Traditional automation. Streaming telemetry. Event driven automation. gRPC, Protocol buffers. Configuration management Catch 22 and initial configuration. ZTP, POAP. Traditional automation. TFTP. Ansible vs the rest (chef, salt, puppet). Jinja2 and templating. How ansible works. Network programmability Programming languages. Linux, shell scripting. Python vs the rest. Off box vs on box automation. Python network libraries Sockets pysnmp, ncclient, paramiko, netmiko, pyez, NAPALM. APIs Proprietary APIs, CLI, NETCONF, RETCONF. YANG, XML, YAML, JSON. Other tools Git, GitHub, Jenkins, JIRA and others.