1868 Courses in Bradford

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

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.

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation. This programme provides staff with the basic skills they need to sell. This course will help participants: Profile customers Research and identify potential new customers Use the consultative sales process Build effective rapport with customers Identify customer needs through effective questioning and listening Position products and services effectively Close the sale or gain commitment to further action Manage their customer portfolio to maximise sales 1 Introduction Aims and objectives of the training Personal introductions and objectives Self-assessment of existing sales skills Overview of content 2 Knowing your customers Who are your customers, and what do they want from you? What are your strengths, compared to your competitors? Who are your new potential customers? How do you communicate with new customers? What do you need to know about your customers before you start to sell? Making the initial approach Planning your pipeline - keeping the customers coming 3 The four-step sales process Overview of the consultative sales process Key benefits of using the consultative sales process Focusing on behaviours not targets The behaviours of a good salesperson Common pitfalls and mistakes Personal strengths and weaknesses 4 Building rapport First impressions - Mehrabian theory of communication Short cuts to building rapport Looking out for clues as to how the customer is thinking Looping back to keep the conversation flowing Acknowledging past communication Dealing with emotions such as anger Setting the agenda to keep control Getting past gatekeepers 5 Questioning and listening How to ask open questions to uncover information Left brain questions When closed question can be useful What stops us listening? The four levels of listening How to develop your listening skills 6 Presenting products and services to customers When to present Using benefits not features Making it personal Using reciprocity The tendency towards the middle Using consistency 7 Gaining commitment Testing the water Dealing with objections using ACLEO Asking for the business Getting referrals Ending with a personalised close Following-up 8 Managing your customer pipeline Spotting opportunities for cross-sales Managing your portfolio Maximising sales proactively Review meetings Customer satisfaction measures and surveys Mystery shopping 9 Putting it all together Skills practice Personal learning summary and action plans

REFERENCE CODE 603/2369/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who have responsibility for sorting, storing and removing non-hazardous wastes related to Construction work. Examples of the types of non-hazardous wastes covered by this qualification include rubble, timber, metal, cardboard or paper, plastics, fabrics and glass. All work must be completed following Industry recognized 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 routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete.

REFERENCE CODE 603/4460/X COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The Level 2 NVQ Diploma in Specialist Concrete Occupations (Construction) -Concrete drilling and sawing qualification has been developed for achievement in a real workplace environment which means you need to be employed to undertake this qualification. This qualification enables you, the learner, to demonstrate and recognise your skills, knowledge and understanding and to demonstrate your competence in a real workplace environment so you can work in Specialist Concrete Occupations. Not all individuals will carry out exactly the same tasks so there are 3 pathways, these allow achievement in Concrete Drilling, Concrete Sawing and Concrete Drilling & Sawing. You will be assessed against a set of performance and knowledge statements which have been derived from National Occupational Standards for your occupational area. You will be assessed by an occupationally competent and qualified assessor whose job is to work with you and help you complete your qualification. The qualification consists of 4 mandatory units with a total credit value of 20 credits, in addition to these candidates must achieve the required credits from the chosen pathway.

Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care

The Health and Safety (First Aid) Regulations 1981 Emergency First Aid at Work

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

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.