7053 Courses delivered Live Online

The aim of this course is to provide an overview of the key principles and techniques for leading and managing project work. It will focus on the core principles and generic methods of project management, showing how these can be applied to typical projects. 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 of, and help participants understand the skills required by, the project leader Illustrate the use of project skills through examples and case studies Identify ways to improve project management, both individually and corporately DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Key concepts and requirements for success Projects and project management Lessons from past projects; the essential requirements for success Differences between projects; characteristic project life cycles The challenges of project management; the role of the project manager Project exerciseA team exercise to demonstrate the challenges of project management 3 Defining project objectives and scope Identifying the stakeholders; key roles and responsibilities Getting organised; managing the definition process Working with the 'customer' to define the project scope 4 Project case study: part 1 Defining the project objectives: syndicate teams define the objectives and scope for a typical project 5 Project planning The nature of planning; recognising planning assumptions Planning the plan; the importance of team involvement Developing the work breakdown structure Estimating task resources, timescales and costs Developing the project schedule Analysing the plan and identifying the critical path 6 Project case study: part 2 Creating the project plan Syndicate teams begin development of their project plans (for completion after session 7) Team presentations and group discussion (after session 7) DAY TWO 7 Managing project risks Understanding and defining project risks Classifying risks and adopting an appropriate risk strategy Identifying, evaluating and managing project risks Agreeing ownership of project risks; the risk register Integrating planning and risk management 8 Project control Pro-active and re-active control; striking the right balance Pre-requisites for effective, pro-active project control Avoiding unnecessary 'scope creep' and controlling change Selecting the data needed to provide early warning of problems Monitoring project performance: 'S' curves, slip charts, earned value Getting good data and assessing project status Defining the roles and responsibilities for control Setting up a routine process for keeping up to date Managing and controlling multiple projects 9 Project case study: part 3 Controlling the project Teams control their project as new developments take place 10 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

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

What do engineers and project managers need to know of finance? 'Nothing - leave it to the accountants!' No, no, no! Engineers must be conversant with the terminology and statements that accountants use. Technical expertise in projects, service delivery, production or other areas can only really be harnessed if the managers understand the accounting and reporting that drives businesses. This course gives the necessary understanding to project, production and technical managers. It develops their skills in understanding financial and management accounting. Accountants may not always like it but a major part of their work is to be the 'servants of business' and to gather, compile and present your figures. So you must understand the figures - they belong to you, your processes or projects. There are many reasons for maintaining accurate accounts. This course focuses on the strategic issues (those over-used words) - what figures reveal about the drivers of business and what they reveal about the day-to-day issues that accountants bother you with. The course will enhance your understanding of finance and of the accounting issues which affect your projects, production and technical areas of business. This course will help you: Understand the business world in figures - make sense of what the accountants are telling you Appreciate what drives business - and how this affects your role in your part of the business Relate your activities to the success of the business - through figures Gain the skills to advance in management - financial awareness is a 'must have' if you are to progress in your career 1 What do accountants do? The finance function, types of accountant, financial v management accounting and the treasury function Understanding the role of the finance function and how the information you provide may be used 2 The basic financial statements Balance sheets and income statements (P&L accounts) What they are, what they contain and above all what they can reveal - how to read them The accounting process - from transactions to financial statements What underpins the statements - accounting systems and internal controls 3 Why be in business - from a financial perspective The driving forces behind financial information Performance measures - profitability, asset utilisation, sales and throughput, managing capital expenditure 4 Accounting rules - accounting standards Accounting concepts and the accounting rules: accruals, 'going concern' - substance over form and other 'desirable qualities' Accruals - why the timing of a transaction is so important to the finance function Depreciation and amortisation - the concepts and practice Accounting standards - the role of International Financial Reporting Standards 5 Cash The importance of cash flow - working capital management Cash flow statements - monitoring overall cash flows Raising cash - levels of borrowing, gearing Spending cash - an outline of capital expenditure appraisal 6 Budgeting Why budget? - good and bad practice Determining why budgets play a key role and should not be simply an annual ritual Justifying your budgets - the link between the strategic plan and day-to-day budgeting - alignment of company culture Budgets as motivators - the importance of the right culture Techniques to improve budgeting - whether day-to-day or capital budgeting 7 Costing The type and detail of costing very much depends on your business - eg, manufacturing piston rings is quite different from the construction of a power plant Issues with overhead allocation Accounting for R&D 8 Reading financial statements Annual financial statements - why they are produced, what's in them and what you should look for Learning what a set of accounts reveals about a company's current situation, profitability and future prospects 9 Performance measurement - analytical reviews and ratio analysis ROI/ROCE Profitability, margins and cost control Sales - asset turnover Efficiency (asset / stock turnover, debtor / creditor days) 'City' measures Investment (interest / dividend cover, earnings per share, dividend yield)

