6951 Courses in Cardiff delivered Live Online

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

Why Choose Revit Basic to Fundamentals Course Course Link In this course you will learn Revit skills for BIM modeling. In-person or live online. Autodesk Revit Architecture training for students to create full 3D architectural project models and set them up in working drawings. Duration: 10hours Method: 1-on-1 method with tailored content and flexible pace, backed by individual support. Schedule: Choose a convenient hour from Mon to Sat between 9 am and 7 pm to create your own schedule. Revit Essentials Training: Learn Revit fundamentals for architecture and structural design, supporting efficient building construction with BIM workflows. Delivery Options: In-class at our center Live online sessions I. Introduction to Revit  Overview of Revit and its uses Revit interface and basic tools Navigation and viewport controls Creating and saving projects II. Setting up a Project  Creating a new project Setting up project levels and grids Adding site and building information Setting up project units III. Creating Building Elements  Creating and modifying walls Adding doors and windows Creating and modifying floors and ceilings Creating roofs and modifying roof shapes Creating stairs and railings IV. Views and Sheets  Creating and managing views Creating and managing sheets Adding schedules and tags Creating construction documents V. Annotation and Detailing  Adding text and dimensions Creating and modifying detail components Adding symbols and keynote legends Adding annotations to construction documents VI. Conclusion and Next Steps Review of course content Tips for further learning and resources Q&A and feedback Note: The above course outline is just a suggestion, and the course content and duration can be adjusted according to the needs and level of the learners. Detailed Course Outline. 1. Starting a Project Creating a new project and the importance of a template. Understanding project settings and scales Adding levels Adding grids Adding columns 2. Modeling Basics Adding walls Using snaps Wall properties and wall types Using the modified tools Adding doors and windows Using constraints See: Autodesk Seek and Revit City websites 3. Links, Imports, and Groups Working with DWG files Creating topography from a DWG link Understanding CAD inserts Using import tips Creating a group Working with Revit links Managing links 4. Sketch-Based Modeling Components Working with floors Working with roofs Adding openings Working with stairs Working with railings Working with ceilings 5. Complex Walls Creating a custom basic wall type Adding curtain walls Adding curtain grids and mullions 6. Visibility and Graphics Controls Using object styles Working with visibility/graphic overrides Using Hide/Isolate Understanding view range Using the Linework Using cutaway views 7. Rooms Adding rooms Controlling room numbering Understanding room bounding elements 8. Schedules and Tags Understanding tags Adding schedules Modifying schedules Creating a key schedule 9. Annotation and Details Adding text Adding dimensions Adding symbols Adding legend views Creating a detail callout Using detail components Adding filled and masking regions 10. The Basics of Families Understanding familiesUsing reference planes, parameters, and constraints Adding solid geometry Adding void geometry Completing the family 11. Sheets, Plotting, and Publishing Adding sheets Exporting to AutoCAD and JPG

