142 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 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

The manicure offers the technician a whole range of options to suit nearly every client. This course will teach you everything you need to know about offering a professional manicure and includes a practical training session & assessment. Gel Polish treatments are an increasingly popular treatment within the professional beauty industry. Gel Polish is applied to the client’s nail and then cured using an LED or UV lamp to create a longer lasting nail treatment (up to 3 weeks) than a standard manicure. The GTi Gel Polish course covers how to complete gel polish application and demonstrates the correct removal techniques. The course also covers reception and consultation, contra-indications to treatment and aftercare advice. The GTi Tips with Acrylic Overlay course will teach you how to apply the Acrylic System (Liquid and Powder) in conjunction with nail tips. The course covers how to complete the application and demonstrates the correct removal techniques. It also covers reception and consultation, contra-indications to treatment and aftercare advice. Pedicures are a fantastic way to get new clients into the salon. It is a treatment that is often given as a treat or is booked to make tired toes look respectable. Once a client has been made to look and feel better, they are much more inclined to repeat the process, and you will hopefully have gained a customer for life. Upon course completion you will gain 4 recognised & insurable qualifications.  Includes: 4 Hard copy take home training manuals. Duration – Fast track three-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm & 10.30-5.30pm & 10am – 5pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class  Optional Add on’s – You may wish to add on one or more of the following take home kits to your course booking: The Edge Manicure & Pedicure tool kit inc manicure bowl £70 Kaeso Manicure & Pedicure Products £40 The Edge gelover soak off nail kit £65 The Edge gelover soak off nail kit inc UV lamp £87.50 The edge ultra low odour acrylic liquid & powder kit £71.99

Autodesk Maya Basic to Fundamentals Training. Ideal for beginners, learn to navigate Maya's interface, create models, apply textures, animate objects, and delve into advanced topics. Engage in interactive in-person or online sessions. Access recorded lessons for review and receive lifelong email support. Learn 3D modeling and animation - enroll today! Click here for more info: Website Duration: 10 hours of immersive learning. Method: Personalized 1-to-1 sessions and Choose your own day and time Monday to Saturday 9 am to 7 pm. Course Overview: I. Introduction to Maya (1 hour) Maya overview and applications Basic interface and navigation tools Project creation and management II. 3D Modeling Techniques (2 hours) Polygon modeling fundamentals Creating, editing, and refining objects Advanced techniques like extrusions and bevels III. Texturing and Materials (1 hour) Introduction to texturing concepts Material creation and application Texture mapping, UV unwrapping, and image importing IV. Lighting and Rendering (1.5 hours) Basic lighting techniques and composition setup Rendering images and animations effectively Output options and file formats V. Animation Skills (2.5 hours) Keyframe animation and animation curves Character rigging and animation Special effects: particles, fluids, explosions, and smoke VI. Intermediate Modeling Techniques (1 hour) NURBS modeling basics and advanced curves/surfaces manipulation Creating organic shapes with NURBS and sculpting tools VII. Conclusion and Next Steps (0.5 hours) Course review and recap Further learning resources and tips Q&A and feedback session Autodesk Maya Basic to Fundamentals Training Course Key Learning Areas: Advanced modeling techniques: Surfaces, Polygons, Subdiv Modeling, etc. Deformation methods: Twist, Lattice, Flare, Bend Shape manipulation: Lines, Pen tools, Revolve, Loft, Planer, Text in Maya Animation: Keyframes, Path animations, Timeline Texturing and Rendering: Diffuse, Reflections, Transparency, Shaders, Resolution settings Lighting and Camera: Basic & advanced lights, Shadows, Camera effects, Path animation Note: The course content and duration are adaptable to cater to learners' needs and proficiency levels.   Maya Interface Proficiency: Participants will develop a comprehensive understanding of Maya's interface, tools, and workflow, allowing them to navigate seamlessly and manage projects efficiently. 3D Modeling Skills: Students will be equipped with polygon modeling techniques to create both basic and complex 3D models with precision. They will master the art of shaping and refining objects, elevating their creativity in 3D design. Texturing and Materials Mastery: Learners will gain expertise in texturing, applying materials, and incorporating images to enhance the visual appeal of their 3D models. They will create captivating surfaces with colors, textures, and reflectivity. Lighting and Rendering Expertise: Participants will learn essential lighting techniques to illuminate their scenes effectively. They will set up cameras and produce high-quality still images and dynamic animations with Maya's powerful rendering capabilities. Animation Techniques: Students will explore the world of animation, utilizing keyframe techniques and animation curves to bring their creations to life. They will delve into character rigging, animating characters with sophistication and realism. Special Effects and Dynamics: Learners will unleash their creativity with mesmerizing particle systems, fluid simulations, and dynamic effects. They will craft captivating visuals, such as explosions and smoke, adding depth and excitement to their projects. Intermediate Modeling Techniques: Participants will refine their skills with NURBS modeling, mastering curve and surface manipulation. They will create intricate organic shapes, pushing the boundaries of their artistic expression. Creative Problem-Solving: Throughout the course, students will tackle real-world projects, facing challenges that foster creative problem-solving skills. They will gain confidence in overcoming obstacles in 3D modeling and animation. Maya Essentials Basic to Fundamental Training Program: Course Focus: Autodesk Maya Essentials, covering fundamental concepts and techniques. Duration: Flexible scheduling, tailored to individual learning pace. Method: Personalized 1-1 training, interactive sessions, hands-on projects. Curriculum Highlights: Introduction to Maya (1 hour): Interface overview, navigation, project management. 3D Modeling Techniques (2 hours): Polygon basics, object creation, advanced editing. Texturing and Materials (1 hour): Texture mapping, material application, UV unwrapping. Lighting and Rendering (1.5 hours): Lighting fundamentals, composition setup, effective rendering. Animation Skills (2.5 hours): Keyframe animation, character rigging, special effects. Intermediate Modeling (1 hour): NURBS modeling, organic shapes, sculpting tools. Conclusion and Next Steps (0.5 hours): Course review, learning resources, Q&A session. These resources will complement your training, providing additional support and insights as you explore the world of Autodesk Maya. Explore the World of 3D Animation: Master the intricacies of 3D computer graphics and animation using Autodesk Maya. Delve into modeling, texturing, animation, and rendering to bring your creative visions to life. Practical Learning Experience: Dive into hands-on projects refining your skills. Craft 3D models, apply textures, animate characters, and produce polished renders. Recognized Industry Expertise: Gain proficiency in Autodesk Maya, a leading software in entertainment, gaming, and animation. Enhance your employability with highly sought-after skills, opening doors to diverse career paths. Endless Applications: Uncover Maya's versatility in entertainment, architectural visualization, product design, and more. Tailor your expertise to align with your passions and career aspirations. Reinforcement through Recordings: Access comprehensive lesson recordings for thorough review. Revisit specific topics, reinforcing your grasp of Autodesk Maya at your own pace. Continuous Guidance: Receive lifetime email support for ongoing mentorship. Seek answers, clarifications, and expert advice, ensuring your continuous growth even after completing the course.

