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

Who is this course for? Beginner to Intermediate 3ds Max Training Program. Learn 3D modeling with our in-depth 3ds Max training program. Beginners to intermediate learners, this course is led by certified instructors and industry professionals. Learn 3D modeling, animation, and visualization. In-person or live online sessions. Click here for more info: Website Duration: 20 hours Method: 1-on-1 Personalized Attention. Schedule: Design your own schedule, hours of your choice, offered Mon to Sat from 9 am to 7 pm. 3ds Max and Vray Basic to Intermediate Training Course - 20 Hours Course Outline: Module 1: Introduction to 3ds Max (2 hours) Familiarizing with the 3ds Max interface and navigation Understanding the workspace setup for efficient workflow Mastering object creation, modification, and manipulation Exploring the basics of scene organization and management Module 2: 3D Modeling in 3ds Max (4 hours) Creating primitive and complex shapes using standard tools Utilizing modifiers for advanced modeling techniques Mastering spline modeling for precision and creativity Combining multiple objects for seamless compositions Module 3: Texture Mapping and Material Creation (4 hours) Understanding UVW mapping and texture coordinates Applying materials and shaders for realistic surfaces Utilizing Vray materials for enhanced visual effects Customizing materials for unique and captivating designs Module 4: Lighting and Rendering with Vray (4 hours) Implementing Vray lights for various lighting setups Exploring Vray's global illumination for realism Configuring render settings for high-quality output Fine-tuning the rendering process for efficiency and speed Module 5: Animation and Camera Techniques (4 hours) Setting up animation keyframes for dynamic motion Utilizing cameras for captivating viewpoints and perspectives Creating smooth camera animations and walkthroughs Incorporating animated objects to bring scenes to life Module 6: Scene Optimization and Advanced Features (2 hours) Streamlining scene organization for better workflow Leveraging Vray proxies for optimized performance Exploring advanced Vray features for stunning effects Using Vray render elements for post-processing control Module 7: Project Work and Review (2 hours) Applying the learned skills in hands-on projects Reviewing and refining the projects with instructor guidance Consolidating knowledge and addressing any remaining queries Course Requirements: A computer with 3ds Max and Vray installed (trial versions available on Autodesk and Chaos Group websites) Basic familiarity with 3D modeling concepts is beneficial but not mandatory Enthusiasm for learning 3ds Max and Vray to create impressive 3D models, visualizations, and animations By the end of the 3ds Max and Vray Basic to Intermediate Training Course, participants will be able to: Navigate and utilize the 3ds Max interface with ease for efficient 3D modeling and scene management. Create a variety of 3D models using different techniques, including primitive shapes, modifiers, and spline modeling. Apply textures and materials to their models, utilizing Vray materials for enhanced visual effects. Set up lighting and render scenes using Vray, understanding global illumination for realistic renders. Animate objects and cameras, producing dynamic and engaging animations within their 3D scenes. Optimize scenes and use advanced Vray features, like proxies and render elements, for improved performance and post-processing control. Apply the learned skills to hands-on projects, gaining practical experience in creating captivating 3D models and animations. Review and refine their projects, receiving instructor guidance and feedback to enhance their work. Gain confidence in using 3ds Max and Vray, allowing them to continue exploring and advancing their 3D modeling and rendering skills independently. Showcase their newfound abilities through an impressive portfolio of 3D models and animations, ready to take on new creative challenges in various industries. Skills Acquired: Mastering Fundamental 3D Modeling Techniques in 3ds Max Developing Texturing and Material Application Skills Understanding Lighting and Rendering Fundamentals Grasping Animation Basics and Keyframe Animation Gaining Proficiency in Scene Composition and Camera Setup Career Opportunities: Entry-Level 3D Modeler Junior 3D Animator Texturing and Lighting Assistant CAD Designer in Architectural Firms Product Visualization Artist in Marketing Agencies Upon completing our 3ds Max Beginner Course, students will acquire foundational 3D modeling and animation skills, opening doors to entry-level positions in various industries, including animation studios, architectural firms, and marketing agencies. Personalized Guidance: Expert trainers cater to your unique learning needs through tailored one-on-one coaching. Hands-On Learning: Engage in practical demonstrations, reinforcing skills applicable to industries like design, gaming, and film. Comprehensive Resources: Access a Certificate of Attendance and detailed training guides for continuous reference. Interactive Sessions: Interact live with tutors, receiving valuable feedback and access to recorded sessions. Flexible Options: Choose between online or in-person sessions, fitting your schedule and preferences. Value and Support: Enjoy competitive rates, discounts for referrals, and lifetime assistance via email and phone. Smooth Start: Receive assistance with software installation, ensuring a seamless learning experience.

