2635 Courses in Cardiff delivered Live Online

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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 public, one to one, tailored and bespoke courses. Tailored in company 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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

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

Why Learn Revit V-Ray 3ds Max Visualization Training Course? Revit is perfect for architecture, and 3ds Max, with V-Ray rendering, offers super results. Autodesk Revit Interoperability integrates Revit and 3ds Max seamlessly, combining metadata, materials, and lighting. Architects and designers using 3ds Max tools for architectural designs. Check our Website Booking: 1-on-1 Duration: You can split these 40 hours over as many days, Mon to Sat between 9 am to 7 pm, or call 02077202581 to book In-person or Live Online Module 1: Revit Fundamentals (16 hours) Introduction to Revit: Acquaint yourself with Revit's essential concepts and tools. Interface and Workspace: Navigate Revit's interface and workspace seamlessly. Building Information Modeling (BIM) Workflow: Grasp the fundamental BIM workflow principles for effective modeling. Basic Building Model Creation: Learn to craft a foundational building model using Revit. Basic Modeling Techniques: Master elements like walls, doors, windows, floors, roofs, stairs, and railings. Advanced Revit Modeling: Dive into advanced topics, including family creation and working with intricate geometries. Annotation and Documentation: Enhance your projects with text, dimensions, schedules, and efficient printing/exporting methods. Module 2: 3ds Max Mastery (16 hours) Introduction to 3ds Max: Familiarize yourself with the core aspects and interface of 3ds Max. 3D Modeling Workflow: Understand the intricacies of creating basic 3D models in 3ds Max. Basic 3D Modeling Techniques: Work with primitive shapes, splines, and create complex 3D models. Materials and Textures: Explore the material editor, apply materials, and craft realistic textures. Lighting and Cameras: Learn to illuminate scenes, utilize the daylight system, and optimize camera angles. Module 3: V-Ray Rendering Proficiency (8 hours) Introduction to V-Ray: Grasp the fundamentals of V-Ray, including its interface and workflow. V-Ray Materials and Textures: Understand the intricacies of V-Ray materials and textures for lifelike renderings. Basic Rendering Techniques: Dive into essential rendering techniques, including lighting adjustments and global illumination. Advanced Rendering Methods: Explore advanced techniques to elevate the quality of your renders. Gain expertise in Revit, 3ds Max, and V-Ray through our comprehensive training, mastering the core concepts and advanced techniques necessary for stunning architectural visualizations.   Upon completing the course, you will: Master Architectural Modeling: Proficiently create intricate architectural models using Revit and 3ds Max. Visualize Realistically: Utilize advanced rendering techniques in V-Ray for lifelike visualizations with realistic lighting and materials. Efficient Documentation: Learn annotation and documentation skills for clear and effective project communication. Enhance Collaboration: Understand file interoperability for seamless collaboration with diverse software platforms. Build a Professional Portfolio: Create a diverse portfolio showcasing your skills in architectural visualization. Career Opportunities: Upon completion, you can pursue roles such as: Architectural Visualizer 3D Modeler Render Artist BIM Specialist Freelancer/Consultant Architectural Technician Visualization Trainer Mastering these tools opens doors to versatile career opportunities in architectural visualization. Download Revit Download 3ds max Download Vray Revit and 3dsMax V-Ray Visualization Training: Master architectural visualization with our intensive course blending Revit, 3dsMax, and V-Ray. Dive into modeling, materials, lighting, and rendering for photorealistic results. Course Highlights: Comprehensive Learning: Cover fundamental and advanced techniques in Revit and 3dsMax, enhancing your visualization skills. V-Ray Expertise: Explore advanced V-Ray rendering techniques, from global illumination to realistic material creation. Real-World Projects: Work on industry-relevant projects, building a portfolio of professional-grade visualizations. Flexible Learning: Choose in-person or live online sessions for interactive instruction and engaging discussions. Lesson Recordings: Access session recordings to review concepts, reinforcing your learning at your own pace. Lifetime Support: Enjoy lifetime email support for ongoing guidance from experienced instructors, ensuring your success beyond the course. Enroll now to transform your architectural designs into captivating visualizations, impressing clients with your skills and creativity. Join our training for a comprehensive learning experience, enhancing your expertise in Revit, 3dsMax, and V-Ray. Revit | 3ds max | V-Ray Course Benefits: Comprehensive Skill Set: Master Revit, 3dsMax, and V-Ray for exceptional architectural visualization, from basic modeling to advanced rendering. Realistic Rendering: Harness V-Ray's capabilities for lifelike visuals, covering global illumination, materials, and textures. Practical Experience: Work on industry-relevant projects, building a professional portfolio with hands-on exercises. Flexible Learning: Choose in-person or live online sessions for interactive instruction and discussion, tailored to your preferences. Review Resources: Access recorded class sessions to reinforce your knowledge and skills at your convenience. Lifetime Support: Enjoy lifetime email support from experienced instructors, ensuring ongoing guidance for your projects.

