1926 Courses in Coventry

leadership management training course MBTI personality profiling

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 principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/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

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

A thorough account of the UK and European legal framework and its requirements as regards managing environmental performance. This course will help staff to understand: The framework of UK and European legislation and its enforcement The principal features of the legislation as they apply to your organisation's activity/product/service The benefit of having an Environmental Management System such as ISO 14001 How their own actions and decisions can either expose or protect the organisation in relation to its legal obligations 1 Introduction and objectives 2 Introduction to environmental law and enforcement Sources of law (European and UK) Structure and enforcement Key legislation 3 Integrated Pollution Prevention and Control (IPPC) and Local Air Pollution and Control (LAPC) Pollution and Prevention Control Act 1999 EC Directives on PPC The meaning of BAT Transitional provisions Fit and proper persons Control of emissions to air National Air Quality Strategy 4 Packaging and producer responsibilities Who, what and how The Producer Responsibility Obligations (Packaging Waste) Regulations Obligations and exemptions Registration Recycling and recovery obligations Records Duties of the Environment Agency Offences Developments 5 Waste management National Waste Strategy Waste minimisation (re-use/recycling) Waste definition Disposal and recovery Controlled waste management Hazardous waste management 6 Proposed Legislation and EC Directives EU Commission's waste and resources strategies Implementation of ELV (End of Life Vehicles) Directive WEEE (Waste Electrical and Electronic Equipment) Directive transposition into UK legislation Other producer responsibility initiatives Other proposals from the EU 7 Conclusion Open forum Summary Close

leadership management training course belbin team roles

Reliability Centred Maintenance (RCM) is commonly used to help establish safe minimum levels of maintenance, determine changes to operating procedures and help establish maintenance regimes and plans. Successful implementation can result in cost savings, machine uptime and improved risk management. But the devil's in the detail - how can you achieve these benefits and successfully implement RCM in your organisation? This programme will help you do just that. Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. To provide a better understanding of RCM, particularly: What, why, how and who? Opportunities and benefits Risks Cost effectiveness Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. 1 What is maintenance? Why maintain? Traditional maintenance methods Common current practices and trends 2 What is Reliability Centred Maintenance? Its history Its development Current usage Where can it be cost-effective? 3 How does it work? Basic features Key criteria Maintenance options Key outcomes 4 Making the business case and preparing the strategy Identifying and quantifying current risks Identifying and quantifying current costs Motivating decision-makers Identifying and empowering those who have to deliver the results Educating / gaining buy-in from interested parties 5 Implementation Identify business functions Prioritise functions Verify correct usage Identify failure modes Identify the consequences of failure Understand the failure process Specify the appropriate maintenance action(s) 6 Ongoing requirements Monitoring Recording Analysis Continuous re-evaluation 7 Open discussion Sharing experience and addressing specific issues of interest to participants Course review Close

Being a Mentor in the Early Years

Meetings are a fact of working life - both virtual and physical meetings. Recording the key points from meetings is critical to making sure that accurate information is captured, and action points are clearly identified and allocated. This virtual training session will support members of staff to develop their skills in recording the key points from meetings and discussions. This course will help participants: Describe the different levels of note taking and pick the appropriate style for the meeting Prepare to take minutes in the virtual and the physical environment Liaise and work in partnership with the meeting Chair Use a template to enable the capturing of key points Set up the room ready for the meeting Identify key points to record, versus what not to record Interrupt the meeting confidently to check key points Take neutral, accurate and concise records Produce a well-laid out set of minutes. 1 Introduction Objectives and overview Introductions and personal aims 2 An introduction to minutes Purpose and use Different levels of notetaking 3 Preparing to take minutes Identifying the purpose of the meeting Working with the Chair Tips and techniques to prepare effectively Case studies, review and discussion The physical environment: setting up for a meeting 4 Listening and recording Tips and techniques to make the process easier How to interrupt a meeting What to record; what to leave out Recording in short-form using playscript and bullet-points Listening neutrally Activity: Minuting a Meeting The tricky ones and how to overcome problems in the meeting 5 Preparing the minutes Producing a set of draft minutes Tips on grammar, punctuation and layout Stylistic variation Managing feedback from the Chair 6 Review Summary of key learning points Action planning

What are the aims of this course? Define mental health Identify and explain mental health facts and fiction Understand key legislation relating to mental health Explain how mental health care has evolved over time Identify common signs and symptoms Understand common mental health disorders Recognise common attitudes towards mental ill-health and the impacts these can have Explain the concept of parity of esteem Know how to support people and offer advice

To provide a fundamental understanding of building services in the context of: The working environment The success of the core business The health and safety of the occupants Operating cost and environmental impact The optimisation of cost and value Strategies for continuous improvement DAY ONE 1 Building services fundamentals The function of services in commercial buildings and their importance to the core businessElectrical servicesLightingHeatingVentilation and air conditioningLiftsWater Understanding IT and communication systems Practical exercises 2 The provision of comfort and safety Statutory requirementsHealth and safety legislationControl of contractorsRisk assessmentFire precautionsLegionella, sick building and other risks Business requirementsUnderstanding user requirementsMatching systems to business needs Practical exercises 3 Getting the design right What the FM needs to know about design and its procurementSuccessful space planningRelationship between services, space planning and designGetting the brief rightSupplier selection and management Practical exercises DAY TWO 4 Operation and maintenance Why maintain?Maintenance contractsInput and output specificationsResource optionsContracts - principal elementsTendering - key stepsSelection criteriaOperational criteriaMaintenance trends Performance-based service provisionInput and output specificationsKPIs and thresholdsRisk containmentValue-add opportunitiesPerformance contract strategy Practical exercises 5 Contingency planning Being ready for the unexpected Identifying and reducing riskInternal risksExternal risksIdentifying threats at your site Managing riskProtective systemsOccupier obligationsFire managementTesting Practical exercises 6 Commissioning services systems Physical commissioning Common problems Typical costs Commissioning stages Continuous commissioning Energy efficiency and the scope for environmental improvement Practical exercises 7 Satisfying the occupants Obtaining and responding to feedbackWhen to get feedbackWhyHowWhat to do with it Practical exercises 8 'Air time' Sharing experience and addressing specific issues of interest to participants Course review Close