296 Courses in London

Designed with the experienced user in mind, this one day course offers those already familiar with Illustrator the chance to explore more of its complex creative options, and increase their productivity and output. Creating 3D type and shapes, advanced use of colour and bespoke brushes are just some of the advanced techniques you will learn for creating professional print and web-ready artwork.

Why Choose Mastering Maya Basics to Intermediate Course? Click here for more info: Website Our courses cater to graphic designers, animators, and beginners, providing industry-standard animation skills. Dive into 3D animation, modeling, simulation, and rendering for film, TV, games, and ads. Duration: 20 hours Approach: 1-on-1 Sessions. Schedule: Design your own schedule by pre-booking a convenient hour of your choice, available Mon to Sat between 9 am and 7 pm. I. Introduction to Maya (1.5 hours) Understanding Maya and its Applications Navigating the Maya Interface and Basic Tools Creating and Managing Projects II. 3D Modeling (3 hours) Basics of Polygon Modeling Creating Simple and Complex 3D Shapes Organic Shape Creation using NURBS Advanced Techniques: Extrusions, Bevels, and Editable Objects III. Texturing and Materials (1.5 hours) Introduction to Texturing and Material Creation UV Unwrapping and Texture Mapping Importing and Applying Textures and Images IV. Lighting and Rendering (2 hours) Fundamental Lighting Techniques Camera Setup and Composition Rendering Images and Animations Output Options and File Formats V. Animation (4 hours) Keyframe Animation and Animation Curves Rigging and Animating Characters Motion Paths and Animation Layers Editing Animation Clips VI. Rigging (2 hours) Introduction to Rigging and Skeletons Binding Skin and Weight Maps Creating Rigging Systems for Characters VII. Special Effects (1.5 hours) Particle Systems and Dynamics Creating Fluids, Fire, and Other Effects Special Effects Editing: Explosions, Smoke, and more VIII. Advanced Modeling Techniques (1.5 hours) Complex Objects using Booleans and Deformers Modifying Curves and Surfaces Organic Shape Creation with Sculpting Tools IX. Conclusion and Next Steps (0.5 hours) Course Review Further Learning Tips and Resources Q&A and Feedback Please note: The course content and duration are flexible, tailored to match learners' needs and skill levels. Throughout the course, lifetime email support ensures you receive guidance with any challenges you face. Embark on your Autodesk Maya journey, exploring 3D modeling and animation with confidence. Additional Topics Covered: Modeling: Surfaces, Control Vertex, Polygons, Extrusion, Vertices, Edges, Bridge Tool, Combining, Smooth, Mirror Geometry, Merging Vertices, Subdivision Modeling. Deformations: Twist, Lattice, Flare, Bend. Shapes: Lines, Pen Tools. Animations: Basic Keyframes, Vertex Animation, Clusters, Path Animations, Skeletons, Bones, IK Handle Tool, Skinning. Dynamics: Fire, Lighting, Soft and Rigid Bodies, Particles, Collisions, Gravity. Fur and Paint Effects: Fur Basics, Fur Color Corrections, Paint Effects, Paint Modifier, Brush Animations. Texturing: Diffuse and Bump Maps, Reflections, Transparency, Shaders, Toon Shaders, Glow Textures. Lighting: Basic and Advanced Lights, Shadows, Special Light Effects. Camera: Free and Aim Cameras, Camera Effects, Path Animations. Fluid Effects and Ncloth: 2D and 3D Containers, Collision Effects, Gravity, Wind Effects. Rendering: Images and Animations, Render Techniques, Resolution Settings, Batch Rendering. Download Maya Maya Proficiency: Master Maya's interface, tools, and functions, advancing from basic to intermediate levels. 3D Modeling Expertise: Create diverse 3D models using polygonal and NURBS techniques, from simple shapes to intricate designs. Texturing and Rendering Skills: Apply textures, create materials, and utilize advanced rendering techniques for high-quality visuals. Animation Techniques: Understand keyframe animation, rigging, and character animation, producing engaging animations and special effects. Special Effects and Dynamics: Explore particle systems, fluid dynamics, and advanced visual effects, enhancing realism in animations. Advanced Modeling and Sculpting: Master complex modeling techniques, including Booleans, deformers, and organic shape creation through sculpting tools. Professional Portfolio: Develop a diverse portfolio showcasing 3D modeling and animation skills, ready for presentation to employers or clients. Problem-Solving Skills: Learn creative approaches to solve complex 3D challenges effectively. Collaborative Abilities: Understand team dynamics and collaboration within the 3D production pipeline. Recommended Books: "Introducing Autodesk Maya 202X" by Dariush Derakhshani and Randi L. Derakhshani: Comprehensive beginner's guide to Maya's essential tools and techniques. "Mastering Autodesk Maya 20XX" by Todd Palamar: In-depth intermediate guide covering advanced features, modeling, animation, and rendering. "Maya Character Creation: Modeling and Animation Controls" by Chris Maraffi: Focuses on character creation, covering modeling, rigging, and animation. "Maya Secrets of the Pros" by Todd Palamar: Expert tips and techniques from professional Maya artists, detailing advanced workflows and best practices. "Stop Staring: Facial Modeling and Animation Done Right" by Jason Osipa: Specialized book on facial modeling and animation, perfect for character expression enthusiasts. "The Art of 3D Computer Animation and Effects" by Isaac Kerlow: Offers foundational knowledge in 3D computer animation principles, applicable to various software, including Maya. Mastering Maya Basics to Intermediate Course Benefits: Comprehensive Skill Development: Master essential tools and techniques, from basics to intermediate, with hands-on projects mirroring real industry scenarios. Industry-Grade Proficiency: Acquire expertise in Autodesk Maya, enhancing credibility in animation, visual effects, and gaming industries. Creative Exploration: Unlock creative potential through advanced shading, lighting, dynamics, and simulations, enabling imaginative project realization. Portfolio Enhancement: Build a strong portfolio showcasing skills in 3D modeling, animation, and rendering for career advancement. Individualized Support: Receive personalized guidance and feedback, ensuring tailored learning experiences and skill refinement. Potential Jobs After Course: 3D Animator: Create lifelike character animations for films, games, and advertisements. 3D Modeler: Design detailed 3D characters, environments, and objects for various applications. Visual Effects Artist: Produce stunning visual effects for movies, TV shows, and commercials. Texture/Lighting Artist: Develop intricate textures and set the mood with expert lighting. Rigging Specialist: Rig characters and objects for realistic movement in animations. Rendering Specialist: Optimize rendering capabilities for high-quality images and animations. Game Developer: Contribute to interactive game development using Maya's features. Freelance Artist/Animator: Work independently on diverse projects, collaborating with studios and agencies. Skill Advancement: Progressive Mastery: Develop from basics to intermediate levels in Autodesk Maya, honing essential tools for stunning 3D visuals and animations. Hands-On Learning: Interactive Practice: Engage in practical projects, refining your skills in 3D modeling, advanced materials, character animation, and high-quality renders. Industry-Ready Proficiency: In-Demand Skills: Acquire proficiency in Autodesk Maya, a key software in animation and gaming, enhancing your employability. Creative Exploration: Unlock Creativity: Experiment with advanced shading, lighting, and dynamic animations, unleashing your creative potential in Maya. Flexible Support: Tailored Learning: Access recorded lessons for review, deepening your understanding, with lifetime email support for continuous guidance.