Nail art designs are becoming more and more popular and is an opportunity for you to provide an additional profitable service to your clients. This course serves as an introduction and will provide you with the sufficient skills and knowledge to start to offer this service. THE REQUIREMENTS No experience required. Salon wear must be worn with long hair tied back. THE CONTENT Health & Safety Client consultation Contra-indications Equipment and brushes Preparation Nail painting Nail art techniques (nail colour art, transfer foil, stamps, sparkle, etc.) After care DURATION This is a one-day course which runs from 10am to 4:30pm. PRICE INCLUDES  A certificate of attendance. All products are provided for the duration of the course.

Aimed at owners & potential owners wanting to learn more about the vehicle they drive and how to look after it.   INTRODUCTION TO AIRCOOLED Vehicles   Workshop objective: To give you the knowledge and confidence to successfully look after your aircooled vehicle. Workshop Contents: Morning How an air-cooled engine works How to get the best out of your engine What can go wrong and how to prevent them from happening Key things you need to know about an MOT Key things on keeping you, your passengers safe. After Lunch (Hands On) How to maintain your aircooled vehicle Adjusting points, timing and valve clearances Changing Oil & Strainer Changing Spark Plugs Changing the fan belt Carrying spares to help breakdown services getting you back home safely Further reading and learning more

PRINCE2® Foundation and Practitioner are process-based project management approaches that can be easily customised and scaled. PRINCE2® Foundation and Practitioner course aim to provide delegates with a comprehensive knowledge of project management methodologies. Course Overview PRINCE2 Foundation and Practitioner are process-based project management approaches that can be easily customised and scaled. PRINCE2® Foundation and Practitioner course aim to provide delegates with a comprehensive knowledge of project management methodologies. At the end of this PRINCE2® Foundation and Practitioner course, delegates will be able to delegate tolerances and report actual and forecast progress effectively. They will also be able to quickly prepare the risk management, change control, quality management, and communication management approaches. Attaining this PRINCE2® certification enables candidates to demonstrate and enhance their project management proficiency – contributing to elevated business acumen and career prospects. Concepts covered: • Project management • Levels of management • Authorise initiation • Tailoring the IP process • Project and stage plans • Analysing risks to a plan • Escalate issues and risks PRINCE2® Foundation Training: This introductory PRINCE2® certification will help candidates understand the fundamentals of the PRINCE2® project management methodology and develop an appreciation of the constituents that contribute to a project’s success – underpinned by the PRINCE2® principles, processes, and themes. The foundation element of the combined course lasts for 3 days. During the course, candidates will gain a basic understanding of how to work in part of a PRINCE2® team. PRINCE2® Practitioner Training: The PRINCE2® Practitioner element of the combined course forms the final part of the training where the candidate learns to apply their acquired knowledge. Candidates will be educated on how to apply the methodology to a set of scenarios and how to efficaciously lead a project. What’s Included in this PRINCE2® Course? The following is included in this PRINCE2® Course: • The PRINCE2® Foundation Examination • The PRINCE2® Practitioner Examination • Pre-course material • PRINCE2® Workbook • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments • PRINCE2 Homework – Set by your PRINCE2 Instructor at the end of each day. Prerequisites for PRINCE2® Course: In this PRINCE2® Foundation and Practitioner course, there are no formal prerequisites. This PRINCE2® Course is designed for anyone who wants to gain in-depth knowledge about project management methodologies. This Course is more beneficial for: • Project Managers • Aspiring Project Managers • Team Leaders • Directors • Senior Responsible Owners PRINCE2® Foundation and Practitioner 6th Edition Training Course Outline: Module 1: Introduction to Projects and the PRINCE2® Methodology: • PRINCE2® “Project” Definition • Project Characteristics • Project Management • What is PRINCE2®? • Four Integrated Elements • What PRINCE2® Does Not Provide • What Makes a Project a PRINCE2® Project? Module 2: Project Manager Activities: • Customer/Supplier Environment • Projects in Context • Commercial Environment • Applying PRINCE2® • Delivery Approaches • Measuring Success • Organisational Capability • Seven Processes Module 3: Seven Themes: • Business Case • Organisation • Quality • Plans • Risk • Change • Progress Module 4: Seven Principles: • Continued Business Justification • Learn from Experience • Defined Roles and Responsibilities • Manage by Stages • Manage by Exception • Focus on Products • Tailor to Suit the Project Module 5: Organisation Theme: • Four Levels of Management • PRINCE2® Organisation Requirements • Project Management Team • Project Management Team Roles • Project Board • Project Assurance • Change Authority • Project Support • Communication Management Approach Module 6: Starting Up a Project (SU): • Process Overview • Feasibility Study and Mandate • Appoint the Executive and the Project Manager • Capture Previous Lessons • Design and Appoint the Project Management Team • Prepare the Outline Business Case • Project Product Description • Select the Project Approach and Assemble the Project Brief • Plan the Initiation Stage • Tailoring the SU Process Module 7: Directing a Project (DP): • Authorise Initiation • Authorise the Project • Authorise a Stage or Exception Plan • Authorise Project Closure • Give Ad Hoc Direction • Tailoring the DP Process • Theme Overview • Balance of Justification • Continued Business Justification • PRINCE2® Requirements • Contents of a Business Case • Business Case Development • Benefits Management Approach • Key Responsibilities Module 8: Initiating a Project (IP): • Agree to the Tailoring Requirements • Prepare the Risk Management Approach • Prepare the Change Control Approach • Prepare the Quality Management Approach • Prepare the Communication Management Approach • Set up the Project Controls • Create the Project Plan • Prepare the Benefits Management Approach • Assemble the Project Initiation Documentation • Tailoring the IP Process Module 9: Risk Theme: • Risk Definition • Effective Risk Management • PRINCE2® Risk Requirements • Risk Management Approach • Probability/Impact Grid • Risk Register • Risk Management Procedure • Identify Step • Risk Budget • Key Responsibilities Module 10: Quality Theme: • Quality Definitions • Quality Management • Quality Planning and Control • What is Quality Assurance? • PRINCE2® Quality Requirements • PRINCE2® Quality Documentation Requirements • Quality Management Approach • Quality Audit Trail • Project Product Description • Product Description • Quality Review Technique • Quality Review Roles/Responsibilities • Quality Review Meeting • Off-Specifications and Concessions • Review Follow-Up • Quality Review Benefits • Key Responsibilities • Communication Management Approach Module 11: Plans Theme: • Dealing with the Planning Horizon • PRINCE2® Planning Requirements • Documentation Requirements • Project and Stage Plans • Team Plans and Work Packages • Plans Relationship • What is in a Plan? • PRINCE2® Approach to Plans • Designing a Plan • Delivery Approaches • Defining and Analysing the Products • Product Breakdown Structures • Product Description • Product Flow Diagram • Identify the Activities and Dependencies • Preparing Estimates • Preparing a Schedule • Documenting the Plan • Analysing Risks to a Plan • Gantt Chart and Tailoring • Key Responsibilities Module 12: Progress Theme: • Progress Definition • PRINCE2® Requirements • Progress Control • Management by Exception • Delegating Tolerances and Reporting Actual and Forecast Progress • Types of Control • Management Products and Progress Control Module 13: Change Theme: • Issue Definition • PRINCE2® Approach to Change • PRINCE2® Change Documentation • Issue Register • Change Control Approach • Change Budget • Issue and Change Control Procedure • Issue Report • Exception Report Module 14: Controlling a Stage (CS): • Activity Breakdown • Authorise a Work Package • Work Package • Review Work Package Status • Receive Completed Work Packages • Review the Management Stage Status • Report Highlights • Highlight Report • Capture and Assess Issues and Risks • Escalate Issues and Risks • Take Corrective Action • Tailoring CS Module 15: Managing Product Delivery (MP): • Accept a Work Package • Execute a Work Package • Checkpoint Report • Deliver a Work Package • Tailoring MP Module 16: Managing a Stage Boundary (SB): • Plan the Next Management Stage • What is in a Plan? • Update the Project Plan • Update the Business Case • Report the Management Stage End • End-Stage Report • Produce an Exception Plan • Tailoring SB Module 17: Closing a Project (CP): • Prepare Planned Closure • Hand Over Products • Evaluate the Project • End Project Report • Recommend Project Closure • Tailoring CP Module 18: Considerations for Organisational Adoption: • Creating a PRINCE2® Based Project Management Method • Creating Tailoring Rules and Guidelines • Rating the Complexity of Projects • Embedding PRINCE2® • Tailoring • What Should Be Tailored? • Tailoring Constraints and Influences • Creating an Organisation’s Method DURATION 6 days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

