2589 Courses in Southwater

Develop more advanced training skills such as expert presentation, facilitation and coaching skills. Course overview Duration: 2 days (13 hours) This workshop is for people who want to take their personal skills as a trainer to the next level. It builds on the Underscore Level 1 Train the Trainer course.  In this Level 2 course delegates will develop more advanced training skills such as expert presentation, facilitation and coaching skills. In the modern world learning is often delivered in blended learning formats and this course will introduce delegates to the challenges of blended learning and how to introduce a range of delivery methods into programmes. Attendees will learn how to write more complex learning plans and integrate different methods and media into their plans. Objectives  By the end of the course you will be able to: Describe your Personal Training Style Explain how personality affects communication styles Use techniques to read delegates and adapt communications for greater impact Recognise the ‘games people play’ and how to deal with difficult behaviour Use techniques to establish credibility and enhance your reputation Identify the right approach to take when faced with a range of challenges Use advanced Presentation Skills Use facilitation and coaching skills for experiential workshops Use modern Training Methods and Media Deliver memorable training Note: Delegates attending this programme will be asked to complete an online psychometric in advance of attending the programme in order to help understand personal training styles Content Understanding your Personal Training Style Receive feedback from online Psychometric Understand personal training styles Understand personal communication and working style Understand the impact this has on audience Learn how to adapt your style for greater impact Growing your reputation as a trainer Your Training Persona Training Confidence Training Reputation Trainer Brand Understand the ‘Games People Play’ An introduction to Transactional Analysis (TA) for Trainers Using TA to:Contract for learningUnderstand Trainee AudienceUnderstand interpersonal stylesUnderstand working and thinking stylesWorking in groupsCreativity and innovation Developing deeper Trainer Skills Presentation Magic – making your presentations more effective Facilitation skills for workshops Coaching skills for classrooms and virtual training Delivering experiential workshops Modern Training Methods and Media Incorporating blended learning into your programmes Using Social Learning Using Videos Using Virtual Tools Using CBT and e-learning Pre-course work 1: Complete and online Psychometric Pre-course work 2: Deliver and record a 5-10-minute training session in your workplace on your phone and bring it with you Note: there is an option to have addition 1 hour coaching for delegates to support workplace learning after the course.

Elevate your skills in designing, delivering and evaluating engaging and interactive training that will leave a lasting impact on your team or organisation Course overview Duration: 2 days (13 hours) This Train the Trainer workshop will enable you to gain valuable insights and practice helping you to feel more comfortable and confident delivering training sessions. We will look at some training best practice tools and techniques to ensure you can deliver the learning outcomes required. The workshop covers the training cycle but focuses heavily on interactive and practical training techniques to bring learning to life for participants. There will be opportunities to practice delivery of real work-based training and receive feedback on delivery style. Objectives  By the end of the course you will be able to: Explain Kolb’s model of how adults learn Describe the 4 key learning styles and how to engage people with different learning styles Apply the training cycle to plan, design, deliver and evaluate your training Write SMART training objectives Use and select a variety of methods to make your training interactive, engaging and effective Describe ways to deal with difficult participants or situations that may arise Apply your training skills to deliver structured training sessions with more competence and confidence Content The Training Cycle Assessing needs Planning and preparing Implementing training Reviewing Assessing Assessing Needs Understanding the task Assessing the learner’s current ability Identifying the gap Planning and Preparing Having clear outcomes in mind What people learn: o Knowledge o Skill o Understanding How people learn: preferences and learning styles and methods suitable for each Planning a programme Planning a session – a systematic approach Assessing risk Writing and using SOPs in training Key Skills for Effective Training Explanation and Demonstration Questioning and Listening Observation and Feedback Facilitation and Debriefing skills Coaching Using questioning, listening and feedback to help learners solve problems and develop confidence Evaluation and Assessment How to measure reactions and participant satisfaction Use of tests and assessments to measure learning Organisational measures of learning transfer Leverage You will have the opportunity to deliver two training sessions on this programme and gain valuable feedback to support you in your ongoing training delivery. Participants are required to prepare a 15 minute training session. This can be something you have delivered before or something you’ve created for the course. Please prepare and include any visual aids you would usually use when speaking and bring them with you, f possible, please also bring your smart phone (with camera, and memory capacity for a short video clip to be added), and headphones.

