3808 OV courses in Cardiff delivered Live Online

With over 140 clients, from FTSE 100 companies to small SMEs, from publishing to transport services, from central Government to Parish Council, we are well placed to provide GDPR consultancy services to all businesses, local authorities and charities.

The course is relevant to anyone requiring an understanding of the use of Agile or looking to adopt it. This includes, but is not limited to, organisational leaders and managers, marketing executives and managers, and/or all professionals working in an Agile environment, including software sesters, developers, business analysts, UX designers, project management office (PMO), project support and project coordinators.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Jamf training, Jamf 240 course, Jamf course

Exciting news! My popular 'Getting Started in Data Governance' course is making it's way across the pond! Due to numerous requests, I'm thrilled to announce that I will be hosting a U.S. edition of the course.

Why Learn 3ds Max Basic to Advanced Training Course? Learn 3ds max design and animation with our comprehensive 3ds Max Basic to Advanced Training Course. Whether you're a beginner or an experienced user, this course is thoughtfully designed to elevate your skills. Course Link Duration: 40 hrs Method: 1-on-1, Personalized attention & Tailored content. Schedule: 1-on-1 training with flexible scheduling. Book a convenient hour, Mon to Sat, from 9 am to 7 pm. Course Details: Course Duration: 40 hours Course Syllabus: Part 1: Introduction to 3ds Max and Vray Familiarization with the 3ds Max Interface Configuring an efficient workspace in 3ds Max Seamless navigation within 3ds Max and Vray Understanding the power of Vray and its interface Part 2: 3D Modeling Precision crafting of fundamental shapes Mastering modifiers for advanced modeling Creating intricate 3D models using diverse techniques Learning the art of polygonal modeling Shaping both organic and inorganic models flawlessly Part 3: Texturing Applying and refining textures with expertise Grasping the essentials of UVW mapping Harnessing material editor to perfection Customizing materials with Vray materials Part 4: Lighting Discovering the magic of illumination Differentiating various light types Comprehending the subtleties of light properties Setting up captivating scenes with Vray lights Part 5: Animation Embarking on an animation adventure Expertly setting up keyframes and animation curves Infusing life into objects in a mesmerizing 3D space Elevating animations with Vray's prowess Part 6: Advanced Rendering with Vray Entering the realm of rendering excellence Mastering Vray Global Illumination for realism Optimizing visuals with Vray Physical Cameras Illuminating scenes with Vray HDRI Lighting Employing Vray Proxies and Render Elements for finesse Streamlining rendering workflow with Vray's techniques Part 7: Projects Showcasing skills through hands-on projects Crafting a captivating yet simple interior scene Designing an alluring exterior scene Taking on the challenge of a complex scene with multiple elements Course Requirements: A computer with 3ds Max and Vray installed (trial versions are available on Autodesk and Chaos Group websites) Basic knowledge of computer operations Enthusiasm for 3D modeling and animation Course Objectives: Upon completing the course, you will have mastered 3ds Max and Vray, enabling you to create photorealistic 3D scenes. The skills acquired will open doors to opportunities in the 3D modeling and animation industry, while also serving as a foundation for further honing your expertise. Course Overview: Photoshop Post-Production Delve into the world of Photoshop post-production through our comprehensive course. Learn essential photo editing techniques, including color correction, retouching, and compositing. Unleash your artistic potential by creating mesmerizing visual effects and stylizing your photos. Course Syllabus: Part 1: Introduction to Photoshop Post-Production Navigating the Photoshop Interface with ease Mastering the art of Layers and Layer Masks Embracing the power of Selections Understanding the basics of Color Correction Part 2: Retouching Techniques Unraveling common Retouching Tools and Techniques Removing blemishes, wrinkles, and unwanted elements Achieving remarkable results with Dodging and Burning Part 3: Compositing Embracing the art of Compositing Working seamlessly with Multiple Images Blending images flawlessly using Layer Masks Part 4: Visual Effects and Stylizing Techniques Crafting Special Effects with Layer Styles and Blending Modes Enhancing images with Filters Achieving mesmerizing effects with Color Grading and Adjustment Layers Part 5: Projects Applying your knowledge to hands-on projects Perfectly Retouching a portrait Creating an alluring composite image Fashioning a stylized masterpiece Course Requirements: A computer with Photoshop installed (trial version available on Adobe website) Basic knowledge of computer operations Passion for photo editing and manipulation

