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
Can be run as a one day or two day course. Whereas the one day course concentrates on Speaking Skills in delivering a talk and allows time for participants to prepare and deliver a very short talk, the two day course offers the opportunity for participants to deliver a longer (15 minute) talk and includes consideration of other situations where speaking skills are important such as talking in meetings, talking at interviews etc.
Why Choose Complete Maya Beginner to Advanced Training? Maya's extensive toolkit includes modeling, animation, simulation, and more, amplifying your versatility and influence in the 3D production pipeline. Click here for more info: Website Beginners or those with basic 3D knowledge. No specific digital media background is required. Duration: 40 hours Training Approach: 1-on-1 Sessions. Schedule: Customize your schedule by pre-booking a convenient hour of your choice, available Monday to Saturday between 9 am and 7 pm Course Structure: I. Introduction to Maya (3 hours) Maya Overview and Applications Interface Navigation and Basic Tools Project Creation and Management II. Basic Polygon Modeling (6 hours) Fundamentals of Polygon Modeling Creating and Editing Basic Shapes Advanced Techniques: Extrusions, Bevels, and NURBS for Organic Shapes III. Intermediate Modeling (6 hours) Advanced Polygon Modeling: Booleans, Deformers, and Surfaces Architectural Model Creation Sculpting Tools for Organic Shapes IV. Texturing and Materials (6 hours) Introduction to Texturing and Material Application Texture Mapping, UV Unwrapping, and Shaders Painting Textures with 3D Paint Tool V. Lighting and Rendering (6 hours) Basic and Advanced Lighting Techniques Realistic Lighting Environments Camera Setup, Composition, and Rendering VI. Animation (9 hours) Keyframe Animation and Animation Curves Character Rigging and Animation Complex Character Rigs, Lip Sync, Facial Animation, Dynamics, and Simulations VII. Rigging (4 hours) Skeleton Creation and Joint Binding Weight Maps and Simple to Complex Rigging Systems VIII. Special Effects (4 hours) Particle Systems, Fluid Dynamics, Fire, and Explosions Advanced Simulations with nCloth and nParticles Paint Effects and Mash Networks IX. Advanced Rendering Techniques (2 hours) Render Layers, Passes, and Global Illumination Mental Ray Rendering and Settings X. Conclusion and Next Steps (1 hour) Course Review, Tips for Further Learning Q&A Session and Feedback Please note that the course outline is flexible and can be tailored based on the learners' needs and proficiency levels. Autodesk Maya Basics to Advanced Level Course: Modeling: Surfaces, Control Vertex, Polygons, Extrusion Techniques, Subdiv Modeling, and More Deformations: Twist, Lattice, Flare, Bend Tools Shapes: Lines, Pen Tools, Surface Manipulation Techniques Animations: Keyframe Setup, Path Animations, Skeletons, IK Handles, Skinning Dynamics and Special Effects: Particle Systems, Fluid Dynamics, Lighting Effects, and Advanced Simulations Texturing and Rendering: Diffuse and Bump Mapping, Reflections, Shaders, Lights, and Camera Techniques Fluid Effects and Ncloth: 2D and 3D Containers, Collision Effects, Wind Simulations, and Gravity Control Rendering: Image and Animation Rendering, Playblast, Resolution Controls, and Output Formats. Advanced Modeling: Master intricate 3D models, including polygon, NURBS, and architectural modeling. Expert Texturing: Create realistic textures, apply shaders, and utilize the 3D paint tool. Complex Animation: Rig characters, perform lip sync, facial animation, and dynamic simulations. Special Effects Mastery: Understand particle systems, fluid dynamics, fire effects, and advanced simulations. Rendering Expertise: Grasp advanced rendering techniques, including layers, passes, and global illumination. Comprehensive Rigging: Develop joints, skeletons, and advanced rigging systems for characters and objects. Fluid Dynamics Proficiency: Manipulate 2D/3D fluid containers, create collision effects, and work with wind/gravity simulations. Advanced Lighting and Camera: Perfect lighting, shadows, and special effects. Master camera setups for diverse visual compositions. Recommended Books: "Introducing Autodesk Maya 2023" by Dariush Derakhshani and Randi L. Derakhshani "Mastering Autodesk Maya 2023" by Todd Palamar "Maya Character Creation: Modeling and Animation Controls" by Chris Maraffi "Maya Secrets of the Pros" by John Kundert-Gibbs and Dariush Derakhshani "The Art of 3D Computer Animation and Effects" by Isaac Victor Kerlow Advanced Maya Training Tailored to You: Elevate your Maya skills with specialized training covering essential areas like modeling, UV mapping, texturing, lighting, camera movement, and rigging. Your learning experience is personalized to match your unique requirements and preferences. Discuss your goals with our trainer, and we'll create a syllabus tailored just for you. Flexible Training Choices: Select between in-person sessions at our UK center or attend live online classes, offering convenience and accessibility. Certified Instructors: Benefit from expert guidance provided by Autodesk Authorized Trainers from London Design Training Course. Hands-On Learning: Our practical approach combines theory with step-by-step demonstrations, allowing ample time for hands-on practice on your computer with Maya. You'll retain all the files you create. Compatibility Across Platforms: Maya training caters to both Windows and Mac users, ensuring compatibility with various versions of Maya. Comprehensive Training Package: Participants receive an e-certificate upon successful completion, validating their Maya training. Lifetime Support: Enjoy a lifetime of email support post-training, ensuring assistance with any queries or challenges that arise. Tailored to Your Version: Training can be adapted to your preferred Maya version, ensuring you learn using the most relevant and up-to-date software features. Download Maya https://www.autodesk.co.uk Highly skilled mentors with practical experience. Cutting-edge facilities ensuring an immersive learning environment. Comprehensive courses spanning diverse design disciplines. Practical projects to enhance your portfolio. Networking avenues within the dynamic design community. Skills attuned to current industry trends. Opportunities for professional growth. Choose from flexible in-person or online classes. Internationally recognized training credentials. Engage in London's thriving art and design scene.
Training duration: 10 hrs Click here for 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. Autodesk Maya Training Course with our flexible evening training course. Designed to accommodate busy schedules, this course allows you to learn Maya at your convenience, either in-person or through live online sessions. Master essential features and workflows to create captivating 3D models, animations, and visual effects. Benefit from expert guidance, hands-on projects, and lifetime email support, ensuring a rewarding learning experience. Enroll now to ignite your creativity and open doors to exciting opportunities in the animation and visual effects industry. The Autodesk Maya Evening Training Course offers a flexible learning option for busy professionals and students with daytime commitments. Master the powerful tools and capabilities of Autodesk Maya during convenient evening sessions. Participants will receive comprehensive training in 3D modeling, materials, animation, lighting, and rendering. The course progresses to advanced topics, including dynamics, character rigging, shading, and compositing. Enroll in this course to develop valuable skills in 3D computer graphics and animation. Benefit from interactive learning experiences and expert guidance, whether attending in-person or joining live online sessions. Maya Evening Training Courses Duration: 10 hours Course Outline: I. Introduction to Maya (1 hour) Gain insights into Maya's versatile applications and interface. Master navigation and project management. II. Creating 3D Models (2 hours) Learn polygon modeling basics and refine objects with precision. III. Texturing and Materials (1 hour) Apply and customize materials for enhanced visuals. IV. Lighting and Rendering (1.5 hours) Explore lighting techniques and rendering. V. Animation (2.5 hours) Understand animation principles and rig characters. VI. Special Effects (1 hour) Harness particle systems and create captivating effects. VII. Intermediate Modeling Techniques (1 hour) Venture into NURBS modeling and sculpting tools. VIII. Conclusion and Next Steps (0.5 hour) Recap and explore further learning resources. Autodesk Maya Evening Training Course Topics Covered: Modeling, Texturing, Animation, Lighting, Rendering, and more. Download Autodesk Maya! Create expansive worlds, characters, and effects. Subscribe now for a year and start your 3D model and animation journey. Visit https://www.autodesk.co.uk/maya for a free trial. Upon completing the Autodesk Maya Evening Training Course, participants will gain proficiency in 3D modeling, texturing, animation, lighting, and rendering using Autodesk Maya. They will acquire the skills to create captivating visuals and animations, opening up opportunities in diverse industries such as entertainment, gaming, and architectural visualization. The flexible evening schedule allows for convenient learning, accommodating busy professionals and students.
Who is this for? Essential Adobe InDesign Training Course. Acquire Adobe InDesign basics from certified instructors. Master layout design, typography, and core design concepts. Opt for in-person or live online sessions. Receive a Certificate of Completion and lifelong email assistance. Lean desktop publishing skills and quality layouts. Click here for more info: Website Duration: 5 hours Approach: Individualized 1-on-1 training with customized content. Schedule: Flexible sessions, available Monday to Saturday from 9 am to 7 pm. Course Outline: Module 1: Introduction to Adobe InDesign (1 hour) Familiarize with workspace and tools Create new documents with appropriate page size and margins Effectively format text and images Customize the interface for efficient workflow Module 2: Text Formatting and Styles (1 hour) Apply consistent character and paragraph styles Manage text flow using frames Organize lists with bullets and numbering Master special characters for precise typography Module 3: Working with Images (1 hour) Import and position images in documents Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Module 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for balanced layouts Streamline work with layers Maintain consistency using master pages and templates Module 5: Printing and Exporting (1 hour) Understand color modes and print principles Export to PDF and other formats for diverse outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through practical exercises, solidify your grasp of each module, enabling you to design visually appealing layouts, craft documents for various purposes, and manage InDesign projects adeptly. Adobe InDesign's potential is vast, and this fundamentals course opens doors for you to explore diverse design projects. Seize this opportunity to unleash your creative prowess with InDesign! Upon completing the Adobe InDesign Fundamentals course, participants will be able to: Master InDesign Tools: Demonstrate proficiency in utilizing InDesign's essential tools, workspace, and interface for effective design workflows. Layout Design Skills: Create visually appealing layouts using grids, guides, and balanced object arrangements, ensuring professional-quality design. Text Formatting Mastery: Apply consistent character and paragraph styles, manage text flow, and enhance typography with special characters. Image Manipulation Expertise: Import, position, and enhance images within frames, integrating them seamlessly into layouts. Printing and Exporting Proficiency: Understand color modes, print principles, and export documents to various formats, ensuring print readiness and diverse output options. Efficient Project Management: Utilize layers, master pages, and templates for streamlined project organization and management in InDesign. Book Recommendations: "InDesign CC Classroom in a Book" by Kelly Kordes Anton and John Cruise: This official Adobe guide provides hands-on lessons and practical techniques for mastering InDesign's core features. "InDesign Type: Professional Typography with Adobe InDesign" by Nigel French: Explore advanced typography techniques, layout principles, and typographic finesse specific to Adobe InDesign. "Real World Adobe InDesign CC" by Olav Martin Kvern, David Blatner, and Bob Bringhurst: A comprehensive guide offering practical insights, tips, and real-world techniques for InDesign users of all levels. "The Adobe InDesign CS6 Book for Digital Photographers" by Scott Kelby: Focused on integrating photography with InDesign, this book provides valuable insights into creating visually stunning layouts with images. "InDesign Secrets" by David Blatner and Anne-Marie Concepción: This book is packed with expert tips, tricks, and techniques that can significantly enhance your efficiency and creativity in InDesign. 1-on-1 InDesign Courses: Personalized Learning: Tailored 1-on-1 courses designed to meet your specific learning needs and goals. Expert Instructors: Learn from industry professionals with extensive experience in animation and design. Flexible Scheduling: Schedule sessions at your convenience, allowing you to balance learning with your busy lifestyle. Comprehensive Curriculum: Dive deep into animation techniques, software mastery, and creative skills through our comprehensive courses. Hands-On Training: Get practical, hands-on experience with real-world animation projects, enhancing your skills effectively. Individual Attention: Benefit from personalized attention and detailed feedback from instructors, ensuring your progress and understanding. Professional Development: Acquire skills relevant to the industry, empowering you for career advancement in animation and related fields. Portfolio Enhancement: Develop a strong portfolio with the guidance of experts, showcasing your newfound skills and creativity. Post-Course Support: Enjoy continued support even after the course completion, ensuring you have resources for ongoing learning and growth. Certification: Receive a certificate upon course completion, validating your expertise and enhancing your professional credentials. Course Highlights: Master Adobe InDesign's key features for layout, text, images, and graphics. Learn design principles and typography techniques for visually appealing documents. Efficiently handle multi-page projects like magazines and brochures. Utilize styles, templates, and libraries for streamlined design and consistency. Explore advanced techniques for interactive PDFs and digital publishing. Earn a Certificate of Completion for your Adobe InDesign proficiency. Flexible learning options: in-person or live online sessions. Lifetime email support for ongoing assistance after the course. Adobe InDesign Learn & Support https://helpx.adobe.com ⺠support ⺠indesign Get started with Adobe InDesign. Find tutorials, the user guide, answers to common questions, and help from the community forum.
Adobe After Effects is recognised as an essential tool for motion graphics and visual effects. Our introductory Adobe After Effects course is designed for those new to post-production techniques, and would like to get the most from this immensely powerful application. Whether you are a motion graphics designer, a web designer, rich media artist or broadcast video editor, this course covers all the techniques you need to successfully start using, or significantly improve your command over, Adobe After Effects.
Live online course with study materials and certificate of completion included Adobe After Effects is recognised as an essential tool for motion graphics and visual effects. Our introductory Adobe After Effects course is designed for those new to post-production techniques, and would like to get the most from this immensely powerful application. Whether you are a motion graphics designer, a web designer, rich media artist or broadcast video editor, this course covers all the techniques you need to successfully start using, or significantly improve your command over, Adobe After Effects. Description Completing this course will enable you to do the following and more: Become familiar with the After Effects workspace Create animations using keyframes Understand keyframe interpolation and velocity Work with the graph editor to fine tune animations Work with Solid, Text and Null layers Work with masks, mattes and track mattes Create Compositions Incorporate video with Photoshop and Illustrator. Use video layering with transfer and blending modes Use Motion Tracker and 3D Camera Tracker Apply and animate Effects Use Colour Correction / Glows + Curves Use filters for special effects Render your final project For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone who wishes to learn Adobe Afer Effects from scratch or wants to improve their existing knowledge of the program. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included
3ds max professional one to one training
Summary of topics covered in the class: – Overview on leather types, tanning, finishings and best uses – Hand sewing / saddle stitching – Leather preparation, pattern placement, leather marking and leather cutting – Leather beveling and burnishing – Pattern making principles for hand sewn goods By the end of the tuition, you will have: – Learned to hand sew leather / saddle stitch leather and construct some three-dimensional shapes – Understood the proper use of hand tools related to hand sewing leather, as well as needle and thread types – Gained an understanding of leather types and the ability to select the correct material for your project – Worked with a variety of tools and various leathers, creating a catalogue of samples to take home – Developed confidence in utilising a wide range of specific tools for leather preparation, marking, finishing, cutting, and more – Understood the different methods of creating patterns for hand-sewn items compared to pattern making for other types of goods Included in the course: You will receive useful paper handouts containing: – A list of tools and materials used during the lesson(s), with descriptions and usage instructions – A list of recommended suppliers for leather and fittings, both in London and online – A glossary of leather types and characteristics All materials are included, there are no additional costs. Find all modules here: https://the-london-leather-workshop.cademy.co.uk/
Why learn Vectorworks Basics to Intermediate Training Course? Course Link Vectorworks skills with our course! Led by certified expert tutors, this course takes you from basics to intermediate level, enabling you to create plans and sections. The course will cover 2D and 3D modeling, rendering, and visualization. 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. At London Design Training Course, we offer a range of Vectorworks training options to meet your specific needs and those of your business. Explore the links below for detailed information about the various training types and their content. On-Site Training: London Design Training Course comes to your location, eliminating the need for you to travel. This approach allows us to fully understand your business culture and requirements. Training can be conducted in your studio or conference room, with scheduling flexibility tailored to your preferences. In-House Training: Our studio in London SW96DE, hosts In-House Vectorworks training for both individuals and groups. During the sessions, we provide the necessary software and hardware to ensure a seamless learning experience. Vectorworks Basic to Intermediate Course Course Duration: 16 hours The Vectorworks Basic to Intermediate Course is tailored for individuals with basic Vectorworks knowledge, aiming to master advanced 2D and 3D techniques, including modeling and rendering. Participants will customize Vectorworks to their needs, create custom tools, and automate tasks with scripting. I. Review of Basic Concepts (1 hour) - Vectorworks interface and navigation - Creating and editing 2D and 3D geometry - Working with layers and classes - Utilizing views and viewports II. Advanced 2D Drawing Techniques (2 hours) - Creating complex geometry using advanced drawing tools - Editing and modifying intricate geometry - Customizing line types and hatches - Utilizing advanced annotation tools III. Advanced 3D Modeling (3 hours) - Creating 3D forms and custom 3D objects - Exploring advanced 3D tools such as Solid Modeling - Converting 2D plans into 3D models IV. Visualization and Rendering (3 hours) - Setting up cameras and lights for visualization purposes - Utilizing the Renderworks engine for rendering - Enhancing visuals with the visualization palette - Creating and editing textures and materials V. Customizing Vectorworks (3 hours) - Personalizing the interface to suit specific preferences - Creating custom tools and automating tasks using the scripting language - Developing custom object styles and resources - Creating custom plug-ins and scripts VI. Collaboration and Sharing (2 hours) - Importing and exporting data from other software - Collaborating with others on the same project - Utilizing cloud-based collaboration tools VII. Conclusion and Next Steps (1 hour) - Review of course content and key skills learned - Tips for further learning and available resources - Q&A and feedback session Free 30-day, BIM & CAD Software Trial Request | Vectorworks https://www.vectorworks.net/trial Vectorworks Trial Version Request. Please fill out the following form. We will provide you with an evaluation serial number to activate your trial copy. Learning Outcomes of the Vectorworks Basics to Intermediate Training Course: Proficiency in Vectorworks interface, tools, and navigation. Master 2D drafting and 3D modeling skills. Efficiently manage workflows using layers, classes, and views. Spotlighting techniques for lighting design and stage productions. Advanced object manipulation with solid modeling and Boolean operations. Utilize the symbol library for enhanced productivity. Create professional presentation drawings using viewports and annotations. Integrate with other software and CAD/BIM workflows. Apply skills to real-world projects for practical application. Upon completing the course, participants will have essential skills to effectively use Vectorworks, advancing their proficiency to an intermediate level.