This course introduces the key concepts of the Internet of Things and cybersecurity. The course will provide an insight into the Internet of Things; the basics of cybersecurity; and describe a framework to protect IOT assets. This course will also examine real-world examples of IOT deployments and their cybersecurity, to highlight key lessons and key deployment actions that can be taken.

Endorsed by City & Guilds for the new 2020 2377 Electrical Equipment Maintenance and testing qualification, the course covers the requirements of the 5th Edition of The Code of Practice for the In‑Service Inspection and Testing of Electrical Equipment. The Code of Practice has been extensively updated and includes the requirements for managing and carrying out the in-service inspection and testing of electrical equipment. As part of the course, learners will have access to three practice examination tests in order to prepare for the City & Guilds In-Service Inspection and Testing of Electrical Equipment 2377. A certificate of completion is issued upon finishing the course which can then be presented to your local assessment centre in order to take the exam.

Duration 2 Days 12 CPD hours This course is intended for Professionals who manage teams and desire to understand what leads to conflict, help peacefully navigate team members through potentially antagonistic situations, encourage and empower others to disagree respectfully and productively, and effectively manage disputes between team members will benefit from this course. Overview Identify and manage sources of conflict Define an effective strategy to deal with conflict Implement a process to manage conflict situations Build civility in the workplace In this course, students will learn to recognize the warning signs that precede quarrels and how to mitigate their impact, as well as constructive ways to harness the differences between team members and shift them toward productive, positive outcomes. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Understanding conflict Identifying the Causes of Conflict Harnessing the Benefits of Conflict Resolving Conflict Understanding the Key People in Conflict Resolution 2. Civility in the Workplace Recognizing Uncivil Behavior Reaping the Benefits of Civil Behavior Working with Difficult People Identifying and Avoiding Incivility Creating, Implementing, and Enforcing a Civility Policy 3. Conflict Resolution Process Making an Effective Atmosphere Developing Mutual Understanding Focusing on individual and Shared Needs Getting to the Root Cause Generating Options Building a Solution 4. Conflict Resolution Strategies Differentiating Resolution Strategy Versus Process Recognizing the Advantages and Disadvantages to Collaborating, Competing, Compromising, and Avoiding Additional course details: Nexus Humans Constructive Conflict Management 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 Constructive Conflict Management 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.

Duration 2 Days 12 CPD hours This course is intended for Professionals who want to make the best decisions and develop creative and elegant solutions to challenging problems will benefit from this course. Overview Enable you to evaluate, identify, and distinguish between relevant and irrelevant information Engage critical thinking through curiosity and your ability to ask good questions Apply the eight best practices of critical thinking in practice Leverage open-mindedness to become more receptive and highly tuned for new ideas Students will learn to explore challenges, defy incorrect assumptions, and look at things with new and differing perspectives, incorporating these insights into your thought processes, and enabling them to find solutions to even the most difficult tasks. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. The Challenges of Modern Thinking Becoming a Rational Thinker Critical Thinking in Application Applying Reason Developing Open-Mindedness Stepping Out of Your Comfort Zone Avoiding Jumping to Conclusions Expecting and Initiating Change Being Ready to Adapt Thinking Logically 2. Critical Thinking Best Practices Listening Actively Evaluating Information Making Assumptions Watching Out for Bias Asking Clarifying Questions Performing SWOT Analysis Benefitting from Critical Thinking 3. Putting It All Together Changing Your Perspective Considering Other Viewpoints Dealing with New Information Solving Problems Identifying Inconsistencies Asking Why Evaluating the Solution Retaining Your New Skills Reflecting and Learning from Mistakes Asking Questions on an Ongoing Basis Additional course details: Nexus Humans Thinking with Critical Insight 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 Thinking with Critical Insight 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.

