1284 Courses in Liverpool

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

Nigel Reed, The Dog Guardian is hosting a series of seminars revealing his easy-to-follow method for a happy and well-behaved dog.

Challenging behaviour is causing increasing concern today as many individuals have increasing levels of stress and uncertainty in their lives. Understanding the causes of challenging behaviour is the first step towards finding ways to support individuals and manage their behaviour.

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

Are you requiring additional training to support your or your teams skills but can't see what you need in our advertised training courses? Then get in touch to design training/teambuilding specific to you or your team. How does it work? A free 30 minute consultation to discuss what you would like to achieve from a bespoke training course. A written proposal of what training may look like along with costings is emailed to you within 3 days of the initial consultation. If the proposal is agreed, then a date and time is agreed with both parties. Trainings can be delivered on a one to one basis, or with small - large groups. Recent bespoke training have been delivered covering topics such asCommunicationCustomer serviceTime ManagementDelegationWhat does professionalism look like? Prices start from £75.00. Contact us directly to organise bespoke training.

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

The Sales Accelerator programme is a fresh approach to improving business development productivity. It focuses on identifying and using a series of business productivity metrics in order to build a clear action plan for improving sales results - typically within 90 days. The metrics are grouped under three headings: The basic principle is that a small improvement in each area can lead to a significant increase in sales results and productivity. And the object of the programme is to show how best to achieve that. The programme therefore looks at each of these three areas in turn, spending a day on each. Suitable for any and all businesses and all levels of experience and expertise, this is a remarkably practical and hands-on programme. During the workshop, participants discuss, review and apply many proven sales and marketing techniques and personal selling ideas. The goal is to generate and commit to changes and actions that can lead to a 10-30% increase in the next three to six months. There's also a consultancy option, rather than the workshop-based programme. See below for details. Day one - Activity Key objective This first module introduces the Sales Accelerator model. The goal here is to show participants how to increase their pro-active activity levels by around 10%. It covers all aspects of creating new business opportunities, from existing customers and non-customers alike, and is linked to personal activity improvement goals. Main elements Improve the productivity, accuracy and effectiveness of your business approach by using new and unique models and techniques. Different methods of creating and generating new business opportunities in the short, medium and long term. This includes sourcing new business, up-selling, cross-selling, warm calling and gaining referrals. Using organised persistence to track and build new customer revenue. Managing your sales time effectively. Key learning points Sales productivity - understand the dynamics of increasing the combination of activity levels, deal value and conversion rate of proposals/quotations to orders and implement an improvement plan. Sales goal setting: setting business development objectives for quantity and quality - plus tips and tricks of top performers. Maintain a peak activity level, on a consistent basis using 'organised persistence' and structured business development tracking methodology. How to prioritise opportunities and manage your time when sourcing new business. Identify potential new customers - and particularly the decision-makers and influencers - with greater accuracy. Make outbound business or appointment calls with improved confidence, control and results. Day two - Value Key objective To be able to better anticipate, identify, create, and develop business opportunities using a customer / client-focused communication-based business model and consultative skills. Main elements How to develop sales more effectively from new and existing customers; and managing the first appointment with a new customer. Use structured and assertive drawing-out skills to identify, develop and formalise business opportunities and to gain commitment. How to better position your company and your products and services against your main competitors. Create and deliver persuasive business messages based on specific need areas, criteria and value. Key learning points Advanced consultative selling - use a variety of structured and advanced questioning techniques to confidently and efficiently uncover opportunities, need areas and business criteria - confidently and efficiently. Involve the customer/client at all times, and to a far greater degree, and keep better control of business development process. Value message - differentiate your solutions clearly and accurately with customer/client-matched value statements. Presenting the right USPs, features and benefits and making them relevant and real to the customer. Qualification and reading buying signals. Day three (held around four weeks after the first module) - Conversion Key objective This module looks at how to improve the final qualification, progression and conversion of opportunities in your sales pipeline. Also includes price negotiation, overcoming objections and obstacles to gaining agreement. The module begins with a learning review, sharing participants' experiences over the last four weeks in applying the new techniques and skills acquired during the first two modules. This is an opportunity to revisit particularly challenging areas as well as to share and celebrate successes. Main elements Structuring and preparing for negotiating a deal and knowing when and how to move into the 'end-game' mode. Anticipate and answer customer objections and questions more confidently. Build more credibility and proof into your business process to reduce 'buyer's remorse' and speed-up decision-making. Being more assertive and developing better instincts and strategic thinking in progressing quotations and proposals. Key learning points Smart ways to position price, emphasise value and be a strong player without being the cheapest. Becoming more assertive in closing deals, and the importance of organised follow-up on the telephone. Qualify pipeline opportunities with more accuracy, using a proven check-list. Use an 'option generator' to simplify complex proposals, increase business value and close business faster. Writing more effective sales proposal documents and quotations. How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns. Practical methods of asking for agreement and closing a sale

