2268 Courses in London

First Aid for Mental Health 1-day course stands at the forefront of addressing the crucial aspect of mental well-being. Designed to equip individuals with essential skills and knowledge, this course offers a comprehensive exploration of mental health first aid.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Developing the high performing team takes time and effort. But above all, it requires an understanding of the dynamics of high performing teams. This programme helps managers and leaders understand what high performing teams do and how they do it. It focuses on enabling managers to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. A core theme is the need for managers of teams to 'hold up the mirror' to themselves and to see themselves as a leader of people, to reflect on how others see them and to modify their style accordingly. This programme will help managers / team leaders: Analyse the constituents of a 'high performing' team Apply essential influencing techniques Use a range of communication techniques to support effective teamwork Create and articulate team vision Generate common values Assess team effectiveness and take/recommend the appropriate actions Make more efficient use of team time Understand and agree on techniques to manage conflict Define and implement team meeting protocols that will facilitate team effectiveness Use the Prime Focus model to create the environment and framework for a high performing team Draft your team strategy to take them to the next level Day 1 1 Welcome and introduction Participants are welcomed to the programme and invited to share their personal objectives and people challenges Participants are given an action plan template to complete throughout the workshop 2 Your team The concept of 'positive intention' The difference between a team and a high performing team Assess your team effectiveness What is your 'interference'? 3 The team environment Setting the scene Building rapport Active listening Team goals and role profiling 4 Your style Tuckman model of team stages - how do you manage each stage? Team standards and goals Your team vision 5 Effective team meetings Influencing in team meetings How to make them interesting and relevant The pure role of the chair Day 2 1 Effective communication techniques Giving and receiving feedback Your communication style How to adapt, pace and lead to build rapport The Mehrabian theory of communication 2 How to manage conflict What is conflict? What is your default conflict approach? Tools and tips for managing conflict Practice sessions 3 Team skills Undertake a team skills analysis Types of team member Motivating team members Reframing situations 4 Setting your strategy Seeing the bigger picture The Prime Focus Model Your strategy for success Articulating your strategy Action plans revisited

This course will explore ways to support and enhance the quality of care provided to the individual approaching end of life, their families and their carers.

The aim of this course is to provide an overview of the principles and practice for leading and managing a portfolio of smaller projects in a multi-project / multi-task environment. It presents a range of practical methods and techniques relevant to the smaller project scenario, using exercises and case studies to show how these can be applied. The scope of the programme includes: The course also emphasises the importance of the leadership and team-working skills needed by project managers and team members in carrying out their roles. The principal training objectives for this programme are to: Explain and demonstrate the key principles of successful project management Demonstrate a range of useful project management tools and techniques Define the role, and help participants understand the skills required by, the project leader Provide a structured framework to help participants manage multiple projects Identify opportunities to improve project management within the organisation DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Managing smaller projects Projects and project management Lessons from past projects; the essential requirements for success Differences between projects; characteristic project life cycles Key issues and challenges of smaller projects The multi-project world; project portfolio management 3 Project exercise Syndicate teams plan and manage a small project Review of the project exercise: What are the keys to successful management of small projects? 4 Setting up the project Getting organised Managing the definition process Identifying and managing project stakeholders Working with the customer to define the scope and agree deliverables 5 Case study 1 Defining the project scope and deliverables Syndicate teams define the scope and deliverables for a typical project 6 Project planning The importance and cost benefit of effective planning Planning the plan; deciding how detailed a plan to create Packaging the work and estimating timescales and costs Developing project / resource schedules; setting milestones for control v Identifying and managing critical path activities 7 Case study 2 Creating the project plan Syndicate teams develop and analyse the project plan DAY TWO 8 Managing project risks Identifying risks to the project outcome, timescale and cost Evaluating risks and adopting an appropriate risk strategy Defining risk ownership; keeping a simple risk log Keeping risk management up to date; staying pro-active Integrating planning and risk management 9 Project control Managing change, minimising scope creep Selecting the data needed to provide early warning of problems Monitoring performance easily with 'S' curves and slip charts Using trend forecasting to assess true project status Running project review meetings 10 Managing a multi-project portfolio Understanding the world of multiple projects Establishing ownership of project / programme management Classifying projects and creating the 'master schedule' Defining and applying project lifecycle management Resource management: essential pre-requisites and mechanisms Project prioritisation criteria and techniques; pain / gain analysis 11 Managing the multi-project team Characteristics of small project teams / part-time team membership Clarifying line and project management responsibilities Implementing effective manpower planning Establishing professional working practices in the team Developing project management competences in the team Establishing team roles and integrating team members 12 Course review and transfer planning (Course sponsor present) Identify actions to be implemented individually Identify corporate opportunities for improving project management Sponsor-led review and discussion of proposals Conclusion

