1781 Courses in Bristol

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

REFERENCE CODE 603/2369/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed those who carry out activities in the Construction Industry working with Glass Reinforced Plastics (GRP) products. The qualification has a core group of 5 mandatory units that cover the generic areas including Health and Safety, transport and storage of tools, materials and equipment, checking and confirming the job specification and communication skills. The qualification also has a group of optional units that cover preparation, positioning, testing, installation and assembly. The qualification, along with the required separate proof of Health and Safety knowledge will give candidates a route to the relevant CSCS card required for site access.

REFERENCE CODE 603/7248/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The aim of this qualification is to confirm that the candidate has the skills and knowledge to install Curtain Wall systems on site. It is not expected that all curtain wall installers will carry out identical tasks as there are many variations in system types and installation environments, so the qualification had been developed to allow as wide an uptake as possible. All of the work needs to be completed in accordance with relevant legislation, regulations and health and safety guidelines

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.

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.

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.

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

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.

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