Investigate and recognise the role of project sponsor and the importance of the relationship between sponsor and project manager and how this can be improved. Course overview Duration: 1 day (6.5 hours) This workshop is designed to investigate, understand and develop the role of the project sponsor. By taking elements of effective governance from the guidance published by the APM (Association for Project Management) and Axelos Managing Successful Programmes, an improved project sponsor capability can be developed. The workshop will also explore the importance of the relationship between sponsor and project manager and how this can be improved. Whilst predominately designed for the project sponsor role, there is provision for a discussion with project manager representatives to agree an action plan to improve the delivery of projects within an organisation. Objectives  By the end of the course you will be able to: Describe and commit to the role of the Project Sponsor Identify the key principles of governance that can contribute to success Describe the environment in which the projects are delivered Explain the financial and resource constraints within the project environment Define the criteria used for project selection Identify the expectations of key stakeholders and develop a clear communication plan to engage with them Identify and resolve areas of conflict Describe the relationship with the Project Manager Create an effective environment and relationship for project success Content Introduction The Project Environment The Principles of Governance The background to the training Roles The Project Sponsor The Project Manager The Project Board Sponsor responsibilities Defining Project Selection Criteria and Prioritisation Business Case and Justification Finance and Funding Resourcing the projects Stakeholder Engagement Project Governance Resolving conflict between stakeholders Benefits Realisation Capitalising the lessons learned during project reviews Delivering success The relationship with the Project Manager and team Action Plan for the future The workshop will use case studies drawn from previous client projects, both successful and less successful.

Understand the needs and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks. Course overview Duration: 2 day (13 hours) Our Project Risk Management course addresses risk management throughout the project lifecycle. This course is designed for project staff, including project leaders, sponsors, project team members, support staff and functional staff involved in project activity. The workshop is especially suited to teams working on bids, feasibility and project start up. The workshop covers the need and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks, human behavioural factors affecting risk management performance, and organisational interfaces and governance requirements. Objectives  By the end of the course you will be able to: Describe success factors and benefits arising from effective risk management Explain human behaviour factors affecting risk management Establish the project context and conduct an initial risk assessment Define an appropriate strategy and produce a risk management plan Define risk identification strategies and apply appropriate identification methods Identify and record important risk information including ownership Establish risk probability and impact levels; produce probability impact charts and severity time charts Establish exposure levels and contingency requirements Explain the principles of quantitative analysis Define and evaluate response options Implement effective risk management process control Content Principles of risk management Terminology Purpose Success factors Benefits and overall process Human factors that impact on risk management Initiate Analyse and determine context factors relevant to risk management Develop a robust risk management strategy for the life of the project How to conduct an initial risk assessment and define an outline strategy Identification Development of a risk identification strategy Appropriate methods and their strengths and weaknesse Determine an appropriate strategy and identify risks in a given case study Animating text Slide titles Bullet points Applying animation to Slide Master Assessment Methods commonly used for assessing and prioritising risks Evaluating exposure and contingency requirement Demonstration of quantitative methods and exercises to assess risks and contingency levels Planning and implementing responses Appropriate methods for responding to risks Defining implementation and control plans Assigning ownership Defining appropriate plans Conducting net benefits analysis and examining effectiveness Manage process Organisational interfaces and specific requirements to ensure appropriate controls Improvements and compliance with governance requirements

