2437 Courses delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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 This in an introductory-level class for intermediate skilled team members. Students should have prior software development experience or exposure, have some basic familiarity with containers, and should also be able to navigate the command line. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert facilitator, students will explore: What a Kubernetes cluster is, and how to deploy and manage them on-premises and in the cloud. How Kubernetes fits into the cloud-native ecosystem, and how it interfaces with other important technologies such as Docker. The major Kubernetes components that let us deploy and manage applications in a modern cloud-native fashion. How to define and manage applications with declarative manifest files that should be version-controlled and treated like code. Containerization has taken the IT world by storm in the last few years. Large software houses, starting from Google and Amazon, are running significant portions of their production load in containers. Kubernetes is an open-source system for automating deployment, scaling, and management of containerized applications. This is a hands-on workshop style course that teaches core features and functionality of Kubernetes. You will leave this course knowing how to build a Kubernetes cluster, and how to deploy and manage applications on that cluster. Getting Started Our sample application Kubernetes concepts Declarative vs imperative Kubernetes network model First contact with kubectl Setting up Kubernetes Working with Containers Running our first containers on Kubernetes Exposing containers Shipping images with a registry Running our application on Kubernetes Exploring the Kubernetes Dashboard The Kubernetes dashboard Security implications of kubectl apply Scaling a deployment Daemon sets Labels and selectors Rolling updates Next Steps Accessing logs from the CLI Managing stacks with Helm Namespaces Next steps

Ladder Safety Course Overview This course on "Ladder Safety" provides learners with essential knowledge and skills to ensure the safe use of ladders in various environments. It covers critical topics such as ladder classifications, risk assessments, pre-use safety checks, and the correct procedures for setting up and using ladders safely. Designed for both beginners and those looking to refresh their knowledge, the course aims to reduce the risks associated with ladder usage and promote safety in the workplace. By the end of the course, learners will be equipped to identify potential hazards, conduct safety inspections, and implement effective safety measures when using ladders. Course Description The "Ladder Safety" course explores key aspects of ladder use, focusing on ensuring safety in various work environments. Learners will delve into ladder classifications, pre-use safety inspections, and risk assessments to identify hazards. The course covers setting up ladders correctly, ensuring proper placement, and securing them to prevent accidents. Throughout the course, learners will gain an understanding of safe ladder usage techniques and the importance of conducting thorough risk assessments. The course provides an engaging learning experience that equips participants with the knowledge to make informed decisions about ladder safety and compliance with workplace regulations. Ladder Safety Curriculum Module 01: Introduction to Ladder Safety Module 02: Ladder Classifications and Uses Module 03: Pre-use Safety Inspections and Risk Assessment Module 04: Setting Up and Safe Use of Ladders Module 05: Placement Considerations and Securing a Ladder (See full curriculum) Who is this course for? Individuals seeking to enhance workplace safety Professionals aiming to improve their knowledge of health and safety regulations Beginners with an interest in workplace safety and risk management Anyone working in environments where ladder use is required Career Path Health and Safety Officer Construction Site Manager Facilities Management Professional Risk Assessment Specialist Safety Trainer in Various Industries

Working from Home Essentials Course Overview: "Working from Home Essentials" provides learners with the knowledge and skills to excel in a home-based work environment. This course explores the tools, techniques, and strategies necessary for efficient and effective remote work. From understanding essential online meeting tools to mastering project management and communication software, learners will gain a comprehensive understanding of what it takes to succeed in a virtual workplace. The course highlights key tools for maintaining productivity, staying organised, and fostering clear communication, ensuring that learners are well-equipped to thrive in a remote role. Course Description: This course dives deep into the core elements of working from home, equipping learners with the knowledge to use a variety of tools designed to enhance productivity and collaboration. Topics include navigating online meeting platforms, utilising project management tools, and improving communication through digital mediums. Learners will understand how to plan and manage tasks remotely, effectively lead virtual teams, and ensure clear communication channels. By the end of the course, learners will have a thorough grasp of the software and strategies essential for remote work success, making them highly adaptable to modern work settings. Working from Home Essentials Curriculum: Module 01: Introduction to Work from Home Module 02: Online Meeting Tools Module 03: Project Management Tools Module 04: Project Planning Tools Module 05: Communication Tools (See full curriculum) Who is this course for? Individuals seeking to improve their remote work skills. Professionals aiming to enhance their efficiency in virtual environments. Beginners with an interest in learning the basics of remote work tools. Those looking to transition to or improve their work-from-home experience. Career Path Virtual Assistant Remote Project Manager Digital Marketing Specialist Customer Support Representative (Remote) Online Content Creator Remote Team Coordinator

