1071 Courses in Nottingham 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 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

Course Description: 3ds Max Evening Training Course. Training duration: 10 hrs 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. Course Link Unleash the art of character animation with our 3ds Max training course. Perfect for beginners and seasoned artists alike. Benefit from certified tutors and industry experts as your mentors. Opt for in-person or live online sessions with flexible scheduling. Access recorded lessons and lifetime email support. Receive a Certificate of Attendance and a practical training guide. Enjoy hands-on instruction and personalized attention. Ideal for architects, interior designers, game designers, and more. Enroll today and unlock your animation potential with 3ds Max. Try it out for free using the link provided. Module 1: Introduction to 3ds Max (1 hour) Overview of 3ds Max and its applications in various industries Interface tour and navigation controls Working with objects, creating basic shapes, and transformations Understanding the viewport and workspace customization Module 2: Modeling in 3ds Max (2 hours) Polygon modeling techniques Working with modifiers for efficient modeling Creating complex shapes using subdivision surfaces Using splines and lofting for advanced modeling Introduction to NURBS modeling Module 3: Texturing and Materials (2 hours) UVW unwrapping and mapping techniques Applying textures and materials to objects Utilizing the Material Editor and material libraries Creating realistic materials using maps and procedural textures Introduction to PBR materials and material workflows Module 4: Lighting and Cameras (1.5 hours) Types of lights and their properties in 3ds Max Setting up basic and advanced lighting scenarios Working with natural and artificial lighting techniques Introduction to photometric lighting and IES profiles Camera settings and composition for better renders Module 5: Animation and Rigging (1.5 hours) Understanding keyframes and animation controllers Creating simple animations and motion paths Introduction to character rigging and bone systems Basic animation principles and timing Animating objects and cameras for visual storytelling Module 6: Rendering and Output (1.5 hours) Overview of the rendering process in 3ds Max Render settings and output formats Working with render elements for post-processing Introduction to V-Ray rendering (or other popular render engines) Final render setup and optimization techniques Module 7: Particle Systems and Dynamics (1 hour) Introduction to particle systems and particle flow Simulating dynamics and physics in 3ds Max Working with particle operators and events Creating realistic effects like smoke, fire, and water Module 8: Advanced Techniques and Plugins (1 hour) Exploring advanced tools and workflows in 3ds Max Overview of popular plugins and their functionalities Integration with other software and formats (e.g., Adobe Photoshop, CAD software) Utilizing scripts and automation for workflow optimization Downlaod 3ds max for free

Why Learn SketchUp Evening Training Course? You will learn how to create and edit 3D models to a professional standard, ensuring you leave with the skills and confidence to fully take advantage of SketchUp and Layout software. You can book this course after work we are open 9 am to 7 pm. Course info 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. SketchUp Evening Training Course Course Duration: 10 hours I. Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Familiarization with the user interface and essential tools - Mastering navigation and viewport controls - Efficiently creating and managing interior design and architectural projects II. Creating Floor Plans (1 hour) - Importing floor plans and site plans for reference - Precision in drawing walls, windows, and doors - Effective management of floor levels - Organizing designs using Layers and Scenes III. Adding Furniture and Fixtures (2 hours) - Accessing and importing furniture and fixtures from the extensive 3D Warehouse - Crafting custom furniture and fixtures to suit specific design needs - Strategically placing and arranging elements within the space - Crafting and customizing materials to achieve the desired visual impact IV. Advanced Modeling Techniques (2 hours) - Employing advanced tools for creating intricate 3D models - Enhancing model organization using groups and components - Adding exquisite details and finishes to elevate design quality V. Layout for Construction Documents (2 hours) - Creating construction documents in Layout for clear communication - Seamlessly importing SketchUp models into Layout - Crafting detailed floor plans, elevations, and sections - Adding annotations and dimensions to facilitate construction VI. Introduction to Vray (1 hour) - Understanding the capabilities of Vray for SketchUp - Familiarization with the basic Vray interface and tools - Exploring Vray materials and textures for enhanced rendering VII. Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to elevate SketchUp models - Creating artificial and natural lighting for realistic visualizations - Enhancing designs with entourage and landscaping elements VIII. Importing and Exporting (30 minutes) - Seamlessly importing and exporting files for versatile workflows - Ensuring file format compatibility with other software - Preparing models for 3D printing as required IX. Conclusion and Next Steps (30 minutes) - Comprehensive review of course content and key takeaways - Suggested further learning resources and avenues for improvement - Interactive Q&A session and feedback collection Download SketchUp | Free Trial of 3D Modeling Software SketchUp https://www.sketchup.com SketchUp's Intuitive Interface Helps You Communicate Ideas In 3D Fast. Subscribe Today!

