1134 Courses in Cardiff delivered Live Online

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 Certificates Certificates Certificate of completion Digital certificate - Included

Duration 4 Days 24 CPD hours This course is intended for This course is designed for network administrators, system administrators, network architects, systems engineers, and technical support engineers who are involved with advanced installation, configuration, maintenance, and basic troubleshooting of Ruckus ICX products. Overview Upon successful completion of this course, the student will be able to: Describe Ruckus ICX hardware Configure and implement management protocols on Ruckus equipment Configure and implement monitoring and reporting features on Ruckus equipment including syslogs and sFlow Perform hardware troubleshooting and support functions Perform firmware upgrades Configure, implement, and maintain Layer 2 STP protocols (RSTP, MSTP, PVST) Configure and manage VLANs, Virtual Ethernet routed interfaces, topology groups, and Q-in-Q Configure, deploy and maintain Link Aggregation Groups (LAGS) Describe, configure, and maintain Multi-Chassis Trunking (MCT) Integrate MCT with VRRPe for redundancy Identify PoE-capable products Configure and manage Ruckus ICX switches in a PoE environment Configure, implement, and maintain the OSPF routing protocol Configure, implement, and maintain QoS This course provides an in-depth study of the Ruckus ICX family of products and how they are utilized in an enterprise network. The course covers core competencies of configuration, operations and maintenance of Ruckus ICX products. This course also covers core L2/L3 protocol configurations including STP family, OSPF, QoS, and Ruckus proprietary protocols and technology including MCT, VRRPe and FDP. This course provides an in-depth study of the Ruckus ICX family of products and how they are utilized in an enterprise network. The course covers core competencies of configuration, operations and maintenance of Ruckus ICX products. This course also covers core L2/L3 protocol configurations including STP family, OSPF, QoS, and Ruckus proprietary protocols and technology including MCT, VRRPe and FDP. Additional course details: Nexus Humans Ruckus ICX 200 Administrator Training Course training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Ruckus ICX 200 Administrator Training Course course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Managing meetings, Meeting Management, Efficient Meetings, Moccasin Approach, Moccasin Manager,

Training duration: 10 hrs. Click here for more info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Learn Arnold for 3ds Max and make breath-taking renders with our comprehensive training course. Led by certified tutors and industry experts, you'll master the basics to advanced techniques of creating stunning visual effects and lifelike renderings. Course Duration: 10 hours Course Outline: Session 1: Introduction to Arnold Renderer (1 hour) Unveiling Arnold Renderer's features and capabilities Understanding the benefits of Arnold in 3ds Max Setting up Arnold renderer and exploring its interface Mastering the workflow for exceptional results Session 2: Basic Arnold Shading (1 hour) Navigating the Arnold shading network Creating essential materials with Arnold shaders Working with diverse shader types (standard, Lambert, etc.) Elevating visuals with maps and textures in Arnold's materials Session 3: Arnold Lighting Techniques (1.5 hours) Embracing the art of lighting with Arnold Lights Implementing various light types (area lights, spotlights, etc.) Creating ambiance with Arnold skydome and environment lighting Illuminating scenes using physical sky and image-based lighting Session 4: Arnold Cameras and Rendering Settings (1.5 hours) Mastering Arnold cameras and their settings Achieving depth of field and motion blur effects in Arnold Configuring optimal rendering settings for superior results Fine-tuning rendering with the Arnold Render Setup dialog Session 5: Advanced Arnold Shading (1.5 hours) Creating intricate materials with advanced Arnold shaders Realistic surfaces with Arnold's procedural textures Harnessing the power of advanced shading nodes (bump, displacement, etc.) Unleashing specialized effects with Arnold shaders (subsurface scattering, hair, etc.) Session 6: Arnold Rendering Optimization (1 hour) Streamlining rendering settings for enhanced efficiency Leveraging Arnold features like adaptive sampling and denoising Noise reduction techniques for smoother Arnold renders Troubleshooting common rendering issues and their solutions Session 7: Advanced Lighting Techniques (1 hour) Crafting lifelike lighting setups with Arnold's prowess Exploring advanced lighting properties (exposure, color temperature, etc.) Enhancing lighting with Arnold light filters and modifiers Implementing captivating effects like volumetric lighting and caustics Session 8: Arnold AOVs and Compositing (1 hour) Understanding Arnold AOVs (Arbitrary Output Variables) Configuring and rendering AOVs for post-production control Compositing AOVs for artistic adjustments in post-production Leveraging AOVs for fine-tuning the final image Session 9: Arnold for Animation and Motion Graphics (1 hour) Integrating Arnold seamlessly into animation and motion graphics projects Rendering animation sequences with finesse Managing motion blur and time-based effects with Arnold Unveiling Arnold's potential for particle rendering and dynamic effects Session 10: Arnold Tips, Tricks, and Best Practices (1 hour) Exploring advanced techniques and workflows for exceptional results Optimizing scene setup for enhanced rendering performance Troubleshooting tips for common issues and errors in Arnold Q&A session and final review to consolidate knowledge