The importance of building services to the success of an organisation has never been greater and continues to grow. Developers and occupiers are becoming more aware of the contribution that building services make to the well being of occupants and hence their perception of the quality of the working environment. Those involved with the design, construction, maintenance and operation will increasingly be required to deliver building services that demonstrable contribution to the occupier's business. Energy efficiency, carbon management and occupant satisfaction depend substantially on the way building services are designed, managed and operated. To optimise these aspects, an informed strategic approach is essential. Tried and tested techniques and processes are available that, when applied holistically, will deliver substantial benefits. This course reviews best practice in the area and inspires participants to ensure that building services perform at their optimal level. To provide a better understanding of how building services can be designed, managed and operated to: Maximise occupant comfort, satisfaction and wellbeing Add value and contribute to the success of the business of the occupier Improve health safety Reduce operating cost, energy use, carbon emissions and environmental impact Optimise cost and value Provide strategies for continuous improvement and sustainable operation 1 Building services fundamentals The function of services in commercial buildings and their importance to the core business 2 Techniques and processes for optimising cost and value Programmed operation evaluation Continuous commissioning Lifetime product management Performance-based service Energy efficiency and the scope for environmental improvement 3 Making the business case and preparing the strategy Motivating decision-makers Empowering those who have to deliver the results Managing business risk 4 Strategy implementation and monitoring results Ensuring that rich and robust feedback is available to support continuous improvement and strategy enhancementWhen to get feedbackWhyHowWhat to do with it 5 Case histories and 'air time' Sharing experience and addressing specific issues of interest to participants Course review Close

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

This course follows the Institute of Occupational Safety and Health's syllabus. A one-day programme, it is suitable for all people at all levels in the workplace and gives a basic introduction to the principles of environmental management. On successful completion of the course, participants will be able to: Understand the terms 'environment' and 'pollution' Understand the terms 'hazard' and 'risk' related to the environment Better appreciate environmental issues generally, and specifically in respect of their organisation Identify hazards to the environment from working practices Outline the procedures/controls necessary to prevent damage to the environment 1 What is the environment? - putting the environment in context Key environmental issues and how we contribute Definition of the environment 2 Working with the environment What is pollution? Sources, receptors and pathways Environmental consequences workshop - identifying the environmental consequences of our working practices Environmental risk assessment Effective control mechanisms 3 Protecting the environment - Environmental Management Systems What is an Environmental Management System (EMS)? What are the benefits of having an EMS? EMS structure and models Identifying what elements of EMS your company has and how they work Roles and responsibilities 4 Choice of module Option 1: Organisation-specific moduleThis module can be used to introduce environmental concepts that are specific to your activities and operations, and will be compiled through discussion with your organisation Option 2: Environmental best practiceIf no organisation-specific module is required, or if participants from a number of organisations attend, generic operational environmental best practices can be covered instead. Areas covered include waste management, fuel storage and use, hazardous materials, emissions to air and water and environmental incidents

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

