933 Design courses in Tranent

Often your recruitment and induction processes determine whether you retain your staff and volunteers. A poor induction often leads to a lack of productivity and motivation. This half day course is designed to help participants ensure that new staff receive a comprehensive and welcoming induction so that they can settle into their job or role quickly and with confidence. The course can be run as a one-off session or can be incorporated into a series of sessions on managing staff.

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. There are two options to complete the NVQ Level 3 in Electrical Installations, these are the C&G 2346 and C&G 2357. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited electricians

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

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. The EWR is for electricians who have been working in the industry for at least 5 years but have not formally completed an industry apprenticeship or Level 3 NVQ qualification. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited Gold Card status. Bear in mind that the C&G 2391-50 and 18th Edition courses are pre-requisites to the Experienced Worker route. In case you don’t hold them, we can help you with a Pre-Experienced Worker Route package.

Adobe After Effects CC is the industry leader in video compositing software, offering an exciting and versatile array of applications for the creation of professional moving image work. On this course you will learn a range of visual effects and animation techniques, working between Photoshop and After Effects to create videos which explore text based motion graphics, character animation, green-screen compositing, 3D landscapes, motion tracking and lots more in-between. Alongside technical exercises the tutor will screen and discuss relevant artists, designers and filmmakers, providing both the technical skills and inspiration to create your own professional motion graphics work, filmic special effects or experimental artists video. Computer experience is required. Week 1 This week we will create a short video that combines text, still image and video layers. Through this exercise you will learn how to: Navigate the workspace on After Effects Set up a project and select a video format Introduce video to the timeline and split layers Change the position and scale of layers Introduce basic text Use selections in Photoshop to create a still image composition Import this composition into After Effects to create a composite video. Week 2 This week we will look at basic animation techniques. Through a series of exercises, you will learn how to: Use Photoshop to great multi-layered elements for animation Import these Photoshop elements into After Effects Work with key-frames and interpolation Add motion blur Duplicate and pre-compose animated elements Create a parallax effect to give the illusion of depth Apply blending modes Work with the puppet tool to create moving joints for an animated character Week 3 This week we will look at converting 2D photographs into a 3D virtual space to provide depth and movement. Through a series of exercises, you will learn how to: Convert a 2D image into a 3D space Set up a multi-layered diorama in Photoshop Import this into After Effects and position the layers within 3D space Create an animated camera move through 3D space Apply depth of field Week 4 This week we will look at working with green-screen compositing to place a live action figure within an animated backdrop. Through a series of exercises, you will learn how to: Work with the Keylight filter Adjust colour balance and tone Composite the figure against an animated background Introduce shadows and highlights Use the green-screen figure to create a silhouette Week 5 This week we will look at applying masks to footage to create cutouts, as well as exploring different applications for effects. Through a series of exercises, you will learn how to: Work with masks Use the Roto-mask tool Apply time re-mapping Work with ‘Particle Playground’ and similar effects Week 6 This week we will look at working with the paint panel to create animated drawings, as well as using motion tracking to attach a text element to a moving point within a video clip. Finally, we will cover how to output your final project, adding sound effects and applying a basic edit. Through a series of exercises, you will learn how to: Create text based motion graphics (kinetic typography) Apply motion tracking to live action footage Render your project Add sound to your video   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

Pilates and Yoga Fusion is a low-impact workout that seamlessly blends the core-strengthening principles of Pilates with the flexibility-enhancing poses of Yoga. This unique combination offers a well-rounded practice that focuses on strength, stability, balance, and deep stretching, all performed on a mat. By incorporating mindful movement, breathwork, and intentional body alignment, this class helps to improve flexibility, mobility, and overall well-being. This class is designed for all fitness levels, whether you’re new to Pilates and Yoga or have prior experience. Our session includes a mix of flowing Yoga-inspired sequences to promote relaxation and flexibility, combined with Pilates-based exercises to engage the core and build functional strength. The emphasis on stretching helps release tension, improve posture, and enhance mobility, making it an excellent practice for anyone looking to move with greater ease in daily life. Beyond the physical benefits, Pilates and Yoga Fusion encourages mindfulness and body awareness, helping you feel more present and connected. The class environment is welcoming and supportive, providing a space to unwind, reset, and invest in your well-being. Join us for a class and experience the perfect balance of strength and flexibility! Whether you’re looking to tone your muscles, relieve stress, or improve your range of motion, this fusion workout offers something for everyone. Come move, stretch, and breathe with us—you’ll leave feeling stronger, more flexible, and completely refreshed. Egle is a fully qualified Level 3 (UK) Personal Trainer, Pilates Mat Teacher, Yoga Teacher, Sports Massage Therapist, Outdoor Fitness Instructor, and Group Exercise Instructor. Passionate about health, fitness, well-being, and nutrition, she firmly believes that the fitter and healthier a person is, the more enjoyable life becomes. Egle works with individuals of all fitness levels, from those who have never stepped into a gym or exercise class to those seeking their next challenge. Her main focus is to provide a diverse range of services tailored to meet various health and fitness needs. She is also deeply committed to injury prevention and rehabilitation, helping clients move safely and effectively toward their goals. This class is sponsored by Cash4Clubs, Sported and Flutter UKI It is FREE and is aimed at adults (particularly, but not only 18-25), women, etnic minorities, any individuals from low-income background. Suitable for all levels experience. By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

If you want to start installing independently or with an electrical contractor look no further as this course will give you the skills and knowledge required. This package which will allow you to become a fully qualified domestic installer and enable you to join a Competent Person Self-Certification Scheme and certify your own domestic work.

A half day course for those who find themselves taking and presenting minutes for different kinds of meetings. The session will provide practical tips on how to write minutes that are clear and more concise and how to save time during the minute-taking process. It will be a useful session for both novice and experienced minute takers.

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.