Why choose Vectorworks Evening Training Course? Course Link. This course led by certified expert, this course offers flexibility for evening learning. Choose in-person or live online sessions to master Vectorworks in architecture, interior design, and landscaping. Enroll now even after business hours! Duration: 10 hrs. Method: 1-on-1, Personalized attention. 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 Vectorworks course provides comprehensive training in computer-aided design (CAD) and Building Information Modeling (BIM) using the powerful Vectorworks software. This hands-on, instructor-led course covers 2D drafting, technical drawing, and 3D modeling, enabling participants to apply Vectorworks effectively in real-world projects. Key Features: Hands-on, instructor-led classroom training. Practical Vectorworks CAD projects for real-world application. Part-time evening or weekend options available. 1-2-1 Private learning experience. Module 1: Grasping CAD and Vectorworks Understanding the Role of CAD in Design Getting Acquainted with Vectorworks Software Module 2: Configuring Your Workspace Customizing Your Workspace Essential Options and Preferences Module 3: Mastering Foundational Drawing Skills Techniques for Drawing Object Selection Methods Module 4: Advanced Object Manipulation Merging Shapes Reflecting Objects Rotating Objects Grouping Elements Module 5: Precision Drawing and Scaling Techniques Working with Scale Setting Preferences for Accuracy Creating and Saving Templates Module 6: Achieving Accurate Object Placement Ensuring Drawing Precision Precise Object Movement Module 7: Advanced Editing Methods Utilizing Fillet Tool Applying Offset Function Module 8: Understanding Object Attributes and Groups Basic Attribute Management Editing Object Groups Module 9: Object Duplication Techniques Linear Duplicates Rectangular Duplicates Circular Duplicates Module 10: Crafting Room Plans Designing Walls Incorporating Windows and Doors Module 11: Development of Room Plans Methods for Room Plan Drawing Module 12: Exploring Additional Attributes Hatch Patterns Gradients Image Fills Module 13: Creating Elevation Drawings Elevation Drawing Techniques Effective Approaches Module 14: Importing Images for Graphic Use Graphic Illustration Integrating Images Module 15: Symbols and Resource Handling Symbol Creation Introduction to Resource Browser Module 16: Organizing Drawings Using Design Layers Optimizing Design Layer Utilization Module 17: Labeling Drawings and Title Blocks Drawing Labels Title Block Text Placement Module 18: Plotting and Printing Methods User Interface Navigation and Terminology Printing Approaches Module 19: Generating Drawing Sheets A1, A2, and A3 Sheet Formats Module 20: Utilizing Viewports Effectively Managing Multiple Views Module 21: Professional Model Presentation Techniques Paper Space Presentation Conversion to PDF Formats Module 22: File and Project Management Module 23: Object Display and Terminology Module 24: Objects and Data Management Module 25: Precise Object Placement Object Snapping Quick Selection Module 26: Dividing and Measuring Objects Module 27: Dimensioning and Annotations Module 28: Working with Text Elements Module 29: Customizing Tool Palettes Module 30: Organizing Tool Palettes Module 31: Efficient Tool Palette Usage Module 32: Standard Views and Drawing Techniques Module 33: Drawing Curved Shapes Arcs, Donuts, and Ellipses Drawing Module 34: Real-World Units and Measurements Module 35: Object Manipulation Adjusting Object Angles Module 36: File Handling and Management Saving, Exiting, and Opening Projects Module 37: Creating Mirrored Images Module 38: Introduction to 3D Modeling By the end of the Vectorworks Evening Training Course, participants will: Demonstrate proficiency in using the Vectorworks interface, tools, and navigation. Create and edit 2D drawings, including walls, doors, windows, floors, ceilings, stairs, and railings. Effectively manage layers, classes, and views for organized and controlled object placement. Create and edit dimensions and annotations for accurate measurements and documentation. Develop skills in creating, modifying, and utilizing symbols for increased efficiency. Generate and edit 3D geometry, apply textures, and create sections and elevations from 3D models. Create polished presentation drawings using viewports, annotations, and text for clarity. Summarize course content and confidently apply learned skills in Vectorworks projects. Utilize available resources for further learning and professional development.

High Performing Teams. Moccasin Approach, Moccasin Manager,

The Moccasin Manager, The Moccasin Approach, Management Training, Management Development,

