2176 Courses in Sheffield

How do you manage yourself under pressure? Are there times you get hijacked by your emotions and find it hard to deal with setbacks? How good are you at dealing with change? Resilience is all about having the ability to adapt, deal with change constructively and bounce back from adversity. While some people are naturally more resilient that others it is something that can be learnt. This session focuses on helping you respond positively to the pressures and demands of work and take specific steps in building your personal resilience. Take away: Action planner for i-resilience profile. You will have the opportunity to: * Gain insight into the relationship between work pressure, performance, wellbeing and resilience * Explore your natural strengths and how to manage what pushes you into a less resourceful state * Understand the skills and techniques that underpin the behaviours and attitudes of highly resilient people

The CIEH Foundation Certificate in Occupational Health and Safety supports businesses in their legal obligations to ensure employees are protected from harm. This course is ideal for those who want to develop their knowledge of health and safety issues in the workplace and of the regulations for maintaining a healthy and safe working environment. This course will focus on common hazards and how to control them. It will help you work more safely and be more aware of how your own actions can affect the health and safety of others.

A high-impact programme designed to be fun and to get people fully involved. The first-class, jargon-free content is based on what people need to know in practice, not off-putting legal language. THIS INTRODUCTORY COURSE COVERS: * Introducing Working Safely: Accidents can happen to anyone. The realities of the human suffering behind the statistics. The importance of personal responsibility. * Defining hazard and risk: Focusing on the six broad hazard groups, participants are asked to think about the hazards and risks they come across in their own work. 'Risk assessment' demystified. * Identifying common hazards: All the main issues - aggression and violence, asbestos, bullying, chemicals and harmful substances, computer workstations, confined spaces, drugs and alcohol, electricity, fire, getting in and out, height, housekeeping, lighting, manual handling, noise, personal hygiene, plant and machinery, slips and trips, stress, temperature, vehicles and transport, and welfare facilities. * Improving safety performance: Bridging the gap between management and workforce, encouraging participants to play their part. Also covered: contract work, inspections, safe systems and permits, protective equipment, signage, emergency procedures, reporting and health checks.

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: * Plan and create a database * Sort and filter records * Use field data types * Work with tables * Create and manage a query * Create and work with forms, and use the form wizard * View, create and print reports 1 ACCESS INTRODUCED * Planning a database * Creating a blank database * Opening an existing database * Security warnings * The navigation pane * Previewing database components * Closing an Access database 2 TABLES INTRODUCED * Viewing and navigating table data * Navigating using keyboard shortcuts * Editing table data * Adding records to tables * Selecting and deleting records * Finding and replacing data * Filtering tables * Summing table data 3 QUERIES INTRODUCED * Opening a query in datasheet view * Opening a query in design view * Adding fields to a query * Sorting query results * Modifying datasheet view * Saving and closing queries 4 FORMS INTRODUCED * Working with form data * Sorting records * Filtering records * Working in design and layout views * Changing object attributes 5 REPORTS INTRODUCED * Opening and viewing reports * Viewing a report in design view * Previewing and printing report data * Creating reports with auto report * Creating reports with the report wizard * Changing field attributes 6 CREATING A NEW DATABASE * Creating database tables * Creating table fields * Selecting field data types 7 TABLE RELATIONSHIPS * Introducing relationships * Establishing table relationships * The one-to-many relationship type * Establishing referential integrity 8 CREATING QUERIES * Streamline query criteria using wildcards * Creating summary queries * Creating queries based on criteria * Running date queries * Formatting field properties * Building queries from multiple tables * Summing in queries 9 CREATING FORMS * Creating a new form * Inserting form fields * Working with the property sheet * The command button wizard * The command button wizard * Programming without typing * Creating forms with embedded sub forms * Creating forms with the sub form wizard * Creating forms with the form wizard 10 CREATING REPORTS * What are report bands? * Managing report controls * Basing reports on multiple tables * Basing reports on queries * Sorting and grouping records

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: * Create custom shows to personalise presentations for individual clients * Make the Slide Master work collectively with slide layouts and themes * Seamlessly interact with external content using links * Work with advanced animations and transitions, and video/audio tools 1 THEMES AND MASTERS * Add a Design theme to a presentation * Make changes to the Slide Master * Delete layouts from the slide master * Saving a slide master with themes as a template 2 ADVANCED GRAPHICS AND DIAGRAMS * Drawing, duplicating and resizing shapes * Grouping, aligning and stacking shapes and graphics * Using SmartArt for diagrams and organisation charts 3 GRAPHS AND CHARTS * Inserting and formatting a chart * Linking an Excel chart to a slide * Linking Excel tables to a slide * Animating charts 4 VIDEO, CUSTOM ANIMATION AND HYPERLINKS * Adding and editing video * Animating pictures and drawings * Hyperlink to another Slide or Website * Compressing and optimising media 5 PRESENTING * Reuse slides * Hide slides * Rehearsing timings * Enabling a presentation to run continuously

