6411 Courses in Worsley delivered Live Online

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

Use the features in project to report effectively on your plans. Course overview Duration: 4 hours Our Project – Reporting course is aimed at experienced users of Project who need to create reports in their project plans. It looks at using the different types of report in Project, exporting data to other packages, building new reports and sharing reports between projects. Experience of using Project to create and resource plans is required. Objectives  By the end of the course you will be able to: Print and PDF data from your project Use timelines Setup filters and groups Import and export data Create and share dashboard reports Content Printing and reporting Setup and Printing Creating PDFs Visual reports Using the Timeline Filtering and grouping Applying filters Applying grouping Creating your own filters and groups Importing and exporting data Importing data into Project Exporting data Creating and saving data maps Dashboard reports Using dashboard reports Creating dashboard reports Adding widgets Customising data shown

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

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.

Some people naturally possess an ability to sell and others over time develop their own style. We have created a highly practical course to give you the confidence and ability to sell over the phone or face to face. We focus the exercises, theory and discussion on your own job role and experiences to ensure you can return to the workplace to deliver tangible results. This 2-day course is designed for individuals who are new to selling, those in a sales role but have not received any formal training, or professionals who would like to brush up and enhance their current selling skills and learn some new techniques. Course Syllabus The syllabus of the Essential Selling Skills course is comprised of seven modules, covering the following: Module One Understanding the Customer The importance of good customer care Selling vs. selling attitude The reasons people buy Adopting a positive approach Module Two Self-Awareness Understanding your selling style Adapting your selling style to your customer Understanding your customers buying style Module Three Effective Communication and Rapport Building Why does communication need to be effective? Actively listening to your customers' needs Right question at the right time The impact of positive and emotive language Module Four Taking a Consultative Approach Different styles of selling Taking a consultative approach to selling Preparation techniques Buyer behaviour and motivation A selling approach to match the buyers mind Module Five Presenting the Solution Selling the benefits Sales tool kit Unique sales points Advanced questioning techniques Module Six Gaining Commitment Recognising and acting upon buying signals Dealing with customers concerns No means no? How to cope in stressful situations Module Seven Confirming the Sale Confirming or closing? Effective confirming techniques Going the extra mile Benefits For you as an individual This course will increase your confidence and ability to sell, having provided you with tools and techniques to achieve maximum results. Delegates always leave with fresh ideas, energy and motivation to succeed. For an employer The attitude of the delegates and the results they deliver will speak for themselves. All techniques are easy to apply back into the workplace for an immediate impact. What will I learn? By the end of the course, participants will be able to: Appreciate the need for preparation before a sales appointment Effectively identify and meet needs with advanced questioning techniques Identify verbal and non-verbal buying signals Construct professional answers to questions and possible objections Present your products and/or services with the buyer in mind Identify and use a selling style appropriate to capture the buyer's attention Recognise and overcome major objection types How to apply effective confirmation techniques with the buyer in mind Real Play Option We offer an innovative solution to engage the learners and bring real negotiation and closing scenarios to life. We use actors who improvise scenarios which have been specified by the group. The group is split the group into 2 sub-groups, one with the actor, the other with the trainer. Each group has a brief and has to instruct their trainer/actor on how to approach the scenario supplied. The actor and trainer perform the role play(s) as instructed by their respective teams; however during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) - not the performers. Scheduled Courses This course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information please contact us.

This course is designed to provide delegates with awareness in the Control of Substances Hazardous to Health (COSHH) and how it may affect them, their colleagues, and their employer.

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