This comprehensive online interior design course includes 12 self study modules, and weekly 1:1 telephone and or video consultations. I will personally guide and inspire you through your creative learning journey.

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course is designed with the aim of showing the degree of integration necessary in developing an offshore petroleum discovery, from field appraisal to development. The 5 half-day VILT course gives a comprehensive account of the methodology, processes and techniques utilised in developing an offshore oil or gas discovery. Technically, integration of expected reservoir behavior, well planning and design, and facilities concepts and selection are exemplified through detailed case histories, group discussions and exercises. Commercial aspects related to overall project evaluation are also covered. Training Objectives Course participants will obtain a comprehensive understanding of key aspects of offshore field development, from appraisal through to development planning and leading up to sanction. The VILT course covers the three key elements: reservoirs, wells and facilities, and covers the integration of these with commercial aspects, and the required management aspects, including uncertainty and risk. Target Audience This VILT course is designed for project managers, field development and planning engineers, asset managers, petroleum engineers, reservoir engineers as well as field geoscientists and managers who have an interest in or are involved in field development feasibility and planning. In particular, this VILT course would be of interest to managers leading multidisciplinary and diverse functional teams. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Trainer 1: Your first expert course leader is a specialist in reservoir engineering, field development planning and petroleum management. Having worked for over 40 years in the petroleum industry, his most recent full-time position was Chief Operating Officer and Project Director for AED Oil and East Puffin (2007-09) for the Puffin offshore development, Timor Sea. Prior to his academic career (2001-2006), commencing in 2001 as head of the new School of Petroleum Engineering and Management at the UA, he worked for 16 years for BHP Petroleum (now BHP Billiton), most recently as Chief Reservoir Engineer for their worldwide operations. Other positions with BHP Billiton involved mainly technical and project management, and general management positions, including member of the BHP Board. He was project manager (feasibility) for two FPSO projects, the Skua and Griffin area fields, offshore Australia. He was also the Technical Manager for the Dai Hung project, offshore Vietnam where first oil was achieved in just 18 months from sanction. Before that time, he worked for Shell International (8 years) in the Netherlands, including two years as Senior Lecturer Reservoir Engineering at Shell's training centre and in Australia, seconded to Woodside Energy, with a key role in Australia's largest capital project (at the time), the Northwest Shelf Gas development. He started his career in Calgary, Canada, first with Hudson's Bay Oil and Gas and subsequently with the US consulting company, Scientific Software Corporation. He holds a BSc degree in Physics from the University of British Columbia and a MS degree in Nuclear Engineering from Stanford University. He has been an active member of the Society of Petroleum Engineers, including Director for the Asia-Pacific region (1996-98) and as a member of the Board. He was an SPE Distinguished Lecturer during 2001-02 and a PESA Distinguished Lecturer during 2002. He has lectured at many institutions and was a visiting professor at Stanford University in 2000. He has published over 50 papers on both technical and managerial topics. His professional interests are in optimal planning and project management of offshore petroleum discoveries. His primary research interests are in the area of special core analysis and the development of predictive models for reservoir characterisation. Trainer 2: Your other course leader is currently an independent consultant and trainer after 37 years in the upstream petroleum industry. His previous roles included Chief Geologist for GALP Energy, Consultant/ Head of Exploration for Qatar Petroleum, Technical/ Asset Manager for SASOL, and various technical and technical management roles in BHP Billiton Petroleum and Chevron. He managed/ executed many projects in diverse locations: West Grimes gas field development - California; Port Arguello heavy oil development - offshore California; exploration & development projects - Nigeria; Tengiz field early development, Korolev appraisal - Kazakhstan; Nkossa field development, Moho/ Bilondo exploration - offshore Congo; PNG divestment, Bayu-Undan LNG development - Australia; Ohanet acquisition, appraisal & development - Algeria; Pande development, Pande/ Temane gas plant expansion & near field exploration - Mozambique; Pre-Khuff (HP/HT) exploration, multiple blocks & operators - Qatar; Coral/ Mamba appraisal - Mozambique; Blocks 14/32 exploration & development - Angola; exploration & appraisal - onshore & offshore Brazil. He has an MSc in Geophysics from Stanford, an MBA from St. Mary's College of California, and a BSc in Geology (Honors) from Western Illinois University. He is a member of SEG, AAPG, SPE, PESGB, and PESA and is a Fellow of the Energy Institute (UK). His professional interests centre around deploying this extensive and international experience base to add value to future projects via training and consultancy, and to provide the leadership needed to execute, deliver, and ensure profitability of new projects. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations