2497 Courses in Liverpool

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

Project Leadership Skills: In-House Training To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan

Project Stakeholder Relationship Skills: In-House Training This course is designed to provide project managers with the ability to: Analyze the complexities of major stakeholder relationship categories Apply the most appropriate interpersonal relationship skills to the different categories of relationships Align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle What you Will Learn Examine traditional and non-traditional ways to identify and assess stakeholders Explain how competence, character, and trust lead to project success and strong relationships with stakeholders Utilize 'Embodied Leadership' skills to build stakeholder relationships Apply stakeholder engagement best practices to case study and real-life scenarios Getting Started Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations

Strategic Thinking: In-House Training The goal of this course is to provide you with the building blocks and the motivation to develop the critical skill of strategic thinking. The participants will consider a four-part model that distinguishes strategic thinking from strategic planning and managing. With that understanding, you will investigate the critical components of strategic thinking and how to apply it effectively. What you Will Learn Define strategic thinking and distinguish it from strategic planning and management Explain a high-level approach to gaining strategic thinking skills Integrate other interpersonal skills, such as self-awareness, systems thinking, leadership, constructive conflict, and collaboration, into the fabric of strategic thinking skills Select appropriate techniques to apply strategic thinking in specific situations Recognize and emulate effective strategic thinking behaviors Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Interactive event: Define Strategic Thinking (ST) Interactive event: Discuss relationship of ST with Strategic Planning, Management and Decision Making Strategic Level Framework - Tying it all together Strategic thinking attributes Strategic Thinking Critical Success Factors Strategic Thinking Critical Success Factors - 5-part model Strategic Thinking and the Organization Critical Success Factors Model applied to an organization Tools Introduction (5): Environmental, 5 Forces, SWOT, Value Proposition, Integral Theory of Worldview Video: Fog of War Strategic Thinking and the Individual Critical Success Factors Model applied to an individual Tools Introduction (5): Thinking Styles, Six Thinking Hats, Reverse Thinking, Systems Thinking, Integral Theory of Worldview Strategic Thinking at the Interpersonal and Team Levels Emotional Intelligence - Self Awareness and Working With Others Team Leadership and Trust Constructive Conflict as the Gateway to Collaboration Interactive event: Testing the Models - Challenge Perspective; What's Missing Applying the critical skill of Strategic Thinking Worldview: Team versus client Trusted Advisor Interactive event: Doing what is asked (Case study, wherein participants review the default case scenario prepared for this workshop and add specific details to make the scenario more relevant to their experiences / needs. Teams develop an action plan for applying ST concepts and techniques they have learned here to the situation, then compare and contrast results.)

Are you seeking to make a real impact at work by gaining new leadership skills and enhancing your personal development? Our accredited Leadership Foundation Programme provides you with in-depth understanding of how to enhance business performance and employee wellbeing, and how you as an effective change leader can coach, inspire, engage and empower your people. And you gain an internationally recognised ILM Level 5 Award in Leadership and Management.

Overview Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. This one day course will teach you how to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation. Description This training course will help your participants build a professional reputation and develop a network of connections through the two key methods available to them; face-to-face and online. Attendees will discover how to effectively combine these two approaches and create a strategy for networking success that will generate their own community and actively grow their personal network. This will result in an improved performance in their approach to networking and consequently provide opportunities and prospects that will increase their business success. The training provides them with the tools and techniques to both plan a successful, strategic approach to networking and develop their personal communication skills, which will ensure they build effective business relationships. Topics covered: Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off, as well as some personal revelations about networking. Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital. Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development. Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each. Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums. Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages. Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills. Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room. Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional. Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness. The Follow-Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow-up email and a chance to develop their own. Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target. Who should attend Anyone who is looking to improve their networking performance, or the networking performance of a management or sales team. Requirements for Attendees No pre-requisites required.

Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.

