300 Courses in Coventry

This is a one-day training event to help you: Develop your awareness of mental health issues in the workplace Enable you to act in a timely and constructive way to manage mental health issues that arise in the workplace Enable you to promote and maintain good mental health in your working environment It covers: Mental health statistical overview; most prevalent mental health problems, contributing factors, effects on productivity and the costs of mental ill-health Signs and symptoms of prevalent mental health conditions; 3 key indicators for all mental health problems Stigma; what it is and how it affects people Mental health legal and statistical overview: facts & figures, most prevalent mental health problems, aspects of the law, policy and procedural issues and guidelines for best practice Pro-active and constructive principles and strategies to manage mental health issues, to support colleagues who may be vulnerable to mental ill-health, and promote mental wellbeing This workshop will give you: Awareness of the key indications of mental ill-health Recognition of the prevalence and effects of stigma Knowledge of the wider picture; legal context Greater understanding and confidence to act constructively to support individuals who are vulnerable to mental ill-health The ability to take steps to actively promote mental-well-being in the workplace

We all tend to have challenges throughout our lives that cause varying levels of pressure. It is healthy and essential that people experience such challenges because up to a certain point an increase in pressure improves performance and quality of life. Too much pressure can be harmful and affect our health and wellbeing. This participative half-day workshop will explore the causes and impact of stress and provide an opportunity to learn some new ideas and techniques to cope with it. Practical tasks and exercises will be used to promote discussion and participants will be encouraged to share their own experiences and approaches. By the end of the workshop participants will be able to: Understand the causes and symptoms of stress and how to spot them Become more aware of personal habitual behaviours and approaches that get in the way of dealing with stress productively Learn ideas and approaches that help you to cope with the thoughts, emotions and physical feelings that happen in stressful and difficult situations Review and evaluate learning and have an action plan to take back and put into practice at work 1 Welcome, introductions and objectives Breaking the ice 2 Stress Its sources and effects on you Defining stress, its signs and symptoms 3 Exploring your 'default' habits Their consequences in stressful situations 4 Dealing with perception Strategies and approaches for coping with stress 5 Setting goals with positive outcomes Review and evaluation of learning Action planning

This course aims to raise awareness about the triggers, signs and symptoms, and preventive measures to better manage and support people living with asthma.

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

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: Appreciate why errors occur Understand how stress and other factors can affect focus and accuracy Know how to improve accuracy and reduce errors when handling text and data Be able to proof-read text and number-based documents more accurately 1 The importance of accuracy The impact of mistakes Why accuracy is so important Main reasons why errors occur 2 Attentiveness theory The 'capacity' and 'bottleneck filter' models Selective attention Chunking - big picture / little picture 3 Preparing for accuracy Working styles - how they affect detail-orientation Identifying and minimising the impact of stress on concentration 4 Practical strategies How to improve accuracy and reduce errors when inputting text Managing interruptions and distractions Proofing text and numbers

This very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: Identify the purpose of writing their documents - to themselves and to their readers Recognise and meet the needs of their readers Plan documents systematically and improve the layout, flow and structure Express the content more clearly, concisely and correctly Adapt the tone and style of writing to the circumstances Proof-read and edit work effectively, using formal marks and techniques Improve visual layout, format and appearance 1 Course objectives Welcome and Introductions The problems now - group discussion 2 Writing better business documents What points to highlight / exclude Starting off Introductions Conclusions Executive summaries 3 Rules and standards George Orwell's famous maxim Why write? - clarifying your aims and objectives A seven-step method for better preparation The three-stage process for writing well Grouping information for your reader 4 Proof-reading and editing The difference between proof-reading and editing Proof-reading methods and strategies Proof-reading marks and techniques Training your eye for detail Knowing what to look for 5 Effective editing Grammar and English standards Words - usage and spelling Sentences - units of thought Paragraphs - themes Punctuation - spotting and correcting common errors Say what you mean - active v passive language 6 How's your English? Grammar quizzes and punctuation test Spotting spelling errors Rephrasing jargons and clichés Common error's and mistakes 7 Document layout House style Use of white space Fonts and effects 8 One-to-one workshops These are practical sessions with one-to-one consultation with colleagues and the trainer They are held at key points to consolidate the learning from different sessions 9 Course summary Summary of key points Action plans

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

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

It's a fact of life that costs generally increase and as a result prices must go up too. Implementing an increase without losing customers is challenging. Talking about a price increase with customers never makes for an easy conversation. Your customers will generally decide whether to accept the increase based upon value, as well as the hassle cost of switching and going elsewhere. Even the most experienced salesperson who has implemented price increases before will be fighting back the nerves when faced with the task of 'selling' the increase. In this flexible programme, we will support your internal preparations at whichever stage you and your colleagues are at. From making the decision to increase prices, right through to those on the frontline already dealing with any push-back. This programme will help participants: Understand the business case for increasing prices Take steps to research the market Consider their customers' motivations Use the six principles of influence Identify and adapt for different personality styles Assess their level of trust with customers Build rapport rapidly with their customers and prospects 1 Raising prices - keys to success Understanding the business case Researching the market Assessing the value of your offering 2 Understanding your customer base Assessing your key accounts What is your 'target' customer range? Creating consistency in pricing approach 3 Planning the increase Timing your implementation Communication strategy Elements of a good price increase letter 4 Developing influencing skills The Trust Equation The six principles of influence Discovering your customer's buying decisions 5 Emotional intelligence and price increases The part emotion plays Developing strategies for keeping calm Handling your customer's responses 6 Understanding different customer styles Discover your own style Recognising behaviour traits in others Adapting your approach to their style 7 Preparing for customer contact Preparing for specific customers Anticipating their response Dealing with challenging customers 8 Following through Maintaining a consistent approach Resisting requests for discounts Confirming the increase in writing

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security