The essential course for anyone who wants to find out about the EFQM Model and RADAR and how these tools can benefit their organisation. The New EFQM Model was launched at the EFQM Forum in October 2019 and, as EFQM's country partner for Ireland, CforC is providing Foundation Training on the new model. Whilst this training is effective as a stand-alone course, it is also the starting point for all EFQM qualification routes. Who is it for? This course is suitable for anyone who wants to understand the new EFQM Model and how it can be used to make their organisation more effective. It provides a good overview for consultants who want to add the Model/RADAR to their portfolio of products and services. It is also a pre-requisite for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career. Pre-requisites for this course None Benefits By the end of the course, participants will be able to: explain how the EFQM Model could benefit their organisation and how it could be used to overcome current and future challenges explain how the Model is structured and how the different elements apply to their organisation apply RADAR, the diagnostic and assessment tool, to identify strengths and areas for improvement conduct a high-level health check of their organisation The training comprises 8 modules; Module 1 The Changing World Module 2 The Organisation’s Ecosystem Module 3 The Value of a Model Module 4 The EFQM Model Module 5 RADAR Module 6 Using the EFQM Model and RADAR Module 7 The EFQM’s Digital Platform Module 8 Next Steps Delivery The course is delivered through a virtual trainer led live class Cost £450 + VAT which includes the training course, the EFQM Model e-book and your EFQM Foundation Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on delivering the best customer care.

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on telephone etiquettes, communication and behaviours.

Why Learn Adobe InDesign Advanced Training Course? Master Adobe InDesign for efficient page layouts with our advanced course. Learn document setup, text formatting, and special effects. Suitable for beginners and advanced users. London Design Training Course provides top InDesign course with Adobe Certified Instructors. Course Link 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 Flexible Learning Options: Choose between in-class training at our London center or participate online. Both options provide hands-on, practical learning with step-by-step demonstrations and ample opportunities for questions. Introduction to InDesign: Exploring InDesign Basics Customizing Preferences and Workspace Navigating Panels and Windows Setting Up Toolbar and Properties Panel Document Management: New Document, Pages, and Order Quick Navigation Techniques with Shortcuts Smart Layout: Organizing Layouts with Guides and Grids Understanding Bleed, Slug, and Margins Utilizing Smart Guides for Precision Typography: Mastering the Type Tool Adding Text to Pages and Using Placeholder Text Text Formatting with Character and Paragraph Controls Editing Text Frames and Justifying Text Multi-column Setup and Styling with Character/Paragraph Styles Working with Bullet Points and Numbering Working with Images: Creating Frames and Placing Images Content Fitting Options: Proportional Fit, Content-Aware Fit, Auto-Fit Manipulating Frame Properties: Fill, Stroke, Effects Utilizing Object Styles for Consistent Frames Advanced Techniques: Image Frame Grids, Merging Frames, Text Wrap Options Understanding Image Formats and Resolution Tabs and Alignment: Mastering Tab Palette and Alignment Options Adding Leaders for Enhanced Formatting Color Theory and Editing: Basics of Color Theory and Color Modes Creating Color Themes with the Color Theme Tool Swatches, Color Libraries, and Gradients Editing Gradient Fills and Colors Advanced Interactive Actions: Adding Animation Effects with Animation Panel Fine-tuning Animations with Timing Panel Creating Complex Object States and Action Buttons Adding and Testing Hyperlinks, Page Transitions Parent Page Basics: Understanding Parent Pages Page Numbering, Order, Headers, and Footers Inserting Text Variables for Dynamic Content Advanced Object Styles and Effects: Opacity Control and Blending Modes Black and White Conversion, Color Blending Modes Adding Dimension with Bevel and Emboss Effects Advanced Text Frame Options: Auto-sizing Text Frames and Balancing Column Height Inset Spacing and Fill Colors for Text Boxes Hot Corner Resizing Shortcuts and Anchor Objects Footnotes: Purpose and Usage of Footnotes Adding, Editing Footnotes with Footnote Options By the end of this Adobe InDesign training, participants will: Understand InDesign basics and its interface. Create effective page layouts with text formatting and image placement. Work with layers, apply special effects, and manage tables. Ensure error-free and print-ready documents through preflighting. Receive a practical training guide and an e-certificate upon completion.

Why Choose 3ds Max and Vray Training Course? Click here for more info 3ds Max a valuable tool for architectural modeling, product design, and manufacturing across numerous industries. While widely utilized, mastering the software requires effort. Engaging in 3ds Max tutorials proves particularly advantageous for game designers, aiding in their career advancement. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm Our 3ds Max course consists of two main sections, covering architectural visualizations for both interior and exterior scenes. By the end of the training, you'll have the expertise to create professional projects independently. We begin with fundamental and advanced 3D modeling, starting from simple objects and progressing to complex buildings, interiors, and products. 3ds Max and Vray Comprehensive Course Course Duration: 10 hours Course Overview: This course is designed to offer a comprehensive introduction to 3ds Max and Vray. Throughout this program, you will acquire the knowledge necessary to proficiently create 3D models, apply materials and textures, configure lighting and camera systems, and produce high-quality Vray renders. This course is suitable for individuals with various levels of experience, from beginners to those with some prior exposure to 3D modeling and rendering. Course Outline: Module 1: Introduction to 3ds Max and Vray Familiarization with the 3ds Max interface Configuring the workspace Navigating within 3ds Max Introduction to Vray and its user interface Module 2: 3D Modeling Creating fundamental shapes Employing modifiers Crafting intricate shapes through advanced 3D modeling techniques Grasping the fundamentals of polygonal modeling Crafting both organic and inorganic models Module 3: Materials and Textures Application and modification of textures Understanding UVW mapping Utilizing the material editor Developing custom materials Leveraging Vray materials Module 4: Lighting Introduction to various lighting techniques Exploring different types of lights Comprehending light properties Configuring lights for a scene Employing Vray lights Module 5: Cameras Familiarization with camera systems Understanding camera properties Setting up camera views Creating animations using cameras Utilizing Vray cameras Module 6: Rendering Introduction to rendering Exploring Vray Global Illumination Utilizing Vray Physical Cameras Harnessing Vray HDRI Lighting Implementing the Vray Rendering Workflow Module 7: Projects Integrating all acquired knowledge Crafting a simple interior scene Constructing a basic exterior scene Developing a complex scene featuring multiple objects and materials Course Requirements: To participate in this course, you will need: A computer with 3ds Max and Vray installed (trial versions can be obtained from Autodesk and Chaos Group websites) Basic computer operation skills An interest in 3D modeling and animation Course Goals: Upon completing this course, you will have gained a comprehensive understanding of 3ds Max and Vray. You will possess the skills required to create realistic and visually captivating 3D scenes using Vray. Furthermore, you will be well-equipped to continue honing your 3D modeling and rendering abilities. Resources: Vray Trial Download: https://www.chaosgroup.com/vray/sketchup/free-trial Materials:https://www.vray-materials.de/ Textures: https://textures.com/ By completing the 3ds Max and Vray Training Course, participants will acquire proficiency in 3D modeling and rendering using 3ds Max. They will establish a solid foundation and essential skills, enabling them to create captivating visualizations. This expertise opens doors to various job opportunities in fields such as architectural visualization, game design, film production, and product modeling.

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.

Emotional Intelligence Training