Conflict is a word that conjures up many emotions. It is something that most people would prefer to avoid, if possible. Work can be an emotive place. Positive relationships can make your life at work exciting, motivating and challenging, whilst relationships that do not hold value to you could make your life very difficult and stressful, especially if there is conflict between you and your manager. This course is essential for people who want to understand where conflict can be used to positive effect and how to manage conflict in your working relationships and see it as something positive that can stimulate the environment. Research has shown that relationships at work are an extremely high motivational factor, and for a lot of people it has a higher importance that salary! Therefore, it is essential that we invest in relationships and search out new ways to make them better in order to have a more positive influence on our surroundings. By understanding why other people are in conflict we can manage the conversation a lot better, with outcomes managed more effectively so the 'conflict' will add value to the organisation. This participative event will cover a wide variety of exercises and personal stories, and leave course participants with a clear strategy to identify when they are in conflict with someone and how they will structure their approach to get to a satisfactory outcome. This is a workshop that targets anyone where conflict needs to be managed and cannot seem to resolve it, whether internally or externally. At the end of the day, participants will: Know their key relationships and the strength of those relationships Complete the Strengths Deployment Inventory (SDI) to identify where you deploy your strengths Understand what is important to you and your key stakeholders Know how motivational value systems can influence behaviour Tailor your communication style to match that of your opposite party Know conflict strategies to resolve conflict in others Learn to be more assertive when challenging Achieve key personal, departmental and organisational objectives 1 Where are you now? How effective are your current working relationships? Can I work effectively without the input from others? Who do you need to be a success? 2 The Strengths Deployment Inventory (SDI) Completion of the SDI questionnaire An understanding of the theory A 'trip around the triangle' Predicting relationship interaction Your scores and what they mean in your relationships 3 Conflict theory What is conflict? The 3 flags of conflict What are your conflict triggers? Your conflict scores plotted The conflict sequence 4 Conflict resolution strategies Early warning signs Most productive behaviours Least productive behaviours Preventable / unwarranted conflict Review of the dynamic triangle Review of the day, personal learning and action planning