This five-day programme empowers participants with the skills and knowledge to understand and effectively apply best practice commercial and contracting principles and techniques, ensuring better contractor performance and greater value add. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Practitioner (CCMP) qualification. By the end of this comprehensive programme the participants will be able to: * Develop robust contracting plans, including scopes of work and award strategies * Undertake early market engagements to maximise competition * Conduct effective contracting and commercial management activities, including ITT, RFP, negotiated outcomes * Understand the legalities of contract and commercial management * Negotiate effectively with key stakeholders and clients, making use of the key skills of persuading and influencing to optimise outcomes * Undertake effective Supplier Relationship Management * Appreciate the implications of national and organisational culture on contracting and commercial activities * Appreciate professional contract management standards * Set up and maintain contract and commercial management governance systems * Take a proactive, collaborative, and agile approach to managing commercial contracts * Develop and monitor appropriate and robust KPIs and SLAs to manage the contractor and facilitate improved contractor performance * Appreciate the cross-functional nature of contract management * Collaborate with clients to deliver sustainable performance and to manage and exceed client expectations * Understand the roles and responsibilities of contract and commercial managers * Use effective contractor selection and award methods and models (including the 10Cs model) and use these models to prepare robust propositions to clients * Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates * Effectively manage the process of change, claims, variations, and dispute resolution * Develop and present robust propositions * Make appropriate use of best practice contract and commercial management tools, techniques, and templates DAY ONE 1 INTRODUCTION * Aims * Objectives * KPIs * Learning strategies * Plan for the programme 2 THE CONTRACTING CONTEXT * Key objectives of contract management * Importance and impact on the business 3 CRITICAL SUCCESS FACTORS * Essential features of professional commercial and contract management and administration * The 6-step model 4 PUTTING THE 'MANAGEMENT' INTO COMMERCIAL AND CONTRACT MANAGEMENT * Traditional v 'new age' models * The need for a commercial approach * The added value generated 5 DEFINITIONS * 'Commercial management' * 'Contract management' * 'Contracting' * ... and why have formal contracts? 6 STAKEHOLDERS * Stakeholder mapping and analysis * The 'shared vision' concept * Engaging with key functions, eg, HSE, finance, operations 7 ROLES AND RESPONSIBILITIES * Contract administrators * Stakeholders 8 STRATEGY AND PLANNING * Developing effective contracting plans and strategies DAY TWO 1 CONTRACT CONTROL * Tools and techniques, including CPA and Gantt charts * A project management approach * Developing effective contract programmes 2 THE CONTRACTING CONTEXT * Key objectives of contract management * Importance and impact on the business 3 TENDERING * Overview of the contracting cycle * Requirement to tender * Methods * Rationale * Exceptions * Steps * Gateways * Controls * One and two package bids 4 TENDER ASSESSMENT AND CONTRACT AWARD I - FRAMEWORK * Tender board procedures * Role of the tender board (including minor and major tender boards) * Membership * Administration * Developing robust contract award strategies and presentations DAY THREE 1 TENDER ASSESSMENT AND CONTRACT AWARD II - PROCESSES * Pre-qualification processes * CRS * Vendor registration rules and processes * Creating bidder lists * Disqualification criteria * Short-listing * Using the 10Cs model * Contract award and contract execution processes 2 MINOR WORKS ORDERS * Process * Need for competition * Role and purpose * Controls * Risks 3 CONTRACT STRATEGY * Types of contract * Call-offs * Framework agreements * Price agreements * Supply agreements 4 CONTRACT TERMS I: PRICING STRUCTURES * Lump sum * Unit price * Cost plus * Time and materials * Alternative methods * Target cost * Gain share contracts * Advance payments * Price escalation clauses 5 CONTRACT TERMS II: OTHER FINANCIAL CLAUSES * Insurance * Currencies * Parent body guarantees * Tender bonds * Performance bonds * Retentions * Sub-contracting * Termination * Invoicing 6 CONTRACT TERMS III: RISK AND REWARD * Incentive contracts * Management and mitigation of contractual risk DAY FOUR 1 CONTRACT TERMS IV: JURISDICTION AND RELATED MATTERS * Applicable laws and regulations * Registration * Commercial registry * Commercial agencies 2 MANAGING THE CLIENT-CONTRACTOR RELATIONSHIP * Types of relationship * Driving forces * Link between type of contract and style of relationships * Motivation - use of incentives and remedies 3 DISPUTES * Types of dispute * Conflict resolution strategies * Negotiation * Mediation * Arbitration DAY FIVE 1 PERFORMANCE MEASUREMENT * KPIs * Benchmarking * Cost controls * Validity of savings * Balanced scorecards * Using the KPI template 2 PERSONAL QUALITIES OF THE CONTRACT MANAGER * Negotiation * Communication * Persuasion and influencing * Working in a matrix environment 3 CONTRACT TERMS V: DRAFTING SKILLS * Drafting special terms 4 VARIATIONS * Contract and works variation orders * Causes of variations * Risk management * Controls * Prevention * Negotiation with contractors 5 CLAIMS * Claims management processes * Controls * Risk mitigation * Schedules of rates 6 CLOSE-OUT * Contract close-out and acceptance / completion * HSE * Final payments * Performance evaluation * Capturing the learning 7 CLOSE * Review * Final assessment * Next steps

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 'golden rule' of negotiation is simple - don't! But life's rarely that simple and very often we do have to negotiate, particularly if we want to win the business and especially if we want to win it on our terms. Such negotiations are crucial. We need to prepare for them. We need a strategy, and the skills to execute it. Does your team have a structured approach? Is it flawlessly executed, every time? Or is there room for improvement? This programme will help them master the six fundamentals of closing better business: Manage all these elements well and you will win more business, more profitably. This course will help participants: * Negotiate from a position of partnership, not competition * Deal more effectively and profitably with price objections * Identify and practise successful sales negotiating skills * Identify strengths and weaknesses as a sales negotiator * Understand different types of buyer behaviour * Learn to recognise negotiating tactics and stances * Apply a new and proven structure to their business negotiations * Identify and adapt for different behavioural styles * Be alert to unconscious (non-verbal) communication * Prepare and present a proposal at a final business negotiation stage * Project confidence and exercise assertiveness in all sales negotiations 1 PLANNING FOR SUCCESSFUL BUSINESS NEGOTIATIONS This session introduces the concept of business negotiation and looks at its importance in the context of the participants' roles and activities. It briefly examines why we negotiate and the dynamics involved. Session highlights: * What kind of a negotiator are you? * Negotiation skills self-assessment and best practice * How to establish roles and responsibilities for both parties * How to identify and set objectives for both buyer and seller * How to research and establish the other person's position (business negotiation stance) 2 HOW TO STRUCTURE YOUR NEGOTIATIONS This module presents an eight-step framework or structure for use in negotiations and considers how best to prepare and plan your negotiations within the context of a supplier/customer relationship or business cycle. It also includes a brief review of legal responsibilities and what constitutes a 'deal'. Session highlights: * Learn and apply a formal structure to use when negotiating * How to establish short- and longer-term objectives and opportunities * How best to plan, prepare and co-ordinate a major business negotiation meeting, or on-going negotiations * Understanding of basic legal and organisational requirements 3 VERBAL NEGOTIATION SKILLS This session examines the human and communication dynamics inherent in any negotiation situation. It emphasises the importance of professional skills in preparing for a negotiation by identifying needs, wants and requirements accurately and by qualifying the competitive and organisational influences present. Session highlights: * How to fully 'qualify' the other party's needs, requirements and constraints during the negotiation process by using advanced questioning and listening skills * How to pre-empt negotiation objections by promoting and gaining commitment to options, benefits, value and solutions * How best to propose and suggest ideas, using drawing-out skills 4 NON-VERBAL NEGOTIATION SKILLS This module highlights how different personal styles, corporate cultures and organisation positions can influence events, and demonstrates practical methods for dealing with and controlling these factors. It also examines key principles of body language and non-verbal communication in a practical way. Session highlights: * Gaining rapport and influencing unconsciously * Understanding the importance of non-verbal communication; reading other people's meaning and communicating effectively as a result * Ensure that non-verbal behaviour is fully utilised and observed to create maximum impact and monitor progress (eg, buying signals) * Recognising that business negotiations are precisely structured and agreements gained incrementally 5 PROPOSING AND 'PACKAGING' This session highlights how best to present and package your proposal. It looks at how to pre-empt the need for negotiating by creating minor-options and 'bargaining' points, as well as how to manage the expectations and perceptions of the customer or buyer. Session highlights: * How to identify the key variables that can be negotiated * The power and use of 'authority' within your negotiations * How to structure and present your proposal, ideas or quotation to best effect * The importance of when and how to identify and influence buyer's objections 6 DEALING WITH PRICE This module highlights how to best present and package price within your proposal or negotiation. In most cases, price has more to do with psychology than affordability and preparation and careful handling are essential. Session highlights: * The three reasons that people will pay your asking price * How to set price in a competitive market * The key differences between selling and negotiating * Ten ways to present price more effectively and persuasively 7 GETTING TO 'YES': TACTICS AND STRATEGIES There are many different tactics and strategies common to successful negotiators. This session looks at those that are most appropriate to the participants' own personal styles and situations. The importance of 'follow-through' is also explained and how to deal with protracted or 'stale-mate' business negotiations. Session highlights: * How to negotiate price and reduce discounting early in the process * How to recognise negotiating tactics and strategies in your customer or supplier * Key strategies, techniques and tactics to use in negotiation * The importance of follow-through and watching the details * How to deal with stalled business negotiations or competitor 'lock-out' 8 CASE STUDIES AND REVIEW This session examines a number of different situations and participants discuss ways to approach each. This will allow learning to be consolidated and applied in a very practical way. There will also be a chance to have individual points raised in a question and answer session. Session highlights: * Case studies * Question and answer * Planning worksheet * Negotiation 'toolkit' and check-list 9 PERSONAL ACTION PLANS Session highlights: * Identify the most important personal learning points from the programme * Highlight specific actions and goals * Flag topics for future personal development and improvement