Why Choose Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate? Learn Rhino 3D and V-Ray for Rhino Basic to Intermediate Training Course. Suitable for beginners and experienced users alike, this program equips you with vital modeling and rendering skills. Opt for in-person or live online sessions. Click here for more info: Website Duration: 16 hours. Approach: 1-on-1 Sessions, Customized Content and Flexible Learning. Scheduling Flexibility: Tailor your sessions from Mon to Sat between 9 am and 7 pm. Course Title: Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate - 16 Hours Session 1-2: Introduction to Rhino 3D Basics (2 hours) Understanding Rhino Interface: Navigating toolbars, command line, and properties panel. Basic Geometric Shapes: Creating lines, circles, and polygons with precision. Editing Tools: Mastering move, rotate, scale, and mirror commands. Session 3-4: Advanced Rhino 3D Modeling Techniques (2 hours) Curves and Surfaces: Delving into NURBS curves, creating complex surfaces, and blending techniques. Modeling Aids: Utilizing grids, snaps, and construction planes for accuracy. Organizing with Layers: Managing complex projects efficiently. Session 5-6: Introduction to V-Ray for Rhino (2 hours) V-Ray Interface: Understanding V-Ray toolbar and settings. Basic Lighting: Exploring different light types and their effects on scenes. Materials: Creating realistic materials, understanding diffuse, reflection, and transparency. Session 7-8: Intermediate V-Ray Concepts (2 hours) Advanced Lighting: Mastering HDRI lighting, creating natural outdoor lighting scenarios. Texture Mapping: Understanding UV mapping, applying textures seamlessly. Rendering Optimization: Reducing noise, optimizing settings for quicker, high-quality renders. Session 9-10: Rhino-V-Ray Integration (2 hours) Model Preparation: Optimizing Rhino models for V-Ray rendering. Advanced Material Manipulation: Creating complex materials, incorporating textures. Interactive Rendering: Real-time adjustments for immediate feedback. Session 11-12: Advanced Modeling Techniques in Rhino (2 hours) Advanced Surface Modeling: Creating organic shapes, advanced surfacing techniques. Precision Modeling: Advanced curve editing, filleting, and trimming. Working with 3D Text: Creating custom 3D text for design projects. Session 13-14: Scene Composition and Presentation (2 hours) Camera Settings: Understanding focal length, depth of field, and perspective. Scene Composition: Design principles, rule of thirds, focal points, and balance. Post-Processing: Enhancing renders in Photoshop, adding atmosphere and context. Session 15-16: Final Project and Portfolio Review (2 hours) Final Project Work: Participants apply learned skills to create a complex 3D scene. Instructor-led Critique: Feedback session for final projects. Portfolio Guidance: Tips for selecting the best works for a professional portfolio. By the end of this 16-hour course, participants will have a deep understanding of both Rhino 3D and V-Ray, allowing them to create intricate 3D models and produce high-quality, realistic renders for various applications. Upon completing the Rhino 3D and V-Ray Basic to Intermediate Training Course, participants can expect to achieve the following learning outcomes: Proficiency in Rhino 3D and V-Ray: Develop a comprehensive understanding of Rhino 3D and V-Ray interfaces, tools, and functionalities, enabling participants to navigate and utilize the software effectively. 3D Modeling Skills: Master the art of creating captivating 3D objects and shapes using Rhino 3D, including editing, transforming, and refining designs for diverse applications. Material Application: Acquire the ability to apply and customize materials and textures to enhance the visual appeal and realism of 3D models, elevating the quality of designs. Lighting Techniques: Gain expertise in utilizing V-Ray lighting tools, such as V-Ray lights and HDRI maps, to achieve striking lighting effects in rendered scenes. Rendering Excellence: Learn to optimize V-Ray render settings, control global illumination, and apply dynamic effects like depth of field and motion blur for high-quality and impressive renders. Advanced Modeling: Develop skills in advanced modeling techniques, including handling curves, surfaces, and solids, enabling participants to tackle complex design challenges. Lighting Mastery: Acquire the knowledge and expertise to create and adjust artificial lights, utilize the Sun and Sky system, and craft custom HDR images for realistic lighting setups. Seamless File Management: Understand various file formats for exporting and importing 3D models, facilitating efficient collaboration and preparation for 3D printing. Creative Problem-Solving: Enhance creative thinking and problem-solving abilities through hands-on practice and exploration of diverse design scenarios. Professional Presentation: Learn post-production techniques in Photoshop to enhance renders and create visually appealing design presentations for effective communication. Continuous Learning: Access valuable resources and tips to encourage continuous learning and professional growth in Rhino 3D and V-Ray. Skills You'll Gain: Master Rhino 3D basics: Curves, surfaces, modeling aids, and precision techniques. Explore intermediate V-Ray concepts: Advanced lighting, material manipulation, and texture mapping. Understand Rhino-V-Ray integration for seamless 3D modeling and rendering workflows. Optimize render settings for high-quality output and reduced rendering times. Career Opportunities: Upon completing this program, you'll be prepared for various roles in the design and visualization industry, such as: 3D Modeler: Create detailed 3D models for diverse industries, including architecture and product design. Architectural Visualizer: Produce realistic architectural visualizations for presentations and marketing materials. Product Designer: Develop visually appealing product prototypes and visualizations for marketing and manufacturing. Visualization Specialist: Work in design studios, advertising agencies, or game development companies, creating immersive visual content. Freelance Designer: Offer your skills on platforms like Upwork or Fiverr, providing 3D modeling and rendering services to clients worldwide. Solidify Rhino 3D Expertise: Master foundational modeling skills, including intricate geometries and surface manipulation, establishing a robust foundation for your 3D design journey. Unlock V-Ray for Rhino: Explore the potential of V-Ray for Rhino, learning to create mesmerizing visualizations and achieve lifelike rendering results that bring vitality to your designs. Enhance Visual Appeal: Grasp advanced lighting techniques, material application, and texture methods to elevate the visual allure of your 3D creations, making them more immersive and authentic. Explore Advanced Concepts: Delve into optimizing rendering settings, post-production tactics, and efficient workflows, advancing your design proficiency to higher levels. Hands-On Experience: Engage in practical exercises and real-world projects, applying your skills in practical contexts to enrich your portfolio and showcase your capabilities effectively. Certification of Achievement: Receive a valuable Certificate of Completion, confirming your expertise in Rhino 3D and V-Ray for Rhino, enhancing your professional credibility as a skilled designer. Flexible Learning Paths: In-Person or Live Online: Opt for in-person sessions, fostering collaborative learning, or choose live online classes for convenience and accessibility, tailoring your learning experience to your preferences. Personalized Guidance: Regardless of your chosen format, benefit from tailored instruction and guidance, ensuring optimal learning outcomes and continuous support throughout the course.