Advanced Reflexology Course Overview The "Advanced Reflexology" course is designed for individuals who wish to deepen their understanding and mastery of reflexology techniques. It covers a wide range of specialised reflexology practices, focusing on addressing specific ailments and musculoskeletal pain. Learners will explore advanced treatment methods, enhancing their ability to target particular health issues effectively. This course also emphasises the integration of reflexology with other complementary therapies to improve patient care. By the end of the course, students will be equipped with the knowledge and skills to offer more focused and precise treatments, contributing positively to clients' health and wellbeing. Course Description In this comprehensive course, learners will study advanced reflexology techniques that cater to a wide array of health concerns. Topics include treating specific ailments such as digestive disorders, stress, and hormonal imbalances, as well as focusing on musculoskeletal issues like back and neck pain. The course also covers how reflexology can be integrated with other therapeutic approaches to enhance healing. Learners will gain in-depth knowledge of reflex points, pressure techniques, and reflexology for specific conditions, helping them to provide more tailored treatments. The learning experience is structured to provide a deep dive into each topic, enabling learners to refine their reflexology practices and offer expert care. Advanced Reflexology Curriculum Module 01: Introduction Module 02: Treating Specific Ailments Module 03: Treating Back, Neck, and Other Musculoskeletal Pain (See full curriculum) Who is this course for? Individuals seeking to enhance their skills in reflexology Professionals aiming to specialise in treating specific health conditions Beginners with an interest in complementary therapies Practitioners looking to expand their expertise in musculoskeletal treatments Career Path Reflexologist in private practice or health centres Complementary therapy practitioner Wellness consultant Holistic health practitioner

Project Planning for Everyone Course Overview: "Project Planning for Everyone" is designed to provide learners with the essential skills required to plan and manage projects effectively. This course covers the fundamental concepts of project planning, including the use of MS Projects for task management, data entry, and creating timelines. By the end of the course, learners will be equipped with the knowledge and confidence to plan projects efficiently, track progress, and ensure successful project delivery. Whether you’re new to project management or looking to refine your skills, this course offers practical value for all learners. Course Description: This course offers an in-depth introduction to project planning, with a focus on using MS Projects as a tool for creating project plans and tracking their progress. Learners will explore basic MS Projects features, including creating tasks, setting deadlines, and entering project data. The course progresses into more complex aspects, such as resource management and task dependencies, providing learners with a comprehensive understanding of project planning. The course includes a structured learning experience with clear objectives, enabling learners to build the skills necessary for effective project management. Upon completion, learners will have a solid foundation in project planning, ready to apply their skills in various professional settings. Project Planning for Everyone Curriculum: Module 01: Introduction Module 02: Basic M S Projects Module 03: Data Entry in MS Projects (See full curriculum) Who is this course for? Individuals seeking to improve their project management skills Professionals aiming to enhance their career development in project planning Beginners with an interest in project management and MS Projects Those interested in working within project management teams or handling individual projects Career Path: Project Manager Project Coordinator Operations Manager Scheduling Coordinator Team Leader in project-based industries

Diary Management Course Overview This Diary Management course offers comprehensive training on effectively organising and managing personal and professional schedules. Learners will explore essential techniques for scheduling appointments, prioritising tasks, and optimising time use to enhance productivity. The course emphasises the development of strong organisational skills, enabling learners to efficiently handle daily commitments and improve workflow. By mastering diary management, participants will gain confidence in managing multiple responsibilities, meeting deadlines, and maintaining clear records. This course is valuable for anyone looking to streamline their time management and improve administrative efficiency in any professional setting. Course Description This course delves into the key components of diary management, including methods for note-taking, scheduling, task tracking, and using digital tools designed to support organisation. Participants will learn how to structure their diaries effectively to accommodate varied responsibilities, manage interruptions, and maintain focus on priorities. The learning experience incorporates techniques for using popular note-taking programmes and digital calendars, ensuring learners can integrate modern technology into their daily routines. Throughout the course, individuals will build skills in time optimisation and discover practical strategies to enhance their organisational capabilities, ultimately supporting improved professional performance and personal productivity. Diary Management Curriculum Module 01: Introduction to Diary Management Module 02: Taking and Organising Notes Module 03: Scheduling and Time Optimisation Module 04: Keeping Track of Tasks Module 05: Note-Taking Programs Module 07: Diary Management Tricks and Optimisation (See full curriculum) Who is this course for? Individuals seeking to improve their time and schedule management skills. Professionals aiming to enhance their organisational and administrative abilities. Beginners with an interest in developing effective diary and task management. Administrative assistants and office workers looking to boost efficiency. Career Path Personal Assistant Office Manager Executive Secretary Administrative Coordinator Project Administrator

