1260 Courses

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

Course Overview:Welcome to our exclusive knitting course designed specifically for cashmere yarn enthusiasts. Whether you're a complete beginner or looking to refine your skills, this course will guide you through the luxurious experience of knitting with cashmere. By the end of the course, you'll have the knowledge and confidence to create beautiful, high-quality garments and accessories. Course Outline: Module 1: Introduction to Cashmere Lesson 1.1: Understanding CashmereOrigins and productionCharacteristics of cashmere fibersBenefits of knitting with cashmere Lesson 1.2: Selecting the Right Cashmere YarnDifferent types of cashmere yarnYarn weights and their usesHow to choose the best yarn for your project Module 2: Knitting Basics Lesson 2.1: Essential Tools and MaterialsNeedles: types and sizesOther necessary tools (stitch markers, tape measure, etc.) Lesson 2.2: Getting Started with KnittingCasting on techniquesBasic stitches: knit and purlUnderstanding gauge and tension Module 3: Advanced Techniques and Patterns Lesson 3.1: Intermediate Stitch PatternsRibbing, seed stitch, and cablesIncorporating these patterns into your projects Lesson 3.2: Shaping Your KnitsIncreases and decreasesReading and following patterns Module 4: Creating Your First Cashmere Project Lesson 4.1: Simple Projects for BeginnersKnitting a cashmere scarfCreating a basic hat Lesson 4.2: Moving to More Complex ProjectsDesigning and knitting a cashmere sweaterTips for knitting larger garments Module 5: Finishing Techniques and Care Lesson 5.1: Finishing Your KnitsBinding off and weaving in endsBlocking techniques for cashmere Lesson 5.2: Caring for Cashmere GarmentsWashing and storing your knitwearRepairing and maintaining the quality of cashmere Additional Resources: Printable guides and patterns Video tutorials for visual learners Access to a community forum for support and sharing projects Enrollment Information:Sign up now and join a community of cashmere knitting enthusiasts. Enjoy personalized support, access to premium materials, and the satisfaction of creating luxurious, handmade garments. For more information or to enroll, please visit our website or contact our shop directly. Happy knitting! Cashmere yarn