Adobe authorised live online course with study materials and certificate of completion included Our advanced Adobe Photoshop course has been developed especially for Photoshop users who want to harness the full potential of the programme. You will learn advanced techniques for replacing colour, professional image retouching methods and complex blending techniques for integrating textures. You will also discover power user keyboard shortcuts and the advantages of different techniques for masking complex objects, plus much more. Description Completing this course will enable you to do the following and more: Use advanced image retouching Use advanced image restoration techniques Work with Smart Objects Learn Quick and effective techniques for masking complex objects Use Advanced retouching techniques using blending layers Work with Textures Use Texture integration using advanced blending techniques Implement Non-destructive transformations using smart objects Work with Advanced sharpening and noise reduction techniques Record, import and execute actions Make Selections from colour and alpha channels Improve your workflow Use Power Shortcuts Access Repousse and 3D layers For the full course content please download the course information pdf listed above. Who is this course for? This course is perfect for existing Photoshop users who want to learn how to make use of more of the applications powerful features and improve their workflow. Requirements Attendees should have a good working knowledge of Photoshop. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Why Choose Photoshop Basics to Fundamentals Training Course? Our Photoshop Basics to Fundamentals Training Course offers a strong skills in Adobe Photoshop, equipping with essential skills. Learn to use layers, selection tools, layer effects, layers, masking, photos, typography, filters, and color theory. Learn features for confident Photoshop usage. Course Link 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 Course Highlights: Master Advanced Photoshop Skills: Develop expertise in professional image editing, retouching, and manipulation techniques. Hands-on Creative Projects: Engage in practical exercises to enhance real-world design skills. Explore Special Effects: Dive into advanced topics like layer effects, filters, and blending modes for stunning visual creations. Typography and Design Mastery: Learn typography styles, layout design, and color theory for compelling compositions. Build a Professional Portfolio: Receive guidance on crafting a portfolio showcasing your Photoshop expertise. Job Opportunities: Graphic Designer: Create captivating visuals for print and digital media. Digital Artist: Craft digital artwork for various applications, from illustrations to ads. UI/UX Designer: Design user interfaces and experiences for websites and apps. Web Designer: Develop visually engaging websites with expertise in Photoshop. Marketing Content Creator: Produce marketing materials, including banners and social media visuals. Freelance Designer: Offer design services independently to diverse clients. Advertising Creative: Design impactful ad visuals for creative campaigns. Print Production Specialist: Prepare print-ready materials, ensuring high-quality results. Photography Post-Processing Specialist: Enhance and retouch photographs for professional use. Module 1: Interface and Preferences Familiarize with the Photoshop Interface Customize Panels and Toolbars to suit your workflow Explore Photoshop Preferences for optimal settings Discover different Photoshop CC Workspaces for various tasks Get started with essential Keyboard Shortcuts Module 2: Image File Formats Understand various image file formats, including PSD, JPEG, PNG, and PDF Explore File Compression and its impact on image quality Module 3: Creating a New Document Set dimensions and size for new documents Understand media units for precise design specifications Explore Color Profiles and their importance Save presets for quick document setups Module 4: Placing Images Learn about Embedded vs. Linked images Introduction to Smart Objects for non-destructive editing Master the Selection tool for precise image placement Module 5: Image Size and Resolution Save images in different formats and compression settings Learn about Image Size and Resolution for various output requirements Module 6: Layers Introduction Organize your work using Layer management Master layer tasks such as reordering, renaming, grouping, locking, and hiding Module 7: Selection Tools Explore various Selection Tools like Marquee, Magic Wand, Quick Selection, and Lasso Understand Inverse Selection and Deselect for efficient editing Module 8: Layer Effects Apply captivating Layer Effects like Drop Shadow, Stroke, and Outer Glow Save and clone Effects Styles for quick application Combine multiple effects for creative designs Module 9: Introduction to Shapes Utilize the Shapes tool for basic design elements Create Custom Shapes for unique designs Understand Color principles and use the Properties Panel for adjustments Master the Direct Selection tool for precise shape editing Create a basic poster using provided examples Module 10: Type and Typography Work with Type and explore the Character and Paragraph Panel Utilize Styles Panel for consistent text formatting Save favorite fonts for easy access Apply Effects and Layer Styles on Type for impactful typography Learn about Leading, Tracking, and Kerning for optimal text spacing Module 11: Colors Understand RGB vs. CMYK color modes Select colors using the Eyedropper tool Save colors as Swatches for reuse Create gradients using the Gradient Tool Module 12: Creating a Clipping Mask Master the concept of Clipping Masks and its usage Apply Clipping Masks to Type, Images, and Shapes Combine Layer Effects with Clipping Masks for creative designs Module 13: Introduction to Masking Understand Masking and its importance in image editing Utilize the Brush tool for creating masks Learn Masking shortcuts and use Gradient Mask for smooth transitions Module 14: Adjustment Layers Explore Color and Gradient Adjustment Layers for image enhancements Master Curves, Levels, and Hue/Saturation Adjustment Layers for precise color control Convert images to Black and White using Adjustment Layers Combine Adjustment Layer Masks for targeted edits Module 15: Image Touch Up Master various touch-up techniques, including Red Eye Removal, Spot Healing Brush, and Patch Tool Utilize Content Aware Removal for seamless object removal Restore an old photo using Clone Stamp and Dodge/Burn tools Improve portraits by removing blemishes and whitening teeth Module 16: Filters Introduction Understand Smart Objects and Filter usage for non-destructive editing Explore the Filters Gallery and experiment with Blur and Vantage filters Module 17: Blending Modes Introduction Master the concept of Blending Modes and their impact on layer overlays Understand different types of Blending Modes, including Darken, Lighten, and Overlay Master the art of working with layers in Adobe Photoshop. Skillfully utilize various selection tools for precise editing and manipulation. Apply captivating Layer Effects to enhance your designs and visuals. Understand the functionality of Adjustment Layers, Masking, and Clipping Masks for advanced editing and compositing. Acquire the techniques to touch up and restore photographs effectively. Explore typography techniques to create visually appealing text designs. Gain an introductory understanding of Filters and their creative applications. Grasp the principles of Color Theory and its practical application in design.