Recruiting Talent and Termination Procedure Course Overview: This comprehensive course on "Recruiting Talent and Termination Procedure" provides an in-depth understanding of the recruitment process, effective interviewing methods, and employee termination procedures. Learners will explore a wide range of topics, from creating effective recruitment strategies to managing employee terminations in a legal and ethical manner. The course offers practical value by equipping learners with the necessary knowledge and skills to excel in HR roles and manage critical HR processes. On completion, learners will be prepared to contribute effectively to recruitment and employee management within an organisation. Course Description: This course covers the entire recruitment lifecycle, including the development of recruitment models, selection methods, and the nuances of human resource management. Key topics include virtual interviewing techniques, employee on-boarding strategies, and the legal and procedural aspects of employee termination. Through a structured learning experience, learners will develop skills in recruitment planning, interview preparation, and managing the complexities of terminating employment. With a focus on the latest HR practices, the course ensures learners are prepared to handle recruitment and termination tasks with professionalism and confidence. Recruiting Talent and Termination Procedure Curriculum: Module 01: Introduction to Recruitment Process Model Module 02: Recruitment Methods Module 03: Human Resource Management Module 04: Key Skills and Issues in Recruitment Function Module 05: Virtual Interviewing Module 06: Employee On-Boarding Module 07: Introduction to The Employee Termination Module 08: The Employee Termination Procedure Module 09: Employee Termination Letter and Guide (See full curriculum) Who is this course for? Individuals seeking to enhance their understanding of recruitment and employee management. Professionals aiming to advance their career in HR or recruitment. Beginners with an interest in human resource management. HR practitioners seeking to update their skills in recruitment and termination processes. Career Path: HR Manager Recruitment Consultant Talent Acquisition Specialist Employee Relations Officer HR Coordinator HR Director

Content Management Course Overview This Content Management course provides a comprehensive introduction to managing digital content effectively across various platforms. Learners will explore the fundamentals of content management systems (CMS), understand content strategies, and develop skills in content marketing and planning. The course emphasises strategic approaches to creating, organising, and distributing content that engages target audiences and supports business goals. By the end of the course, learners will be able to design and implement content strategies, leverage marketing tools, and enhance online presence, making it highly valuable for those working in digital marketing, communications, or web management roles. Course Description This course covers essential topics such as the fundamentals of content management systems, the principles of content strategy, and the techniques involved in content marketing. Learners will gain insight into the selection and use of CMS platforms, explore effective content creation and distribution methods, and develop strategic marketing approaches tailored to diverse audiences. The learning experience includes analysing industry tools and tactics for maximising content reach and impact. Throughout, the course maintains a professional and informative tone, equipping learners with the knowledge and skills required to manage digital content proficiently and support organisational objectives in an ever-evolving digital environment. Content Management Curriculum: Module 01: Introduction to Content Management Module 02: Content Management System (CMS) Module 03: Basics of Content Management Systems Module 04: Content Strategy Module 05: Content Marketing Module 06: Content Marketing Tools and Tactics Module 07: Content Marketing Strategy (See full curriculum) Who is this course for? Individuals seeking to develop expertise in digital content management. Professionals aiming to enhance their career in marketing or communications. Beginners with an interest in digital marketing and online content. Anyone responsible for managing or creating content within organisations. Career Path Content Manager Digital Marketing Executive Social Media Coordinator Website Administrator Communications Specialist Content Strategist

Firefighter Training Course Overview The Firefighter Training course provides comprehensive knowledge of fire safety, legislation, risk assessment, and emergency procedures. It is designed to equip learners with essential fire safety skills to prevent and manage fire-related emergencies in various environments. The course is ideal for individuals who aim to enhance their understanding of fire safety and improve their preparedness for emergency situations. Upon completion, learners will gain the ability to identify fire hazards, assess risks, understand fire safety legislation, and manage evacuation procedures effectively. Course Description This course covers a wide range of topics including fire safety legislation, fire risk assessment, and the effective use of fire extinguishers. Learners will also study fire safety arrangements, evacuation procedures, and emergency first aid at work. The course aims to provide a thorough understanding of fire-related risks and how to mitigate them. Learners will also gain knowledge of essential fire safety equipment and the protocols for managing a fire emergency. The programme offers an in-depth learning experience, combining theoretical knowledge with practical guidance for emergency preparedness. Firefighter Training Curriculum Module 01: Introduction to Firefighter Module 02: Fire Safety Legislation Module 03: Understanding Fire Module 04: Fire Risk Assessment Module 05: Fire Safety Arrangements Module 06: Evacuation & Safety Module 07: Fire Extinguishers Module 08: Emergency First Aid at Work (See full curriculum) Who is this course for? Individuals seeking to enhance their fire safety knowledge. Professionals aiming to advance in fire safety management roles. Beginners with an interest in firefighting and emergency response. Employees responsible for health and safety in various sectors. Career Path Fire Safety Officer Fire Risk Assessor Health and Safety Officer Emergency Response Coordinator Facilities Manager Fire Prevention Specialist