This workshop will help you create, develop and close business opportunities using a consultative approach and a value-based (not price-led) proposition. Value-based selling means working the way your customer wants to buy, not how you want to sell. It also means: In a transactional sale the customer knows the answer without help from a salesperson (or cannot see why they should choose you), or is prepared to stay with what they have. Customer decision criteria are price and convenience and customers resent time spent with (new) salespeople, mainly because the salesperson adds little or nothing to what the customer already has and just wastes time. In a consultative or value-based sale, by contrast, the customer doesn't know the answer already. The salesperson must take the role of an advisor, not just a 'product promoter'. Customers demand expertise, advice and customisation during the sales process. Often customers insist on multiple meetings with salespeople and others to develop advantages that you can bring and reduce the perceived risk of changing. In this way the salesperson often adds more value than the product or service alone. This very practical workshop will help you use proven strategies and tactics to build, manage and successfully close sustainable business opportunities using a consultative approach and a value-based (not price-led) proposition. This includes: Increased impact of your new sales conversations, presentations and proposals - leading to faster decisions and increased conversion Greater confidence, consistency and professionalism throughout the business development process Enhanced sales questioning skills and techniques, leading to better, faster and more accurate development of customer needs, problems, value and expectations Improve your people, communication, influence and persuasion skills when approaching, consulting or presenting your services and solutions How to build value at all points in the customer's buying process through your knowledge, skills and structured approach Proven ways to gain additional business and referrals from existing customers and contacts, through direct approach and lead generation Being better able differentiate your firm, your solutions, track-record and expertise clearly and accurately with tailored value statements for each stage and for each opportunity Overcome and avoid price-based objections, buying criteria and negotiation 1 Introduction and key principles of value-based selling Introduction and review of pre-course questionnaires - KPIs, personal learning objectives and key principles The main principles of value-based selling and how they benefit you and the customer How value-based selling differs from 'transactional' or 'price-based' selling The stages of the customer's buying cycle - how to identify and work through strategies for each stage The concept of structured and set-piece selling and proposing Presentation by participants: Personal sales improvement goals 2 Value-based selling strategies and skills What is value? How can one move away from a price-led agenda? How to survive and resist price pressure - six techniques A review of key competencies and skills needed for a value-based approach Strategies, case studies and examples with discussion and review Defining your initial value proposition and comparative advantage How best to established the right level of trust, rapport and credibility Planning and practice session: Strategy - mapping a value-based sales process. 3 Connecting skills Research before the meeting and the first few minutes - ways to gain instant rapport and setting the foundation for a successful outcome in a first sales call How to structure an effective first time sales call or meeting - the subtle differences that are important to master How best to differentiate your solutions and build credibility and enthusiasm early or at the start of the buying process Overcoming initial buying resistance and relaxing the prospect; gaining rapport, opening the meeting: PBC (purpose-benefit-check) and gaining agreement to proceed Planning and practice session: Connecting - first meeting with a new contact 4 Consulting - building, developing and influencing client needs Understanding the power of high-impact and third-level questions to influence people based around specific needs and solutions The importance of body language and other personal communication dynamics when asking questions; empathic listening, run-on questions, drawing out skills, summarising, etc Creating a 'disturb' approach to creating needs and opportunities and positioning your solutions Using proven advanced sales questioning techniques with greater skill: Outcome, SPIN and qualification questions 'Decision-making criteria' - tools to help you develop the relevant criteria with the customer and in doing so progress your sales opportunities more effectively Planning and practice session: Questioning skills 5 Convincing - presentation and persuading skills practice Substance and style - selecting the right tone and content to engage and enthuse your prospect Compelling benefits and reducing perceived risk - key messages to deliver Helping the customer choose your proposition - by being convincing, compelling and credible when you present Professional and effective presentation skills - with personal coaching and practice sessions The keys of influence and persuasion and the keys to convincing a new customer to choose you for the first time Planning and practice session: Role-play in presenting your solution 6 Commitment Knowing when and how to close for commitment to the next stage in your sales process, plus ways to ask for commitment professionally and effectively How to isolate, prioritise and answer objections and concerns more openly and accurately, using a consultative not a confrontational approach Deal more effectively and profitably with price objections and reduce buyer's remorse (which can lead to an 'I want to think about it' reaction and cause delay and inertia) Key negotiation skills around the closing process - getting to 'yes' Planning and practice session: Role-play in closing and negotiation skills 7 Assessed role-play - Final practice session Live role-plays There is an option for external participants to be brought in to the live training workshop to take-part in the final assessed role-play or assist with other sessions run during the course. Performance assessment - 'Dragon's Pitch' The final afternoon of the course is an assessed role-play using a prepared scenario and external 'CEO'. The assessment criteria will be agreed prior to the workshop. 8 Workshop summary and close Personal action plan and learning summary

This is an essential programme for members of staff whose role exposes them to aggressive or violent behaviour. 1 What's happening? Issues around us Risks in context Personal experiences 2 Safety fundamentals Following internal policy and procedure Personal safety and lone working Use of technology 3 Nipping issues in the bud Recognising early warning signs Avoiding causing problems for ourselves 4 Calming - Reaching - Controlling Tips and techniques for potentially calming a situation Reaching and building rapport Accelerants - tips on avoiding accelerating a situation Assertiveness techniques Non-verbal behaviour Active listening and the use of questions and distractions Exploring ways forward and identifying win/wins Avoiding the secondary argument Fogging The 'drama triangle' If all else fails... 5 Harassment, stalking and on-line bulling What constitutes harassment and definition of stalking On-line bullying Steps to take 6 Reporting principles Importance of incidence reporting Taking care of us What next?