1871 Courses in Nottingham

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

In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales. One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer. By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer. By the end of this course, participants will be able to: Understand the power of a positive customer experience in developing sales opportunities Recognise and develop a sales opportunity when it arises Engage with customers and develop rapport and trust Use verbal and non-verbal communication skills and pick up on signals Ask powerful questions - and listen to the answers Create 'magic moments' for the customer Turn a complaint into an opportunity Know when to ask for referrals and testimonials Pass on leads to the relevant people 1 Introduction Aims and objectives Beliefs about sales 2 Building rapport First impressions Short cuts to rapport Finding common interests 3 Selling or serving? Managing emotions and behaviour - Transactional Analysis Moments of truth - creating 'magic moments' Speed sells - the follow-up 4 Meetings Planning a successful meeting Pre-meeting connection and assistance Sales meeting failure reasons Right v wrong mindset 5 Communication - verbal and non-verbal The 3 Vs - Visual, Verbal, Vocal Picking up on signals 7 power questions Questioning techniques LISTEN - 3 types of listening skills 6 Influencing 6 levels of influence Framing to change perspectives Turning complaints into opportunities 7 Referrals The power of referrals How and when to ask for a referral 5 steps from rapport to referral 8 Presentation and pitching (optional session) Basic presentation structure and delivery Creating powerful impressions Creating a 60-second pitch The elevator 10-second pitch - answering 'What do you do?' Sales presentations Emotion v Intellect - how to engage Using visuals

REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.

Belonging & Connection

Lorry Loader Training The aim of the Lorry Loader Training or Clamshell Bucket Courses is to provide the candidate with the basic knowledge and practical skills involved in operating a Lorry Loader ( HIAB ) or clamshell bucket courses, and on successful completion of the practical test, you will be issued with the NPORS Identity card with or without the CSCS logo. Discounts are available for multiple bookings NPORS/CSCS Lorry loader Experienced Worker Test or Training can only be delivered on our customer’s sites nationwide, Therefore reducing downtime and disruption of works to our clients. Experienced operator – NPORS Lorry Loader Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Lorry Loader Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Lorry Loader Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Lorry Loader Test is for operators who have received some form of training in the past or alternatively has been operating the Lorry Loader for several years. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. Discounts are available for multiple bookings There are two parts to the lorry loader test, a theory section comprised of 25 questions and a practical session. Lorry Loader Training Course: Safely Operating Mobile Crane Vehicles 1. Introduction to Lorry Loaders Overview of lorry loader types and configurations Understanding the components and controls of a lorry loader Different applications and lifting capacities of lorry loaders 2. Lorry Loader Safety Procedures Importance of safety in lorry loader operation Pre-operational checks and inspections Understanding load charts and load capacities Personal protective equipment (PPE) requirements Emergency procedures: shutdown, lockout/tagout, and evacuation protocols 3. Lorry Loader Operation Basics Starting, stopping, and controlling the lorry loader, include emergency stops Familiarisation with lorry loader controls: boom, remote, and outriggers Manoeuvring the lorry loader on different terrain types: roads, construction sites, etc. Lifting and lowering loads safely and accurately 4. Load Handling Techniques Proper assessment of loads: weight, size, and stability Positioning the lorry loader for efficient loading and unloading Securing loads with proper rigging techniques: slings, chains, and hooks Stacking and de-stacking loads safely and efficiently Using other professionals to complete the work. Slinger signaller to direct the load 5. Site Safety and Hazard Awareness Identifying potential hazards in the workplace Working safely around pedestrians, other vehicles, and obstacles Recognising environmental hazards: overhead obstructions, power lines, etc. Understanding site-specific safety rules and regulations 6. Maintenance and Inspections Importance of regular maintenance for lorry loader performance and reliability Daily, pre-shift, and post-shift inspection procedures Lubrication points and maintenance schedules Identifying and reporting mechanical issues and wear parts replacement 7. Practical Hands-On Training Practical exercises in lorry loader operation under supervision Manoeuvring through obstacle courses and confined spaces Load handling exercises: lifting, positioning, and placing loads Emergency response drills: simulated scenarios to test response and decision-making skills 8. Assessment and Certification Written examination to assess theoretical knowledge Practical assessment of lorry loader operation skills Certification upon successful completion of the course A lorry loader training course, by Vally Plant Training provides participants with the essential knowledge, skills, and confidence to operate lorry loaders safely and efficiently in various work environments. By covering topics such as safety procedures, operation techniques, load handling, site awareness, maintenance practices, and practical hands-on training, participants can enhance their proficiency and contribute to a safer and more productive workplace. Whether you’re a novice operator or an experienced professional, investing in lorry loader training is essential for ensuring compliance, reducing risks, and maximising productivity in lifting operations. Lorry Loader Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of lorry loader and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built HIAB practical training area to simulate an actual working environment. Our Lorry Loader or clamshell bucket courses and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS LORRY LOADER Tester to your site nationwide, to reduce the amount of time away from work More courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. Frequently Asked Questions 1. What is the aim of the Lorry Loader Training course? • The course aims to provide candidates with the basic knowledge and practical skills involved in operating a Lorry Loader (HIAB) or clamshell bucket. Successful completion of the practical test will result in receiving the NPORS Identity card with or without the CSCS logo. 2. What does the Lorry Loader training course cover? • The course covers various aspects, including: o Types and configurations of lorry loaders o Safety procedures and pre-operational checks o Operation basics, including controls and manoeuvring o Load handling techniques o Site safety and hazard awareness o Maintenance and inspection procedures o Practical hands-on training and assessments 3. What is the duration of the Lorry Loader Training course? • For experienced operators, the course is a 1-day test, accommodating up to 4 candidates. For novice operators, it is a 2-day training session, accommodating up to 3 candidates. 4. Where is the training conducted? • Training can be conducted at the client’s site nationwide, which helps reduce downtime and disruption to work. The training centre is located near the M5 junction 9 in Tewkesbury, with a purpose-built HIAB practical training area. 5. What are the certification options available? • There are two certification options: o NPORS traditional card (valid for 5 years) o NPORS card with CSCS logo (initial RED trained operator card valid for 2 years, upgradable to BLUE competent operator card upon completing relevant NVQ) For those looking for a “NPORS Lorry Loader Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

