2175 Courses in Cardiff delivered Live Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

Gain robust techniques for obtaining feedback from end users throughout product design, and learn how to identify new opportunities for design improvement.

Autocad face to face training customised and bespoke Online or Face to Face

Why Choose Vray for Architects and Interior Designers 3ds max or Sketchup Training Course? Click here for info Achieve stunningly realistic renders with our tailored course in V-Ray. Designed for experienced SketchUp and 3ds max users, this advanced training covers model preparation and rendering techniques, customized to your skill level and preferences. 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. SketchUp is renowned for its user-friendly interface and widespread usage in 3D modeling. Now, with V-Ray for SketchUp, users can take advantage of a powerful rendering tool for unparalleled visualization quality and realism. V-Ray seamlessly integrates into the SketchUp environment, allowing for efficient rendering within your existing workflows. Our course is ideal for those seeking to enhance their SketchUp proficiency by incorporating V-Ray's potent rendering capabilities for 3D models. We adapt the training to your current skill levels in both SketchUp and V-Ray and tailor the content to your modeling requirements and desired rendering quality. V-Ray Rendering Training Course. Course Duration: 10 hours Course Description: This 10-hour course enhances rendering skills with V-Ray, a leading 3D visualization engine. Participants master photorealistic renders, focusing on lighting, materials, and post-production. Covering key concepts, workflow, lighting techniques, material creation, rendering settings, and post-processing, the course ensures stunning visual results. Course Outline: Module 1: Introduction to V-Ray Rendering (1 hour) Overview of V-Ray and its role in 3D rendering Understanding the rendering workflow Setting up V-Ray for your 3D software platform Module 2: Essential Rendering Concepts (1 hour) Understanding global illumination and its impact on renders Exploring image sampling and antialiasing techniques Introduction to render elements for post-processing Module 3: Lighting Techniques (2 hours) Mastering various lighting types in V-Ray Creating natural lighting with HDRI maps Implementing artificial lighting with V-Ray lights Achieving realistic daylight with V-Ray sun and sky Module 4: Material Creation (2 hours) Creating realistic materials using V-Ray material editor Applying textures and procedural maps for added realism Understanding material reflections and refractions Advanced techniques for materials like glass, metal, and fabric Module 5: Rendering Settings and Optimization (1.5 hours) Exploring V-Ray rendering settings for different scenarios Understanding render output options and resolution settings Efficiently using V-Ray distributed rendering for faster results Module 6: Post-Processing with Photoshop (1.5 hours) Enhancing renders through post-processing techniques Compositing render elements for added control Adjusting colors, contrast, and lighting in Photoshop Adding effects and final touches to achieve photorealism Module 7: Advanced Rendering Techniques (1 hour) Working with V-Ray proxies and instancing for complex scenes Utilizing V-Ray displacement for intricate detailing Understanding depth of field and motion blur effects Module 8: Real-World Project (1 hour) Applying the skills learned to complete a real-world rendering project Guidance and feedback from the instructor

A workshop for independent schools that are inspected by Ofsted. Providing a proven strategy for ensuring compliance with the independent school standards.

Introduction to web development with React. 30 Hour course over 5 weeks.

Duration 5 Days 30 CPD hours This course is intended for System installersSystem integratorsSystem administratorsNetwork administratorsSolution designers Overview After taking this course, you should be able to:Describe the Cisco IOS XR software architecture, high availability components, and scalability featuresPerform basic configurations on a Cisco IOS XR routerDescribe Cisco IOS XR software operationsDescribe the configuration file systemPerform Cisco IOS XR software installationsConfigure AAA servicesConfigure NTPConfigure Simple Network Management Protocol (SNMP), telemetry, and loggingConfigure routing protocolsMonitor processesUse error messages and core dumps he Introduction to Cisco IOS XR (IOSXR100) v2.0 course introduces you to the features and functions of the Cisco© Internetwork Operating System (Cisco IOS©) XR Software operating system. You learn the fundamental concepts on which the operating system is based and Cisco IOS XR basic operations, system administration, and troubleshooting. Cisco IOS XR Software Overview Platform Overview Cisco IOS XR Architecture Cisco IOS XR High Availability Cisco IOS XR Software Configuration Basics Cisco IOS XR Configuration Operations Cisco IOS XR Initial Configuration Reviewing the Configuration Cisco IOS XR Software Operations Examining Configuration Operations Examining Configuration Rollback and Recovery Configuration File System Overview Examining the Binary Configuration Examining the Commit Database Examining the ASCII Configuration Examining the Nonvolatile Generation (NVgen) Files Verifying Cisco Fabric Services (CFS) Integrity Cisco IOS XR Software Installation Software Package Basics Installing Software Packages AAA Security AAA Fundamentals Task-Based Security Configuring a User Security Policy Authentication with Remote Servers Configuring Router to AAA Server Communication Configuring Authentication Terminal Access Controller Access-Control System Plus (TACACS+) Command Authorization Configuring Accounting AAA Troubleshooting Network Time Synchronization Network Time Protocol SNMP, Telemetry, and Logging Examining SNMP Examining Telemetry Examining Logging Basic Routing Configuration Configuring Intermediate System to Intermediate System (IS-IS) Configuring Open Shortest Path First (OSPF) Configuring Border Gateway Protocol (BGP) Configuring Routing Protocol for LLN (RPL) Policy Packet Filtering Access Control Lists Unicast Reverse Path Forwarding Management Plane Protection Monitoring Process Examining Processes and Threads Process Crashes Commands for Debugging Processes Restartability of Processes Process Monitoring Identifying Memory Problems Memory Depletion Core Dumps Core Dump Fundamentals Using Core Dump Information Additional course details: Nexus Humans Cisco Introduction to Cisco IOS XR v2.0 (IOSXR100) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Introduction to Cisco IOS XR v2.0 (IOSXR100) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Unity 3d face to face training customised and bespoke.

