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

SEP (Safety Equipment & Procedures) with one of our partners British Airways, Virgin Atlantic or TUI. Airline Cabin Crew need to be able to act quickly and confidently in all safety and emergency situations. SEP (Safety Equipment & Procedures) with one of our partners British Airways, Virgin Atlantic or TUI  Airline Cabin Crew also known as: Air Hostess, Flight Attendant and Stewardess need to be able to act quickly and confidently in all safety and emergency situations. SEP (Safety Equipment & Procedures) training will ensure all participants have in-depth knowledge of safety and emergency procedures. It will also fully prepare candidates to handle any unforeseen circumstances or emergencies. The professional training of aircrew is a priority for aviation safety. This course is also ideal for those who would like more indepth specific training. If you completed your Cabin Crew studies elsewhere and would like to progress, to refresh your knowledge or get more confidence, you can join our one day certified SEP (Safety Equipment & Procedures) training. Aircraft Doors Aircraft doors operations in both Armed and Disarmed modes in both theory and practical sessions. Evacuation Planned Emergency Passenger Evacuations on the aircraft from a crew seat including door operations and passenger evacuation commands. Fire & Smoke • Theory of Fire • Firefighting equipment with practical handling • Firefighting drills and implementing them • Practical exercises in smoke chambers • Practical exercise with a naked flame Slide Descents/ Slideraft • Instruction and practice of descending A320 & B747 slides • Practical exercises on B747 dry slideraft Survival • Principles of survival • Survival equipment • Option of training survival of dry B747 slideraft Date – 30 April 2024 Time – 10am to 4pm Fees – £150 including certificate Dress Code – would be the best for all female candidates to wear trousers, comfortable shoes so that they can all practice. Confirmation of the course– once registration completed, we will email you joining instructions for the day Location – Bournemouth airport training centre Certificates – provided within 5 working days Please contact info@waterlooacademy.co.uk if you have further enquiries VISIT OUR YOUTUBE CHANNEL HERE

Who is this Course for? Mastering Unity 3D Intermediate Level Training Course Our Unity 3D training programs are tailored for individuals aspiring to become game developers, creative minds, & enthusiasts keen to explore the realm of game development. Learn 3D & 2D games or looking to master Unity's cross-platform features. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 Individualized Attention & Customized Content Timetable: Scheduling any hour between 9 am and 7 pm, from Mon to Sat Course Overview: Sessions 1-2: Introduction to Unity Familiarize yourself with Unity's interface and workspace Create a new Unity project and set up the initial scene and navigation Sessions 3-4: Asset Management Explore and download free assets Import various asset types into Unity and understand their applications Sessions 5-6: Environmental Design Utilize Unity's terrain tools for environment creation Enhance scenes with textures, materials, and environmental objects Sessions 7-8: Character Development Design 3D character models Rig, animate, and import characters into Unity Sessions 9-10: Player Interaction Set up player controls and script basic movements Implement camera controls for seamless gameplay experiences Sessions 11-12: Physics and Realism Understand and implement physics in Unity Configure collisions, gravity, force, and torque for realistic interactions Sessions 13-14: Audio Enhancement Master audio implementation with sound effects and background music Fine-tune volume and pitch for immersive gameplay Sessions 15-16: Lighting and Visual Effects Employ advanced lighting techniques, including dynamic day-night cycles Enhance visuals with lens flares and particle systems Sessions 17-18: User Interface Design Construct user interfaces using Unity's canvas system Integrate interactive elements such as buttons and menus, ensuring smooth functionality Sessions 19-20: Optimization and Performance Implement optimization techniques and utilize the profiler for performance analysis Improve frame rates and reduce memory usage for seamless gameplay Session 21-22: Multiplayer Integration Explore multiplayer implementation and set up local multiplayer games Session 23-24: Mobile Game Development Discover mobile game development in Unity Build, deploy, and optimize games for mobile devices, focusing on performance and controls Session 25: Advanced Topics Delve into advanced scripting techniques, including coroutines, delegates, and events Explore shader programming and visual effects, and venture into VR development with Unity and Oculus Quest Final Project: Create a Comprehensive Game Test the game thoroughly, identify and resolve bugs Make necessary adjustments and improvements for a polished final product Experience the Real-Time Development Platform: Unleash your creativity and create 3D, 2D, VR, and AR experiences across various industries, including games, automotive, AEC, film, and more. Unity Pro offers a complete solution to develop better, iterate faster, and grow your business. Enjoy amazing games and immersive experiences with multi-platform support. Get started today: Unity Pro. Learning Outcomes: Participants will gain expertise in Unity 3D, mastering asset management, environmental design, character animation, player interaction, physics, audio, lighting, UI, optimization, and advanced scripting. They will develop a complete game, honing skills in debugging and project completion. Career Opportunities: Graduates can pursue roles as Game Developers, Mobile Game Developers, VR/AR Developers, Game Designers, UI/UX Designers, Game Testers, Indie Game Developers, Educational Game Developers, Freelance Developers, or Game Development Instructors, leveraging their Unity 3D skills for diverse and exciting career paths in the gaming industry. Skills Acquired: Participants in the Mastering Unity 3D Intermediate Level Training Course will gain advanced proficiency in Unity 3D game development, including: Advanced 3D Game Development Techniques Real-time Physics and Animation Skills Multiplatform Game Deployment Expertise Job Opportunities: Upon completion, individuals can pursue roles such as: Game Developer Unity 3D Programmer AR/VR Developer Interactive Simulation Designer This course equips participants with the expertise required for exciting opportunities in game development studios, AR/VR companies, and interactive media agencies, setting the stage for a successful career in the gaming and simulation industry. Course Advantages: Comprehensive Unity Mastery: Develop expertise in various Unity aspects, including game design, scripting, animation, and optimization. Hands-On Project Experience: Engage in practical projects mirroring real-world game development, enhancing your skills and portfolio. Interactive Live Instruction: Learn from experienced instructors in real-time, encouraging interactive discussions, Q&A sessions, and personalized guidance. Flexible Learning Paths: Opt for in-person or online classes, ensuring accessible and convenient learning tailored to your needs. Lesson Revisions: Access recorded lessons, allowing flexible review and reinforcement of concepts at your own pace. Lifetime Email Support: Benefit from ongoing support via email, where experts are available to assist with any questions or challenges, even after the course concludes.