Why Choose 3ds Max Basics Training Course? Click for more info What am I going to get from this course? Create your own models in 3ds Max; Use built in poly modelling tools to create basic 3D objects. Learn everything you need about 3ds Max with this guide, from the basics of modelling and animation to more advanced steps.  Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. 3ds Max Basic Training Course: Course Name: 3ds Max Basics Training Course. Core Skills for 3D Modeling, Rendering, Animations, and Games. Target Audience: Beginners and new users from diverse industries, including architects, interior designers, engineers, game developers, artists, and animators.Course Outline: 3D Modeling and Animation with 3ds MaxI. Introduction to 3ds Max- Course overview and objectives - Navigating the user interface - Basic settings and preferencesII. Creating 3D Objects- Building simple shapes with primitive objects - Craft complex designs using Editable Poly - Enhancing objects with modifiers - Applying materials and textures for realistic effectsIII. Lighting Techniques- Illuminating scenes with different light sources - Exploring various types of lighting - Adjusting light properties for desired effects - Casting shadows to enhance realismIV. Camera Control- Creating and configuring camera views - Fine-tuning camera settings for optimal shots - Animating cameras for dynamic scenesV. Animation Fundamentals- Mastering keyframe animation techniques - Utilizing the time slider and track view - Animating object transformations - Adding movement to materials and texturesVI. Rendering Process- Configuring render settings for high-quality output - Selecting appropriate output formats - Streamlining rendering with batch processing - Enhancing final renders with post-processing effectsVII. Project-Based Learning- Applying acquired skills to complete a final project - Exercising creativity and problem-solving abilities - Integrating modeling, animation, lighting, and rendering into the projectIn-Depth Course Outline:1. Modeling- Edit Poly Modeling: Extrude, Chamfer, Cut, and Slices - Symmetry Mirror Modeling - Designing a Table and Chair - Creating a Basic House Model - Working with Lines and Shapes - Importing Plans from AutoCAD/Vectorworks - Crafting Interior Spaces - Adding Doors, Windows, Railings, and Trees - Implementing Stairs2. Modifiers- Exploring Compound Objects - Utilizing Connect, Scatter, Pro Boolean, Loft, and Terrain Modifiers - Manipulating Bend, Taper, Twist, Stretch, Skew, FFD, Wave, Ripple, and Lattice - Employing the Lathe Modifier for Curved Objects3. 3ds Max Basic Lights- Mastering Omni, Spot, and Direct Lights for Illumination4. 3ds Max Camera- Understanding Free and Target Cameras for Optimal Shots5. Texturing and Rendering- Applying Diffuse and Bump Mapping Techniques - Integrating Environment and Background Images - Configuring Render Settings for High-Quality Images - Lighting and Rendering Scenes in 3ds MaxAre you ready to take your 3D modeling and animation skills to the next level? Download the 30-day free trial of 3ds Max from Autodesk and embark on a transformative learning journey today. Explore the possibilities and unleash your creative potential!

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

Why Choose Lumion 3d Realtime Rendering Training Course? Course Link Our Lumion Course is best for materials, lighting, and animation skills. Learn high-quality rendering using Lumion's asset library. In-person or live online sessions with lifetime access to recordings and email support. Unleash Lumion's potential for immersive architectural visualizations. 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 What is Lumion? Lumion is specialized 3D rendering software designed for architects and designers. With Lumion, you can quickly bring your 3D design models to life, add materials, furnish interiors and exteriors, and showcase the impact of lighting and shadows without the need for specialized training. Objectives of the Course The course aims to teach you how to start Lumion projects, add environments, cameras, illuminations, populate scenes with various elements, create terrains, and produce animations. Lumion 3D Course Outline Module 1: Introduction to Lumion 3D Discovering Lumion 3D's capabilities and interface navigation. Learning shortcut keys for efficient workflow. Customizing settings for optimal performance. Module 2: 3D Models and Materials Importing 3D models in various formats. Applying and tweaking materials. Creating procedural materials and glass effects. Troubleshooting common issues. Module 3: Creating a Project in Lumion Building scenes and sculpting terrain. Enhancing realism with alpha and height maps. Module 4: 3D World Managing multiple 3D objects and their properties. Implementing grass and scattering elements. Module 5: Lighting in Lumion 3D Utilizing weather settings for dynamic scenes. Understanding Lumion lights and interior/exterior illumination. Creating 3D reflections and spotlights. Module 6: Realistic Visualizations Incorporating special effects like fire, smoke, and fog. Achieving realism with camera effects and shadows. Rendering still images and animations. Module 7: NPR Visualizations Creating non-photorealistic visualizations with artistic effects. Implementing unique styles for enhanced visuals. Module 8: Artistic Effects in Lumion 3D Exploring conceptual visualizations with painting and sketch effects. Creating cartoon effects and understanding perspectives. Module 9: Animation in Lumion 3D Timing and working with cameras for dynamic shots. Composing animation clips and adding effects. Utilizing layers and control objects for precise control. Module 10: Advanced Features Import and output formats in Lumion. Expanding assets with the 3D model library. Adding animated characters and sound effects. Utilizing the advanced material library. Controlling environment and weather for dynamic scenes. Scene management and movie editing within Lumion 3D. Lumion for Students | Unleash Your Creativity https://lumion.com› product › students Unlock the full potential of your designs with Lumion for students. Request your free 1-year Student license now and bring your visions to life!

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.