If your organisation manages contractors then your staff need to understand the health and safety issues. This course is the answer. The expert trainer will set out clearly the legal responsibilities of all relevant parties and explore the practical application of these responsibilities with the course participants. The course will then examine the issues associated with the planning of work to be contracted out and the evaluation, selection, control and monitoring of contractors engaged to undertake the work. Although the main focus is on health and safety, the course will also explain how health and safety issues need to be integrated into your organisation's functional management processes to ensure effective control of contractors. The course will consider all types of contracted activities, including construction and maintenance, cleaning, security, plant installation, etc. This programme will give participants: * A clear understanding of the organisation's legal responsibilities for managing contractors * The information they need to assess the competence of contractors * A practical understanding of risk assessment principles and the transfer of risk to contractors * A step-by-step guide to the key aspects of managing contractors in practice, covering: * Planning of the work * Selecting contractors * Handover prior to work commencement * During the work * Reviewing the work on completion * Practical guidance on the integration of health and safety controls into organisational procedures for contractor management 1 INTRODUCTION * Who are contractors? * Why manage contractors? * Different types of contractors * Costs of poor contractor performance 2 OVERVIEW OF HEALTH AND SAFETY LAW AND LIABILITY * Health and safety law and statutory duties * Relevance of civil and criminal law * Enforcement and prosecution 3 RELEVANT LEGISLATION FOR CONTROLLING CONTRACTORS * Health and Safety at Work Act 1974 * Management of Health and Safety at Work Regulations 1999 * Construction (Design and Management) Regulations 1994 (as amended, 2007) * Other relevant legislation * Contract law 4 MANAGING CONTRACTORS IN PRACTICE * Exercise - how well is it happening? * The objectives * Five step approach * Planning of the work * Selecting contractors * Handover prior to work commencement * During the work * Reviewing the work on completion 5 PLANNING THE WORK * Scope and extent * Risk assessment * Interface and other activities * Who controls what? * Contract arrangements 6 SELECTING THE RIGHT CONTRACTOR(S) * Locating contractor organisations * Selection the right contractors * Assessing contractor competence * Approved lists/frameworks * Tender process 7 PRE-WORK COMMENCEMENT * Co-ordination and co-operation * Exchange of information * Contractor risk assessments and method statements * Permits to work * Case study exercise 8 DURING CONTRACT WORK * Communication and liaison * Supervision and inspection of the work * Inspection and reporting procedures * Security issues * Facilities and access 9 REVIEWING WORK ON COMPLETION * Why, what and how? * Achieving continuous improvement in contractor performance 10 QUESTIONS, DISCUSSION AND REVIEW

Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: * Appreciate the role and importance of Finance within organisations * Be able to recognise and describe some of the common items and jargon used * Identify the elements of the Profit & Loss and the Balance Sheet * Understand cashflow * Make better decisions * Manage budgets 1 INTRODUCTION * Expectations * Terminology * Key financial principles * Accruals * Consistency * Prudence * Going concern 2 THE THREE MAIN FINANCIAL STATEMENTS * Profit & Loss account * Income * Cost of sales * Gross profit * Administrative expenses ('overheads') * Net profit/(loss) for the financial year (the 'bottom line') * P&L format * Balance Sheet * Terminology * Fixed Assets * Current Assets * Current Liabilities * Long-term Liabilities * Capital * B/S format * Cashflow Statement * Financial and management information systems 3 BUDGETS AND FORECASTS * Why budget? * Types of budget - incremental or zero-based * Budgeting for costs - fixed and variable * Budgeting for income * An eight point plan for budgeting for your department * Case study: Small Brother Ltd * Problems and solutions 4 ACCRUALS * Accruals - what and why? * Prepayments 5 OPEN FORUM