The CIEH Introductory Certificate in Occupational Health and Safety provides an awareness of key health and safety issues, and the part that staff should play in keeping themselves and others free from harm at work. This course will give you a basic background in, and understanding of, general health and safety practices and the control measures required to reduce risks in the workplace.

REFERENCE CODE 500/7826/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who remove and install fascias, soffits, and bargeboards in the domestic market. The standards cover the most important aspects of the job. This qualification is at Level 2, although some qualifications may have units at different levels, and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job. Candidates for this qualification will primarily be: Working on customer’s premises, removing and installing fascias, soffits and bargeboards Candidates could have jobs entitled: FSB Fitter or FSB Installer

Successful account management requires time and investment to achieve high levels of customer satisfaction and develop new business opportunities. Ensuring you are equipped with the right tools to approach every customer interaction in a structured way will help you have productive relationships with your clients. Whether you're new to account management or experienced in business development and looking to expand your skillset, understanding how you can maximise customer relationships will be key to your success. We have developed this programme to be practical, fun and interactive. Participants will have the opportunity to learn and practice a number of key skills that will see successful results, and are encouraged to bring real life examples to the course so that learning can be translated to real world scenarios. This course will help participants: Learn how to plan growth and increase revenue from existing accounts Develop skills to build and develop essential relationships to increase value and visibility Learn how best to create loyalty and customer satisfaction Identify how to set account targets and development plan for building contacts and cross-selling Develop persuasion and influencing skills to better define needs and develop opportunities Learn how to add value at all stages; plus gaining competitive advantage Develop an up-selling, cross-selling strategy 1 Performance metrics for account management Introduction to the PROFIT account management model Using practical tools to measure account performance and success Planning your account strategy - red flags and green lights 2 Relationships for account management How to build and manage key relationships Producing a 'relationship matrix' Developing a coach or advocate 3 Setting objectives for your account Developing an upselling cross-selling strategy Setting jointly agreed goals, objectives and business plans Planning session 4 Feedback and Retention - building loyal and satisfied customers How to monitor and track your customer's satisfaction Building a personalised satisfaction matrix Customer service review meetings 5 Influence Getting your message and strategy across to C-level contacts Being able to better develop a business partnership within an accountes 6 Teamwork and time management Working with others to achieve your account goals Managing and working with a virtual team Managing your time and accounts effectively 7 Gaining commitment and closing the sale Knowing when to close for commitment How to ask for commitment professionally and effectively Key negotiation skills around the closing process - getting to 'yes' Checklist of closing and negotiation skills Practice session

In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Exploiting the opportunity The world of digital media means there are lots of opportunities to appear online, on radio or on TV, as an expert or commentator and gain invaluable exposure for your business and organisation. You may meet journalists at industry events or be contacted for a comment on an issue. You may also need media training because you have to protect your business’ reputation by reacting proactively if you become involved in a news story. Media training will help you handle interviews with journalists, content creators and other media professionals. You need to communicate positively and effectively and make sure your message reaches the audience. It means speaking consistently, and with style and confidence. You’ll also need to know how to handle challenging questions and make sure you positively manage your reputation. Contemporary Media Training Our media training is interactive, engaging and importantly, carried out by experienced journalist trainers. Our team has worked at the highest levels of journalism and broadcasting and will give you an invaluable insight into how to maximise the opportunity of a media appearance. We will take you through the background of what journalists want and need, and give you a clear understanding of how to prepare and deliver your messages and ideas. We will then carry out a number of media style interviews which our technical team will record and playback so you can see and hear yourself. We will then support you with practical, inclusive and useful feedback for you to put into practice for the next interview. We provide copies of all your recordings and useful notes after the training. Locations that suit you We deliver training at our facilities in Birmingham or London or at your location, bringing our technical equipment and cameras with us. You can have a half day training session for up to 4 people or a full day training for a larger group. We also deliver training online for small groups which can be useful when teams are spread around the country. Expert Journalist Trainers We pride ourselves on two things at Coherent Comms – delivering contemporary media training and our supportive inclusive feedback. We know there are lots of media training companies out there but our clients tell us they work with us because we listen. We don’t tell you what training you need or hark back to the old days. We take on board your communication needs and deliver bespoke training. Our associates are working in digital communications, carrying out interviews for news online sites and our contacts are producing digital content for a 21st century audience. We’ll talk to you about TV and radio but we understand the wider media landscape and how to navigate it. And we’re really proud of our feedback – we want to take you from good to great and believe confidence building with tips and ideas that will work for you is the best way to develop your skills. We will help you design the course you want All our media training is bespoke and designed to exactly suit your needs. We have lots of ideas of how it might work but we want to hear from you and what you want! So get in touch with our friendly team by phone on 0754 533 4269 or fill in our contact form and we will get back to you. We’d love to hear how you hope to improve your media and communication skills.

REFERENCE CODE 600/8370/0 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in carrying out insulation or associated treatments to buildings; this could be on internal or external surfaces or structures. The qualification is designed to ensure that there is a high degree of flexibility within the units available that will allow employees from companies of all sizes and specialisms equal opportunity to complete. All work completed must be done in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The standards cover the most important aspects of the job. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job.