Overview This one day course covers the basics of brainstorming and then goes on to look at a number of different yet highly effective techniques that can be employed. Description Brainstorming is probably the most well known and most widely used method for bringing groups of people together to generate ideas about an issue or problem. This is because it’s a good way to gather a lot of ideas very quickly. It is also a great way of bringing people together and helping to build them as a team. Just imagine the effect on the team and its morale if ideas that they generate are actually used. There is no doubt that people are more likely to buy into the ideas that they came up with themselves. Although brainstorming is widely used for decision-making, it is not always handled very well. If that is the case, it can have the opposite effect to the one that is intended. Rather than creating ideas it can stifle them and rather than motivating people it demotivates them. This highly interactive course will help learners to make the most of brainstorming sessions and also provides alternative techniques to enliven any session that is beginning to flag. Topics covered: What is Brainstorming? – A discussion to help participants understand what brainstorming is, and what it involves. Brainstorming rules – A quick look at the very limited rules suggested by Alex Osborn who is generally credited with being the inventor of brainstorming. Preparation – Although many brainstorming sessions take place on the spur of the moment they all require some preparation. We look at the importance of defining the purpose of the session, selecting the right participants, and then briefing them properly. Storm and Floods – This is an activity that we re-visit on several occasions to take participants through the whole brainstorming process and to give them plenty of practice. The Three R’s of Facilitation – The three R’s take you through the essential elements of facilitating an effective brainstorming session. Closing the Session – Effective closing of the brainstorm may be just as important as the session itself. We look at the essential elements that the facilitator needs to cover. Clarify and Nurture – Learners discover the importance of ensuring that all ideas that are unclear are clarified and that ideas are nurtured. They also learn what this involves practically. Alternative Techniques – There are many ways to enliven a flagging brainstorming session, provide a fresh approach or simply build on initial ideas. The learners are introduced to some of the most important of these. Brainstorming Scenarios – Learners work through up to 6 scenarios so that they can practice the alternative techniques covered during the programme. Who should attend Anyone who facilitates or takes part in brainstorming sessions, or wants to work with organisational teams to develop their problem-solving abilities. Requirements for Attendees None.

Overview This course sets out to develop attendee’s skills in understanding their own body language as well as being able to read the body language of others. If we can learn to identify and appreciate non-verbal clues, we can begin to improve our communication as a whole. This use of body language skills could impact situations such as; sales visits, interviews, presentations and normal day-to-day interactions where body language plays a part. Description Effective communication skills are critical in the development of relationships between people and although verbal communication plays a large part in this, studies have shown that a proportionate amount of our message comes from not what we say, but very often the non-verbal communication behind the message. Therefore, it is clear that body language is an important, influential aspect of communication and understanding how it works is essential in the development of your personal communication skills. Topics covered: Core Principles and the Five C’s – Exploring the subconscious effects of body language and setting the scene by ensuring participants appreciate the rules to interpreting body language. Reading Body Language – Gestures – An activity that helps participants realise the power of body language and how important it is to communication. Arm Barriers – Understanding the different arm barrier gestures and crossed arm positions and what each means. Palm and Handshake Gestures – Discussing the different handshakes and palm actions, what they mean and how they are applied in real life. Includes activities that test the theory. Hand and Thumb Gestures – A review of these different gestures and what they mean. Hand to Face Gestures…or… How to Spot a Liar! – An exploration of different gestures that involve the hand moving to the face. Identifying how to spot body language that signifies lying and what to watch out for. Chin and Cheek Gestures – An activity that helps participants understand the different chin and cheek gestures and how to interpret this body language. Eye Signals – A review of pupil dilation, directed gazes and eye accessing cues in order to fully understand how eyes provide body language clues. Matching & Mirroring – Looking at the technique of building rapport and developing relationships through careful observation of body language. Bringing it all Together – An activity that allows participants to embed their learning and realise how much they now understand and appreciate body language and its effect on communication. Who should attend Anyone who wants to gain a better understanding of their own body language, and that of others. Requirements for Attendees None.