Who is this course for? Landmark Training Course With Vectorworks. Dive into terrain modeling, planting, irrigation, and site analysis guided by certified tutors. Master these tools for precise landscape designs and effective documentation. Check our Website Enrollment : 1-on-1 Landmark Training. Tailor your schedule. Mon to Sat between 9 am and 7 pm Call 02077202581 to book your slot. Duration: 16 hours. "Split these hours over multiple days as needed for your ideal schedule." Approach: In-person or live online. Landmark Training Course with Vectorworks: Basic to Intermediate Level Course Duration: 16 Hours Embark on a transformative journey with our Landmark Training Course tailored for landscape architects and designers. Over 16 intensive hours, dive deep into Vectorworks Landmark, mastering fundamental and intermediate techniques crucial for comprehensive 2D and 3D landscape design. Craft intricate site analyses, plans, irrigation systems, and elevate your designs with mesmerizing 3D visualizations. Explore custom plant symbols, detailed planting plans, and learn the art of efficient collaboration and customization. Course Highlights: I. Introduction to Vectorworks Landmark (1 hour) Explore Vectorworks Landmark for landscape design Master interface, tool usage, and project management II. Site Analysis and Site Plans (3 hours) Craft detailed site analyses and hardscape designs Work with contours, elevations, and terrain models III. Planting Plans (5 hours) Utilize the plant database for region-specific plant selection Create personalized plant symbols and comprehensive planting plans IV. Irrigation Design (2 hours) Design and edit efficient irrigation systems and zones Integrate irrigation components into site plans V. 3D Visualization (3 hours) Create captivating 3D models with realistic textures and materials Enhance designs with advanced lighting and special effects VI. Customization (1 hour) Tailor the interface for efficient landscape design Create custom object styles and resource libraries VII. Collaboration and Sharing (1 hour) Seamlessly import/export data from other platforms Share designs effectively with colleagues and collaborators VIII. Conclusion and Next Steps (1 hour) Review course content comprehensively Receive guidance on further learning resources Engage in a Q&A session and provide valuable feedback Enhance your landscape design expertise and unleash your creativity. Enroll now in our Vectorworks Landmark Basic to Intermediate Training and transform your designs. Download Vectorworks Landmark By the end of the Vectorworks Landmark Training Course, participants will: Understand the key features and functionalities of Vectorworks Landmark for landscape design. Demonstrate proficiency in using essential tools for site analysis, site plans, and hardscape design. Create detailed planting plans, selecting appropriate plants, and understanding their compatibility and growth patterns. Design efficient and effective irrigation systems, including generating irrigation reports. Create 3D visualizations of landscape designs, applying textures, materials, lighting, and special effects. Customize the interface and create personalized object styles and resources. Collaborate and share landscape design drawings with other software users. Have the foundation to pursue further learning and exploration in landscape design using Vectorworks Landmark. Mastering Foundations Begin your project by organizing your files and importing survey data. Learn to sketch existing buildings using Building Shell tools and model neighboring structures with Massing Model. Explore different methods for laying out survey points and marking existing features with precision. Objectives: Review File Organization Techniques Import Survey Data (DWG Import) Create Building Structures with Building Shell Tools Utilize Triangulation and Arc Tool for Precision Master Various Tape Measurement Techniques Elevating Your Design Enhance your survey with detailed ground, existing trees, and fences. Conduct shadow analysis to optimize planting locations. Dive into the Vectorworks Plant tool, your key design companion. Objectives: Develop Detailed Ground Surfaces Incorporate Existing Trees and Fences Design with Railing Fence Tool Conduct Shadow Analysis using Heliodon Tool Utilize Plant Tool Modes for Plant Placement Access Existing Plant Libraries and Customize Plants in 2D/3D Crafting Landscapes Create vibrant plant mixes using Landscape Area tool and apply them across your site models. Design intricate hardscapes, aligning them effortlessly even in complex paving scenarios. Learn to use components for detailed reporting, cut and fill calculations, and precise detailing. Explore custom object creation and site furniture placement. Objectives: Design Landscape Areas and Define Custom Plant Mixes Create Hardscapes and Define Custom Paving Constructions Generate Reports and Tags for Landscape Areas and Hardscapes Access and Manage Objects in Resource Manager Craft Custom Objects and Site Furniture Polished Presentation Present your designs professionally using Sheet layers and viewports. Create Section viewports to cut through your model and Detail viewports to focus on specific areas. Enhance visual appeal with mood boards and annotations, ensuring a refined, detailed presentation. Objectives: Craft Sheet Layers for Presentation Create Plan, Elevation, and Perspective Viewports Generate Section and Detail Viewports Annotate Viewports for Clear Communication Incorporate Images and Plant Reports for Comprehensive Presentations Master Vectorworks Landmark: Gain expertise in essential and advanced 2D/3D landscape design tools for precision and efficiency. Boost Efficiency: Learn time-saving techniques and workflows tailored to Vectorworks Landmark, enhancing productivity. Versatile Landscape Skills: Develop proficiency in site analysis, planting plans, hardscapes, and irrigation systems for diverse projects. Industry-Ready Expertise: Acquire sought-after skills in landscape architecture, paving the way for career growth. Flexible Learning: Access recorded lessons for convenient review and receive lifetime email support for ongoing guidance.

The 1-Day Foundations Course in Wheel Building with master wheel-builder Vince Warner Are You New to Wheel Building and Eager to Start Off Right? Imagine having the confidence to build motorcycle wheels that not only look good but are durable and reliable. With the right foundation, you can! I believe that a strong foundation is essential to becoming proficient in any skill, and wheel building is no different. That's why I created the 1-Day Foundations Course—to provide you with all the essentials you need to get started on the right foot. Here's What You'll Learn:Preparation and Measurements: How to ensure you have all the correct parts, materials and accurate measurements before you start building. Lacing: Understand the methodology behind lacing the most common type of motorcycle wheel. Truing: Essential techniques for achieving optimal alignment for your wheel. Tensioned Wire Wheel Principles: A deep dive into the underlying principles that make a tensioned wire wheel reliable and effective. BONUS: Full Access to Video Modules To complement your 1-day experience in my workshop, you'll also gain full access to Module 2 of my video training, which is essential viewing before you attend. This covers many of the topics you'll be learning in-person. SPECIAL BONUS: Introduction to Bicycle Wheels As an added bonus, I'm also going to give you Module 1, which focuses on bicycle wheels—expanding your understanding and adding another skill to your wheel building arsenal. Lunch Is on Me! Enjoy complimentary lunch, along with tea, coffee, cold drinks, and snacks throughout the day.

