Ensure Workplace Safety and Compliance! Empower yourself and your colleagues with the skills to manage emergency situations effectively. Sign up today for our Full First Aid at Work course and become a vital first responder in your workplace.
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com
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
Why Choose Rhino 3D Basic to Intermediate Training Course? Course Link Learn NURBS modeling, curves, and 3D printing prep in our Rhino 3D Course. Master materials, textures, and lighting for 2D & 3D modeling. A basic understanding of Rhino is valuable for creative professionals pursuing careers in product, furniture, architectural, or jewelry design. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. Supported Learning Approach: Personalized Support: No matter the course duration, our team is dedicated to supporting you every step of the way. From homework assignments to video tutorials and free after-support, we ensure a supportive path to software expertise. One to One Course Advantage: The One-to-One Course Advantage offers personalized learning, flexible scheduling, focused feedback, and a private environment to boost confidence and achieve your specific objectives. Rhino 3D Basic to Intermediate Training Course Course Duration: 10 hours Course Description: 3D modeling journey with our Rhino 3D Basic to Intermediate Training Course. Ideal for beginners, master the powerful Rhino 3D software used by architects and designers. Explore the interface, create captivating 3D models, and enhance your designs with comprehensive tools and techniques. Course Outline: I. Introduction to Rhino 3D (1 hour) - Explore the Rhino 3D interface and discover essential tools for 3D modeling - Master seamless navigation and viewport controls - Grasp the significance of units and tolerance for precise creations - Customize your workspace for an efficient and personalized workflow II. Creating Basic 3D Objects (3 hours) - Unleash your creativity by crafting simple yet captivating 3D shapes - Gain expertise in editing objects and working with curves for refinement - Dive into the world of surfaces and solids, refining your skills - Effortlessly use transformations and copying techniques to enhance your designs III. Organizing and Enhancing Models (2 hours) - Streamline your projects with smart organization using groups and layers - Elevate the visual appeal of your models with vibrant colors, materials, and textures - Illuminate your creations with fundamental lighting techniques IV. Advanced Modeling Techniques (2 hours) - Master the art of tackling complex shapes with advanced modeling tools - Explore the nuances of creating and editing curves and surfaces - Enhance your proficiency in handling solids and understand Boolean operations and trimming techniques V. Introduction to Rendering (1 hour) - Gain an overview of rendering and its role in visualizing your designs - Understand Rhino's powerful render engine and its capabilities - Apply basic materials to elevate the quality of your renderings VI. Exporting and Importing (1 hour) - Acquire a comprehensive understanding of file formats for seamless sharing - Prepare your models for 3D printing using best practices - Integrate models from other software into Rhino 3D for a unified workflow VII. Conclusion and Next Steps (30 minutes) - Recapitulate the knowledge gained throughout the course - Access valuable tips and resources for continuous learning and growth - Engage in an interactive Q&A session to receive feedback and support Note: The above course outline is flexible, ensuring it meets the unique needs and skill levels of learners. Download - Rhino
Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities... Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 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 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. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office 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
Why Choose Rhino Introduction to Intermediate Training Course? Learn: 3D NURBS models. Master: Surfacing modeling. Interface: Rhino's navigation. Rendering Skills: Enhance presentations with Rhino renderings. Check our Website Flexible Scheduling: 1-on-1 training sessions according to your convenience. Choose any hour between 9 a.m. and 7 p.m., Mon to Sat. You can call us at 02077202581 to book over the phone. Duration: 10 hours. Methods: Personalized training either in-person, or live online. Introduction and Navigation Become acquainted with Rhino's interface, menus, and screen layout. Efficiently traverse through Rhino models, ensuring precision in 2D lines, polylines, and NURBS curves. Utilize modeling setup features, incorporating constraints like snap, ortho, and planar for accuracy. Leverage object snaps and Smart Track functionality to enhance precision. Solid and Surface Modeling Develop rapid 3D solids and surfaces, employing Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling, exploring 3D space and elevations. Create diverse shapes, such as rectangles, circles, arcs, ellipses, and polygon curves. Elevate models with Rhino render and render color, incorporating free-form curves, helix, and spiral curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transform curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions: move, copy, rotate, mirror, and scale. Create arrays with both polar and rectangular arrangements and employ boolean operations like union, difference, and intersection. Offset curves and surfaces effectively, ensuring meticulous detailing. Intermediate Edit and Surfacing Introduce key NURBS modeling concepts and terminologies. Edit curves and surfaces via control point manipulation and rebuild them for optimal refinement. Employ the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings, expertly crafting page layouts. Advanced Surfacing and Solid Modeling Construct model primitives and solid text, employing techniques such as pipe and extrusion. Modify solids efficiently using Boolean tools, expanding your surface modeling capabilities. Employ techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves, mastering surface network techniques for complex shapes. Upon completion, you will: Master Rhino Tools: Navigate interfaces, utilize advanced tools for precise modeling, and employ features like object snaps and Smart Track. Expert Solid and Surface Modeling: Develop intricate 3D solids and surfaces, create diverse shapes, and use Rhino render effectively. Advanced Editing Skills: Apply intermediate and advanced editing techniques, including symmetry tools and realistic rendering. Precision Modeling: Utilize coordinates, constraints, and advanced aids for accurate detailing and problem-solving. Professional Project Execution: Create high-quality renderings, 2D drawings, and polished 3D models for real-world design scenarios. Upon completion, you'll be adept at 3D modeling, product design, and architecture, positioning you as a valuable asset in the design industry. Why Choose Our Rhino Courses? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software, utilized extensively in domains like architecture, industrial design, and multimedia. Our Rhino courses are meticulously crafted to empower you in mastering this software. Led by seasoned instructors, our courses provide a comprehensive understanding of Rhino, enabling you to create exceptional designs. Rhino 3D Training: Our Rhino 3D training caters to beginners and those seeking advanced techniques. Course Highlights: Precise 3D Modeling: Master free-form 3D NURBS models with precision. Advanced Functionality: Explore Rhino's features, including advanced surfacing commands. User Interface Mastery: Navigate Rhino's interface and hone skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under expert guidance. Modeling Techniques: Learn free-form and precision modeling techniques. Modeling Aids: Utilize tools for accurate modeling and create basic Rhino renderings. Benefits of our Courses: Expert Guidance: Receive instruction from experienced architects and designers, providing practical, real-world insights for comprehensive learning. Comprehensive Resources: Access bespoke video tutorials for additional learning and reference, enhancing your understanding of the course materials. Digital Reference Material: Receive a digital reference book to support your revision efforts, providing a comprehensive resource for your studies. Ongoing Support: Enjoy free after-support through phone or email even after course completion, ensuring continuous assistance and guidance. Tailored Learning Experience: Customize your learning journey by adapting the syllabus and projects to align with your specific needs and interests, fostering a personalized educational experience. Certificate: Upon completion, earn a certificate from us, validating your achievement and recognizing your expertise in the field.
Why Choose Rhinoceros 3D Night Training Course? Learning Rhino 3D opens doors to advanced 3D modeling, making it essential for architects, designers, and engineers. Its versatility, ease of use, and powerful features make it an industry favorite for creating intricate designs, from architecture to product design. Click here for more info: Website Personalized Learning: 1-on-1 sessions tailored to your needs Flexible Timing: Convenient evening classes (5 pm - 7 pm) Mon to Sat Duration: 10 hours. Choose your own day and time Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Upon completing this course, you will: Master Rhino's Interface: Gain proficiency in Rhino's commands, toolbars, and menus, enabling efficient 3D modeling. Create Complex 3D Models: Develop the skills to create intricate 3D objects using curves, surfaces, and solids with various techniques like lofts, sweeps, and revolves. Refine Modeling Techniques: Learn advanced editing methods, such as filleting, chamfering, and curve Booleans, to refine and modify objects. Navigate the 3D Space: Understand 3D navigation, viewports, and construction planes, enabling precise modeling in a virtual space. Prepare Models for Production: Master techniques for analyzing and preparing 3D models for manufacturing, prototyping, and 3D printing. Enhance Rendering and Visualization: Learn rendering techniques to create realistic visuals of your models for presentations and proofs. Job Opportunities: After completing this course, you can pursue a variety of careers, including: 3D Modeler: Create detailed 3D models for industries like gaming, animation, or virtual reality. Product Designer: Design and visualize products for manufacturing using 3D modeling software. Architectural Visualization Specialist: Develop detailed architectural models for presentations and client approvals. Industrial Designer: Design consumer products, furniture, or appliances for manufacturing companies. Jewelry Designer: Craft intricate jewelry designs with precise detailing using 3D modeling techniques. Prototyping Specialist: Work in industries like aerospace or automotive, creating prototypes for testing and development. Freelance 3D Artist: Offer your skills on platforms like Upwork or Fiverr, creating custom 3D models for clients worldwide. Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Advantages: Personalized Rhino 3D Evening Training with individual attention. Flexibility to select your preferred time and day for the training. Access to free online support even after completing the course. Comprehensive PDF notes and handouts provided for effective learning. Receive a certificate upon completing the Rhino 3D Evening Training Course. Affordable pricing options tailored to your budget. Assistance in computer configuration for seamless software installation. Referral benefits: Recommend a friend and enjoy exclusive discounts. Special discounts available for group training sessions. Operating hours from Monday to Saturday, extending into the evening for convenience. Tailored training programs designed to meet your specific needs and requirements.
Discover practical ways you can help using the core skills and concepts of human givens therapy – early intervention and ‘treating the whole person’ can be crucial… Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) Excellent trainer, very engaging, invaluable insights and knowledge This new course for HG therapists builds on the online Understanding Eating Difficulties introductory webinar. It will deepen your understanding of working with clients experiencing eating difficulties and give you practical guidance on the most appropriate ways to support them, whether they have an official diagnosis or not. You will leave the workshop with a much better understanding of how to apply the skills and concepts encompassed in human givens therapy in this area. Jo Baker has a wealth of experience in this area; she has previously worked as a volunteer for BEAT and other local eating disorder charities and helped people with eating difficulties in both private practice and university settings. NEXT DATE: This course is part of our new range of recommended CPD for HG therapists. We don’t currently have another date for it, if you are interested in attending please register here so we can let you know when one becomes available. Why take this course The numbers of people experiencing eating difficulties are hitting an all time high – in the UK, 1.25 million people are estimated to have a diagnosable eating disorder¹ with hospital admissions more than doubling from 10,318 to 22,000 in the four years between 2016 and 2020². The early stages (or ‘subthreshold’ stages i.e. when symptoms do not meet full diagnostic criteria for an eating disorder as defined by the DSM-5 or the ICD-11) have been identified as a critical period for preventing progression of an eating disorder³. However, stigma directed towards those experiencing eating difficulties that aren’t believed to be ‘serious enough’ to warrant support⁴ can present a barrier to seeking help. With its deliberate use of non-clinical language Jo Baker’s new workshop for HG therapists considers all difficulties around eating worthy of help, understanding and support, irrespective of whether or not these difficulties have been diagnosed or meet the criteria for a diagnosable eating disorder. In this regard, the human givens approach takes a step forward towards early intervention, and treating the whole person. As well as having been a practising Human Givens therapist for 12 years, and teaching the HG Diploma, Jo has previously worked as a volunteer for BEAT and other local eating disorder charities and brings to the day a wealth of practical experience of working with eating difficulties both in private practice and in university settings. What will you learn The nuance of language – how to avoid causing unintentional distress The causes of most eating disorders and difficulties Creating space for the client’s story How to help your client identify and challenge destructive thought processes Therapeutic tools to get to the root of the problem – we look at which techniques can be useful, and what to be careful of The barriers created by clinical language and diagnostic criteria Diversity in eating difficulties – a greater understanding of the impact of cultural and contextual factors around eating How to help your client meet their needs and use their resources in a healthy way Eating difficulties and neurodiversity An increased awareness of complicating conditions – such as alcohol / substance abuse and medical conditions The important role of sleep in recovery Accessing resources and helping the individual to develop a nurturing self Ethical practice Understanding the boundaries of your role and your own limitations And more… Course Programme The ‘The Mind-Body Connection in depth: Movement, Emotion and Calm’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Eating difficulties: an overview 11.00am Discussion over tea/coffee 11.30am Understanding and resolving difficulties 1.00pm Lunch (included) 1.45pm Group discussion – questions from the day so far 3.00pm Discussion over tea/coffee 3.15pm Bringing it all together 4.00pm Day ends Who is this course suitable for? This course is for experienced, qualified HG therapists and counsellors who would like to understand more about eating difficulties, eating disorders and the different ways they can affect people. It is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. The course combines trainer input, discussion and small group activities. All training is limited by time constraints and whilst we have done our utmost to include a diversity of perspectives there will inevitably be topics that have not been covered. This course is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
Interior design tutor one to one open 7 days 9 am to 9 pm