Develop your Project Management skills and fully understand the entire project lifecycle and key activities that need to be done to deliver a successful project outcome. Course overview Duration: 2 days (13 hours) The ability to run a successful project professionally is a valuable transferrable life skill that can enhance your career and opportunities in any industry. Our Principles of Project Management course takes a pragmatic approach to managing a project successfully. It looks at the entire project lifecycle and key activities that must be done to give a successful project outcome. This course is suitable for anyone who is involved in or about to run a project – either as a full-time project leader/manager or as a part of their role. Objectives  By the end of the course you will be able to: Identify 10 key principles for managing a project successfully Apply a common sense project lifecycle to a project regardless of its size or magnitude Develop robust project documentation throughout the lifecycle whilst keeping the documents to a minimum Identify the expectations of key stakeholders and develop a clear communication plan to engage with them Apply a range of planning and scheduling techniques to help manage the project timeline Produce realistic estimates to help monitor and control the project costs Manage key risks and issues associated throughout the project lifecycle Manage changes through a robust change control process Manage the Project team through the use of clearly defined Work Packages Identify and manage key areas of conflict throughout the lifecycle Content Introduction Key characteristics of projects v Business as Usual Definition of Programmes and Portfolios Project Lifecycles – A structured approach using phases Reasons why projects fail 10 principles of successful project management The Concept (Feasibility) Phase Analysing the project context / environment Stakeholder needs and requirements Content of a Business Case Differences between Benefits, Success Criteria, Success Factors and Key Performance Indicators (KPI’s) Purpose of the Project Brief The Definition (Planning) Phase Defining the Scope of a project Assigning Project roles and responsibilities Product Breakdown structures and Work Breakdown Structures Approaches to estimating Detailed planning using Gantt charts Critical path analysis Using project management software – an overview Constructing a realistic project budgets Resource allocation and optimisation Producing a Communication Plan The Implementing (Execution) Phase Delegating using a Work Package Project tracking and reporting Managing contractors Controlling changes to the project Risk and Issues management Managing conflict between stakeholders The Handover / Closure Phase Measuring project success Capturing Lessons Post project review and evaluation Benefits Realisation Transferring the deliverable into Business as Usual

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Understand what diversity and inclusion is and how to manage it affectively in the workplace. Course overview Duration: 1 day (6.5 hours) Diversity and Inclusion in the workplace will help you develop an understanding of why diversity and inclusion is important to a business, what it is and how individuals and teams can work effectively together and harness the power that comes from valuing diversity and promoting inclusion. Objectives  By the end of the course you will be able to: Describe why diversity and inclusion is important in teams and organisations Explain and overcome unconscious bias and other beliefs that cause exclusion and impact the workplace Recognise your own diversity and understand the value of diversity and inclusion in teams Develop an Action Plan to create an inclusive work climate Content Understand Diversity and Inclusion What the Equality Act 2010 says about diversity Understanding protected characteristics Learn how to create an optimum climate to unlock the power of a diverse teams Understanding Yourself and Unconscious Bias Identify your own unique characteristics and how these could impact your performance Examine self-limiting beliefs and how these can impact personal performance Experience how unconscious bias impacts our information gathering, problem solving, judgement and decision making Creating a Diverse and Inclusive Team Climate Understand the importance of respect, the role of trust and what valuing diversity really means Apply the ABC Model to the creation of a diverse climate:Awareness – be alert, self-aware and aware of othersBoundaries – understand how things can go wrong when working with others: boundaries, banter and bullyingCoaching – learn listening and coaching skills to promote inclusion Create an achievable, personal action plan that can be applied immediately in the workplace to improve diversity, promote teaming and create an inclusive work climate

Discover the more complex features of Word for long document creation. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 2) course shows you some of the more advanced features of Word that are key for long document creation. This course will enable you to create longer, more complex documents with ease, including adding cross references, headers and footers and a table of contents. This course is aimed at existing Word users who have attended our Word Document Production (Part 1) course or have equivalent knowledge and who want to extract the most out of the package. Objectives  By the end of the course you will be able to: Create, amend and use templates Use styles for easy formatting Work with section breaks Manage linked headers and footers Insert pictures and objects Add cross references Create a table of contents Use tracked changes Content Creating templates Creating templates Using templates Amending templates Using styles in templates Adding styles to a template Using Heading Styles Managing Styles Applying template style changes directly from a document Copying styles between templates Working with different types of section break Next page section breaks Odd and even section breaks Inserting page numbers, headers and footers Creating custom headers and footers Inserting fields Using Section breaks Dynamic linking between Sections Page numbering in Sections Graphics Inserting pictures Inserting objects from other packages Object text wrapping options Picture options Adding cross references Creating cross references Creating a table of contents Generating a table of contents Setting table of contents styles Updating a table of contents Track changes Setting track changes Accepting and rejecting changes Viewing comments The reviewing pan

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. Course overview Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. Objectives  By the end of the course you will be able to: Create and amend flowcharts Create cross functional (Swim Lane) process flows Produce organisation charts by importing data Add essential data to shapes Export diagram data reports to Excel Present, publish and print Visio diagrams Content Visio essentials Finding your way around Visio Using the ribbon and Quick Access toolbar Keyboard shortcuts Shapes and stencils explained What Visio can do for you Creating basic flowcharts Working with shapes Adding and deleting shapes Joining, aligning and sizing shapes Using Auto-Connect Labelling shapes and connectors Editing and improvinC flowcharts Amending shape and connector labels Using colours to emphasise Changing line styles Moving and copying objects Grouping diagram elements Quick ways of working Cross functional flowcharts Creating Cross-Functional Flowcharts Manipulating functional bands Creating off-page references within diagrams and hyperlinks to other documentation Organising charts and shape data Using the wizard to create an organisation Chart Importing existing Data into to create an organisation chart Modifying an organisation chart Shape Data Adding shape data to a shape Creating shape data sets Diagram reports Exporting data to a report in Excel Exporting to HTML Creating and customizing reports Presenting, publishing and printing Using Page Setup Print previewing Embedding backgrounds Adding headers and footers Converting your final documentation to PDF Saving as HTML Visio with PowerPoint