Enhance your knowledge in petroleum geochemistry with EnergyEdge's course on petroleum exploration. Enroll now!

Adobe authorised live online course with study materials and certificate of completion included Designed with the experienced user in mind, this one day course offers those already familiar with Illustrator the chance to explore more of its complex creative options, and increase their productivity and output. Creating 3D type and shapes, advanced use of colour and bespoke brushes are just some of the advanced techniques you will learn for creating professional print and web-ready artwork. Description Completing this course will enable you to do the following and more: Use Professional Artboard setup Work with Advanced drawing and path editing techniques Use Advanced Layers with Sub Layers Create and edit Symbols Create and edit Brushes Learn Power user shortcuts/workflow techniques Use Advanced colour, creating Colour Groups, colour management Use Advanced typography and text layout techniques Create 3D shapes Create 3D type Work with Gradient Mesh tool to create effects Add multiple effects to a single object Use Non-destructive design using Appearance Create and use Actions For the full course content please download the course information pdf listed above. Who is this course for? This course is perfect for experienced Illustrator users who want to learn how to make use of more of the applications powerful features and improve their workflow. Requirements Attendees should have a good working knowledge of Illustrator. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

During this 1 day Intermediate level InDesign course you will explore powerful layout and typographical controls, working with layers, creating multipage documents, using clipping paths and preparing for print. This course is ideal for anybody who already uses InDesign and wishes to progress to a professional level. Comprehensive colour management, typography and advanced graphics and effects are also covered.

Rhino Courses for Architects

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