3771 Design 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

The Flexible Leader – The Future of Leading Hybrid Teams, 1 day training course delivered in Nottingham Provides delegates with an opportunity to explore the potential benefits of a flexible working environment, as well as an exploration of the key skills and attributes managers/leaders need to succeed in the evolving ecosystem of hybrid work. Whether you and the team work part-time, work remotely, or have odd days in the office, the session will help you be more effective and confident – ensuring the best from individuals, keeping the team informed and motivated, whilst managing performance and increasing efficiency.

Develop your skills in geothermal project finance analysis and modeling with EnergyEdge's specialized course. Join now!

The aim of this module is to enable delegates to perform entry-type injured person rescue operations, in a Wind Turbine Generator, using industry standard rescue equipment, rescue methods and techniques, exceeding those of GWO Working at Heights. Valid GWO BST Module Working at Heights, GWO First aid and GWO Manual Handling certificates are prerequisites for participation.

Adobe After Effects is recognised as an essential tool for motion graphics and visual effects. Our introductory Adobe After Effects course is designed for those new to post-production techniques, and would like to get the most from this immensely powerful application. Whether you are a motion graphics designer, a web designer, rich media artist or broadcast video editor, this course covers all the techniques you need to successfully start using, or significantly improve your command over, Adobe After Effects.

Course Description Training will cover detailed anatomy and physiology of the lymphatic and associated vascular system, pathology of lymphoedema and chronic oedema and the different stages and types of lymphoedema. Please note: Your training will be delivered through a blended learning format. With our blended learning format, you will have the opportunity to complete the theoretical components of your training at your own pace. In addition to the online learning, we offer clinical skills training on scheduled workshop dates. This hands-on training will allow you to put your theoretical knowledge into practice and develop the necessary skills to excel in your field. Our experienced instructors will guide you through each step of the training, ensuring that you are fully prepared and confident in your abilities. Once you have completed your clinical skills training, you will receive your certification, validating your skills and knowledge. Please note price includes VAT Our Comprehensive Lymphoedema Training Course  Course Summary Join us on our blended learning training programme especially designed for certified healthcare professionals working within clinical settings.   By the end of the course, you will have a thorough understanding of the anatomy and physiology of the lymphatic system, enabling you to holistically assess and diagnose a patient with lymphoedema. You will be able to design and implement an appropriate research and evidence based individualised management strategy selecting from a range of therapies and new innovations. You will be competent in the field of Decongestive Lymphatic Therapy including Multi Component Bandaging (MCB) and the latest knowledge and research in Fluoroscopy Guided - Manual Lymphatic Drainage (FG-MLD®) Entry Requirements This training is suitable for: All certified healthcare professionals. Such as Medics, Registered General Nurses, Physiotherapists, Radiographers, Occupational therapists, Osteopaths and Chiropractors Learning Format Your course is made up of a blended learning format meaning your content and modules will be taught via live interactive webinars, through self-guided independent study and face to face clinical skills workshops. So, whether you're learning style is social, solitary, visual, kinesthetic, auditory or a combination we have a learning style to help you get the best out of the course. We hope that you make the most out of the tools that are available to you throughout the course but don't worry if you are not the most "tech-savvy", we have real people on hand to help you every step of the way. Assessment Criteria All students will undergo a series of course specific formative & summative assessments. Throughout the course you will be assessed through observation of practical tasks, written assessments, assignments, research and online tests. Course Contents You will gain knowledge, skills and techniques in: Compression Exercise Skincare & Wound Healing Garments Multi-Component Bandaging Assessment & Treatment of Oedema Anatomy & Pathways of the Upper & Lower Limb FG-MLD® Technique Tissue Dielectric Constant Head & Neck, Midline & Genital Oedema.   Training will also cover innovations and consideration for clinical practice. Course Inclusions As part of your training pack, LTA will provide all training support materials required to undertake the course.   Such as but not limited to: Corporate Sponsored Bandaging Pack LymphBalls™ Latest LTA Research & Development articles Lymphoedema supporting literature Access to in-house LTA training & demonstration videos Learning management platform (CANVAS) profile & course content Snacks & Refreshments throughout your practical skills workshops Dedicated support from the LTA training team Course Certification The benefits of an LTA certification means you can; Display FG-MLD® Certified and LTA Cert. logo on your marketing material Write LTA Cert. after your name Wear your qualification badge Practice MLD to further enhance outcomes Use an innovative technique and ensure effective treatment programmes Receive training and support from Jane Wigg & Team Access the latest developments in Lymphoedema care Have access to a private FG-MLD® Therapist FB Page Recertification To maintain your LTA Therapist Certification, a 2-day recertification is required after 12 months after your initial training, and you will be required to attend a 1-day recertification every 2 years thereafter to maintain your certification of practice.

Why Learn Vray for Maya Training Course? Course info. Become a V-Ray for Maya expert with our training course. Led by certified tutors, you'll master lighting, shading, and rendering techniques to create stunning visual effects and animations. In-person or live online sessions, access recorded lessons, and receive lifetime email support. Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm. Maya - Advanced Rendering with V-Ray Course Description: VRay Course for Maya to learn advanced rendering techniques and create stunning photo-realistic renderings. Gain access to all project and source files, allowing you to practice and perfect your skills. Key Details: Advanced Rendering Techniques: Learn advanced rendering methods using V-Ray in Maya. Photo-Realistic Renderings: Create stunning, lifelike renderings that closely resemble real-world images. VRay Course: Access a detailed step-by-step instruction to master VRay rendering in Maya. Project and Source Files: Get hands-on practice with all the necessary files provided. Skill Level: Designed for intermediate to advanced Maya users seeking to enhance their rendering capabilities. Instructor-led: Benefit from expert guidance and insights from experienced instructors. Flexible Learning: Study at your own pace and convenience. Realistic Visuals: Take your rendering skills to the next level and achieve professional-grade results. Course Modules: Module 1: Introduction to Vray for Maya (2 hours) Understand Vray's significance and benefits in Maya Install and set up Vray for Maya Familiarize with the Vray interface and workflow Learn about Vray materials and their usage in Maya Module 2: Lighting with Vray (2 hours) Explore various lighting techniques with Vray in Maya Work with different types of Vray lights and their settings Create outdoor scenes with Vray sun and sky Utilize Vray dome lighting for interior scenes Introduction to IES lights and their usage in Vray for Maya Module 3: Vray Camera (2 hours) Master Vray camera settings and their impact on the render Control exposure and use Vray depth of field Create camera animations with Vray for dynamic shots Utilize Vray frame buffer for post-processing Module 4: Vray Materials (2 hours) Understand Vray material properties and settings Create realistic materials using Vray Save and organize custom Vray material libraries Utilize Vray material overrides for efficient changes Module 5: Vray Rendering and Post Production (2 hours) Optimize Vray rendering settings for high-quality output Render still images and animations using Vray Enhance Vray renders in Photoshop with post-production techniques Utilize Vray frame buffer for fine-tuning the render Composit Vray render elements in Photoshop for added control Reduce noise in renders with Vray denoiser V-Ray for Maya Trial - Free Download Chaos Group https://www.chaos.com â€º vray › maya › free-trial V-Ray for Maya. Add realism to your VFX and animation projects. Try free for 30 days. Download trial. Master Vray for Maya to create high-quality renders. Apply various lighting techniques for realistic and visually appealing scenes. Control Vray camera settings and create dynamic shots. Create and customize realistic Vray materials for 3D scenes. Optimize rendering settings for high-quality output. Enhance renders with post-production techniques in Photoshop. Establish an efficient workflow with Vray in Maya. Gain hands-on experience and access valuable resources for further practice.

