1137 Systems courses in Cardiff delivered Live Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included

Going the digital experience research route? Learn how a human centric approach to digital transformation results in a positive experience for all involved.

This course leads to the Mediterm Advanced Certificate in Medical Terminology (Level 3), the highest qualification in Medical Terminology, and can be studied flexibly over 20 weeks

Autocad face to face training customised and bespoke.

Being safe at the workplace should be a priority for any business. Come to Knight Training to train with us and start working safe with our IOSH Managing and Working Safely Course!

Agile techniques and management frameworks are changing the way organisations operate. Evolving to realise that organisations are no longer static and structured entities is the key to unlocking new ways to achieve better results. Agile can be utilised at an organisation, team, and project level. Transforming to an Agile way of working requires knowledge, commitment, and frameworks to lead change. The Applying Professional Scrum training teaches key implementation techniques and Scrum frameworks. Course Description Applying Professional Scrum Training ONLINE Getting results with the Scrum framework Scrum is the most used Agile framework for complex product development and project management. It is a proven system, in use for over 25 years by companies large and small. Scrum training introduces an iterative and incremental approach to product or project development – aiming to reduce complexity and achieve results faster. A Scrum team works simultaneously rather than sequentially, with more flexibility. Scrum teams learn to work better together, delivering more value for project stakeholders. Applying professional scrum training The Applying professional Scrum (APS) course introduces the Scrum framework and demonstrates its power over traditional approaches to project or product development. It is an interactive course that aims to familiarise participants with its iterative and 'Sprint' based methodology. The Scrum framework is commonly used in software development but is relevant in any industry or to any complex project. Course contents and key objectives The course will teach participants how to apply Professional Scrum and the Scrum framework. It is appropriate for anyone, whether or not they have previous exposure to Scrum. Contents of the two-day course include: Understanding more about Agile development and the value that an Agile mindset can bring. Explain how Scrum differs from traditional work models and the advantages this offers. Explain the details of the Scrum methodology and its practical application. Understand how to apply Scrum to projects and teamwork. This includes the concepts of the Scrum team, Sprints, Sprint reviews, and the Daily Scrum. Course attendees will work in Scrum teams to simulate a Scrum project. This will involve a series of 'sprints' to solve complex problems and demonstrate the Scrum approach's power. Such Sprints are key to the Scrum framework. They bring in the iterative way of working, giving teams the chance to review success and quickly adapt to meet business requirements. As part of this practical approach, participants will learn to recognize and understand common missteps and misunderstandings when using Scrum. Expected Outcomes from Applying professional scrum training Applying professional scrum training will teach attendees what Scrum is, the value it can deliver, and how to implement it. The practical and example-based nature of the course will help develop a thorough understanding of the Scrum framework. Experience is the key to implementing it in practice. As such, the course is designed to mimic this and teach the problems to look out for and their solution. Participants will emerge as proficient Scrum practitioners – ready to transform the development of their projects. Who Should Attend This Course? Scrum is beneficial for any company, or individual, with complex projects or products. This course provides an introduction and solid grounding in Scrum, enabling participants to work effectively within the Scrum team and to go on to further training if desired. It is ideal for anyone: Working in or joining a team that uses Scrum. Considering the use of Scrum or investigating its benefits. Working alongside or managing Scrum teams – even if not using the methodology directly. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Who is this course for? Mastering 3ds Max: Complete Basic to Advanced Training. Looking to learn 3D modelling and animation? Look no further than our comprehensive 3ds Max beginner course! Gain a strong foundation in 3ds Max and learn essential skills for creating stunning 3D models and visualizations. Check our Website Training Duration: 40 hours Method: 1-on1 Sessions and Customized Content. Schedule: Choose your preferred time slot between 9 am and 7 pm, Mon to Sat, tailored to fit your schedule. Course Title: 3ds Max and V-Ray Comprehensive Training Program (40 Hours) Course Overview: Dive deep into the world of 3D visualization and rendering with our intensive 3ds Max and V-Ray training program. Over the course of 40 hours, you'll master the fundamental concepts, advanced techniques, and practical applications of both 3ds Max and V-Ray, empowering you to create stunning, photorealistic visualizations for various industries. Course Outline: Module 1: Introduction to 3ds Max (8 hours) Understanding the 3ds Max interface and tools Basic 3D modeling techniques and workflows Material creation and texture mapping Lights and cameras setup for scenes Module 2: Advanced 3ds Max Techniques (8 hours) Character modeling and animation Particle systems and dynamics Advanced lighting and shading techniques Scene composition and camera animation Module 3: V-Ray Fundamentals (8 hours) Introduction to V-Ray rendering engine V-Ray materials and texture mapping Lighting with V-Ray lights and HDRI maps V-Ray camera settings and depth of field Module 4: Advanced V-Ray Rendering (8 hours) Global illumination and image-based lighting V-Ray proxies and instancing Advanced V-Ray shaders and displacement maps Render elements and post-production techniques Module 5: Architectural Visualization with V-Ray (8 hours) Interior and exterior scene setup Realistic materials for architectural elements Lighting strategies for different times of the day Creating lifelike environments and atmospheric effects Course Features: Hands-On Learning: Engage in practical exercises and real-world projects to reinforce your skills and knowledge. Industry-Standard Tools: Work with the latest versions of 3ds Max and V-Ray, widely used in the professional 3D visualization industry. Expert Instruction: Learn from certified trainers and industry professionals with extensive experience in 3D modeling and rendering. Project-Based Assessments: Apply learned techniques to comprehensive projects, receiving feedback and guidance to refine your skills. Flexible Learning: Choose between in-person and online sessions, accommodating various schedules and learning preferences. Upon completing this 40-hour course, you will be equipped with the expertise to create visually stunning 3D renderings and animations, making you proficient in both 3ds Max and V-Ray for a successful career in architectural visualization, gaming, film production, and more. Upon completion, participants will: Master 3ds Max & V-Ray: Acquire advanced skills in 3ds Max and V-Ray for creating realistic 3D visualizations. Expert in Architectural Visualization: Specialize in architectural visualization techniques, ideal for interior designers and architects. Project-Based Proficiency: Apply learned skills to real projects, developing a professional portfolio. Recommended Jobs: Architectural Visualization Artist 3D Animator Product Visualization Specialist Interior Designer VR Developer Freelance 3D Artist Game Environment Artist Visualization Consultant This training opens doors to diverse roles in architecture, gaming, design, and more. Duration: 40 Hours Focus: Master 3ds Max and V-Ray for advanced 3D visualizations and architectural rendering. Learning Format: One-on-One Training for personalized attention. Availability: Book your sessions Monday to Saturday, 9 am to 7 pm, tailored to your schedule. Outcome: Expertise in 3ds Max, V-Ray, and specialized architectural visualization skills. Practical Focus: Hands-on projects and real-world applications for skill reinforcement. Certification: Upon completion, receive a certificate showcasing your advanced 3D modeling and rendering skills. This one-on-one course offers tailored training sessions from Monday to Saturday, 9 am to 7 pm, ensuring personalized attention and flexibility to suit your schedule. Download 3ds max Ongoing Email Support: We offer continuous email assistance, ensuring your queries are promptly addressed even after the course completion. Comprehensive Resources: Access extensive handouts and valuable documents designed to reinforce your learning experience. Flexible Financial Options: Explore adaptable financial support options, including installment plans and assistance through job center plus and DWP. Reach out to us for specific details. Satisfaction Guarantee: Although it's highly improbable given our exceptional quality and skilled tutors, if you find dissatisfaction after your initial session, we will promptly address your concerns. If necessary, a refund may be provided (Terms and conditions apply). Optimized Software Experience: Receive guidance on optimizing your computer for enhanced software performance in applications like Autocad, 3ds Max, and Photoshop, whether you're on MAC or PC platforms. Industry Connections: Leverage our industry ties as we actively showcase your portfolio to potential employers. Many of our students have secured jobs through our recommendations, offering valuable career opportunities.

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 Certificates Certificates Certificate of completion Digital certificate - Included

Participants gain a foundational understanding of the UX design process, tools and techniques through an engaging mix of theory and practical application exercises.

Realistic rendering course with 3ds max and Arnold.