Conflict within a workplace can appear in many forms, from personality conflicts between employees to employee and supervisor issues. This course will equip you with the knowledge of conflict management strategies and the practical skills to take steps to help to resolve situations of conflict.

Instructor training enables companies to have their own AITT Forklift Instructor. On completion they are able to instruct and examine operators on company premises. Also it could be an opportunity for an individual to embark upon a rewarding career as a recognised AITT instructor. The course complies with the approved code of practice issued by the Health & Safety Executive. We offer the AITT Instructor training course at our training centre in Warrington, Cheshire. We use all the best tools and equipment to assist trainee development. Our Instructor’s Mike Hammett and Stephen McCann have a lot of experience in this course, both have very good success rates and offer alot of after care too! Once an Instructor has passed their AITT Instructor training course they can always come back and receive professional advice. We always go the extra mile! AITT Accredited Novice Course: The Instructor training course caters for candidates seeking to become an AITT Registered Instructor. Previous fork lift experience is strongly recommended and candidates must have a current counterbalance certificate dated within 36 months prior to the course start date. Refresher courses are available prior to the instructor course extending the duration by one day to 11 days. Objectives: On successful completion of the course the candidate will be qualified to teach and train on all Industrial Counterbalance and Reach trucks for which they are certificated to use as operators. Target Group: The employer should carefully select the correct person for the job as an instructor. They should be literate and numerate with good presentation skills. The AITT recommend that candidates have a minimum of 12 months operating experience before attending the course. During the course candidates will be progressively assessed in all key areas. Candidates therefore must have a good knowledge of each subject and are provided with some excellent materials to assist them on completion of the course. AITT Instructor Training Course Duration: 3 or 5 days for Re-qualification or Re-Registration courses. 5 days for Assimilation Courses. 10-12 days for the Novice AITT instructor training course. Contents: Principles of instruction. Instructional techniques. HASAWA 1974/PUWER 1998/LOLER 1998/L117. Setting up courses. Administering the tests etc. All original documentation supplied by examining body and HSE. Prices are available on request and should you require any further information please do not hesitate to contact us. We also offer In-House Instructor training to suit companies needs and these are of five day durations, please contact for further details. Please feel free to download our Course Syllabus’s below and decide which course best meets your needs. See Mike at work demonstrating a lesson of De-stacking from High Level. In-House Courses: These courses are aimed at companies wishing to use their own Instructors to train staff. IN-HOUSE BASIC INSTRUCTOR COURSE PDF AITT Instructor Training Courses: On completion of these courses candidates will be registered as an AITT Instructor and be able to train on anything they are currently qualified to operate. Courses vary depending on experience and current qualifications so please have a look at the following courses to see which suits best. More information is available at www.aitt.co.uk.

This course aims to provide a more in depth understanding of confidentiality and record keeping. Providing information on the importance of accurate and true record keeping.