Life coaching package 3 Months relationship guidance (Relationship analysis ascertaining problem areas) Relationship training programme Confidence and Styling / Beauty /Body confidence training 3 Gym sessions per week (1 hour PT session) (The personal trainer will put together a bespoke package for individual this part of the package is optional) M.D.D Whats app Service inclusive in this package. (Includes teeth whitening with celebrity dentist and 2x Harley Street beauty treatments) Get fit and healthy Overhaul your beauty regime Work on improving you and moving On to a new improved you. Learn how to be better in relationships and become a better partner. Find out what your wants and needs are in a relationship. Price on application https://relationshipsmdd.com/product/m-d-d-v-i-p-private-coaching-package/

The most imperative components of marriage are respect, communication, understanding, intimacy, core values and matched expectations. When any of these components become problematic we have a marriage that is in trouble. This package helps to restore a rocky marriage that is in danger of imploding. You will be assigned to a ICF/BACP qualified relationship coach to help you and your partner learn relationship skills over the course of 8 weeks The Gottman Method Emotionally focused therapy Relationship and Marriage counselling Improving communication skills Conflict Management Introspection tests for each spouse Cognitive behavioural therapy Relationship skills training Mediation Cognitive training Building trust and transparency Rebuilding the marriage foundation Eliminating family issues Examining spouses values, needs and requirements Unlearning negative marriage habits Concession Calls Couples Therapy Exercises 8 Week marriage care package for marriage breakdown WAS £1100 SPECIAL OFFER https://relationshipsmdd.com/product/marriage-relationship-counselling-service-package/

Introducing the Dating Profile Consultant Package: Expert Guidance for an Outstanding Online Dating Presence Are you looking to maximize the impact of your online dating profile and improve your chances of connecting with compatible matches? Miss Date Doctor’s Dating Profile Consultant Package offers you personalized support and insights from experienced consultants who specialize in optimizing online dating profiles. Crafting an effective online dating profile requires a strategic approach and understanding of what resonates with potential matches. Our dedicated dating profile consultants are here to assist you in creating a profile that showcases your unique qualities and attracts genuine connections. Here’s how the Dating Profile Consultant Package can support you: Personalized Evaluation: Our dating profile consultants will conduct a thorough evaluation to understand your personality, preferences, and dating objectives. Strategic Profile Enhancement: We’ll collaborate with you to strategically enhance your profile text, photos, and overall presentation. Photo Selection and Arrangement: Our experts will guide you in selecting and arranging photos that project a genuine and appealing image. Compelling Bio Creation: We’ll assist you in creating a compelling and authentic bio that piques the interest of potential matches. Showcasing Your Uniqueness: Our consultants will work with you to emphasize your unique qualities and values that make you stand out. Initiating Engaging Conversations: We’ll provide insights into starting conversations and maintaining engaging communication with your matches. Boosting Self-Confidence: The Dating Profile Consultant Package aims to boost your confidence by helping you create a polished and attractive profile. Attracting Compatible Matches: We’ll focus on attracting matches who align with your dating preferences and aspirations. The Dating Profile Consultant Package at Miss Date Doctor is designed to empower you with a refined and attention-grabbing online dating profile. Our experienced dating profile consultants offer personalized guidance and practical tips to help you make a lasting impression in the online dating world. Invest in your online dating success and take the first step towards an optimized dating profile with the Dating Profile Consultant Package. Embrace the opportunity to present your best self and attract matches that resonate with your personality and interests. Let our consultants guide you towards an elevated online dating experience filled with meaningful connections. 15 pictures AI approved dating app high standard excellence photos 4×1 hour sessions https://relationshipsmdd.com/product/dating-profile-consultant/

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