The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances Course Overview The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. They will learn about various essential topics such as communication management approach, tailoring the SU process, giving Ad Hoc direction, setting up the project controls, risk management procedure, PRINCE2® quality requirements, PRINCE2® approach to plan, tailoring SB, and many more. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances and report actual and forecast progress effectively. They will also be able to properly prepare the risk management, change control approach, quality management, and communication management approaches. The PRINCE2® Practitioner enables learners to apply their acquired knowledge and obtain highly reputed jobs with upgraded salaries. Concepts covered: • Balance of justification • Create the project plan • Quality audit trail • Quality review technique • Designing a plan • Gantt chart and tailoring • Change control approach Who should attend this PRINCE2® training course? This PRINCE2® Practitioner training course is for anybody interested in the field of project management. This PRINCE2® course is also intended for anyone looking to build their knowledge of how to tailor the PRINCE2® method to workplace scenarios. Other individuals that would benefit from undertaking PRINCE2® certifications include: • Project Managers • Aspiring Project Managers • Project Board Members • Project Support Staff • Office Support and Line Managers • Product Deliver Managers • Senior Responsible Owners • Change Analysts PRINCE2® Practitioner Prerequisites: It is required that delegates provide sufficient evidence of having satisfied the prerequisites before attending the PRINCE2® Practitioner training course. Delegates must hold the 2009 or 2017 version of the PRINCE2® Foundation certification or another valid qualification such as PMP, CAPM, or an IPMA Level A-D qualification. What’s Included in this PRINCE2® Practitioner Training Course? The following is included in this PRINCE2® Practitioner course: • PRINCE2® Practitioner Examination • Pre-course material • Post-course material • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments Course Content: Module 1: Organisation Theme: • Four Levels of Management • PRINCE2® Organisation Requirements • Project Management Team • Project Management Team Roles • Project Board • Project Assurance • Change Authority • Project Support • Communication Management Approach Module 2: Starting Up a Project (SU): • Process Overview • Feasibility Study and Mandate • Appoint the Executive and the Project Manager • Capture Previous Lessons • Design and Appoint the Project Management Team • Prepare the Outline Business Case • Project Product Description • Select the Project Approach and Assemble the Project Brief • Plan the Initiation Stage • Tailoring the SU Process Module 3: Directing a Project (DP): • Authorise Initiation • Authorise the Project • Authorise a Stage or Exception Plan • Authorise Project Closure • Give Ad Hoc Direction • Tailoring the DP Process • Theme Overview • Balance of Justification • Continued Business Justification • PRINCE2® Requirements • Contents of a Business Case • Business Case Development • Benefits Management Approach • Key Responsibilities Module 4: Initiating a Project (IP): • Agree the Tailoring Requirements • Prepare the Risk Management Approach • Prepare the Change Control Approach • Prepare the Quality Management Approach • Prepare the Communication Management Approach • Set Up the Project Controls • Create the Project Plan • Prepare the Benefits Management Approach • Assemble the Project Initiation Documentation • Tailoring the IP process Module 5: Risk Theme: • Risk Definition • Effective Risk Management • PRINCE2® Risk Requirements • Risk Management Approach • Probability/Impact Grid • Risk Register • Risk Management Procedure • Identify Step • Risk Budget • Key Responsibilities Module 6: Quality Theme: • Quality Definitions • Quality Management • Quality Planning and Control • What is Quality Assurance? • PRINCE2® Quality Requirements • PRINCE2® Quality Documentation Requirements • Quality Management Approach • Quality Audit Trail • Project Product Description • Product Description • Quality Review Technique • Quality Review Roles/Responsibilities • Quality Review Meeting • Off-Specifications and Concessions • Review Follow-Up • Quality Review Benefits • Key Responsibilities • Communication Management Approach Module 7: Plans Theme: • Dealing with the Planning Horizon • PRINCE2® Planning Requirements • Documentation Requirements • Project and Stage Plans • Team Plans and Work Packages • Plans Relationship • What is in a Plan? • PRINCE2® Approach to Plans • Designing a Plan • Delivery Approaches • Defining and Analysing the Products • Product Breakdown Structures • Product Description • Product Flow Diagram • Identify the Activities and Dependencies • Preparing Estimates • Preparing a Schedule • Documenting the Plan • Analysing Risks to a Plan • Gantt Chart and Tailoring • Key Responsibilities Module 8: Progress Theme: • Progress Definition • PRINCE2® Requirements • Progress Control • Management by Exception • Delegating Tolerances and Reporting Actual and Forecast Progress • Types of Control • Management Products and Progress Control Module 9: Change Theme: • Issue Definition • PRINCE2® Approach to Change • PRINCE2® Change Documentation • Issue Register • Change Control Approach • Change Budget • Issue and Change Control Procedure • Issue Report • Exception Report Module 10: Controlling a Stage (CS): • Activity Breakdown • Authorise a Work Package • Work Package • Review Work Package Status • Receive Completed Work Packages • Review the Management Stage Status • Report Highlights • Highlight Report • Capture and Assess Issues and Risks • Escalate Issues and Risks • Take Corrective Action • Tailoring CS Module 11: Managing Product Delivery (MP): • Accept a Work Package • Execute a Work Package • Checkpoint Report • Deliver a Work Package • Tailoring MP Module 12: Managing a Stage Boundary (SB) : • Plan the Next Management Stage • What is in a Plan? • Update the Project Plan • Update the Business Case • Report the Management Stage End • End-Stage Report • Produce an Exception Plan • Tailoring SB Module 13: Closing a Project (CP): • Prepare Planned Closure • Hand Over Products • Evaluate the Project • End Project Report • Recommend Project Closure • Tailoring CP DURATION 2 Days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

An intermediate sewing workshop - making your own knickers, pants, undies. Create underwear to suit you and for your comfort.