FORS Approved Virtual Reality Safe Urban Driving Training Registration will begin at 7:30 AM. The training will begin promptly at 8:00 AM. Please plan your arrival accordingly to ensure you don't miss any important information. Equip your drivers with the skills to navigate urban roads safely with our innovative VR training course. This DVSA-approved, 7-hour course utilises virtual reality to create a fully immersive learning experience. Drivers will gain a firsthand perspective of the challenges faced by vulnerable road users, such as cyclists, in a safe and controlled environment. Benefits: Immersive Learning: Develop empathy and understanding of vulnerable road users through VR simulations. Accessible & Risk-Free: Learn defensive driving techniques without the need for on-road cycling experience. Consistent Quality: Get a standardized training experience unlike unpredictable real-world scenarios. Course Content: The Changing Urban Landscape Sharing the Road with Vulnerable Users Defensive Driving Techniques Driver Attitude and Perception Impact of Driver Fitness on Safety Hazard Recognition for Vulnerable Road Users Compliance and Recognition: This course meets the requirements of: Work Related Road Risk (WRRR) FORS Silver Level CLOCS Standard Invest in your drivers' safety and the safety of vulnerable road users. Enroll today! Please review our Terms and Conditions for more information.

The perfect course for car care enthusiasts who have a passion for keeping their cherished vehicles in peak cosmetic condition safely and effectively, using tips and tricks to preserve and protect finishes, and who want to further their knowledge of detailing. Enthusiast Classic Car detailer training. The perfect course for classic car care enthusiasts who have a passion for keeping their vintage cherished vehicle in peak cosmetic condition, and who want to further their knowledge of detailing with a slant towards the classic end of the market. The course will guide the attendee through best practice processes of safe washing, decontamination, inspection, paint protection and preservation, mild paint correction, leather, plastics and vinyl care, and discuss/apply the various protection options on offer including paint type suitability. Course Details: • Assessment of vehicle exterior & interior inspection. • Cleaning, decontamination & preparatory work of the vehicle body: Washing processes, Pre-wash & snow foam, multi bucket methods, acids and alkalis, fallout removers and in-depth cleaning practices. Use of low water, less invasive wash methods and drying techniques • Cleaning, decontamination & preparatory work of alloy, steel and wire wheels. • Paintwork inspection using lighting techniques, depth gauges, and visual cues. Identifying paint types and areas of concern, and how to address them. • Engine bay cleaning and steaming, what chemicals can be used where, brightwork and mare metal care, what can you safely clean? • Practical overview of machine polisher ranges and their usage. • Practical overview of various polishing compounds and pad combinations. • Paintwork and Wheel protection options and application technique. • Glass cleansing and protection practical overview. • Detailing tips and tricks to give you the best results. You will have hands-on experience starting from the very beginning and working your way through all steps of a full enhancement detail, it will then be up to you to build on the knowledge you have gained by practising on your own vehicle, with ongoing support. The course is run from our fully equipped studio in the heart of Gloucestershire, with easy access to the M4/M5, and under an hour and a half to the M25. Course Length 1 Day (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

Stone Carving made a return to the Phoenix last year when we welcomed Mark Stonestreet to come teach us the joys of creating free-standing abstract sculpture. It was an absolutely fantastic course! This year Mark is coming back for more and this time we’re giving the students more stone to create with and more time – 5 days to be precise! The dusty nature of stone means that we will be working under a marquee set within the studio’s beautiful meadow – what better way to spend your summer – especially when none of us can go abroad? Outside of a global pandemic, Mark spends half the year creating sculpture in the South Downs and the other half in Mamallapuram in India – a village of over 200 stone carving workshops. His life is in stone and I liked him the instant we met. He is everything you would expect a stone carver to be – sturdy, weathered (meant in the nicest possible way, I promise Mark!) with a warm, no-nonsense personality that immediately puts you at ease. Our students are in safe hands working with him and I cannot wait to see what they will achieve this year! 23/08/2021 - 27/08/2021 10:00 am - 4:30 pm Location: The Phoenix Studio This fun course includes: Informal, relaxed & attentive guidance for every student, provided by Mark Stonestreet Step-by-step demonstrations covering… How to work with the tools and stone safely, How to create an abstract design that will look good and have structural integrity, How to transfer your design to the stone and carve into it efficiently to create the basic shape, How to add detail and refine the carved form, How to finish and present the form (looking at finishes, treatment, and mounting). This course is for you if: You want to realise drawings and 2D designs into 3D or have an introduction to visualizing your ideas in 3D You want to explore your creativity but lack the confidence to do so on your own You want to learn how to work safely and competently in stone You want to get away from it all and immerse yourself in a fun, creative environment Suitable for? Anyone, but please note that you will be using a chisel and mallet throughout the three days and this will take it’s toll on your arms and body. We generally limit the age to 16 years old+ though exceptions can be made where appropriate. Please contact James Orts and ask. What is included in the price? Five full days tuition (10 am-4.30 pm) Materials, including a piece of Portland stone (approximately 55cm x 25cm x 22cm), safety gear, and the tools you will need for when on the course You could consider making a simple printed course handout outlining the technique’s main principles and useful links/suppliers – Totally your choice though! Tea, coffee, biscuits/cakes Use of a beautiful, purpose-built art studio with all the equipment & materials you will need Beautiful countryside setting Pre-course prep It would be useful to gather, sketch out or think about what abstract shapes you are drawn to. Mark will be able to provide ideas as well and advise you on which of your ideas may work best so having some ideas to work from would be useful. You will be working outdoors so come prepared for the forecasted weather and all students must work in sturdy shoes. You will be sent an automated email on booking which prompts you towards documents that help you prepare for your time here. If this does not happen then please email James before the course.   Beyond The Course Having completed a Phoenix Studio course many of our students choose to explore the medium further. They may come on another weekend course, start coming to our Phoenix Art Club Sessions or our Creative Monday Sessions, or carry on independently at home. We are more than happy to help and advise you in taking those first creative steps! Need accommodation? If you are travelling from further afield and would like to stay in the area for your visit then have a look at our recommend B&Bs and hotels. Click here for the list.

This course meets the standards to become a mental health first aider. If you wish to become a mental health first aider, this is a great way to understand what it takes, get some practice in and how to really help someone in mental health crisis.

Introducing the Therapeutic Intervention Package: Guided Support for Positive Change and Emotional Healing Are you seeking professional guidance to overcome challenges, manage stress, and foster emotional well-being? Miss Date Doctor’s Therapeutic Intervention Package offers you a personalized and structured approach to address your concerns, providing you with expert insights and tools to facilitate positive change and emotional healing. Life can present us with various obstacles that impact our mental and emotional health. Our experienced therapists are dedicated to helping you navigate through these challenges, empowering you to make informed decisions and cultivate a healthier and more fulfilling life. Here’s how the Therapeutic Intervention Package can support you: Personalized Assessment: Our therapists will conduct a comprehensive assessment to understand your specific needs, goals, and areas of concern. Tailored Treatment Plan: We’ll work together to create a personalized treatment plan that addresses your unique challenges and supports your well-being. Evidence-Based Techniques: Therapeutic interventions will be rooted in evidence-based techniques to promote emotional healing and positive change. Skill Building: Our therapists will equip you with practical skills and coping strategies to navigate challenges and manage stress. Emotional Regulation: We’ll focus on helping you develop healthy emotional regulation techniques to manage intense feelings. Goal Achievement: Together with your therapist, you’ll set achievable goals and track your progress as you work towards positive change. Supportive Environment: The Therapeutic Intervention Package offers a safe and non-judgmental space for you to explore your thoughts and feelings. Empowerment and Growth: Our therapists are committed to empowering you to overcome obstacles, build resilience, and experience personal growth. The Therapeutic Intervention Package at Miss Date Doctor is designed to provide you with expert support and guidance on your journey to improved emotional well-being. Our experienced therapists offer insights, tools, and a compassionate space to help you navigate challenges and foster positive change. Invest in your mental and emotional health and take the first step towards positive transformation with the Therapeutic Intervention Package. Embrace the opportunity to gain insights, develop skills, and create lasting positive change in your life. Let our skilled therapists guide you towards a brighter and more empowered future. 3 sessions x1 hour https://relationshipsmdd.com/product/therapeutic-intervention-package/

Hydrodermabrasion Course *machine and other kit is not inlcuded. You will train using our equipment. What Is Hydrodermabrasion? This treatment is often mistaken for microdermabrasion, however, these two are different. Microdermabrasion is used to exfoliate your skin without any crystals, unlike microdermabrasion. The process is a lot more comfortable for your skin and is safe for sensitive skin as well. Course Content - History of Hydrodermabrasion - Anatomy and physiology - Contraindications - How to perform the treatment - Use of the machine - Aftercare 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 date once you sign up for the course. Will I require a model? Yes, usually 1 model is required 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

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling- Locator Operator