Our Innovator Founder Training Course is an essential program designed to provide you with valuable insights into the new Innovator Founder visa. This visa route, which replaced the Innovator visa, offers individuals the opportunity to establish a business in the UK based on their innovative, viable, and scalable business idea. View the Innovator Founder Training course dates below, delivered via Microsoft Teams. Innovator Founder Our Innovator Founder Training Course is an essential program designed to provide you with valuable insights into the new Innovator Founder visa. This visa route, which replaced the Innovator visa, offers individuals the opportunity to establish a business in the UK based on their innovative, viable, and scalable business idea. During the course, we will guide you through the key changes introduced by the Innovator Founder route, including the removal of the minimum funds requirement and the ability to engage in secondary employment. We will also explore the importance of regular contact point meetings with the endorsing body to assess progress and provide ongoing support. This course will cover the endorsement requirement, emphasizing the need for a comprehensive endorsement letter from an approved Endorsing Body or Legacy Endorsing Body. You will gain a deep understanding of the criteria that the endorsing body considers when assessing your fit as an Innovator Founder, ensuring you meet the necessary standards for endorsement. Our course will provide valuable guidance on the period and conditions of leave granted under the Innovator Founder route, as well as the settlement requirements and eligibility criteria. This is not to be missed by lawyers, solicitors, immigration advisors, entrepreneurs and business owners. Course joining links, materials and instructions are sent out 24hours before the course starts. Why choose IAS' Immigration Training Courses? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our fully qualified and OISC regulated trainer will guide you through the content in our comprehensive training course. See why others like to study with IAS: Delivered Online Expert Course Trainer Free Course Materials Certificate of Attendance   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course.   How is this course structured? The “Innovator Founder” training workshop will involve the following: Introduction to the Innovator Founder visa Endorsement requirements Business plan requirements Innovative, viable, and scalable business requirements Same business requirements English Language and Financial Requirement Period and conditions of grants Settlement requirements Dependants of an Innovator Founder

Why Learn Adobe Illustrator Basic to Intermediate Training Course? Course Link With our Illustrator Intermediate Course take your vector graphics to the next level and bring your designs to life with advanced techniques and tools. Gain hands-on skills in creating shapes, patterns, and logos, and learn how to edit images with precision. Duration: 6 hrs. Method: 1-on-1 - Personalized attention Schedule: Schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This course covers fundamental tools and features of Adobe Illustrator, aimed at beginners, to enable them to create and edit vector graphics efficiently and effectively. Adobe Illustrator is the industry-leading vector graphic software for working with vector graphics, providing a comprehensive set of tools for producing exceptional graphics for various media, including print, video, web, and mobile devices. Course Title: Adobe Illustrator  Course Outline: Mastering Advanced Drawing Techniques  In-Depth Curvature Tool Mastery Advanced Pen Tool Usage: Drawing Complex Paths Understanding Path, Anchor Points, and Handles Precision Editing with Direct Selection Tool Slicing and Dividing Paths using Scissors and Knife Tools Exploring Advanced Stroke and Path Options  Custom Width Profiles with the Width Tool Diverse Brushes Exploration in Brush Library Creating Scattered Objects with Scatter Brushes Applying Patterns along Paths with Pattern Brushes Crafting Custom Pattern Brushes Understanding Graphic Styles  Efficient Usage of Graphic Style Libraries Creating, Deleting, and Saving Graphic Styles with Graphic Style Panel Leveraging the Power of Graphic Styles Mastering Pattern Manipulation Techniques  Creating and Editing Patterns using Pattern Mode Modifying Pattern Elements with Precision Adjusting Spacing and Resizing Patterns using the Tile Tool Rectifying Background Errors with Overlap Options Saving and Exporting Custom Patterns Exploring Advanced Gradient Options  Gradient Styles Exploration Fine-Tuning Gradients with the Gradient Annotator Creating Free Transform Gradient Points and Lines Applying Single Gradient across Multiple Objects Gradient and Transparency Integration Creative Applications and Practical Projects  Applying Advanced Techniques to Real-World Projects Creative Problem-Solving Strategies Q&A Session and Feedback Gathering Note: Each section includes practical exercises and hands-on projects to reinforce learning. The course emphasizes practical application, ensuring participants leave with tangible skills and a deep understanding of advanced Adobe Illustrator concepts. Q: What will I learn in the London Design Training Course in Adobe Illustrator? A: In this course, you'll learn essential techniques for creating and editing vector graphics using Adobe Illustrator. The training covers drawing tools, shapes, layers, effects, styles, logo design, Image Trace, Live Paint, and integration into your design workflow. Q: What can I expect to achieve after completing the Illustrator training course? A: By the end of the course, you'll be proficient in Illustrator tools, create graphics for print, web, and mobile, design logos with special effects, and manipulate images. You'll receive an accredited Illustrator training certification and post-course support. Q: Is any prior knowledge of Illustrator required to attend the course? A: No, the course is designed for beginners, and no prior knowledge of Illustrator is necessary. Q: Which version of Illustrator will the training be based on? A: The training is primarily based on Illustrator 2023, but the techniques apply to recent releases. Q: Can I attend the course on either a Windows or Mac computer? A: Yes, Illustrator works identically on both Windows and Mac. Our training centers offer both platforms for your convenience.

Foundation • Advanced • Masterclass 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases.  Additional information ATTENDANCE ONLINE (theory), IN-CLINIC (Practice) COURSE LEVEL BEGINNER | Foundation Course, INTERMEDIATE | Advanced Course, EXPERT | Masterclass Course