731 Other courses in Hurstpierpoint

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.

The need for key staff to have commercial skills is paramount, as the public sector is increasingly opened up as a commercial market, in which organisations compete against each other and the private sector for contracts. Generating additional income and being commercially aware is vital for this to be a success, and is what many public sector organisations are looking to do. This programme will help you: See commercial awareness as not just another skill-set, but as a different mind-set Use a variety of tried-and-tested commercial, analytical decision-making techniques and tools Define your commercial objectives Develop a strategic focus Start looking at service clients as market segments Analyse, in a competitive context, your service offering Plan a commercial strategy, prepare for its implementation and see it through to execution 1 What is commercial thinking? Understand what it means to be a commercial thinker Identifying commercial opportunities often involves not only a different skill set but also a different mindset; looking at the services that you provide 2 Defining strategic commercial objectives Defining your key commercial objectives Prioritising your strategic objectives Two key strategic planning tools:Resource and Competency MatrixPESTLE How to apply these tools to your particular situation 3 Developing a strategic focus Decision-making on how to compete in the markets identified by your strategic objectives requires a strategic focus Developing strategic focus A tool for helping you to make those decisions: using the Ansoff Matrix 4 Defining customer targets How to think more commercially by understanding who all your customers are and how they differ from each other how to apply the principles to your areas to identify the type of customers you have and their key characteristics - Customer segmentation Who are your customers? How do their needs vary? - Scenarios 5 The competitive market place Understanding the competitive forces at play Different types of competition Analysing your competitive environment using Porter's 5 Forces model 6 Meeting stakeholder expectations Two simple models to help you identify the key stakeholders who could influence your commercial environment How to use your stakeholders to help you achieve your commercial objectives 7 Implementation - systems, structures and processes Effective commercial activity involves working with others to implement ideas and strategies What do you need to have in place before you implement your commercial strategy? How to health-check your organisation prior to implementation using the McKinsey 7S framework 8 Implementation - people and culture A good commercial strategy only works if the people involved buy in to the ideas and if the culture of the organisation is conducive to the effective implementation How the latest thinking in behavioural economics can help you develop your culture and people to work commercially 9 Tools and checklists Be more commercial within your sphere of influence using a commercial checklist to help you Using the checklist as a benchmark against the most commercially aware organisations Using the checklist as a health check - both corporately and individually

I also offer private immersive sound journey & gong bath sessions for groups large or small. Similar to my private 1:1 or 2:1 sessions, these can be completely tailored to your specific requirements. I come to your home, venue or event and provide everything that is needed for you and your guests to enjoy a magical sound and vibration journey like no other. For all enquiries, please contact me.

Why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships.Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) This workshop is designed for those who deal on a regular basis with fellow employees, suppliers or customers from different cultural backgrounds. The workshop will focus on understanding why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships. The one day session will use professional actors in the afternoon so that you can practice real-life situations involving intercultural challenges. Objectives  By the end of the course you will be able to: Understand what makes us different from people from other cultures Appreciate why we form impressions of other cultures Use strategies to communicate effectively with those from different cultural backgrounds Build trust with those we work with from a different cultural background Content Intercultural Challenges What challenges do you face with dealing with people from different cultures? Why do these challenges exist? Understanding Culture What is culture? Trompenaars’ Model of Culture – what determines our understanding of different cultures Cultural theories Hall and Hall:Three Systems of TimeThe Importance of Context – Data vs Dialogue Hofstede – 6 Cultural Dimensions Trompenaars – 7 Cultural Dimensions Chart your intercultural business relationships against these dimensions Strategies and Intercultural Management Trompenaar’s 3 step approach – Recognise, Respect, Reconcile How to foster and maintain trust Effective intercultural communication strategies Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.

A one-day programme of study designed for Registered Nurses, Doctors, and Allied Health Professionals working in a variety of care settings, whose role may include supporting and advising patients who are end of life.

Encourage people to think about how they can improve their performance through asking questions and coaching effectively. Course overview Duration: 1 day (6.5 hours) This workshop is suitable for anyone who is in a first line manager position looking to develop their coaching skills. The focus of the workshop is on understanding how coaching supports other management techniques, how it develops people and their performance, and how best to use coaching with your team. Objectives By the end of the course you will be able to: Define what coaching is and how it differs from and complements other management techniques State the benefits that coaching has for team members, managers and the business Use the key skills of coaching Implement strategies to deal with resistance to coaching Give feedback effectively while coaching Practice your coaching skills with real-life situations ContentWhat is Coaching How does coaching differ from mentoring, training, counselling? Giving advice vs coaching – The Power of 3 How does coaching support performance? Coaching as a leadership style Benefits of Coaching What are the benefits of taking a coaching approach for Team membersManagersThe wider organisation Key Skills How to build rapport for a positive coaching relationship Effective listening – understanding and practising the different levels involved in active listening Smart questioning The power of observation – reflecting back what isn’t being said Practical application throughout The GROW model for Coaching Understanding how to use the GROW model Types of questions to use at each stage Demonstration and practice Resistance for Coaching and Strategies Why might people be resistant to coaching? The role of “experts”, self-talk and self-concept in our thinking Expanding comfort zones Contracting and ethics Feedback/Directive Coaching Directive vs Non-Directive Coaching How and when to give feedback when coaching A feedback model Practice Action Planning