Duration 1 Days 6 CPD hours This course is intended for This course is intended for managers and individuals who would like to increase their skill in leading and planning meetings. Overview Upon successful completion of this course, participants will have the basic tools needed to initiate and manage meetings that will engage attendees and leave a positive and lasting impression. In this course, participants will learn the needed skills in planning and implementing a successful meeting. Getting Started Workshop Objectives Action Plan Planning and Preparing (1) Identifying the Participants Choosing the Time and Place Creating the Agenda Practical Illustration Planning and Preparing (2) Gathering Materials Sending Invitations Making Logistical Arrangements Practical Illustration Setting Up the Meeting Space The Basic Essentials The Extra Touches Choosing a Physical Arrangement Practical Illustration Electronic Options Overview of Choices Available Things to Consider Making a Final Decision Practical Illustration Meeting Roles and Responsibilities The Chairperson The Minute-taker The Attendees Variations for Large and Small Meetings Practical Illustration Chairing a Meeting (1) Keeping the Meeting on Track Dealing with Overtime Holding Participants Accountable Practical Illustration Chairing a Meeting (2) Running in and Out Cell Phone Ringing Off on a Tangent Personality Conflict Practical Illustration Dealing With Disruptions Running in and Out Cell Phone Ringing Off on a Tangent Personality Conflict Practical Illustration Taking Minutes What are Minutes? What do I Record? A Take-Home Template Practical Illustration Making the Most of Your Meeting The Minute Meeting Using Games Giving Prizes Simple Magic Practical Illustration Wrapping Up Words From the Wise Additional course details: Nexus Humans Meeting Management Skills 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 Meeting Management Skills 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 The course is targeted at professionals who have never worked with Microsoft 365 before, or who have yet to move beyond its basic functions. The target audience typically includes individuals, professionals, and organizations who are looking to improve their productivity, collaboration, and communication using the suite of applications and services provided by Microsoft 365. This could include office workers, project managers, IT professionals, and small to large-scale businesses who want to maximize the benefits of cloud-based solutions for their daily operations. Overview Upon successfully completing this course, students will have confidence in using the Microsoft 365 applications. Students will increase their work productivity and decrease time on completing tasks. In this course, students will learn how to use different tools of Microsoft 365 for better online collaboration, including OneDrive, SharePoint, Teams, Excel, Outlook, Word, and PowerPoint. First Steps in Office 365 The Difference Between Office 365 and Microsoft 365 Pros and cons of Microsoft 365 First Steps on mobile devices OneDrive Introduction - What is Microsoft OneDrive? How To Access Microsoft OneDrive? Upload Files Share Files Sync Files Recycle Bin Using OneDrive How To Access Onedrive On Phone? Teams - Simplify Collaboration within Companies Discover new ways to collaborate and communicate An introduction to your central place in Office 365 How to launch and install Teams The Interface of Microsoft Teams Use the Teams window to structure your organization Use Channels to structure the Teams window Use Tabs to access tools and information Communicate with others via Chat Keep track of activities Meetings, video conferencing and screen sharing Share files effectively Manage teams and permissions for organizational structuring Use Teams effectively on mobile devices Final remarks SharePoint Sites Introduction First Steps Document Library - First Steps Document Library - Set and Manage Alerts Document Library - Understanding Versioning Sync Libraries Share a Site Picture Library Lists Calendar Tasks Discussion Board Outlook First Steps in Mail Improved Search Function Work with Folders Settings Working with the Mail App Calendar People Tasks Excel Online Introduction Open and Edit an Excel Online Workbook Limitations of Excel Online Create a New Workbook with Excel Online Edit a Workbook Simultaneously with another Person Working with the Excel AppUse Excel effectively on mobile devices PowerPoint Online Introduction Open a PowerPoint Online Presentation Edit a Presentation Online Limitations of PowerPoint Online Create a Presentation with PowerPoint Online Working with the PowerPoint App Use Power Point effectively on mobile devices Word Online Introduction Open and Edit a Word Document Online Limitations of Word Online Create a New Document Edit a Document Simultaneously Working with the Word App
Duration 1 Days 6 CPD hours This course is intended for This course is intended for anyone engaged with teams or looking to live a more fulfilling life. Overview Upon successful completion of this course, participants will gain a new perspective on themselves and their emotions, and increase their value to society. In this course, participants will learn how beneficial becoming more self-aware can be and see how a highly self-aware person becomes more equipped to deal with daily life and its challenges. Getting Started Workshop Objectives Action Plan What is the Self? The Physical Self The Emotional Self The Mental Self The Spiritual Self Practical Illustration Awareness of the Physical Self Scanning Progressive Relaxation Physical Stressors Exercise Practical Illustration Time Management Organization Goal Management Priorities Procrastination Practical Illustration The Emotional Self Validity of Emotions Utility of Emotions Emotional Arousal Emotional Valence Practical Illustration Mood Management Emotional Intelligence Categories of Emotion Increasing Arousal Decreasing Arousal Practical Illustration The Mental Self Thinking Style Learning Style Personality Stinking Thinking Practical Illustration Interpersonal Awareness Addressing Different Thinking Styles Addressing Different Learning Styles Active Listening and Body Language Transactional Analysis Practical Illustration The Spiritual Self Mindfulness Meditation Cultivating Positivity Gratitude Practical Illustration Limitations of Self Awareness Navel Gazing Excessive Self Discipline Developing Humility Developing Empathy Practical Illustration Independence versus Interdependence What is Interdependence? Systems Theory More Than the Sum of All Parts Team Building Practical Illustration Wrapping Up Words from the Wise Additional course details: Nexus Humans Improving Self Awareness 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 Improving Self Awareness 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.
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
The Power of Resilience Course Overview The Power of Resilience course equips learners with essential strategies to strengthen their ability to adapt and thrive in the face of adversity. This course explores the core principles of resilience, highlighting its crucial role in personal and professional success. Learners will discover how to cultivate mental toughness, manage stress effectively, and maintain emotional balance through challenging times. By the end, participants will be empowered with actionable insights to foster inner peace, build courage, and navigate change with confidence. This course offers valuable tools for anyone seeking to enhance their emotional strength and improve overall wellbeing, making it highly relevant across a variety of life and career contexts. Course Description This comprehensive course delves into the multifaceted nature of resilience, examining how it influences success and wellbeing. Topics include the psychological foundations of resilience, techniques for developing a resilient mindset, and the relationship between resilience and inner peace. Learners will explore how resilience fosters courage and empowers individuals to face life’s uncertainties positively. The course also addresses strategies for managing change and chaos effectively, ensuring learners gain a thorough understanding of resilience in dynamic environments. Designed for a professional and informative learning experience, the course builds skills in emotional regulation, adaptability, and stress management that are valuable across personal growth and career advancement. The Power of Resilience Curriculum Module 01: Resilience As A Key To Success Module 02: The Secrets To Developing Resilience Module 03: Resilience Brings Inner Peace Module 04: Be Resilient, Develop The Courage You Need To Live A Happy Life Module 05: Use Resilience To Deal With Change And Chaos (See full curriculum) Who Is This Course For? Individuals seeking to enhance emotional strength and wellbeing. Professionals aiming to improve adaptability and stress management skills. Beginners with an interest in personal development and mental resilience. Anyone wishing to develop courage and navigate change confidently. Career Path Mental Health Support Worker Life Coach or Personal Development Advisor Human Resources Specialist Team Leader or Manager in dynamic work environments Wellbeing Consultant
Certified Project Manager Course Overview: The "Certified Project Manager" course is designed to equip learners with the essential knowledge and skills required for effective project management. Covering key topics such as leadership, stakeholder management, communication, and change management, this course provides a comprehensive foundation for managing projects from start to finish. It is ideal for professionals looking to enhance their project management expertise and ensure successful project delivery. By the end of this course, learners will be prepared to manage projects efficiently, aligning them with organisational goals while maintaining focus on quality, budget, and timelines. Course Description: This course offers an in-depth exploration of project management principles, including project communication, leadership, and stakeholder management. Learners will delve into project methodologies, budgeting, scheduling, and performance assessment, ensuring they can lead projects effectively within diverse environments. The curriculum also covers critical topics like change management and scope definition, preparing learners to manage projects through every stage. Through the course, learners will gain valuable insights into essential project management tools, techniques, and strategies to address challenges and optimise project outcomes. This course is structured to provide a solid foundation in project management, preparing learners for a successful career in the field. Certified Project Manager Curriculum: Module 01: Introduction & Overview Module 02: Teams & Leadership Module 03: Project Communication Module 04: Stakeholder Management Module 05: The Basics of Project Management Module 06: Scope and Requirements Module 07: Developmental Methodologies Module 08: Effective Budgets & Schedules Module 09: Project Performance Module 10: Change Management (See full curriculum) Who is this course for? Individuals seeking to develop their project management skills. Professionals aiming to advance their careers in project management. Beginners with an interest in managing projects across industries. Those seeking to understand the fundamentals of project management processes. Career Path: Project Manager Programme Manager Project Coordinator Operations Manager Team Leader Project Analyst Construction Project Manager IT Project Manager
Metaphysics Course Overview This Metaphysics course offers a comprehensive exploration of the fundamental principles underlying reality, existence, and the nature of being. Learners will delve into key metaphysical concepts such as existence, causality, and the relationship between mind and matter. Designed to deepen philosophical understanding, the course also examines the historical development of metaphysical thought alongside its influence on religion, spirituality, and modern New Age beliefs. Participants will gain critical thinking skills, enhancing their ability to analyse abstract ideas and apply them in philosophical, religious, or cultural contexts. By completing this course, learners will build a strong intellectual foundation for further study or professional work involving philosophy, theology, counselling, or holistic disciplines. Course Description This detailed course covers the breadth of metaphysical inquiry, beginning with an introduction to its core subjects and evolving through historical perspectives from ancient to contemporary times. Topics include fundamental questions about existence, the supernatural, and the intersection of metaphysics with religion and occultism. Learners will engage with new metaphysical concepts emerging from the New Age movement and critically examine their cultural significance. The learning experience emphasises analytical reasoning and reflective thought, encouraging students to evaluate complex ideas and theories. Skills developed include philosophical analysis, conceptual clarity, and an enhanced understanding of diverse belief systems, preparing learners for roles that require insight into metaphysical and spiritual frameworks. Metaphysics Curriculum Module 01: Introduction to Metaphysics Module 02: Core Subjects of Metaphysics Module 03: History of Metaphysics Module 04: Fundamental Questions of Existence Module 05: New Age Movement and Metaphysics Module 06: Metaphysics and the Supernatural Module 07: Metaphysics, Religion and Occultism Module 08: Other Metaphysical Concepts (See full curriculum) Who is this course for? Individuals seeking to deepen their understanding of philosophical concepts. Professionals aiming to enhance their knowledge in theology or spiritual counselling. Beginners with an interest in philosophy, spirituality, or metaphysical studies. Those exploring careers in holistic, religious, or cultural education fields. Career Path Philosophy lecturer or researcher Spiritual or holistic counsellor Religious studies advisor or educator Author or content creator in metaphysical and spiritual topics Cultural consultant or community facilitator
Master Emotional Intelligence for Crucial Moments Course Overview: "Master Emotional Intelligence for Crucial Moments" is an in-depth course designed to enhance your emotional intelligence (EQ) to handle critical situations with clarity and confidence. Throughout this course, you will develop the skills to manage your emotions effectively, understand others’ emotions, and use these insights to navigate complex interactions. Learners will explore key emotional intelligence concepts, gaining the ability to apply them during high-pressure moments. This course equips you with the tools to improve decision-making, strengthen leadership qualities, and handle crises with emotional composure. By the end, you’ll be able to influence outcomes positively in both personal and professional settings, enhancing your overall interpersonal effectiveness. Course Description: This course offers comprehensive insights into mastering emotional intelligence, focusing on its application during crucial moments. You will explore how EQ can be used to pause and reflect, understand emotional triggers, and manage stress in critical situations. Topics such as taming emotional responses, using EQ in leadership, and emotional regulation in times of crisis are central to the course. Learners will engage with various tools and strategies that support emotional self-awareness, empathy, and leadership. By developing these skills, learners will gain an enhanced ability to maintain composure, inspire others, and lead with emotional intelligence in high-stakes environments. This course provides essential skills for those aiming to excel in leadership, communication, and conflict resolution, ensuring they remain calm and focused in the most challenging moments. Master Emotional Intelligence for Crucial Moments Curriculum: Module 01: The Crucial EQ Moment - It's In The Pause Module 02: Use Emotional Intelligence To Tame Your Brain And Cope During Crises Module 03: Emotionally Intelligent Leadership In Action (See full curriculum) Who is this course for? Individuals seeking to enhance their emotional intelligence for career growth. Professionals aiming to improve leadership and crisis management skills. Beginners with an interest in emotional intelligence and personal development. Anyone looking to strengthen their interpersonal skills in high-pressure situations. Career Path: Leadership Roles Conflict Resolution Specialist Human Resources Manager Executive Coach Organisational Development Consultant Crisis Management Advisor
This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 Oracle 12c SQL Fundamentals 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.