Manicures can be found on nearly every treatment menu and are often the bread and butter of many businesses. The manicure offers the therapist or technician a whole range of options to suit nearly every client. This course will teach you everything you need to know about offering a professional manicure and includes a practical training session and assessment. Gel Polish treatments are an increasingly popular treatment within the professional beauty industry. Gel Polish is applied to the client’s nail and then cured using an LED or UV lamp to create a longer lasting nail treatment (up to 3 weeks) than a standard manicure. The GTi Gel Polish course covers how to complete gel polish application and demonstrates the correct removal techniques. The course also covers reception and consultation, contra-indications to treatment and aftercare advice. The GTi Tips With Acrylic Overlay course will teach you how to apply the Acrylic System (Liquid and Powder) in conjunction with nail tips. The course covers how to complete the application and demonstrates the correct removal techniques. It also covers reception and consultation, contra-indications to treatment and aftercare advice. On completion of the course you will receive three recognised and insurable qualifications.  Includes: 3 Hard copy take home training manuals. Duration – Fast track two-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am – 6pm & 10am – 4.30pm inc short lunch break. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class  

REFERENCE CODE 610/0054/0 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in setting out and erecting masonry structures onsite working from drawings and specifications. The structures could be brick and blockwork or local materials. It is not expected that candidates working in this industry all do the same activities, so the qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the mandatory units’ candidates will also be able to select optional units recognising specific skills What is required from candidates? Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 610 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 334. Group A MANDATORY UNITS Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Conforming to General Health, Safety and Welfare in the Workplace Erecting and Dismantling Access/Working Platforms in the Workplace Preparing surfaces for painting and/or decorating in the workplace Applying surface coatings by brush and roller in the workplace Optional units Group A – Minimum of 1 unit must be achieved from this group Hang wallcoverings (standard and foundation papers) in the workplace Hanging non-standard width wallcoverings in the workplace 3 20 Optional units Group B-Minimum of 1 unit must be achieved from this group Applying coatings by the airless spray method in the workplace Summary of the: LEVEL 3 NVQ DIPLOMA IN DECORATIVE FINISHING-PAINTING AND DECORATING (CONSTRUCTION) Producing and applying complex stencils in the workplace 3 21 Hanging wallcoverings to complex surfaces in the workplace 3 32 Hanging wallcoverings (specialised paper) in the workplace 4 30 Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for these qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

his course covers the technique for eyebrow tinting, eyebrow waxing, threading the eyebrows and surrounding area and the application of make-up to the eyebrow area. It also includes fantastic anatomy & physiology resources with clear diagrams. Reception, consultation and aftercare guidance is covered as well as contra-indications to treatment. Photographs and diagrams ensure this course is both engaging and informative to give you the confidence to perform this very popular treatment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track two-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10.30am-4.30pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

Lash Lift and Tint What is a lash lift? The objectives of this course are that by the end the student will be able to perform a professional treatment safely and hygienically in a commercially acceptable time, along with experience of carrying out a consultation with the knowledge of the background, benefits, consultation, contra-indications, contra-actions, aftercare, equipment and products needed. Course Content Salon health, safety & hygiene Be able to consult, plan and prepare for eye treatments with clients Understand how to work safely and effectively when providing lash lift service Anatomy & Physiology Understand contra-indications that prevent or restrict eye treatments Understand equipment, materials, products, techniques and treatment planning for a lash lift and tint Be able to provide aftercare advice for clients Training Kit Included with a course Certificate You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public How does the course work? 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-3 hours practising on a model in our venue in London E106RA. Will I require a model? Yes, you have to supply your model-2 will be needed. We can supply one for you, however, there is a £50 charge for this. Do I Need Experience Before Booking a Course? 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. PAYMENT Payments are non refundable. By paying for the course you agree to our terms and conditions.

Fat Freezing Course *machine and kit isn't included. You will train using our equipment About The procedure freezes and kills fat cells in the part of your body that you're having treated. Course Content What is Fat Freezing Anatomy and physiology Health & Safety Consultations and Aftercare How to provide Fat Freezing How does the course work? 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-3 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 a model? Yes, usually 1 model is required so please make sure you bring someone with you so you can practice on them Do I Need Experience Before Booking a Course? 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