2462 Courses

Personnel involved in the electrotechnical sector such as electricians, designers and inspectors who wish to update their knowledge to the IET Wiring Regulations Eighteenth Edition. Learners who wish to gain an understanding of BS 7671.

Serious about starting your own candle business? Set yourself up for success from the very beginning, in a private course with Paula Mateo, award winning founder of Old Bexley Soap & Candle Co.

For pupils aged 14+ | Delivered in UK Schools by Real World App and Games Developers Our new Getting Started with Website Design and Development Workshop is a great way to introduce your pupils to coding. We’ll focus on HTML, CSS and JavaScript throughout a full-day workshop. At the end of the day, they will have a working website, along with notes and support so they are equipped to design an online portfolio for their work, or other project.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

Learn the basics of bartending and have a fun-filled week in Manchester City Center! Fast-track your way into the bartending industry with 1 week of hands-on training with our highly-experienced instructors. Next Available Sessions (please write in the note which one you prefer) 📅 18th-21th March 2024 ⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 13th-17th May 2024⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 22nd-26th Jul 2024 ⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ Calendar: Monday to Thursday 12pm to 16pm plus one evening of real experience from 17 to 23 on Friday Gain the equivalent of 3 months bar experience Master 20 classic cocktails You be awarded with a Dirextra's certificate to showcase your skills to employers at the end of your course Licensed Premises Staff Training Online Course and Certificate included in the course to be done online after the week of practical experience A fun experience Suitable for beginners Duration: 20 hours over 1 weekDestinations: Manchester City Center Why Is This Course for You? Add some new certified skills to your CV (get 2 certificates) Start working as soon as you finish the course Earn some extra cash while studying or working Get a taste of the fast-paced bartending industry and see if it’s for you Start in an entry level bartending position and work your way up to the top Course Programme You’ll learn: The bartender’s role and responsibilities How to set up the bar Basic pour techniques How to make simple garnishes The art of perfect service how to make 20+ classic cocktails from limoncello bramble and whiskey sours to espresso martini and old fashion using fresh ingredients Learn basic bartending techniques like muddling, churning, shaking and stirring. You’ll learn how to layer shots, blend cocktails, pour and use a jigger. You’ll also become familiar with key bar tools and basic equipment Learn the fundamentals of your favourite spirits and their origins to impress friends, customers and potential employers. We’ll cover vodka, gin, rum, tequila, whiskey and brandy. You will also gain an insight into beer and wine On the practical night you will put in place what you learned in a fast-pace bar serving and preparing cocktails for real customers Course Venue Sicilian NQ, award winning "Best Neighbourhood Bar 2023 - Central Manchester", it's a charming mediterranean style wine bar, relaxed and characterful venue nestled in Manchester’s trendy Northern Quarter, right in the heart of the city center. Northern Quarter is a cool neighbourhood, with lively street art, bohemian bars and independent shops. It's home to lively restaurants and some of the city's biggest music venues, featuring concerts from trendy independent bands and famous artists.

This course is a legal requirement to obtain the SIA CCTV Licence which enables you to work as a CCTV (Closed Circuit Television) operator. CCTV Operatives usually work in a control room that is connected to a network of CCTV equipment. Employers typically include security companies, medium-large corporations, local authorities, the police, etc.

The Site Supervisor Safety Training Scheme (SSSTS) is a comprehensive training program designed to equip site supervisors with the essential knowledge and skills to ensure the safety and well-being of workers on construction sites. This course combines theoretical insights with practical applications, enabling participants to effectively manage site safety, identify potential hazards, and promote a culture of safety excellence. Key Course Objectives: Risk Management: Gain a deep understanding of risk assessment methodologies and strategies to identify, assess, and mitigate potential hazards on construction sites. Learn how to implement controls and create safe work environments that adhere to legal regulations and industry best practices. Legal Compliance: Familiarize yourself with the latest health and safety regulations, codes of practice, and legislative requirements relevant to the construction industry. Explore the responsibilities of a site supervisor in maintaining compliance and preventing accidents. Effective Communication: Develop strong communication skills to effectively convey safety information, instructions, and expectations to site workers and contractors. Enhance your ability to lead safety briefings, toolbox talks, and emergency procedures. Accident Prevention: Acquire the tools to proactively prevent accidents through proper planning, effective supervision, and timely intervention. Learn incident investigation techniques to understand root causes and implement corrective actions. Leadership and Motivation: Cultivate leadership qualities to inspire a safety-first mindset among your team. Understand how to motivate and engage workers in adhering to safety protocols and participating in safety initiatives. Site-specific Considerations: Explore safety challenges and considerations specific to different types of construction sites, such as residential, commercial, and industrial projects. Adapt your safety strategies to suit the unique characteristics of each site. Course Format: The SSSTS course is delivered through a dynamic blend of lectures, interactive discussions, case studies, and practical exercises. Participants will engage in group activities, role-playing scenarios, and real-world simulations to apply theoretical concepts to real-life situations. Course materials include comprehensive handouts, reference guides, and access to relevant safety regulations. Who Should Attend: This course is ideal for individuals currently working or aspiring to work as site supervisors, foremen, or team leaders within the construction industry. It is also beneficial for those responsible for managing safety on construction sites, ensuring compliance, and fostering a culture of safety excellence. Course Outcomes: By the end of the SSSTS course, participants will be empowered to effectively lead site safety efforts, reduce risks, and contribute to the overall success of construction projects. Graduates will receive a widely recognized certification that validates their competence in site safety management and leadership. Invest in your career and the safety of your team by enrolling in the Site Supervisor Safety Training Scheme (SSSTS) course today. Gain the expertise needed to create safer construction environments and make a positive impact on the industry.