Who is this course for? 3ds Max Basics Training Course. This course is designed for beginners and enthusiasts looking to learn the fundamentals of 3ds Max. Whether you're a budding 3D artist, designer, or hobbyist, this training course provides a comprehensive introduction to the basics of 3ds Max. Click here for more info: Website Duration: 10 hrs Method: 1-on-1 and 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. Course Outline: 3D Modeling and Animation with 3ds Max I. Introduction to 3ds Max - Course overview and objectives - Navigating the user interface - Basic settings and preferences II. 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 effects III. Lighting Techniques - Illuminating scenes with different light sources - Exploring various types of lighting - Adjusting light properties for desired effects - Casting shadows to enhance realism IV. Camera Control - Creating and configuring camera views - Fine-tuning camera settings for optimal shots - Animating cameras for dynamic scenes V. Animation Fundamentals - Mastering keyframe animation techniques - Utilizing the time slider and track view - Animating object transformations - Adding movement to materials and textures VI. Rendering Process - Configuring render settings for high-quality output - Selecting appropriate output formats - Streamlining rendering with batch processing - Enhancing final renders with post-processing effects VII. 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 project In-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 Stairs 2. 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 Objects 3. 3ds Max Basic Lights - Mastering Omni, Spot, and Direct Lights for Illumination 4. 3ds Max Camera - Understanding Free and Target Cameras for Optimal Shots 5. 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 Max Upon completing our 3ds Max Basic Training Course, participants will: Master Fundamental 3D Modeling: Acquire proficiency in basic 3D modeling techniques, including object creation and manipulation. Texturing and Material Application: Learn the art of texturing and applying materials to 3D models for realistic rendering. Essential Lighting and Rendering Skills: Understand fundamental lighting principles and rendering techniques to create visually appealing scenes. Basic Animation Knowledge: Grasp the basics of animation, including keyframe animation and movement principles. Scene Composition and Camera Setup: Learn how to compose scenes effectively and set up cameras for different perspectives. Recommended Resources: Official Autodesk Documentation: Explore Autodesk's official website for 3ds Max documentation, including tutorials, user guides, and forums for troubleshooting. Books: Consider essential reads like '3ds Max For Dummies' by Kelly L. Murdock or '3ds Max 2022 Essentials' by Randi L. Derakhshani and Dariush Derakhshani for detailed guides on mastering the software. By utilizing these resources, participants can further enhance their 3ds Max skills and stay updated with the latest industry trends and techniques." Skills Acquired: Fundamental 3D Modeling Techniques in 3ds Max Texturing and Material Application Skills Lighting and Rendering Fundamentals Animation Basics and Keyframe Animation Introduction to 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 Basic Training 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." Step into Personalized Learning with Us! Why Choose Us? Our Exclusive Benefits: Tailored One-on-One Training: Experience personalized coaching from skilled architects and designers, either face-to-face at (SW96DE) or via live online sessions. Sessions are available Monday to Saturday, 9 am to 7 pm. Customized Tutorials: Take home unique video tutorials crafted to elevate your learning experience. Comprehensive Learning Resources: Access a digital reference book for thorough revision, ensuring you grasp every concept effectively. Free Ongoing Support: Enjoy continuous post-course assistance via phone or email, ensuring your success extends beyond the class. Flexible Syllabus: We adapt syllabus and projects to match your specific needs, ensuring you learn exactly what matters most to you. Official Certificate: Certificate upon completing the course. Why Us? Personalized Learning Support: Our courses, ranging from 10 hours to 120 hrs Diploma training Courses, provide unwavering support at every stage. With personalized homework assignments and free after-course assistance, we pave the way to mastering software with unparalleled guidance. Individual Attention, No Crowded Classrooms: Bid farewell to overcrowded classrooms. Experience the intimacy of one-on-one learning. This ensures you receive the undivided attention you deserve, creating a confident and comfortable learning environment. Financial Flexibility: Embarking on your educational journey shouldn't be a financial burden. We offer a range of payment plans tailored to your needs. Explore the available options and embark on your learning adventure today. Expert Instructors, Real-world Expertise: Our instructors are meticulously chosen experts, renowned for their extensive industry knowledge and passion for teaching. They are dedicated to imparting invaluable skills to anyone eager to learn. Download 3ds max. Autodesk Download a free 30 day trial of 3ds Max

The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.