Introduction to Inkle Loom Weaving' workshop in the beautiful setting of Fisherton Mill in Salisbury, Wiltshire. Learn how to plan your weaving project, set up your inkle loom ready for weaving and spend a day learning the basic weaving technique in this relaxed & informative beginners weaving workshop. All materials and equipment are provided and you will leave with a clear handout of notes and your first woven band, made from organic cotton and linen, available in a wide range of stunning colours.

'Introduction to Off-Loom Weaving' workshop in the beautiful setting of Fisherton Mill in Salisbury, Wiltshire. Learn how to select the right yarns for your weaving project and use branches, stones and other items from nature as your loom. Spend a day learning basic weaving techniques in this relaxed & informative beginners weaving workshop. All materials and equipment are provided and you will leave with a clear handout of notes and your first woven pieces, made from organic cotton and linen, and many more sustainable materials.

'Introduction to Frame Loom Weaving' workshop in the beautiful setting of Fisherton Mill in Salisbury, Wiltshire. Learn how to set up your loom for weaving and spend a day learning basic weaving techniques, along with techniques for crating texture and pattern in this relaxed & informative beginners weaving workshop. All materials and equipment are provided and you will leave with a clear handout of notes and your first piece of weaving, made from a wide selection of sustainable tarns and fibres.

Unity 3d face to face training customised and bespoke.

The IMI PAC course in Light Vehicle Brake Fitting is 3 days in duration and is aimed at fitters who want to improve their knowledge and skills A minimum of 3 months practical experience is required as this is not an introductory course. An alternative course is available for those with no previous experience, contact us for more details Successful candidates will receive an IMI Professional Achievement Certificate in Light Vehicle Brake Fitting.  Course Details: Classroom based theory session Workshop practice session Examination and assessment Course Fees £499.00 + VAT per candidate *Please contact us for group rates  Course Content Theoretical Health & Safety Brake types (disc brake & drum brakes) Hydraulic operating systems Brake arrangements Brake valves Brake fluid Servo assistance Introduction to ABS and EPB Practical Brake pad and disc removal and re-fitting Brake drum and shoe removal and re-fitting Manufacturing a brake pipe Bleeding a hydraulic system IMI assessment and test A multi-choice theory question paper Five practical assessments, observed by an IMI approved assessor. What’s included Fully qualified and experienced trainers Course booklet Examinations Fees and Certification One year IMI membership To find out more, please use the live chat function, visit our contact page or call us on 024 76325880

Our 2 day weekend course is a fantastic introduction to sailing, designed to give a taste of sailing or allow you to practice skills in a relaxed environment. It is the perfect setting to find out if sailing is for you, as students are involved in all aspects of sailing the yacht, from basic knot tying to hoisting the sails and steering the boat. You will be taught basic skills and routines on board, whilst enjoying your first exposure to sailing. Price includes accommodation on board one of our yachts, all meals, fuel & mooring fees. Waterproof clothing loan available on request. Our current school boat is the modern 2017 Dufour 382, a fantastic boat to learn and develop your knowledge on; with her spacious deck layout,dual helm and on-deck plotter, she is easy to handle in close and open quarters. We pride ourselves on providing a comfortable, enjoyable sailing experience and guarantee all students their own cabin.   Facilities on-board include: • Dual helm • Heating • Fridge • Two toilets each with hot water and showers • Three cabins • Television and radio • Charging points for mobiles • On-deck chart plotter and radar   We carry out a deep clean before every course and provide fresh linen and towels. Operating along the picturesque South Devon coast, we venture to prime local cruising locations such as Torbay, Dartmouth, Salcombe and Plymouth. Marinas feature as a daily stop, providing time to reflect and partake in shore-side activities. Our aim is to provide safe fun on the water, allowing you to develop your skills and knowledge in a safe and friendly environment. We use a 3:1 students to instructor raitio, which allows our experienced RYA instructors to tailor courses to the various levels and needs on board, and deliver at a managable pace. Navigation is taught using traditional charting techniques along with electronic methods using E-Series Raymarine chart plotters and Radar. All course prices include accommodation on board, meals for the duration of the course, fuel and mooring fees, and the provision of fresh linen and towels.Waterproofs are available upon request.