134 Courses in London

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

Self-understanding is a prerequisite for leading and managing others responsibly and honourably. The field of Neuro Linguistic Programming has helped us to gain a better insight into how we all think and behave. Upon completion of this course participants will be able to: Gain an insight into the purpose and functions of the unconscious mind Develop flexibility to increase their for behaviours in different circumstances Appreciate how different people experience the world Create and set effective goals and direction Understand the NLP Model of Communication Adapt their communication style to maximise effectiveness Influence and persuade others by connecting with people Understand how empowerment can make life easier Appreciate how creativity works Learn creativity techniques to tap into the power of the team 1 Self-awareness Autopilot - your unconscious mind Developing flexibility How identify, values & beliefs shape our behaviour Models of the world 2 Creating direction Describing present and desired state Designing your direction Making it happen Self-mastery 3 Communication The NLP Model of Communication Insights to the way people think Understanding representation systems Reframing the way people think about negative experiences Using metaphor 4 Influence and persuasion Building trust Connecting with people Purpose intention and outcomes The difference empowerment makes 5 Creativity and innovation Hindrances to creativity and innovation Your natural state of creativity Getting unblocked Creativity techniques 6 Action plan Course summary and presentation of action plans

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

"Enhance your love life with our Professional Dating Coach in London. Gain confidence, master online dating, and find meaningful connections with expert guidance tailored to your needs. Start your journey to lasting love today!

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Agility has become a prized business attribute. Although Agile methods were once most associated with software development, they are now applied in a host of different areas. Agile continues to find new applications because it is primarily an attitude. This programme delivers a solid grounding in both the Agile mindset and Agile methods. It covers three methods, illustrates the benefits of each and shows how they can be integrated. It includes practical techniques as well as background knowledge. By the end of the session, participants will be able to: Apply Agile concepts to self-manage their work Understand the roles people take on in Agile teams Use a variety of techniques to help deliver customer satisfaction Focus on delivering against priorities Employ a range of estimating techniques 1 Introduction Overview of the programme Review of participants' needs and objectives 2 The basics of Agile What makes Agile different Agile Manifesto and Principles Using feedback to deliver what is needed 3 Agile teams Multi-disciplinary teams Team size and empowerment Agile values 4 Agile at the team level - Scrum Scrum roles Scrum 'events' Scrum 'artifacts' 5 Agile for teams juggling multiple demands - Kanban Taking control of the work Improving throughput Dealing with bottlenecks 6 Agile in projects - AgilePM The phases of an Agile project Managing change requests Delivering on time 7 Estimating T-shirt / Pebble sizing Yesterday's weather Planning poker 8 Pick 'n' mix - some useful techniques The daily stand-up User stories Retrospectives Work-in-process limits Burndown charts Minimum viable product A / B testing 9 Review and action planning Identify actions to be implemented individually Conclusion

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning

It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans

Successfully closing a sale and negotiating the best outcome for the business is a key skill for all salespeople, and often an area that is overlooked. Investing in this skill will have a positive impact on interactions with customers, both new and existing, and lead to improved sales performance. Whilst understanding how to reach a conclusion with a customer faster means increased efficiency and more time to invest in sourcing new business. We have developed this programme to be practical, fun and interactive. Participants will learn proven techniques for influencing, persuading and negotiating with clients, gain increased confidence and clarity when reviewing contract terms and prices, and understand how to structure and manage sales negotiation and contract review meetings. This course will help participants: Learn a structured and proven approach to the negotiation of contract terms Apply the key principles of negotiation, playing the person and the problem Create a contract negotiation strategy - from opening to close Recognize and put to use proven negotiation tactics and techniques Learn how to embrace conflict positively - to 'say no, then negotiate' Plan and prepare for any commercial negotiation conversations Understand the stages of negotiation and how to move through them 1 Closing and negotiating from a position of personal power The eight steps of a sales or commercial negotiation Ten ways to resist price pressure How to draw on sources of power when you have less authority The six principles of influence and persuasion and how to use them 2 Effective negotiation - planning and theory How to plan and structure your negotiation for a successful and quick conclusion Influence: knowing how to 'push or pull' to win an argument Achieving a BATNA - a range of practical skills and techniques Case study: planning for a client negotiation around contract or price issues 3 Effective closing and negotiation - practice and reality Higher-level questioning techniques to investigate and solve problems Listening to lead - active listening and structuring your conversation The most common 'unforced' negotiation mistakes and errors Case study: setting objectives, sources of value, trading concessions 4 Sales negotiation tactics and playing the game How high - how hard - how soon; why now How to identify hidden or perceived currencies and values How to use these to establish a higher base price Negotiation best-practice checklist and summary