1715 Courses in Bradford

The Level 4 Award in Immediate Life Support (RQF) is ideal for a wide range of healthcare professionals. This includes doctors, dental professionals, medical students, nurses, midwives, and physiotherapists who need an ILS qualification for their registration with regulatory bodies like the GMC, GDC, NMC, and HCPC. It's also perfect for those looking to advance in their careers or needing an ILS certification for new job opportunities.

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

As a qualified crystal healer, I can come to your home and provide a 1hr crystal healing session.   We can work on any areas you may be aware of that require some attention. Or I can do a full body scan and assessment, free up an unbalanced energy flow within the body and bring everything back into alignment.   I can also free the body from any negative energies and restore positive balance and harmony within. These sessions are a fantastic way to relieve stress and promote healing. For more information or booking enquiries, please contact me here.

REFERENCE CODE 603/4678/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This is a work-based learning qualification for those involved in cavity wall surveys/inspections and/or clearance. The qualification has been developed at the request of and in partnership with OSCAR OSNITE https://oscaronsite.co.uk The OSCAR and this qualification are recognised by a number of UKAS Certification bodies, industry bodies, Local Authorities and industry stakeholders. Prior to registering on this qualification, individuals must be registered with OSCAR. The clearance pathway enables individuals to carry out the extraction of cavity wall insulation to create a clear cavity that can be reinsulated or insulated if the system has been used to remove debris only. Candidates must also prove knowledge and competence to create a clear cavity to be able to facilitate External Rendering and External Wall Insulation complying with current Building Regulations. All work must be completed following safe working practices, relevant legislation, and comply with contract information and the allocated timescales. The surveyor/inspection pathway requires candidates to demonstrate the skills and knowledge required to interpret information to be able to carry out a Cavity Clearance survey in accordance with the job specifications, following safe working practices and within the allocated time. The Surveyor must also understand how to communicate with others to ensure work is carried out effectively. This pathway includes identifying and selecting the correct quality of equipment, additionally candidates must understand how to calculate quantity, area and wastage. To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 3 mandatory units and 2 pathways. Candidates must complete the mandatory units and one or both of the pathways. The minimum credit value of this qualification is 24 credits. There is also an entirely optional additional unit, if achieved this will appear on the qualification certificate but does not count towards the minimum credit value of the qualification. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 240 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 84. Mandatory Units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Handling and Storing Resources in the Workplace 2 5 Pathway 1 Cavity Wall Clearance Cavity wall clearance in the workplace CWC1 Pathway 2 – Cavity Extraction Specialist Surveyor/Inspector Surveying/Inspection of Cavity wall clearance in the workplace Summary of the: GQA NVQ LEVEL 2 CERTIFICATE IN CAVITY WALL EXTRACTION OCCUPATIONS SICW1 Additional Unit Erecting and Dismantling Access/Working Platforms in the Workplace Achieving the combination of Mandatory units and the correct choice of Optional credits will mean the qualification has been completed and GQA will provide the qualification title. Where a candidate has completed additional credits, the qualification will list these as “additional credits”, in cases where the candidate has not completed the full qualification and will not go on to do so, a Certificate of credit can be issued for the credits achieved. Assessment guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

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

Official workshops for West-End shows and bespoke masterclasses tailored to any show.

Are you an EDI Officer, HR Specialist, Leader or Manager? Or the nominated EDI champion for your team? Maybe you've been given the EDI portfolio on behalf of your Board or department? Or if you're aiming to make a difference via your diverse staff network or union, all change-makers are welcome!

REFERENCE CODE 603/5285/1 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This is a work-based learning qualification for those involved in laying floorcoverings in a Construction related working environment. Although many of the skills and knowledge across floorcovering occupations are generic, not all those employed to fit floorcoverings will be fitting the same product. The group of optional units will allow specialisms of timber based, textile and resilient floorcoverings. What is required from candidates? To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 9 mandatory units and a group of optional units. The minimum credit value of this qualification is 127 credits. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 1,270 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 543 Mandatory units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Moving, Handling and Storing Resources in the Workplace Surface preparation to receive floorcoverings in the workplace Setting out for laying floorcoverings in the workplace Preparing and fitting underlays for floorcoverings in the workplace Develop customer relationships Assessing and preparing background surfaces for floor-covering in the workplace Assessing and evaluating conditions for floorcoverings in the workplace Optional Units (Minimum of 18 credits) Installing timber–based floorcoverings in the workplace Summary of the: GQA NVQ LEVEL 2 DIPLOMA IN FLOORCOVERING OCCUPATIONS (CONSTRUCTION) Installing textile floorcoverings in the workplace Installing resilient floorcoverings in the workplace Types of evidence: Evidence of knowledge is required. Evidence of knowledge through performance can contribute and if applicable should be demonstrated by completing projects and reports, by responding to questions or through Professional/Guided Discussions. Quantity of evidence: Evidence should show that you can meet the requirements of the units consistently over an appropriate period of time. Potential sources of evidence: Suggested sources of evidence are shown above, these can be supplemented by physical or documentary evidence, e.g.: Accident book/reporting system Notes and memos Safety record Telephone/e-mail records Training record Customer and colleague feedback Audio evidence Records of equipment and materials Witness testimonies Work records Photographic/ video evidence Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

This course explores Autism and the current body of thinking and knowledge around Autistic Spectrum Disorders. This enables learners to consider how to adapt their practice with useful strategies to better support an individual with autism.

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online