In this unique course with tutor Sarah Reece you will learn how to cut two shapes of stones: The first will be a free form shape with a flat edges as shown in the images. The second the focus will be how to create a traditional cabochon. This stone will be have a flat base with a rounded top. This will be cut from rough stone which you can each select from Sarahs beautiful collection. You can decide the shape and size and which part of the stone you wish to use. The class size is limited to just 1 student. So you do not breathe in harmful rock dust during the process, you will be cutting the stone while it is in water. With this in mind, please wear older clothes, and waterproof shoes – wellies are advised as it is not a clean or dry activity. Water sprays from the rotating wheels as you are working. We will provide you with a waterproof apron. This course is an excellent introduction to stone cutting. It allows you to step into the world of Lapidary where you can cut and create any shaped stone you desire, you won’t be beholden to the shop bought stone. This means your projects and settings can become completely unique as per your designs. You will be working with a Cab King 6″ and the Diamond Pacific Pixie Cabbing Machine. We have factored in a 30 minute break for lunch during our Saturday sessions. Full info below… When: Sarah is available at weekends and during the week. If you decide to book a stone cutting course, there is flexibility for your booking. We will contact you to find a suitable session. Length: The session will last 4 hours Where:  THIS WORKSHOP COURSE IS BASED IN FARNHAM NOT OUR WOKING WORKSHOP Weydon Farm House Weydon Farm Lane GU9 8QJ There is parking on site. Tutor: Sarah Reece What does the session involve? In this unique course with tutor Sarah Reece you will learn how to cut two shapes of stones: The first will be a free form shape with flat edges (as shown in the images). The second the focus will be how to create a traditional cabochon. This stone will have a flat base with a rounded top. This will be cut from rough stone which you can select from Sarah’s beautiful collection. You can decide the shape and size and which part of the stone you wish to use. You will be cutting the stone while it is in water so you do not inhale harmful dusts. With this in mind, please wear older clothes, and waterproof shoes – wellies are advised as it is not a clean or dry activity. Water sprays from the rotating wheels as you are working. We will provide you with a waterproof apron. This course is an excellent introduction to stone cutting. It allows you to step into the world of Lapidary where you can cut and create any shaped stone you desire, you won’t be beholden to the shop bought stone. This means your projects and settings can become completely unique as per your designs. You will be working with a Cab King 6″ and the Diamond Pacific Pixie Cabbing Machine. The class size is limited to just 1 student. This Instagram post gives you a preview of what to expect from your session Experience required: None, all abilities are welcomed. We support you throughout the session and provide demonstrations to show you the techniques and steps needed to create your project. With one to one sessions, you will gain a large amount of support in this intensive introduction to stone cutting Class size: 1 What is included? All tools and consumables are supplied The stones you will carve are NOT INCLUDED in the price of the course – This is something you can choose on the day so you can select something you would like to work with. Sarah has priced up different varies in generous sizes ranging from £3-£20. If you would rather not buy stone to work with, no problem, Sarah has plenty of beautiful flint that you can use instead. What to bring: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within the workshop. Wellies or older waterproof shoes advised. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. There are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Also pack your own snacks and drinks for the session if required.