Why Learn Vray for 3ds max Training Course? Course Link 3ds Max - Rendering with V-Ray training offers an extensive master class in utilizing V-Ray, a widely used tool in architecture, interior design, film, and various industries. Topics covered include lighting techniques for interiors using both natural and artificial light sources. Duration: 10 hrs Method: 1-2-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. Module 1: Introduction to Vray for 3ds Max (2 hours) Learn the purpose and advantages of Vray for 3ds Max. Install and set up Vray for 3ds Max. Get familiar with the Vray interface and workflow. Understand Vray materials and their usage in 3ds Max. Module 2: Lighting with Vray (2 hours) Explore lighting techniques using Vray in 3ds Max. Work with different types of Vray lights and their settings. Create and control Vray sun and sky for outdoor scenes. Utilize Vray dome lighting for interior scenes. Learn about IES lights in Vray and their usage. Establish an efficient lighting workflow with Vray. Module 3: Vray Camera (2 hours) Understand Vray camera settings and their impact on renders. Control exposure and use Vray depth of field. Create camera animations with Vray for dynamic shots. Explore Vray frame buffer functionalities for post-processing. Module 4: Vray Materials (2 hours) Learn about properties and settings of Vray materials. Create realistic and visually appealing materials with Vray. Save and organize custom Vray material libraries. Use Vray material overrides for efficient material changes. Module 5: Vray Rendering and Post Production (2 hours) Get an overview of Vray rendering settings for high-quality output. Render still images and animations using Vray. Enhance Vray renders in Photoshop with post-production techniques. Utilize Vray frame buffer for fine-tuning renders. Composit Vray render elements in Photoshop for added control. Work with Vray denoiser for noise reduction in renders. You can access the free trial of Vray for 3ds Max here: (https://www.chaosgroup.com/vray/sketchup/free-trial), material libraries here: (https://www.vray-materials.de/), and textures here: (https://textures.com/).

Why Choose Twinmotion Realtime Rendering Training Course? Click here for info Empower architects, designers, and visualization experts with our Twinmotion training. Learn tools, materials, lighting, animation, and rendering. Explore advanced techniques for lifelike landscape and special effects using Twinmotion's asset library. Opt for in-person or live online sessions. 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 Twinmotion Real-time 3D Architecture Visualization Course Outline: Module 1: Introduction to Twinmotion Explore Twinmotion's real-time 3D visualization capabilities Master the Twinmotion interface for efficient scene manipulation Prepare 3D files for import and manage the workflow Module 2: Materials and Realism Enhance scenes with realistic materials and visual quality Utilize videos as materials and apply glow effects Create grunge materials for added texture and realism Employ the X-ray material for specific visualization needs Module 3: Landscape and Vegetation Integrate vegetation using Twinmotion's scatter, HQ trees, and growth features Customize grass and utilize HQ vegetation assets for realism Create time-lapse effects for vegetation growth Module 4: Library and Object Import Access the Twinmotion library for furniture and objects Seamlessly import external 3D objects Obtain high-quality 3D assets from the internet and add to the user library Utilize BIM-objects for additional assets Module 5: Lighting and Animation Work with various lighting options, including area light and volumetric light Add animated characters and vehicles for dynamism Incorporate construction vehicles and aircraft for realism Module 6: Volumes and Interactivity Utilize volumes and the animator feature for dynamic scenes Implement urban elements and measurement tools for accuracy Module 7: Nature and Weather Effects Utilize Twinmotion's nature features, including physical sky and weather effects Create realistic lighting for outdoor scenes Add ocean effects for water elements Module 8: Rendering Techniques Master rendering processes, from creating images to exporting panoramas and animations Implement depth of field improvements for captivating visuals Create BIM motion virtual reality phases for immersive experiences Utilize the Twinmotion presenter feature for streamlined presentations Module 9: Final Project Apply knowledge and skills to complete a final render project in Twinmotion Download Twinmotion https://www.twinmotion.com › download Learn how to download and install Twinmotion, the fast, easy real-time archvis tool.

EUSR SHEA Core Qualification – Safety, Health & Environmental Awareness The EUSR SHEA Core Qualification (Safety, Health and Environmental Awareness) is a foundational training programme that provides essential health, safety, and environmental understanding for individuals working across a wide range of industries, including utilities, construction, and engineering. Developed by Energy & Utility Skills, the SHEA Core qualification is recognised nationally and forms the basis of all SHEA schemes. It delivers a strong grounding in workplace safety principles and prepares learners for more specialised SHEA sector schemes such as SHEA Water, SHEA Gas, SHEA Power, and SHEA Waste & Resource Management.