Why Learn Sketchup and Stable Diffusion Rendering Course? Course Link SketchUp and Stable Diffusion Rendering Course. An AI image creation course designed to explore AI image creation techniques and master the use of advanced AI technology. You'll learn Ai 3D modeling, advanced rendering, and lighting techniques. Duration: 16 hrs. Method: 1-on-1 Online Over Zoom is also available. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. Sketchup and Stable Diffusion Rendering Course (16 hours) Module 1: Introduction to Sketchup (2 hours) Overview of Sketchup software and interface navigation Basic drawing tools and geometry creation techniques Module 2: Texturing and Materials (2 hours) Applying textures and customizing materials Exploring texture mapping and material libraries Module 3: Lighting and Shadows (2 hours) Understanding lighting principles and light placement Creating realistic shadows and reflections Module 4: Advanced Modeling Techniques (3 hours) Creating complex shapes and utilizing advanced tools Working with groups, components, and modifiers Module 5: Stable Diffusion Rendering (2 hours) Introduction to stable diffusion rendering Configuring rendering settings for optimal results Module 6: Scene Composition and Camera Setup (2 hours) Exploring composition principles and camera perspectives Managing scenes and creating walkthrough animations Module 7: Rendering Optimization (2 hours) Optimizing models for faster rendering Using render passes and post-processing techniques Module 8: Project Work and Portfolio Development (1 hour) Applying skills to complete a real-world project Showcasing work in a professional portfolio Optional: Installing Stable Diffusion and Python (Additional 10 hours) Module 1: Introduction to Stable Diffusion and Python Overview of Stable Diffusion and Python's significance Module 2: System Requirements Hardware and software prerequisites for installation Module 3: Installing Python Step-by-step installation process for different OS Module 4: Configuring Python Environment Setting up environment variables and package managers Module 5: Installing Stable Diffusion Downloading and installing the Stable Diffusion package Module 6: Setting Up Development Environment Configuring IDEs for Python and Stable Diffusion Module 7: Troubleshooting and Common Issues Identifying and resolving common installation errors Module 8: Best Practices and Recommendations Managing Python and Stable Diffusion installations Module 9: Practical Examples and Projects Hands-on exercises demonstrating usage of Stable Diffusion and Python Module 10: Advanced Topics (Optional) Exploring advanced features and techniques Stable Diffusion UI v2 | A simple 1-click way to install and use https://stable-diffusion-ui.github.io A simple 1-click way to install and use Stable Diffusion on your own computer. ... Get started by downloading the software and running the simple installer. Learning Outcomes: Upon completing the Sketchup and Stable Diffusion Rendering Course, with a focus on AI image rendering, participants will: Master AI Image Rendering: Gain expertise in using AI-powered rendering techniques to create realistic and high-quality visualizations. Utilize Sketchup for 3D Modeling: Navigate the software, proficiently use drawing tools, and create detailed 3D models. Optimize Renderings: Apply AI-based rendering to optimize model visuals, achieving faster rendering times and superior image quality. Implement AI-driven Lighting and Shadows: Utilize AI algorithms for lighting placement, shadows, and reflections, enhancing realism in renderings. Create Professional Portfolio: Showcase AI-rendered projects in a professional portfolio, highlighting advanced image rendering skills. Note: The course focuses on AI image rendering using Sketchup and Stable Diffusion techniques, empowering participants with cutting-edge skills for creating exceptional visual representations.

Why Choose Character Animation in 3ds Max Training Course? Click here for more info. Top character animation course in 3ds Max, this course provides an accessible learning experience. Learning character animation enables you to create your own short films. It's not just a means of income; it evolves into a passion.  Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Enroll in our exclusive "Character Animation Fundamentals in 3ds Max" course at London Design Training, guided by experienced tutors Sitwat Ali, Qasim Ali, and Jess. Gain in-depth insights into animating 3D characters, covering essential techniques like character rigging, pose creation, and seamless pose-to-pose animation. 3ds Max Character Animation Course Duration: 20 hours Course Overview: Master the art of character animation in 3ds Max with our comprehensive course. Ideal for beginners and those with some 3D modeling and animation experience, this course covers everything you need to know to bring characters to life. Course Outline: Introduction to Character Animation Explore animation principles Get familiar with 3ds Max animation tools Learn to create character rigs and manage the timeline Basic Animation Principles Understand keyframes and animation cycles Apply the 12 principles of animation Work with the graph editor and ease-in/out techniques Advanced Animation Techniques Utilize the reaction manager for complex animations Master non-linear animation methods Animate with inverse kinematics, custom controllers, expressions, and scripts Creating Characters Craft a character model with proper topology Create UV maps and apply textures Prepare characters for rigging Facial Animation Learn facial animation principles Create blend shapes and morph targets Master lip syncing techniques Body Animation Animate walk cycles and character motion Achieve believable character poses Implement character physics Advanced Character Animation Work with motion capture data Use CAT and Biped tools Understand motion blur and create special effects Render and output animations Character Animation Projects Bring all skills together in practical projects Create basic and complex character animations Course Requirements: Computer with 3ds Max installed Basic computer operations knowledge Passion for character animation Course Goals: Upon completion, you'll have a thorough grasp of character animation in 3ds Max, capable of creating realistic and sophisticated character animations using advanced techniques. You'll be equipped with the skills to continue honing your character animation abilities independently.

Unleash Your Inner Bird! Sky Riders Elementary Pilot Course. Learn to paraglide with our beginner-friendly course.