3402 Design courses in Addlestone delivered Live Online

This Course is the DSL Course delivered via Zoom (it is the same as the face to face course but delivered via video conferencing and will be no more than 15 people at one time. There will be a training consultant taking delegates through the course and available to answer any questions throughout the course. This course will help you and you become familiar with the role and responsibilities of the designated safeguarding lead in your organisation. It will develop both your competence and confidence in carrying out the role of Designated Safeguarding Lead (DSL). Formally known as Level 3.

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

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/

The Level 1 Certificate in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.

Join a supportive small group of 3-5 members in monthly 90-minute sessions designed to deepen your Internal Family Systems (IFS) practice. These meetings provide a safe space to: Gain insights and perspectives on your clinical work Enhance your understanding of IFS principles Explore and work with your own internal parts as a therapist Share valuable resources and techniques £85 per month. Your booking covers the first month, with invoicing starting from the second month. Sessions are available on Wednesdays at 1:30 pm. Provided by Dr Maria Kaltsi, Clinical Psychologist, IFS Certified Therapist, currently on the ,consultant pathway, with experience of supporting IFS trainings (including L1 and L2 trainings). For more information, please contact: mariakaltsitherapy@gmail.com

Duration 2 Days 12 CPD hours This course is intended for Develop for experienced IT Professionals familiar with Citrix Virtual Apps and Desktops 7.1x in an on-premises environment. Potential students include administrators, engineers, and architects designing or deploying Citrix Virtual Apps and Desktops workloads on Microsoft Azure. Overview Prepare the Azure environment for secure integration with Citrix Virtual Apps and Desktops Deploy and manage Virtual Delivery Agent machines in Microsoft Azure using Machine Creation Services Integrate Citrix Cloud and Citrix Virtual Apps and Desktops with Microsoft Azure Active Directory Design Machine Catalogs and virtual machines on Microsoft Azure Resource Manager Provide remote access with Citrix StoreFront and Citrix Gateway on Microsoft Azur Students learn to deploy and manage the Citrix Virtual Apps and Desktops apps and desktops in Microsoft Azure. Students gain the skills to plan the machine catalog and virtual machine design based in Microsoft?s public cloud and get hands-on practice deploying those machines using Machine Creation Services. Students will also learn about additional Azure considerations including maintenance and power management which are critical in a cloud environment. For remote access, students will learn to configure Citrix StoreFront and Citrix Gateway on the Azure platform. This course focuses on Microsoft Azure as a Citrix Cloud resource location however concepts are relevant to both Citrix Cloud and fully managed Citrix Virtual Apps and Desktops sites. Citrix Virtual Apps and Desktops on Azure Overview Defining IAAS Citrix Virtual Apps and Desktops Azure Deployment Models Azure Fundamentals Review Azure Management Azure Locations Citrix Virtual Apps and Desktops Integration with Azure Active Directory Active Directory Basics Active Directory Usage Connecting On-premises Active Directory to Azure Azure Role Based Access Control Connecting to Microsoft Azure Azure Connectivity Cloud Connectors in Azure Creating Citrix Virtual Apps and Desktops Host Connections to Azure Deploying Apps and Desktops using Machine Creation Services Master Image Preparation Machine Creation Services in Azure Considerations for Deploying onto Azure Providing Access to End Users StoreFront Locations Citrix ADC Locations Multiple Citrix Virtual Apps and Desktops Zones in Azure Regions Maintaining Infrastructure and VDAs in Microsoft Azure Maintaining Infrastructure Maintaining Resources Power Management Plan for a Successful POC Planning your next steps

Duration 3 Days 18 CPD hours This course is intended for Security architects Design engineers Network engineers Cisco integrators and partners Overview After taking this course, you should be able to: Describe Cisco Identity-Based Networking Services (IBNS) for providing access control to corporate networks. Describe Extensible Authentication Protocol (EAP) authentication types and methods, and the role of Remote Authentication Dial-In User Service (RADIUS) in EAP communications. Describe how to configure Cisco Catalyst switches, Cisco Wireless LAN Controllers (WLCs), and Cisco ISE for 802.1X operation. Describe how to configure access for non-supplicant devices in an 802.1X deployment. Describe how to plan and deploy Cisco IBNS Networks with Cisco ISE and 802.1X. The Introduction to 802.1X Operations for Cisco Security Professionals (802.1X) v1.0 shows you how to configure and prepare to deploy Cisco© Identity-Based Networking Services (IBNS) solutions based on Cisco Identity Services Engine (ISE), Cisco Catalyst switches, and Cisco Wireless LAN Controllers. You will learn the fundamentals of the 802.1X protocol and configuration, Cisco IBNS, configuring access for non-supplicant devices, Cisco ISE deployment options, architectural components, considerations with 802.1X, and more. You will also gain hands-on experience configuring 802.1X?based network services using the Cisco Identity Services Engine and a Cisco Catalyst switch. Describing Cisco Identity-Based Networking Services Cisco IBNS Overview Authentication, Authorization, and Accounting (AAA) Role in Cisco IBNS Compare Cisco IBNS and Cisco ISE Solutions Explore Cisco IBNS Architecture Components Explore Cisco TrustSec Describing 802.1X EAP Authentication Explore the IEEE 802.1X Standard Explore 802.1X and EAP Explain EAP Methods Describe the Role of RADIUS in EAP Communications Configuring Devices for 802.1X Operation Identify 802.1X Components and Topologies Configure Cisco Catalyst Switch for 802.1X Compare IBNS 1.0 and 2.0 on Cisco Catalyst Switch Configure Cisco WLC for 802.1X Configure Cisco ISE for 802.1X Configure Supplicants for 802.1X Operation Configuring Access for Non-Supplicant Devices Configure Cisco IBNS for Non-Supplicant Devices Explore IBNS 2.0 for Non-Supplicant Devices Configure Cisco Central Web Authentication for Guests Designing Cisco IBNS Networks with Cisco ISE and 802.1X Cisco ISE Architectural Components Introducing the Cisco ISE Bring Your Own Device (BYOD) Process Identify Cisco ISE Deployment Options Identify Component Compatibilities with 802.1X Review 802.1X Design Considerations

Course Summary: This workshop is designed for Club Welfare Officers and it is highly recommended that attendees complete UK Coaching's Safeguarding and Protecting Children Workshop first. Are you new to the Welfare Officer role or has it been three years since you last attended a Time to Listen workshop? The 3 hour workshop covers the following and learners will be able to: Describe how a club welfare officer works with others to create a child centered environment. Explain how the club welfare officer role fits into the wider safeguarding environment. Apply learning to case studies including sharing good safeguarding practice.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners 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

The Professional Agile Leadership Essentials (PAL-E) is a 2-day hands-on workshop that uses a combination of instruction and hands-on exercises to help managers and other leaders who work directly with agile teams understand how to best support, guide, and coach their teams to improve their agile capabilities. Course Description Professional Agile Leadership Essentials (Scrum.org) Training ONLINE PAL E - Professional Agile Leadership Essentials Agile leadership has a lot to offer businesses today. Organizations have changed a great deal over the years and are no longer the static, structured entities they once were. Agile teams and agile leadership respond to these changes, offering a new way to achieve better results. PAL-E training is designed to help managers, and other leaders, understand how to approach an Agile transformation, and to guide teams to be successful.  Agile teams and leadership bring real benefit Agile organisations and teams thrive in unpredictable and changing environments. They are able to improve efficiency and react quickly to changing markets and customer needs. Achieving this is not something that just happens. The transformation to become an agile organisation is profound, requiring senior leaders, managers, and team members to change how they organise themselves and others, alongside how they work and measure results.  According to consultancy McKinsey: "the key to a successful Agile transformation is for leaders, particularly senior leaders, to develop substantially new mind-sets and capabilities." Scrum Training is a perfect first step in this. Professional Agile Leadership Essentials training The Professional Agile Leadership Essentials (PAL-E) course is a certified 2-day online workshop for team managers and leaders. It will show managers how to effectively develop, support, and guide agile teams to improve their performance. Agile teams are different from traditional structures. There is much more focus on continuous development and learning, as well as self-organisation. The course provides a foundation for managers' and leaders' roles in creating the conditions for a successful Agile transformation. Through detailed instruction and practical exercises, this course will teach leaders and managers how to form, support, and enhance Agile teams. It will guide them through the business, cultural and behavioural changes that must be made to take full advantages of the possibilities of Agile teams. PAL-E Course contents and key objectives The Professional Agile Leadership Essentials course will provide a solid grounding in the background and importance of agile leadership and how to apply it in leading teams.  The main content and learning includes: An understanding of what Agile is, the benefits and impact it can have on business, and the role a manager plays in achieving this. Challenges and techniques of Agile management, and the role management plays in an Agile organisation. How to develop and support Agile teams. How to measure and guide Agile product delivery, and an understanding of core problems in product development. An understanding of how to measure the benefits and impacts of agility in your organisation. Expected Outcomes from a PAL-E workshop PAL-E training highlights how Agile teams perform and the role of leaders and managers in establishing and developing their teams. Agile can help an organisation thrive through a framework that provides a flexible approach to challenges and problem solving. Thje Professional Agile Leadership Essentials course enables you to lead your teams and implement core Agile frameworks that deliver real business benefits. Who Should Attend This Course? Professional Agile Leadership essentials course is designed for leaders and managers in Agile organisations. It is suited to anyone responsible for setting up or establishing Agile techniques and for those managing teams and improving ongoing methods and techniques. After completing the course, participants can obtain industry-recognised certification. This will require passing a rigorous online assessment following the training. There are then plenty more courses that can take you further into Agile techniques. Scrum Master Training, for example, will guide participants through the industry-leading scrum framework for Agile practices. 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