Using an excavator as a crane is a common practice in certain construction and lifting operations. Using the digger as a crane requires appropriate training and skills However, it’s important to note that excavators are primarily designed for digging and earthmoving, not lifting. Using an Excavator as a Crane involves some inherent risks, and it’s crucial to follow safety guidelines and manufacturer recommendations. To book the NPORS Excavator as a Crane training or test please contact us to schedule your Training Here are some general considerations and steps you might take when using an excavator as a crane: 1. Check Manufacturer Guidelines: Always consult the manufacturer’s guidelines and specifications for the specific excavator model you are using. Manufacturers provide load charts and other essential information to ensure safe operation. 2. Understand Load Capacities: Know the lifting capacities of your excavator at various boom lengths and angles. Exceeding these capacities can lead to instability and accidents. 3. Use Proper Attachments: If your excavator is equipped with a lifting attachment, make sure it is designed and rated for lifting operations. Using inappropriate attachments can compromise safety. 4. Stabilise the Excavator: Ensure that the excavator is on stable ground. Extend the outriggers or stabilisers to provide additional support and prevent tipping. 5. Inspect the Excavator: Regularly inspect the excavator for any signs of wear, damage, or malfunction. Pay particular attention to the boom, hydraulics, and other critical components. 6. Position the Excavator: Position the excavator in a way that allows for a stable lifting operation. Avoid working on slopes or uneven surfaces. 7. Rigging and Lifting Techniques: Use proper rigging techniques, and ensure that the load is properly secured. Lift the load smoothly and avoid sudden movements. 8. Maintain Clear Communication: Establish clear communication between the operator and any ground personnel involved in the lifting operation. Use hand signals or radios to coordinate movements. 9. Avoid Exceeding Reach Limits: Do not exceed the excavator’s reach limits. Lifting loads beyond the recommended reach can lead to instability. 10. Training and Certification: Ensure that operators are properly trained and certified for lifting operations. Holding the NPORS Excavator As A Crane bolt on is essential for lifting operations Operating an excavator as a crane requires specific skills and knowledge. 11. Weather Conditions: Consider weather conditions, especially wind speeds, as they can affect the stability of the excavator during lifting operations. Always prioritise safety when using equipment for tasks it wasn’t originally designed for. If the lifting requirements are frequent or extensive, it may be more appropriate to use a dedicated crane with the necessary capacity and features. Remember, safety is paramount in any construction or lifting operation. Frequently Asked Questions 1. What is Excavator As A Crane Training, and why is it necessary? Excavator As A Crane Training provides individuals with the skills and knowledge required to safely and effectively use excavators for lifting operations. Although excavators are primarily designed for digging and earthmoving, this training ensures operators can perform lifting tasks safely, minimizing risks and accidents on job sites. 2. Who should undergo Excavator As A Crane Training? This training is essential for anyone involved in using excavators for lifting operations, including machine operators, construction workers, and site supervisors. Proper training ensures that individuals understand equipment operation procedures, load capacities, and safety protocols. 3. What topics are covered in Excavator As A Crane Training programs? Training programs cover a range of topics, including: Manufacturer guidelines and load charts Understanding load capacities at various boom lengths and angles Proper use of lifting attachments Excavator stabilization techniques Rigging and lifting techniques Positioning and communication strategies Safety procedures and weather considerations Regular inspection and maintenance of equipment 4. Is Excavator As A Crane Training mandatory in certain industries? While not legally mandated in all areas, many employers in the construction and lifting industries require operators to undergo training as part of their occupational health and safety policies. Compliance with excavator as a crane training requirements helps prevent accidents and ensures regulatory compliance. 5. Where can I find reputable Excavator As A Crane Training courses? Reputable Excavator As A Crane Training Courses are offered by various institutions, including industry associations, equipment manufacturers, and specialized training providers like Vally Plant Training. It is important to choose a program that offers accredited certification and covers relevant industry standards and best practices.