Face to Face training customised and bespoke. One to One Online or Face to Face

Why Choose AutoCAD Architecture Training Classes? Course info Master architectural design tools and workflows. Create precise floor plans, elevations, and sections. Utilize BIM for intelligent 3D modeling. Access recorded lessons and lifetime email support. Enroll for in-person or online sessions. Duration: 16 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. AutoCAD Architecture 3D Course Outline: Introduction to AutoCAD Architecture Understanding the difference between AutoCAD Architecture and AutoCAD LT Familiarization with the user interface and 3D viewing Wall Construction and Modification Adding walls to the model Creating curtain walls for specialized designs Modifying walls to fit specific requirements Joining walls together to form complex structures Adding and modifying wall openings for doors and windows Ceiling Plans (Reflected) Creating ceiling grids and construction detailing Modifying ceiling grids to match design needs Inserting ceiling fixtures and construction detailing Structural Design and Analysis Working with structural members and online resources Creating column grids and detailing columns Modifying column grids and annotations Annotating column grids and detailing for clarity Stairs Creating stairs in the model Modifying stairs to suit design specifications Adding railings to stairs and construction detailing Modifying railings and construction detailing Floors and Slabs Creating floor slabs and construction detailing Modifying floor slabs to align with the design Editing slabs using Slab Tools and construction detailing Roofs and Construction Detailing of Roofs Creating roofs for the building Designing roof slabs for specific areas Modifying roofs and roof slabs as needed Using Roof Slab Tools for precise detailing Annotation Detail drawing for scale and annotation Adding text, leaders, and comments to the model Dimensioning in AutoCAD Architecture for accurate measurements Utilizing other annotation tools for clarity Equipment and Furnishings Adding interior and exterior furnishings to the design Incorporating blocks and online 3D models for realistic representations Utilizing Tool Palettes and Autodesk Seek resources Model Views Ready for Print PDF Creating callouts for specific views Designing elevations, sections, and construction detailing Modifying callout objects for better visualization Implementing live sections and elevations Generating reports and managing project resources Schedules Adding door and window labels to the model Editing label data for accuracy Creating schedules for better project management Modifying schedules to suit specific requirements This AutoCAD Architecture 3D course covers a comprehensive range of topics, providing participants with the skills to create detailed 3D architectural models, implement construction detailing, and manage project resources efficiently. The course enables participants to produce professional-grade architectural designs using AutoCAD Architecture software.

The course is aimed at everyone working in health and social care that makes decisions for people who may lack capacity and who require a knowledge of the Mental Capacity Act and, specifically, the issue of deprivation of liberty safeguards (DOLS).

Revit face to face training customised and bespoke. Online or Face to Face