Wouldn't sales be a 'walk in the park' without challenging customers? Why is it that some customers are so difficult to please, so quick to call 'foul' at the slightest blip and so mean with their gratitude after we've bent over backwards to accommodate them? Whether we are looking at prospective or existing customers, there is a toolkit for dealing with the most challenging of them. This course will help participants: Use broad open questions to give the customer a platform for their opinions or issues Improve listening skills to really understand what's behind the customer's challenging style Probe specific phrases to show listening and earn deeper disclosure Use silence to let challenging customers 'blow off steam' Understand the negative impact of certain phrases on a challenging customer Summarise effectively and reassure the customer of our understanding of their needs Recognise the 'behaviour cycle' and avoid emotional escalation Understand 'transactional analysis' and how to bring people from 'child' to 'adult' state Create loyalty in customers who are slow to give trust 1 What makes a customer 'challenging'? Why customers challenge us - understanding their drivers 'Wearing their shoes' - seeing things from their perspective Understanding our own personality style How to flex with a style that is different from our own Ways to quickly recognise a customer's style The benefits of flexing with a challenging customer's style 2 Practical exercise - forum theatre Participants take it in turns to deal with the trainer (who plays the role of the challenging customer) Observers stop the action when they hear or see something they deem wrong The participant in the seat gets a chance to use a suggested alternative line The participant who makes the suggestion has the chance to occupy the seat and deliver it themselves Frequent feedback from the trainer as to how the participant's words are making him feel Opportunities to rewind the action if an ill-advised line is suggested and delivered Flipchart for capturing what worked, what didn't work and why Mehrabian principle - the importance of body language and tone over words used 3 Questioning and listening skills How to use open questions to get the customer talking What questions to avoid and why The use of pauses and silence to reduce tension and build trust What listening is and what it isn't Question funnelling - how to earn deeper disclosure through probing The power of summary 4 Transactional analysis explained What is transactional analysis (TA)? Exploring the TA states and why people behave in that way under pressure How to bring challenging customers to 'adult' state to reduce tension How 'parent' or 'child' behaviours can be inadvertently triggered Understanding the 'behavioural cycle' and how to break it Mini-role play 'vignettes' to demonstrate real time impact of ill-chosen words 5 How to build trust with challenging customers Techniques for placating current challenging customers Methods that the participants have already used effectively - understanding why those methods worked and how other participants can model them Participants' experiences of trust having been lost - understanding why those experiences had that negative outcome How to 'go the extra mile' with challenging customers 6 Bringing a 'real' challenging customer to life Participants give the trainer a brief profile of a specific challenging customer of theirs 5-10 minute roleplay in which the trainer brings that individual to life Observing participants - without interrupting - make notes on what is and isn't working Trainer stops the action half-way through to give feedback on how he is feeling Participant goes back into the roleplay having recalibrated their approach based on feedback Observers give feedback on what did and didn't work Trainer comes out of character to explain the impact of the participant's words and behaviours 7 Wrap-up Key learnings from each participant Individual action planning - steps that can and will be implemented in the workplace

The Paediatric First aid course provides the comprehensive set of practical skills needed by people working in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies.

The Paediatric First aid course provides the comprehensive set of practical skills needed by first aiders in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies and common childhood illnesses. It meets the standards required to help comply with Ofsted regulations.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment